CONTPAQi Bancos: Fix Bank Statement Import and Reconciliation Errors

TL;DR — Quick Summary

Fix CONTPAQi Bancos bank statement import errors: configure bank layouts for BBVA, Banamex, Banorte, resolve duplicates and generate the reconciliation entry.

CONTPAQi Bancos is the most widely used treasury system in Mexico for managing bank accounts, issuing checks, and performing monthly bank reconciliation. The statement import and reconciliation journal entry process concentrates most user-reported errors: from CSV formats incompatible with the bank to a broken link with CONTPAQi Contabilidad. This guide covers every common error and its step-by-step fix.

The Error

The most common error messages in CONTPAQi Bancos during reconciliation are:

• “Error al importar el estado de cuenta” — appears when loading the bank CSV or OFX file.
• “No se encontraron movimientos para conciliar” — the file imported but no movements appear.
• “Error de conexión con la empresa” — CONTPAQi Bancos cannot communicate with the CONTPAQi Contabilidad database.
• “Error al generar póliza de conciliación” — accounting accounts are not correctly mapped.
• The reconciliation wizard freezes or crashes when processing statements with more than 1,000 movements.
• Movements showing different amounts after import due to decimal separator or currency conversion issues.
• Duplicate movements after re-importing the same bank statement.

Root Cause

Incompatible bank file formats

Each Mexican bank generates statements in a different format:

Bank	Available formats	Notes
BBVA	CSV (comma-separated), OFX	Columns: Date, Description, Reference, Debit, Credit, Balance
Banamex / Citi	CSV (pipe-separated), OFX	Includes movement type column
Banorte	CSV, TXT, OFX	CSV uses semicolons as separators
Santander	XLS/XLSX, OFX	Must save as CSV before importing
HSBC	CSV, OFX	Dates in DD/MM/YYYY or MM/DD/YYYY depending on settings

CONTPAQi expects columns in a specific order and with a specific separator as defined by the configured layout. If the bank file does not match that layout, the import fails.

Misaligned date range

When the period open in CONTPAQi (e.g., January 2026) does not match exactly the dates in the imported file, the system finds no movements within the expected range.

Broken link to CONTPAQi Contabilidad

The link between Bancos and Contabilidad depends on a network path to the accounting company. If the server was renamed, the IP changed, or the company folder was moved, the link breaks and the connection error appears.

Unmapped accounting accounts

To generate the reconciliation journal entry, each bank account in CONTPAQi Bancos must have its corresponding accounting account assigned from the Contabilidad chart of accounts. If the account does not exist or was deleted, journal entry generation fails.

Step-by-Step Solution

Step 1 — Configure the correct bank layout

1. In CONTPAQi Bancos, go to Bancos > Catálogos > Layouts de Importación.
2. If no layout exists for your bank, click Nuevo.
3. Configure the parameters for your bank:
   • Separator: comma, semicolon, pipe, or tab.
   • Date format: DD/MM/YYYY or YYYY-MM-DD.
   • Start row: first data row number (to skip header rows).
   • Debit / credit column: correct column number for each.
4. Use Probar Layout to validate against a sample of the real file.
5. Save the layout with the bank’s name for future reuse.

Step 2 — Import the bank statement

1. Download the statement from online banking in OFX format (preferred) or CSV for the exact month to reconcile.
2. In CONTPAQi Bancos go to Bancos > Importar Estado de Cuenta.
3. Select the correct bank account.
4. Choose the downloaded file and select the layout configured in step 1.
5. Verify that the period shown matches the open month in the system.
6. Click Importar and wait for all movements to load.

If the file has more than 1,000 movements and the wizard freezes, split the statement into two files (by fortnight) using Excel before importing.

Step 3 — Review differences and reconcile items

1. Go to Bancos > Conciliación Bancaria and select the month.
2. The screen shows three columns: Bank movements | System movements | Differences.
3. Movements with matching amounts and close dates reconcile automatically (green checkmark).
4. For movements not automatically reconciled:
   • Select the bank movement in the left column.
   • Find its counterpart in the system column.
   • Use Conciliar Manualmente to force the association.
5. For bank fees or interest not in the system: click Nuevo Movimiento and enter them directly from the reconciliation screen.

Step 4 — Repair the link to CONTPAQi Contabilidad

If “Error de conexión con la empresa” appears:

1. Go to Bancos > Configuración > Empresa Contable.
2. Click the browse button next to the company path.
3. Navigate to the folder where the CONTPAQi Contabilidad company is stored (typically C:\ContPAQi\Contabilidad\Empresas\CompanyName).
4. Select the .emp file and accept.
5. Test the connection with the Verificar Liga button.
6. If the company is on a network server, confirm the UNC path (\\server\path) is accessible from the machine running CONTPAQi Bancos.

Step 5 — Generate the reconciliation journal entry

1. Verify all items are reconciled (difference = $0.00).
2. Go to Bancos > Conciliación > Generar Póliza.
3. Select the journal entry type (Diario for fees and interest).
4. Review the description and date.
5. If an unmapped accounts error appears:
   • Go to Bancos > Catálogos > Cuentas Bancarias.
   • Open the bank account and in the Contabilidad tab assign the correct accounting account.
6. Accept to generate the entry. It will be sent automatically to CONTPAQi Contabilidad.

Alternative Solution

If the CSV import error persists, convert the file to OFX format using a tool such as OFX Convert or your bank’s portal if it offers that option. OFX is a financial standard that CONTPAQi reads without needing manual column mapping.

For Santander Excel (XLSX) statements, open the file in Excel, remove the bank header rows, and save as standard comma-separated CSV before importing.

Prevention

• Create one layout per bank the first time and save it — no need to reconfigure on each import.
• Always use OFX when your bank offers it — it is the most compatible format with CONTPAQi.
• Reconcile monthly without accumulating multiple months; the more months pile up, the harder it is to find differences.
• Do not re-import a statement without first deleting previously imported movements for the same period.
• Verify the Contabilidad link at the start of each monthly close before attempting to generate journal entries.
• For USD or foreign currency accounts, confirm the exchange rate for the day is entered in the currency catalog before importing.

Related Issues

Movements with different amounts after import The bank reports amounts with 2 decimal places but CONTPAQi interprets the decimal separator differently depending on Windows regional settings. Fix: in the import layout, configure the decimal separator used by the bank file.

Balance discrepancy between the reconciliation report and the bank If report totals do not match the actual bank statement, look for movements imported outside the month range (December dates in a January statement). Filter by date on the reconciliation screen to identify them.

Foreign currency accounts that do not reconcile correctly Foreign currency accounts require that each movement has the exchange rate for that day. If the rate is zero, CONTPAQi converts amounts incorrectly. Enter historical exchange rates in Bancos > Catálogos > Tipos de Cambio before reconciling.

Summary

• The “Error al importar el estado de cuenta” error is resolved by configuring the correct bank layout for each institution (BBVA, Banamex, Banorte, Santander, HSBC).
• “No se encontraron movimientos” indicates a date misalignment between the file and the open period.
• The company connection error is fixed by updating the path to the CONTPAQi Contabilidad company.
• Duplicate movements are prevented by deleting prior imports for the same period before re-importing.
• The reconciliation journal entry requires each bank account to have an assigned accounting account.
• For large files (more than 1,000 movements), split the statement into fortnightly files.

Related Articles

• CONTPAQi Bancos: Bank Reconciliation and Statement Error
• CONTPAQi AdminPAQ Report Generation Error
• CONTPAQi Comercial CFDI 4.0 Payment Complement Error