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!

Finding baby name inspiration in unusual places

Sometimes the greatest baby name ideas come from the most unexpected places, as these EB members show.

The case for inducing at 37 weeks

While we often think of pregnancy as a 40 week affair, experts agree that 37 weeks is actually “full term". So is there an argument for inducing all births at 37 weeks?

Does controlled crying really work?

Controlled-crying techniques may help some babies sleep through the night, but for many exhausted new parents, it's just a recipe for more tears all round.

How I taught my infant to use a toilet

As people become more aware of these benefits, I hope more parents will practice this method, so we can cut down on nappies and improve baby bonding.

'I thought it was impossible': Emily Symons pregnant at 45

Aussie actress Emily Symons has announced she is pregnant with her first baby.

Shallow water blackout kills fit, healthy dad

A little girl will grow up without her father after the fit and healthy 34-year-old passed away while doing something he had practised his whole life.

Afternoon naps may be bad for toddlers' sleep

You could be doing yourself a disservice by encouraging your toddler to have an afternoon nap, according to new research.

Best gifts for newborns, new mums and christenings

We've compiled a guide to some of the most popular presents for newborns and new mums, and for christenings and naming days.

Jaime King to be a mum again

Actress Jaime King is pregnant with her second child, giving 16-month-old James a sibling.

Nannies should receive government funding

The Abbott government should extend funding to nannies, and direct childcare payments to low and middle income families, a landmark study on childcare has found. 

Common skin irritations in newborns (and how to treat them)

As many as one in two newborn babies suffer from skin irritations in their first few weeks. So what are the most common rashes and irritations to look out for?

10 wall decals for the nursery or playroom

Wall decals are the answer to creating a beautiful nursery or children's space without lifting a paint brush, a spirit level or even a hammer.

Preschooler walks 2.4km home alone

Three-year-old Cain Trainor headed off home after his first day at a new preschool without telling anyone.

Video: Why mums get nothing done

In spite of being in an almost constant state of motion while looking after the kids and trying to keep things together at home, it can seem as though parents have managed to get nothing on the to-do list done by the end of the day.

The middle name game

The middle name is no longer an afterthought, and parents' inspiration comes from many places.

Have a baby or your money back - but there's a catch

A new IVF scheme offers couples the chance to fall pregnant and give birth - or get their money back. But there's more to it than you might think.

A rare glimpse inside the womb

A baby born still inside the amniotic sac gave US doctors a rare glimpse at life inside the womb.

Battered mum forced to write to her attacker ex in jail

Three years ago Jason Hughes viciously attacked his ex-partner. Now she has to write to him three times a year.

Woman pleads not guilty to ultrasound scam

A West Australian woman will fight allegations that she scammed expectant mums by selling them fake ultrasound pictures of babies.

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

Brain damaged mum receives compensation

A Sydney mother who suffered brain damage when she was hit by a car while pushing her newborn baby in a pram has reached a confidential out-of-court settlement with the driver's insurance company.

Indigenous midwives break down the barriers

A culturally sensitive midwifery service has gained the trust and respect of Aboriginal women.

The Katering Show's next big delivery

Most mums-to-be plan to take things easy and perhaps have a little break from work as the birth of their baby draws near. Not Kate McCartney.

53 creative pregnancy announcements

Announcing that you're expecting can be a time to express your creativity, sense of humour and imagination. Check out how other parents and parents-to-be have broken the news to friends and family.

Why I have mixed feelings about Cindy Crawford's leaked photo

Last week an un-retouched photo of model Cindy Crawford surfaced, showing the 48-year-old mother-of -two posing in underwear.

How to create a Peppa Pig pancake

Thought your toddler could not love pancakes any more than they already do? How about if the breakfast treat came in the shape of every two-year-old's favourite cartoon character?

'It's a little life, not a little loss': pregnancy after miscarriage

I thought I was never going to be able to have a successful pregnancy. I decided that I wasn't going to form an emotional attachment with this baby.

Bonds Baby Search 2015: what you need to know

February 18 marks the start of one of the most prolific annual baby competitions in Australia: the Bonds Baby Search. And this year is going to be more special than ever.

Who will manage your Facebook account when you're gone?

This is not something that people like to talk about, but Facebook has announced that it will grant users more control over what happens to their pages after they die.

Struggling mum of four wins $188 million

Mother of four Marie Holmes was financially struggling after quitting her jobs at Walmart and McDonald's in order to care for her children.

Pregnant obese women a 'relatively new problem', coroner hears

A first-time mother whose daughter died hours after her frightening birth insists she was never told of the risks of being obese and pregnant.

'I'm angry as hell': the story behind mum's passionate vaccination plea

She has labelled parents who do not vaccinate their children "misinformed imbeciles" - and for that, she makes no apologies.

IKEA hacks for the nursery and kids' rooms

Are you one of those that know the whole IKEA catalogue by heart? Love their stuff but want to personalise it? Here's some inspiration to help you realise the potential of IKEA furniture and fittings.

8 different kinds of tantrums

I never thought I’d say this, but for a brief moment last week, Kim Kardashian and I had something in common: both our kids had public tantrums.

Polycystic ovary syndrome: symptoms, treatment and your fertility

Polycystic ovary syndrome (PCOS) is the most common female hormonal condition, affecting roughly one in 12 Australian women.

What's the best position for giving birth?

If doing it on your back is out, what's the best position for labour and birth?

Wife forgives snake catcher husband for car surprise

With Valentine's Day coming up, Nat Gilbert could be forgiven for thinking her husband might be planning a surprise for her.

Kids who meet milestones at their own pace

We usually only hear the success stories: tales of the two-year-old who’s talking, running and completely toilet trained. But other stories need to be told too.

Ruby shines as Bonds Baby

Sarah Kiss has a word of advice for proud mums and dads who are keen to enter their babies in this year's Bonds Baby Search Competition - just have fun.

Why dads should go to sleep school

If your family needs to go to sleep school, go with them. You are part of that family and you are part of the solution.

36 baby names inspired by food and drinks

A French court may have ruled out Nutella as a baby name, but that doesn't have to stop you from taking inspiration from the supermarket (or bottle shop). See what parents in the US have chosen for their delicious little ones.

Clever breastfeeding products

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

 

Win a KitchenAid Mixer

Let's celebrate 300,000 fans on Facebook

To celebrate, and to thank our amazing fans, we?re giving away a KitchenAid Artisan Tilt-Head Stand Mixer.

 
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.