-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: What's the most interesting small town you've visited in South Africa?
Budget spreadsheet
- Thread starter petum
- Start date
pinball wizard
Honorary Master
Is your google broken?
backstreetboy
Honorary Master
- Joined
- Jun 15, 2011
- Messages
- 49,397
- Reaction score
- 56,416
The FNB app, Capitec and probably others all have a budget built in now.
NarrowBandFtw
Honorary Master
Capitec's one isn't great though, mobile app only makes it a pain to use and it insists on seeing anything that goes out of your bank account as an expense
so even that interest sweep into your live better savings account is seen as an expense even though that is cash you still have on hand, making the total expenses for the month a murky figure where you need to remember how much of it was real expenses vs cash just moving around
The_MAC
Honorary Master
I've tried some of the templates, they are over-kill. Just create a blank sheet with 2 columns, 1 for Wife and one for you, sum up all the expenses, subtract them from the individual incomes, and sum the delta.
backstreetboy
Honorary Master
- Joined
- Jun 15, 2011
- Messages
- 49,397
- Reaction score
- 56,416
When you export to CSV on IB the categories are there though.
SeRpEnT
Executive Member
Just do it yourself. Start with your current bankstatement/s. Extract to Excel and base your budget on your monthly costs. Distinguish between variable costs and fixed costs. The variable costs are the trickier ones to budget for - so base this on a gut feeling and worst case scenario. The fixed costs should be easy enough..
And so on.
pinball wizard
Honorary Master
I don't think the OP can sum, or knows what delta is.
pinball wizard
Honorary Master
RedViking
Nord of the South
Yeah I have a nice one which you can alter to fit your needs. There are also many apps available.
I'm sorry I don't meet your excel expectations. Delta igloo Charlie.
pinball wizard
Honorary Master
Dic?
Surely you meant Dick? So, no excel skills and no ability to spell or insult? Got it.
NarrowBandFtw
Honorary Master
also not familiar enough with the radio alphabet ... it's India, not igloo
pinball wizard
Honorary Master
Well, you got what you got instead.
pinball wizard
Honorary Master
11 Best Free Personal Finance Excel Templates for Budgeting
If you need an efficient and easy-to-use Excel template for personal budget or personal finance, you have come to the right place. Managing personal
geekflare.com
The 7 Best Free Excel Budget Templates (Personal and Business)
1. Project Budget. 2. Personal Monthly Budget. 3. Balance Sheet. 4. Family Budget Planner. 5. Portfolio Tracker. See more templates here.
spreadsheeto.com
:max_bytes(150000):strip_icc()/lower-cable-bill-56a8fd3a3df78cf772a29115.jpg)
The Best Budget Spreadsheets
Take control of your finances by budgeting. If you're having trouble with your budget, you might want to use one of these budget spreadsheets.
konfab
Honorary Master
@OP Is this something you are looking at?
I have faked all the values, and changed the categories, but fundamentally mine works like this.
I have all the income summed in one column. Then list all the expenses in another. Each expense has a category like Rates, levy, Debt order ,Monthly, or Yearly. These categories represent what I need to do with the money. Either I move it into another account, or mark it for a debt order. The sheet has a true or false column that indicates when the debt order has gone off and updates the amount I still needs to keep in my account. I just change the false to a true when the debt order goes off.
I have both Capitec and Bank zero accounts with sub accounts. Main ones are Weekly (which my wife manages, I pay into it every month), Monthly and Yearly. This represents roughly when you access the money. Weekly is for groceries, which you take out 1/5 of it every month for your groceries (because there are never more than 5 weeks in a month). Monthly, which are things you purchase on a monthly basis like water, electricity and fuel, and yearly are things you need to budget for on a yearly basis like a car service or a holiday.
I then have a separate sheet that goes and figures out how much I need to put into each account by summing monthy. OP doesn't need to have all the conditional summing logic I have built in.
@OP, you are going to need to learn how to do this yourself because whatever you do will need to be tailored to your needs, but feel free to use my template as an example.
I have faked all the values, and changed the categories, but fundamentally mine works like this.
I have all the income summed in one column. Then list all the expenses in another. Each expense has a category like Rates, levy, Debt order ,Monthly, or Yearly. These categories represent what I need to do with the money. Either I move it into another account, or mark it for a debt order. The sheet has a true or false column that indicates when the debt order has gone off and updates the amount I still needs to keep in my account. I just change the false to a true when the debt order goes off.
I have both Capitec and Bank zero accounts with sub accounts. Main ones are Weekly (which my wife manages, I pay into it every month), Monthly and Yearly. This represents roughly when you access the money. Weekly is for groceries, which you take out 1/5 of it every month for your groceries (because there are never more than 5 weeks in a month). Monthly, which are things you purchase on a monthly basis like water, electricity and fuel, and yearly are things you need to budget for on a yearly basis like a car service or a holiday.
I then have a separate sheet that goes and figures out how much I need to put into each account by summing monthy. OP doesn't need to have all the conditional summing logic I have built in.
@OP, you are going to need to learn how to do this yourself because whatever you do will need to be tailored to your needs, but feel free to use my template as an example.
Went_For_Beer
Expert Member
My sheet started with two columns and ended up with this.
I fill in the income
Fill in whatever we spend in the section at the bottom of the screenshot
The rest is populated with formulas to update balances and change cell color if we spend more than the budgeted amounts set in the formulas.
On months where we end up spending too much, I take a look at the "Total Spend Per Category" to see what we need to cut down on.
I fill in the income
Fill in whatever we spend in the section at the bottom of the screenshot
The rest is populated with formulas to update balances and change cell color if we spend more than the budgeted amounts set in the formulas.
On months where we end up spending too much, I take a look at the "Total Spend Per Category" to see what we need to cut down on.
Last edited: