Bookkeeping for E-commerce: Reconciling Shopify, Amazon, and PayPal Without Duplicates
Selling on more than one channel creates a bookkeeping problem that pure service businesses never see: the same sale shows up in your books three or four times before it becomes money in the bank. Shopify records the order. Shopify Payments records the payout — minus fees. PayPal records its own transaction. Amazon settles on its own two-week cycle with referral fees and storage fees netted out. If your books record all of those as income, your revenue is inflated and your fees are invisible.
One sale, four records
A $100 order on Shopify typically becomes a payout of roughly $96 after processing fees. If your books show $100 of income and a $96 deposit, you either double-counted the sale or lost the fee. Multiply that across hundreds of orders and two extra channels, and your profit-and-loss statement stops describing reality.
The fix is a simple rule: record the sale where it happens, and record the payout as a transfer — not income.
The three-account pattern that works
Clean e-commerce books separate money into three places:
- A clearing account per channel (Shopify Payments clearing, Amazon settlement, PayPal) — this is where the sale and its fees land.
- The bank account — where payouts arrive.
- The books — where the payout is matched against the clearing balance, not counted again.
When a payout hits the bank, it matches against the clearing account. If the numbers agree, it's a transfer. If they don't, the difference is a fee, a refund, or a chargeback — and each has its own home in your books.
What breaks without it
- Inflated revenue — gross sales counted again as deposits.
- Invisible fees — processing and platform fees buried inside "transfers," so your margins look better than they are.
- Sales tax confusion — gross sales vs. after-tax deposits get muddled, which makes filings harder than they need to be.
- Reconciliation that never finishes — a bank feed that "almost" matches, month after month, until someone gives up.
What to do this week
- Create a clearing account in your books for each payment channel.
- Book channel sales and their fees into the clearing account — not straight to the bank.
- Match payouts against the clearing balance; investigate any payout that doesn't tie out.
- Reconcile the clearing accounts to zero at every month-end close.
That last rule is the whole game: a clearing account should return to zero once every payout has landed. If it doesn't, something is missing — usually a refund, a fee, or a payout still in transit.
When to hand it off
The pattern is simple; the daily discipline isn't. Multi-channel reconciliation is one of the most common reasons sellers move to outsourced bookkeeping — it's also a big part of what we handle for e-commerce and retail businesses. If your books are already tangled, catch-up bookkeeping clears the backlog first, so going forward is clean.
Curious what it would cost? Our pricing page shows every plan openly — from $250/mo, scaling with your expenses — or get your exact quote in about a minute.
Want this handled for you?
Our team runs this process for hundreds of businesses every month. Get accurate books without adding to your plate.
Keep reading
1099 Forms Are Due January 31 — Here's the Checklist That Saves You Penalties
Contractor payments over $600 need a 1099-NEC by January 31, and the penalties stack per form. Collect W-9s now, reconcile payments this month, and file before the deadline instead of paying for it.
Quarterly Estimated Taxes for California Small Businesses: A Calendar That Works
Miss a quarterly deadline and the IRS charges interest daily. The dates, the math, and the system that keeps California business owners penalty-free — without thinking about it monthly.