All Collections
Accounting Hub
Integrations
QuickBooks Online
How to Sync Crypto Transactions to QuickBooks Online
How to Sync Crypto Transactions to QuickBooks Online

Sync and categorize crypto transactions from Gilded to QuickBooks Online in minutes.

Gil Hildebrand avatar
Written by Gil Hildebrand
Updated over a week ago

Tired of spending too many hours wrangling spreadsheets?

With Gilded's crypto accounting plugin for QuickBooks you can sync crypto transactions to QuickBooks Online in minutes. 

How does it work?

  • Gilded syncs crypto transactions from popular sources like the Bitcoin and Ethereum blockchains and the Coinbase exchange. Gilded automatically attempts to classify each crypto transaction as income, expense, trade, or transfer.

  • Gilded creates QuickBooks journal entries for each crypto transaction during the sync using your mapping and configuration.

  • We offer auto configuration to create a Digital Assets account in QuickBooks to keep track of your digital assets value in USD or other traditional currencies including EUR, CAD, etc. For each digital asset, we create a separate sub account such as BTC Asset.

  • Once your crypto transactions are synced, run QuickBooks reports as usual. Your reports  now include your crypto transactions.

  • When generating a Balance Sheet report, the Digital Asset account values should be tested for impairment at the end of each reporting period.

 

It's a 5-step process that can take as little as 10 minutes:

1. Signup here!

In order to access our seamless QuickBooks integration, invoicing, and file import/export features, you must have an account with Gilded.

We offer a fully functional 14 day free trial. You can unsubscribe at any time.

2. Add wallets and exchanges

Navigate to the Accounts page to connect your Coinbase, Kraken, Bitcoin, Ethereum, BSC, Ronin, and/or Polygon wallets. Once connected, you can see all of your transaction history in a single, organized space in our Activity page.

3. Enable QuickBooks on the Integrations page

After signing in to your Gilded account, you can then connect to your QuickBooks Online account.

Select Integrations from the drop-down menu under your profile icon.

Select Connect to QuickBooks on the Integrations page.

A pop up window will prompt you to enter your QuickBooks credentials and authorize the connection. Gilded does not store your QuickBooks credentials.

4. Configure mappings to your Chart of Accounts

Gilded needs a dedicated account in QuickBooks to store digital asset holdings. Under this account, Gilded will create sub accounts for each of your digital assets like Bitcoin and Ethereum. We recommend calling it Digital Assets.

You'll need to create this account manually in QuickBooks. Alternatively, you can use the Auto Configure Mappings button to create it directly from Gilded.

The only change Gilded makes to QuickBooks is creating the Digital Assets account. You can always delete this account from QuickBooks later if you decide not to keep it.

The Auto Configure Mappings button also maps income, expense, fee, and gain/loss accounts. You can customize these mappings to suit your needs.

Gilded's Pro Accounting plan gives you even more control over how wallets and crypto transactions are mapped. Contact us to learn more.

5. Sync your first crypto transaction to QuickBooks Online

Navigate to the Activity screen to see all your crypto transactions. On the right side is a QuickBooks column  indicating whether each transaction has been successfully synced. Gray means not synced ;  green means synced.

Click on a transaction to view the details. Make sure the Classification is correct (income, expense, etc), and click the Save to QuickBooks button at the bottom. This step will take just a moment to complete.

Next, open QuickBooks to verify that the transaction was synced as a journal entry. The easiest way to find the transaction is using the magnifying glass icon at the top right of QuickBooks. When the dropdown menu opens, it should appear as the most recent journal entry on top.

Now you can run your standard QuickBooks reports noting your newly synced crypto transactions.

Having trouble? 

Follow these steps to troubleshoot:

  1. Navigate to the Integrations page in Gilded to verify the QuickBooks integration is enabled.

  2. Review your Chart of Accounts mappings:

    • Verify that your Digital Assets account is mapped to a QuickBooks account of the type Other Current Assets.

    • Verify that your Income account is mapped to an Income account in QuickBooks.

    • Verify that your Expense, Fee, and Gain/Loss accounts are mapped to Expense accounts in QuickBooks.



Got a question? Contact our friendly Customer Success team via the in-app chat at the bottom-right of your screen, or email [email protected]

Did this answer your question?