DC

Monthly Spend Analysis

LiveFinancial Report
Today: Business Central and spreadsheets
Kingsway Contract CleaningAll sitesLast 12 weeks5 reports on this account
Replaces: monthly spend assembled from BC and Shopify exports
Net spend£4,1963 orders, every channel
Busiest month£3,872Aug 2026
Average order£1,399net of VAT
Monthly average£2,098across 2 months with orders
Monthly Spend AnalysisAll sites - Last 12 weeks
01k2k3k4kNet spendMay: £0£0Jun: £0£0Jul: £324£324Aug: £3,872£3,872MayJunJulAug
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£3241£324
Aug2026£3,8722£1,936
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.