Shopify, Amazon, Stripe Bookkeeping: 7 Errors to Fix in 2026

Why the deposit never equals the sale

Three different numbers describe the same order, and they never match.

• Gross sale. What the customer paid, including shipping and sales tax.
• Net payout. What the platform sends to your bank after fees, refunds, chargebacks and reserves.
• Reported gross. What the platform tells the IRS on Form 1099-K.

Each platform widens the gap differently. Shopify Payments deducts processing fees before the payout lands. Amazon bundles roughly two weeks of sales, refunds, referral fees, FBA fees, advertising and reserves into one deposit on a standard 14-day settlement cycle. Stripe deducts its fee per charge and pays out on a rolling schedule.

The result is the same everywhere: one bank line hides dozens of accounting events.

Error 1: Booking the net payout as revenue

This error survives for years because the profit line still looks plausible.

Say you sell $10,000 on Stripe across 200 orders. Stripe's standard US rate is 2.9% + 30¢ per successful domestic card charge, so fees are about $350 and the deposit is about $9,650. Record $9,650 as revenue and two things break at once:

• Revenue is understated by $350.
• Processing fees of $350 are never recorded as an expense, so you lose the deduction.

Net profit looks correct. Every line above it is wrong. The damage shows up when the 1099-K arrives reporting close to $10,000 in gross payments, and your books say $9,650.

Error 2: Fees that never appear on your bank statement

Fees you never see are still deductible expenses. On the three platforms, the ones that most often go missing are:

• Stripe: an extra 1.5% on international cards, 1% when currency conversion is required, 0.5% on manually entered cards, and $15 for each dispute received (Stripe pricing page).
• Shopify Payments: online card rates run from 2.5% to 2.9% plus 30¢ depending on plan, plus a currency conversion fee of 1.5% for US stores and 2% for stores elsewhere (Shopify, January 2026).
• Amazon: referral fees, FBA fulfillment and storage fees, advertising and long-term storage, all netted inside the settlement before disbursement.

To size the effect: on $500,000 of annual volume, an unrecorded surcharge stack of 0.4 percentage points is $2,000 of lost deductions in a year. That is an illustration, not a benchmark. Your real number depends on your card mix.

Error 3: Refunds and chargebacks recorded as negative sales

A refund is not a reversed sale. It is a contra-revenue event, and it usually costs you money on top of the refunded amount.

Stripe states that for standard pricing, processing fees from the original transaction are not returned when you refund. So a refunded $100 order does not return you to zero. You are out the original processing fee. Disputes cost more: Stripe charges $15 for each dispute received, and PayPal's chargeback fee is $20 per incident.

Netting refunds against sales also destroys your return rate. If both sit in one account, you cannot tell whether returns are 2% or 20% of volume, and that number decides whether a SKU is profitable.

Error 4: Sales tax sitting inside your revenue account

Sales tax collected is a liability, not income. Booking it as revenue inflates your top line and hides what you owe. The rules differ by platform, and this is where most multichannel sellers get caught.

• Amazon is a marketplace facilitator. Under Marketplace Tax Collection, Amazon calculates, collects and remits state sales tax on third-party sales. All 45 states with a general sales tax, plus the District of Columbia, have marketplace facilitator legislation on the books.
• Shopify is not a marketplace facilitator. Its Help Center is explicit: tax is your responsibility, and Shopify does not remit or file your taxes for you unless you use Shopify Tax with automated filing enabled.

So the same dollar of tax is handled two different ways. Tax Amazon collects and remits generally passes through without becoming your liability, with one caveat: Amazon states that in certain states, some local taxes fall outside facilitator legislation and are not its responsibility. Shopify tax lands in your payout and stays your liability until you file.

Error 5: Mixing order date with settlement date

Amazon's Business Reports are built on order date. Amazon's settlement reports are built on posted date. Pull one for the P&L and the other for reconciliation and your month will never close.

The gap is structural. A 14-day settlement cycle almost always straddles a month end, so part of every period sits in a settlement that has not closed. Refunds and reserve movements widen it further. Shopify and Stripe have the same problem in smaller form, because a charge captured on the 31st is paid out in the following month.

Error 6: No COGS entry, so gross margin is fiction

If you record sales but never move inventory to cost of goods sold, your gross margin is just your revenue line. This is common because inventory is the one number no platform calculates for you.

It matters most for FBA sellers. Inventory sits in Amazon warehouses across multiple states, it moves without you touching it, and it is still your asset until it sells. Note that not every tool handles this: A2X's entry-level Shopify plan at $29 per month does not include the cost of goods sold feature, which starts on the $45 plan (A2X pricing page, checked July 2026).

Error 7: Currency conversion treated as a rounding difference

Cross-border sales create two accounting events, and sellers usually record neither: the conversion cost, and the exchange difference between sale date and payout date.

Stripe's surcharges stack: base 2.9% + 30¢, plus 1.5% for an international card, plus 1% if conversion is required. That is 5.4% + 30¢ in the worst case, not 2.9%. Shopify applies its own conversion fee of 1.5% or 2% depending on store region.

If you post only the converted deposit, both the surcharge and the FX movement disappear into revenue. Your international margin then looks identical to your domestic margin, which it is not.

Reconciliation tools compared

All four tools do the same core job: they read the platform settlement, split it into its components, and post a summary journal entry to QuickBooks Online or Xero that reconciles exactly to the bank deposit. They differ in pricing basis and scope.

Prices verified against vendor pricing pages in July 2026. Vendors change tiers often, so confirm before you buy.

How to choose your approach

Work through these criteria in order. The first one that applies decides your answer.

1. Do you sell on more than one channel? If yes, run the multichannel math before choosing. Per-channel pricing is what turns a $29 subscription into $150.
2. Do you hold physical inventory? If yes, COGS support is not optional. Skip the entry tiers that exclude it.
3. How many orders per month? Under roughly 200 orders on one channel, a careful manual journal entry is defensible. Above that, manual work costs more in bookkeeper hours than the software.
4. Do you sell cross-border? If yes, prioritize multi-currency and tax mapping over price.
5. Who does the monthly close? If an external bookkeeper does it, ask which tool they already run. Their familiarity beats a $20 monthly difference.
6. What is your accounting system? These tools center on QuickBooks Online and Xero. Confirm support before comparing anything else.

A practical rule: if your bookkeeper spends more than two hours per settlement and you have two settlements a month, a reconciliation tool pays for itself in the first month.

Sources and references

• Stripe Pricing and Fees — US rates, surcharges, dispute and refund fee treatment (stripe.com/pricing).
• Shopify, The Average Credit Card Processing Fees for 2026 — Shopify Payments rates by plan, conversion and chargeback fees.
• Shopify Help Center, Taxes — Shopify does not remit or file unless automated filing is on.
• Amazon, Marketplace Tax Collection — scope of Amazon's collection and remittance duties.
• IRS, Form 1099-K FAQs: General Information — treatment of the Box 1a gross amount.
• IRS, IR-2025-107 — threshold restored to $20,000 and 200+ transactions.
• Avalara, State-by-State Guide to Marketplace Facilitator Laws — facilitator legislation by state.
• A2X for Shopify Pricing — tiers, order limits, COGS availability.
• Link My Books, 2026 Price Changes — pricing update effective 1 July 2026.