Case study Ecommerce accounting
Finding the Profit Leaks in a $10M Ecommerce Business
This ecommerce accounting case study shows how an online retailer with about $10M in annual revenue cleared a 200 day backlog in 90 days, rebuilt records that could not be traced, moved to weekly and monthly closes, and stopped $25K a year in leakage at the source.
- Industry
- Ecommerce, online retail
- Annual revenue
- About $10M
- Engagement
- Outsourced bookkeeping and controller support since 2020
- Close cycle
- Weekly close, plus a 3 day month end close
- $25K Annual leakage stopped fixed in the system
- 3 days Month end close books were 200 days behind
- 90 days To clear the backlog 200 days of records rebuilt
- Weekly Close and reporting actual figures, books updated daily
The short version
Sales were growing. The books could not keep up.
Revenue was rising, but the books were about 200 days behind, and most of the historical data could not be traced to a source. Reconciliations were incomplete, payables were handled only as problems surfaced, and leadership was making pricing, purchasing and cash decisions on estimates. We cleared the backlog in 90 days, rebuilding the missing records as we went, then rebuilt the company’s ecommerce accounting in three layers: sound accounting practices with weekly and monthly closes, disciplined reconciliations, streamlined AP and planned cash flow, and a leakage review corrected in the system. Management now works from actual figures every week, and $25K a year that was leaking out unnoticed has stopped.
The challenge
High volume, low visibility
What leadership was seeing
- Books about 200 days behind, so reports were too late to act on
- Most historical transactions with no traceable source document
- Bank and payout balances that did not match the books
- Vendor bills and credits handled case by case, with no approval trail
- Receivables with no regular follow up
- Margins that looked healthy on paper but did not show up as cash
What the finance function had, and lacked
Had
- Accounting software
- Sales and payout data from each channel
Lacked
- A documented month end close
- Complete monthly reconciliations
- A set routine for AP and AR
- Records that could be traced to source
- Actual figures leadership could trust
The business was not short of data. It was short of books that matched the bank.
Root cause identified at the start of the engagement
The solution
A three layer accounting control system
Each layer answers one question leadership could not answer before.
How the work was sequenced
Phase 1 · Catch up, 90 days
Rebuild 200 days of records
Most transactions had no traceable source. We worked back from bank statements, channel reports and vendor records to identify each one, then reconciled every account to the bank. Done in 90 days.
Phase 2 · Stabilize
Stop it falling behind again
Restructure the chart of accounts, connect daily sales and payout feeds, put bills through approval and introduce a written close checklist.
Phase 3 · Run and improve
Close weekly and monthly, then find leaks
With current, reconciled books, a weekly close starts, the monthly close drops to 3 days and the leakage review has clean data to work from.
Layer one
Accounting practices and live reporting
Objective: bring the books up to date, keep them there, and give leadership current numbers.
What we put in place
- Chart of accounts built for ecommerce
- Month end close checklist and calendar
- Cutoff and accrual rules
- Review and sign off at every close
Actions
- Cleared about 200 days of unrecorded activity in 90 days, tracing transactions that had no supporting records
- Gave gross sales, returns, platform fees, payment processing fees and shipping their own lines, by channel
- Connected sales and payout data so the books update daily
- Built reports on actual figures: profit and loss by channel, cash position, and AP and AR aging
From about 200 days behind to closed within 3 days of month end, with every account reconciled before sign off.
A weekly close, and a 3 day month end close
Every week, the team closes cash, sales, payouts and payables so management sees actual figures within days. At month end, the full close runs on a fixed 3 day calendar:
Day 1
Reconcile
- Bank and credit card accounts
- Processor and marketplace payouts against recorded sales
- Refunds and chargebacks
Day 2
Adjust
- Payables cutoff and accruals
- Cost of goods sold and inventory
- Receivables aging and follow up
Day 3
Review and report
- Controller review and sign off
- Leakage checks on fees, refunds and shipping
- Reporting pack issued to leadership
Results
- Backlog of about 200 days cleared in 90 days
- Weekly close, and books closed within 3 days of month end
- Profit and loss, cash and aging reports on actual figures, updated daily
- One version of the numbers for leadership
Strategic impactDecisions moved from numbers more than six months old to this week’s.
Layer two
Reconciliations, AP and cash flow
Objective: make every balance tie out, streamline payables, and plan cash instead of reacting to it.
We reconcile these accounts every month:
- Operating bank accounts
- Credit cards
- Payment processor and marketplace payouts
- Accounts payable to vendor statements
- Accounts receivable
Accounts payable, streamlined
- Bills entered and coded on receipt
- Approval required before payment
- Vendor statements reconciled monthly
- Payment runs on a fixed schedule
Cash flow and receivables
- Weekly cash position from reconciled balances
- Payment runs timed against cash on hand
- Every payout matched to what was due, with short payments chased
Results
- All accounts reconciled every month
- AP streamlined: bills paid on schedule, with approvals on record
- Cash flow planned weekly from actual balances
Strategic impactManagement stopped working from estimates. Cash, payables and the balance sheet now show actual figures every week.
Layer three
Leakage review and system fixes
Objective: find where money was leaving the business unnoticed, and correct it at the source.
Where we looked
- Platform and marketplace fees
- Payment processing fees
- Refunds and returns
- Shipping charged against shipping paid
- Vendor bills and credits
- Duplicate and recurring charges
How leaks like these usually happen
Netted payouts
Channels deposit sales after fees, refunds and holds. If only the net deposit is recorded, overcharged fees and unrecovered refunds never appear as a cost anyone reviews.
Settings that drift
A changed fee plan, a shipping rule or an integration mapping can misstate costs on every order until someone checks the setting itself.
Credits nobody claims
Vendor credits, duplicate charges and returns that were refunded but never received back are easy to miss when the books run months behind.
What we found
Why $25K matters$25K is 0.25% of revenue, and all of it is profit. For example, at a 10% net margin on $10M, it equals 2.5% of the year’s net profit, every year, from fixes that are now permanent.
Actions
Each finding was traced to its cause in the system: a setting, a mapping or a missing control. We fixed it there, so it no longer depends on someone catching it each month.
- Corrected the system settings and account mappings behind each leak
- Added leakage checks to the monthly close, so a recurrence shows up within one month
Results
- $25K a year in leakage stopped
- Fixes made in the system, not in month end adjustments
- Leakage review built into every close
Strategic impactLeakage stopped being invisible. It became a line someone reviews every month.
Consolidated impact
The numbers, before and after
| Metric | Before | After | Change |
|---|---|---|---|
| Backlog | About 200 days, largely untraceable | Cleared and reconciled | In 90 days |
| Close cycle | 200 days behind | Weekly, plus 3 day month end | 197 days sooner |
| Management figures | Estimates | Actuals, updated daily | Every week |
| Accounts reconciled monthly | Partial | All | 100% |
| Accounts payable | Handled ad hoc | Streamlined, with approvals | On schedule |
| Cash flow | Reacted to | Planned weekly | Optimized |
| Annual leakage | $25K, unnoticed | Stopped at source | $25K a year |
Every dollar of leakage stopped goes straight to operating profit, and current numbers let leadership act on it in the same month.
Operational transformation
How the finance function changed
Before
- Books 200 days behind, records untraceable
- Decisions made on estimates
- AP and AR handled ad hoc
- Leaks hidden inside net payouts
After
- Weekly and monthly closes on actual figures
- Every account reconciled monthly
- Streamlined AP and planned cash flow
- Leakage checks in every close
Key insights
Three lessons for any online seller
A sale is not cash until it reconciles
Fees, refunds and holds sit between the order and the deposit. Without payout reconciliation, you do not know your real margin.
Small leaks scale with volume
An error worth cents on one order becomes real money across thousands of orders a month.
Fix the system, not the month
A journal entry corrects one month. Correcting the setting behind it corrects every month after.
Is this your business?
Signs your store is leaking profit
- Your books close weeks or months after month end
- Deposits from your sales channels do not match recorded sales
- You cannot say what you paid in platform and processing fees last month
- Vendor bills and customer balances get attention only when someone complains
If any of these apply, the same three layers can show you where profit is slipping away. Learn more about our ecommerce bookkeeping work.
What you receive
Three standing deliverables
- Live reporting packProfit and loss by channel, cash position and AP and AR aging, through our financial reporting services.
- Monthly close with full reconciliationsBank, card and payout reconciliations plus scheduled accounts payable and accounts receivable, as part of our outsourced bookkeeping.
- Leakage reviewFees, refunds, shipping and vendor charges checked every close, supported by our outsourced controller services.
We keep your numbers current, reconciled and complete, so profit does not slip away unnoticed.
Big Accountants
Find out where your store is leaking profit
If your books run behind or your deposits never quite match your sales, money is likely leaving the business unnoticed. We will review your reconciliations, fees and payables, and show you where to start, with a written quote.
Client name withheld for confidentiality. Figures reflect this client’s engagement; the margin example in the leakage section is illustrative. Results differ by business. This page is general information, not tax, legal or accounting advice.
