Outsourced accounting for US businesses
mail@bigaccountants.com
+1 469 607 0077
ookkeeping and Accounting Services for Small Businesses
  • Home
  • Services
    • Bookkeeping
      Outsourced BookkeepingA full team for businesses and CPA firmsSmall Business BookkeepingMonthly books, reconciled and reviewedVirtual BookkeepingFully online, US business hoursCatch Up BookkeepingBehind on your books? Fixed quote
      Accounting and Reporting
      Accounts PayableBills coded, approved and paid on timeAccounts ReceivableInvoicing, collections and DSOController ServicesMonth end close and internal controlsFinancial ReportingMonthly statements and lender packsBusiness IntelligenceKPI dashboards from clean books
      Tax, CFO and Advisory
      Tax Preparation and FilingBusiness returns, prepared and e-filedVirtual CFO ServicesForecasts, budgets and KPIsConsulting and AdvisoryProcesses, controls and systemsSoftware ImplementationQuickBooks, Xero and Zoho Books
      Not sure where to start?Tell us what is taking up your time. We will recommend the right services and send a clear quote.
      Book a free callView all servicesHow pricing works
  • Industries
    • Commerce

      EcommerceShopify, Amazon and marketplace salesRetailStores, inventory and sales taxWholesale and DistributionInventory, margins and receivables

      Operations

      ManufacturingJob costing and cost of goods soldConstruction and ContractorsJob costing, WIP and retainageRestaurantsFood cost, tips and daily sales

      Professional and Property

      HealthcarePractices, clinics and suppliersReal Estate and PropertyRentals, owner statements and reportsAccounting FirmsWhite label bookkeeping support

      Specialists in your industryIndustry specific charts of accounts, reports and KPIs, from a team that already knows your business model.
      Book a free callAll industriesHow pricing works
  • Pricing
  • Insights
    • Guides

      How Bookkeeping Pricing WorksFixed, hourly or per taskBusiness Tax Filing Deadlines1120-S, 1065, 1120 and 7004Cash vs Accrual vs GAAPWhich reporting basis fits youAI in Accounting, ExplainedWhat AI does and what people check

      Finance Explained

      Bookkeeper vs Controller vs CFOThree roles, explained simplyHow to Calculate DSOFormula and collection KPIsFinance KPIs That MatterMargins, cash and turnoverIn House vs Outsourced BookkeepingCost, review and cover compared

      Latest insightsPractical articles on bookkeeping, tax deadlines and finance for US business owners.
      Book a free callAll articles
  • About
  • Contact
Book a free call

Finding the Profit Leaks in a $10M Ecommerce Business

Posted on 12 Nov at 6:54 am
No Comments

Home / Insights / Ecommerce accounting case study

Case study · Ecommerce accounting · Nov 10, 2026

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.

01Accounting practices and live reportingCan we trust today’s numbers? 02Reconciliations, AP and cash flowDoes every balance tie out? 03Leakage review and system fixesWhere is money slipping away?

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.

01

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
Days between month end and closed books
Before 200
After 3

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.

02

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.

03

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

$25Ka year leaving the business unnoticed, across the areas we reviewed

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

MetricBeforeAfterChange
BacklogAbout 200 days, largely untraceableCleared and reconciledIn 90 days
Close cycle200 days behindWeekly, plus 3 day month end197 days sooner
Management figuresEstimatesActuals, updated dailyEvery week
Accounts reconciled monthlyPartialAll100%
Accounts payableHandled ad hocStreamlined, with approvalsOn schedule
Cash flowReacted toPlanned weeklyOptimized
Annual leakage$25K, unnoticedStopped 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

1

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.

2

Small leaks scale with volume

An error worth cents on one order becomes real money across thousands of orders a month.

3

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

  1. Live reporting packProfit and loss by channel, cash position and AP and AR aging, through our financial reporting services.
  2. Monthly close with full reconciliationsBank, card and payout reconciliations plus scheduled accounts payable and accounts receivable, as part of our outsourced bookkeeping.
  3. 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.

Book a free ecommerce accounts review Read the next case study

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.

Previous Post
2026 Vendor Reporting Guide: Prepare Your Records Before Year End

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Recent Posts

  • Finding the Profit Leaks in a $10M Ecommerce Business November 12, 2026
  • 2026 Vendor Reporting Guide: Prepare Your Records Before Year End November 2, 2026
  • Auto Draft April 20, 2026
  • Stop Losing Profit You Don’t Know You’re Losing – Case Study April 18, 2026
  • AI in Accounting, How Smarter Workflows Save Time and Improve Accuracy March 26, 2026

Categories

  • Accounting (6)
  • Best Practices (4)
  • Blog (7)
  • Case Study (2)
  • Sales Tax Compliance Guide (3)
  • Success Stories (3)

Big Accountants

Outsourced accounting, bookkeeping and tax services for US businesses. One dedicated team, every close reviewed twice, at competitive pricing.

  • QuickBooks ProAdvisor
  • Xero Certified Advisor
  • Zoho Books Certified

Free assessment

Talk to an accountant this week

A 30 minute call, a written quote and no obligation. Fixed monthly, hourly or per task pricing.

Book a free call +1 469 607 0077

Bookkeeping

  • Outsourced Bookkeeping
  • Small Business Bookkeeping
  • Virtual Bookkeeping
  • Catch Up Bookkeeping
  • Bookkeeping Pricing

Accounting and Reporting

  • Accounts Payable
  • Accounts Receivable
  • Outsourced Controller
  • Financial Reporting
  • Business Intelligence

Tax, CFO and Advisory

  • Tax Preparation and Filing
  • Virtual CFO Services
  • Consulting and Advisory
  • Software Implementation
  • All Services

Industries

  • Ecommerce
  • Retail
  • Wholesale and Distribution
  • Manufacturing
  • Construction
  • Restaurants
  • Healthcare
  • Real Estate
  • Accounting Firms
  • All Industries

Company

  • About Us
  • Insights and Case Studies
  • AI Accounting Services
  • Engagement Models
  • Make a Payment
  • Contact Us

USUnited States

Client relationships

14455 Webb Chapel Road, Suite 201
Farmers Branch, TX 75234

+1 469 607 0077

UKUnited Kingdom

Account management

Wootton, Northampton
NN4 6RX

mail@bigaccountants.com

INIndia

Delivery centre

L-3, Pathadipalam, Kalamassery
Kochi, Kerala 682033

+91 701 232 4405

Reach us

  • mail@bigaccountants.com
  • WhatsApp us
  • Book a free call
  • LinkedIn
  • Facebook
  • Instagram

© 2026 Big Accountants. All rights reserved.

  • Privacy Policy
  • Terms and Conditions
  • Cancellation and Refund Policy
  • Sitemap

Content on this website is general information and is not tax, legal or accounting advice for your situation. A client relationship begins only when an engagement letter is signed.

We use essential cookies to keep our website working. With your permission, we also use optional cookies to understand how visitors use our site and improve your experience. Select “Accept All” to allow optional cookies or “Reject Optional” to use essential cookies only.