Skip to main content

Quickbooks (QBO) integration

Quickbooks Online (QBO) x Crypto Tax Calculator integration

David Melbourne avatar
Written by David Melbourne
Updated today

How to Use the CryptoTaxCalculator + QuickBooks Online Integration

Managing crypto transactions for your business just got easier. If you're on a CryptoTaxCalculator (CTC) Business Plan, you now have access to a powerful integration with QuickBooks Online (QBO) — one of the leading cloud-based accounting platforms.

This integration allows you to seamlessly export categorized crypto transactions from CTC into QBO, helping streamline your bookkeeping and simplify your accounting workflow.


What You’ll Need

  • An active CryptoTaxCalculator Business Plan

  • A QuickBooks Online account


Why Use CryptoTaxCalculator with QuickBooks Online?

CryptoTaxCalculator helps you import, categorize, and manage all your crypto activity. QuickBooks Online provides a robust accounting platform to handle financial reporting, tax tracking, and general business health.

When combined:

  • CTC manages the crypto-specific bookkeeping

  • QBO handles broader financial and tax accounting


How to Sync CTC with QBO

1. Import & Categorize Transactions in CryptoTaxCalculator

Start by importing your crypto transactions into CTC. The platform automatically recognizes common transaction types such as:

  • Trades

  • Income

  • Mining

  • Staking rewards

  • And many more

You can manually categorize transactions as needed to ensure accuracy before exporting.


2. Connect CTC to QuickBooks Online & Map Accounts

Once your transactions are categorized:

  • Navigate to the Accounting Integrations tab in CTC.

  • Under Connect Integration, choose QuickBooks Online.

  • Follow the prompts to authorize the integration and link your client’s QuickBooks account.

After connecting, you’ll need to map CTC’s default accounts to your QuickBooks Chart of Accounts.

Default Account Mappings:

CTC Account

Purpose

Cash Account

Represents fiat received or paid when selling or buying crypto. (Crypto-to-crypto trades don’t affect this account.)

Fee Account

Captures fees paid on transactions.

Realized Gain Account

Tracks profits from the disposal of crypto assets.

Realized Loss Account

Tracks losses from crypto disposals.

Missing Purchase History Account

Used when an asset is acquired without an associated payment (e.g., airdrops), with cost basis calculated using market value.

These mappings ensure exported data flows into the right accounts within QuickBooks.


3. Choose Export Settings

Before syncing, customize how your data is exported:

  • Rollup Settings: Choose how to bundle journal entries:

    • None – Export every transaction individually

    • Daily – Group transactions by day

    • Monthly – Group transactions by month

  • Allow Transactions with Warnings: Toggle this on if you'd like to sync transactions from CTC even if they contain warnings.


4. Export Transactions to QuickBooks Online

Once mappings and settings are configured:

  1. Go to the Transactions page in CTC.

  2. Use the filter options to review transaction statuses:

    • Synced – Already exported to QBO

    • Ready to Sync – Categorized, mapped, and ready for export

    • Not Ready to Sync – Unable to be synced due to missing mapping

    • Out of Date – Previously synced but has since changed in CTC. This can happen when making manual changes to an already exported transaction or making a change that affects that transactions cost base.

    • Failed – Attempted sync failed; retry or contact support

  3. For each transaction:

    • Click into it and select Chart of Accounts

    • Assign the appropriate account for each asset

    • Click Sync to QBO on the right side of the transaction

  4. To export in bulk:

    • Select multiple transactions

    • Use bulk tools to apply mappings and sync all at once

CTC will then create the appropriate journal entries in QBO, aligned with your mapping and grouped based on your export settings.


Integration Benefits

✅ No more manual data entry

✅ Accurate and consistent account mapping

✅ Easy reconciliation of crypto with business records

✅ Streamlined tax prep and audit readiness

✅ Clean, professional financial reporting


Important Reminders

  • This integration is exclusive to Business Plan users on CryptoTaxCalculator.

  • Ensure your QuickBooks Chart of Accounts is fully set up before mapping.

  • Sync regularly to maintain accurate and up-to-date records in both systems

Did this answer your question?