DC

Monthly Spend Analysis

LiveFinancial Report
Today: Business Central and spreadsheets
Halstow LogisticsAll sitesLast 12 weeks5 reports on this account
Replaces: monthly spend assembled from BC and Shopify exports
Net spend£3,6732 orders, every channel
Busiest month£2,772Aug 2026
Average order£1,837net of VAT
Monthly average£1,837across 2 months with orders
Monthly Spend AnalysisAll sites - Last 12 weeks
07501.5k2.3k3kNet spendMay: £0£0Jun: £0£0Jul: £901£901Aug: £2,772£2,772MayJunJulAug
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£9011£901
Aug2026£2,7721£2,772
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.