DC

Monthly Spend Analysis

LiveFinancial Report
Today: Business Central and spreadsheets
Ludgate Row RestaurantsAll sitesLast 12 weeks5 reports on this account
Replaces: monthly spend assembled from BC and Shopify exports
Net spend£5,5963 orders, every channel
Busiest month£4,394Aug 2026
Average order£1,865net of VAT
Monthly average£2,798across 2 months with orders
Monthly Spend AnalysisAll sites - Last 12 weeks
01.3k2.5k3.8k5kNet spendMay: £0£0Jun: £0£0Jul: £1,202£1,202Aug: £4,394£4,394MayJunJulAug
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£1,2021£1,202
Aug2026£4,3942£2,197
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.