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 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

 

How to talk about your pregnancy at work

The workplace isn't always a friendly place for pregnant women. Yet working women inclined to conceal a pregnancy from prying coworkers may be better off opening up and carrying on, according to a new study.

Tell us your story to win!

To celebrate Mother's Day this year we are giving you the chance to win one of five great prizes simply by telling us your story.

Where to get help to help your baby sleep

There is so much pressure about having a baby who sleeps 'all night' , it's no wonder you worry about your baby if she wakes in the night.

Vintage baby names having a comeback

What makes some names have comebacks while others silently fade into oblivion? A few factors come into play.

When your partner doesn't want you to breastfeed

Dads can have many reasons for not wanting their partners to breastfeed their baby, but both parents should learn more about it before making a final decision.

Model mum Sarah Stage shares post-baby selfie

Most new mums would recoil at the thought, but Sarah Stage has shared a post-pregnancy selfie just four days after giving birth.

I'll admit it: I have last child parenting fatigue

If you're a new mum and feeling ignored by the older mum/the old hand/the has-been, please know, it's not you, it's me. Blame the last child parenting fatigue.

Exhaustion is not the same as tiredness

Having a new baby isn't tiring - it can be downright exhausting.

Five posterior babies, four home births

I was on a high. I'd done it all by myself with no help from anyone.

Mum's list of birthday gift demands goes viral

We're big fans of kids' birthday parties - but this is one bash we're glad we didn't get an invite to.

Kate Middleton to receive 'loyalty discount' for second birth

Everybody loves a bargain - including the Duchess of Cambridge.

Fish & chip shop owner's sad note goes viral

A lengthy note put on the window of a fish & chip shop has gone viral due to the writer's serious doubts about the romance of travel.

Pregnant women need good nutrition advice, not judgment

Pregnant women are under pressure to do all the "right things" to have a healthy child. It results in women feeling judged about their decisions.

When your child wants you to have another baby

Giving your child a sibling when you don't want to have another baby can be a complex issue.

William Tyrrell's mum speaks out: 'We hope he is still alive'

The mother of missing toddler William Tyrrell says she has a vision that somebody "picked him up and moved him on ... that's the only way ... to explain for him not to be there".

Family comes first for 23-year-old Tommy Connolly

Most 23-year-old blokes spend their hard earned cash on fun times with mates or romantic dinners with their girlfriend, but not Tommy Connolly.

Newborn all-girl quintuplets 'doing great'

The first all-female quintuplets born in the United States were delivered last week, at 28 weeks and two days.

Model mum's big baby silences critics

He may be less than a week old, but baby James Hunter has already helped his model mum silence her critics.

Jammy, Hula Hoop, Rage: Reddit reveals most unusual baby names

A recent Reddit thread has revealed some of the more creative names in the world.

Woman awakens from coma, learns she gave birth

A US woman awakened this week from a four-month-long coma that doctors had feared would be permanent and learned that she had given birth to a baby boy, according to her family.

'Give us a break': mum sent shocking letter over Facebook baby pics

Posting a lot of baby photos doesn't make you a bad person. It may make your Facebook feed a little irritating, but it doesn't make you a bad person.

In defense of the dads who do so much

It's time to shift the focus off what dads aren’t doing and shine it on what they are.

The modern cloth nappies too cute to cover up

If you're only just joining the modern cloth nappy movement, or would like to spruce up your collection, we have to introduce you to Designer Bums.

How breastfeeding can affect your libido

When you’ve just had a baby, having sex isn’t usually top priority. In fact, for a lot of women it rates about as appealing as changing another dirty nappy.

Should pregnant women be allowed to use 'parent and child' car parking spots?

Is it acceptable to use these car parking spots when pregnant? How many of us would admit to doing it?

Healthy baby from sperm taken 48 hours after a man died

Fertility doctors have described their "most extraordinary case" - creating a healthy baby from sperm taken 48 hours after a man had died.

Sign up to our 30 days of #PlayIQ challenge

Sign up to receive 30 amazing tips and ideas for play with baby during the month of April and submit a picture or tip on our social wall for a chance to win an amazing Fisher-Price prize pack.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

Last chance to win a year's supply of toys

You have less than a week left to win your child one of five Fisher-Price toy packs valued at over $600 each - hurry, enter today!

Childcare is a big problem, but there's more to it

Let’s keep talking about these issues and not allow them to be put into a neat little box that’s labelled ‘Fix childcare and everything is solved’.

Pink's awesome response to body-shaming trolls

When trolls felt the need to comment on 35-year-old singer-songwriter Pink's weight, her answer was an awesome ode to body love.

Fertility clinic offers egg donors $5000

A national chain of fertility clinics is offering egg donors a $5000 payment to cover their expenses, a first for Australia which is raising concerns the money could act as an inducement.

Baby boy abandoned in India amid fresh surrogacy concerns

Australian officials could do nothing to stop an Australian couple from abandoning their baby son, born through surrogacy in India, after they decided they did not want to bring him to Australia.

Herd immunity and community responsibility: how free-riders can make kids suffer

Individual choice works for haircuts and handbags, but not for preventing infectious diseases that kill kids.

Photographer captures 'unexpected beauty' of birth

If there is one thing Leilani Rogers knows about childbirth, it is that no two deliveries are ever the same.

Expectations vs the reality of making a toddler's clothes

Note to self: less sewing, more life. Not the party dress, but the party. The toddler, as usual, has it all figured out.

Mum meets 'dead' daughter 49 years after birth

In 1965, Zella Jackson-Price was told her premature baby girl had died shortly after birth.

How pregnancy probiotics can help you and your baby

New research suggests that taking specific pregnancy probiotics could be the answer to a range of common pregnancy side effects.

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.

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.

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.

 

ENTER NOW!

Win a year's worth of toys

Last week to submit a picture of your baby at play for your chance to win. Visit the Play Wall to view our recent entries.

 
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.