Ecommerce and Retail bookkeeping has to reflect orders, refunds, discounts, sales channels, merchant processors, inventory locations, shipping, duties, and returns. A generic transaction list can show cash moving, but it cannot explain whether the operating records, bank activity, and ledger agree.
This guide focuses on designing a chart of accounts that supports useful reporting without becoming unmanageable. It is a bookkeeping workflow, not tax, legal, assurance, or regulated professional advice. Policies and jurisdiction-specific decisions should be approved by the business and its appropriately qualified professional.
Start With Decisions, Not Account Numbers
Before creating accounts, list the questions management expects the books to answer. Those questions usually concern gross sales to net sales, payout clearing, gross margin, inventory movement, landed cost, channel profitability, and cash conversion. If two types of activity require different review, control, or handoff treatment, separate them. If nobody will act on the distinction, a tracking dimension may be better than another general-ledger account.
A Practical Account Architecture
Revenue
Create enough separation to explain gross sales, discounts, refunds, gift cards, marketplace adjustments, shipping income, and processor payouts. Preserve gross activity when net deposits contain fees, refunds, holds, credits, or other deductions.
Direct and operating costs
Direct costs should help explain the work or sales that produced revenue. For online stores, multichannel sellers, retailers, and inventory-based brands, those costs often include product purchases, inbound freight, duties, fulfillment, packaging, merchant fees, marketplace charges, and write-downs. Administrative expenses can remain separate so gross performance is not confused with the cost of running the organization.
Balance-sheet accounts
Use distinct accounts for bank and payment balances, receivables, deposits, prepaids, fixed assets, accumulated balances, loans, payroll liabilities, customer or vendor credits, and clearing activity. Every recurring balance-sheet account should have an owner and a reconciliation method.
Use Dimensions for Operational Detail
Typical dimensions are sales channel, product family, location, processor, and order period. A dimension is valuable when it is applied consistently to both revenue and related cost. Tracking revenue by project or location while leaving payroll and vendor costs unassigned produces an incomplete comparison.
Build the Mapping Before Importing Data
Document how each source in storefronts, marketplaces, payment processors, inventory, fulfillment, payables, and accounting systems maps to the ledger. Include:
- the source report or export;
- the destination account and dimension;
- whether the entry is gross or net;
- the expected clearing account;
- the person who reviews exceptions;
- the cutoff used at month-end.
Test the mapping with a complete period before automating it. An integration can repeat a wrong mapping faster than a manual process.
Avoid These Chart-of-Accounts Traps
- posting net deposits directly to sales
- treating processor fees and refunds as invisible differences
- changing inventory balances without count or movement support
- mixing owner purchases, product samples, and ordinary cost of goods sold
Also avoid creating a new account for every vendor, customer, product, or employee. Those details usually belong in subsidiary records or tracking dimensions.
Review the Structure Quarterly
Archive unused accounts only after confirming their balances are zero and historical reports will remain understandable. Merge duplicate accounts carefully, preserve an account-change log, and involve the qualified professional when a change affects an approved accounting policy.
Minimum Documentation
Keep an account list with a plain-language purpose, examples of what belongs, examples of what does not, the normal balance, the assigned dimensions, and the expected reconciliation. This small data dictionary improves consistency for owners, staff, bookkeepers, and reviewers.
Practical Control Matrix
Use this table as a review aid, then adapt responsibilities and frequency to the business. In ecommerce bookkeeping, the control design should reflect orders, refunds, discounts, sales channels, merchant processors, inventory locations, shipping, duties, and returns.
| Control area | Evidence to retain | Review signal |
|---|---|---|
| Account purpose | Each active account has a clear use and reporting owner. | Similar transactions are coded consistently. |
| Dimensions | Only useful customer, project, location, product, or program detail is required. | Reports answer operating questions without duplicate accounts. |
| Change control | New, merged, or inactive accounts are documented before use. | Historical comparisons remain understandable. |
Put the Guide Into Practice
- Establish the baseline. Confirm the period, source systems, accounts, responsible people, and last reliable reconciliation. List missing evidence before making corrections.
- Build the operating bridge. Document how storefronts, marketplaces, payment processors, inventory, fulfillment, payables, and accounting systems feed or reconcile to the ledger. Test the workflow on one complete period before scaling it.
- Measure completion. Review gross sales to net sales, payout clearing, gross margin, inventory movement, landed cost, channel profitability, and cash conversion. Record exceptions, decisions, and due dates with the monthly package.
The objective is not more paperwork. It is a smaller, stronger evidence trail that lets an owner, bookkeeper, and qualified reviewer reach the same explanation of a balance.
Keep Building the Ecommerce Bookkeeping System
For broader planning, browse the bookkeeping services overview, compare supported accounting and operating platforms, or use the accountant handoff checklist.
Further Reading
- Shopify payout documentation
- Stripe revenue and transaction methodology
- IRS inventory recordkeeping guide
External guidance may be jurisdiction-specific and can change. Use it as a research starting point and confirm requirements with the appropriate professional.
