Excel spreadsheet tool for estimating income and national insurance tax for self-employed and sole traders.
Uses cash basis reporting (i.e. record income and allowable expenses when paid rather than when accrued. The tool offers guidance as to what expenses might be allowable as tax deductible. Allowable expenses per the tool are as defined on 'Her Majesty's Revenue & Customs' (HMRC) ie the UK tax authority. However, this may not be a complete list for your particular tax authority. As such, the tool provides space for additional allowable costs to be considered.
Whilst the tool is useful for forecasting and estimating the expected amount of income tax, national insurance contributions and take-home pay. However, it is up to you as the individual to ensure that you pay the right amount of tax and that you keep appropriate records. We strongly recommend that you seek advice from a qualified financial or tax professional.
In terms of using the tool:
Yellow cells are input cells e.g. trading income, allowable expenses, tax rates. Tax rates in particular will need to be updated based on the current tax year and tax jurisdiction. Blue cells are also input cells but we anticipate that these will not be changed as regularly.
Very useful tool