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.
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.
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.
Interactive preview with sample data. Nothing is sent to a server.
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]