E-Commerce & Social Commerce Bookkeeping

Why Your Net Bank Payout Is Not Your Real Revenue

Selling products across multiple channels, whether through a Shopify storefront, an Etsy shop, Amazon, TikTok Shop, or direct Instagram messages, is fantastic for business growth. But behind the scenes, reconciling multi-channel income quickly turns into a financial headache.

Money rarely arrives line-by-line per sale; instead, it lands days later as a single, lump-sum bank deposit that has already been stripped of processing fees, shipping costs, and customer refunds. If you are simply booking those bank deposits as "income," you are making one of the most common e-commerce bookkeeping mistakes, one that inflates your apparent revenue and increases your annual tax bill.

1. The Payout "Math Game" (Why the Numbers Don't Add Up)

You open your Shopify or Stripe dashboard and see $1,500 in total sales for the week. But when you look at your bank account, the deposit is only $1,420.

Where did the missing $80 go? It was scattered across credit card processing fees, prepaid shipping labels, app commissions, and a partial refund.

• The Pain Point: Your bank feed only shows the net payout, not individual customer sales. To make sense of it, you have to log into multiple platform dashboards, download messy CSV spreadsheets, and manually play detective to match orders to a single deposit.
• The Dangerous Trap: If you record the $1,420 deposit as income, you fail to write off the $80 in platform fees and shipping expenses. Even worse, if you record the full $1,500 as gross revenue without logging the fee deductions separately, you end up paying income tax on money you never actually received.

2. Social Media DM Sales & Broken Inventory Ledgers

Modern social commerce isn't limited to traditional shopping carts. Many entrepreneurs run thriving operations by taking custom orders directly in DMs, issuing Stripe checkout links, or printing slips on portable thermal receipt printers.

• The Pain Point: A customer orders via Instagram, requests a return a week later, and you issue a manual refund through Stripe or e-transfer.
• The Reality: Because the transaction was handled off-cart, the paper trail breaks down. The bank ledger shows money leaving your account, but your inventory software still thinks the product was sold.
• The Result: Your Cost of Goods Sold (COGS) and actual monthly profit margins become completely skewed.

3. The Sales Tax Liability Trap (GST/HST & PST)

When selling through marketplace platforms or collecting sales tax on manual orders, the tax line inside your payout was never your income to keep.

• The Mistake: Counting collected sales tax as business revenue artificially inflates your income figures and leaves you scrambling when quarterly or annual sales tax remittances are due to the Canada Revenue Agency (CRA).
• The Fix: Sales tax collected at checkout must be categorized as a short-term liability from the moment it is charged, never as top-line revenue.

How Proper E-Commerce Bookkeeping Solves the Chaos

You don't need a massive system overhaul or a complicated new platform to fix your backend numbers. A structured bookkeeping workflow plugs directly into your existing setup to deliver audit-ready clarity:

1. Detailed Payout Unbundling: Every single bank deposit is split into gross sales, processor fees (Stripe, PayPal, Square, Shop Pay), shipping expenses, and refunds, with each item mapped to its dedicated account.
2. Channel-by-Channel Profit & Loss (P&L): See exactly which platform (TikTok Shop, Etsy, Shopify, or Instagram DMs) makes you real money after accounting for platform fees and returns.
3. Inventory & COGS Matching: Inventory purchases are tracked as assets on your balance sheet and released to Cost of Goods Sold in the exact month the item actually sells.
4. Payouts-in-Transit Reconciliation: Un-deposited payouts sitting in transit at month-end are accounted for so your general ledger agrees with your bank balance down to the penny.

Supported E-Commerce & Payment Platforms

We integrate directly with the platforms you already use to keep your backend organized without disrupting how you sell:

• Sales Channels: Shopify, Etsy, Amazon, TikTok Shop, Instagram & Facebook Shops, Squarespace Commerce.
• Payment Processors: Stripe, PayPal, Square, Shop Pay, and direct e-transfers.
• Accounting Platforms: QuickBooks Online & Xero.