Skip to main content

Sync transactions to QuickBooks

Connect QuickBooks Online, map your accounts and sync without CSV exports

Written by Noah

Altitude Accounting connects your workspace to QuickBooks Online. You review each settled transaction, choose how it is recorded and write it to QuickBooks – no CSV exports, and nothing syncs until you choose to sync it.


Before you connect

  • Accounting in your Altitude sidebar – if it is missing, a member with Propose adds the Accounting permission for you through a proposal in Settings › Members (see Members)

  • One QuickBooks company per workspace

  • A Primary admin or Company admin role in QuickBooks

  • QuickBooks Online available in your country

  • Multicurrency turned on in QuickBooks, to sync EUR accounts

Intuit only lets those user roles connect apps.


Connect QuickBooks

  1. Go to Accounting and connect QuickBooks.

  2. Sign in to QuickBooks and authorize Altitude.

  3. Choose the Altitude accounts to sync. For each, use an existing QuickBooks account or create a new one, and set a Sync from date.

  4. Check the summary and confirm.

Transactions before the sync from date are not brought in. A new QuickBooks account can start with your balance on that date; an existing one does not, so check its balance matches Altitude.


Review and sync transactions

Settled transactions on your synced accounts wait under For review.

  1. Open a transaction.

  2. Check the Type and choose a Category from your chart of accounts. Altitude suggests one based on similar transactions you have synced – see Suggestion Engine.

  3. Add the QuickBooks vendor for money going out, or the customer for money coming in. If they are not in QuickBooks yet, create them from the same list.

  4. Check the preview and sync.

To post to Accounts Payable or Accounts Receivable, add the vendor or customer first.

The transaction moves to Synced. For a quicker pass, set the type and category in the row and sync from there – the category list only shows accounts that fit the type and currency. To sync several at once, select them, choose one category for all of them, then sync.

To keep transactions out of QuickBooks, exclude them, one at a time or several at once. They move to Excluded, where you can send each one back for review.


Transfers

A transfer between two synced Altitude accounts posts as one QuickBooks transfer, and card deposits and withdrawals are set to Transfer automatically. A transfer that converts currency, such as EUR to USD, syncs as two single-currency transactions.

Map each Altitude account to its own QuickBooks account. QuickBooks rejects a transfer where both sides are the same account.


What syncs

  • Bank deposits and payments – ACH, wire, SWIFT and SEPA

  • USDC and EURC deposits and transfers

  • Transfers between your Altitude accounts

  • Card activity, once your Cards account is mapped

  • Earn rewards

USD and EUR accounts are supported; SOL and cbBTC in Holdings are not. A transaction cannot be split across lines yet, transaction hashes are not added to the entry, and synced entries can only be corrected in QuickBooks.


Change your setup or disconnect

Open the settings on the Accounting page to add or stop syncing an account, change a mapping, refresh your QuickBooks accounts or disconnect. To change a mapping, stop syncing the account, confirm, then add it again. Anything already synced stays in QuickBooks.


If a transaction will not sync

What you see

What to do

A transaction cannot be synced

Choose a type and category that work together

The transaction is under Failed

Open it to see why, fix it and try again

A transfer failed

Both accounts map to the same QuickBooks account – remap one

A EUR account cannot be selected

Turn on multicurrency in QuickBooks

QuickBooks will not connect

Check your QuickBooks role and that QuickBooks Online is available in your country

A new vendor or customer cannot be created

Use a name that is not already in QuickBooks, without a colon

Using Xero? See Sync transactions to Xero. For CSV and PDF statements, see Statements and documents.

Did this answer your question?