Fixing Bank Reconciliation Differences Caused by Backdated Journals

Introduction

A backdated journal entry can change historical balances and cause a bank account reconciliation to no longer match. This guide explains the common ways to correct the discrepancy and what to review before making any accounting changes.

Issue description

This issue occurs when a journal entry is posted with a date that falls in a previously reconciled period. As a result, the bank reconciliation balance may differ from the expected balance, and the account may appear out of sync with your accounting records.

Signs

• The bank reconciliation no longer matches the statement balance.
• A previously reconciled period now shows a discrepancy.
• The balance changed after a journal entry was posted with an earlier date.
• Accounting reports show an unexpected difference in the bank account.

Basic troubleshooting steps

Before making any correction, confirm the source of the discrepancy and review the impact on your financial records.

1. Identify the backdated journal entry that caused the discrepancy.
2. Confirm whether the journal entry was posted to a reconciled bank account.
3. Check whether the entry should remain in the current period or be moved.
4. Review the effect on bank reconciliation, general ledger, and reporting balances.
5. Coordinate with your accounting team before making any reversal or unreconciliation changes.

Advanced troubleshooting steps

Option 1: Create a new journal entry to offset the incorrect amount

If the backdated journal entry should remain in place, you can create a new journal entry that reverses or offsets the incorrect amount. This helps restore the expected balance without altering the original posting.

1. Open the journal entry module in your accounting system.
2. Create a new journal entry for the same bank account and amount.
3. Use the appropriate offsetting debit and credit accounts.
4. Set the date according to your accounting policy and reconciliation period.
5. Save the entry and recheck the bank reconciliation balance.

Option 2: Unreconcile the affected journal entry from the backend

If the journal entry was reconciled incorrectly, you may need to unreconcile it from the backend so the balance can be adjusted. This action should only be performed by an authorized user or support team member with the appropriate access.

1. Locate the affected journal entry in the backend or accounting administration area.
2. Remove the reconciliation status from the entry.
3. Verify that the bank balance updates as expected.
4. Reconcile the account again if needed.
5. Document the change for audit and internal review purposes.

Contact support

If you are unsure which correction method to use, contact your accounting team or [salesorder's helpdesk] support. Include the journal entry date, amount, affected account, and reconciliation period so the issue can be reviewed quickly.

Disclaimer

Accounting corrections can affect financial statements, audit trails, and closed periods. Always confirm the impact of any journal entry reversal or unreconciliation action with your finance or accounting team before proceeding.