Why your Amazon or Shopify payout never matches your sales
By Martin Elsworth, CPA, co-founder, Merchant Place Books
The deposit in your bank is not your sales and it is not your profit. It is what is left after the platform has taken fees, refunds, tax and reserves, on its own schedule.
A common mistake
A bookkeeper who isn't familiar with ecommerce will often post the deposit from Shopify or Amazon as sales.
Intuitively, it feels correct.
Yet fatal from an accounting accuracy point of view, and to tax-filing readiness.
That deposit has to be broken down into its parts:
- Gross sales
- Refunds and returns
- Referral and platform fees
- Payment processing fees
- Fulfillment and storage fees
- Shipping
- Chargebacks
- Other adjustments
- Sales tax, where applicable
And then, and only then, comes the net amount actually paid to you.
What is inside an Amazon settlement (illustrative figures)
- Gross product sales +$18,450.00
- Marketplace sales tax collected +$1,291.50
- Marketplace sales tax remitted -$1,291.50
- Referral fees -$2,767.50
- FBA pick and pack fees -$1,920.40
- FBA storage fee -$284.60
- Sponsored Products ads -$1,412.90
- Customer refunds and returns -$412.50
- FBA inventory reimbursements +$85.20
- SAFE-T claim reimbursements +$142.50
- Unavailable balance (reserve) -$1,200.00
- Net deposit $10,679.80
The reserve is the one that catches people out. It is your money held back by the platform, not an expense.
What is inside a Shopify payout (illustrative figures)
- Gross online sales +$9,240.00
- Collected sales tax +$646.80
- Collected shipping fees +$612.00
- Customer tips +$45.00
- Credit card processing -$285.71
- Chargeback fee and hold -$165.00
- App subscription billing -$89.00
- Bank deposit $10,004.09
How A2X fits in
For Shopify, Amazon, Walmart and other channels, A2X is the bridge between the selling platform and QuickBooks Online. When each settlement or payout is issued, A2X posts it to QBO as an accounting-ready entry, with every component in the right account and the net amount held in a clearing account. When the money lands in your bank, that deposit is matched against the entry and cleared. The posting is per settlement or payout, so the timing follows your platform's payout schedule, not the calendar month.
Your sales platform tells you what you sold. A2X tells QuickBooks where the money went, so your books show revenue, the detailed line items and the cash you actually received. This provides the right amount of detail to assist your CPA's tax prep.
It's all set up, automated and checked by us, without the hours every month you'd otherwise spend untangling the books instead of growing the business.
What to check in your own books
For every platform
- Does revenue equal gross sales, or what hit your bank?
- Are fees and ad spend recorded as expenses, not netted off your sales?
For Amazon
- Is the sales tax Amazon collects and remits recorded separately?
- Is the reserve shown as a balance held, not an expense?
For Shopify
- Are collected sales tax and customer tips kept out of revenue?
- Is the shipping you collect shown on its own line?
- Are processing fees and app charges recorded as expenses, not netted off your deposit?
- Is each payment gateway (Shopify Payments, PayPal, Stripe) reconciled on its own, with chargeback holds tracked until they are resolved?
If you prefer an outside check, the $95 Financial Diagnostic Review compares your books against your platform payout statements. The fee is credited to your first month's bookkeeping fee.