A worked example
Assume an online store takes £12,000 of gross paid orders on Monday. The total includes £9,200 product sales, £600 shipping and £2,200 VAT. Customers used several payment methods and £350 of earlier orders were refunded that day.
A useful Xero summary does not create 240 customer invoices. It records the sales components in the correct accounts, records the refund treatment separately and allocates payment totals to the relevant clearing accounts. The clearing balances can then be compared with later gateway settlements.
Why the grouping date matters
For a paid-date summary, only orders whose payment was captured on that date belong in the rollup. An order created Sunday but paid Monday belongs with Monday's paid activity. That prevents the sales summary from drifting away from the payment evidence used for reconciliation.
What should be visible in the calculation
- Net sales by the Xero account and tax treatment that will be posted.
- Shipping and discounts when they use different accounts or tax treatment.
- Refunds by refund date rather than silently rewriting historic sales.
- Payment totals by gateway or manual method where clearing accounts are used.
- Rounding adjustments where exact Xero line totals need a controlled balancing entry.