Why Your Shopify QuickBooks Integration Is Showing Wrong Numbers (And How to Fix It)

By John Adams | Palo Alto Bookkeeping

You open QuickBooks. It reports $142,000 in monthly revenue. Shopify shows $131,000. Your bank statement: $124,000 deposited.

Three numbers. One store. One month. None of them agree.

The problem isn’t a glitch. Shopify and QuickBooks were built for different jobs. Shopify tracks orders the moment customers pay. QuickBooks records money when it lands in your bank. Between those two events, Shopify subtracts fees, withholds sales tax, bundles orders, nets out refunds, and waits up to three business days before sending anything.

Every connector between these systems has to translate across that gap. Most of them get it wrong.

I find this in roughly seven out of ten ecommerce books I open. The remaining three had the problem, attempted a fix, and made it worse.

This post walks through the five root causes, how to identify which one you’re facing, and how to fix each issue permanently.

The Five Reasons Your Numbers Don’t Match

Below are the five most common causes, ranked by how often I encounter them in cleanup engagements. Each section identifies the cause, explains how it distorts your numbers, and provides a specific fix.

1. Shopify Sends Net Payouts, Not Gross Sales

This cause creates the largest dollar discrepancies and appears in the majority of misconfigured integrations.

Shopify groups multiple days of activity into a single deposit. A typical payout bundles 47 orders, subtracts $312 in processing fees, deducts $89 in refunds, and holds $24 in chargeback fees. The net deposit that reaches your bank — $7,431.18 — bears little resemblance to the $7,840.22 in gross sales Shopify reports for those orders.

If your QuickBooks records the bank deposit as a single “Sales” or “Shopify Income” entry, your revenue is understated by roughly $400. Simultaneously, your expenses are missing $312 in processing costs, $89 in refunds, and $24 in chargeback fees. Your P&L is wrong in three directions at once.

If your QuickBooks also imported the $7,840.22 as gross sales from a sync app, your income is now doubled to approximately $15,271 — for $7,840 in actual sales.

The fix. Record each payout as a broken-down transaction in QuickBooks, not a lump sum. Pull the Shopify Payout Report (Finances > Payouts in your Shopify admin) — not the revenue dashboard or orders export — and map each component to the correct account:

Payout Component	QuickBooks Account	Example Amount
Gross sales	Income: Shopify Sales	$7,840.22
Refunds issued	Income: Shopify Refunds (contra)	-$89.00
Processing fees	Expense: Merchant Processing Fees	-$312.00
Chargeback fees	Expense: Chargeback Fees	-$24.00
Shipping adjustments	Income or Expense (varies)	+$16.00
Net deposit	Matches bank feed	$7,431.18

Note: A2X handles this breakdown automatically when configured in detail mode. In summary mode, it posts the net deposit as a lump sum and the breakdown disappears. Verify your A2X settings before assuming the app is doing the work.

2. December Sales Land in Your Bank in January

This cause distorts month-end and year-end numbers, and the gap widens during high-volume periods.

Shopify records a sale on December 30 the moment a customer completes payment. The payout for that sale typically reaches your bank on January 2, one to three business days later.

If QuickBooks pulls from your bank feed, it records the deposit in January. December revenue in QuickBooks is too low. January revenue is too high. Your year-end P&L is off by whatever revenue straddled the calendar boundary. During a Black Friday week, this timing gap can exceed $10,000.

The fix. Reconcile by payout period, not calendar month. Download the Shopify Payout Report for a specific payout date. Find the corresponding bank deposit — the amounts will match or nearly match. Record the income in QuickBooks using the payout date.

For cash-basis taxpayers, the payout date determines when you constructively received the money. For accrual-basis taxpayers, consult your CPA about accruing revenue at month-end. Either way, choose one method and apply it consistently across every payout.

3. Marketplace Facilitator Tax Inflates Your Revenue

This cause is easy to miss because the numbers look plausible — just slightly too high. Over a full year, the cumulative error can reach tens of thousands of dollars.

In most U.S. states, Shopify collects and remits sales tax on your behalf. When a California customer pays $109.25 for a $100 order, Shopify holds the $9.25 in tax and sends it directly to the CDTFA. Your payout is roughly $99.75 after fees. You never receive the tax.

But your Shopify order report lists the full $109.25 sale. If your sync app or manual import pulls the gross order total without stripping out marketplace facilitator tax, QuickBooks records $109.25 in revenue rather than $100. For a store generating $2 million in annual sales with 30% of orders shipping to facilitator-tax states, this overstates revenue by $40,000 to $60,000 per year.

The fix. In your Shopify Payout Report, locate the column labeled “Marketplace Facilitator Tax.” This amount was withheld and never reached you. It does not belong in your income accounts.

In A2X, verify the tax mapping settings. Marketplace facilitator tax should map to a clearing account or be excluded — not lumped into your sales income. If your books already contain a year or more of inflated revenue, this becomes a cleanup project, not a quick adjustment. Correcting the configuration now prevents the problem from compounding.

4. Redundant Sync Methods Double-Count Every Sale

This cause is the most common reason QuickBooks revenue is exactly twice what it should be.

The pattern repeats across dozens of cleanup engagements I’ve worked on: a store owner connects the native Shopify-QuickBooks integration at launch. Months later, their bookkeeper sets up A2X. Someone else imports a CSV manually. Nobody disables the old connections.

Now every Shopify order appears in QuickBooks two or three times. The bank feed also records each deposit. The same sale is represented four different ways.

A subtler version occurs when a single sync app posts by both order date and payout date. Each sale gets recorded when it occurs and again when the payout arrives, producing the same doubling effect with only one connector installed.

The fix. Select one pipeline and disable everything else.

• If you use A2X, disconnect the native Shopify sync: Gear icon > App Center > My Apps > Shopify > Disconnect.
• If you import manually, turn off all automated connections.
• If you use Connex or another connector, confirm it is the only active sync.

After changing your configuration, audit the previous 30 days in QuickBooks. Search for transactions sharing the same amount and date. Delete the duplicates created by your retired connection, and retain the entries from your chosen pipeline. Document which method is the source of truth so no one reactivates the old connector next quarter.

5. Shopify Fees Vanish from Your P&L

This cause hides in plain sight. Revenue looks reasonable. Bank deposits reconcile. But your profit and loss statement shows zero merchant processing fees — or a number that is obviously too small.

When a sync app posts only the net deposit as a single income entry, the fees were subtracted before the entry was created. They never appear as an expense. Your net income is technically correct, but your gross revenue is understated and your deductible processing fees are invisible.

The reverse scenario also occurs: gross sales post correctly to income, but fees land in “Uncategorized Expense” or a catch-all account. The fees exist somewhere in your file, but no one can locate them at tax time.

The fix. Confirm your sync app maps processing fees to a dedicated expense account. I use “Merchant Processing Fees” as a sub-account of “Bank Service Charges.” This should happen automatically for each payout.

Run a Profit & Loss report and examine your merchant fee account. If your store processes $50,000 per month and your Shopify Payments rate is 2.9% + $0.30 per transaction, expect approximately $1,450 to $1,750 in that account each month. A balance of zero or $200 signals a mapping error.

Do You Have One of These Problems?

You do not need to diagnose the technical cause to recognize the symptoms. Check the signs below. Two or more “yes” answers indicate your integration is failing — even if the connector reports a successful sync.

• Your clearing account never zeroes out. A Shopify Clearing account that carries a balance month after month signals payouts are not being broken down correctly.
• Your bank deposit matches no recorded payout. The money arrived, but QuickBooks cannot connect it to the Shopify payout that generated it.
• Revenue in QuickBooks exceeds the cash you received. You “made” $200,000 last quarter but your bank balance barely grew.
• Shopify fees are missing from your P&L. Your merchant fee expense account is empty or implausibly low.
• Refunds appear in Shopify but not in QuickBooks. A customer received a refund that is not deducted from your sales in QuickBooks.
• Your CPA asked you to reconcile Shopify to QuickBooks and you could not. This is the one that generates the call.

A Monthly Reconciliation That Actually Works

Once you understand the five causes, a repeatable workflow prevents them from recurring.

1. Step 1: Start with the Shopify Payout Report. Navigate to Finances > Payouts > Export. This report — not the revenue dashboard — is your source of truth. It lists gross sales, refunds, fees, marketplace facilitator tax, adjustments, and the net deposit amount for every payout.
2. Step 2: Match each payout to its bank deposit. Find the deposit in your bank feed that matches the payout amount and approximate date. If the amounts do not align closely, check for adjustments or fees you did not account for.
3. Step 3: Verify QuickBooks recorded each component. If QuickBooks shows a lump deposit but no breakdown of gross sales, refunds, and fees, your P&L is incorrect even if the total matches. Every component in the payout report needs a corresponding QuickBooks entry.
4. Step 4: Search for duplicates. In QuickBooks, look for any transaction appearing more than once with the same amount and date. Remove duplicates before proceeding.
5. Step 5: Repeat monthly, not quarterly. A sync error caught after 30 days takes roughly half an hour to fix. Caught after six months, it requires a multi-day cleanup involving journal entries, reclassified transactions, and a stressed CPA.

Fix It Yourself or Hire Help? A Quick Guide

If you sell a few products per month with simple fee structures, you can likely implement the workflow above yourself. Connect A2X in detail mode, verify the mappings once, and spend 15 minutes reconciling each month.

Hire an ecommerce-specialist bookkeeper if any of these apply:

• Shopify revenue exceeds $20,000 per month
• You sell across multiple channels (Shopify plus Amazon, wholesale, or retail)
• International sales create multi-currency payouts
• Your books have been questionable for six or more months
• Your CPA has flagged discrepancies they cannot resolve
• A Shopify Clearing account balance has been sitting since 2024

Ecommerce bookkeeping is a specialty for a reason. Integrations are powerful, but they are also the most common reason a small business’s QuickBooks file is materially wrong. I have opened files where revenue was overstated by six figures because of a single misconfigured sync. Early correction is inexpensive. Post-tax-season correction is not.

A Free 20-Minute Call

If your store matches any scenario above — mismatched numbers, missing fees, doubled revenue, a clearing account that will not clear — I can tell you in 20 minutes whether the fix is small or the cleanup is large, what it will cost, and how long it will take.

I will need read-only access to your QuickBooks Online file to provide a real estimate. You can revoke access with one click. I cannot withdraw money, pay bills, or modify anything.

[Book a Free 20-Minute Call →]

Palo Alto Bookkeeping is a solo practice by John Adams, specializing in QuickBooks Online cleanup, ecommerce bookkeeping, and ongoing monthly bookkeeping for Silicon Valley small businesses. This post provides general information and does not constitute tax or accounting advice.