This article describes three reports that are designed to work with the Bank Reconciliation feature:
Bank Rec In-Progress
Bank Reconcile History
Bank Balance Exception
They are located at Reporting > Bank Reports > Bank Analytics.
Each report is described below.
Note: We recommend that after posting a bank reconciliation, you run either the Bank Rec In-Progress report or the Bank Reconcile History report in detail mode and save the results. If there is a change to the G/L later, and you are trouble-shooting problems with the bank rec, you can compare the current report results with the version of the report made on the day you posted the reconciliation.
Bank Rec In-Progress Report
This is a report version of what appears on the Bank Reconciliation screen. It shows all the uncleared transactions that affect the bank account for the selected period as well as a list of items that have been cleared.
Go to Reporting > Bank Reports > Bank Analytics. On the left side of the screen, select Bank Rec In-Progress.
Select a Bank and enter the Closing Day.
Click Display. The report includes summary information, a list of all the cleared items (checks, deposits, and other items), and a list of uncleared items.
Lower half of screen:
Bank Reconcile History Report
The Bank Reconcile History report displays posted bank reconciliations. To view a current, un-posted bank reconciliation, use the Bank Reconciliation In Progress report described above.
Go to Reporting > Bank Reports > Bank Analytics. On the left side of the screen, select Bank Reconcile History.
Select a Bank and enter a date range.
Click Display.
Lower half of screen:
Note: If there are any changes to the GL after the reconciliation is performed (if somebody posts in a prior period, for example), the report might be out of balance.
The Bank Balance Exception Report
The Bank Balance Exception Report displays transactions that cause the bank reconciliation to be out of balance—for example, receipts that have not been deposited. If the bank reconciliation does not balance, use this report for troubleshooting.
Go to Reporting > Bank Reports > Bank Analytics. On the left side of the screen, select Bank Balance Exception.
Select a Bank and a Closing Day.
Click Display.
The report finds the following exceptions:
A receipt that does not have a deposit record.
A transaction where the transaction date is not in the same month as the post month.
A receipt paying a charge that uses a cash account instead of an income account on a detail line.
Note: This report would not be best to use when looking for online payments that haven not been deposited.