About Services Tools Blog Contact us

UK Limited Company Tax Dashboard

Connects to Xero and forecasts turnover and profit to the year end for a UK limited company. It shows the corporation tax to set aside, VAT threshold headroom and the cash left after both.

  • Accounting & Reconciliation
  • Professional services
  • Dashboard feature
  • Productised
  • Local/private
  • 2026

The problem

From the Xero screens alone, a director cannot see where turnover and profit will land by the year end, or how much tax and VAT to put aside on the way. Profit that drifts into a higher tax band was often noticed only after the year had closed.

What it does

Profit and loss and the balance sheet are read from Xero into turnover, costs and profit. A year of UK rates is applied for corporation tax and the VAT threshold. A forecast weighted for seasonal sales runs to the year end, and pension and equipment timing show as suggested decisions. A spreadsheet with the same calculations is also produced, including cash after VAT and corporation tax are set aside.

Outcomes

  • One view shows forecast turnover, profit, tax band and VAT headroom.
  • The year-end tax figure moves when a pension contribution is added.
  • A cash line shows when VAT and corporation tax fall due.
  • A warning appears when profit is heading into a higher tax band.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Tax position

Marginal band
Profit
£200,000
forecast before any pension
Corporation tax
£49,250
marginal relief still applies
VAT headroom
£33,710
cash after the 7 Nov bill
Turnover forecast
£780,000
year to March, weighted for seasonal sales
Monthly profit, April to March, with forecast
Year-end corporation tax
Now £49,250. Allowance uses a £60,000 pension. Under 50k needs more than the allowance.
Tightest cash month
Feb
£18,600 after VAT and corporation tax reserves
Next VAT bill is £12,240 on 7 November. The cash buffer held back is £15,000.

Before the year end

Pension £0
Drag to try a contribution, or clear the band with the button. The annual allowance is £60,000.
Profit
£200,000
Corporation tax
£49,250
Marginal band
Pension
At £0 the profit stays at £200,000, in the marginal band. The annual allowance is £60,000.
Equipment
Bring the £9,400 equipment purchase in before 31 March. Full expensing deducts it while profit is in the marginal band.
Band is still marginal

How it works

  1. Connect to Xero and take a copy of profit, cash, invoices and assets.
  2. Forecast turnover and profit for each remaining month, weighted for seasonal sales.
  3. Apply the year's corporation tax rates and VAT threshold to the forecast.
  4. Show the month when cash is tightest once tax and VAT are set aside.
  5. Produce a spreadsheet from the same model and show pension and equipment timing as suggested decisions.

Pipeline

flowchart LR
  Books[Xero] --> Parse[Turnover and profit]
  Parse --> Forecast[Seasonal forecast]
  Rates[UK tax rates] --> Band[Tax position]
  Forecast --> Band
  Band --> Year[Year end projection]
  Year --> Note[Decision cards]