Why can't I import the balance column from my bank statement?
Top Tip: Click here to read this help guide article on importing your bank statements into ExpensePlus.
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. It deliberately doesn't import the balance since this is automatically calculated in the system, which provides the opportunity to check whether all transactions have been imported correctly. The user completing the import should double-check that the system 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.
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.