Before export
Preview the sales summary or invoice output and check mappings before Xero is changed.
Day-to-day reconciliation
ClearCommerce for bookkeepers who need ecommerce month end to stop being detective work
Bookkeepers are often the first people to see the practical mess: gateway deposits that do not equal sales, refunds in the wrong period, thousands of retail invoices and BACS orders that look paid when they are not.
Daily workload
Replace repetitive cleanup with a repeatable evidence trail
During reconciliation
Use separate payment clearing mappings so Stripe, PayPal and manual methods do not become one unexplained balance.
When something fails
Read the sync history, correct the problem and retry without building a second copy of the same accounting record.
At month end
Trace refunds and source references without rebuilding the ecommerce sales calculation in a spreadsheet.
Bookkeeping questions ClearCommerce is designed to answer
Why is the bank payout lower than sales? The gateway clearing account separates gross captured money from fees and later settlements.
Why is this order in Tuesday's sales? The export profile shows whether the store groups by paid date, created date or another configured basis.
Why is this BACS invoice still outstanding? Its payment mapping can deliberately leave it unpaid until the transfer arrives.
Was this refund exported already? Source and Xero references remain in the history so the answer does not depend on memory.
Monthly workflow
What a bookkeeper reviews each period
- Confirm daily summaries reconcile against gateway payout evidence
- Check the payment clearing account balance is fully explained
- Review any flagged or failed exports before period close
- Confirm VAT rates applied match the return being prepared
Questions people ask
FAQs
Can a bookkeeper access client mappings without changing them?
Access can be scoped so a bookkeeper reviews mappings, exports and clearing balances without needing to alter connector settings.
Does ClearCommerce reduce month-end reconciliation work?
Daily summaries and mapped clearing accounts are designed to leave a shorter, more explainable list of items to check at month end rather than eliminating review entirely.
Can bookkeepers manage multiple client companies from one login?
Yes. Each client remains a separate company with its own stores, mappings and Xero connection.
Related reading
Related pages
Bring the reconciliation task you hate most
We will use that task as the demo scenario instead of walking through generic slides.