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.


#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


#15 kate13rose

Posted 19 January 2013 - 02:49 PM

I like this one:

#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


Newborn baby found in a nativity scene

Police are trying to trace a woman who abandoned a baby boy in the manger of a church nativity scene.

Life would be harder without my kids

The Humans of New York Facebook page is well known for sharing touching, real stories from one of the world's biggest cities – and it's just hit the heart of parents everywhere.

Mum dresses as Wonder Woman for last day of chemo

A Brisbane mum dressed up as a superhero to celebrate the end of her chemotherapy and created a moment her family will remember forever.

How a raisin can predict a toddler's IQ

All you need to assess a child's future intelligence is a plastic cup and a raisin, according to new research.

Former Hi-5 member's cannabis hope

Former Hi-5 star Tim Harding hopes a cannabis-derived drug will help control his daughter's epilepsy, which sees the four-year-old suffering between 50 and 100 seizures a day.

The top 5 reasons your toddler throws a tantrum

Whilst to the outside world little people may appear to have it easy, it's actually not always the case – just ask any toddler who's had their toast cut up the wrong way.

Glenn McGrath thought he'd lost his wife and baby

Australian cricket ledged Glen McGrath has spoken about the moment he thought he might lose his wife, Sara and their baby daughter, Madison.


Inside my Centrelink nightmare

Mother Bec Smith has been trying for months to access Centrelink payments. A "serious error" is preventing her.

Warnings over push for hourly childcare billing

Australia's peak childcare body has called for caution around the Turnbull government's push for childcare centres to charge parents by the hour, not by the day.

Cate Blanchett thought about adopting for years

Cate Blanchett says her recent adoption of a baby girl had nothing to do with wanting a daughter after having three sons.

Kate Walsh: 'I can't have kids'

Grey's Anatomy star Kate Walsh has revealed she is unable to have children because she has experienced early menopause.

The parasite that could boost fertility

The Tsimane women of Bolivia are often revered as among the most fertile in the world - on average having 10 children in their lifetimes -- but some are even more fertile than others.

Family may sue cousin over genetics

A Melbourne couple is suing the Royal Children's Hospital for failing to diagnose a genetic disorder in their first child - an error they allege caused them to have another child with severe disabilities.

Strange things mums have done in labour

While most women in labour focus on the upcoming birth of their baby, some women do more interesting things.

Michael Clarke reveals baby's name

When Michael Clarke said he was wrapped around the finger of his little princess, he wasn't joking.

The logistics of breastfeeding twins

Our life is more or less divided into neat four hour parcels of time and it's hard to get much of anything done in the time between feeds.

How to stop people ruining Christmas

We can make a conscious effort about how we react to those curly Christmas day scenarios that can send us up the wall, or should we say chimney.

Lots of formula offers for desperate mum

The mum who was down to her last three tins of baby formula said she had received hundreds of calls and offers to send her formula.

Surviving breast cancer while pregnant

It was last thing Rebecca O'Donnell expected at 30 weeks' pregnant. One morning, while putting on her bra, she felt a pea-sized lump in her right breast.

Cot sheet brands for the nursery

With so many awesome cot sheet options these days, we thought we'd put together a list of go-to brands for you to seek out for your baby's bed.


What's hot on EB

How I survived breast cancer while pregnant

It was last thing Rebecca O'Donnell expected at 30 weeks' pregnant. One morning, while putting on her bra, she felt a pea-sized lump in her right breast.

Grieving father's letter to Bataclan terrorists: "...this little boy will threaten you by being happy and free"

A grieving father whose wife was killed in the attacks on the Bataclan Theatre last weekend has written an open letter to her killers.

5 challenges of motherhood - and how to see them differently

Despite the smiles, the sloppy kisses and the pure magic children bring to our lives, it's hard to deny that motherhood can be tough.

4 challenges of being a new dad - and how to face them

Becoming a parent is challenging – and that applies to both mums and dads.

My battle against antenatal and postnatal depression

I was five months pregnant when I realised I needed help.

Children swapped at birth will not be returned to biological parents

A boy and girl accidentally swapped on the day they were born will stay with the families who have raised them, a South African court has ruled.

A quarter of men believe they get 'man periods'

A British study has revealed one in four men believe they have a monthly cycle.

Baby deposit

How much do you need to save for a 'baby deposit'?

It's fairly straightforward to calculate a house deposit, but how much money do you need to save up for a baby?

Dad's beautiful note to his wife, a nurse

To anyone else it might just look like a picture of a mum having a nap with her toddler.

'I was a complete schmuck': Mike Baird opens up about his wife's postnatal depression

When his wife Kerryn was not well following the birth of their daughter, NSW Premier Mike Baird buried himself in his work.

Mum's desperate plea as whooping cough alert issued

A desperate mother has shared a heart-breaking video of her baby struggling to cope with a coughing fit caused by pertussis.

Coffee could help you live longer

New US research found people who report drinking three to five cups of coffee a day are less likely to die prematurely from heart disease, suicide, diabetes or Parkinson's disease.

The joy and dread of playdates

To live vicariously through your child is to rediscover anxieties you thought dead and buried.

Sick baby could die without scarce special formula, mum says

Lizzie Cann is down to her last three tins of a special formula in short supply.

Adorable toddler's strop foiled by squeaky shoes

We're probably all familiar with the pouty bottom lip and tightly crossed arms of a tot mid-strop.

More sex during World Cup created more baby boys

More sex during South Africa's World Cup meant a disproportionately high number of boys were born nine months later, a new study has found.

Win one of two ABC Shop prize packs in time for Christmas

What a boon it would be to have your toddler's Christmas gifts covered this year. We have two awesome ABC Shop prize packs to give away to two lucky winners.

Do fitness challenges really work?

Fitness challenges aren't new. There's Michelle Bridges 12WBT and a bunch of other programs if you really want to lose weight.

What are pregnant women Googling?

Pregnancy is a huge change for any woman, so it's natural we'll have questions - and turn to Google to ask them.



Can't decide?

Check out the Essential Baby Names section for some inspiration

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.