Family Budget Planner
by CI Staff
Family Budget Planner is an Excel spreadsheet aimed at helping you create a yearly family budget. The spreadsheet is designed to track your budget monthly, quarterly and annually. It is simple to use and requires very little setup.
The first tab allows users to input starting balances for cash, credit cards, current account (checking account) and savings account, along with monthly estimated and actual income. The bottom table presents the difference between the actual and estimated amounts.
Print this article
Share this article
Each of the next four tabs represents a quarter. The numerical cell at the top-left shows the balance carried. For the first quarter, the balance carried would be the asset accounts entered in the income tab less the liability accounts. Income is broken down in the next two tables, which are automatically populated based on the inputs from the first tab. The expense tables are below the income tables. You can adjust the estimated and actual expenses for each month of the quarter. In addition, expenses are broken down into categories including, but not limited to, housing, transportation, insurance, daily living, children, entertainment, family care and pets. As you adjust your actual expenses, the spreadsheet will track the differences in each.
As you move on to the next quarterly tabs, the balance at the top-left will be updated. The format of the expenses remains the same, and the spreadsheet will utilize the income and expenses for the quarter to keep the quarterly balance current.
The spending total tab provides an aggregate of your yearly spending in tabular format and as bar and pie charts. Both actual and estimate figures are presented, as well as the difference between the two. The final tab lists your yearly results, including total income and spending, and shows whether you have saved money during the year.
Welcome to the American Association of Individual Investors.
AAII is a nonprofit association dedicated to investment education. For full access to our award-winning content, classrooms, model portfolios and stock screens, please take a moment to join AAII today for only $29 -- a 40% savings off our regular rate.
Join AAII Today!
Family Budget Planner is designed to run in Microsoft Excel. If you are running a Mac, you need to be able to open and edit XLS files in order to use the spreadsheet. The spreadsheet is provided free of charge.
Family Budget Planner
System Requirements: Ability to read and edit XLS (Microsoft Excel) files