What bank statement formats are supported?
ExpensePlus works with all bank accounts!
The most efficient way to reconcile your account transactions is to log in to your online banking and export statements in .csv or .xls format. (These file formats are spreadsheet files compatible with Excel and are a common export format used by most banks. Note: your bank may also allow you to export as .PDF, however, this is not suitable for data import purposes).
All banks should offer the .csv or .xls option to download transactions from online banking, so if you think this is not available for you, we'd recommend that you contact your bank to ask.
Manual Entry - (not recommended)
ExpensePlus does offer an option to manually upload transactions within ExpensePlus, however, this is far more time-consuming and has an increased risk of human error (due to the nature of manual data entry).
If you need to use the 'Manual Upload' function, you can find it within the Bank Reconciliation screen by clicking 'Upload Transactions' and then choosing the 'Upload Manually' option at the bottom of the pop-up.
Upload from .csv or .xls (online banking export)
There is no need to modify the bank statement you download from your bank (and indeed we recommend that you don't!). The first time you upload a statement into ExpensePlus, you will be asked to select the column format for that statement which then is remembered for that bank account.
On the Bank Reconciliation screen, select 'Upload Transactions'
Select the file you wish to upload (1) by clicking 'Choose file' and finding it in the file browser, then select 'Upload File' (2).
Select the number of header rows (this should include any blank lines, other lines, and header lines), select the column headers (selecting any columns not needed as 'not required'), and check the date format of the first transaction in the spreadsheet is displaying correctly.
To upload a statement you will need to import a date column, a description column, and either a combined Paid In/Out column (with positive and negative figures), or the two separated columns 'Paid In' and 'Paid Out'. You will also need to check that the date format is correct depending on whether your bank account exports using British (DD/MM/YYY) or American (MM/DD/YYYY) formatting.
Important Note: the column selected as 'Description' should be the column that is the 'most descriptive' i.e. it displays the supplier/payee/donor name
Note: ExpensePlus doesn't require you to select a 'Balance' column, and this is because it calculates the balance based on the opening bank balance set for this account, and the transactions that have been uploaded. This calculated balance is displayed when you upload a statement into ExpensePlus and it should match your actual bank statement balance. If it doesn't match, it means you have done something incorrectly e.g. you've not set your opening balance correctly, or double imported one or more transactions, or missed transactions from your import. You will need to fix any such issue right away before continuing. To find out more about this, please read this help guide article.
Example
The transaction data in this file begins on row 2, so the number of header rows should be set as '1'
(had the transaction data begun on row 8, the number of header rows would need to be set as '7')
Column A = Date, Column B = Description, Column C = Paid In amount, Column D = Paid Out amount
If your bank displays a combined paid in/out column, (where columns C&D are combined with positive and negative figures) then you can select this option within ExpensePlus.