DC

Monthly Spend Analysis

LiveFinancial Report
Today: Business Central and spreadsheets
Pennine Schools TrustAll sitesLast 12 weeks5 reports on this account
Replaces: monthly spend assembled from BC and Shopify exports
Net spend£2,9273 orders, every channel
Busiest month£2,927Aug 2026
Average order£976net of VAT
Monthly average£2,927across 1 months with orders
Monthly Spend AnalysisAll sites - Last 12 weeks
07501.5k2.3k3kNet spendMay: £0£0Jun: £0£0Jul: £0£0Aug: £2,927£2,927MayJunJulAug
Spend is the operational record. The ledger, VAT and statutory accounting stay in Xero, which this feeds.
The figures4 rows, the same numbers the chart draws
MonthYearNet spendOrdersAverage order
May2026£00£0
Jun2026£00£0
Jul2026£00£0
Aug2026£2,9273£976
How it is worked out. Net order value by calendar month of the order date, cancelled orders excluded. Months with no orders are shown at zero rather than dropped.