TL;DR — Quick Summary
Fix Aspel COI month-end close when journal entries are blocked: unposted entries, open periods, SAE/NOI interface, concurrent users, and e-accounting.
Month-end close in Aspel COI bundles everything accounting must validate before trial balance, financial statements, and SAT e-accounting: journal entries balanced and posted to the general ledger, and the accounting period ready to close. When the system blocks entries or rejects close, operations stop at month-end — often with unclear messages when manual entries, Excel imports, and automatic entries from Aspel SAE or Aspel NOI mix together. This guide explains why entries get blocked and how to complete close without corrupting the ledger.
The error
When attempting month-end close or saving/posting entries during close, COI may show:
Cannot close accounting period
Unposted journal entries exist
Entry in use by another user
Cannot post entry to general ledger
Period already closed
Month-end close error — check pending entries
In Journal Entries > Inquiry, filtering by period shows draft or unposted folios that the close assistant lists as blockers. Sometimes a single sales or payroll interface entry — unbalanced by one cent or using a major account — blocks the entire month.
Why month-end close blocks entries
Unposted journal entries
COI will not close a period while accounting movements have not reached the general ledger. This includes saved drafts, balanced but unposted entries, and interface batches that failed mid-process.
Unbalanced entries or invalid accounts
Entries with debits unequal to credits cannot post; close flags them as pending. The same applies when using major accounts that reject direct postings or inactive chart accounts.
Wrong or already closed period
Editing entries in a closed month causes blocks. Trying to close again may show “period already closed” when the real issue is prior-month stragglers or the next month not opened.
Concurrent session lock
COI locks a record when another user has the same entry open. During close with multiple clerks this is common; closing the other session or admin release fixes it.
Incomplete SAE or NOI interface
Automatic entries from billing, purchases, payroll, or PTU provisions depend on account mapping under Configuration > Accounting interface. If the source module changed SAT keys, accounts, or cost centers without updating COI, bad interface entries remain unposted and block close.
E-accounting pre-checks
Many teams validate trial balance and catalog before SAT XML. Missing SAT grouping or out-of-period movements delay close; COI still shows pending entries until root cause is fixed.
Quick diagnosis
| Symptom | Likely cause | Where to check |
|---|---|---|
| Close rejected with folio list | Unposted entries | Journal Entries > Inquiry, unposted filter |
| Entry won’t save | Closed period or user lock | Accounting periods / active sessions |
| Empty interface folio | Account mapping | Configuration > Accounting interface |
| Totals don’t balance | Rounding or major account | Entry editor, chart of accounts |
| One month only fails | Prior-month stragglers | Date range inquiry |
Document folio, type, source, and variance for each pending entry; COI’s close summary helps but manual inquiry catches submodule entries.
Step-by-step fix
1. Inventory pending entries
Filter the closing month for unposted status. Separate manual, imported, and interface (SAE, NOI, bank) entries.
2. Fix unbalanced entries
Match debits and credits per entry. For sub-peso rounding differences, add an adjustment or exchange-difference line. Replace grouping accounts with detail subaccounts.
3. Post to ledger in a controlled batch
With balanced entries, use Post to ledger per entry or batch if your version supports it. If “closed period” appears, temporarily reopen with admin rights, post, and close again.
4. Release user locks
Have staff close COI on other PCs. If locks persist, admin must clear connected users and record locks.
5. Reprocess SAE and NOI interface
Validate every sales, purchase, and payroll concept maps to a live account. Regenerate period entries only after mapping fixes; cancel duplicate folios from failed runs.
6. Trial balance and month-end close
Generate trial balance for the month. When it ties, run month-end close. Log date, user, reprocessed entries, and notes for audit.
7. Post-close e-accounting
Generate SAT e-accounting XML per your calendar. Fix catalog errors in COI before filing; reopening periods has tax implications — involve your accountant.
Prevention
- Weekly cutoff: no month entries left unposted after day 25.
- Update accounting interface the same day the chart of accounts changes.
- Train staff not to leave COI sessions open on shared entries.
- Separate manual capture from mass interface reprocessing schedules.
- Document period reopenings with reason and owner.
Summary
- Aspel COI month-end close fails with unposted, unbalanced, wrong-period, or user-locked entries.
- SAE and NOI interface often leaves pending entries; fix mapping before close.
- Balance, post, validate trial balance, then close; e-accounting follows with a consistent catalog.
- Period reopening needs admin rights and should align with SAT obligations.