simple income expense report excel

Vertex42.com - The Guide to Excel in Everything

Support • About • Contact Us • Excel Consulting

= Menu

  • EXCEL TEMPLATES
    • Budget Templates
    • Invoice Templates
    • Project Management
    • Timesheets
    • Business Templates
    • – More –
  • CALENDARS
    • 2018 Calendar
    • 2019 Calendar
    • Calendar Template
    • Printable Calendars
    • – More –
  • CALCULATORS
  • GANTT CHART
    • Gantt Chart Pro
  • WORD TEMPLATES
    • Legal Forms
    • Resumes
    • Letters
  • EDUCATION
    • Excel Tutorials
    • 100+ Excel Tips
    • Templates for School
  • APPS
  • BLOG
    • Excel Formulas

Home > Excel Templates > Budget Templates > Income and Expenses

Income and Expense Tracking Worksheet

Print a blank worksheet or customize and edit using Excel® or Google Sheets

Tracking your income and expenses is one of the first steps in managing your money. I designed this worksheet to use as a printable handout in an introductory personal finance course, but it also functions as an editable spreadsheet. Although I have other finance and budget spreadsheets that do a lot more than this one, if you are looking for a very simple way to keep track of your money, this worksheet can help you get started.

Advertisement

Income and Expense Worksheet

for Excel, Google Sheets, or PDF

Income and Expense Tracking Worksheet

⤓ Download

For: Excel 2007 or later & Excel for iPad/iPhone

Other Versions

Printable PDF
Google Sheets

Template Details

License: Private Use
(not for distribution or resale)

Using the Income and Expense Worksheet

I tried to make this worksheet as easy to use as possible. If you are using it in Excel on a smart phone, you’ll find that it uses a lot of drop-down lists. You can edit those lists in the Settings worksheet.

This worksheet doesn’t calculate a summary of income and expenses by category for you (like the Account Register for example). However, if you are comfortable with Excel you could use a Pivot Table to analyze your income and expenses.

Step 1: Clear the sample data, but don’t clear the formulas in the Balance column.

The sample data is there to give an example of how you can enter beginning balances, transfer money between accounts, and enter some basic expense transactions.

It is not necessary to use the worksheet for ALL your accounts in one register. You could duplicate the worksheet and use one worksheet for each of your accounts if you wanted to.

Step 2: Enter beginning balances for the accounts you want to track.

This isn’t necessary, but it’s what you would do if you wanted to keep track of each account balance. There is actually a hidden column that you can unhide that will show your current Account Balance.

Step 3: Edit the Accounts and Categories lists in the Settings worksheet as needed.

These lists control what is shown in the drop-down lists for each column. It isn’t necessary to use the drop-down lists – they are just for convenience.

If personal finance scares you a bit, it may be easier to start with just a few expense categories. When you are ready for something more advanced, you might want to try the Money Management Template .

Step 4: Update the Income and Expense Worksheet daily.

If you are using the worksheet on your phone, you can edit it on the go. If you are using the printed worksheet, you can take it with you in your wallet or purse and edit it whenever you make a purchase.

Another approach is to make notes on a 3×5 card or make notes on your phone about your spending, and then update your worksheet at home.

Step 5: Create a Pivot Table to Analyze Income and Expenses

The image below shows an example of the type of report you can create fairly easily using a Pivot Table in Excel. For detailed instructions, see the blog article written by guest author and Microsoft MVP John MacDougall: Using Pivot Tables to Analyze Income and Expenses .

Pivot Table showing Expenses by Category and Month

Tip: If you use a Pivot Table in Excel 2013 or later, I’d recommend trying the new Timeline feature. This makes it easy to select the range of dates to display in your table. Click inside the pivot table, then go to the Analyze tab and click on Insert Timeline.

More Money Management Templates

Account Register Template
Account Register Template
Weekly Money Manager
Weekly Money Manager
Money Tracker
Money Tracker
Money Manager for Kids
Money Manager for Kids

Related Content

 

LIKE THIS TEMPLATE?

Google+

Like on Facebook

Follow Us On …

FB 

G+ 

PIN 

TWEET 

LI 

Business Templates by Vertex42.com

Budgets

Money Management
NEW Money Tracker
Monthly Cash Flow
Personal Budget
Personal Monthly Budget
College Budget
Simple Budget
Household Budget
Family Budget Planner
Home Budget Worksheet
Event Budget Template
Wedding Budget
Business Budget
Project Budget
Expense & Budget Tracking
Budget Calculator
Savings Goal Tracker
Debt Reduction
Travel Budget Worksheet
Account Register
Checkbook Register
Weekly Budget
Price Comparison
Donation Tracker
info  Make a Budget

Sponsored Listings 

VERTEX42.com

© 2003-2018 Vertex42 LLC. All rights reserved.

Vertex42® is a registered trademark of Vertex42 LLC. Microsoft® and Microsoft Excel® and Microsoft Word® are registered trademarks of Microsoft Corporation. Vertex42.com is not associated with Microsoft.
Contact/About Us . Excel Articles . Excel Links . Sitemap . Privacy . Legal Stuff