Case study · Finance and accounting

Ecommerce bookkeeping across channels

Company-reported case study

Actigy BPO reconciled channel payouts for Loom & Larder, a UK homeware brand using several marketplaces and payment processors. The case reports bookkeeping results with ledger treatment approved by the client.

Actigy BPO confirms the engagement and supporting records. Results apply to the stated scope and measurement windows.

Reconciliation accuracy

Result

99.8%

Baseline: 94.1%

Window: 4 months

Supporting record: Xero reconciliation report

Owner hours on books

Result

2 / month

Baseline: 12 / month

Window: 4 months

Supporting record: Owner time log

Unmatched transactions

Result

18 / month

Baseline: 540 / month

Window: 4 months

Supporting record: Xero reconciliation report

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.

Reported results: Ecommerce bookkeeping across channels
MeasureBaselineResultWindowSupporting record
Reconciliation accuracy94.1%99.8%4 monthsXero reconciliation report
Owner hours on books12 / month2 / month4 monthsOwner time log
Unmatched transactions540 / month18 / month4 monthsXero 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.

Scope this workflow for your operation

Use the documented workflow, client-held decisions and operational checks to outline a pilot for your own workload.