Learn how to manage ecommerce bookkeeping across multiple sales channels — from tracking marketplace fees and reconciling payouts to choosing the right accounting software and avoiding costly mistakes.
Running an online store is one thing. Keeping its books in order is another problem entirely — especially when you sell on multiple platforms. Every marketplace pays you on a different schedule, deducts its own fees in its own format, and sends payout reports that rarely match what your accounting software expects. A single order on Shopee might involve a commission fee, a payment processing fee, a shipping subsidy, and a buyer voucher deduction, all netted into one payout line item days later. Multiply that across Lazada, TikTok Shop, Amazon, and your own Shopify store, and you have a reconciliation puzzle that most small sellers simply ignore — until tax season arrives.
This guide walks you through how to set up and maintain a clean bookkeeping system for your ecommerce business, with a particular focus on the challenges multichannel sellers face every day.
Ecommerce bookkeeping is the process of recording, categorising, and reconciling all financial transactions generated by an online selling business. At its core, it involves the same principles as traditional bookkeeping — tracking income, expenses, and liabilities — but the operational reality is far more complex.
A physical retailer has one point-of-sale system and one bank account to reconcile. An ecommerce seller managing three marketplaces and a webstore might deal with:
The goal of ecommerce bookkeeping is to turn this chaos into a clear financial picture — one that tells you your actual profit margins, your true cost of goods sold, and your tax obligations.
Actionable Insight: If your current bookkeeping amounts to checking your marketplace dashboard balance, you are not doing bookkeeping — you are guessing. Dashboard figures show gross sales, not profit. They exclude costs like packaging, returns, and advertising that eat into your margins.
Many online sellers treat bookkeeping as an annual inconvenience — something to sort out before filing taxes. This approach hides problems until they become expensive.
Without accurate books, you cannot answer basic business questions:
Marketplace payouts follow different schedules. Shopee typically pays every two weeks, Lazada operates on a weekly cycle after a holding period, and Amazon settles every 14 days. Without tracking these payout cycles in your books, you might think your business is flush when in reality that cash belongs to orders already fulfilled but not yet paid out.
Tax authorities do not care that marketplace reporting is confusing. If you sell goods, you owe accurate records. In Singapore, businesses exceeding S$1 million in annual revenue must register for GST. In the US, economic nexus laws mean you may owe sales tax in states where you have never set foot. Clean books make compliance straightforward; messy books make it a nightmare — and potentially very expensive.
If you ever need external funding, a line of credit, or want to sell your business, buyers and lenders will want auditable financial records. A Shopee dashboard screenshot will not suffice.
Let us break ecommerce bookkeeping into the concrete tasks you need to perform regularly.
The most common mistake sellers make is recording the marketplace payout as revenue. This is wrong. Revenue should be the gross sale amount — what the customer paid. Marketplace fees, commissions, and shipping subsidies are separate expense or contra-revenue line items.
Example: A customer buys a product for $50 on Shopee. Shopee deducts a 6% commission ($3), a 2% payment processing fee ($1), and a $1.50 shipping subsidy clawback. You receive $44.50 in your payout.
| Entry | Amount |
|---|---|
| Revenue (gross sale) | $50.00 |
| Less: Shopee commission (6%) | -$3.00 |
| Less: Payment processing fee | -$1.00 |
| Less: Shipping subsidy clawback | -$1.50 |
| Net payout received | $44.50 |
If you only record $44.50 as revenue, you are understating your sales and hiding fee expenses — which distorts your margin analysis and could create tax issues.
COGS is the direct cost of producing or purchasing the products you sell. It includes:
COGS should be calculated per SKU or per unit, not as a monthly lump sum. This lets you identify which products generate healthy margins and which ones are silently bleeding cash.
Actionable Insight: If you source internationally, your COGS fluctuates with exchange rates and shipping costs. Update your unit costs quarterly at minimum. A product that was profitable at USD/SGD 1.30 might not be at 1.38.
Every marketplace has a different fee structure, and most charge multiple fee types per transaction:
| Marketplace | Commission | Payment Fee | Other Common Fees |
|---|---|---|---|
| Shopee | 2-6.5% | 2% | Shipping fee, campaign fees |
| Lazada | 1-6% | 1.5-2% | Campaign fees, penalty fees |
| TikTok Shop | 2-8% | 1% | Shipping subsidy |
| Etsy | 6.5% | 3-4.5% | Listing fee ($0.20/item) |
| eBay | 10-15% | 0% | Insertion fees above free allowance |
| Amazon | 6-45% | 0% | FBA fees, storage fees |
| Shopify | 0% | 2.4-2.9% | Monthly subscription |
Track these as individual expense categories in your accounting software — not as a single “marketplace fees” bucket. This granularity lets you compare platform profitability.
Returns create bookkeeping headaches because they require multiple entries:
For sellers with return rates above 5%, returns can meaningfully impact monthly profit figures if not tracked properly.
Payout reconciliation is the most time-consuming bookkeeping task for multichannel sellers. Each marketplace bundles multiple orders into a single bank deposit, and the payout amount reflects gross sales minus all fees, refunds, and adjustments.
The reconciliation process:
Doing this manually across three or four platforms is realistic for small sellers processing fewer than 100 orders per month. Beyond that, automation becomes essential.
If you are starting from scratch or reorganising a messy set of books, here is a step-by-step approach.
The two dominant choices for small-to-medium ecommerce businesses are:
Both integrate with marketplace connector tools like A2X that automatically pull settlement data from Amazon, Shopify, and eBay into your accounting software.
What to look for:
Your chart of accounts is the backbone of your bookkeeping system. For ecommerce sellers, you need more granularity than a typical small business:
Revenue accounts:
COGS accounts:
Fee accounts (expenses):
Other expense accounts:
Separating revenue and fees by marketplace is critical. It is the only way to calculate true platform-level profitability.
Manual data entry is a recipe for errors and burnout. Automate where possible:
Actionable Insight: If you sell on Southeast Asian marketplaces (Shopee, Lazada, TikTok Shop), check whether your accounting connector supports these platforms. Many tools like A2X focus primarily on Amazon, Shopify, and eBay. For SEA sellers, you may need to combine a multichannel hub with manual settlement report downloads.
Consistency matters more than frequency. Choose a schedule and stick to it:
| Business Size | Recommended Frequency | Why |
|---|---|---|
| < 100 orders/month | Monthly | Low transaction volume, manageable manually |
| 100-500 orders/month | Weekly | Enough volume that errors compound quickly |
| 500+ orders/month | Daily or every 2 days | Missing a week means hundreds of unreconciled transactions |
Every reconciliation session should answer: Does the money in my bank account match what my books say should be there? If not, find the discrepancy before moving on.
Selling on a single marketplace is manageable. Selling on three, four, or five platforms simultaneously creates bookkeeping complexity that scales non-linearly.
Consider a seller operating on Shopee, Lazada, TikTok Shop, and their own Shopify store. Every week, they need to:
The time required to maintain accurate books roughly doubles with each additional sales channel. This is why sellers who expand from one to three marketplaces often see their bookkeeping fall apart within the first quarter — the manual processes that worked at low volume simply do not scale.
Each marketplace holds your money for a different period before releasing it:
| Marketplace | Typical Payout Cycle | Holding Period |
|---|---|---|
| Shopee | Bi-weekly | 7-15 days after delivery |
| Lazada | Weekly | 7 days after delivery confirmation |
| TikTok Shop | Weekly | 15 days after delivery |
| Amazon | Bi-weekly (every 14 days) | Up to 14 days |
| Shopify | Daily to weekly | 2-3 business days (Shopify Payments) |
This creates timing mismatches in your books. On any given day, you might have thousands of dollars in earned but unreceived revenue sitting across different platforms. If you use accrual accounting (which you should for any serious ecommerce business), you need to record revenue when the sale occurs, not when the payout arrives.
Beyond standard commissions, each marketplace has fees that catch sellers off guard:
If you do not track these granularly, your profit calculations will be off — sometimes by 5-10% of gross revenue.
When you sell the same product on multiple platforms at different prices, inventory valuation gets tricky. Most small sellers use weighted average cost — the total cost of inventory divided by the number of units on hand. This method smooths out price fluctuations from different supplier orders.
But you also need to decide: do you maintain one inventory pool or separate pools per channel? If you use a shared inventory model (where one warehouse serves all marketplaces), a single pool makes sense. If you allocate specific stock to specific channels, you may want per-channel tracking.
A multichannel inventory management system can help by maintaining a centralised inventory record that updates across all connected platforms in real time, giving your bookkeeper a single source of truth for stock levels and costs.
After years of working with online sellers, certain mistakes appear repeatedly. Here are the most damaging.
As covered earlier, marketplace payouts are net of fees. Recording the payout amount as revenue understates your gross sales and hides your true fee expenses. Always record gross revenue and fees separately.
Cash basis accounting records transactions when money changes hands. Accrual accounting records them when they are earned or incurred. For ecommerce sellers, cash basis is dangerously misleading because of payout delays.
Example: You sell $10,000 worth of products in the last week of March, but the payouts arrive in April. Under cash accounting, March shows zero revenue and April shows $10,000 — neither reflects reality. Under accrual accounting, March correctly shows $10,000 in revenue.
Most accountants recommend accrual accounting for ecommerce businesses generating more than $50,000/year in revenue. If you are selling on multiple marketplaces, accrual is practically a requirement.
A single “marketplace fees” expense line tells you nothing useful. You need to know:
Granular fee tracking by platform is the foundation of channel profitability analysis.
Every month you skip reconciliation, discrepancies compound. A $50 fee overcharge on Shopee in January becomes invisible by June. A refund that was never processed gets buried under thousands of other transactions. Set a recurring calendar event and treat reconciliation as non-negotiable.
This is basic but still common among solo sellers. Use a separate business bank account and business credit card. Every personal expense run through a business account is a line item your bookkeeper or accountant has to manually identify and exclude — time that you are paying for.
Platform dashboards do not track your tax liabilities. You are responsible for:
Build tax tracking into your bookkeeping system from day one, not as an afterthought at year-end.
Your approach should match your business stage:
| Stage | Annual Revenue | Approach | Estimated Cost |
|---|---|---|---|
| Side hustle | < $50K | DIY with Xero/QuickBooks + spreadsheet | $20-50/month (software only) |
| Growing seller | $50K-$500K | DIY with accounting automation (A2X, multichannel hub) | $100-300/month (software + tools) |
| Established business | $500K+ | Outsourced bookkeeper + accounting automation | $500-2,000/month (bookkeeper + tools) |
| Enterprise | $2M+ | In-house accountant or CFO services | $3,000+/month |
At the “growing seller” stage, many merchants find that investing in a multichannel management platform pays for itself through time savings alone. Instead of downloading four settlement reports and manually mapping them to your books, you get consolidated sales reports and order data from a single dashboard.
The core principles are identical — record income, track expenses, reconcile bank accounts. The difference is operational complexity. Traditional retail has one or two revenue channels with straightforward transaction records. Ecommerce bookkeeping involves multiple sales channels, each with different fee structures, payout schedules, and reporting formats. Refund handling, marketplace fee reconciliation, and cross-border currency management add layers that traditional bookkeeping rarely encounters.
Yes, especially if you sell on one or two platforms and process fewer than 200-300 orders per month. Modern accounting software like Xero and QuickBooks, combined with automation tools, makes DIY bookkeeping feasible for small sellers. Once you exceed 500 orders per month across multiple platforms, the reconciliation workload typically justifies hiring a bookkeeper — even a part-time one. The cost of a bookkeeper ($300-800/month) is usually less than the cost of the financial errors they prevent.
At minimum, monthly. Weekly is better for sellers processing more than 100 orders per month. The longer you wait between reconciliations, the harder it becomes to identify and resolve discrepancies. Some sellers reconcile every time they receive a payout — which is arguably the most accurate approach if you have the time or the right automation tools.
Xero and QuickBooks are the two most popular choices, and both work well. Xero tends to be preferred in Singapore, Australia, and the UK for its clean interface and strong multi-currency features. QuickBooks dominates the US market and has better payroll integration. Both support marketplace data connectors like A2X. The best choice depends on your location, your accountant’s preference, and which tool your other business systems integrate with.
Managing bookkeeping across multiple sales channels? OneCart connects your Shopee, Lazada, TikTok Shop, Amazon, and Shopify stores into a single platform — consolidating orders, inventory, and sales data so your accounting stays clean. Paired with Xero or QuickBooks integration, it eliminates the manual reconciliation grind that eats hours every week. Start your free trial →
Automate & Scale Your Online Business with OneCart
Start a Free TrialUsed by hundreds of merchants in Singapore & Southeast Asia