Bank Reconciliation Error in Aspel Banco

Bank reconciliation is a critical accounting process in Mexico. It verifies that entries in your accounting system (Aspel Banco) match the bank statement.

Prerequisites

  • Aspel Banco version 4.0 or later.
  • Bank statement for the period (Excel, CSV, or PDF).

Common Causes and Solutions

1. Incorrect Starting Balance

Ensure that the starting balance in Aspel equals the prior month’s ending balance per the bank statement.

2. Duplicate Entries

Generate a Movement Detail report, sort by reference and amount, and delete exact duplicates.

3. Unrecorded Bank Fees/Interest

During reconciliation, look for items marked “Unreconciled - At Bank.” These are bank charges. Add them to Aspel and classify them (e.g., account 5300 for financial expenses).

4. Items in Transit (Uncashed Checks)

These are normal differences. If a check is outstanding for more than 30 days, consider cancelling it.

5. Import Format Error

Ensure the file has Date, Reference, Description, and Amount columns. Use “Preview” mode to verify column mapping.