Family Budget Sheet

Click here to download our free family budget sheet

If step one in organizing your monthly bills is to gather them up in one place via a dedicated "Bills Only" email service then step two is to know exactly how much your monthly bills actually are.

There are several ways to organize, categorize, and determine exactly how much your monthly bills total each month. One of the simpler methods is log on to your online bank and then download the monthly expenses into your Microsoft Money, Peachtree Accounting, Sage 50, Quicken, Simply Accounting, or Quickbooks accounting software programs.

What about all of the people that don't want or don't have an expensive home accounting software program to organize and categorize their monthly bill expenditures?

BillsOnly.com has created a simply family budget sheet in a Microsoft Excel spreadsheet. This sheet will help you:

  • Organize your monthly bills

  • Calculate monthly total bill expenses automatically

  • Calculate yearly total bill expenses automatically

  • Calculate average yearly expenses automatically

  • Place a monthly "due date" to keep you on pace

  • Allows you to mark if the bill is ready to be paid or delivered

  • Sort by simply clicking the appropriate heading of "Bill Type," "Amount," "Due Date," or "Delivered Y/N"

  • Next year simply save this as " 2012 Family Budget Sheet " to start all over again. 2013 do it again.... " 2012 Family Budget Sheet "

The basic family budget sheet features:

family budget sheet features

family budget sheet totals tabs

Click here to download our family budget sheet.


To use the family budget sheet click the link above and when the file download box comes up hit the "save" button. It is going to ask you where to save it. My advice is to put it somewhere you can find it easily like your desktop.

Save the family budget sheet to your hard drive

Once the family budget sheet is saved, open it and it is ready to use.

 


One of the nice features of this spreadsheet is the ability to quickly sort by any of the headings "Bill Type," "Amount," "Due Date," or "Delivered Y/N." For any given month you can find specific amounts or sort by the date due in an ascending or descending method.

Here's how:

Step 1 click on the cell of the heading that you want to search:

Click on the heading your want to search

Step 2 use the drop down arrow to choose what you are search for:

Use the dropdown to choose the amount, date, etc you wish to search

Your result:

The sorted results of your family budget sheet

 

Average Monthly Bill give you the average for the whole year. This average is only "real" if all twelve months of date are available.

Average Monthly Bills


Family budget sheet pic 1

Bill calculator, family budget spreadsheet pic 2

Expense calculator sheet for family budgets pic 3

Calculate monthly bills with this family budget sheet pic 4