TL;DR — Quick Summary

Fix Aspel Banco bank reconciliation errors: wrong bank layout, duplicate movements, rounding differences, date format issues and multi-currency accounts.

Bank Reconciliation Errors in Aspel Banco

Bank reconciliation in Aspel Banco is one of the most critical steps of the monthly close for any Mexican company. However, users frequently encounter errors that prevent completing this process: from messages like “Error al importar layout bancario” to unexplained balance differences between what Aspel shows and what the bank reports.

This article covers all the most common errors, their root causes, and the exact steps to resolve them — including the specific quirks of each major Mexican bank.

The Error

The most common errors during bank reconciliation in Aspel Banco are:

  • “Error al importar layout bancario” — appears when importing the electronic bank statement and the file format does not match the configured layout.
  • “Error en formato de fecha” — occurs when the imported file contains a date format different from what the layout expects (e.g., MM/DD/YYYY instead of DD/MM/YYYY).
  • Irreconcilable balance difference — Aspel’s balance and the bank statement differ by cents or by exact amounts that cannot be easily identified.
  • Duplicate movements — after re-importing a statement, double the movements appear for the same period.
  • Already-reconciled items showing as pending — the reconciliation report marks previously reconciled entries as open.

Root Cause

Bank layouts not configured per institution

Each Mexican bank delivers electronic statements in different formats. BBVA exports semicolon-delimited CSV; Banamex (Citibanamex) offers TXT and OFX formats with different layouts depending on whether the account is corporate or personal banking; Santander uses CSV with Spanish-language headers; Banorte exports both native Excel and CSV. When the layout in Aspel does not match the bank’s current format (which can change without notice after online banking updates), the system cannot map columns correctly.

Date format mismatches

The “Error en formato de fecha” error occurs when the file contains dates in US format (MM/DD/YYYY) but the layout is configured for the Mexican format (DD/MM/YYYY), or vice versa. This is especially common with Banamex OFX exports, which have historically alternated between both formats.

Rounding and decimal precision

Mexican banks report amounts with two decimal places, but some online banking systems calculate internally with higher precision. The result can be a $0.01 or $0.02 difference that mathematically matches no transaction and blocks the reconciliation close.

Re-imports without prior cleanup

When re-importing a statement due to errors, if the movements from the previous import were not properly deleted, Aspel records all movements a second time, generating exact duplicates that inflate the system balance.

Step-by-Step Solution

Step 1: Verify and fix the bank layout

  1. Open Aspel Banco and go to Configuración > Layouts Bancarios.
  2. Select the relevant bank from the list.
  3. Download a recent sample file from your online banking (do not import it yet).
  4. Open the file in Excel or a text editor and compare the column structure against the layout defined in Aspel.
  5. Correct the column order, delimiter (comma, semicolon, tab) and date format in the layout.
  6. Save changes before attempting to import.

Bank reference: BBVA Empresas: semicolon-delimited CSV, date DD/MM/YYYY. Banamex Business: OFX or TXT — check date format on each export. Santander: CSV with first-row header, date DD/MM/YYYY. Banorte: native Excel or CSV, date DD/MM/YYYY.

Step 2: Resolve “Error en formato de fecha”

  1. Open the bank statement file in Excel.
  2. Identify the exact format of the date column (does the day or month come first?).
  3. In Aspel Banco, go to Configuración > Layouts Bancarios > [Bank Name] > Formato de Fecha.
  4. Change the value to match: DD/MM/YYYY or MM/DD/YYYY.
  5. Save and retry the import.

If the file mixes formats (a bank export error), open the file in Excel, select the date column, and use Data > Text to Columns to standardize the format before importing.

Step 3: Remove duplicate movements

  1. Go to Conciliación > Movimientos del Periodo.
  2. Sort the view by Date and then by Amount.
  3. Identify identical movement pairs (same date, same reference, same amount).
  4. Select the duplicate movement (the one from the second import) and click Delete.
  5. If there are many duplicates, cancel the current period, delete all imported movements for the affected date range, and re-import from scratch.

Step 4: Handle rounding differences

  1. Identify the exact amount of the difference (usually $0.01 or $0.02).
  2. Go to Movimientos > Nuevo Movimiento.
  3. Record a debit or credit for the exact difference amount.
  4. Enter “Rounding adjustment” as the description and assign it to financial expenses or exchange differences as appropriate.
  5. Manually reconcile this adjustment entry against its counterpart on the bank statement.

Alternative Solution: Manual Reconciliation Without Import

If the layout keeps failing after all adjustments, you can reconcile entirely manually:

  1. Go to Conciliación > Conciliación Manual.
  2. You will see two columns: Aspel movements on the left and a space to enter bank statement movements on the right.
  3. Manually enter each bank statement movement with its date, reference, and amount.
  4. Mark each matching pair as reconciled.

This method is more time-consuming but completely eliminates file format issues and is especially useful for credit card statements, which rarely have available layouts in Aspel.

Prevention

  • Always download statements in the same format. Configure your preferred export type in online banking and never change it. If BBVA offers both XLS and CSV, always choose the same one.
  • Never re-import without cleaning up first. If you need to re-import, delete all movements for the date range in Aspel before doing a new import.
  • Reconcile weekly, not monthly. Catching errors over 7 days of movements is much easier than over 30.
  • Record bank fees on the same day. Set a calendar reminder to enter bank fees in Aspel the same day they appear on the statement, preventing year-end differences.
  • Update the exchange rate before closing USD accounts. For multi-currency accounts, update the last-day-of-month rate before running reconciliation.

Report shows already-reconciled items as pending

This happens when the database is regenerated or compacted without a backup. Reconciliation marks are stored in a separate table and can be lost. Solution: go to Utilerías > Verificar Integridad de Conciliación (available in version 4.5 and later) or contact Aspel support to restore the reconciliation index.

Error reconciling credit card statements

Credit cards have a billing cycle cutoff date different from the calendar month. In Aspel Banco, configure the credit card account with its actual cutoff date (e.g., the 20th). This prevents end-of-cycle movements from appearing as unreconciled in the wrong month.

Aspel COI integration fails after reconciliation

If the automatic Banco-COI link generates the error “La cuenta contable no existe”, verify that bank accounts in Aspel Banco have their corresponding COI chart of accounts account assigned. Go to Bancos > Datos de la Cuenta > Cuenta Contable and assign the correct account (typically 1020 or whichever matches your chart of accounts).

Summary

  • Bank layout errors are fixed by adjusting the file format (delimiter, column order, date format) in Configuración > Layouts Bancarios.
  • Each Mexican bank (BBVA, Banamex, Santander, Banorte) uses a different format that can change after online banking updates.
  • Duplicate movements are caused by re-imports without prior cleanup — delete the affected range before re-importing.
  • Cent-level rounding differences are resolved with an adjustment entry classified under financial expenses.
  • Manual reconciliation is always a valid alternative when layouts fail or for credit card statements.
  • Integrate reconciled data with Aspel COI by verifying account mappings before running the link.