Ecommerce bookkeeping cleanup: a six-step process

Published on Beamarc: September 30, 2026.

An ecommerce cleanup rebuilds the records behind balances that no longer reconcile.

Meaning: the GL might look fine, but there’s no credible trail from reality to the numbers. Deposits can’t be matched to payouts. Inventory doesn’t tie to anything. Gross margin swings for no operational reason.

Missing support can delay tax preparation, reporting and due diligence. Define the affected periods and the records available before starting corrections.

This post lays out a repeatable cleanup process for ecommerce operators: Shopify, Amazon, Stripe/PayPal, 3PL/FBA inventory, wholesale AR: the stuff that breaks normal bookkeeping.

What cleanup is (and isn’t)

• Fix past periods, reconstruct balances, rebuild the trail. Monthly Close: Keep current periods tied out and reviewable
• Backlog-oriented: “what happened last year?”. Monthly Close: Process-oriented: “how do we prevent drift next month?”
• Outputs: corrected financials + workpapers + baseline. Monthly Close: Outputs: recurring tie-outs + aging + variance review

Cleanup without a new close process just recreates the same mess later.

When you actually need a cleanup

If any of these are true, you’re already in cleanup territory:

• You can’t explain bank deposits by payout/settlement IDs (Shopify, Amazon, Stripe/PayPal).
• “Undeposited Funds” or a clearing account has months/years of drift.
• Inventory in the GL doesn’t tie to a system or a count.
• Accrual-reporting cost of goods sold follows payment dates rather than the sale of the related inventory.
• Returns and refunds are not reconciled to any existing refund liability or return-recovery asset and the physical condition of returned goods.
• Sales tax is being collected in states where you aren’t registered, or you have a “sales tax” balance you can’t explain.
• You’re switching stacks (e.g., spreadsheets → QBO/Xero; new inventory system; new middleware like A2X/Webgility).
• You used a generic service that posted net deposits as revenue and called it “done.”

If you’re nodding along: the fix isn’t “more bookkeeping.” It’s a rebuild with hard tie-out rules.

Step 0: define what “defensible” means for you

Different milestones need different rigor. Pick the target before you touch entries:

Tax-return support

Clean income/expense classification, reconciled cash, and enough support to file accurately. Not the same as investor reporting.

Lender / board package

Accrual-aware numbers, stable gross margin logic, clean balance sheet schedules, and consistent policies month to month.

Diligence-ready

Clear workpapers, channel tie-outs, inventory support, normalized add-backs clearly documented. The story holds up under questions.

Cleanup succeeds when the goal is explicit. Cleanup fails when the goal is “make it look right.”

Step 1: collect the right source data (not screenshots)

You can’t reconstruct ecommerce books from bank statements alone. You need source-of-truth exports that explain deductions, holds, and timing.

Minimum data pack (by channel)

• Bank + credit cards. What you need: Statements + CSV exports; Why it matters: Hard cash truth + timing
• Shopify / gateways. What you need: Payout reports + transaction detail; Why it matters: Explains fees, refunds, disputes, payout adjustments
• Amazon (FBA/SC). What you need: Settlement statements + transaction reports; Why it matters: Explains deposits; captures reserves, reimbursements, fee reversals
• Stripe / PayPal. What you need: Payouts/balance activity + fees/refunds; Why it matters: Net deposits aren’t revenue; detail is required to book correctly
• Inventory system / 3PL. What you need: On-hand report + movement/adjustments; Why it matters: Ties inventory to reality and supports COGS
• Wholesale. What you need: Open invoices + AR aging + cash application; Why it matters: AR is your reconciliation point, not “clearing”
• Tax / payroll. What you need: Filings, notices, payroll registers; Why it matters: Liabilities must be real and explainable

Identify gaps in the source records early. Missing evidence can limit what can be reconstructed and affect the scope and timing of the work.

Step 2: reconcile cash cycles first (payouts/settlements → deposits)

Cash and settlement reconciliations provide a useful starting point for identifying missing and duplicated activity.

For settlement channels, the rule is simple: every deposit must match a payout/settlement ID, and the clearing balance must equal only explainable pending items (timing + documented holds).

If you need the channel-by-channel close model, start here: Multi-channel ecommerce reconciliation: a monthly close and Clearing-account aging for ecommerce payouts.

Cleanup rule for clearing accounts

• Rule No dumping. Clearing is not a plug account. Every line needs a source reference (payout ID, settlement ID, transfer ID, hold documentation).
• Aging: investigate balances beyond the internal review threshold. Document corrections or losses based on evidence, not age alone.
• Output Deposit map. A deposit schedule that ties bank lines to payout/settlement IDs.

Step 3: rebuild revenue, refunds, fees, and chargebacks (gross → net)

If someone booked net deposits as revenue, you lost the detail needed to reconcile. Cleanup restores the structure:

• Revenue: recorded on a consistent basis (not “whatever hit the bank”).
• Contra-revenue: returns/allowances tracked so revenue isn’t overstated.
• Fees: processor/marketplace fees booked separately (so margin analysis is real).
• Chargebacks/disputes: tracked consistently, with timing understood.

Returns and cutoffs are a common failure point; see: Returns, refunds and chargebacks: getting cutoff right.

Step 4: rebuild inventory and cost of goods sold

Inventory errors affect both the balance sheet and cost of goods sold. Trace quantities and cost before relying on reported margin.

At minimum, your cleanup needs:

• Landed cost completeness: inbound freight/duties included consistently when applicable.
• Valuation consistency: FIFO or weighted average applied consistently in the system.
• Returns and adjustments: account for recovered goods at the supported amount, settle any existing return-recovery asset, and avoid reversing cost of goods sold twice.
• Tie-out: inventory system (or count) to GL at period end.

Deep dive: Inventory, cost of goods sold and product margins.

Where inventory records cannot be reconstructed, document the missing evidence, the possible effect on reporting and the limitations of any estimates.

Step 5: rebuild the balance sheet (AR/AP/tax/payroll/debt)

A cleanup should address balance-sheet support as well as the income statement.

Minimum balance sheet schedules to rebuild and retain:

• Accounts Receivable: aging ties to open invoices; cash applied; deductions documented.
• Accounts payable: reconcile bills and accruals for goods or services received to vendor support. Track unfulfilled purchase commitments separately.
• Sales tax payable: ties to filed returns and payments (or documented exposure if not filed).
• Payroll liabilities: ties to payroll registers and deposit confirmations.
• Debt: principal/interest schedule ties to statements; no unexplained balances.
• Equity: owner contributions/distributions not buried in expenses.

Sales tax basics and nexus risk live here: Sales tax records for ecommerce: what to prepare.

Step 6: produce workpapers + install the close so drift doesn’t return

Cleanup output should be something a third party can follow without calling you.

Cleanup deliverables (minimum)

• 1 Reconciled cash. Bank/credit cards tied to GL.
• 2 Channel tie-outs. Clearing accounts reconciled to payout/settlement support.
• 3 Inventory support. System or count tie-out + key adjustments documented.
• 4 Balance sheet schedules. AR/AP/tax/payroll/debt supported.
• 5 Close checklist. A repeatable monthly process to keep it clean.

The close process is the “maintenance plan.” No maintenance = drift returns.

Common cleanup mistakes (that waste time and still don’t fix it)

1) Starting with the P&L instead of cash cycles

Without a supported settlement-to-bank reconciliation, reclassifications can leave the underlying differences unresolved.

2) One giant clearing account

If Shopify + Amazon + PayPal + “random” all hit one account, you can’t isolate problems. Separate by settlement source or enforce strict sub-tracking.

3) Treating inventory like an afterthought

Where the reporting basis requires inventory accounting, support the quantities, ownership, cost and valuation adjustments.

4) “Make it tie” entries with no trail

A plug entry isn’t a fix. It’s a future diligence question you can’t answer.

---

FAQ

What is an ecommerce accounting cleanup (and how is it different from monthly bookkeeping)?

Cleanup is historical reconstruction: you correct prior periods, rebuild reconciliations, and reset the balance sheet to a defendable baseline. Monthly bookkeeping is the ongoing close process to prevent drift going forward.

What’s the #1 rule of ecommerce cleanup?

Start with cash cycles. Reconcile deposits to payout/settlement support by channel. If you can’t explain deposits, you can’t defend the books.

How long does an ecommerce cleanup take?

It depends on time period, transaction volume, channel mix, and whether inventory/COGS needs reconstruction. A records assessment should define scope, required inputs, constraints, and a realistic timeline.

Do I need to rebuild inventory and COGS during cleanup?

If you hold inventory and your margin is unstable or inventory doesn’t tie to a system/count, yes. If you can’t support inventory, you should document limitations instead of pretending margin is precise.

What deliverables should come out of a cleanup project?

Reconciled bank/credit cards, channel-level tie-outs (clearing), inventory/COGS support where applicable, balance sheet schedules (AR/AP/tax/payroll/debt), and a close checklist that prevents drift.

Can I just plug differences into a clearing account to make it tie?

No. A plug leaves the underlying issue unresolved. Keep a visible exception with source references and obtain support before recording a correction.

---

Respect the reporting basis and prior periods

The workflow above is aimed at supported accrual reporting. Cash-basis tax records can differ and may require a separate reconciliation. Before changing a filed or previously issued period, assess the correction with the responsible tax preparer or reporting adviser and preserve the audit trail.

How Beamarc can help

Beamarc provides bookkeeping, monthly close, financial reporting and accounting advisory. We can discuss the records available, the questions you need answered and the support that fits your business. Scope, responsibilities, timing and fees are agreed before work begins.

Request a consultation.

Related reading

• Bookkeeping cleanup readiness: what to prepare
• Inventory, cost of goods sold and product margins
• Multi-channel ecommerce reconciliation: a monthly close

General information only. Accounting and tax treatment depend on your facts and reporting framework. This article does not provide assurance or establish a client relationship.