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 closing the books in a controlled sequence so reports are timely and reviewable. 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.
Before the Close Starts
Set a cutoff for source records and confirm that the period, entities, accounts, and operational systems in scope are known. Ask whether there were new accounts, financing, major purchases, disposals, new locations, unusual refunds, or changes in how the business operates.
The close package should begin with these records:
- order and sales summaries by channel
- processor payout, fee, refund, and dispute reports
- purchase orders, supplier bills, and freight or duty documents
- inventory receipts, transfers, adjustments, and counts
- bank and credit-card statements
- gift-card, store-credit, and customer-deposit activity
Step 1: Complete Transaction Intake
Post or import the period’s activity, resolve obvious duplicates, and identify transactions that lack sufficient support. Do not guess at material classifications. Place questions in an exception log with the date, amount, account, source, and decision needed.
Step 2: Reconcile Cash and External Balances
Reconcile every bank, credit-card, loan, payment, and material clearing account through the final statement date. Investigate old outstanding items, transfers recorded on only one side, duplicated feeds, and deposits that do not match source reports.
Step 3: Tie Operations to the Ledger
Perform sales-channel and payout reconciliation using order reports, refund and dispute reports, fee detail, payout statements, bank deposits, inventory movements, and ledger clearing accounts. The source total, reconciling items, and ledger balance should be visible in one schedule.
Step 4: Reconcile Payroll and Payables
Tie store, warehouse, customer-service, and management payroll together with contractor and fulfillment labor to payroll registers, cash withdrawals, and liability balances. Review unpaid vendor items, credits, duplicates, and payments issued after cutoff.
Step 5: Review Assets, Debt, and Other Schedules
Update records for inventory units, landed cost components, warehouse equipment, computers, leasehold items, and product write-offs. New financing should tie to executed documents and cash received or paid. Keep bookkeeping schedules separate from depreciation methods, capitalization policies, and other decisions that require professional approval.
Step 6: Perform an Analytical Review
Ask:
- Do gross orders reconcile to refunds, fees, and net payouts?
- Does inventory movement agree with the general ledger?
- Are cutoffs consistent for shipped, returned, and in-transit orders?
- Which channel or product exceptions need operational review?
Compare the current period with prior periods, expectations, and operational activity. A variance is a question—not automatically an error.
Step 7: Lock the Package
Deliver the reports, reconciliations, schedules, and open-item log together. Record who reviewed the close and prevent silent changes to a completed period. If a correction is later required, document what changed, why, who approved it, and which reports were reissued.
A Close Is Not Complete When…
- 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
It is also incomplete when bank accounts reconcile but operational clearing accounts, payroll liabilities, receivables, payables, or asset schedules remain unexplained.
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 |
|---|---|---|
| Cutoff | The period, missing records, and late activity are identified. | Open items are not silently pushed into another month. |
| Reconciliation | External statements and supporting schedules agree with the ledger. | Material differences are explained rather than plugged. |
| Review | Reports include corrections, unusual movements, and unresolved questions. | Delivery status and approvals are recorded. |
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.
