E-commerce Seller Templates
Organize sales channels, payout reports, merchant fees, refunds, reserves, shipping, inventory, sales tax, and platform deposits.
Best for: Shopify, Etsy, Amazon, eBay, marketplace, and direct-to-consumer sellers.
Important: This article is general bookkeeping education. It is not tax, legal, payroll, or accounting advice. Rules and correct treatment can depend on entity type, industry, location, software setup, and professional judgment.
E-commerce deposits rarely equal gross sales. Payouts may be reduced by fees, refunds, reserves, shipping, sales tax, advertising, and adjustments.
What this means
E-commerce bookkeeping connects storefront reports, marketplace reports, processors, bank deposits, inventory, fees, refunds, and taxes.
If the bank deposit is recorded as total sales, revenue and expenses can be wrong. Platform-level reports are needed to understand activity before payout.
Core concepts
Sales before fees, refunds, discounts, taxes, and reserves.
Net deposits after platform or processor activity.
Merchant fees, marketplace fees, chargebacks, refunds, and adjustments.
Product costs, shipping, sales tax, and inventory records need review.
Step-by-step workflow
- Gather the source records. Save statements, receipts, reports, screenshots, contracts, confirmations, or notes that support e-commerce bookkeeping records.
- Identify the business event. Decide what actually happened before choosing a category or changing a report.
- Match the money movement. Compare the bookkeeping record to bank, credit card, loan, payroll, or platform activity.
- Choose the right treatment. Separate income, expense, asset, liability, equity, transfer, and owner activity instead of using one catch-all category.
- Review for duplicates and timing. Look for repeated entries, missing transactions, old balances, refunds, chargebacks, and period cut-off issues.
- Save final notes. Keep a clear explanation so the owner, bookkeeper, or accountant can understand the decision later.
Review checklist
- The period, account, and source report being reviewed are clearly identified.
- Transactions are not duplicated or counted in the wrong period.
- Unclear items are placed on a question list instead of guessed.
- Supporting documents are saved in the monthly records folder.
- The final report or template includes notes for unusual activity.
Common mistakes to avoid
- Guessing from the bank description only. Bank descriptions are helpful but often incomplete.
- Using miscellaneous too often. Too many miscellaneous entries make reports less useful.
- Skipping documentation. A correct number is harder to defend when the source is missing.
- Ignoring balance sheet effects. Some activity affects assets, liabilities, or equity rather than the P&L.
Example review map
| Area | What to review |
|---|---|
| Documents | Confirm the files supporting e-commerce bookkeeping records are saved and named clearly. |
| Category | Confirm the category describes the business purpose and account type. |
| Balance | Confirm any related bank, card, loan, tax, payroll, or owner balance makes sense. |
| Questions | List missing details and assign follow-up before closing the month. |
| Handoff | Save a short note for the owner, bookkeeper, accountant, or tax preparer. |
FAQ
Why does the deposit not match sales?
Deposits are often net of fees, refunds, reserves, taxes, and timing differences.
Should each platform have separate accounts?
It can help if you review channels separately, but keep the chart useful and manageable.
Can I use this with a KanderBooks template?
Yes. Use the article as a workflow guide, then use the matching KanderBooks template to organize amounts, notes, dates, confirmations, and review questions.
When should I ask a professional?
Ask a qualified bookkeeper, accountant, payroll provider, or tax professional when the item affects taxes, payroll, loans, prior-period reports, legal compliance, or financial statements used outside the business.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.