FAQ: ERP & Chart of Accounts

Use this FAQ to help with questions related to syncing journal entries and your chart of accounts.

Chart of Accounts

Can I map my Chart of Accounts by crypto token, rather than by wallet?

Yes! Just expand the wallet (+) in your chart of account mapping and select the dropdown mapping for each currency within the wallet.

I don't use an ERP. Can I import a custom chart of accounts?

I made a change to my Chart of Accounts. How do I update it in Integral?

To refresh your Chart of Accounts data in Integral, navigate to the Integrations page and click the "refresh" button on the right of your ERP connection.

Do you have any best practices when creating a Chart of Accounts in crypto?

See our article on How to Create a Chart of Accounts in Crypto.

Syncing Journal Entries to QuickBooks/Xero/Netsuite

My journal entry failed. Why?

There are many reasons a journal entry sync might fail.

1) The most common reason is a missing mapping in the Chart of Accounts page. Please make sure all your tokens and/or wallets are mapped to an asset account, and your gas fees & realized gains/losses are also mapped. See Map your Chart of Accounts.

2) For Xero users: Integral cannot push journal entries to "system accounts". It is common for users to map their realized gains/losses to Xero's default system account for realized gains/losses. Please create a new "crypto realized gains/losses" account, and remap it under Chart of Accounts.

3) Your account currency is different that the default Integral currency.

I have a large transaction volume. Can I roll up my journal entries?

Yes! Navigate to Accounting Policies, enable "Journal Entry Bundling". Once enabled, select sum-up journal entries, the frequency of sum-ups, and the types of transactions to sum up. See Customize Journal Entries for more details.

How do I see what was synced to my ERP?

All transactions synced to your ERP will show up in the “Synced” tab in the Bookkeeping page. A custom report is coming soon.

Can I change the category on transactions I already synced to my ERP?

You cannot edit journal entries from Integral (yet!) and cannot edit transactions that have been synced. However, you can manually overwrite this. Navigate to Bookkeeping -> Synced tab. Bulk select the transactions you want to overwrite, and click "Unmark as Synced". This will place the transactions back into the Categorized tab. Here you can change the categories and resync the transactions. Note: It is up to you to delete the previous journal entries in your ERP.