Ecommerce reconciliation

What is ecommerce reconciliation?

Ecommerce reconciliation answers one question: does the money you earned match the money you received and the numbers in your books? Three things have to tie out: the order (what the customer bought), the payment/payout (what the processor actually deposited after fees, refunds, and reserves), and the general ledger entry (what your accounting system recorded). When all three agree, revenue is trustworthy. When they don't, you have a discrepancy to find.

For a single-channel seller with low volume this is manageable. For a brand selling thousands of orders across Shopify, Amazon Seller, and TikTok Shop, with Stripe, PayPal, and other processors settling on different timelines, it becomes a data wrangling exercise.

Why ecommerce reconciliation is hard

Ecommerce breaks the simple "one sale, one payment" model that traditional accounting assumes:

• Bundled payouts. Shopify, Amazon Seller, Stripe, and TikTok bundle dozens of orders, fees, refunds, and reserves into a single net deposit. The number that hits your bank is not the number you sold.
• Fee waterfalls. Referral fees, FBA fulfillment, advertising, processor fees, and reserves are all netted out before you're paid, and each has to be booked to the right account.
• Payout timing. Payouts settle days after the sale, so revenue and cash land in different periods.
• Refunds, chargebacks, and returns. These arrive on their own schedules, often disconnected from the originating transaction, sometimes 30–60 days later.
• Multi-channel, multi-processor, multi-entity. Complexity compounds with every channel, processor, currency, and legal entity you add.

The result: the bundled bank deposit becomes the number-one source of misstatement, and finance teams spend days each month matching payouts and investigating discrepancies in spreadsheets.

How ecommerce reconciliation works: the three-way match

At its core, reconciliation is a three-way match across every channel, every period:

1. Order: the sale recorded in your commerce platform (e.g., a $248 Shopify order).
2. Payment: what the processor charged and settled (e.g., $248 authorized, less a $10.78 Stripe fee).
3. Payout / bank deposit: the net cash that actually landed in your bank (e.g., $237.22).

Reconciliation ties order → payment → payout, accounts for every fee, refund, and reserve in between, and posts the correct entries to your general ledger so the books reflect reality rather than a bundled "mystery number."

Manual reconciliation vs automated reconciliation

How Blue Onion automates ecommerce reconciliation

Blue Onion is the financial intelligence platform for ecommerce. Before any reporting happens, it connects to your sales channels, payment processors, and bank accounts and reconciles every order to every payout at the transaction level, building one continuously reconciled source of truth.

On that foundation, the Close module:

• Decomposes every bundled payout (Shopify, Amazon Seller, TikTok Shop, Stripe) back to the underlying orders, fees, refunds, and reserves.
• Performs the order → payment → payout three-way match automatically across every system.
• Posts daily summary journal entries to NetSuite, QuickBooks, or Xero with a full audit trail, turning a 5–10 day close process into quick review.
• Handles ASC 606 revenue recognition, deferred revenue, gift cards, returns and chargebacks, and multi-currency FX.
• Auto-detects and books adjustments when source data changes in historical periods (Smart Adjustments), so the books stay accurate.

That reconciled foundation is also what makes the rest of the platform work: Fabric exposes the clean data to APIs, models, and AI agents, and Edge (coming soon) will tell you what happened and why so you can turn insights into action.

Who needs automated ecommerce reconciliation

Blue Onion is built for growing and mid-market ecommerce and retail brands, typically $10M–$500M+ in annual revenue, usually operating across multiple channels, processors, and entities, and closing in NetSuite, QuickBooks, or Xero. If your team spends days each month reconciling payouts and investigating discrepancies in spreadsheets, that's the signal you've outgrown manual reconciliation.

FAQ

What is ecommerce reconciliation?

Ecommerce reconciliation is the process of matching every sale to the cash received and the entries posted to your general ledger, tying orders and refunds to processor payouts, bank deposits, and fees across every sales channel.

Why doesn't my order revenue match my bank deposit?

Because processors bundle many orders into one net payout and subtract fees, refunds, and reserves before depositing. The bank deposit is net; your order revenue is gross. Reconciliation breaks the payout back down so both tie out.

What is a three-way match in ecommerce accounting?

It's matching the order, the payment the processor settled, and the bank deposit that landed, accounting for every fee and refund in between, then posting the correct GL entry.

Can ecommerce reconciliation be automated?

Yes. Platforms like Blue Onion reconcile at the transaction level across channels, processors, and banks continuously, surface discrepancies automatically, and post ERP-ready journal entries, replacing the monthly spreadsheet exercise.

How long does it take to close the books with automated reconciliation?

Blue Onion customers typically move from a 5–10 day close to a quick review, because reconciliation and journal entries happen daily rather than at month-end.