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 create a balance sheet account for the bank you're uploading (if it doesn't already exist on Ambrook). Head to Balances-->New Balance Sheet Account and select "Bank" or the matching type of account. Set the opening balance to the date you plan to bring your books over to Ambrook - this is typically the beginning of the year.
Next, 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. Alternatively, you can go to Settings-->Import and click "New".
Drag and drop the CSV file from your downloads into the “Upload CSV File” box, or select a file from your computer that you've downloaded from the bank.
Select the account associated with the transactions you are uploading. If the account doesn’t exist in Ambrook, you can create a new 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.
You can also specify import preferences:
Only Amount means there’s a single, signed amount column
Separate Debit/Credit Amounts means there is a signed Debit amount and a signed Credit amount column
Combined Debit/Credit means there’s an unsigned amount column and a column which specifies “debit” or “credit"
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.