Skip to main content

How can we help?

Syncing transactions to Quickbooks

Quickbooks is one of the world’s leaders in accounting software. Cryptio allows you to push transaction data automatically, saving both time and money on the accounting process.

 

Why would I do that?

  • It's the right method if you want to have in your accounting system a journal entry per transaction

  • It's the most automated method. No manual spreadsheet is needed. You can use our direct Quickbooks integrations

  • You won't need to do any reconciliation within your accounting system


Syncing requirements

For transactions to successfully sync to Quickbooks it needs to meet certain requirements:

  1. Default accounts have been mapped (Gains/Losses & Fees)

  2. The transaction is balanced (Asset account & PnL account mapped)

    - For trades, there are two asset accounts.
  3. There are no missing prices (if there is let us know!)

In order for the transactions to make sense in your main-ledger you want to have the following details attached to the transaction:

  1. Appropriate name of your source (wallet/exchange)

  2. Counterparty identified

  3. Transactions Labelled (and notes added where applicable)

Here's how the entires will look in Quickbooks:

 


Steps to syncing transactions

The first thing you need to do before syncing transactions is check whether you have a warning next to your workspace saying you need to Update the Cost Basis!

 

You can do this by clicking on the Update cost basis button on the transactions page.

 

The next step is to filter for all the transactions that you want to sync to Quickbooks, this is really up to you, what is the most common practice is filtering by:

  • Syncing all transactions with a particular Label (i.e. Salary)

  • Syncing all transactions within a particular time frame

Let's use the example of filtering by Label and syncing transactions:

 

 

Step 1: Double-check the transactions are Balanced

Do this by clicking on random transactions to check if the automated Chart of Accounts mapping has mapped the correct accounts to the transactions.

 

 

Step 2: Select the transactions you want to sync

 

 

Step 3: Click, Synchronize 'X' transactions with Quickbooks

 


Locating these transactions in Quickbooks

  • Log-in to Quickbooks

  • Click on the magnifying glass icon

  • Once you have clicked you will be presented with all the recent synced transactions from Cryptio.

  • Click on Advance Search, to see a full list of all the journal entries. This is the location of the synced transactions that you have pushed from your sub-ledger to the main ledger.