Related: Excel Template for Net Worth Report (Balance Sheet). And when you’re done, learn to make accurate predictions.
In order to create my Income Statements (here is the latest for example), I use two main tools. All of my transactions are entered into Quicken. I used to use Microsoft Money but I switched a few years ago.
Once it is likely I’ll have no more adjustments for a month, I run Quicken’s Income/Expense report, customized to include all accounts and subcategories. I export the report to an “Excel-compatible” format, and import the file using Excel.
I link the new file up to a template similar to the one attached. The template I use has cell references that point to my exported file, but the attached template does not contain links. If you use this template, you will need to enter your amounts manually or develop a system of linking to your own exported reports.
For the last three columns (year-to-date amounts for 2004, 2005, and 2006) to be accurate, you have to manually update the cell reference range each month.
Updated October 9, 2016 and originally published July 9, 2006.