Skip to content
Integral Help Center home
Integral Help Center home

Map your Charter of Accounts

Overview

Your Chart of Accounts (CoA) is the backbone of your general ledger in your ERP system (QuickBooks Online, NetSuite, or Xero). In Integral, CoA mapping connects Integral's internal transaction categories to your actual GL accounts so that journal entries sync to the correct accounts in your ERP.

Before Integral can push journal entries to your accounting system, you must map Integral's account categories to your GL accounts. Without this mapping, journal entries will fail to post or post to incorrect accounts, breaking your audit trail and ledger reconciliation.

How Integral Imports Your Chart of Accounts

When you connect an ERP system to Integral, Integral automatically imports your entire Chart of Accounts from that system. The import captures:

  • Account name — the display name of each GL account (e.g., "Bitcoin Wallet," "Ethereum Cold Storage")

  • Account code — the account number or identifier (e.g., "1010", "2100")

  • Account type — the classification (Asset, Liability, Equity, Income, Expense, etc.)

This import is read-only on Integral's side. You cannot create, edit, or delete GL accounts directly in Integral; all account management happens in your ERP. If you add a new account in QuickBooks, NetSuite, or Xero, it will appear in Integral's mapping interface on your next sync.

Where to Find Chart of Accounts Mapping

To access CoA mapping in Integral:

  1. Go to Settings → Integrations.

  2. Select the ERP system you want to map (QuickBooks Online, NetSuite, or Xero).

  3. Click Chart of Accounts page.

The mapping screen displays two columns:

  • Left column — Integral's internal account categories (e.g., "BTC Balance," "Realized Gains," "Trading Fees")

  • Right column — Your imported GL accounts from your ERP, organized by account type

What Needs to Be Mapped

You must map the following account types to ensure all transaction types post correctly:

Asset accounts — Map a GL account for each crypto asset and fiat currency you hold. This includes:

  • Bitcoin

  • Ethereum

  • Stablecoins (USDC, USDT, DAI, etc.)

  • Fiat currency accounts (USD, EUR, etc.)

  • Any other digital assets your fund holds

Realized gain/loss accounts — These post when you sell or convert assets. You may need separate accounts for:

  • Realized gains

  • Realized losses

Unrealized gain/loss accounts — These post when you mark to market crypto holdings. You may need:

  • Unrealized gains (revaluation account)

  • Unrealized losses (revaluation account)

Fee accounts — Map GL accounts for:

  • Exchange fees

  • Custody/custody fees

  • Transaction fees

  • Network fees (gas, etc.)

Income/revenue accounts — Staking rewards, airdrops, and other earned income.

Default/fallback account — A catch-all GL account for transaction types that don't have a specific mapping. This prevents journal entries from failing if a category is unmapped.

How to Map Accounts

Follow these steps to map your CoA:

  1. Open Settings → Integrations and select your ERP (QuickBooks Online, NetSuite, or Xero).

  2. Click Chart of Accounts.

  3. In the left column, locate the Integral category you want to map (e.g., "BTC Balance").

  4. Click the dropdown on the right side of that row to select a GL account from your ERP.

  5. The dropdown displays account names, codes, and types to help you choose the correct account.

  6. Select the GL account that matches this category.

  7. Repeat for all required account categories.

  8. Once all required mappings are complete, click Save.

  9. Integral will validate the mapping. If there are errors (e.g., unmapped categories), the UI will highlight them.

You can map accounts one at a time or all at once before saving.

What Happens If Mapping Is Incomplete

If you attempt to push journal entries to your ERP but your CoA mapping is incomplete, Integral will:

  1. Detect the unmapped category when generating the journal entry.

  2. Block the entry from posting

  3. Display an error message indicating which account categories are unmapped.

  4. Prevent the journal entry sync until all required mappings are complete.

This safeguard prevents orphaned or misclassified entries from reaching your ERP. Review the error message, complete the missing mappings, and retry the sync.

Updating Your Mapping

You can change a CoA mapping at any time:

  1. Go to Settings → Integrations and select your ERP.

  2. Click Chart of Accounts.

  3. Click the dropdown for the category you want to update.

  4. Select a different GL account.

  5. Click Save.

Mapping changes are generally prospective. When you remap a transaction category or account to a different GL account, Integral applies that mapping to new journal entries generated after the change. Entries that have already been posted to your ERP (QuickBooks Online, NetSuite, or Xero) are not automatically updated.

If journal entries have already been pushed to your ERP under the old mapping:

  • The entries in your ERP remain as-is under the original GL account.

  • Any new transactions categorized under the updated rule will post to the new account going forward.

  • This can create a split across periods where the same transaction type hits two different GL accounts — which matters for comparability and period-over-period reporting.

Recommendation: Before changing a mapping, consider the impact on your ledger. If historical entries have already posted to the old GL account, changing the mapping will not retroactively move those entries. You may need to make manual journal entry adjustments in your ERP or discuss the change with your accountant.

Correcting Historical Entries

To correct already-posted entries, the typical workflow is:

  1. Identify the affected journal entries in Integral.

  2. Void or reverse the incorrectly mapped entries.

  3. Re-categorize the underlying transactions under the correct mapping.

  4. Re-push the corrected journal entries to your ERP.

Tips for a Clean CoA Mapping Setup

Work with your accountant — Before you start mapping, review your CoA structure with your accountant or finance team. Ensure that Integral's categories align with your existing GL account structure. Misaligned mappings can create reconciliation issues later.

Use consistent account naming — If possible, ask your accounting team to use clear, descriptive GL account names (e.g., "Bitcoin – Hot Wallet" instead of "Crypto 1"). This makes it easier to identify the correct account in Integral's dropdown.

Test with a small subset — If you manage multiple asset classes or currencies, start by mapping one or two categories and running a small test sync. Verify that entries post to the correct GL accounts in your ERP before mapping all categories.

Document your mappings — Keep a record of your CoA mappings (category → GL account) in a shared spreadsheet or wiki. This is helpful for onboarding new team members and audits.

Plan for future assets — If you expect to add new crypto assets or currencies in the future, discuss with your accountant how to structure GL accounts for those assets now. Creating sub-accounts or segments in your ERP can simplify mapping as you scale.

Reach out to your Integral onboarding contact or email help@integral.xyz

Last updated: April 2026

Powered by Plain