Aspel COI: Error Importing Accounting Entries and Chart of Accounts

TL;DR — Quick Summary

Fix Aspel COI errors importing accounting entries and chart of accounts: incorrect file format, missing accounts, and accounting period issues.

Aspel COI Import Errors

Aspel COI allows importing accounting entries from text files but requires correct format and existing accounts.

Solution: Convert to .txt/.csv with correct delimiter. Dates in DD/MM/YYYY.

Solution: Import chart of accounts first.

Solution: Ensure debits equal credits for each entry.

Guide & Instructions

Estimated Time: 20m

Tools Needed:

Ensure the file is delimited text (.txt/.csv) with correct field order and DD/MM/YYYY date format.

Confirm all accounts in the import file exist in COI's chart. Import the chart first if needed.

Go to Utilities > Import > Entries. Select the file and configure the delimiter.

Verify imported entries and confirm balances match.

Frequently Asked Questions

What file format does Aspel COI accept for importing entries?

COI accepts delimited text files (.txt or .csv) with fields in the correct order: entry type, number, date, account, description, debit, credit.

Why does COI reject entries with non-existent accounts?

Accounts must exist in COI's chart of accounts before importing entries. Import the chart first, then the entries.