As featured in The Wall Street Journal, Money Magazine, and more!
     

Excel Template for Income and Expense Report

This article was written by in Software. 9 comments.


Related: Excel Template for Net Worth Report (Balance Sheet). And when you’re done, learn to make accurate predictions.

template.jpgIn 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.

Here is the Excel file: Income Expense Template.xls. I’ll post a similar template for my net worth reports (balance sheet) shortly.

Updated February 6, 2012 and originally published July 9, 2006. If you enjoyed this article, subscribe to the RSS feed or receive daily emails. Follow @ConsumerismComm on Twitter and visit our Facebook page for more updates.

Email Email Print Print
avatar
Points: ♦127,485
Rank: Platinum
About the author

Luke Landes, also known as Flexo, is the founder of Consumerism Commentary. He has been blogging and writing for the internet since 1995 and has been building online communities since 1991. Find out more about him and follow Luke Landes on Twitter. View all articles by .

{ 9 comments… read them below or add one }

avatar Financial Freedumb

I just bought Quicken 2006. I’ve been looking at it for awhile, but I finally bought it. I used to use Money, but I totally got lost using it after awhile…just too bloated IMO.

Reply to this comment

avatar Luke Landes ♦127,485 (Platinum)

Both Quicken and Money are bloated in their own ways, and yet neither one contains all the features I’d like.

Reply to this comment

avatar harold

Thanks for getting this up there!!

Reply to this comment

avatar macewan

If of all thanks for providing this information. It should come in handy as I travel down this path.

Have you considered making the spreadsheet available in an online format such as Google Docs/Spreadsheets?

Reply to this comment

avatar paul kelly

Nice template, keep up the good work.

Reply to this comment

avatar malathi

Thank you for providing a great and easiest income & expense excel format…..

regards.
malathi

Reply to this comment

avatar Ding Emang

thank you for this helpful template.
God bless

Reply to this comment

avatar Cam

Income expense template is perfect just what I was looking for.
Thanks

Reply to this comment

avatar idr591

This is a great spreadsheet; thank you. Any way to easily modify it to accomodate multiple properties?

Reply to this comment

Leave a Comment

Connect with Facebook

Note: Use your name or a unique handle, not the name of a website or business. No deep links or business URLs are allowed. Spam, including promotional linking to a company website, will be deleted. By submitting your comment you are agreeing to these terms and conditions.

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Previous post:

Next post: