Reporting & close

Preparing ecommerce records for investor due diligence

Prepare revenue, inventory, working capital and adjustment schedules that help investors and diligence teams understand your ecommerce financial records.

Sema Koch, CPA

Published

2026-09-30

Last updated

October 6, 2026

Author credentials and experience

Published on Beamarc: September 30, 2026.

A useful diligence package explains how reported earnings connect to source records, accounting policies and working capital.

Investors and buyers may examine revenue, product costs, returns, liabilities and proposed earnings adjustments. Clear schedules help them evaluate those amounts.

Ecommerce records can require additional reconciliation across marketplaces, payment processors, inventory locations and tax jurisdictions.

This guide is a practical QoE-readiness checklist for ecommerce brands, built around what diligence teams actually ask for and where ecommerce books typically break.

Quick definitions (so nobody talks past each other)

GAAP financials. What it means in real life: Financial statements prepared using U.S. GAAP policies applied consistently (e.g., revenue recognition, inventory costing, accruals).
QoE. What it means in real life: A buyer/investor diligence analysis of earnings sustainability, often producing a normalized earnings measure (commonly Adjusted EBITDA) plus working capital trends.
Investor-ready. What it means in real life: Not “perfect.” It means reconciled, explainable, and supported with workpapers so another party can follow the trail without guessing.
Audit / Review. What it means in real life: Assurance services performed under professional standards. A QoE is not an assurance engagement.

This page is educational. It is not an assurance report, and it does not provide audit/review assurance.

The ecommerce QoE reality

A diligence team will pressure-test four things:

Does it reconcile?

Provide a bridge from recognized revenue through settlements to cash, with timing and deductions explained.

Is COGS defensible?

Support cost of goods sold with inventory quantities, landed costs, returns and valuation adjustments.

Working capital isn’t optional

Working-capital schedules support the amounts used in a transaction. The purchase agreement determines which balances count and how adjustments operate.

Proposed earnings adjustments need evidence and a clear rationale. The intended users determine whether they accept each adjustment.

Step 1: Stop treating deposits as revenue

Booking net deposits as revenue can conceal fees, refunds and timing. Rebuild the gross-to-net bridge before relying on channel comparisons.

Deposits are cash movement.
For a merchant acting as principal, revenue reflects the goods transferred before processor fees, adjusted for discounts and returns. An agent may recognize only its fee or commission. Assess control of the specified goods or services and apply the appropriate sales-tax presentation.
The difference is fees, refunds, chargebacks, reserves, timing, and sometimes taxes collected/remitted by a marketplace.

Investor-ready ecommerce accounting starts with a channel-by-channel cash cycle close (clearing/settlement accounts). If you haven’t built that, start here: Multi-channel ecommerce reconciliation: a monthly close.

Step 2: Revenue recognition and “what counts as revenue”

Most ecommerce QoE work doesn’t argue about your brand. It argues about cutoff and presentation:

Revenue workpapers buyers ask for

Req 1 Monthly revenue bridge by channel. Sales reports → settlement statements → bank deposits, with timing items documented.
Req 2 Returns/refunds policy and reserve support. Consistent treatment of refunds, chargebacks, and returns (including inventory/COGS reversals where applicable).
Req 3 Sales taxes treatment. Clear policy on whether sales taxes collected are excluded from revenue and where liabilities sit (and what the marketplace remits vs you remit).
Req 4 Gift cards / store credit. Liability rollforward (beginning balance + issued − redeemed, adjusted for supported refunds, transfers to unclaimed-property liabilities and qualifying breakage).
Req 5 Gross vs net revenue memo for edge cases. Especially if you have marketplace arrangements, affiliates, or “seller of record” structures.

A reviewer should be able to follow the revenue figure through the supporting schedules and source reports.

Step 3: COGS that holds up under pressure

Inventory-related questions often concern the following areas:

Missing landed costs (freight/duties stuck in operating expense)
Inventory not tying to the inventory system / 3PL / FBA reports
Returns with missing recovery adjustments, unsupported recovered values or a duplicate COGS reversal
Old inventory not written down

If you want the detailed inventory close process, see Inventory, cost of goods sold and product margins. This section is the QoE-specific version: what to prove, not just what to book.

Inventory & COGS proof package

Inventory reconciliation (system → GL). What it supports: Agreement between the inventory subledger and GL; counts, ownership, cutoff and valuation need separate evidence; Common failure: “Inventory” in GL is a plug number
Landed cost allocation support. What it supports: COGS includes freight/duties appropriately via inventory; Common failure: Freight expensed when paid, not matched to sales
Returns log + COGS reversal logic. What it supports: Supported recovery of goods and settlement of an existing return-recovery asset; Common failure: Missing or duplicate recovery adjustments
Write-down / obsolescence analysis. What it supports: Slow-moving inventory isn’t overstated; Common failure: Obsolete inventory carried at full cost
Physical count / cycle count results. What it supports: Shrink is identified and recorded timely; Common failure: Shrink discovered once a year (and huge)

Document the inventory policies used, the supporting records, and any unresolved differences. The appropriate treatment depends on the reporting framework and the facts.

Step 4: Marketplace fees, reserves, and “where did the money go?”

In ecommerce, a huge part of diligence is simply proving that deductions are complete and classified consistently.

If fees are buried in “misc expense” or netted against revenue inconsistently, you get two problems:

Margin is not comparable month-to-month
A diligence team may propose reclassifications or normalization adjustments when policies or records are inconsistent.

Minimum fee mapping (example categories)

Marketplace referral fees. Where it usually shows up: Settlement statement; What you should do: Map to a consistent “Marketplace Fees” account (don’t bury it)
Fulfillment fees (FBA/3PL pick-pack). Where it usually shows up: Settlement / 3PL invoice; What you should do: Classify by the nature of the cost and reporting framework; apply the supported presentation consistently
Storage / aged inventory fees. Where it usually shows up: Settlement statement; What you should do: Track separately so you can see operational pain early
Chargebacks / disputes. Where it usually shows up: Processor reports; What you should do: Track distinctly; document policy for timing and classification
Reserves / holds. Where it usually shows up: Settlement timing differences; What you should do: Separate “holds/reserves” from normal clearing timing; age it

The “right” classification can depend on your reporting objectives and materiality. The diligence requirement is consistency + support.

Step 5: prepare working-capital schedules

Establish the proposed working-capital definition early enough to prepare comparable schedules.

In many deals, the purchase agreement defines a target net working capital level at closing. If actual net working capital delivered is below the target, purchase price is reduced (and vice versa). Definitions vary by deal, but the mechanics are consistent: working capital is negotiated off your balance sheet.

Working capital schedule (illustrative format)

Accounts Receivable. Amount: $210,000; Support: AR aging ties to invoices/receipts
Inventory. Amount: $680,000; Support: Inventory system + valuation support
Prepaids / other current assets. Amount: $55,000; Support: Invoices/contracts
Total Current Assets (subset). Amount: $945,000; Support:
Accounts Payable. Amount: ($330,000); Support: AP aging + subsequent payments
Accrued expenses. Amount: ($120,000); Support: Accrual schedules
Deferred revenue / gift cards (if current). Amount: ($40,000); Support: Rollforward
Total Current Liabilities (subset). Amount: ($490,000); Support:
Net Working Capital. Amount: $455,000; Support: Must match deal definition

Actual deal definitions may include/exclude cash, debt, taxes payable, and other items. Align your schedule to the LOI/purchase agreement definition.

Prepare the accounts receivable, accounts payable and inventory schedules consistently, and reconcile them to the transaction’s agreed definition.

Step 6: Add-backs that are actually defensible

Document each proposed add-back and any offsetting cost or replacement expense. Acceptance depends on the evidence, transaction terms and intended users.

Add-back support checklist

One-time professional fees. Evidence to provide for review: Invoice + explanation + why non-recurring; What gets rejected: “We always have legal fees” but calling them one-time
Owner compensation normalization. Evidence to provide for review: Payroll/1099 support + market rationale; What gets rejected: Arbitrary “owner add-back” with no benchmark logic
Non-operational settlements/lawsuits. Evidence to provide for review: Settlement agreement + legal invoices; What gets rejected: Recurring disputes treated as non-recurring
Run-rate savings. Evidence to provide for review: Contract termination proof + effective date; What gets rejected: “We plan to cancel this someday”
Accounting cleanup costs. Evidence to provide for review: Clearly scoped cleanup invoices + timing; What gets rejected: Rolling monthly bookkeeping called “cleanup”

Support each proposed adjustment and distinguish recurring costs from genuinely nonrecurring items.

Step 7: The QoE-ready monthly close package

A repeatable monthly close should produce both financial statements and schedules that explain the underlying balances.

QoE-Ready Close Checklist (ecommerce)

Close 1 Bank reconciliation completed. No ancient uncleared items without documentation.
Close 2 Channel settlements reconciled. Shopify/Amazon/processors tie-out to deposits; clearing balances are explainable and aged.
Close 3 Revenue/returns support. Returns/refunds are consistent; reserve logic documented if material.
Close 4 Inventory & COGS support. Inventory system ties to GL; landed cost and write-down logic documented where relevant.
Close 5 AR/AP aging. AR ties to invoices; AP ties to vendor bills; large past due items investigated.
Close 6 Accruals booked. Payroll, 3PL, ad spend, software, interest, captured consistently so periods are comparable.
Close 7 Working capital schedule prepared. Using the same definition each month (or a reconciliation between definitions).
Close 8 Add-back log updated. Nothing “remembered later.” Evidence filed.

Historical differences may need a separate reconstruction before the recurring close produces reliable schedules.

The accounting schedules in this checklist provide inputs for that recurring work. Substantial cleanup and new projects require a separate agreement. This accounting advisory scope does not provide a QoE report, valuation, assurance, or transaction opinion.

Common ecommerce QoE red flags

1) Revenue is “whatever hit the bank”

Net deposits alone do not explain revenue, fees, refunds and reserves. Retain the channel reconciliation that connects them.

2) Inventory is a plug

Unsupported inventory creates uncertainty in both margin and working capital. Identify and resolve gaps before relying on the figures.

3) Returns distort margin

Review both the refund and inventory recovery. Where expected returns were already recognized, actual refunds and returned goods settle or adjust those balances rather than causing duplicate revenue or COGS entries.

4) Add-backs are undocumented

Retain invoices, dates, and a rationale for each proposed adjustment. Acceptance depends on the evidence and the requirements of the intended users.

5) Sales tax exposure is vague

Prepare a state-by-state registration and filing record, together with any specialist assessment of unresolved exposure.

Completion checks

Tied

Revenue bridges to settlements and deposits by channel

Defensible

Inventory/COGS supported by method, landed cost, and reconciliations

Documented

Add-backs supported by invoices, dates, and rationale

Comparable

Accruals and classifications applied consistently month to month

FAQ

What is a Quality of Earnings (QoE) report?

A QoE is a buyer/investor diligence analysis of earnings sustainability. It often normalizes earnings (commonly to Adjusted EBITDA), evaluates revenue and margin quality, and analyzes working capital. It is not an assurance report.

Is a QoE the same as an audit or review?

No. Audits and reviews are assurance services performed under professional standards. A QoE is transaction diligence commissioned by buyers/investors to evaluate sustainability and risk drivers.

What does “investor-ready financials” mean for ecommerce?

It means the financials and supporting schedules are reconciled, consistent, and explainable: revenue ties to settlements/cash, COGS ties to inventory and costing policies, balance sheet accounts reconcile, and add-backs are documented.

What are the most common QoE issues for ecommerce brands?

Net deposits booked as revenue, unreconciled marketplace fees/reserves, inventory/COGS not tied to units and landed cost, missing or duplicate return-recovery adjustments, unclear sales tax liabilities/exposure, and undocumented add-backs.

How many months should be clean before a raise or sale?

Ask the intended users which periods they need. Requests may cover multiple years and a trailing-twelve-month analysis; there is no universal minimum that makes records investor-ready.

What is a working capital peg and why does it matter?

A working capital peg/target is a negotiated normalized level of net working capital expected at closing. Deliver less than target and purchase price is typically reduced. Definitions vary by deal, so the key is clean schedules and alignment to the agreement definition.

Gift-card breakage requires support under the revenue guidance and applicable unclaimed-property law. Old balances are not automatically revenue.

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.