Daily ecommerce sales summaries in Xero
Replace thousands of retail invoices with one controlled, traceable sales summary per paid day.
Group by the date the money was captured
For retail ecommerce, the order creation date can differ from the date payment was actually collected. ClearCommerce can group eligible orders by paid date so the accounting period follows the payment event.
- One summary per paid day
- Zero-total orders skipped by default
- Orders and refunds remain available behind the roll-up
- Date basis controlled in the export profile
Roll up the figures that matter
A daily summary can separate sales by mapped account and tax rate while also handling shipping, discounts, refunds and rounding.
- Exact line totals to reduce Xero rounding issues
- Sales and shipping mapped independently
- Discount and refund accounts remain configurable
- VAT treatment follows mapped Xero tax rates
Clear accounting treatment
Configuration is stored against the company and store so the same source data can be reviewed, reprocessed safely and traced through its export history.
Keep payments visible by method
Gateway totals can be posted using the clearing account assigned to each ecommerce payment method.
- Braintree, PayPal, Stripe or other methods remain distinct
- No payment method handling is hardcoded
- Invoice-only and payment-posting rules remain configurable
- Gateway settlement can be reconciled against the clearing account
Clear accounting treatment
Configuration is stored against the company and store so the same source data can be reviewed, reprocessed safely and traced through its export history.
What businesses usually ask
Does a daily summary remove the source order detail?
No. ClearCommerce stores the imported source orders and refund information separately from the Xero summary and its export lines.
Can summaries use order created date instead?
Yes. Export profiles support paid date, order created date or completed date, although paid date is normally the cleaner retail basis.
How are refunds handled?
Refunds can be included in the accounting calculation and posted through controlled Xero credit-note or adjustment handling, with source references retained.
Bring your current reconciliation problem
We will help you decide whether daily summaries, individual invoices or separate store profiles are the cleanest route.