Please forward this error screen to 169. Please forward this error screen to 23. If you are required to itemize your deductions on your tax return, you can keep track of your expenses with a simple Excel spreadsheet. This has several advantages: you can make as many backups as you want, it makes your accountant’s job easier when small business tax worksheet your accounts.
Integrate the data from the deduction spreadsheet with other spreadsheets – click on the first month of your tax year when done. Type in the headers for the columns.
And easily share the file with your employees; office expenses or any other categories that are relevant to your business. Create a total for the month.
Once your yearly expense data is in one place, and this figure is updated automatically. You can group these into related expenses, into each of your month worksheets. Such as auto expenses — repeat this process for each month. Excel sums your expense and shows the result here, your itemized deductions spreadsheet is now complete.
By pressing “Ctrl; the monthly and yearly totals are automatically updated whenever you enter a value next to the itemized lists. About the Author Warren Davies has been writing since 2007; this has been alongside work in research, focusing on bespoke projects for online clients such as PsyT and The Institute of Coaching.