Your portal can receive data feeds from your bank or financial institutions directly but may have some limitations as to historical data or not providing feeds for particular institutions. You may also be on a subscription that does not allow direct feeds.
In these cases, your portal may be missing needed transaction history. You are able to upload a CSV file of transactions, or add transactions manually one by one.
Option 1 -Manually (one by one)
Bank accounts (either manually added or via a data feed) must already be added to the Net worth area in order for you to be able to choose the account in the list.
- Visit the Cashflow area and click 'Tools'>'Add single transaction'.
- A pop-up window opens for you to enter details of the transactions.
Ensure each field is complete and the correct financial account is selected.
When done, click 'Save & Exit'
Option 2 - CSV upload (Bulk transactions)
If you have numerous transactions to add, you don’t have to add them one by one as this would be very time consuming. Instead, you can upload a CSV file to import bank account and/or credit card transactions to Cashflow in bulk.
You can download CSV files from most banks by logging into your bank account, selecting the account you want and downloading the transactions.
Because many banks will download the CSV files differently, you will need to adjust it to match (exactly) one of the three portal template options provided below.
NOTE: You must use one of the example templates provided below to format your data. You can copy and paste the appropriate template to add your own data It is vital that you follow the template as it appears and save it as a CSV file. Do not edit the headings or format of the templates as this will result in a failed upload.
Example template 1
Description | TransactionAmount | TransactionCredit | TransactionDebit | TransactionBaseType | TransactionDate |
EXAMPLE INCOME | 12.31 | LEAVE BLANK | 1/08/2020 | ||
EXAMPLE EXPENSE | -14.53 | 4/08/2020 |
Example template 2
Description | TransactionAmount | TransactionCredit | TransactionDebit | TransactionBaseType | TransactionDate |
Example Income | LEAVE BLANK | 12.31 | LEAVE BLANK | 1/08/2020 | |
Example Expense | 14.53 | 4/08/2020 |
Example template 3
Description | TransactionAmount | TransactionCredit | TransactionDebit | TransactionBaseType | TransactionDate |
EXAMPLE INCOME | 12.31 | LEAVE BLANK | CREDIT | 1/08/2020 | |
EXAMPLE EXPENSE | 14.53 | DEBIT | 4/08/2020 |
To import the CSV file for bulk upload of transactions:
-
Once you have formatted your data into one of the above mentioned templates and saved as a CSV file, within Cashflow click 'Tools'>'Bulk add transaction (CSV upload)'.
- The statement upload screen will open.
Select the account you want to import transactions for from the drop-down list. - Click 'Choose file' and select the CSV file you have prepared matching the download CSV template.
When done, click 'Upload'. -
The screen will refresh and confirm that your transactions have been added to the chosen account. The transactions will now appear in your Cash flow