TL;DR — Quick Summary
Fix errors when importing accounting journal entries from SAT XML files in CONTPAQi Contabilidad: invalid schema, missing accounts, and period conflict resolution.
Error Importing Journal Entries from SAT XML in CONTPAQi
Importing accounting journal entries from XML files is common when receiving records from external accountants, migrating between accounting systems, or incorporating electronic accounting generated by third parties complying with SAT Anexo 24.
Prerequisites
- CONTPAQi Contabilidad with valid license and admin access.
- XML file in SAT Anexo 24 format (version 1.3).
- Chart of accounts updated in CONTPAQi.
- Open accounting period matching the entry dates.
Common Errors and Solutions
1. “Invalid XML Schema”
The file doesn’t comply with the Anexo 24 XSD structure.
Solution:
- Verify the correct namespace:
www.sat.gob.mx/esquemas/ContabilidadE/1_3/PolizasPeriodo. - Validate against the official SAT XSD schema.
- Request re-generation with the updated schema if from another system.
2. “Account Not Found”
XML accounts don’t exist in your CONTPAQi chart of accounts.
Solution:
- Export your current chart: Catalogs > Accounts > Export.
- Compare with XML accounts to identify missing ones.
- Create missing accounts or use the equivalence table in Tools > Account Equivalences.
3. “Accounting Period Closed”
Entries have dates from a period already closed.
Solution:
- Go to Processes > Open Period.
- Back up before reopening.
- After importing, close the period again.
4. “Duplicate Entry”
An entry with the same type, number, and date already exists.
Solution:
- Check if already imported.
- Delete the existing entry first, or configure automatic numbering.
Quick Diagnostic Table
| Error | Probable Cause | Solution |
|---|---|---|
| ”Invalid schema” | XML doesn’t meet Anexo 24 v1.3 | Validate against official XSD |
| ”Account not found” | Missing accounts in chart | Create accounts or use equivalences |
| ”Period closed” | Month/year blocked | Reopen period from Processes |
| ”Duplicate entry” | Previously imported | Delete existing or auto-number |
| ”Balance mismatch” | Debits ≠ Credits in XML | Validate source file with accountant |