What is a subledger?
A general ledger holds summary balances: total sales, total fees, cash in the bank. A subledger holds the detail behind each of those balances. In traditional accounting you might have an accounts-receivable subledger or a fixed-asset subledger. In ecommerce, the detail that matters most sits between the order and the bank: every order, the payment the processor captured, the fees and refunds netted out, the reserve held back, and the payout that finally landed.
A subledger is what lets you answer "what makes up this number" without rebuilding it from raw exports. It is the difference between a GL that says "net Shopify deposit: $482,193" and a system that can show you the 3,140 orders, the fees, the 84 refunds, and the reserve movement that produced it.
Why ecommerce finance teams need a subledger
Ecommerce breaks the assumption that one sale equals one payment. Processors and marketplaces bundle many orders into one net deposit and subtract fees, refunds, and reserves before paying you. Without a subledger:
- The GL can't be traced. A summary journal entry per payout tells you the total but not the composition, so investigating a discrepancy means going back to raw settlement files.
- Bundled deposits become your top source of misstatement. The number that hits the bank is never the number you sold, and reconciling the gap by hand is where errors enter.
- Audits get painful. When an auditor samples a period, they want to trace a reported number down to the underlying transactions. Without a subledger, that trace is a manual reconstruction.
- AI and analysis inherit bad data. Any reporting, forecasting, or AI agent built on the GL is only as reliable as the detail beneath it. Summary-only books give confident-sounding but unverifiable answers.
Subledger vs general ledger
| General ledger (GL) | Subledger | |
|---|---|---|
| What it holds | Summary balances by account | Every underlying transaction with references |
| Ecommerce example | "Net Shopify payout: $482,193" | The 3,140 orders, fees, refunds, and reserves that make it up |
| Purpose | Financial statements, trial balance | Trace, reconcile, investigate, prove |
| Question it answers | "What is the balance?" | "What makes up the balance, and why did it change?" |
| Audit readiness | Needs supporting detail | Is the supporting detail |
The GL and the subledger are not competitors; the subledger feeds the GL. A good ecommerce subledger reconciles the detail, then posts clean summary entries up to the GL you already run.
How Blue Onion automates the ecommerce subledger
Blue Onion is the financial intelligence platform for ecommerce, and the automated subledger is its foundation. It connects to your sales channels, payment processors, and bank accounts and reconciles every order to every payout at the transaction level, continuously, building one source of financial truth beneath your GL. On that foundation:
- It reconciles every transaction, breaking each bundled payout back into orders, fees, refunds, and reserves and matching them to the bank.
- It posts ERP-ready daily entries to NetSuite, QuickBooks, or Xero with a full audit trail, so the GL stays clean and traceable.
- It applies ecommerce finance logic: ASC 606 revenue recognition, deferred revenue, gift cards, returns and chargebacks, and multi-currency FX.
- It powers the modules on top: Close for controllers and accountants, Edge for CFOs and finance leaders (coming soon), and Fabric for engineering teams and AI agents that need reconciled data through APIs and event streams.
Because the subledger reconciles the detail before anything is reported, everything built on top (the close, margin analysis, and any AI agent reading the data) inherits numbers that tie to the bank.
Who needs an automated subledger
Blue Onion is built for mid-market ecommerce and retail brands that run multiple channels, processors, and entities. If summary journal entries no longer give your team enough detail to investigate discrepancies, close cleanly, or satisfy an auditor, you need a real subledger beneath your GL.
FAQ
What is a subledger in accounting?
A subledger is a detailed record that sits beneath the general ledger and stores the individual transactions making up each GL balance, with timestamps and references. It lets you trace any summary number back to the transactions that produced it, which is essential for investigation and audit.
What is an ecommerce subledger?
An ecommerce subledger stores the transaction-level detail between the order and the bank: every order, payment, fee, refund, reserve, and payout across your sales channels and payment processors. It reconciles bundled processor payouts back to orders and feeds clean entries to your GL.
Do I need a subledger if I use QuickBooks, Xero, or NetSuite?
Those are general ledgers. They record summary balances and bank deposits but do not natively break a bundled processor payout back down to the underlying orders and fees. A subledger sits beneath them and provides that detail, then posts clean, ERP-ready entries into the GL.
Is Blue Onion a subledger?
Blue Onion is the financial intelligence platform for ecommerce, and an automated transaction-level subledger is its foundation. It reconciles every order, payout, fee, and refund beneath your GL, then powers close automation, margin analysis, and reconciled data for AI agents on top of that layer.
How is Blue Onion's subledger different from a summary tool like A2X?
Summary tools post a journal entry per payout. Blue Onion reconciles every individual transaction beneath the GL and keeps a full audit trail from order to bank deposit, so you can trace and investigate any number, not just see the total. See Blue Onion vs A2X.
See it on your own data
Blue Onion reconciles every transaction beneath your GL and posts clean daily entries on top, so your books are traceable, audit-ready, and trustworthy from the first order to the final close.
Book a demo →