EveryBooks / Industries / Consumer & e-commerce / Channel revenue reconciliation
Consumer & e-commerce
Channel revenue reconciliation
Marketplace payouts, fees and point of sale sales reconciled to the ledger every period, with the differences named rather than plugged.
Who this is for. Controller or finance lead at a brand selling through marketplaces, retail and its own site.
The problem today
A marketplace payout is a net number covering a period that does not match your month, after fees that are not itemised the way your chart of accounts expects. Reconciling it properly means rebuilding gross sales, fees, refunds and reserves from the settlement detail.
Most teams do not have time, so the payout is posted to a holding account and reconciled quarterly, or never. Fee changes, short payments and chargebacks disappear into the difference, and gross margin by channel becomes an estimate.
What we deliver
Settlement detail rebuilt into the ledger
Gross sales, fees, refunds, reserves and adjustments posted to the right accounts rather than netted into one line.
Payouts reconciled to the bank
Each deposit tied to the settlement it represents, with timing differences identified as timing rather than left as a balance.
Point of sale to general ledger journals
Daily or weekly store sales, tender types, discounts and tax posted as proper journals, tied back to the point of sale summary.
Short payments and chargebacks flagged
Payments that do not match expectation identified and categorized while a claim is still possible.
Fee changes surfaced
When a marketplace changes a fee rate or adds a charge, the change is visible in the period it happens, which is when you can still react to it.
Margin by channel that holds up
Because the fees and the refunds are in the right place, the channel profitability number is something you can act on.
What agents do, and what your team approves
What the agents do
Agents retrieve the settlement and point of sale data, rebuild the detail, prepare the journals, perform the reconciliation and flag every difference.
What they never do
Journals are posted by your team after review, and claims against a channel are raised by a person. Agents prepare and flag, your controller decides.
Systems we work with
- Amazon
- Shopify
- Stripe
- QuickBooks
- Point of sale systems
From past work
What we have built
We automated marketplace invoice retrieval and receivables monitoring, and built point of sale to general ledger posting, for brands and for the firms serving them. The recurring lesson is that the reconciliation has to be built to expect format changes, because they arrive without notice.
Questions we get
Which channels do you support?
The large marketplaces, the main commerce platforms, the common payment processors and most point of sale systems. The honest constraint is data access: if a channel gives you settlement detail, we can reconcile it, and if it only gives you a net number then nobody can.
How are fees and refunds handled?
Broken out and posted to their own accounts, by fee type, rather than netted against revenue. That is usually the single biggest improvement to margin reporting that this work produces.
How often does it run?
As often as the channel settles, which for most marketplaces means every payout cycle. Reconciling at settlement rather than at month-end is what makes the differences recoverable.
What about historical periods we never reconciled?
We can work backwards, and we will tell you when the cost of doing so exceeds what you are likely to recover. Often the right answer is to clear the holding account with a documented adjustment and start clean.
Related
- Sales tax complianceMulti-state sales tax filed accurately and on time.
- International entity accountingForeign entities and currencies managed in one place.
- Client accounting automationClient bookkeeping and reconciliations run with far less manual work.
- All Consumer & e-commerce workMarketplaces, stores and your own website never agree with the ledger on the first pass.
- How we workRead the books, design for agents, ship them, train your operators, then run and improve.