If your General Ledger Cash Account is out of balance to your bank statement:
There are a few factors that can cause your General Ledger (GL) Cash Account to be out of balance to your Bank Statement. Please read the Blackbaud KnowHow blog post, General Ledger Cash Account Out of Balance to Statement During Bank Reconciliation
, to understand which transactions comprise your Bank Reconciliation and to see which factors could be causing your out of balance and how to find and correct the out of balance.*
*Note: We strongly encourage you to use the link in step 1. Learning which transactions comprise your Bank Reconciliation and learning which factors can cause you to be out of balance will help you resolve the present out of balance issue and will prevent you from having out of balance issues in the future.
**Note: You will need to know when you were last in balance or find a reliable starting point before you set out to find the out of balance culprit.
If your Bank Register is out of balance to your bank statement, you will need to run your bank register report and compare it to your statement. Follow the steps below to create a bank register report to be compared to your bank statement.
1. From any submodule, go to Reports>Bank Account Reports>Bank Register Report
2. Click New
3. On the General tab, select Detail for the Report Format
4. Select the bank account you are reconciling
5. Select <Specific range> in the Transaction date field. Leave the start date field blank and enter the statement ending date in the end date field
6. While still on the General tab, click the Filters button
7. Select General so that it is highlighted. Make sure there are no dates in the From or To columns
8. Select System so that it is highlighted. Make sure that all systems are marked
9. Select Transaction Type so that it is highlighted. Make sure all boxes are marked and that there is no text in the Start Number and End Number columns
10. Select Transaction Status so that it is highlighted. Make sure that everything except Reconciled is marked and that there is no text in the Start Date and End Date columns
11. Select Post Status so that it is highlighted. Make sure that everything is marked and that there is no text in the Start Date and End Date columns
12. Click OK
13. Click Preview
14. Compare all the transactions on this report to the statement you received from your financial institution. If transactions are on your report but not on the statement or vice versa, this is one reason, or possibly the entire reason, why you are out of balance. Also, note the status of each transaction on the Bank Register report when you are comparing it to your bank statement. If the status of a transaction is cleared, make sure that it is showing up on your bank statement. If the status of a transaction is outstanding, make sure that it is not showing up on your bank statement or mark it as cleared if it is showing up on your bank statement. If the status of a transaction is voided, make sure that it is not showing on your bank statement.