| The Bank Statement Ending Balance on my Bank Reconciliation report is incorrect in Cash Management (item was reconciled that did not clear the bank) |
Cause | A transaction was reconciled that never actually cleared the bank.
To identify the entry:
- Use Cash Management Inquiry, Bank Register.
- Select the Register file then click OK.
- Double-click on the bank account.
- Add columns for the Cleared Date and Statement Date.
- Add a condition for Reconciled Status Equal to R.
- TIP: You may want to add additional conditions to date range on a specific statement period you want to verify. For example, if you want to confirm what is reconciled for the October statement period, you would add conditions for Statement Date Greater than or equal to 10/1/2020 AND Statement Date Less than or equal to 10/31/2020.
- Review the transactions and compare to the bank statements to confirm the items that actually cleared the bank.
|
|