Cant find a budgeting app you like?
Prefer to manually type your transactions or control the layout of your budget?
A lot of other people do too!
And because Microsoft Excel has its own app, your budget spreadsheet is no longer bound to your rig.
Its up to you, but I recommend starting small and getting more complex as you improve.
Budgeting isnt something youre good at right off the bat; its a continual lesson in delayed gratification.
Our team has compiled alist of creative waysyou can fatten your bank account this week.
This is a long list, so dont get overwhelmed.
Well keep it updated as offers changes or expire.
A lot of the templates out there are clunky and outdated.
Even if you wanted to alter a template, editing can get pretty confusing.
So learning how to make a budget in Excel will serve you well no matter what path you choose.
How to Make a Budget in Excel
First, decide what youd like to track.
Heres a list of100 expensesto account for in your budget to get you started.
Lets start giving your budget some character.
In columns H-J, add the labels Income, Planned and Received.
Thatll give you your projected total income for the month.
Go ahead and allot a budgeted cost for all your budget categories.
If youre doing azero-based budget, while pressing shift, select your first and last budgeted costs.
Then hit the Sum button.
This will give you your total expenses and will change if you adjust the numbers above.
Then, AutoSum the two cells.
Youll see in real time where your budget stands.
Youll change out the : for - so that the formula subtracts E9 from D9.
It should look something like this: =SUM(D9-E9).
This will give you a running tab of what you have left to spend in the restaurants category.
To continue that running tab down the column, youll need one more formula.
Say my next transaction is $3.11 from Smoothie King because I feel guilty about those dollar menu tacos.
Thatll subtract the latest transaction from the latest remaining balance, giving a running total.
With F10 still selected, there will be a little blue box in the lower-right corner of the cell.
Ill click that box and drag it down the column to the last row of the restaurants category.
Youll see the Remaining number in every open row, and itll update as you add transactions.
I also keep tabs on the total Ive actually spent, just to be redundant.
Beneath income, I like to compare Planned Income with Budgeted Expenses to ensure every dollar is going somewhere.
The same can be done with received income, =J6, compared with actual expenses, =E30.
But wait, theres more!
To label slices, right-nudge the pie and select Add Data Labels.
keep your budget, and upload it to OneDrive.
Download the Microsoft Excel mobile app, and enter to your Microsoft account.
In the Open tab select OneDrive Personal and grab the file you uploaded your budget to.
press your spreadsheet and your budget will be available on the go!
If you do this on your rig, youll want to update it from the file in OneDrive.
She religiously budgets every month.
(Can you sense my millennial sarcasm there?)
You know which ones were talking about: rent, utilities, cell phone bill, insurance, groceries…
