TL;DR — Quick Summary

Aspel COI annual fiscal year close errors: unbalanced entries, missing closing journal entry, opening balances mismatch, and SAT trial balance issues.

If when trying to close the annual fiscal year in Aspel COI you see messages like “Error performing fiscal year close”, “Cannot close the fiscal year because there are pending journal entries”, or “Error generating the closing trial balance”, this guide explains every possible cause and how to resolve it step by step so you can complete the close and open the new fiscal year correctly.

The Error

Fiscal year close errors in Aspel COI appear at different points in the process:

  • When running Processes > Fiscal Year Close and receiving the message Error performing fiscal year close
  • When the system warns Cannot close the fiscal year because there are pending journal entries before the process even starts
  • After reviewing the new fiscal year and finding that opening balances do not match the closing balances of the previous year
  • During generation of the SAT trial balance XML for electronic accounting, with the message Error generating the closing trial balance
  • When the system freezes for several minutes with no visible progress on databases with many years of data

In all of these cases the fiscal year remains open or closes incorrectly, which means income and expense accounts are not zeroed out, net income is not transferred to equity, and the electronic accounting records will contain inconsistencies for the SAT.

Root Cause

The fiscal year close in Aspel COI fails because of one or more of the following root causes:

Journal entries in draft status (not yet posted). The close requires all journal entries for the fiscal year to be posted so they impact account balances. Any draft entry blocks the process because COI cannot consider a period complete when there are unconfirmed transactions.

Unbalanced trial balance. If any journal entry has total debits different from total credits, the fiscal year trial balance does not balance. The close checks this equilibrium and rejects the process if it detects a difference, since an unbalanced trial balance would produce an inconsistent chart of accounts for the next year.

Monthly periods not closed. The annual close requires that all twelve months of the fiscal year have been previously closed via the monthly close. If any month remains open, COI blocks the annual close to prevent modifications to that period’s entries after the close.

Accounts with incorrect type in the chart of accounts. If an income or expense account is classified as Balance type (asset/liability/equity) rather than Result type, the system will not include it in the automatic closing entry. This causes those accounts not to be zeroed out and the new fiscal year to start with incorrect balances in the result accounts.

Transfer account for retained earnings not configured. The closing journal entry needs an equity account (usually 3xxx) to record the net result of the fiscal year. If this account is not defined in Settings > Parameters, the system does not know where to post the net income or loss and fails when generating the closing entry.

SAT-required fields missing in the chart of accounts. For electronic accounting, the SAT requires that each account have a grouping code and defined nature. If these fields are missing, the generation of the closing trial balance XML fails even if the accounting close itself was successful.

Large or fragmented database. In companies with many years of history and thousands of journal entries, the close process can take several minutes. If the database is fragmented or the server has limited resources, the process may appear to freeze when it is actually just taking longer than expected.

Step-by-Step Solution

Follow this process in the order shown. Do not skip the initial backup.

Step 1: Create a full backup before any operation.

Go to Tools > Backup in Aspel COI and save a complete copy of the database to an external location (USB drive, network share, cloud). If the close fails and leaves the database in an inconsistent state, this backup is the only path to recovery without data loss.

Step 2: Post all draft journal entries.

Go to Journal Entries > Query and filter by status Draft. Review each entry that appears:

  • If the entry is correct, select it and choose Post so it impacts account balances.
  • If it is an unused draft or has errors, delete it.

Repeat the filter until the query returns zero draft entries across all months of the fiscal year.

Step 3: Verify the trial balance is balanced.

Go to Reports > Trial Balance and generate the report for the full fiscal year (January to December). Confirm that total debits equal total credits. If there is a difference:

  1. Identify which period contains the difference by reviewing month by month.
  2. Open the journal entries for that period and find the one with the imbalance (debits ≠ credits).
  3. Edit the entry to correct the imbalance and post it again.

Step 4: Close all 12 monthly periods in order.

Go to Processes > Monthly Close and close any months that remain open, starting with January. The monthly close prevents modification of that period’s entries and is a prerequisite for the annual close. Verify that all 12 months from January to December appear as closed before continuing.

Step 5: Verify the chart of accounts.

Go to Charts > Accounts and review especially:

  • 4xxx accounts (income): must have nature Result and type Credit.
  • 5xxx and 6xxx accounts (costs and expenses): must have nature Result and type Debit.
  • 1xxx, 2xxx, 3xxx accounts (assets, liabilities, equity): must have nature Balance.

If you find incorrectly classified accounts, correct them. This change does not affect accumulated balances but does affect the behavior of the close.

Step 6: Verify the retained earnings transfer account.

Go to Settings > Company Parameters and find the fiscal year close section. Confirm that the equity account where the net income or loss will be recorded is assigned (usually a 3xxx retained earnings account). If it is not assigned, add it before continuing.

Step 7: Run the fiscal year close.

Go to Processes > Fiscal Year Close. The system will display a summary of the result accounts that will be zeroed out. Review it and confirm. COI will automatically generate the closing journal entry that:

  1. Zeros out all income accounts.
  2. Zeros out all cost and expense accounts.
  3. Records the net result (income or loss) in the configured equity account.

Step 8: Open the new fiscal year and verify opening balances.

Open the new fiscal year in COI. Go to Reports > Trial Balance for the new period and verify:

  • Result accounts (4xxx, 5xxx, 6xxx) should show zero opening balance.
  • Opening balances for assets, liabilities, and equity should match exactly the closing balances of the year just closed.
  • The equity account configured for the transfer should show the net income or loss amount from the previous fiscal year.

If there are discrepancies, review the chart of accounts classification and rerun the opening of the fiscal year from Processes > Open Fiscal Year.

Alternative Solution

If after following the steps above the error persists when generating the trial balance for the SAT (electronic accounting), the problem is likely in the SAT-required fields:

  1. Go to Charts > Accounts and look for accounts without an assigned SAT Grouping Code.
  2. The SAT publishes a grouping code catalog for the electronic accounting schema. Assign the corresponding code to each account based on the nature of the operation.
  3. Also verify that no account has a blank nature field.
  4. Once the SAT fields are complete, go back to Reports > Electronic Accounting > Trial Balance and generate the XML again.

For large databases that freeze during the close, first run a compaction (Tools > Database Maintenance > Compact) with all users disconnected. This reduces the close processing time and prevents the process from timing out.

Prevention

To avoid these errors in future fiscal year closes:

  • Perform monthly closes every month. Do not accumulate open months at year-end. Timely monthly closes prevent draft entry buildup and trial balance errors.
  • Verify the trial balance monthly. Generate the trial balance at the end of each month and confirm it balances before moving to the next period.
  • Keep the chart of accounts clean. Review the nature and SAT grouping code of each account when you create it. It is easier to correct a new account than to clean up the entire chart before the close.
  • Compact the database quarterly. A compacted database reduces close processing time and prevents freezes.
  • Set up automated daily backups. Configure a scheduled task to back up COI every night. If something fails, the previous day’s backup limits data loss to a minimum.
  • Close the fiscal year with a single active user. During the close process, ask all other users to exit COI to prevent file locks and race conditions.

Error compacting or repairing the Aspel COI database. If the database is fragmented, the close may fail or freeze. Before retrying the close, see the guide on Error Compacting or Repairing the Database in Aspel COI.

Error generating the XML for journal entries for SAT electronic accounting. If the close completes but the SAT XML generation fails, see the guide on Error Generating XML for Journal Entries in Aspel COI.

Connection error 503 EAccessViolation in Aspel COI. If after the close an access violation error appears when reopening the system, see the guide on Connection Error 503 in Aspel COI.

Similar errors in CONTPAQi Contabilidad. If you also manage CONTPAQi and have equivalent close issues, the root causes and solutions are similar but the menu paths differ.

Summary

  • The fiscal year close error in Aspel COI is mainly caused by draft journal entries, an unbalanced trial balance, unclosed monthly periods, incorrectly classified accounts, or a missing transfer account
  • Always take a full backup before running the fiscal year close
  • Post all draft entries and close all 12 months before attempting the annual close
  • Verify that result accounts (4xxx, 5xxx, 6xxx) are marked as Result type in the chart of accounts
  • The retained earnings transfer account must be configured in Settings > Parameters before the close
  • After the close, verify that result accounts show zero balance and that opening balances for the new year are correct
  • For large databases, compact before the close and run the process with only one user active