How to sync transactions to Quickbooks

Syncing transactions to QuickBooks is the final step in bridging your on-chain activity with your main ledger. Once synced, your crypto transactions can be seamlessly recorded in QuickBooks with the correct accounting entries.

Classifying transactions ensures the data is easy to identify and categorize, but the real game-changer is Chart of Accounts mapping. This ensures the correct debit and credit entries are pushed to the right accounts in QuickBooks.

You may wish to further categorise your transactions using Classes on Quickbooks. Once enabled, you will see Class in your transaction mapping. See more about this here.

Syncing Requirements

For a transaction to successfully sync to QuickBooks, it must meet the following requirements:

Default accounts mapped: Gains/Losses and Fees accounts are set.
Asset mapping for trades: Both assets involved in a trade are mapped to asset accounts.
Pricing data available: No missing prices (contact Support if you encounter gaps).

To make transactions meaningful in your main ledger, it’s also best practice to include:

A clear source name (wallet or exchange).
The identified counterparty.
Transaction labels and notes, where relevant.

Steps to Sync Transactions

Before syncing, check if your workspace has a warning to Update Cost Basis.

Go to the Transactions page.
Click Update Cost Basis if prompted.

Then, follow these steps:

Step 1: Filter Transactions

Decide which transactions you want to sync. Common approaches include:

Filtering by Label (e.g., Salary).
Filtering by Date range.

Step 2: Check Chart of Accounts Mapping

Click into a few transactions to confirm that automated mapping has assigned the correct accounts and that entries are balanced.

Step 3: Select Transactions

To synchronize all transactions that are ready, head to the Needs Review Module, then go to the Ready to be synced tab. You can select all transactions here, then hit Sync with QuickBooks at the bottom.

If you want to do this in batches, you can also highlight the transactions you want to sync from anywhere on the Transactions page. Please note, transactions will only synchronize if they have complete mappings.

Step 4: Sync to QuickBooks

Click Synchronize “X” transactions with QuickBooks.

Green checkmarks indicate the sync was successful.

Locating Synced Transactions in QuickBooks

To view your synced transactions in QuickBooks:

Log in to QuickBooks.
Go to Advanced Search to view all synced journal entries.
This shows the complete set of entries pushed from Cryptio into your ledger.