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 offer: The Baby & Toddler Show 2014

At The Baby & Toddler Show, you?ll find everything you need to get ready for your new arrival and guide you through the early weeks and years of parenting.

An open letter to Tony Abbott: please salvage our super

We face financial ruin, but most of us don?t realise it. If we don?t act together to salvage our superannuation, I have no doubt the new GFC will be the Girls? Financial Crisis.

'I'm happy to know I'm changing lives': surrogate mum of two

I know that once the baby is born, I will focus on the gift I have given, and watch the parents with their new child. I can't wait for that day.

Birth trauma and the issue of informed consent

There is a perception that women should just be happy they have a healthy baby in their arms. But for women who experienced birth trauma, there's a lot more to it.

Tips for managing pollen allergies and hayfever

They're simple tips, but they can have a big impact on those who suffer from hayfever and pollen allergies.

Ada Nicodemou shares tribute to her stillborn baby

Just over one month since Ada Nicodemou and her husband lost their second son, the Home and Away star has shared a touching poem for her baby.

Mum causes stir breastfeeding on train

?To the woman breastfeeding her kid on the train. Seriously! On the train?" began the letter of complaint.

10 things they don?t tell you about being pregnant

As I slowly waddle my ever-changing pregnant body towards the finishing line of my due date, it?s becoming increasingly clear there are a lot of things they just don?t tell you about pregnancy.

Overcoming a fear of the dark

A toddler's fear of the dark is very normal, but there are ways parents can help children through this stage in their development.

Kids, TV and movies: how young is too young?

It seems you don't have to throw the TV and iPad out the window - it all boils down to moderation, supervision and interaction.

Video: Baby's first birthday is a special day for mum, too

?A baby?s first birthday is also mum?s first birthday.?

The day Supernanny came to tea

Prince William's favourite celebrity child trainer Jo Frost puts Bryony Gordon and her toddler through their paces.

Tales from the homefront

When you're at work you sort of assume that your house is basically just sitting there quietly doing nothing until you return. However, since spending my days at home, I've learned this couldn't be further from the truth.

The words I hated hearing as new mum

It was less than a week after my son was born that I first heard it - from my mother.

To the pharmacist who sold me baby formula

On the rare occasion I catch sight of you at school, or around town, I think back to our earliest exchange. I?m sure you have no recollection of it at all.

Babies may benefit from autism therapy

Children showing signs of autism don't usually receive early intervention until well into toddlerhood or later, but a new study suggests infants with symptoms of the developmental disorder might benefit from therapy from as early as six months.

Knatalye and Adeline born with an everlasting bond

Knatalye Hope and Adeline Faith are a lot like any other identical twin girls, but there is one dramatic difference: they're joined at the chest and shares several internal organs.

The question this dad wishes he'd asked his wife

I should have seen that my wife wasn't the same person I'd fallen in love with, but we were both too focused on simply trying to get by.

Why we should talk about the deaths of the Hunt children

The deaths are too horrible even to think about. Yet we owe it to the children - Fletcher, Mia and Phoebe Hunt - to think long and hard about it all.

Baby dies of meningococcal weeks after vaccine application denied

A six-month-old girl has died from meningococcal disease just weeks after an application for government funding of a vaccine for the most deadly strain of the virus was rejected.

Finding the right balance when playing with your kids

Being too involved in our children?s play and not allowing our kids enough free time for unstructured activities can mean our kids miss out on the value that play offers.

Creative DIY light shades

The Pop Light light shade comes in a flat pack already made - it's up to you to design it as you'd like.

The battle of iParenting versus imagination

Have we forgotten how to be imaginative, resourceful parents?

Why movement is so important for your baby's growth

Letting your child move as much as possible in the early years ? using all senses, engaging in the real world, preferably outside ? will help them grow up healthier, smarter, calmer and stronger.

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

Special offer: The Baby & Toddler Show 2014

At The Baby & Toddler Show, you?ll find everything you need to get ready for your new arrival and guide you through the early weeks and years of parenting.

Losing yourself to motherhood

While watching your baby grow into a unique little person is exciting and wondrous, the intensity of meeting everyone else?s needs can ever so sneakily overtake your own needs for self-care.

Tearing during delivery: the facts

Almost all women will experience bruising, grazing or tearing after a vaginal birth. Depending on the degree of tearing, there are various treatments available.

6 tips for a day out with a baby and toddler

Outings can be lots of fun with the kids, but there are inevitable challenges. Here's some information about days out to help you be a little more prepared.

Why I invited a dozen people to watch my son's birth

I sent invitations on burgundy scrapbooking paper stamped with a field of poppies, and told each person why I wanted him or her there. I warned that there would be nudity.

Getting labour started: tips for a natural induction

When your baby?s due date comes and goes without so much as a pop - let alone a bang - it can be disheartening. Mums and a doula share their stories of natural inductions.

7 mistakes old hands make with new babies

As I sat across the table from my friend ? me, a seasoned mother of three; her, a brand new mum ? I thought of all the mistakes an old-hand parent can make when visiting a newborn baby.

That's my boy: a dad's diary of the first 4 months

Unbearable anxiety, unspeakable joy, constant exhaustion and bouts of frustration ... The many shocks of first-time fatherhood resound in a dad's diary of his son's early months.

One of the most important things a new mum can do

Finances may not be as cute as a newborn, but with many women?s working arrangements changing post-baby, monetary matters need attention too.

6 things I didn't expect as a parent

From weird smells to dangerous opinions, painful body parts to numbness, here are a few things new mums and dads can expect.

Personalised baby gifts

We've scoured the internet to find gorgeous personalised keepsakes and nursery decor to record baby name and dates. They make great gifts for christenings, name days and birthdays! (All prices in AU.)

 

Reader offer

2 FOR 1 TICKET OFFER

For Shopping, For Advice, For Baby & You. Enjoy a special day out with fabulous shopping from over 200 brands, leading parenting experts offering advice on a range of topics, and amazing children?s entertainment

 
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.