What Is Bank Statement Reconciliation & How Do I Use It?
The Reconciliation feature in ISP allows you to accurately keep track of your finances outside of ISP and ensure all transactions are financially accounted for and match your actual bank statement.
If it is your first time doing a reconciliation or you are starting a new one, you will see four bank statement fields:
- Account: The financial account to reconcile. Reconciliation is done on a financial account-by-financial account basis and is independent of the filers. Only transactions that are part of the specific financial account you select will appear.
- Closing Date: The ending date of the bank statement you are reconciling. Along with the financial account selected, only transactions equal to and older than this date will appear.
- Starting Balance: The starting balance of the bank statement for that month. If there was prior activity in the account that is not in ISP, that is factored into the number entered here.
- Ending Balance: The ending balance as indicated on the bank statement you are reconciling.
Once completed, click the Generate button to calculate the difference between the starting and ending balance and pull any transactions older than the Closing date entered.
On the new screen, the Statement Summary section will display the info you added, totals for Receipts and Disbursements, and the Difference between your previously entered Starting and Ending balances. As Outstanding Transactions are selected, the totals and Difference amount will automatically adjust. To adjust the information you previously entered, click the Edit Statement Details button.
The overall goal with reconciliation is to get the difference between the starting and ending balances to be $0. That indicates all transactions affecting the actual bank statement have been identified. The system will not allow a reconciliation to be applied until the Difference shows $0, at which point the Reconcile button will appear at the bottom of the screen. Until then, this button will not show.
If during this process you catch anything missing, click Continue Later at the bottom of the screen to save the work you’ve done up to that point, and leave the page to make corrections.
If your starting balance doesn’t match what was previously marked as cleared, review transactions that may have been edited since your last reconciliation. To view these transactions, click the Changed Reconciled Transactions Report link in the message.
If you have the Dropbox integration installed in your database, you’ll see the Dropbox icon in various spots when reconciling a bank statement. Use this folder to add attachments to the specific reconciliation you are working in, whether it’s a current reconciliation or you’re reviewing a previously completed reconciliation. Each reconciliation statement will have its own room for attachments specific to only that reconciliation statement.
Along with the Reconcile and Continue Later buttons at the bottom of the screen is a Past Reconciliations drop-up menu, which allows you to view past reconciliations, as well as reopen or undo the most recent reconciliation. This latter option is good for correcting previous reconciliation mistakes.
The Upload for AI button allows you to upload a bank statement to assist with the reconciliation process. This upload will check the box of the matching transaction in the list of transactions to reconcile, as well as automatically adjust the Difference total in the Statement Summary section at the top of the page. Please note that every bank is different. If you encounter issues with your bank statement and the AI upload process, please contact Support.
For financial accounts that have over 200 transactions that are yet to be reconciled and it has been over six months since the last dated reconciliation, you will see an option to Auto Reconcile all historical transactions. This option only appears when both criteria have been met.
How do I handle adding, editing, or deleting a transaction that had previously been reconciled?
Best practices are to undo reconciliations back to the relevant month, correct the transaction error, and redo the reconciliations going forward.
However, if you choose, you can include an old transaction in the current reconciliation. The reconciliation system only requires that the ending balance be $0. It will warn you if the starting balance doesn’t match but it will not prevent you from completing your reconciliation.
