What Is Bank Statement Reconciliation & How Do I Use It?
When you first navigate to the Reconcile Bank Statement page via the Accounting tab, you will see several options.
Account
Closing Date
Starting Balance
Ending Balance
Once the initial settings have been created, click the Generate button. That will calculate the difference between the starting and ending balance and pull any transactions that are older than the Closing date entered.
The overall goal with reconciliation is to get the difference between the starting and ending balances in ISP to be $0. That indicates all transactions affecting the actual bank statement have been identified. When working on a bank reconciliation in ISP, the system will not allow a reconciliation to be applied until the Difference shows $0. Until that happens, you can click Continue Later to save the work you have done up until that point.
While it’s not best practices, in certain situations 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 won’t prevent you from finishing your reconciliation.
As you go through the reconciliation, the transactions selected from the list of Outstanding Transactions will add or subtract from the difference between the starting and ending balances, as indicated in the Difference column. If you need to edit any of the initial settings, such as changing the starting balance or even the financial account, click the Edit Statement Details button in the Statement Summary section.
If you receive a message stating your starting balance doesn’t match what was previously marked as cleared, your next best step is to 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.