The Adjusted Bank Balance does not match the Register Balance as of Statement Date (PR Accounting date set to Period End Date)
Description
Cause

You use Period End Date for the Accounting Date in File, Company Settings, PR Settings, Accounting Date.

This setting sends the Period End Date as the Accounting Date on the transactions for Cash Management. The Adjusted Bank Balance on the bank reconciliation report uses the Accounting Date when calculating the balance.

The actual Check Date is the Reference Date on the transactions sent to Cash Management. The Register Balance as of Statement Date uses the Reference Date to calculate the balance.

The transactions affecting the balances on the Bank Reconciliation have a Reference Date greater than the last reconciled date. Because of the date differences and the way the report calculates the two balances, the report may have a difference between the two balances.

 

Example

  1. You cut payroll checks dated January 2025 and your Period End Date is December 2024
  2. You run the bank reconciliation report for 12/31/2024
  3. The Adjusted Bank Balance includes the checks because the accounting date is December 2024
  4. The Register Balance as of Statement Date doesn’t include these checks because the reference date/check date is January 2025
  5. This creates a difference between the two balances on the report
Resolution

Identify transactions

To identify these transactions, print the Open Worksheet report.

  1. In Cash Management select Reports, Worksheets, Open Worksheet.
  2. Click OK.
  3. Click Conditions, and then click Change.
  4. Under Field, select Reference Date.
  5. Under Operator, select Greater Than.
  6. Under Value, click List Items and then click Index.
  7. Select CM, Bank Account and click OK.
  8. Select Last Reconciled Date and click OK.
  9. Click OK, then click Add.
  10. Under Field, select Application of Origin.
  11. Under Operator, select Equal To.
  12. Under Value, type PR.
  13. Select AND as the connector above the Field list then click OK twice.
  14. Click Print Preview to view the report.
  15. If a transaction appears on the report, note the transaction information.
  16. The Reference Date is the Check Date on the payroll check.
    • If this date is correct, no changes are needed
    • If the Reference Date (Check Date) is incorrect, change the Reference Date following the steps below

No changes needed

No action is required. The report is correct when you complete a bank reconciliation with a statement date that is beyond the reference date.

Use the Adjusted Bank Balance to balance with General Ledger, remembering to account for future voids.

Change the Reference Date

Correct the Reference Date for this transaction in Payroll.

  1. Unreconcile the entry in Cash Management, if needed. Make note of the Cleared Date before you unreconcile the transaction.
  2. Correct the transactions in Payroll.
  3. If you unreconciled the transaction in step 1, reconcile the transaction again using the same Cleared Date you noted.
Steps to duplicate
Related Solutions