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

 

Tell us what you think

to WIN 1 of 2 $500 Coles/Myer gift cards

Dealing with a toddler's morning tantrums

Your schedule is not important to your two-year-old, and you cannot convince her otherwise. So what can you do?

Child in suitcase 'could have died eight years ago'

A child whose remains were dumped in a suitcase in the South Australian bush is believed to have been a girl aged between two-and-a-half to four.

MP breastfeeds baby during parliamentary session

An Argentinian mum and politician has caused a stir on social media after being filmed breastfeeding her baby.

My baby's first seizure

It was 1am on a cold winter's night when I woke suddenly to the screams of my 12-month-old son. Our lives were about to change forever.

Portable pools 'more dangerous than permanent ones'

Inflatable and portable children's pools may be required to be sold with compulsory fencing to prevent backyard drownings, with some experts even floating the idea of a ban.

Heartbreaking moment mum kisses her one-week-old goodbye

At 11.07am on April 2 this year, Sarah Marriott welcomed baby Sebastian into the world.

The amazing Tee Pee bed and kid-friendly Frankie Bunk bed

These kids' beds definitely fit the brief of providing personality and personal space for little people who are moving up in the world.

The funny things kids say when you're pregnant

Since becoming noticeably pregnant, my son has taken more of an interest in the sibling he'll soon have.

The real problem with having one child

In this age of political correctness, it seems the one subject still subject to discrimination is that of the Only Child.

Six-week-old baby found dead, believed stabbed

A neighbour heard a child screaming before a baby was found dead, believed to have been stabbed, in a house in Newcastle.

The fire hazard in more than 70,000 Australian homes

So far, 206 Samsung washing machines have caught fire and some have exploded. But many remain in people's homes.

How having a baby can bring on OCD

We all know that having a baby can turn your life upside down - and it can also bring a raft of new anxieties and worries.

IVF gender selection being considered for Australian parents

Couples using IVF may be able to choose the gender of their babies and women could be financially compensated for donating their eggs.

The best age to get married (according to the latest study)

Not too young, and not too old. That's reportedly the best age to get married. Not everyone agrees.

Yes, you can get pregnant before your period returns post-baby

After giving birth, the last thing you want to think about is contraception. But you can get pregnant before your period comes back.

Fellow diner rewards mum after toddler's tantrum

Parents of toddlers everywhere know the feeling. After working up the courage to take your child out for lunch or dinner in public you are rewarded with a mid-meal meltdown. 

IKEA begins massive safety campaign after two toddler deaths

Two children were killed when pieces from their Malm furniture line tipped over.

Beaneasy: sweet nursery furniture with a twist

If you're looking to introduce an organic element into your baby's nursery but want to step away from natural timber, we have the perfect alternative.

A dad's guide to hyperemesis

I am in no way qualified to advise women on how to cope with hyperemesis, but I've learnt some lessons that might be worth sharing with other partners.

Woman adopts best friend's four daughters after cancer tragedy

Best friends share everything - and for these two life-long friends, that includes family.

Baby Leo's mum excluded from $500K trust 'for her own protection'

Samuel Forrest didn't want his wife as a trustee of their baby Leo's half million dollar trust for her own "protection", it has emerged.

Confirmed: men gain weight when they become dads

Men who become fathers experience weight gain and an increase in body mass index, a measurement of body fat based on height and weight, according to a new, large-scale study

Carer investigated over washing machine photo posted 'for a laugh'

She said the photo of a boy with Down syndrome in a washing machine was taken just for fun, but no one else was laughing.

Mum's premature labour nightmare after high tea salmonella outbreak

An opulent high tea at a luxury Melbourne hotel has left 44 people with salmonella poisoning - including a pregnant woman, who went into early labour.

The day my son started a fire

Would you know what to do in a fire emergency? How safe is your home and family?

Prince George celebrates second birthday

Prince George's second birthday has been marked by the release of an official picture showing the toddler smiling as he is held by his proud beaming father.

Which beauty treatments are safe in pregnancy?

Is it safe to use fake tan, hair dye and nail varnish during pregnancy?

The five ways I know my 'baby' is no longer a baby

The truth is, I can no longer deny that my walking, babbling, somewhat-independent little miss is no longer a bona fide 'baby'.

Review: Cybex Platinum PRIAM pram

I'm not usually one who believes in love at first sight but that's exactly what happened when I first saw the Cybex PRIAM.

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

Tell us what you think

to WIN 1 of 2 $500 Coles/Myer gift cards

Why I'm choosing to be a single mother right from the start

I believe that you get out of families what you put into them, and I will give mine my all.

Mother and baby units are a necessity for mental health, not a luxury

I have had two postnatal psychotic episodes. The first when my eldest child was six weeks old, and another after my second child was born.

30 French baby names

French names are always in fashion, but a few have risen in popularity in recent years.

New mum's Spanish maternity nightmare

A British woman who gave birth in Spain has told of her ordeal after spending weeks trying to convince medics the baby girl was hers.

Preparing Rover to be a good dog with baby

Some friends of ours say that it's dangerous to have a dog around a newborn and that we should start looking for a new home for him. Is it?

Company offers to ship working mums' breast milk home

First Apple and Facebook announced they would pay $20,000 towards the cost of their female employees freezing their eggs, now IBM in the US has come up with an innovative new policy aimed at retaining female employees.

Prince William speaks of his pride at wife Kate and 'little joy of heaven' Charlotte

The Duke of Cambridge opened up about family life and his plans for the future in an interview to mark his first day as an air ambulance pilot.

'Glowing' eye saves baby Mason's life

A simple photo taken in front of an evening fire gave new mother Sarah Bowers the power to save her baby's life. 

Parenting and decision overload

Of all the advice people told me before having a baby, no one warned me about the amount of decisions involved.

Proof that toddlers can't be left unsupervised - ever

Parents of toddlers all know the moment when realise your child is being suspiciously quiet. It can only mean one thing - trouble!

Meet Jeremy Ryan, The Voice contestant with seven kids

If you have trouble recalling the ages of Jeremy Ryan's seven children on The Voice, you're not alone. So does he.

Baby's adorable reaction to wearing glasses for the first time

Getting glasses can be a formative moment in a person's life.

Police officer buys supplies for family after mum of six caught shoplifting

When a mum of six was caught shoplifting nappies, clothes and shoes for her kids, the last thing she expected was for a stranger to pay for her haul.

Why pregnant women on antidepressants shouldn’t panic about birth defect claims

The risk of having uncontrolled depression is far greater than the small increased risk of birth defects that may be associated with specific antidepressants.

Arrests made over children's birthday party brawl

Police have raided properties and arrested a number of people over a brawl at a child's birthday party at a play centre in Sydney's west.

Family shares awesome drone baby announcement

Looking for a creative way to share some big news? Look to the skies, like this family did.

Young warrior Owen defies doctors' predictions

Little Owen DiCandilo's name means "young warrior", and it's a description that perfectly fits the inspiring 18-month-old

Advice for dads: when to approach your wife for sex

The exhaustion that comes with caring for young children often means romance between parents becomes a thing of the past.

I might be fat, but I don't need saving

I've been fat for pretty much most of life, besides a few crazy moments of being less-fat, but for the most part I've existed on this earth with a little more meat on my bones than desirable.

The rookie mistakes we make as parents

Since the dawn of civilisation, generation after generation of new parents have had to rely on instinct, trial and error - and sometimes get it wrong.

 

FREE TICKET

See Pinky McKay 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.