Jump to content

Income/Budget Spreadsheets


  • Please log in to reply
17 replies to this topic

#1 Avidlearner1

Posted 23 July 2012 - 01:39 PM

I have just started a new job where I am paid fortnightly, plus I have allowances that are paid monthly and then commission paid on a different day of the month.

I am concerned I am going to lose track of money coming in and pay bills on wrong dates, spend the amount I have set aside for savings, end up short one fortnight and abundance the next etc.

I am used to being paid monthly.

Could you please recommend a spreadsheet (that runs in excel) or program that I can enter in my payments and add what date bills are due so I can reorganise my budget. I tried playing around on excel but my system looked really confusing.

Probably a good example of why I don't work in finance original.gif

#2 Peridot

Posted 23 July 2012 - 01:43 PM

I shall be stalking this thread oomg.gif

#3 Amber Spyglass

Posted 23 July 2012 - 01:48 PM

Me too! I really need something like this!

#4 blithely

Posted 23 July 2012 - 01:49 PM

Quicken does all of that and more. It's worth having if you have a complicated income. The cost to buy is an allowable tax deduction.

#5 justnotfeelingit

Posted 23 July 2012 - 01:52 PM

We have a household budget spreadsheet in our Office Excel templates that looks quite good (I havent used it though). You could take a look through there.

#6 Peppy2

Posted 23 July 2012 - 02:10 PM

I am in finance and I have a spreadsheet for each  6 month period. I just created it myself.

I put each fortnight's date in a column and then next to it, the pays I expect to receive next to each fortnight. You can easily add in the extra money you expect in the next column. Then I map out all current payments (mortgage/insurance/school fees/ etc.). I have my starting bank balance and each forgnight I add the income and subtract the payments. Its pretty simple once you get started.

Then just update for each 6 month period. You don't need anything fancy. Happy to email you a template if you like.

#7 laridae

Posted 23 July 2012 - 02:22 PM

I use YNAB (You need A Budget).  It has a free trial if you want to try it out.  
You can import bank statements from Netbank etc, put in scheduled transactions, pre fill a month or so ahead then reconcile with your bank statements etc.  Allocate money monthly from you income towards paying yearly bills etc.

Similar (but a bit more complicated to get going) and free is GnuCash.

#8 Tamzin1984

Posted 23 July 2012 - 02:29 PM

Like Peppy2, we have an excel spreadsheet we made ourselves.

Essentially, it works on a day to day basis.  The left hand column is each day's date, the rows at the top are Date, Transaction Description, Cash Movement, and then account balances.  

We have it set up in four week blocks, with the weekends coloured differently, so it is easy to see where you are at.  We input all regular income and outgoing expenses, such as my pay (weekly), DH's pay (fortnightly), credit card bill (we pay all other bills on our credit card, amount inputted to table is predicted based on our average spend), mortgage repayment. These are set up as recurring transactions, so you can predict your bank balance months in advance.  As you get more information you can adjust your outgoings (for example, our billing month for the CC ends on the 11th, and is not due to be paid until the 26th, so leading up to the 11th we monitor the balance and adjust spreadsheet accordingly.  By predicting your income and outgoing expenses it helps you to know where you're at, and whether you're actually going to have enough income to pay your mortgage next month, and how much spare you've got to play with.  If you're good with excel it is easy to set up.  

We balance our budget weekly with our bank accounts, making sure the account balances are accurate, and entering interest, and any cash withdrawls as you go.  As each week is balanced we change the colour so we know it is correct.  

My DH, the financial guru of the family, set it all up.

#9 GreenCabbage

Posted 10 November 2012 - 09:09 AM

I have one which runs in excel. I can email it when on the computer next if u send me ur email.  

The bank lady was impressed with it and took it into account when I applied for my home loan.

#10 firstbornbabyboy

Posted 15 November 2012 - 08:55 AM

QUOTE (pinkpineapple @ 10/11/2012, 10:09 AM) <{POST_SNAPBACK}>
The bank lady was impressed with it and took it into account when I applied for my home loan.


This is awesome! original.gif


#11 toadflax

Posted 19 November 2012 - 07:50 PM

I have been using one that was mentioned years ago on an EB thread - it is excellent (by Lynne Woods and David Annetts. I highly recommend it.

https://sites.google.com/site/budget-tracking/

#12 Natbub0610

Posted 16 January 2013 - 11:00 PM

Thanks toadflax, been looking for Lynne's spreadsheet everywhere.

New Years Resolution:- budget & meal plan

#13 Molondy

Posted 19 January 2013 - 02:35 PM

just bumping this as I couldn't get the link to Lynne's page to work - does anyone have a fresh link?

#14 HappyWomble

Posted 19 January 2013 - 02:44 PM

https://sites.google.com/site/budget-tracking/

#15 kate13rose

Posted 19 January 2013 - 02:49 PM

I like this one:
https://www.moneysmart.gov.au/tools-and-res.../budget-planner
original.gif

#16 PurpleNess

Posted 19 January 2013 - 03:55 PM

YNAB _ I just posted this week about how awesome it is, simple to use & you can tailor it to suit your priorities.

Heaps of on line support, tutorials and forums PLUS a 37 days free trial & only $60 to buy the full package , money well spent in this house!

OH FYI we have been working off a Excel spreadsheet for years now & this is SO much better !

Edited by PurpleNess, 19 January 2013 - 03:57 PM.


#17 ginnyk

Posted 19 January 2013 - 04:37 PM

QUOTE (PurpleNess @ 19/01/2013, 03:55 PM) <{POST_SNAPBACK}>
YNAB _ I just posted this week about how awesome it is, simple to use & you can tailor it to suit your priorities.

Heaps of on line support, tutorials and forums PLUS a 37 days free trial & only $60 to buy the full package , money well spent in this house!

OH FYI we have been working off a Excel spreadsheet for years now & this is SO much better !


I downloaded YNAB a few days ago, and am really impressed! Hoping I can "break out of the paycheck cycle" that they spruik as one of the main aims of the program.

I've used a different budget program for year, but it was way too complicated, I like how simple and easy this one is to use...

Thanks for posting it in the first place!



#18 Overtherainbow

Posted 19 January 2013 - 05:55 PM

I'm paid fortnightly, dh monthly.  We budget monthly.  All bills, mortgage, utilities, kids sports, etc are paid on his pay day as is credit card.  My pay just sits on home loan until his pay day.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

 

Win a Mountain Buggy Swift

To celebrate Essential Baby reaching half a million Facebook fans, we have a Mountain Buggy Swift to giveaway to a lucky fan.

Shopping with kids: breaking the pester-power cycle

You're out shopping with your little one and they're incessantly whining that they want a treat. It's easy to say no ... the first time, at least.

eBay jacket may hold clue to murdered girl's identity

A jacket similar to the one found with the remains of a brutally murdered little girl in South Australia has been identified on eBay.

New mum forced back to work early due to paid parental leave 'technicality'

Shelley Parker had to keep driving buses until the date her baby was due and will have to rush back to work at the end of this week after being denied paid parental leave on a "technicality".

Pregnant Amanda Palmer poses naked for book drive

It has to be the most original way ever of promoting a children's book donation day.

The conception dilemma facing many parents today

Some parents who conceived through a sperm donor will be wary of telling the child, while others prefer to deal with it early on. But recent research suggests it makes little difference either way.

The wedding photo the bridesmaid would rather forget

We've probably all seen a passed-out bridesmaid at one wedding or another, but it usually happens towards the end of the night.

Pregnant TV meteorologist takes on haters

Pregnant TV meteorologist Katie Fehlinger has hit back at haters who called her a "sausage in casing".

Honest words from first-time mums

I didn't want to say anything negative to my pregnant friend, but I wish I'd been more honest.

Adorable baby experiences rain for the first time, couldn't be happier

Harper had seen rain from the comfort of indoors before, but had never had the pleasure of being outside and experiencing it first hand.

What it's really like to start a family in your fifties

Many people suppose that it must be much more tiring to have a baby in middle age, but all the mothers in the playground look exhausted, whatever their age.

'Biggest hypocrite ever': Josh Duggar admits to Ashley Madison account

An American reality TV star has been busted with a cheating website account, according to US media.

Long recovery ahead for girl hit by car weeks after baby brother's death

A little girl is more alert and starting to talk after being hit by a car a week ago, but still faces a long recovery.

How to react when a toddler lies

Q: My almost-3-year-old is starting to figure out that he can lie when asked if he ripped the book, threw the food, hit his brother, etc. Totally normal, I know. How do we respond?

The circular experience of a Centrelink client

A mum-to-be experiences the frustration of dealing with Centrelink, myGov and everything in between.

Kelly Clarkson announces live on stage: 'I'm pregnant!'

Singer Kelly Clarkson has announced she is pregnant with her second child during a concert in Los Angeles.

Hack

How to search the leaked Ashley Madison data

At least three sites are republishing Ashley Madison's user data on the public-facing internet.

Mum dances her way through labour

There are a fair few ways to distract yourself and beat pains while in labour, but it's probably a rare woman who chooses her dance her way through it.

'Rest in peace, my little lion': premmie baby Jacob passes away

Baby Jacob, whose photo of him born at just 27 weeks was deemed 'too graphic' for a fundraising site, has died.

Mum killed three young sons 'to help her daughter', prosecutor says

Niall Pilkington's death last summer apparently raised little alarm in Bellefontaine, Ohio. Tragic accidents happen, after all.

Shorter women have shorter pregnancies: study

When a group of researchers studied nearly 3500 mothers and their babies, they noticed a curious pattern.

Get your FREE Baby & Toddler Show ticket!

Get your free ticket to the Sydney Essential Baby & Toddler Show for September 25-27 - register online now.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

The worst 20 minutes of my life

Thirty seconds was all it took to turn a shopping trip into my worst nightmare.

Top baby names for England and Wales in 2014

George has overtaken William in the official rankings of most popular British baby names - and Game of Thrones is still having an impact on parents.

Baseball or baby? Dad's tough choice

What's more important, a baby or a baseball? That's a question this dad seems to struggle with.

Childbirth choices: five star or free?

It's not often you hear the words labour and luxury in the same sentence but for some, a 5-star start to parenthood is exactly what they seek. And with a number of private hospitals now offering packages which include a post-birth stay at a sumptuous first class resort, many mums are choosing to recover in style.

'Where did your boobies go, Mummy?' and other soul-destroying comments from kids

Most women carry a smidge of baby weight after giving birth. If you're lucky enough to have an older child in the house, they can keep you on track with your weight loss goals.

Do you read me, baby?

Is it too soon to be reading to my two-month-old son? If not, what should I read?

Minimising sibling rivalry when you've got a baby

Sibling rivalry is an act of competition, but if your children feel involved and special, this type of jealousy will be minimised.

Will studying on maternity leave take you away from your most important job?

I remember when I was trying to decide if I could combine motherhood and furthering my university education.

Win a Pacapod this Father's Day

To celebrate dads and families, we are giving away a Picos Pack from Pacapod Australia filled with a few extra goodies ENTER NOW

Preschooler hit by car shortly after baby brother's death

A mother has had a frantic race to the hospital after her daughter was hit by a car, just four weeks after her infant son died.

Gay couple and Thai surrogate in custody tug-of-war

A six-month-old baby girl is trapped in the Thai capital in a bitter custody wrangle between her Thai surrogate mother and her biological father.

Couple denied IVF over parenting concerns

A mother of six has been denied access to IVF treatment in order to have another child over concerns about her parenting skills.

The book that promises to put your children to sleep

Exhausted parents from around the world are singing the praises of a "miracle" book which promises to put even the most restless child to sleep in just minutes.

5 things every parent who feels guilty needs to know

Parenthood can make you feel bad, but you're not alone.

Royals criticise 'dangerous' attempts to photograph Prince George

The British royal family criticized paparazzi on Friday for what it called their increasingly dangerous attempts to photograph young Prince George.

'No jab, no play' rule to cover Victorian kindergartens and childcare centres

"Anti-vaxxers" face not being able to send their children to childcare centres or kindergarten if they refuse to have them immunised.

15,000 birthing kits on their way to developing countries

Giving birth in a hospital surrounded by medical experts is tough enough, but some women deliver babies without a clean sheet to lie on.

Photo of premmie 'too graphic', fundraising site says

When their son Jacob was born at just 27 weeks, Christina and Jeff Hinks were thrown into an uncertain world.

The latest Bugaboo collections: cool chevron and runner prams

Bugaboo sure likes to keep things fresh, and with the Australian spring/summer season coming up, there are two new Bugaboo pram releases.

Making room for two in the bed

Mum's room or their own room? Cot or bassinets? Deciding where twins will sleep can be tricky.

 

FREE TICKET

See Hi-5 LIVE in Sydney!

Get your free ticket to The Essential Baby & Toddler Show and save $20 - register online now!

 
Advertisement
 
 
Essential Baby and Essential Kids is the place to find parenting information and parenting support relating to conception, pregnancy, birth, babies, toddlers, kids, maternity, family budgeting, family travel, nutrition and wellbeing, family entertainment, kids entertainment, tips for the family home, child-friendly recipes and parenting. Try our pregnancy due date calculator to determine your due date, or our ovulation calculator to predict ovulation and your fertile period. Our pregnancy week by week guide shows your baby's stages of development. Access our very active mum's discussion groups in the Essential Baby forums or the Essential Kids forums to talk to mums about conception, pregnancy, birth, babies, toddlers, kids and parenting lifestyle. Essential Baby also offers a baby names database of more than 22,000 baby names, popular baby names, boys' names, girls' names and baby names advice in our baby names forum. Essential Kids features a range of free printable worksheets for kids from preschool years through to primary school years. For the latest baby clothes, maternity clothes, maternity accessories, toddler products, kids toys and kids clothing, breastfeeding and other parenting resources, check out Essential Baby and Essential Kids.