How Do I Import Opening Balances for My Accounts?

The Opening Balances import in the Data Exchange Center allows you to set starting balances for your chart of accounts when you first migrate to AccuArk. This is an import-only feature — there is no corresponding export.

Preparing Your CSV File

Your CSV file should contain three columns:

• Account Code — The code that matches an existing account in your chart of accounts
• Debit — The debit amount for this account (leave blank or enter 0 if the balance is a credit)
• Credit — The credit amount for this account (leave blank or enter 0 if the balance is a debit)

Each row specifies one account and either a debit or credit amount.

The Balancing Requirement

Your opening balances entry must balance — the total of all debit amounts must equal the total of all credit amounts. If the totals do not match, the import will not proceed. This is a fundamental accounting rule that ensures your books start in a balanced state.

Import Steps

1. Open the Data Exchange Center and locate the Opening Balances card
2. Click Import
3. In Step 1, select your CSV file and choose the default debit and credit accounts
4. Map your columns in Step 2
5. Review and validate in Step 3 — verify that debits equal credits
6. Click Import to apply the opening balances

When to Use This Feature

Opening balances are typically imported once during your initial setup when migrating from another accounting system. They establish the starting point for all of your accounts in AccuArk. You generally do not need to import opening balances again after the initial migration.

Permission Requirement

This feature requires Super Admin permission. If the Opening Balances card is grayed out, contact your system administrator.