Bookkeeping for E-Commerce Businesses

E-commerce is not like most businesses. You sell across channels, you collect through payment platforms that hold your money and take fees, you ship physical products and handle returns, and you owe sales tax in states you may never visit. If you do not reconcile each channel and track inventory by SKU, you can have a busy store and still lose money without knowing where it went.

E-commerce bookkeeping is built to solve that problem. It adds a layer of detail that general bookkeeping does not: the ability to see what each channel earned, what your inventory really cost, and where your profit actually came from after fees, shipping, and returns. This guide explains what e-commerce bookkeeping involves, how it differs from standard bookkeeping, and how to set it up so you know your margins on every product. If you are newer to bookkeeping altogether, it helps to start with our guide on bookkeeping basics first.

Why E-Commerce Bookkeeping Is Different

Most businesses have one bank account and one revenue source. An e-commerce store might sell on its own website, a marketplace, and a social platform, each with its own payout schedule, its own fees, and its own refund rules. A sale on your website might deposit in two days. A marketplace payout might arrive a week later, net of fees, with returns already pulled out. If you only look at your bank deposits, you cannot tell which channel is profitable and which one is quietly losing money to fees and returns.

That is the core difference. E-commerce bookkeeping adds sales channel reconciliation, which means every month you match what each platform reports you sold to what actually hit your bank account, accounting for fees, shipping, and refunds. It adds inventory tracking by SKU, so every shipment gets recorded by item and quantity and you can see what you actually sold and what you actually have left. And it adds sales tax liability tracking, because online sales create tax obligations in states far from where you operate. For a broader look at how bookkeeping supports those decisions, see our guide on how bookkeeping helps small businesses manage cash flow.

Sales Channel Reconciliation

Sales channel reconciliation is the foundation of e-commerce bookkeeping. It means matching what each platform reports you sold to what actually hit your bank account, every month, for each channel. Start with the platform sales report for the month. Break out gross sales, refunds, fees, shipping collected, and sales tax collected. Match the net payout to the bank deposit. If the platform, the processor, and the bank do not match, you find the difference before the next month starts.

A small unreconciled gap, say forty dollars of unexplained fees on a marketplace payout, becomes a big problem if it is ignored. By the time you notice it repeating across six months, you cannot tell whether it was a fee change, a refund you missed, or a chargeback. Monthly reconciliation catches those gaps while they are still small and easy to trace. For a full walkthrough of the matching process underneath this, see our guide on what bank reconciliation is and why it matters.

Example: Reconciling a Shopify Month

Say your Shopify store reports $18,400 in gross sales for the month. It shows $1,200 in refunds, $640 in payment processing fees, $310 in shipping charged to customers, and $1,150 in sales tax collected. The platform deposits $15,720 to your bank account after it nets out fees, refunds, and some shipping. In your books, you record $18,400 in gross sales, $1,200 in refunds as a reduction to sales, $640 in processing fees as an expense, $310 in shipping as revenue, and $1,150 in sales tax collected as a liability you owe. The bank deposit of $15,720 matches the net payout the platform reported. Everything ties out.

If the deposit had been $120 short, you would trace it before the next payout. Maybe a chargeback hit after the payout cut off, or a fee tier changed mid month. Without channel reconciliation, that $120 would vanish into a monthly total, and over a year of busy months, the gaps add up to real money you cannot explain. Reconciling each channel separately is what turns a guess into a number you can act on.

Platform Fees, Shipping, and Returns

E-commerce costs fall into a few categories, and tracking them separately is what makes margin control work. Here is how to break them down:

Each of these should be a separate category in your chart of accounts, and each transaction should be categorized accurately. When you can see platform fees versus shipping versus returns on every period, you can see where your margins are slipping. If you net everything into a single sales figure, you lose the detail that makes e-commerce bookkeeping useful. For a deeper look at the structure behind this, see our guide on what a chart of accounts is and why it matters.

Inventory Tracking by SKU

Inventory is where most e-commerce bookkeeping problems start. Track inventory by SKU, not just by total purchases. Record every shipment by item and quantity when it arrives. Match inventory sold to sales so your system knows what moved. Take a physical count on a regular schedule and compare it to what your system says you should have. The gap is shrinkage, which is theft, damage, or receiving errors, and it is invisible until you count.

Cost of goods sold is what you paid for the inventory you actually sold, not what you bought. If you bought $20,000 in inventory but still have $6,000 on the shelf, your cost of goods sold is $14,000. You calculate it from beginning inventory plus purchases minus ending inventory. It matters because it is the biggest expense in an e-commerce store, and if it is wrong, your profit number is wrong. For a routine that keeps inventory and counts on track every month, see our guide on the complete monthly bookkeeping checklist.

Sales Tax and State Liability

Online sales create sales tax obligations in states far from where you operate. Where you owe tax depends on where you have sales tax nexus, which can be created by physical presence, employees, inventory stored in a warehouse, or economic activity once you pass a state threshold. Many platforms now calculate and collect sales tax automatically based on the customer location, but you are still responsible for registering, filing, and remitting where you have nexus.

Track the sales tax you collect as a liability, not as revenue, because you owe it to the state until you remit it. If you record it as revenue, your income is inflated and your liabilities are wrong. Sales tax registration and filing is a tax matter, not a bookkeeping service, so talk to a tax professional about where you owe and how to file. We keep the collected amounts accurate and organized so your tax preparer can file with confidence.

Cash Basis vs Accrual Basis for E-Commerce

Most small e-commerce stores start on cash basis accounting because it is simpler. Cash basis records revenue when you collect it and expenses when you pay them. It is easy to understand but it can distort profitability, especially in a store with inventory. You can show a big profit in a month where you sold a lot of merchandise, even if the inventory you bought for those sales was paid for in a different month. You can show a loss in a month where you paid for a large inventory shipment, even if the sales it supported happened earlier.

Accrual basis records revenue when you earn it and expenses when you incur them, regardless of when cash changes hands. It matches revenue to the costs that produced it, which gives you an accurate picture of your inventory cost and your margins by period. For inventory tracking and cost of goods sold to work properly, accrual is usually the better fit, because it ties the cost of inventory to the sales it produced in the same period. The tradeoff is complexity, which is why many stores start on cash and move to accrual as they grow. For a full comparison, see our guide on cash basis versus accrual basis bookkeeping.

Printable E-Commerce Bookkeeping Checklist

Use this checklist to keep your e-commerce books accurate every month. Print it, save it, or share it with whoever handles your bookkeeping.

Common E-Commerce Bookkeeping Mistakes

• Not reconciling by channel. If you only look at total bank deposits, you cannot tell which channel is profitable. Reconcile each platform separately so fees and returns stay visible.
• Netting fees against revenue. If you record net deposits as revenue, your sales look lower than they are and your fees are invisible. Record gross sales and fees separately.
• Recording sales tax as revenue. Sales tax you collect is a liability you owe to the state. If you record it as revenue, your income is inflated and your liabilities are wrong.
• Tracking purchases instead of cost of goods sold. If you only record what you bought and never count what is left, your cost of goods sold is a guess. Count inventory on a regular schedule to get the real number.
• Ignoring shipping margin. If you do not compare shipping you charge to shipping you pay, you cannot see whether your rates cover your costs. Track them separately.
• Waiting until year end to reconcile. If your books are not reconciled monthly, your channel and margin reports are unreliable. Reconcile every month so your numbers are trustworthy when you need them.

Getting Started

E-commerce bookkeeping only works if it is set up right and maintained consistently. If your channels are not reconciled, your inventory is not being counted, or your sales tax is not tracked as a liability, your reports are unreliable, and unreliable reports are a poor foundation for pricing your products or deciding which channels to grow. The best next step is a conversation about where your books stand today. For more on when it makes sense to bring in help, see our guide on when to hire a bookkeeper.