TL;DR — Quick Summary
Aspel COI trial balance does not tie out: find unbalanced journal entries, stale balances, order accounts, and step-by-step fixes for Mexican accounting teams.
When you run the trial balance (balanza de comprobación) in Aspel COI, Mexican accounting teams often see an account difference message or totals where debits and credits do not match. The issue blocks month-end close, Aspel SAE reconciliation, and frequently prevents SAT electronic accounting XML generation.
The Error
The report typically shows:
Trial balance — The balance does not tie out
Difference: $X,XXX.XX between debits and credits, or an inconsistent closing balance on one or more accounts.
Some installations flag unexpected negative balances, subsidiaries with activity but zero balance, or debit and credit totals that disagree at period end. COI does not always point to the exact journal entry, so follow a diagnostic order before editing transactions at random.
Root Cause
The most frequent causes in Mexican COI deployments are:
- Unbalanced journal entries entered manually or imported from Excel without validating debit = credit.
- Balances not recalculated after deleting entries, partial restore, or Aspel patches.
- Incomplete opening entry when starting a fiscal year or creating a new company.
- Misconfigured leaf accounts (posting to header accounts or duplicate subaccounts in the chart).
- COI–SAE interface drift when sales, purchases, or payroll created duplicate or incomplete entries.
- Partially closed periods where users posted into a consolidated month without controlled change permission.
- Cent rounding differences from exchange rates or VAT breakdown that COI accumulates until visible on the trial balance.
Step-by-Step Fix
1. Back up and close sessions
Before any correction, ensure all users close COI.exe. Copy the company .GDB to a safe location. If the difference is large, note the date of the last correct close to narrow the search.
2. Print trial balance with full detail
In Reports > Accounting > Trial balance:
- Select the fiscal year and month with the difference.
- Enable opening balance, debits, credits, and closing balance.
- Sort by account and export to Excel to filter if needed.
Check whether the gap is in the grand total or only in income, order, or balance-sheet accounts. That indicates whether the source is an operational entry or chart configuration.
3. Find inconsistent journal entries
Review the same period for:
- Journal entries with a single line or zero amount.
- Imports from SAE, banks, or payroll using nonexistent accounts.
- Adjustment entries duplicated after a month-end close was manually reversed.
COI lets you drill into account activity: open the suspect account, sum debits and credits for the month, and compare with the trial balance. The first account where closing ≠ initial + debits − credits usually leads to the problem entry.
4. Recalculate balances
If entries balance but the trial balance still fails, run balance recalculation from your version’s utility (Utilities or Special processes). This rebuilds subsidiaries without deleting entries but requires a backup first.
After recalculation, regenerate the trial balance. If the difference disappears, corrupted balances after a power loss or bad restore were the cause.
5. Validate chart and opening entry
Confirm that:
- Only leaf accounts receive postings.
- The opening entry for the year balances debits and credits.
- No obsolete accounts retain residual balance after a chart restructure.
If you migrated from another system, verify opening balances were not loaded twice (opening plus transfer entry).
6. Reconcile with Aspel SAE
When the difference matches sales or purchases for the month:
- In SAE, run the report of entries exported to COI.
- In COI, compare document numbers and amounts for the same date range.
- Remove duplicates and re-export only the affected period.
One-day lag between billing and posting often explains differences that “appear” when rolling the accumulated trial balance into the next month.
Diagnostic Table
| Symptom | Likely cause | First action |
|---|---|---|
| Grand total off by exact amount | Single unbalanced entry | Search entries matching the difference |
| One account wrong closing balance | Posting to wrong leaf account | Drill into account activity for the month |
| Difference after restore | Corrupted subsidiary balances | Back up GDB, then recalculate balances |
| Gap matches SAE sales total | Duplicate or missing export | Reconcile SAE export report with COI folios |
| Cent-level drift | Rounding on FX or VAT lines | Adjust rounding entry on designated clearing account |
Prevention
- Close the month in COI only when the trial balance shows zero difference.
- Block manual posting to header accounts; always use detail subaccounts.
- Schedule balance recalculation quarterly in high-volume automatic-entry environments.
- Document every backup restore and run recalculation immediately afterward.
- Keep the SAE–COI interface on Aspel’s compatible version pairing.
- Before filing electronic accounting, generate and archive the trial balance with the XML.
Summary
- A trial balance that does not tie out in Aspel COI is usually explained by unbalanced entries, stale balances, or SAE drift — not a random report bug.
- Print the trial balance with full balances, find the inconsistent account, and trace the entry before deleting movements.
- Recalculate balances fixes corrupted subsidiaries; back up the .GDB before maintenance utilities.
- A balanced trial balance is required for month-end close, internal audit, and SAT XML filing.