There are several cases where you may want to manually import transactions into Ambrook. For example:
If you’ve made a few business transactions on a personal account, but don’t want to bring those personal transactions onto your Ledger,
If you don’t use online banking for your bank account or credit card,
If your bank isn’t supported by Plaid, our third party bank connection provider, or
You notice discrepancies through reconciliation.
Use our transaction import feature to avoid missing any relevant transactions.
How to Import Transactions
First, you’ll need to log into your online banking portal and export a CSV (comma separated file) of your transactions. Once you have a file downloaded, log into Ambrook and navigate to your Ledger.
Hover over the + New button and select Import Transactions.
Drag and drop the CSV file from your downloads into the “Upload CSV File” box.
Select the account associated with the transactions you are uploading. If the account doesn’t exist in Ambrook, you can create a new custom account. For details on how to do this, see our article here. Once the file appears, click Next.
Match the columns in your CSV to the relevant fields in Ambrook so the system can recognize the data properly. You can go back and review the full dataset at any time. Click Next after selecting the column names.
Select the transactions you wish to import. If you’re only missing a few transactions, you can select just those one by one. Alternatively, you can select or deselect an entire day of transactions by clicking on the checkbox next to each date.
Finally, give your import a name to help you recognize it later and include any notes that will provide you and your team with helpful context down the line.
After importing the transactions, you can always go back and view or remove uploads by going to Settings → Import. The three dots next to each import will allow you to remove the import or view the original file in case you need it.