Bookkeeping by business type
Ecommerce bookkeeping: sales, fees, refunds and stock
Record online store sales at gross, post payment fees and refunds through a clearing account, track inventory and COGS, and keep sales tax off revenue.
By TNas · · 8 min read
Ecommerce bookkeeping means recording each sale at the full price the customer paid, recording the payment processor's or marketplace's fees as a separate expense, and moving the cost of each item out of inventory when it ships. Refunds reverse the sale, and sales tax you collect sits in a liability account until you pay it over. If you set up one clearing account for payouts, the bank deposits will match your books every month.
The examples below use a fictional online store, Juniper Candle Co., which sells candles through its own website and takes card payments through a payment processor. All figures and the 6% sales tax rate are made up for illustration.
Why online store books get out of step
The most common problem in ecommerce books is recording the payout instead of the sales. A processor or marketplace collects money from customers, keeps its fees, subtracts refunds, and sends you the rest a few days later. If you record only that net deposit as income, three things go wrong at once:
- Revenue is understated, because the fees were taken out before the money reached you.
- Fees disappear, so you can't see what selling online actually costs.
- Sales tax is buried in income, so the liability you owe is missing from the balance sheet.
The fix is to record the economic events separately: the sale, the cost of the goods sold, the fee, the refund and the payout. Each one has its own entry, and a clearing account ties them together.
The accounts an online store needs
A clearing account is a temporary holding account for money that has been collected but not yet deposited; it should return to zero once the deposit is recorded. A small online store uses the same five account types as any business (see the five account types), but a few accounts do most of the work. Add them to your chart of accounts before you record the first payout.
| Account | Type | What it holds |
|---|---|---|
| Payment Processor Clearing | Asset | Sales collected by the processor but not yet paid out to your bank |
| Inventory | Asset | Cost of products on hand, ready to sell |
| Sales Tax Payable | Liability | Tax collected from customers that you owe the tax authority |
| Sales Revenue | Revenue | Selling price of goods shipped |
| Sales Returns and Allowances | Contra revenue | Refunds and partial credits given to customers |
| Cost of Goods Sold | Expense | Cost of the products you sold |
| Merchant Fees Expense | Expense | Processing, transaction and marketplace fees |
If you sell on more than one platform, give each one its own clearing account. That way each account can be reconciled against that platform's own payout report.
Recording a week of sales and the payout
Juniper's processor dashboard shows one week of orders: $2,400.00 of candles plus $144.00 of sales tax, so customers paid $2,544.00 in total. The processor will deposit the money a few days later, minus its fees.
Record the sales at gross. The full amount the customers paid goes into the clearing account, revenue gets the selling price, and the tax goes to a liability.
| Account | Debit | Credit |
|---|---|---|
| Week 1: online sales collected by the processor | ||
| Payment Processor Clearing | $2,544.00 | |
| Sales Revenue | $2,400.00 | |
| Sales Tax Payable | $144.00 | |
The candles that shipped cost Juniper $960.00 to make. Under a perpetual inventory system, the second half of every sale moves that cost out of Inventory and into cost of goods sold. Recording COGS at selling price is a common mistake; it is always recorded at cost.
| Account | Debit | Credit |
|---|---|---|
| Week 1: cost of the candles shipped | ||
| Cost of Goods Sold | $960.00 | |
| Inventory | $960.00 | |
When the payout arrives, the processor has kept $76.32 in fees and deposited $2,467.68. The deposit clears the clearing account, and the difference is the fee.
| Account | Debit | Credit |
|---|---|---|
| Payout for week 1 lands in the bank | ||
| Cash | $2,467.68 | |
| Merchant Fees Expense | $76.32 | |
| Payment Processor Clearing | $2,544.00 | |
After the payout, Payment Processor Clearing is back to zero for that week. That's the check: if a clearing account still holds a balance after every payout for a period has arrived, something was missed, such as a refund, a reserve the platform held back, or a fee you didn't record. The same logic is covered step by step in how to record Stripe and PayPal payouts with fees.
Work from the platform's payout report, not the bank line. The report lists the orders, fees and refunds inside each deposit, which is the source document for the entry.
Recording refunds and returns
A refund reverses the sale. Juniper refunds one order: a $60.00 candle plus $3.60 of tax. The customer returns the candle unused, so it goes back on the shelf.
The refund side uses Sales Returns and Allowances, a contra revenue account, so gross sales stay visible on the income statement. The tax portion reduces the liability, because Juniper no longer owes tax on a sale that was reversed. The processor takes the refund out of the next payout, so the credit goes to the clearing account.
| Account | Debit | Credit |
|---|---|---|
| Refund of order 1047 through the processor | ||
| Sales Returns and Allowances | $60.00 | |
| Sales Tax Payable | $3.60 | |
| Payment Processor Clearing | $63.60 | |
Because the candle came back in sellable condition, its cost goes back into Inventory. Juniper's cost for that candle was $24.00.
| Account | Debit | Credit |
|---|---|---|
| Returned candle restocked at cost | ||
| Inventory | $24.00 | |
| Cost of Goods Sold | $24.00 | |
If the item is damaged and can't be resold, skip the restocking entry; the cost stays in COGS. If the processor returns its original fee on a refund, the payout report will show it as a credit and you reduce Merchant Fees Expense by that amount. If it keeps the fee, there's nothing more to record. The lesson on returns and shrinkage covers the cost side in more detail, and how to record customer refunds the right way covers refunds outside ecommerce.
Buying stock and keeping inventory right
When Juniper buys wax, wicks and jars to make candles, or buys finished goods to resell, the cost goes into Inventory rather than straight to expense. Expensing stock when you buy it makes profit look low in the month you restock and high in the months you sell.
| Account | Debit | Credit |
|---|---|---|
| Supplier bill for finished candles, 30-day terms | ||
| Inventory | $3,000.00 | |
| Accounts Payable | $3,000.00 | |
Shipping you pay to bring stock in is part of its cost. Shipping you pay to send orders to customers is a selling expense. Postage and packaging for outbound orders usually go to their own expense accounts so you can compare them with what customers paid for shipping.
Counting stock
Records drift from reality: items break, get lost in the post, or are miscounted at receiving. Count stock at least at year-end, and more often for fast sellers. When the count is lower than the records, record the difference as shrinkage.
Juniper's records show $8,000.00 of inventory; the count finds $7,850.00.
| Account | Debit | Credit |
|---|---|---|
| Year-end count: inventory shrinkage | ||
| Cost of Goods Sold | $150.00 | |
| Inventory | $150.00 | |
The inventory and COGS examples page has more practice with counts and costing methods such as FIFO.
Sales tax collected on online sales
Sales tax you charge a customer is never your revenue. You collect it on behalf of the tax authority and owe it until you pay it, which is why it's credited to Sales Tax Payable. The lesson on sales tax basics shows the same entry for a service business.
At the end of the filing period, the balance in Sales Tax Payable should equal tax collected minus tax refunded since the last payment. In Juniper's example that's $144.00 − $3.60 = $140.40.
| Account | Debit | Credit |
|---|---|---|
| Pay sales tax collected for the period | ||
| Sales Tax Payable | $140.40 | |
| Cash | $140.40 | |
Paying the tax settles a liability, so it's not an expense. Whether you must collect tax, and for which states, depends on where you sell and on each state's rules; check with the state revenue department or a tax professional. If a platform tells you it collected and paid the tax itself, that tax was never yours to hold, so don't put it in Sales Tax Payable. Record only the sales and fees the platform reports to you.
Form 1099-K and your sales records
Form 1099-K is an information return that reports payments you received for goods or services through payment cards, payment apps and online marketplaces. The IRS says these platforms, which it calls third party settlement organizations, must file the form and send you a copy. Payment apps and online marketplaces must report when payments exceed $20,000 in more than 200 transactions. The IRS also notes you may get a form even below that threshold (IRS, Understanding your Form 1099-K).
For bookkeeping, treat the 1099-K as a check, not a source of entries. Your books are built from order and payout reports, and the form summarizes payments over a year. Total your gross sales from the platform and compare them with the form. If the numbers differ, write down why (refunds, sales tax, timing at year-end, or sales on another platform), and give that note to your tax preparer.
A monthly routine for an online store
A short routine keeps the books matched to the platforms and the bank. Most of it fits into the month-end close.
| Step | What to check |
|---|---|
| 1. Record every payout | Sales, tax, fees and refunds from each payout report |
| 2. Reconcile each clearing account | Balance should equal sales not yet paid out at month-end |
| 3. Reconcile the bank | Each deposit matches a payout; see bank reconciliation basics |
| 4. Review Inventory | Large purchases recorded; COGS posted for every shipment |
| 5. Check Sales Tax Payable | Balance equals tax collected minus refunds since last payment |
| 6. Review gross profit | Net sales minus COGS; see net sales and gross profit |
Keep the payout reports, supplier invoices and refund records with the books. The IRS says to keep records as long as they're needed to prove the income or deductions on a return. It also explains the usual three-year period and the longer periods that apply in some cases (IRS, How long should I keep records?).
Frequently asked questions
Should I record online sales gross or net of fees?
Gross. Record the full amount customers paid as sales (and sales tax), then record the processor's or marketplace's fees as an expense. Recording net hides both revenue and selling costs.
Is shipping charged to customers revenue?
Yes. Shipping you charge customers is part of what they pay you for the order, so it's income. Record the postage you pay as an expense, so you can see whether shipping charges cover shipping costs.
What if a platform holds back part of a payout?
Some platforms hold a reserve. The held amount is still your money, just not paid yet, so it stays in the clearing account (or a separate reserve account) until it's released. Don't expense it.
Do I need perpetual inventory for a small shop?
Not always, but it helps. Perpetual records update Inventory and COGS with every sale, so gross profit is right each month. A count is still needed to catch shrinkage.
What to practice next
Start with the inventory side, since COGS entries are the step most new store owners skip. Work through the inventory and COGS exercises, then try the sales tax bookkeeping exercises and the bank reconciliation exercises. For a full month of online store transactions in one place, the online shop project puts payouts, refunds and stock counts together.
Sources
Educational content for US small-business bookkeeping, not tax, legal or accounting advice. Example businesses and figures are fictional. See our editorial policy for how we write and correct content.