How to Set Up A2X with QuickBooks: Shopify Step-by-Step

Learning how to set up A2X with QuickBooks means connecting your Shopify store to A2X, connecting A2X to QuickBooks Online, mapping each line of a Shopify payout to the right account in your chart of accounts, and posting a test payout to confirm it reconciles. This guide walks through the exact steps Shopify brands use in 2026 to get clean accrual numbers in QuickBooks.

In our work with 100+ Shopify brands at Ottit, the pattern below is what works in production — not the marketing version. If you're choosing between QBO and Xero for ecommerce in the first place, the QBO vs Xero vs NetSuite comparison covers that decision.

1What You'll Need Before Starting

Before opening A2X, get the prerequisites in one place. Most failed setups happen because the chart of accounts wasn't ready or someone didn't know which gateways the store actually uses. Spending 10 minutes here saves an hour of rework later.

• Shopify admin access with the Owner or Staff with full permissions role
• An active A2X subscription on the Shopify plan tier that matches your monthly order volume
• QuickBooks Online Essentials, Plus, or Advanced (Plus is the standard for ecommerce)
• A finalized chart of accounts with separate accounts for Shopify sales, shipping income, discounts, refunds, sales tax payable, merchant fees, and a Shopify clearing account
• A list of every payment gateway the store uses (Shopify Payments, PayPal, Shop Pay Installments, Affirm, Amazon Pay, gift cards)
• The first payout date you want A2X to start syncing — usually the first day of the current or prior month
• Decisions made on sales tax handling: are you booking gross or net of tax, and which liability account does it hit

2How to Set Up A2X with QuickBooks: Connect to Your Shopify Store

The first step in how to set up A2X with QuickBooks is connecting A2X to your Shopify store. Sign in to A2X, choose Shopify as the platform, approve the install in your Shopify admin, and A2X starts pulling the last 60 days of payouts. The whole connection takes about three minutes.

A2X redirects to your Shopify admin and asks you to install the A2X app. Approve the permissions — A2X needs read access to orders, payouts, refunds, and products. Once installed, A2X starts pulling the last 60 days of payouts as a starting dataset.

If the store uses multiple Shopify stores (a US store and a UK store, for example), each one needs its own A2X account or its own connection inside the same A2X subscription. Don't try to combine them — the currency and tax logic breaks. The A2X documentation for Shopify accounting covers the multi-store setup pattern.

You'll know this worked when: A2X displays your store name, base currency, and a list of recent Shopify payouts in the dashboard within two to three minutes of approving the install.

3Connect A2X to QuickBooks Online

Connecting A2X to QuickBooks Online takes about 30 seconds. In A2X, click Connect to QuickBooks, sign in to Intuit, and authorize A2X to post journal entries, read your chart of accounts, and read tax codes. A2X then pulls in your QBO chart of accounts, tax rates, and class list automatically.

If the connection hangs, the QBO company file is likely on the wrong region — A2X has to match the country to your Shopify base currency.

Best practice from production setups: connect A2X to a QBO file that already has at least one prior month closed. Connecting to a brand-new QBO file with no opening balances often causes A2X's first payout to look orphaned because there's nothing for it to reconcile against. The QuickBooks Online help center has more on app authorization.

You'll know this worked when: A2X's settings page shows the QBO company name, and the Account Mapping screen displays your real QBO chart of accounts in the dropdowns.

4Map Shopify Payout Lines to QuickBooks Accounts

Mapping is the step where most setups get sloppy. A2X breaks each Shopify payout into 15 to 25 line types — sales, shipping, discounts, refunds, gift cards, tips, sales tax, fees, adjustments, chargebacks, and more. Each line needs to map to a specific QBO account. Generic mapping (everything to "Sales") destroys the reporting value of A2X.

Below is the mapping pattern we typically see across Shopify DTC brands. Adjust account names to match your COA.

The Shopify Clearing account is the most important one. A2X posts the total payout amount as a debit to Shopify Clearing. When the deposit lands in the real bank account, you transfer from Shopify Clearing to Operating Cash, and clearing zeroes out. This is the standard accrual pattern documented in the Shopify Help Center guide to payouts.

You'll know this worked when: A2X's Account Mapping page shows zero unmapped lines and a green "Ready to post" indicator.

5Configure Tax Rates and Tax Settings

A2X needs to know whether your QBO file uses Automated Sales Tax (AST) or manual tax codes, and whether you want sales tax tracked on the journal entry or just booked to a liability account. For most Shopify stores using TaxJar, Avalara, or Anrok for filing, the cleanest approach is to book sales tax to a liability account and ignore QBO's tax tracking on the A2X journal.

In A2X, go to Settings → Tax Settings. Choose No Tax on the journal entry lines and let the Sales Tax Collected line carry the full liability amount. This avoids the common problem where QBO's AST tries to recalculate tax on a summary journal and produces a different number than what Shopify actually collected. The Shopify Help Center tax documentation covers the source-side tax logic.

If the store has nexus questions or is wondering when Shopify auto-collection kicks in by state, the Shopify sales tax automation guide for 2026 breaks that down. For Amazon nexus specifically, the Amazon FBA sales tax nexus guide covers the marketplace facilitator rules — relevant if you also sell on Amazon alongside Shopify.

You'll know this worked when: the test journal preview in A2X shows Sales Tax Collected as a credit to your liability account, with no QBO tax codes attached to any line.

6A2X vs Order-Level Sync Apps: Which to Use

Before posting your first journal, it helps to confirm A2X is actually the right tool for your volume. The industry splits ecommerce-to-QBO sync into two camps: summary-level (A2X) and order-level (Bold, Webgility, native Shopify-QBO connector). The table below compares the two approaches across the factors that matter for Shopify and Amazon sellers.

For Shopify brands doing more than 500 orders per month, summary-level posting via A2X is the standard. Order-level sync only makes sense for very low-volume stores or audit scenarios where every order needs to live in QBO individually.

7Post a Test Payout to QuickBooks

Pick the most recent settled payout in A2X and click Send to QuickBooks. A2X creates a journal entry in QBO dated to the payout date (not the deposit date). Open it in QBO and verify the totals match what Shopify reports for that payout. If anything looks off, do not post more payouts — fix the mapping first.

Here's what a typical A2X journal entry looks like for a Shopify Payments payout of $9,247.83 on a $10,500 gross sales day:

The debits and credits balance to $10,279.00 each side. The $9,247.83 in Shopify Clearing is what will deposit into the bank two business days later. When that deposit hits the QBO bank feed, it gets matched to the Shopify Clearing balance, not categorized with a rule.

You'll know this worked when: the journal entry appears in QBO under Reports → Journal, dated to the payout date, with the payout total exactly matching A2X's Shopify Clearing debit.

8Match the Bank Deposit to Shopify Clearing

In QBO, go to Banking → For Review and find the Shopify Payments deposit. Instead of using a category rule, click Find Match and select the matching A2X journal line in the Shopify Clearing account. QBO clears both sides. Repeat this for every payout going forward — after a month, the bank feed match becomes muscle memory.

If the store has multiple gateways (PayPal, Affirm, Shop Pay Installments, Amazon Pay), each one needs its own clearing account and its own A2X account configuration. PayPal especially gets messy because PayPal payouts settle differently than Shopify Payments. The QuickBooks bank feed and rules documentation covers the Find Match workflow.

You'll know this worked when: the Shopify Clearing account balance returns to zero after each payout-deposit cycle, and the QBO bank feed shows no uncategorized Shopify deposits.

9Backfill Historical Payouts

Once one test payout reconciles cleanly, A2X can post the rest of the historical payouts in bulk. Most Shopify brands backfill 12 to 24 months. The risk: if you backfill into a closed period, you'll create journal entries in months that have already been reported. Coordinate with whoever closes the books before bulk-posting.

In A2X, go to Settlements, filter to the date range, and bulk-select. Click Send to QuickBooks. A2X paces the API calls so QBO doesn't throttle. A 12-month backfill of roughly 180 payouts takes about 15 minutes to post and another hour or two of bank-feed matching.

You'll know this worked when: the Shopify Clearing account shows a debit-credit pair for every historical payout and ends at zero, and revenue by month in QBO matches Shopify's analytics within rounding.

10Common Mistakes to Avoid

• Mapping sales tax to an income account. Sales tax collected is a liability owed to the state, not revenue. Booking it as income inflates the top line and creates a sales tax filing nightmare.
• Skipping the Shopify Clearing account. Some setups post the payout directly to Operating Cash. This breaks reconciliation because the journal date (payout date) and the bank feed date (deposit date) don't match. Always use a clearing account.
• Posting before COA is finalized. Renaming an account in QBO after A2X has been posting to it doesn't break the link, but renaming it and then changing the type (income to expense) does. Lock in the COA structure first.
• Ignoring gift card liability. Gift card sales are a liability until redeemed. Mapping them to revenue overstates current-period sales and understates the deferred revenue balance.
• Connecting A2X to a personal Intuit account. If the bookkeeper who set up A2X leaves, the QBO connection can break. Connect A2X using a company-owned Intuit login or the firm's accountant access.

11Troubleshooting

A2X journal totals don't match the Shopify payout amount

This is almost always a missing line type in the mapping. Open the A2X settlement detail and look for any line marked "Unmapped" — even a $0.42 adjustment line that wasn't mapped will throw the totals off. Map it, then click Re-send to QuickBooks. A2X will overwrite the existing journal entry with the corrected version.

Bank deposit doesn't match Shopify Clearing

Check whether Shopify deducted a chargeback or reserve from the payout. Shopify sometimes nets these against the deposit without a separate line. A2X usually catches it, but if the chargeback hit the bank before A2X synced, the clearing account will be off by the chargeback amount until the next sync. Wait 24 hours and re-check.

QuickBooks rejects the journal with a tax code error

QBO's Automated Sales Tax sometimes rejects journals that touch tax-tracked accounts without a tax code. Fix: in A2X tax settings, set every line to No Tax and make sure Sales Tax Payable is not a tax-tracked account in QBO. If it is, change it to a regular Other Current Liability account.

12Frequently Asked Questions

Can I run A2X for Shopify and Amazon in the same QuickBooks file?

Yes. A2X has separate products for Shopify and Amazon, and both can post to the same QBO company. Use a separate clearing account for each (Shopify Clearing, Amazon Clearing) so the reconciliation stays clean. Many DTC brands run both side by side.

How often does A2X sync new payouts?

A2X polls Shopify for new settlements every few hours. New payouts typically appear in A2X within 6 hours of Shopify finalizing them. You can configure A2X to auto-post to QBO on a schedule, or leave it manual so a bookkeeper reviews each payout before it posts.

Does A2X handle multi-currency for international Shopify stores?

Yes, but with caveats. A2X posts in the payout currency. If your QBO file is USD and you have a UK store paying out in GBP, you need a separate QBO file for the UK entity or a multi-currency QBO Plus setup. Mixing base currencies inside one QBO file leads to FX adjustments that defeat the point of A2X.

What's the difference between A2X and Bold's QuickBooks Sync?

A2X posts summary journal entries grouped by payout, on accrual basis. Order-level sync apps post every individual order to QBO, which works for very low volume but creates thousands of transactions per month at scale. The industry standard for stores doing 500+ orders per month is summary-level posting via A2X.

Can I use A2X with Recharge subscriptions?

If Recharge processes through Shopify Payments, the subscription orders flow through Shopify payouts and A2X picks them up automatically. If Recharge uses its own gateway, you need a separate reconciliation path because those payouts don't appear in the Shopify payout report A2X reads. The Recharge subscription platform documentation covers the gateway options.

Should I let A2X auto-post or review each payout manually?

Most stores doing under 1,000 orders per month review manually for the first three months, then switch to auto-post once the mapping is stable. High-volume stores with stable mappings often run on auto-post from day one. The deciding factor is whether someone is actually reviewing the journals — auto-post without review just delays the discovery of problems.

13Where This Fits in Your Stack

A2X handles the booking side of Shopify revenue. It doesn't handle inventory costing, sales tax filing, or COGS. A typical Shopify finance stack pairs A2X with a sales tax filing tool (TaxJar, Avalara, or Anrok), an inventory and COGS tool (Finaloop, Settle, or a manual month-end COGS journal), and a QBO file maintained by a bookkeeper who actually understands ecommerce. Brands selling on Shopify and Amazon often run two A2X connections into the same QBO file.

If you're evaluating whether your current bookkeeper actually knows this workflow, the framework for vetting an ecommerce bookkeeper covers the questions to ask. And if you're trying to figure out what's reasonable to expect them to do, what an ecommerce accountant actually does lays out the scope.

14Sources

• the A2X documentation for Shopify accounting
• the QuickBooks Online help center
• the QuickBooks bank feed and rules documentation
• the Shopify Help Center guide to payouts
• the Shopify Help Center tax documentation
• the Recharge subscription platform documentation