• This issue applies to you if you use Period End Date for the Accounting Date in your Payroll Settings (File, Company Settings, PR Settings, Accounting Date).
• The Accounting Date specified in PR Settings affects the accounting date on the check transactions sent to Cash Management.
• Because of the way the report calculates the two balances, when the accounting date usage specified in PR Settings is set to Period End Date, the bank reconciliation report may have a difference between the two balances.
• The Period End Date is the Accounting Date on the transactions sent to 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.

Example:

You cut payroll checks dated January 2015 and your Period End Date is December 2014. On the 12/31/2014 bank reconciliation report, the Adjusted Bank Balance includes the checks (because the accounting date on the checks is December 2014), but the Register Balance as of Statement Date does not include these checks (because the reference date/check date is January 2015. There is a difference between the two balances on the report.

The transactions affecting the balances on the Bank Reconciliation have a Reference Date greater than the last reconciled date.

To identify these transactions, print the Open Worksheet report as follows:

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. Verify that AND is selected as the connector above the Field list then click OK twice.
13. Click Print Preview to view the report.

If a transaction appears on the report, note the transaction information.

The Reference Date is the Check Date on the payroll check. If this date is correct, choose Option A.

If the Reference Date (Check Date) is incorrect, choose Option B.

Option A:
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.

Option B
The Check Date is the Reference Date on the transaction. If this date is wrong, correct the Reference Date for this transaction in the Application of Origin as follows:

1. Unreconcile the transaction if necessary. Refer to article ID 22176 "How do I change the reconciled status of a transaction in Cash Management?"
   • Note: Make note the Cleared Date before you unreconcile the transaction.
2. Correct the transactions in Payroll. Refer to article ID 25178 "How do I change the check date on a Payroll check?"
3. If you unreconciled the transaction in step 1, reconcile the transaction again using the same Cleared Date you noted. Refer to article ID 22176 "How do I change the reconciled status of a transaction in Cash Management?"