Accounting Tips for Ecommerce Sellers

Why ecommerce bookkeeping is different

Selling online looks simple from the customer's side, but the money trail behind it is not. A single order can involve a sale price, a shipping charge, a marketplace commission, a payment-processing fee, tax collected, and — days or weeks later — a possible refund. Multiply that across two or three sales channels and a couple of warehouses, and a shoebox of receipts turns into a genuine accounting puzzle.

The core problem is that the cash landing in your bank is almost never the same as the sales you actually made. Platforms pay you the net figure after they've taken their cut. If you record only what hits your account, your revenue looks too low, your expenses disappear, and your tax numbers drift out of line. Good ecommerce bookkeeping is really about pulling that netted-out payout back apart into its true pieces.

Record gross sales, not net payouts

The golden rule for online sellers: your revenue is what the customer paid, before anyone took a fee. Book the full sale as income, then record each cost — commission, listing fee, payment processing, shipping labels — as its own expense line.

This matters for two reasons. First, it gives you a true gross margin, so you can see how much each channel actually costs you to sell on. Second, it keeps your tax figures honest, because in most countries the tax you owe is calculated on gross sales, not on the trimmed-down amount that reaches your bank.

• Gross sale price = revenue.
• Platform commission, listing and referral fees = selling expenses.
• Payment-gateway/card fees = a separate finance expense.
• Shipping you charged the customer = income; shipping you paid the carrier = expense.
• Tax collected = a liability you hold and later remit, not your money to keep.

Reconcile every marketplace payout line by line

When a marketplace deposits, say, a fortnightly payout, that single number usually bundles dozens of orders, a handful of refunds, all the fees for the period, and sometimes an advertising charge or a reserve adjustment. Booking it as one 'sales' entry hides all of that.

Instead, treat each payout as a mini bank statement. Break it into its components so the deposit in your books matches the deposit in your bank to the cent. Most platforms give you a settlement or transaction report you can download to do exactly this.

1. 1

   Pull the settlement report

   Download the payout/settlement statement for the period from each channel.

2. 2

   Split the total

   Separate it into gross sales, refunds, commissions, payment fees, shipping and any ads or adjustments.

3. 3

   Post each component

   Record sales as income and every fee as its matching expense, dated to the payout.

4. 4

   Match to the bank

   Confirm the net of all those lines equals the actual deposit — if it doesn't, hunt the difference before you close the period.

Keep stock accurate across every warehouse

If you hold stock in more than one location — a shop stockroom, a fulfilment warehouse, a third-party depot — you need to know what's where, not just how much you own in total. Selling the same SKU across several channels makes this harder, because two channels can sell your last unit at the same time.

For the books, inventory is money sitting on a shelf. Every sale should reduce stock and record the cost of goods sold; every purchase or transfer should update the location it landed in. Counting stock per warehouse keeps your inventory valuation right and stops the classic ecommerce trap of overselling items you no longer physically have.

• Track quantity and cost by SKU and by location, not just company-wide.
• Deduct cost of goods sold at the moment of each sale so margins stay real-time.
• Do periodic stock counts and post the adjustment — shrinkage and damage are real costs.
• Record inter-warehouse transfers so no location shows phantom stock.

Handle returns and refunds properly

Returns are where a lot of online sellers' books quietly go wrong. A refund isn't just money going out — it's a sale being reversed. If you only record the cash leaving, your reported sales stay too high and your profit looks better than it is.

Do it in two halves. Reverse the revenue (and any tax you'd collected on it), and, if the item comes back in sellable condition, return it to stock at its original cost. If the goods are damaged or discarded, write them off as a loss instead of adding them back. Keeping refunds tied to their original order also makes your channel-by-channel return rate visible, which is useful for spotting problem products.

Get sales tax, VAT or GST right from the start

Tax rules for online sellers vary a great deal by country, and sometimes by where your customer is rather than where you are. Depending on your market you might deal with sales tax, VAT, GST or SST, with different registration thresholds and filing schedules. Marketplaces increasingly collect and remit some of this on your behalf, which changes what you still need to report yourself.

The safe approach is to separate tax you collect from your own income the moment a sale happens, keep it aside as a liability, and file on time. Keep clean records of what each channel collected versus what it remitted for you, so you're not paying twice or missing a gap.

This is general information, not tax advice — rules, rates and thresholds change and differ by country. Confirm your current obligations with the relevant country's tax authority or a qualified local tax professional before you file.

Let one connected system do the stitching

Most of the pain above comes from data living in separate places — sales in each marketplace, fees in settlement reports, stock in a spreadsheet, and the numbers finally re-typed into accounting software. Every hand-off is a chance to make a mistake.

This is where an all-in-one platform earns its keep. Tallium AI brings POS, inventory, e-commerce and accounting into a single app, so a sale updates stock and the books at the same time, and receipts and fees can be scanned and categorised automatically by its AI. Every plan includes unlimited users at no per-seat cost, on one simple flat price in USD, billed monthly with no free trial — a shop/store unit is $79/month and a warehouse unit is $99/month, for example. The point isn't the tool for its own sake; it's that fewer disconnected systems means fewer reconciliation headaches at month-end.