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

 

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.

Win Love Child Season 1 & 2 on DVD

To celebrate the release of Love Child Season 2 on DVD from July 9, Essential Baby and Universal Sony Pictures Home Entertainment are giving away Love Child Season 1 & 2 on DVD to 13 lucky winners.

10 things I wish my pre-baby self knew

I look back at my pre-baby self and laugh at how ridiculously easy I actually had it. I remember complaining about how tired I was and how little time I had.

Creative ways to store your child's art

Ideas for storing your child's artworks have moved on from sticking them to the fridge door before guiltily dumping them in the bin.

Child abuse ignored because 'it's not your children': Waleed Aly

Waleed Aly takes apart the immigration law that's designed to "protect politicians"

How a newborn niece changed star Australian basketballer's life

In August 2013 star basketball Abby Bishop was 24-years-old and in the prime of her sporting career.

Guilt is my new shadow

No one warned me that when I gave birth there would be an additional side order of guilt.

12 brilliant Ikea hacks for kids’ rooms

Check out these creative upcycling ideas that transform regular Ikea items into something special for your little ones.

Child's nightmare about 'man with a light' turned out to be real

For three days, a three-year-old boy had been saying there was "a man with a light" outside his window at night.

Toilet truths after giving birth

The thought of going to the toilet after giving birth is often feared, but there are ways to make it less painful.

Woman asks strangers for $1 million to stop her having an abortion

An anonymous woman is taking an extreme moral and ethical stand by seeking $1 million in donations to prevent her going ahead with a planned abortion.

How a woman's dying wish made another woman a mum

"I kind of think about, 'What did I do beforehand? What kept me so busy back then?' Because now I'm really busy."

The parenting do-over: what six parents did differently second time around

In playgrounds across Australia, you can hear parents lamenting, "When we have our next baby I swear I won't be doing THAT again".

A solo birth, a wasp swarm and a forest fire: mum and baby's amazing story of survival

Desperate, out of petrol and low on food, a new mother lit a fire in the hope of attracting attention.

Boy found on swing died of hypothermia and dehydration, autopsy finds

The story was chilling and heartbreaking: a three-year-old boy was found dead in a Southern Maryland park, his mother pushing him on the swing.

Child's play and laughter help battle fatigue

Feeling fatigued? Uh-huh, thought as much. Join the queue.

Dad shares entertaining 'how to hold a baby' clip

For many new dads, their own child is the first baby they have ever held. So one dad has posted an instructive YouTube video titled "How to Hold a Baby".

The Australian baby with 100,000 Facebook fans

She may be only eight months old, but Egypt has already amassed more than 100,000 fans and received a letter from royalty - Hollywood royalty that is.

Tongue tie: what you need to know

Tongue and lip tie can lead to many problems for babies - and their parents. Here are the signs of tongue tie and how it's treated.

My daughter is small but that doesn't matter

My daughter may be small, but it's my job as her parent to refocus back where it belongs - on who she is as a person

Wet wipes linked to rise in allergic reactions

The government has issued a health warning after a rise in allergic skin reactions has been linked to a preservative found in some wet wipes.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

27 funny ultrasound pictures

Ultrasounds give you a look at your growing baby ... and sometimes what appears to their womb-buddy, or your bub in an amusing position.

What all parents should know about safe babywearing

A picture of Ryan Reynolds always gets the girls talking, and a recently shared photo has done exactly that - but this time, it's for all the wrong reasons.

Baby's head shape reveals potentially fatal condition

Thinking her baby just had an unusually shaped head, a mother was shocked to discover it was instead linked to a dangerous condition.

Why IVF success rates may not be what you think

Transparency, accountability and responsibilityare essential measures to protect IVF vulnerable patients.

Mother-in-law 'from hell' inspires survival guide

The happily ever after Nicola Milan had imagined wasn't to be – and she blames her mother-in-law.

Owning a pair of nail scissors does not make me a hairdresser

It's been a whole year since sleeping in until 10am. A whole year since having a peaceful shower.

The 83 children who were tragically let down in the last decade

Over a 10-year period, 83 children died from domestic violence abuse in NSW, with three quarters of the victims aged five years or under, the NSW Ombudsman has revealed.

Is it reasonable to expect your partner to give up drinking in pregnancy?

From the moment that I fell pregnant with my son, I realised just how much my life had already started to change.

Stroke victim joins class action against makers of popular contraceptive pill

"I was terrified I would always be this way. The pill needs to come with a much higher warning."

Sexy time

Why you should get excited about scheduling sex

Unfortunately, the belief that sex should always be spontaneous is a myth. It just isn't.

When newborn photoshoots get messy

When it comes to newborn photoshoots, it is all about the timing.

Expert Q&A: Gross motor skill development in toddlers and preschoolers

Dr Katie Heathershaw answers questions about jumping, toe walking, riding a bike and being pigeon toed.

'Samuel is our firstborn, and he will never be forgotten'

Having lost their firstborn at one day old, the Carrolls were overjoyed to welcome their daughter Isobel into the world a year later.

Dad takes miraculous catch while feeding baby

One American father has taken multitasking to a new level at a Cubs-Dodgers baseball game at Wrigley Field.

Name your baby Quinoa, win a $10K gift card

Choosing a name for your little bundle of joy is always a major decision. It can be something traditional, trendy, creative … or inspired by the menu of your favourite chain restaurant.

On the 10th anniversary of my son's death

This day marks a significant day. Today marks 10 years since I lost my son Kai.

'Help - my toddler hits me!'

My toddler has started hitting when he gets frustrated, is feeling ignored, or just thinks it might be fun.

The top 6 misleading parenting terms

From 'morning sickness' to 'the terrible twos', there are many parenting terms that are misleading.

When 'good' nannies go bad

While most nannies take pride in their work, there can be some who have a hidden side.

Woman hospitalised for skinny jeans injury

Beware: skinny jeans might be bad for your health.

Gauze seeding: the bacteria-breeding birth trend

A number of women having caesarean deliveries are now taking steps to give their baby a better 'microbiome' start in life.

Jimmy Fallon writes new children's book for dads

Jimmy Fallon, host of NBC's The Tonight Show, recently wrote a children's book about every father's secret wish for their baby's first word to be "dada" - not "mama".

28 names for babies born in winter

Looking for some baby name inspiration for a bub born during the colder months? Here are 28 options from around the world to consider.

 

FREE TICKET

Get your FREE ticket to the Baby & Toddler Show

Get your free ticket to the Sydney Essential Baby & Toddler Show for September 25-27 - 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.