Client profile
Loom & Larder, a UK direct-to-consumer homeware brand with 60 staff.
Challenge and scope
Shopify, Amazon, and three processors generate daily mismatches. The owner spends 12 hours a month resolving them.
A single marketplace payout can include sales, refunds, fees, and reserves from several days of activity. The ledger can show a clean net deposit while the order-level breakdown stays unresolved. That makes it hard to explain a balance to the owner or pick up an exception that remained open at the prior close.
Delivery workflow
Match orders, fees, refunds, and settlements to the Xero ledger across 9,000 monthly transactions and five sales channels. Queue unreconciled balances for review before the books close.
Use the payout ID to join storefront orders and settlement lines to the deposit in Xero. Break out fees, refunds, chargebacks, and other adjustments using the brand’s approved account mapping. Carry items that are expected to clear later with a reference to the source channel and the next settlement date.
Review exceptions by value, age, and cause. Document missing payout lines and mapping differences separately because the corrective work goes to different owners. Give the owner a short reconciliation schedule for each sales channel with the beginning balance, activity, adjustments, and ending amount.
Delivery team
Romania, about 3 FTE. 1 bookkeeping lead and 2 reconciliation associates.
Systems and tools
Xero, Shopify, Amazon Seller Central, Stripe.
Client decision rights
The brand owns tax filings, changes to the chart of accounts, and owner draws.
Early milestone
In week 3, the monthly count of unmatched transactions reaches 210.
Outcomes
Company-reported results, with the baseline, measurement window and supporting record described for each measure.
| Measure | Baseline | Result | Window | Supporting record |
|---|---|---|---|---|
| Reconciliation accuracy | 94.1% | 99.8% | 4 months | Xero reconciliation report |
| Owner hours on books | 12 / month | 2 / month | 4 months | Owner time log |
| Unmatched transactions | 540 / month | 18 / month | 4 months | Xero reconciliation report |
Interpreting the results
In this case, reconciliation accuracy improves while unmatched transactions fall from 540 to 18 a month. Compare counts together with the value and age of the remaining differences. A bookkeeping review should be able to trace an unusual refund or reserve from the marketplace statement to the approved ledger treatment.
Recommendations for new clients
For brands selling on at least three channels, verify the match rate against a sample that includes returns, processor fees, and payout timing differences.
Provide the last two settlement periods and a sample with partial returns, currency conversion, processor fees, and marketplace holds. Agree treatment for cutoffs and refunds that clear later. Have the owner review the first month-end schedule against bank activity and confirm the account mapping before the team takes on new channels.