Why can't I import the balance column from my bank statement?
This article explains why your bank balance isn't imported to ExpensePlus when manually uploading bank statements.
In this article:
Bank statement upload
When you upload a .CSV or .XLS bank statement, ExpensePlus imports a date, description, and a 'Paid In' or 'Paid Out' value for each transaction.
For more information on manually uploading your bank statements in ExpensePlus, please see our Help Guide article How do I upload bank statement transactions?
ExpensePlus deliberately doesn't import the balance, since this is automatically calculated in the system. This provides the opportunity to check whether all transactions have been imported correctly.
The user completing the statement upload should double-check that the ExpensePlus total matches the closing balance of the statement (for the date imported), and where this is not the case, should reject the import and then explore where in the process a problem has occurred. Possible reasons for this are explored in this help guide article.
Running balance
ExpensePlus will still keep a running bank balance on the bank statement screen, as shown below:
To better understand the Bank Reconciliation module, please view the module overview video here.