We often get a request for a format that will help to organize and summarize tax data for either one year or for several years.
Sometimes all you need is a little help. For some clients who are not using accounting software for their finances or for some new clients who have fallen behind in their tax return filing, we have created a spreadsheet file to assist in identifying, organizing, and summarizing income and expense items.
The spreadsheet provides a structure for the entering of income and expense items and performs some basic summarizatiion. From this information we can begin to help analyze a simple business and/or begin to prepare tax returns for the current and/or prior years.
We have also had some clients use this application for a simple budget tool. The straightforward layout allows for quick entries and easy viewing and editing. Once the numbers are entered, reviewed, and "agreed" then this spreadsheet can be printed out and used as a source document for entering a budget into the accounting software.
Download and use the spreadsheet file for your convenience.