How a multi-entity, multi-channel auto-parts seller turned a tangle of marketplace payouts into one reconciled ledger through disciplined ecommerce bookkeeping.
Business Background
The client is a multi-entity ecommerce group that sells European auto parts directly to consumers online. Like many growing online sellers, it does not live on a single storefront. Orders arrive through Amazon in both the United States and Canada, through Walmart Marketplace, through eBay, and through its own Shopify store — and the money flows back through marketplace payouts, PayPal, and several business credit cards.
The business also runs across more than one legal entity. A separate logistics and fulfillment entity and a related operating company sit alongside the main seller, and stock, sales, and costs move between them. The financials for each entity are kept in QuickBooks Online.
That setup is excellent for sales reach, but it is hard on the books. Every channel pays on its own schedule, in its own format, net of its own fees, refunds, and reimbursements — and none of them were built to reconcile cleanly to a general ledger, let alone to each other or to inventory. This is precisely the kind of complexity that disciplined ecommerce bookkeeping exists to solve.
Key Challenges – Ecommerce Bookkeeping
A single bank deposit from a marketplace is never a single sale. It is a batch — dozens or hundreds of orders, minus commission, minus advertising, minus refunds and chargebacks, plus reimbursements — landing days or weeks after the orders themselves. Multiply that across four channels, two currencies, and several entities, and the ecommerce bookkeeping problem compounds fast. The open items spanned the entire revenue-to-cash cycle:
- Marketplace settlements. Amazon settlements (USD and CAD) had to be broken into sales, fees, refunds, and reimbursements and tied to the actual deposits, settlement period by settlement period. Walmart Marketplace biweekly payouts had to be reconciled to sales and refunds, not booked as lump-sum deposits. eBay sales and refunds had to be captured separately for each operating entity, and Shopify and PayPal transfers matched into the right entity’s books.
- Refunds, credit memos & reimbursements. Refunds and credit memos needed matching checks and entries so returned money was reflected accurately rather than overstating revenue, and marketplace reimbursements for lost or damaged inventory and fee corrections had to be recognized so the books matched the cash actually received.
- Banks, cards & clearing accounts. Multiple business credit cards across the entities had to be updated and reconciled, deposits and balances matched to date, and clearing accounts brought back to zero rather than left holding unexplained balances.
- Inventory & intercompany. New inventory items had to be created and item receipts recorded, with the inventory offset account cleared so stock and cost of goods told a consistent story; intercompany sales and AR between the entities had to be reconciled, and aged AR and AP brought current.
All of this had to happen while older periods were still being cleaned up — so the team was closing current activity and clearing the backlog at the same time.
Impact
Left unreconciled, this kind of multi-channel sprawl quietly distorts the numbers an owner relies on. Lump-sum payouts overstate revenue when fees and refunds are not stripped out. Inventory and cost of goods drift out of line when receipts and offset accounts are not cleared. Clearing accounts and aged AR/AP accumulate unexplained balances that make every report suspect. Without dependable ecommerce bookkeeping, the owner could not confidently answer a basic question: how much did we actually make, by channel and by entity?
Requirements & Expectations – Ecommerce Bookkeeping
The client needed more than a one-time cleanup. The expectation was a dependable, repeatable ecommerce bookkeeping process that would, every period:
- Decompose each marketplace payout into sales, fees, refunds, and reimbursements tied to the cash that actually landed.
- Post every transaction to the correct entity and keep intercompany activity in agreement.
- Keep inventory and cost of goods aligned with what was being sold across channels.
- Reconcile all bank, card, and payment-processor balances to date.
- Clear the historical backlog without falling behind on current months.
Strategic Approach – Ecommerce Bookkeeping
GATP treated the engagement as a repeatable reconciliation engine rather than a pile of one-off fixes. The guiding principle of our ecommerce bookkeeping approach is simple: every payout must be turned into sales, fees, and refunds, tied to cash, in the right entity, every period. The work broke into four connected tracks that run on the same cadence each month, so the consolidated picture holds together instead of being rebuilt from scratch.
Comprehensive Solution – Ecommerce Bookkeeping
- Channel-by-channel settlement reconciliation. For each marketplace we built and imported structured sales, refund, and reimbursement schedules — Amazon (USD and CAD), Walmart, and eBay — and tied every settlement back to the deposit that landed in the bank. Each payout is decomposed into its parts instead of being dropped in as a single number.
- Entity-aware bookkeeping. Sales, fees, and refunds are posted to the correct entity’s QuickBooks file, and intercompany activity and AR between the entities are reconciled so the consolidated picture holds together — not just each company on its own. This entity discipline is what keeps multi-entity ecommerce bookkeeping trustworthy.
- Inventory & cost discipline. New items are set up in the books as they appear, item receipts are recorded, and the inventory offset account is cleared so stock and cost of goods sold stay aligned with what is actually selling across channels.
- Banks, cards & clean-up in parallel. Credit cards and payment-processor balances are updated and reconciled to date, clearing accounts are emptied, and older uncleared transactions and aged AR/AP are worked down so current months close on a clean base.
Measurable Results – Ecommerce Bookkeeping
Because every channel is decomposed and tied to cash the same way each period, the client now gets one reconciled set of books across all four marketplaces and both currencies, with each entity’s ledger and the intercompany flows between them kept in agreement. Marketplace payouts reconcile to actual sales and refunds rather than sitting as unexplained deposits; inventory and cost of goods stay tied to the offset account; and the bank, card, and payment balances are current. This is what consistent ecommerce bookkeeping delivers in practice.
4Marketplaces reconciled to cash |
2Currencies tied to deposits |
MultipleEntities kept in agreement |
1Clean, consolidated ledger |
Key Takeaway – Ecommerce Bookkeeping
Multi-channel ecommerce doesn’t break because any one marketplace is hard. It breaks because each channel reports differently, pays differently, and never reconciles itself — and the gaps hide in fees, refunds, currency, inventory, and the spaces between entities. The fix is disciplined, repeatable ecommerce bookkeeping that turns every payout into sales, fees, and refunds tied to cash, in the right entity, every period.
Client Impact
Just as important as clean books is trust. Because the backlog and the current work move together — older uncleared items get cleared while each new settlement period is reconciled on schedule — the owner can finally rely on the numbers behind a complex, multi-channel operation. Decisions about pricing, inventory, and channel mix now rest on financials that match the cash in the bank. Reliable ecommerce bookkeeping turned a tangle of feeds into a single, trustworthy picture.
Let’s Talk
If you sell across Amazon, Walmart, eBay, or Shopify — in one entity or several — and your books never quite match your payouts, that is exactly the ecommerce bookkeeping work GATP does. We turn many feeds into one reconciled set of books you can actually trust.
