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

 

WIN an exclusive performance from Sam Moran!

To celebrate the release of children?s musical series Play Along with Sam, out now on DVD, we?re giving one lucky parent the chance to have Sam perform at their child?s pre-school or day care!

Toddler freed after getting trapped in escalator

A shopping centre escalator needed to be pulled apart to free a toddler's trapped hand.

Why I'm kind of excited about my daughter's nits

Is it weird to say that I am secretly thrilled to find that my daughter Edie has nits?

Baby born at 10:11 on 12-13-14

Well, it's actually 13-12-14 to us over here. But still, Clare Elizabeth Keane's consecutive numerical birth time is pretty special.

On holding tightly and loving fiercely

We can't live in fear. This post is about Christmas and how at this time we should be celebrating life and grateful for what we have: our loved ones who we cherish fiercely.

Babies, relatives and coping with Christmas day

Everyone will love your baby but your baby may not be so happy to be passed around a lot of new people - nor may you want to feed with an audience.

Why I won't be posting pictures of my baby on Facebook

There are pros and cons to this policy.

The myths and truths of gender swaying

Here are a few popular methods hopeful parents-to-be use to try to get a baby of their preferred gender – and what an expert says about whether they really work.

10 easy DIY Christmas decoration ideas

It's officially time to get into the Christmas spirit. Why not branch out when you put up your tree this year and add a personal touch with a few DIY decorations? We've found the perfect easy-to-make ways to put more festive fever into your home.

The dangerous new trend of glucose challenge test refusal

A dangerous trend is seeing more mothers-to-be declining a relatively simple and painless test to check for gestational diabetes.

Office of Fair Trading reveals naughty toys ahead of Christmas

The Office of Fair Trading has pulled seven toys from shelves ahead of Christmas after they fail safety tests.

Video: Baby boy's trouble with twins

These twin girls will no doubt have fun fooling people in years to come, but nobody will be as confused as baby Landon.

Long-term reversible male contraceptive on its way

Men could soon have access to an injectable long-term contraceptive which works in a similar way to a vasectomy but promises to be easily reversed.

'I tried to kill my baby': one mum's story

After bathing and dressing her three-month-old son, Amanda had a rare moment alone with her baby.

Attack of the 'mummy brain'

I feel that almost every day, someone in my life - be they a friend, family member or complete stranger - feels the need to excuse my behaviour as I have other things on my mind.

Mum of baby who fell ill after drinking raw milk speaks out

A Melbourne mother has described how her son turned grey when he became seriously ill after drinking raw milk.

Australian divorce rate lowest since 1976

Modern newlyweds are now well into their 30s and marriage still offers something powerful a new book argues.

The aftermath of a traumatic birth experience

In Australia, 30 per cent of women find their birth experience traumatic, with 6 per cent going on to develop post traumatic stress disorder (PTSD).

Young mum burns 'from inside-out'

A young mum is in intensive care after she took a friend's antibiotic and wound up with an ailment that is burning her body 'from the inside-out'.

The disagreement that can break a relationship

If he doesn't change his mind, all I can hope is that I will. It would be a waste to spend the rest of my marriage mourning a baby that never was.

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

Co-sleeping or no-sleeping? Mum videos worst nap ever

One mother's futile attempt to sleep in caught on camera in a hilarious - and very cute - video.

Why children misbehave during the festive season

While we all like to imagine the holiday season as being a fun, loving and bonding experience; often our reality is quiet different.

I was fat-shamed by my doctor

The fear of being weighed is the most significant factor in women cancelling medical appointments - and now weight-shaming has happened to me.

End of an era: no more childcare

As we reach the end of 2014, we're closing the book on many things for another year, most notably childcare. Our last child has attended childcare for the very last time.

WIN an exclusive performance from Sam Moran!

To celebrate the release of children?s musical series Play Along with Sam, out now on DVD, we?re giving one lucky parent the chance to have Sam perform at their child?s pre-school or day care!

The 7-year itch is more like the 10-year itch: study

Contrary to popular belief, making it past the seven-year mark doesn't mean your marriage will be smooth sailing from there on.

Should children be forced to sit on Santa's lap?

We teach kids it’s okay to say no if they don’t feel safe, so why do some parents force their children to climb in to Santa's lap?

Stop telling us that parenting gets harder

I’m sure that parenting will get harder. But life isn’t exactly smooth sailing for many of us right now, either.

Baby born weighing almost 14 pounds

Yes, the bouncing baby girl was born by caesarean section. And mum says no more kids.

The dummy debate

I'm the first to admit that when I used to see tiny babies with dummies in their mouths, I thought "Hmm, lazy parenting." And now I apologise.

'I thought I was an only child'

Imagine meeting your double at a school sports event, or regularly being mistaken for someone you haven't met. Separated twins Margaret and Joy tell their story.

Carers admit to force-feeding children

As Sydney grieves the loss of Sydney siege victims Katrina Dawson and Tori Johnson, reports have suggested that both died as heroes.

 

How many weeks til Christmas?

On your To-Do list

Get the "Santa" shopping done without the kids in tow.

 
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.