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

Creating an Income and Expense Tracking Document

Recording the Expected Dates and Amounts of Expenses
You have several options for how you will handle the Expected Date column in the Expenses section. No matter which option you choose, the most important thing is to apply it consistently. You can use the Expected Date column to note the following:

  • The date each bill is due – This is usually the most informative data for this column.
  • The date you expect to receive each bill – If you pay your bills as soon as they arrive, this might be the most useful date to record.
  • The date you intend to pay each bill – If you don't pay each bill upon receipt but you want to be prompted to pay it a few days before it's due, or if you have some bills you intentionally pay after the due date but within the grace period, such as a mortgage or property taxes, this might be the best option for you. If this date will fall outside the month you're listing the item in, be sure to include the month (not just the day) in this field.
In the Expected Amount column, record the amount you intend to pay. Again, you have several options:
  • The actual amount due – This is simply the amount you're being billed for.
  • More than the amount due – If you pay more than the minimum toward your mortgage or credit cards, you can record an amount larger than what's actually owed for this billing cycle.
  • Less than the amount due – If you're facing a month of more expenses than income, you can use this column to plan which bills will receive partial payment.
In the Actual Date and Actual Amount columns, record the actual figures when they occur.

Seeing the Big Picture
After you've filled in all of your categories and data, total your expected income and expenses and – deep breath – see which is greater. This is your spreadsheet's reason for being, and it's also the most gut-wrenching part of the whole process. As you can see in the spreadsheet, Sue and Joe's expenses were much less than their income in January, but February is going to present a problem....

Congratulations! You've completed a major step toward organizing your finances. Now maintain this spreadsheet as you continue with the rest of the projects in this book, and keep refining it as you move into your increasingly organized future.

But what if you're not the only one manipulating the money in your accounts? Here's your final project for this chapter: learning to cooperate with your joint-account partners.

<< Previous: Page 3

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.

st. patrick’s day

Celebrate the
luck of the Irish
with recipes
and activities.



10 Best Creative Apps for Kids
Looking for apps that foster creativity? Check out these top-rated art and music apps for kids.

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!

A New Intergalactic Reading Adventure!
Get your reluctant reader hooked on an irresistible new story, Galactic Hot Dogs! Join the Book 1 reading marathon, and get behind-the-scenes tidbits on the official Galactic Hot Dogs blog. Also, print this cool Galactic Hot Dogs reading log to keep your bookworm excited about reading!

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!

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