Cash accounting spreadsheet for sole traders:
the spreadsheet does everything you need in the following bullet points.
1. work out your total monthly self employed earnings.
2. displays your given your total monthly costs.
3. work out our gross monthly earnings less costs (before taxes).
4. options available in the spreadsheet to add any state assistance plus any employed income.
5. automatically works out yearly income less costs for self employment as months progress.
6. spreadsheet also automatically gives you a total annual figure for costs, employed income and state assistance.
7. you are able to add any suppliers, bills and other necessary outgoings / income types to the drop down sheet within the relevant fields.
note:
please be aware that this spreadsheet does not does not currently calculate vat