Bank Reconciliation Troubleshooting

Why doesn't the bank reconciliation match my general ledger bank account balance?

Example:

At month end (ONLY) the Tourplan bank reconciliation Closing Balance should be checked to verify it matches the General Ledger account balance for the same period.

Troubleshooting:

If there is a discrepancy, the following should be checked as a probable cause for the imbalance.

  • A 'Tagged' transaction has a transaction date beyond the reconciliation period, and therefore is not included in the general ledger account balance.

  • A transaction 'tagged' in a previous page has become 'un-tagged'. This will display in the list of open items.

  • On foreign currency accounts (only), a transaction has been entered against the general ledger bank account in a currency which is not a valid currency within the bank reconciliation setup.

  • Only payments, receipts and journals appear in the bank reconciliation.

Once the problem is identified contact your Tourplan local support office for assistance if required.