![]() Just below that number, write your total monthly income so you can compare the two numbers.This will tell you exactly how much money you’re projected to spend for that month.Just as a note, if you have a heading at the top of each column, then your formula will start at B2, not B1. You’ll also need to adjust the formula depending on how many line items (categories) you have.įor example, if you have 30 lines of expenses, your formula would read: =sum(B2:B30). Step 3: At the end of Column B, you’ll need to plug in the formula, =sum(B2:B19) in order for the spreadsheet to tally up your expenses. After all amounts are listed, you’ll be able to see if you have a deficit or an overage in any particular category.Step 2: In Column B list the amount of each bill, or the amount of money you’d like to budget for that category. I usually like to call this one Miscellaneous. Some categories can act as an umbrella covering things like going out to eat, movies, entertainment, etc.Be sure to list ALL of your family’s expenses including everything from monthly bills to dance classes to overall categories like pets or vacation savings. ![]() Edit the categories to reflect your family’s needs. Ready to get started? How do I make a family budget spreadsheet? Step 1: In Column A you’ll see sample categories listed. If you are unable to open a PDF, you can draw out a template (based on the instructions below) and fill it in for now, until you are able to create a digital one. Keep the spreadsheet open in another tab as we work step by step to get your family’s monthly budget set up.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |