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


Join the Real Mums Test Drive Team

Five new mums will join the Essential Baby Test Drive Team and discover great new baby toys from Fisher-Price & write a review to be published on Essential Baby.

Two children fall from second storey window

Two young boys have been rushed to hospital after falling out a second-storey window of a home in Eastwood.

Victorian Labor to introduce same-sex adoption laws

Thousands of same-sex couples with children will have the right to be jointly recognised as parents by Victorian law.

Sneak peek: Maxomorra bee dress, t-shirt and romper for babies

Cutest snap find on the planet - bee rompers, tees and dresses for babies.

Toddler found two days after going missing

A two-year-old girl who disappeared on Friday night from her great-grandparents' home in rural Ohio was found alive Sunday evening in a nearby field.

Dad builds the ultimate bed for his toddler son

The transition from cot to big kid bed might be a little easier if every toddler had a bed like this one.

Is Woolworths now cheaper than Coles?

Woolworths appears to have taken the upper hand in its price battle with Coles after investing millions of dollars lowering the cost of groceries, according to new figures.

Aussie babies and parents stranded in Nepal after surrogacy ban

Parents say Australian babies are being "kept captive" and cannot come home after a ban on commercial surrogacy in Nepal.

Wannabe dads left behind in IVF debate

If virgin women can become mothers through IVF, maybe we're ready for another miracle - genuine equality for men in the parenting debate.

The health and fitness lessons I've learned

What I once assumed about health and fitness is wrong.

Our angel baby story: Hunter James

I have two children: one living, the next an angel baby.

Newlyweds send bill to no-show guests

Planning a wedding can be stressful – and, as most newlyweds can attest, it can be very costly, too.

Your choice or theirs: the tug-of-war over baby names

They had just decided on a name they both agreed on, but then the grandparents threw in an offer of $10,000 in exchange for choosing something else.

Dad-to-be's tearful reaction to pregnancy news goes viral

After 17 years of trying, this man had given up hope of having a family.

Claire Danes: acting out postnatal depression was difficult

Actress Claire Danes found it difficult pretending to have postnatal depression in Homeland, as she had just become a new mother herself.

The moment a 92-year-old meets her great grandaughter

It's a heart-warming photo this family will treasure forever.

How to prepare for breastfeeding when you're still pregnant

While every woman's breastfeeding journey is different, many hurdles are shared. Knowing what to expect will enable you to make informed decisions if - or when - you meet challenges along the way.

Sneak peek: new Love Mae bamboo dinnerware designs

We do love ourselves some brand new designs in tried and true products. The renowned bamboo dinnerware from Love Mae has just had several more members join the family, in addition to a brand new website.

Mum who killed paedophile gets reduced sentence

A mother-of-five who killed a paedophile has had her jail sentence reduced by a judge who described her case as a "truly exceptional" one.

Sneak peek: Geleeo self-cooling pram & high chair liners

We just spotted Geleeo, a brand new self-cooling pram liner you can buy in time for summer.

Toddler's silent debate with mum about naptime

He might not utter a single word - but this toddler is having a great debate with his mother about nap time.


What's hot on EB

Stella McCartney honours mum with lacy bra

Fashion designer Stella McCartney has honoured her late mum, Linda McCartney, by designing a special bra for post-mastectomy patients.

Don't panic: A granddad midwife's guide for dads-to-be

Mark Harris has helped deliver 500 babies. And he's now telling fathers what to expect.

How to be a calm parent when you're feeling anything but

Being a calm parent takes a lot of work, sometimes more than is obvious to those around us.

The joy and isolation of being a stay-at-home dad

It's cool, kind of like a second childhood. I love him to bits and think, on average, I'm an okay dad. But I also want to talk about the other stuff.

How baby Teddy's short life is helping save thousands of lives

He may have only lived for 100 minutes, but that didn't stop baby Teddy from saving the lives of others.

A heartbreaking trail of missed chances in death of baby forgotten in car

A haunting reminder to stay mindful about babies in cars, especially as we approach summer.

What to do if your baby has tongue-tie

Tongue-tie can cause feeding problems. However once it is diagnosed, the condition can be easily treated.

How to move house without losing your mind

Some people move frequently, while others like to stay put. But everyone finds it stressful.

'She had nowhere to go': how new mum's life began to unravel

The birth of her first child should have been happiest of times for Campsie mother Phuong Cao, but friends say it marked the beginning of when her life began to unravel. 

Women giving birth to a son keep some of his Y chromosomes

It was an experiment doomed to failure - they were looking for male cells in female bodies. And their search was stunningly successful.

Photos: How babies fit in the womb

A gorgeous photo series shows babies in the first hours after their birth - as they were positioned in the womb.

Baby tries to persuade stubborn bulldog to walk, fails

We don't know what he's saying, but this baby has a very clear message for his bulldog pal: let's walk - NOW.

The best toddler gift ever? Nine gender-neutral play kitchen picks

Without a doubt, one of the best gifts for a toddler turning two or three is a play kitchen.

9 easy steps to improve your baby photography

With a few simple tips you can take your images from random happy snaps to lovely clean images that create beautiful lasting memories.



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.