Home > Mom's Life > Family Finances > Family Budgets > Creating an Income and Expense Tracking Document
|

Creating an Income and Expense Tracking Document

Okay, you've got all of your receipts. Now what do you do with them?

Even if you use software such as Quicken by Intuit or Microsoft Money, you might find it helpful to keep a separate income and expense tracking document. You can run reports in your money management program that show you how you're doing with your financial goals, but the act of hand-writing or keying in the figures in a separate document can help you see the big picture more easily. I use QuickBooks (the business version of Quicken) to record all my transactions and balance all of my accounts electronically, but I also use another spreadsheet to list all of the data I want to see together, not all of which has a place in QuickBooks where it can be entered. I've tried to create just the right custom report in QuickBooks to eliminate the need for this spreadsheet, but so far nothing has worked as well as my trusty Excel document.

You can create your spreadsheet by hand on graph paper, in a ledger book purchased from an office supply store, or on the computer using a database program such as Microsoft Excel or Access (or even a word-processing program that allows you to create tables, such as Microsoft Word). A database program has the capability to perform calculations for you – a time-saving advantage if you know the program well enough to set the formulas.

You'll need list

  • Either paper and a pen or pencil (for a hand-drawn spreadsheet) or software (Excel, another database program, or a word-processing program) for a computer-based spreadsheet.
  • The receipts you collected in the previous section.
Laying the Foundation
There are a few components your spreadsheet will need to have, no matter how you create it. These are
  • An Income section and an Expenses section
  • Categories for subdividing expenses, and also for income if you receive payments from more than one source
  • Regularly recurring time increments, whether monthly, weekly, or quarterly
  • Spaces for both anticipated and actual amounts
  • Spaces for total income and total expenses by time period
Below is an example of an income and expense tracking document that incorporates all these elements in a space-efficient manner. I created this one in Microsoft Excel, my first choice because I can change it at will, insert or delete lines, attach embedded notes to each field, and have the program automatically perform calculations for me. I can also make the spreadsheet as large as I want because I work on the computer, not on a printout that's limited by the size of the paper.



Next: Page 2 >>

More on: Family Finances

|

Reproduced from Organize Your Personal Finances in No Time, by Debbie Stanley, by permission of Pearson Education. Copyright © 2005 by Que Publishing. Please visit Amazon to order your own copy.


stay connected

Sign up for our free email newsletters and receive the latest advice and information on all things parenting.

Enter your email address to sign up or manage your account.

Facebook icon Twitter icon Follow Us on Pinterest

editor’s picks

thanksgiving crafts & recipes

Make this Turkey
Day fun for the
whole family with
these essentials.

GO

highlights

3 Fun Thanksgiving Games for Kids
Looking for some great Thanksgiving games to play with your kids? Print our free Pin the Feathers on the Turkey game, Pin the Hat on the Pilgrim game, and Thanksgiving Parade Bingo game for loads of laughs this Turkey Day!

Kindergarten Readiness App Wins Gold
Our Kindergarten Readiness app won the Gold Award of Excellence in the educational category at the 2014 Communicator Awards. This valuable checklist comes with games and activities to help your child practice the essential skills she needs for kindergarten. Download the Kindergarten Readiness app today!

8 Surprising Sources of Caffeine in Kids' Foods
Even low doses of caffeine can have an effect on your child's health. Since the FDA doesn't require caffeine content on food labels, learn about hidden sources of caffeine in kids' diets.

Find Today's Newest & Best Children's Books!
Looking for newly released books for your child? Try our new Book Finder tool to search for new books by age, type, and theme, and create reading lists for kids!