Why Your Shopify Deposits Don't Match Your Sales (and How We Fix It)

Disclosure: Tides Bookkeeping is an A2X partner, and we use A2X with a client's Shopify store today.

You open your Shopify dashboard and see one sales total. You open your bank and the deposits add up to something smaller, and the dates don't line up either. It's almost never a sign that money is missing. It's a sign that the books are recording payouts instead of sales.

Reason 1: Fees come out before you're paid

Payment processing fees are deducted before the payout reaches you. Depending on your setup, other app or channel charges may be taken out too. Your sales report shows the gross amount. Your bank shows what's left. If only the deposit is booked, those fees never show up as an expense, and your sales look lower than they were.

Reason 2: Refunds and chargebacks

A refund issued this week can come out of this week's payout, even though the original sale was last month. Chargebacks work the same way. The deposit is a mix of new sales and old reversals.

Reason 3: Timing

Payouts are batched. Sales from the 30th and 31st often arrive in the next month. A2X notes that settlements can span months, and that's what makes month-end totals drift. If the books follow the bank, one month looks light and the next looks heavy.

Reason 4: Sales tax and shipping are inside the deposit

The deposit includes sales tax you collected and shipping you charged. Sales tax isn't your income. You're holding it for the state. Shipping charged to customers is income, but it should be tracked separately from product sales so you can compare it with what shipping actually costs you.

Reason 5: Gift cards, discounts and other payment methods

Gift card sales are a liability until someone redeems them, and how unredeemed cards are treated varies by state, so check with your CPA. Discount codes reduce revenue. Orders paid through PayPal or another gateway arrive in a separate deposit altogether. A2X lists multiple payment gateways and sales channels as one of the main headaches of ecommerce accounting.

How we fix it

Here's our usual approach for a Shopify store:

1. Connect A2X to Shopify and your accounting software. According to A2X, it reads your payout data and breaks each payout into sales, fees, refunds, gift cards, taxes and other items.
2. Map the accounts once: product sales, shipping income, discounts, refunds, processing fees, sales tax payable and gift card liability.
3. Post summaries, not every order. A2X posts one journal per payout, dated by when the activity happened. That keeps months accurate and keeps your file light.
4. Match to the bank. Each journal total equals the deposit, so reconciliation becomes a quick match instead of detective work.
5. Review monthly. We check for unusual fees, uncleared balances and anything that doesn't map cleanly.

How we use A2X

Tides Bookkeeping is an A2X partner, and Daniel Cope is A2X certified. We use A2X with a client's Shopify store today, and it's part of how we close that store's books every month: payouts come in through A2X, each one is matched to the bank, and anything that doesn't fit gets looked at before the month is closed.

For a new store, we connect A2X to Shopify and QuickBooks, build the account mapping around how you actually sell, and check that the first payouts match your bank to the cent. If Shopify adds a new fee type, a refund lands strangely, or a payout doesn't match, we catch it in the monthly review instead of at tax time.

More on the partnership and the certification on our A2X page.

What you get out of it

Sales that match your dashboard, fees you can see and question, sales tax kept out of income, and month-to-month numbers you can trust when you're deciding on ad spend, pricing or a loan.

Common questions

Is it a problem if my bank deposits are lower than my Shopify sales?

Usually not. Fees, refunds and sales tax all explain the gap. The problem is when the books record only the deposit.

Can't I just record the payout as income?

You can, but your sales and expenses will both be understated, and sales tax will be counted as income. That makes margins and tax reporting unreliable.

How long does it take to clean up past months?

It depends on volume and how far back you need to go. A2X can often pull historical payouts. We can look at it with you in a free books review.