Shopify and Amazon Payouts Do Not Match Your Bank: How CPG Brands Reconcile Them

Last updated November 2026.

The short answer

Shopify and Amazon payouts do not match your bank, or your sales report, because a payout is a net, batched, delayed number. Fees, refunds, chargebacks, reserves, and platform charges come out first, and the deposit lands days after the sales it pays for. To reconcile, run every channel through its own clearing account: record gross sales and each deduction from the platform report, record the deposit from the bank, and the balance left over must equal what the platform still holds.

Why doesn't the payout match the bank deposit?

The payout does not match because the platform is not paying you for your sales. It is paying you its balance: what customers paid, minus everything the platform kept, on the platform's schedule rather than your calendar's. Shopify's own help center says the Shopify Payments activity report "isn't a statement of revenue for accounting purposes," and that its totals for a date range "might not match your bank deposits for the same period." Amazon works the same way, with a longer hold.

Every gap between a sales report and a bank deposit traces to one of the items below. The work of reconciliation is naming which one, in dollars, every month.

The mistake that makes all of this invisible is booking each deposit as "sales." The books balance, the bank reconciles, and every line above disappears into one revenue number that is too small and cannot be explained. Our post on e-commerce books a buyer can trace to the payout report covers what that costs you in a sale. This post is the month-end mechanics that prevent it.

What is a clearing account, and why does every channel need one?

A clearing account is a balance sheet account that holds money the platform owes you between the moment a sale happens and the moment the cash reaches your bank. Sales and deductions go in from the platform's report. Deposits come out from the bank feed. Whatever is left at month end is real: it is the balance Shopify or Amazon is still holding for you, and it should match the platform's own ending balance to the dollar.

Each channel gets its own clearing account: one for Shopify Payments, one for Amazon, one for PayPal, one for each buy now pay later provider, one for any wholesale portal that pays net of fees. Combining them hides which platform is short. Shopify's activity report is separate per payout currency, so a brand paid in more than one currency needs one clearing account per currency as well.

How do you reconcile a Shopify payout, step by step?

You reconcile a Shopify payout by working from the platform's records to the bank, never the other way around.

1. Pull the period summary. In Shopify admin, go to Finance, then Documents, then the Shopify Payments activity report, and set the date range to your month. It shows starting balance, gross store earnings, fees, payouts, and ending balance, with activity grouped into charges, refunds, disputes, reserves and holds, shipping, Shopify Capital, and other categories.
2. Book gross, then each deduction. Record gross charges as sales, and each activity group to its own account from the table above. Do not book the net.
3. Match each payout to a deposit. From the Payouts page, each payout has its own transaction export with amount, fee, and net columns. Match each payout to one bank deposit. Payments captured Friday through Sunday arrive as a single payout, so expect fewer deposits than selling days.
4. List what is in transit. A payout marked Deposited can take your bank 1 to 3 business days to post. A payout sent on the last business day of the month is a deposit in transit, not a missing deposit.
5. Tie the ending balance. The clearing account's ending balance, less anything in transit, should equal the activity report's ending balance. Move reserves and holds to a reserve receivable account so they do not sit in clearing looking like a mistake.
6. Reconcile the other processors separately. The Shopify Payments activity report does not include third-party processors or payment methods such as Afterpay, and it does not include Shopify billing fees. Each of those gets its own clearing account and its own tie-out.
7. Wait for the data. Shopify's activity report has a 3-day data delay, so close the clearing account on day 4 or later, not day 1.

In the United States, Shopify's minimum settlement time is 3 business days, newer stores often start longer, and Shopify says payouts typically reach the bank 3 to 5 business days after a payment is captured. Those few days are exactly why month end never matches.

What does a month-end Shopify tie-out look like in dollars?

Here is one month of a Shopify Payments clearing account for an illustrative CPG brand doing about $180,000 a month online. Every figure is illustrative arithmetic, not a benchmark.

Then the bank side. One payout of $3,600 was sent September 30 and landed October 1. One payout of $4,250 was sent October 31 and landed November 3. So October's bank deposits from Shopify were $3,600 plus $168,955 minus $4,250, or $168,305.

If you had booked deposits as sales, October revenue would read $168,305. Gross sales were $184,300. That is a $15,995 gap, almost 9 percent of the month, and every dollar of it has a name in the table above. A margin built on the deposit number understates sales and hides refunds, fees, and chargebacks inside it, which is the same problem as the gross-to-net waterfall on the retail side.

How is Amazon different?

Amazon is different because it holds the money longer and reports it in settlement periods that cut across your month. Under the Delivery Date Based Reserve, which Amazon told North American sellers it would apply starting March 12, 2026, funds from an order become available for disbursement seven days after Amazon confirms delivery. Amazon's own example: an order placed January 1 and delivered January 3 becomes available January 11. Amazon also said the move could cause a one-time cash flow impact around each seller's migration date.

That creates three stages for the same dollar, and your books need to see all three:

1. Deferred. The order has shipped, and the funds sit in your deferred transaction amount.
2. Reserved. The order has been delivered, and the funds wait out the seven days.
3. Available, then disbursed. The funds move to your available balance and go out with the next disbursement.

Which Amazon reports do you need at month end?

Amazon gives you three payment reports, and each answers a different question:

• Settlement report: what was in one disbursement. Use it to match the deposit.
• Date range report: what happened inside your calendar month, regardless of settlement period. Use it to book sales, refunds, and each fee type for the month.
• Deferred transactions report: what Amazon is still holding. Use it to support the clearing account's ending balance.

How do you split a settlement that crosses month end?

You split a settlement that crosses month end by booking the month's activity from the date range report and letting the clearing account carry the rest. If a settlement runs October 22 to November 5, the October 22 to 31 activity goes into October's books from the date range report, and the November 1 to 5 activity goes into November's. The deposit itself, whenever it lands, only clears the account. Booking the whole settlement in the month it was paid moves revenue and fees into the wrong month every time, and the error is largest in your busiest months.

Amazon's fees also stack more than Shopify's: referral fees, fulfillment fees if you use FBA, storage, inbound placement, advertising if it is charged to the seller account, and reimbursements coming back the other way. Give each its own account by channel, so you can see the cost of selling on Amazon instead of one net number.

What does DD+7 do to cash?

DD+7 adds days to your cash conversion cycle, and the money it holds grows with your sales. The arithmetic is simple: if Amazon sells $5,000 a day for you, seven extra days in reserve is about $35,000 that is earned but not in your bank. Add transit time before delivery and bank processing after disbursement, and the gap between the sale and the deposit can run past two weeks.

That matters most in Q4, when you are buying inventory for the season with cash that is still sitting at Amazon. Put the deferred and reserved balances into your forecast as their own line, so the forecast shows when that cash actually arrives. Our guide to the CPG cash conversion cycle shows how to measure the full gap from paying your co-packer to collecting from every channel.

How often should a CPG brand reconcile payouts?

Reconcile every channel at least monthly, as part of the close. Our rule of thumb is to go weekly once online sales pass about $100,000 a month or you sell on more than two platforms. Weekly matching is not extra work; it is the same work in smaller pieces, done while the exceptions are still easy to trace. A missing payout found in week one is a support ticket. Found three months later, it is an unexplained balance that nobody can source.

Connector apps that pull Shopify and Amazon data into QuickBooks or Xero help, but they do not replace the tie-out. A connector can post the summary correctly every day and still leave the clearing account drifting because of one reserve, one failed payout, or one processor it was never set up to read. Someone has to look at the ending balance every month and prove it.

If you also sell wholesale or into retail, the DTC to retail shift adds a second set of deductions with the same problem: the cash that arrives is net, and the books need the gross.

Where Thryve fits

Thryve Together, the CPG accounting and fractional CFO firm in McKinney, Texas, works with e-commerce and retail brands at every stage, from emerging to established. Our bookkeeping and monthly accounting work sets up a clearing account for every channel, books gross sales and each deduction from the platform reports, and ties every clearing account to the platform's ending balance before the month closes. Our CPG accounting work carries that into channel margin, so you can see what Amazon actually costs next to Shopify and retail.

Thryve is not the right fit if you need someone to manage your Amazon account, open seller support cases, or run your ads; that is a marketplace agency. And if your clearing accounts have not tied out in months, the foundation work comes first: rebuilding each channel's history from the platform reports before the monthly tie-out can hold.

Get books you can actually make decisions from.

FAQ

Why is my Shopify payout less than my sales?

Your Shopify payout is less than your sales because Shopify deducts processing fees, refunds, chargebacks and dispute fees, any reserve or hold, and any other charges against your balance, such as shipping labels or Shopify Capital remittances, before it pays out. Timing also shifts sales between payouts, since payments captured Friday through Sunday arrive as one payout. Shopify's activity report shows each of these by group for any month. The exact mix depends on your plan, your payment methods, and your account's settlement schedule, so check the payout's own transaction export before assuming money is missing.

Should I record Shopify or Amazon sales at gross or net of fees?

Most growing CPG brands record platform sales at gross, with fees, refunds, and chargebacks in their own accounts, because that shows the real size of the business and the real cost of each channel, and it is what lenders and buyers expect to trace. Recording only the net deposit hides those costs inside revenue. The right presentation for your financial statements, especially for marketplace sales, depends on the platform terms and on accounting policy decisions your accountant should make with you, so treat this as the default to discuss, not a ruling for your situation.

How long does Amazon hold my money under DD+7?

Under the Delivery Date Based Reserve, Amazon holds funds for seven days after it confirms delivery, then moves them to your available balance for the next disbursement. Amazon's own example is an order delivered January 3 becoming available January 11. Your total wait from order to bank deposit also includes transit time before delivery and bank processing after disbursement, and Amazon can apply a longer reserve to some accounts. Check the deferred transactions report in Seller Central for your actual held balance, since your account's reserve settings may differ from the standard.