When you create a budget, the assessing and documenting start at the beginning. Our prior post discussed gathering all the information about your spending and tracking them by categories. Today, we will show you how to use all tracked money information to make an easy budget for yourself.
If you didn't read the other post, feel free to visit it here: HOW TO TRACK YOUR EXPENSES AND CREATE A BUDGET - PART 1
How to Gather all the Fixed and Variable Expenses in One Place?
Now that you have all your fixed and variable expenses divided and collected, you will need to place them in one place. Some categories may be used more than others. Select the categories you used at least once during the time period you tracked. These categories can range from broad to specific, depending on your situation.
What are the Commonly Used Budget Categories?
Some commonly used budget categories are listed below.
The Food category should include all these subcategories below.
Dining Out/Take Out/Delivery
Groceries - separating groceries will show you how much of your total food expense is related to the food you buy to eat at home.
This is the Fun(discretionary) category. Add here all the things you pay for that you love to do with family and friends. Below are some suggestions.
Online Subscription Channels - This is for any online subscriptions you may have, including cable TV.
It's helpful to have a separate section for vacation so you can see how much you spent taking some R&R.
Credit Cards/Financial Obligations:
Using the name of the credit card if you have more than one is helpful and allows you to see how much you paid for each card.
Line of Credit
Student Loans Payments / Personal Loans
Having a Car expense category will allow you to see if your older car costs more than it should. Rule of Thumb: if the total yearly car repairs divided by 12 months is more than a new car payment, you may want to consider getting a new car.
This category is for everything home related.
Mortgage / Rent
House Insurance/ Renter's Insurance
Community Dues - HOA Dues
This section can be near the mortgage/rent category because these expenses usually relate to the home.
This category is broad. It can be for anything you spend money on over a time period. Below are some suggestions.
Beauty Care - hair cut, makeup, massage, etc...
If you have kids, it is a good idea to have a separate section for the children's expenses. Below are some subcategories you may want to use.
Health includes anything you spend money on to keep you healthy.
This section is important to track for planning purposes. We tend to add to these over time and modify the amount we add to them, so keeping them in a separate category will show you how much you contributed yearly.
Contribution to retirement plans.
Auto transfers to savings accounts.
Holiday Savings for Gifts.
We all have this section in our categories list. It makes it easier at the end of the year when you have to find out taxes from the prior year.
Estimated Taxes - for Self-employed individuals or others who have a side hustle.
Income taxes due
Now, we can't forget to add the Income section. This category is any income that regularly comes to help you pay for your bills.
Interest from bank accounts
Net Income from salary
Dividends from financial accounts
If you contribute to charities, having this section separated will help you if you want to itemize your tax return.
Keeping these categories specific depending on your situation allows monthly scrutiny of the numbers.
How to set up a budget spreadsheet?
Now that you have picked and selected the categories you want to use, we can now make up your very own budget sheet.
If you have a small number of categories, you can easily use a spreadsheet in Microsoft Excel or Google Sheets. I am going to show you how to do this easily.
Each month will have its own Budget versus Actual spreadsheet that looks like this below.
We are going to look at Sara's personal budget. Sara only made a few expenses and lived with her parents, who paid for the house and those expenses. Here is how she wrote up her budget and actual spreadsheet.
Include the due date and sort the categories by the due date. If there are categories that are not regular, you can use the word "varies."
|Car Loan||15th of the month||$250.00||$250.00||$0.00|
|Monthly Total Expenses:||$550.00||$500.00||+$50.00|
|Total Income Sources:||15th and end of the month:||$3000.00||$3200.00||+$200.00|
|The difference for the Month:||$2450.00||$2750.00||$250.00|
By having a difference column, you can easily see what Sara did with her money in a month. Then, the next month, she can assess if any budget numbers have changed and make adjustments.
When reviewing your end-of-month Budget vs Actual sheet, if the difference column shows a negative number, you spent too much money.
Staple to the monthly bank statement.
Gathering these Budget v Actual budget sheets and attaching them to your monthly statements will keep all the paperwork together in case you have questions in the future.
Add up expenses by categories and income at the end of the year from all 12 months.
Now that all the 12 months are completed, you add each category to the spreadsheet using a separate tab in Microsoft Excel or Google Sheets. This will give Sara the totals for the entire year, and she can look at the year and see what she wants to change for the next year or long-term goals.
When you create a budget, you may find it easier to modify the budget column monthly until expenses and income are stable, and you can review it quarterly or yearly.
Get a free copy of our Home Management Binder, where we share preprinted budget pages to create a budget in the financial section.
It also includes Gift List and Budget Tracking Sheet, Gift Card Received tracker checklist, and Cash Donation tracker printables.
How to set up a budget with an app?
If you have many expenses to track once a month, you can use a tracking money app. Below are the ones that are popular right now.
Mint - Intuit makes this app. It is a popular personal finance app.
Quicken - there are different price points on this page. You can track other things like small businesses and real estate rental properties. This is an affiliate link. If you buy this app, I will receive a small referral commission. Note: Quicken used to be owned by Intuit, and they sold it years ago.
Simplifi by Quicken - this is an affiliate link. If you buy this app, I will receive a small referral commission. This app is a competitor of Mint but made by Quicken.
NerdWallet is a free option if you want to start this creating a budget process.
The system will usually guide you through what categories to use and what you do not need in the category list sections. For less confusion, delete the categories you do not use. You can always add them later.
That is it! When you create a budget, you will find areas you overspend. Over time, you will be able to modify the different expenses and maybe even reduce them and increase your savings. Be patient with the process, and you too will have financial success. If you have any questions, please leave me a comment below. I would love to help you.
Need help figuring out what to track with your expenses? Want to be accountable for your spending and create a budget? Schedule a few virtual organizing sessions so we can get you on your way to saving more and having financial freedom. Reach out so we can start today!
Visit these articles below for more information.
Please note these are affiliate links through Amazon, and at no additional cost, I will earn an affiliate commission if you click through and decide to make a purchase.