DC

Monthly Spend Analysis

LiveFinancial Report
Today: Business Central and spreadsheets
Tanner & Vale FoodsAll sitesLast 12 weeks5 reports on this account
Replaces: monthly spend assembled from BC and Shopify exports
Net spend£6,1543 orders, every channel
Busiest month£3,693Jul 2026
Average order£2,051net of VAT
Monthly average£3,077across 2 months with orders
Monthly Spend AnalysisAll sites - Last 12 weeks
01k2k3k4kNet spendMay: £0£0Jun: £0£0Jul: £3,693£3,693Aug: £2,462£2,462MayJunJulAug
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£3,6932£1,846
Aug2026£2,4621£2,462
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.