Importing Your Chart of Accounts

Chart of Accounts is a Tier 2 (First Week) data type. Importing your chart of accounts establishes the financial structure your business uses to categorize transactions, track balances, and generate reports. It is recommended that you import your chart of accounts before importing opening balances or any other accounting data.

Before You Begin

• Prepare a CSV file containing your account list
• Ensure every account has a unique Account Code and a valid Account Type
• Account types must match the types already configured in AccuArk. The standard types are: Asset, Liability, Equity, Revenue, and Expense. If your business uses sub-types (for example, Current Asset or Long-Term Liability), confirm they exist in AccuArk before importing.
• If you want a hierarchical account structure, decide which accounts will serve as parent accounts

Step-by-Step Import

1. Open the Data Exchange Center from the Business menu
2. Click Import on the Chart of Accounts card
3. Click Browse and select your CSV file
4. Click Next to proceed to column mapping
5. Ensure the following required fields are mapped:
   • Account Code (required)
   • Account Name (required)
   • Account Type (required)
6. Map optional fields such as Parent Account, Description, and Tax Code as needed
7. Click Next to validate
8. Review validation results — pay close attention to any account type lookup errors
9. Click Import to finalize

How Upsert Works for Chart of Accounts

Chart of Accounts uses Account Code as the match key:

• If an account with the same account code already exists, the row updates that account with the new values
• If no account with that code exists, a new account is created

This allows you to re-import your chart of accounts after making changes in a spreadsheet without creating duplicates.

Available Fields

Account Type Lookup

The Account Type field is validated against the account types that exist in your AccuArk system. The standard types are:

• Asset — Resources your business owns (cash, equipment, receivables)
• Liability — Obligations your business owes (payables, loans)
• Equity — Owner's investment and retained earnings
• Revenue — Income from sales, services, or other sources
• Expense — Costs of operating the business

If your system has additional sub-types, those are also valid. The match is case-insensitive.

Building a Hierarchical Structure

The Parent Account field lets you nest accounts under a parent. For example, you might have a parent account "1000 - Cash and Bank" with child accounts "1010 - Checking" and "1020 - Savings."

To set this up, enter the parent's account code in the Parent Account column of the child row. Parent accounts can be existing accounts in AccuArk or other accounts being imported in the same file.

Tips

• Import before opening balances — Your chart of accounts defines the accounts that opening balances reference. Always import the chart of accounts first.
• Use meaningful account codes — A numbering convention (e.g., 1000s for assets, 2000s for liabilities) makes your chart easier to navigate
• Export first for a template — If you are unsure of the format, export your current chart of accounts to get a CSV with the correct headers
• Review account types carefully — An incorrect account type can cause financial reports to display incorrect totals