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 itsmemacdolby

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 pinkpineapple

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

 

Special Ticket Offer, Save $8!

The Essential Baby & Toddler Show is back this April! Save $8 off the door price for a limited time only!

Why I breastfed my son until he was three

The fact that I not only breastfed my son, but breastfed him for three and a half years, seems pretty incredible in retrospect.

Do babies and young children see ghosts?

Do babies and young children see ghosts? If you’ve pondered the question, you’re not alone.

15 years with Essential Baby: meet Therese

"Life has a funny way of giving you what you need when you need it the most."

Mum causes a stir by taking a stand against leggings

A mum has found herself the subject of debate after claiming tight bottoms cause lustful thoughts in men.

Don't set a parenting goal for 2015 - do this instead

The problem with goal setting as a parent is the measure. How do we really know if we’re succeeding?

5 pregnancy myths that just won't go away

When you're expecting, it often seems like everyone is keen to offer advice about what you should and shouldn't do in the interests of your health and wellbeing.

RPA hospital contacting mums after discovering vaccine storage fault

Sydney's Royal Prince Alfred Hospital (RPA) is trying to contact women who had babies at the facility after discovering a fault in a refrigerator containing vaccines.

'Nutella' not a baby name, French court says

A French court has blocked parents from naming their baby girl after the hazelnut spread Nutella, arguing it would make her the target of mockery.

Why I'm never calling myself 'just a mum' again

I’ve grown three human beings. I feed them, dress them, teach them, care for them and love them 24 hours a day. Yet for eight years, when I meet new people and they’ve asked me what I do, I tell them: “I’m just a mum”.

Rosie Batty named 2015 Australian of the Year

One year ago, Rosie Batty could not have imagined she'd be where she is. Tonight the grieving mum who put domestic violence on the national agenda was named Australian of the Year.

Five reasons to hug more

Hugging – some of us thrive on it, even depend on it – and then there are those who don't care for it really. So, are they missing out?

Help - my three-year-old has started throwing tantrums

My daughter never went through the "terrible twos" but began throwing wild tantrums shortly after her third birthday.

That's commitment

First peek at Sonia Kruger's daughter Maggie

"She smells so good, I could eat her," Kruger tells co-host David Campbell.

Mum assists in own caesarean surgery

A mum who partly delivered her own twins during a caesarean has encouraged other women to take control of their birthing experience.

How to handle common childhood regressions

Regression can be a natural and common part of development prompted by a variety of factors, but that doesn't make it less frustrating.

Disgruntled dad's pram ad goes viral

When buying a second hand pram, there are lots of things to take into consideration. 

Man discovers he's a dad after finding 55-year-old letter

Discovering you are about to father a baby is startling enough - never mind finding out you have a 61-year-old son.

15 thoughts mums have during a tantrum

Ranging from mild to feral and triggered by events both minor and major, tantrums certainly keep life interesting.

Natural pain relief in the early stages of labour

While managing labour pains on your own can be daunting, there are a number of natural pain relief options to help you cope until you are admitted to hospital.

Win an Octonauts prize pack

To celebrate the launch of Octonauts Live! Operation Reef Shield, a spectacular underwater adventure live on stage, we are giving away an amazing Octonauts prize pack to one lucky fan.

Download now: Essential Kids Activity Finder app

Got bored kids? Quickly find the best activities for kids wherever you are in Australia with the Essential Kids app.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

Forgotten Baby Syndrome claims the life of toddler

One baby dies every eight days in the back of a car in the US, victims of 'forgotten baby syndrome'.

For a brief time, I was touched by an angel

For a brief time, I was touched by an angel. You stole my heart, and changed me into the women I am today.

Chinese woman gives birth to quintuplets

After six years of trying for a baby, a couple’s dreams have come true many times over after the mum gave birth to quintuplets this week.

Chrissie Swan has reached her "sex quota"

Chrissie Swan says she and her partner have sex once a year due to her fear of falling pregnant.

Stars help save choking babies

It's an important lesson to learn, but one that busy new mums and dads might overlook until it's too late.

New Girl star Zooey Deschanel pregnant

Actress Zooey Deschanel is expecting her first child with her producer boyfriend Jacob Pechenik.

16 times 'dad reflexes' saved the day

Of course, in some cases they may be the ones who actually got their child into a precarious position in the first place, but we'll ignore that for now.

Couple's 'non-traditional' pregnancy announcement goes viral

Knowing you are not the father of your pregnant wife's baby would usually indicate a rocky relationship ahead for traditional parents.

The trials and tribulations of identical triplet newborns

Pip Donnelly is still playing spot the difference with her newborn identical triplets, Isabelle, Georgina and Frankie.

Win an Octonauts prize pack

To celebrate the launch of Octonauts Live! Operation Reef Shield, a spectacular underwater adventure live on stage, we are giving away an amazing Octonauts prize pack to one lucky fan.

Earthquake baby thriving five years on

Jenny Alexis is lucky to be alive after spending four days buried in the rubble of the 2010 Haitian earthquake, but now she's a thriving five year old.

Please don't say I'm lucky because I was adopted

On the one hand I was having a regular life with friends and sports and sleepovers and school. But I was also always wondering: Did my mother love me? What was wrong with me?

An open letter to non-parents who offer advice on child-rearing

Kitty, when you’re the parent of my child you’re welcome to wade in with an opinion – but until then, I’d prefer you to have a supportive ear and a glass of wine ready.

Couple arrested over baby gun video

A US couple faces charges after investigators say they found mobile phone videos showing the woman's 12-month-old daughter putting a handgun in her mouth.

NSW Health dumps 10-year limit on frozen embryos

A 10-year time limit on storing frozen embryos that were created with donor sperm has been dropped by the NSW government.

How my happy-go-lucky husband became a monster

Sharan Nicholson-Rogers watched her husband change from a happy-go-lucky police officer into an unpredictable man prone to violent and emotional outbursts.

Dads-to-be experience hormonal changes, too

Dads-to-be experience hormonal changes in line with their pregnant partners, a new study shows.

'They were just doing their job': mum of toddler killed in police chase gone wrong

"They were just doing their job. I feel so sorry for them. It is all just too sad."

Miscarriages to be formally recognised by NSW government

Women who miscarry will be able to obtain an optional "recognition of loss" certificate as a formal recognition of their often heartbreaking loss.

Cafe cubby house 'too noisy' for neighbours

Teenage parties, domestic disputes, or raucous late night pubs are the things that usually come to mind when you think neighbourhood noise complaints.

Dad films baby playing with snake

Most parents would not consider a snake an appropriate playmate for their baby, but a US dad who filmed his daughter playing with a python has defended himself against criticism.

Clever breastfeeding products

Check out this range of products designed to help make your breastfeeding journey more enjoyable, manageable and convenient.

 

Back to School Offer

Findababysitter.com.au

We've got you covered for this school year. Use www.findababysitter.com.au to meet local nannies 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.