When your Shopify revenue and your QuickBooks balance don't match

When your Shopify revenue and your QuickBooks balance don't match

A candle founder we worked with had a board meeting coming up and two different revenue numbers: one in Shopify, one in QuickBooks. His bookkeeper had left in January and nobody replaced her. By summer, six months of transactions sat unreconciled, and neither number was one he could defend in a room full of investors.

The numbers weren't wrong, exactly. They just disagreed. And in that situation, both are useless.

This happens more often than you'd think. For product businesses running Shopify alongside PayPal or another payment processor, a discrepancy between your e-commerce platform and your accounting software is almost never a math error. It's a setup problem. This post explains why the gap exists, what it costs to leave it alone, and how to fix it.

This scenario is drawn from real conversations with Pilot customers.

Why do Shopify and QuickBooks show different numbers for the same month?

Shopify records revenue when a customer places an order. QuickBooks, depending on how it was configured, may record that same transaction when payment settles, when the payout lands in your bank account, or not at all if the integration was never set up right. For a business processing orders every day, that timing difference builds fast.

The amount gap is a separate problem. Shopify bundles multiple orders into a single payout and deducts fees before depositing. If QuickBooks is importing individual gross transactions instead of reading Shopify's finance summary, it records the pre-fee number while your bank shows the post-fee deposit. Neither figure is technically wrong. They're measuring different things, so they'll never agree.

Add PayPal on top of Shopify Payments and the problem multiplies. Two processors, two payout schedules, two fee structures, two import behaviors. Your books can be recording every transaction correctly and still be impossible to reconcile against your bank.

What does a six-month backlog cost you?

Time first. Then credibility.

When a bookkeeper leaves mid-year and no one fills the role, transactions accumulate without being categorized or checked. By the time the pressure arrives (a board meeting, a tax deadline, a loan application), months of data need to be reconstructed from context that may not exist anymore: which store was active, whether the PayPal connection was live, how refunds were being handled.

Investors and board members reviewing your financials want to know those numbers reflect what happened. Unreconciled books, even when every transaction is technically in the system somewhere, don't give anyone that confidence. Owners who have been here describe it the same way: the books weren't wrong, exactly. They just couldn't be trusted. That's a harder problem than being wrong.

Why does PayPal cause so many bookkeeping problems?

Because accounting software treats it like a bank account, and it isn't one.

When PayPal is connected via automation, it imports individual transactions at the gross amount, before fees are deducted. Your bank receives the net amount after fees. Without a reconciliation layer between those two figures, you'll overstate revenue and understate expenses by exactly the amount of PayPal's fees, every month, with no obvious signal that anything is off.

Disconnecting the automation shifts the problem rather than solving it. Every PayPal transaction then requires manual entry: download the transaction report, match each payment to an order, account for refunds and disputes, enter net figures into QuickBooks by hand. For a business processing a meaningful volume of orders, that's a high-effort recurring task with a high error rate. The fix is to treat PayPal as its own sub-ledger with its own reconciliation process, not just another bank feed to connect and forget.

How should you set up Shopify and QuickBooks to work together?

Pick one authoritative source and build everything around it.

For most Shopify-based product businesses, the Shopify finance summary is the right foundation. It's already net of platform fees, it matches your bank deposits, and it gives you a clean, reconcilable figure for each payout period. Configuring QuickBooks to import individual transactions directly from Shopify creates a gross figure that will never match your bank statement. There is no clean fix for that gap.

Your chart of accounts needs to match the business you run. One revenue line isn't enough. Direct sales, shipping income, and a membership program each tell you something different, and they need separate accounts to tell you anything useful. That's what lets you answer a board question or a pricing question without pulling up three reports and doing math on a whiteboard.

If the integration was never right to begin with, or if a previous bookkeeper built it around assumptions that no longer hold, start with the chart of accounts, not the transactions. Fix the structure, then reconcile in order: January before February, every month forward. That's the only path to clean books without piling new errors on top of old ones. Pilot's bookkeeping service handles exactly that sequence, including Shopify and payment processor integration for Core plan customers. The e-commerce bookkeeping guide on the Pilot blog covers the broader landscape if you're evaluating your setup from scratch.

What do trustworthy books look like at month-end?

You should be able to trace any number in any report back to a source document.

For a Shopify-based business, that means the revenue in QuickBooks ties to the Shopify finance summary, which ties to your bank deposit. Each layer confirms the one beneath it. PayPal has its own sub-ledger, reconciled separately against its own payout reports. The chart of accounts is segmented enough to show what each revenue stream contributed without digging.

None of that requires new software. It requires the right setup, once, and consistent maintenance from there.

KEY TAKEAWAY

The gap between Shopify and QuickBooks is a setup problem, not a math problem. Use the Shopify finance summary as your authoritative source, build your chart of accounts around it, and give PayPal its own reconciliation process. Do that and the two numbers will agree every month.