TL;DR — Quick Summary

Fix Aspel COI year-end closing errors: unbalanced journals, result accounts not zeroing, opening balances mismatch, and DIOT generation for annual declaration.

The year-end accounting close in Aspel COI is the most critical process of the fiscal year. An error at this point carries inconsistencies into all future periods, prevents correct generation of electronic accounting files for SAT, and complicates the annual income tax return. This article covers the most common year-end closing errors in Aspel COI, their causes, and a complete step-by-step solution.

The Error

The most frequent error messages when running Processes > Year-End Close in Aspel COI are:

  • “Error al realizar cierre de ejercicio. Existen pólizas descuadradas en el periodo.”
  • “No es posible realizar el cierre. El periodo [month] no ha sido cerrado.”
  • “La cuenta de traspaso de resultados no está configurada.”
  • “Existen pólizas en estado provisional. Convierta a definitivas antes del cierre.”
  • “La balanza de comprobación no cuadra. Verifique los movimientos del ejercicio.”
  • “Error al generar saldos iniciales. Verifique la naturaleza de las cuentas.”

These errors typically appear in December or January when the accountant attempts to close the prior fiscal year. They also occur in retroactive closes of forgotten prior years.

Root Cause

Aspel COI runs a validation chain before allowing the close. The process fails if any of these conditions are detected:

Unbalanced journal entries. Every journal entry must have debits equal to credits. Even a one-cent discrepancy blocks the monthly close for that period and, by extension, the annual close.

Unclosed monthly periods. The annual close is cumulative: COI requires all twelve months to be individually closed first. Any open month — because of adjustment entries added after a partial close — prevents the annual close.

Provisional entries not converted. COI allows capturing entries in provisional mode (for budgets or estimates). If provisional entries still exist at year-end, the system rejects them because they must not affect the definitive accounting records.

Result transfer account not configured. The year-end close automatically cancels income accounts (credit nature) and expense accounts (debit nature), transferring the net result to the capital account assigned in Configuration > Year-End Close Parameters. If this account is missing or any result account has the wrong nature in the chart of accounts, the process fails or produces wrong balances.

Chart of accounts missing SAT grouping codes. Accounts without SAT grouping codes complete the internal close but generate errors when producing the XML trial balance for SAT electronic accounting.

Step-by-Step Solution

Follow these steps in order. Never skip the initial backup.

Step 1: Create a full backup

Go to Utilities > Backup and generate a complete backup of the company. Save the file outside the server (USB, separate network drive, or cloud). This backup is your recovery point if anything goes wrong.

Step 2: Verify the trial balance

Run Reports > Trial Balance for all periods of the fiscal year. Confirm that the debit column equals the credit column. If there is a discrepancy, identify the period with the imbalance and locate the specific journal entry with the error.

To find unbalanced entries, go to Journal Entries > Query, filter by the affected period, and sort by the debit/credit difference. Correct each entry until the trial balance is perfectly balanced.

Step 3: Convert provisional entries to final

In Journal Entries > Query, filter by type “Provisional.” If any exist, open them and change to final, or delete them if they do not correspond to a real transaction. Repeat for all months of the fiscal year.

Step 4: Close all 12 monthly periods

Go to Processes > Monthly Close. Select January and execute the close. If the system accepts the month, continue with February, March, and so on through December. If any month shows an error, return to Step 2 and correct the entries for that specific month before retrying.

Step 5: Validate the chart of accounts and SAT grouping codes

Go to Chart of Accounts > Query. Verify that:

  • Income accounts (typically series 4) have Credit nature.
  • Expense accounts (series 5 and 6) have Debit nature.
  • Balance-sheet accounts have the correct nature.
  • All parent accounts have an assigned SAT Grouping Code.

Use Utilities > SAT Grouping Validation to identify accounts without a code and assign the appropriate code from SAT’s Annex 24.

Step 6: Configure the result transfer account

Go to Configuration > Year-End Close Parameters. Confirm that the capital account to receive the profit or loss is assigned (commonly account 3030 “Profit or Loss for the Period”). This account must have credit nature within the equity section.

Step 7: Execute the year-end close

With all requirements met, go to Processes > Year-End Close. Select the year to close. The system displays a summary with total income, expenses, and net result. Verify these numbers match your tax return before confirming.

Click OK and do not interrupt the process. Do not close COI, restart the computer, or restart the server while the close is running. The process automatically generates the closing entry (cancels income and expenses) and the opening entry for the new year.

Step 8: Verify opening balances in the new fiscal year

After completion, COI positions itself in the new year. Verify:

  • Income accounts (4xxx) have zero balance.
  • Expense accounts (5-6xxx) have zero balance.
  • The profit/loss account (3030) reflects the result of the closed year.
  • Opening balances for assets, liabilities, and equity exactly match the closing balances of the closed year.

If any balance-sheet account is missing an opening balance, or if the opening balance differs from the prior year’s closing balance, there is a close error that must be corrected before proceeding.

Alternative Solution

If the close error persists after following all steps:

  1. Go to Utilities > File Verification and Recovery. Select the company and run a full verification. This detects and repairs database inconsistencies.
  2. If COI detects and repairs errors, retry the process from Step 4.
  3. If the problem continues, restore the backup from Step 1 and contact Aspel technical support with the exact error message and the verification log.

Generating the DIOT and Annual Declaration

Once the year is correctly closed, generate the SAT files:

  • DIOT (Informative Return of Operations with Third Parties): Go to Reports > DIOT. Select the annual period. COI pulls data from journal entries that have supplier RFC codes assigned. Verify all VAT-paid suppliers have correct RFC codes in the supplier catalog.
  • Trial Balance XML for Electronic Accounting: Go to Reports > Electronic Accounting. Generate the December and full-year trial balance. Accounts without SAT grouping codes will trigger warnings that must be resolved.
  • Chart of Accounts XML: Generate the updated catalog after the close to ensure SAT has the current version with correct grouping codes.

Prevention

To avoid errors in future year-end closes:

  • Close each monthly period at the end of the month. Do not accumulate open months: arriving at December with six unclosed months multiplies the risk of errors.
  • Enforce a final-entries-only policy. Convert provisional entries before the last day of the month.
  • Reconcile the trial balance with the bank and SAT each quarter. Finding a discrepancy in March is far less costly than discovering it in December.
  • Validate SAT grouping codes quarterly. Every time you add a new account, assign the grouping code immediately.
  • Enable automated daily backup. Configure Utilities > Automatic Backup so COI backs up when exiting the application.

Aspel COI: Error Generating XML for SAT Electronic Accounting. If the close succeeds but the XML shows errors, the causes are usually accounts without grouping codes or invalid third-party RFC numbers. See: Aspel COI Error Generating XML for SAT Electronic Accounting.

Aspel COI: Connection Error 503 EAccessViolation. If you cannot open the company before the close, resolve the connection issue first. See: Aspel COI Error 503 de Conexión EAccessViolation.

Aspel COI: Error Compacting and Repairing the Database. If file verification finds severe errors, compacting and repairing the database may be required. See: Aspel COI Error al Compactar y Reparar Base de Datos.

Summary

  • Year-end close in Aspel COI requires: balanced trial balance, 12 months closed, no provisional entries, result transfer account configured, and SAT grouping codes assigned.
  • Always create a full backup before starting the close.
  • Unbalanced journal entries are the number-one cause of failure: find and fix all of them before Step 4.
  • If result accounts do not zero out, verify the transfer account configuration in Configuration > Year-End Close Parameters.
  • Opening balances in the new year must exactly match the closing balances of the closed year.
  • After a successful close, generate the DIOT and electronic accounting XML files for SAT before the filing deadline.