See the images below to get more clarity. ![]() Then you should add the same category in the expense tracker category list in the same order. Add New Categories in the Budget Planner as per Your NeedĬlick on the “Monthly Budget Planner” and just type the category that you want to add.įor example, if you add “Books” (Replace ‘Category 1’ with Books). And add the “Budget” amount and “Actual” amount.ħ. So prepare a budget for such debts by adding data in the “Pay off debt” column. And even credit card payment is considered as debt. Sometimes you may have to pay off some debts like borrowed from your friends or relatives or any other extra debts. Make sure that You Track debts and Make Entry When You Pay Off Debt Then make entries of “Budget” and “Actual” amount.Ħ. You can make entry of such savings in the “saving” column. Sinking fund means keeping aside some money for future use or for repayment of long-term debt. So Make entry of such bills in the “bill” column.įill the “budget” amount and also go on filling the “actual” amount when you make payment. You may have many bills and fixed expenses. Keep a Track of Bills and Fixed Expensesīills and Fixed expenses. When you follow step 1 and step 2, the data and calculations will automatically reflect in the “Monthly Budget Planner” tab.Ĥ. Then “Monthly Budget Planner” will get automatically updated. ![]() You have to open the “Expense Tracker” tab and just do entries whenever you spend on something. Here I’ve set up automatic calculations for you. ![]() You don’t need to spend a lot of time tracking such expenses now. For example shopping, medical expenses, groceries, dining out etc. Whatever you spend on a regular basis comes under variable expenses. The “Budget” column must be filled by you at the beginning of the month because that will be easy for you to manage your money throughout the particular month. Everywhere where you see the columns “Budget” enter the amount that you want to spend in the particular month. Fill all the ‘Budget’ columns in the ‘Monthly Budget Planner’ sheet And if in between you receive any income then go on making entry.įor example here “side hustle is 500” so if after 15 days in the same month you earn 200 more then change the data here. Make entry of Income whenever you receive it. If you don’t understand any instructions feel free to ask questions in the comment box below about this budget planner. Read all the instructions and start preparing a monthly budget. How to Make Budget in Excel Budget Planner Easily? – INSTRUCTIONS It includes a feature that it will highlight and make you aware of your spending if you spend more than your budget on any particular category and overall. You can add extra categories in this budget planner and edit as per your need.ħ. You can use this budget template online or offline.Ħ. That means you can choose a category quickly from the list.ĥ. For example – Groceries, Shopping, Medical expenses etc. It has all the important categories dropdown lists to make to track expenses. You can actually compare the budget amount and actual spending in each category.Ĥ. Easy expense tracker is added in the frugal beat budget planner.ģ. Automated calculation setup is included to save your time and money.Ģ. You usually see such features in the paid planner but here it’s completely free.ġ. Download it here.įeatures of Frugal Beat Excel Budget Planner that you usually don’t find in any Free PlannersĪs somebody who values money and time, I have added some extra features to this budget planner. Your excel budget planner is waiting for you. Having a budget plan is the key to save more dollars. If I can save more than 50% of my income by making a monthly budget plan, so you can. Save your time and also money by making use of an easy budget template. Now you can download the frugal beat excel budget planner and use it either online or offline. ![]() Excel Budget Planner helps you to prepare a monthly budget quickly and easily.
0 Comments
Leave a Reply. |