Product Details
Downloads/Installations
Using the Program
Technical Support
Related Resources
Article ID: 8683
The Bank Reconciliation Report Shows a Difference in the Bank Statement Reconciliation Section (top part of report)
Problem Description:
You cannot reconcile your bank account and the Bank Reconciliation Report shows a difference in the Bank Statement Reconciliation section (top part of report). The top part of the Bank Reconciliation Report shows a difference for any of the following reasons:
- You enter an incorrect Opening Balance on the Bank Reconciliation - Select Account window
- You did not enter all prior items or you mistakenly enter an item that does not belong in the Bank Reconciliation - Prior Items window
- You mark an item as cleared that does not appear on the bank statement
- You do not mark an item cleared that appears on the bank statement
- You did not enter an item in the program that appears on your bank statement
- The bank made an error when they cashed a check or deposited a receipt
Suggested Actions:
- Troubleshooting Steps if this is the first Bank Reconciliation for the account
- Troubleshooting Steps if this is not the first Bank Reconciliation for the account
Troubleshooting Steps if this is the first Bank Reconciliation for the account
Take the following steps to reconcile a difference on the top part of the Bank Reconciliation Report if this is your first reconciliation for the account:
- Compare the opening balance that appears on your bank statement to the Opening Balance that appears on the Bank Reconciliation Report, and if they do not match, enter the correct balance in the Opening Balance box on the Bank Reconciliation - Select Account window.
NOTE: You must close the Bank Reconciliation window prior to reopening the Bank Reconciliation tool. Continue troubleshooting if you enter the correct opening balances and still have a difference on the top part of the report. - Ensure that you enter all of your Prior Items in the Bank Reconciliation - Prior Items window.
- Click Deselect all in the Bank Reconciliation window.
- Mark all items that clear the bank, and continue troubleshooting if you still have a difference.
- Verify that the value of each item that appears on bank statement matches the value of the corresponding entry and contact your financial institution to discuss possible bank errors.
- Enter any bank errors that you verify with your bank.
[Top]
Troubleshooting Steps if this is not the first Bank Reconciliation for the account
Take the following steps to reconcile a difference on the top part of the Bank Reconciliation Report if this is not your first reconciliation for the account:
- Compare the Actual Statement Balance that appears on the prior period's Bank Reconciliation Report to the Opening Balance that appears on the current period's report, and if there is a difference, make a backup of your data, Run a Verify Data Integrity, and contact Customer Support to reset the bank balances.
NOTE: Continue troubleshooting if you do not need to reset the bank balances. - Click Deselect all in the Bank Reconciliation window.
- Mark all items that clear the bank, and continue troubleshooting if you still have a difference.
- Locate any items that appear on your bank statement that you do not see in the program and enter the items if you did not enter them previously.
NOTE: Run your General Bank or Trust Bank Journal for all bank accounts to ensure that you did not enter the missing item for the wrong account. - Verify that the value of each item that appears on bank statement matches the value of their corresponding program entries and contact your financial institution to discuss possible bank errors.
- Enter any bank errors that you verify with your bank.
[Top]
Related Topics:
Bank Reconciliation - Overview
Bank Reconciliation Troubleshooting