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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

 

Exclusive Black Friday Sale!

Get over 40% off selected products, including prams, baby carriers, cloth nappies, sleeping bags and much more! 24 hours only, on May 6 - register now for your special code.

Kelly Clarkson shares first photos of son

Kelly Clarkson has shown off the first photos of her son, Remington Alexander Blackstock.

5 childbirth myths that need to be busted

Birth is an unpredictable, mysterious process that intrigues us all, and there is a lot of misinformation out there.

Mum of three fatally shot by toddler while driving

A US mother has been shot by her toddler while driving on a highway in Wisconsin.

All you need is one minute to work out

The seven-minute-work out is old news. Research shows the effectiveness of going hell-for-leather for just one minute.

Pregnant women needed to join diabetes study

Pregnant woman in country Australia will help Adelaide researchers figure out why cases of type 1 diabetes have doubled over the past two decades.

Just announced: the Mountain Buggy Unirider

It's the perfect solution to combat those toddler meltdowns when they no longer want to be in a pram but can't walk long distances.

Authorities euthanise dog that fatally bit a newborn baby

A pit bull mix that fatally bit a 3-day-old infant last week has been euthanised, authorities said.

The push for Medicare to fund lactation consultants

While meeting with a lactation consultant can make an enormous difference to a new mother, it's not a service that is available through the public health system.

Why it's perfectly natural to dislike other people's children

Members of a popular forum are fiercely debating whether it is acceptable to dislike a friend's child.

Woman gives birth on plane, names baby after airline

A pregnant woman who unexpectedly gave birth on a flight has named her new baby after the airline, Jetstar.

Heartwarming photos show the joy of adoption after foster care

Children living in foster care can feel like their future is less than clear. But that uncertainty disappears the day they are adopted by their "forever family" 

'Oh my god, it's a baby!' Mum shocked to give birth

When the cramps started to kick in, Klara Dollan just assumed a painful period was starting.

Mum's Facebook plea: 'Help me find my daughter's father'

Kerryn has a unusual present planned for daughter Imi's 13th birthday celebrations - she hopes to be able to be able to give the soon-to-be the teenager her first ever photo of her dad.

Is it possible for your house to be too clean?

Our houses are cleaner than ever before. But how clean is too clean? Could a sterile home be putting your family's health at risk?

Millions of Monkeys: puzzles that grow with your toddler

Here's a puzzle that grows with them; the Puzzle Grow Pack by Millions of Monkeys.

Baby names from Britpop

If you grew up in the 90s you might want to look to the genre of Britpop music for baby name inspiration.

What to eat and drink when you have gastro

When you catch a bug that causes acute infectious gastroenteritis (gastro), your stomach and intestinal tract become inflamed, causing diarrhoea, nausea, vomiting, abdominal cramping and pain. The last thing you probably feel like doing is eating.

'To this day, I owe her my life'

Would I have survived if I hadn't crossed that street?

Why baby Sonny needs you to vaccinate your children

Caitlin is a firm believer in the importance of immunisation to protect children from harmful and deadly diseases.

Five-year-old's photo captures beauty of motherhood

There is no make-up or special outfits and hairdos, but the five-year-old boy who took this picture captured the essence of motherhood as well as any professional photographer.

Babies know whether you are naughty or nice

Studies have shown that infants in the first months of life try to avoid dealing with social wrongdoers - for example, sharing less with them and helping them less - and they expect others to, too.

 
Advertisement
 

Top 5 Articles

Advertisement
 
 
 

What's hot on EB

The babies who are one in 70 million

Bethani Webb was excited to find out she was pregnant, but the first time mum did not realise she was carrying four babies not one.

Exclusive Black Friday Sale!

Get over 40% off selected products, including prams, baby carriers, cloth nappies, sleeping bags and much more! 24 hours only, on May 6 - register now for your special code.

Cafe offers breastfeeding mums a free cup of tea

A Sydney cafe is offering breastfeeding mums free cups of tea in a bid to show support for the right of women to nurse their babies wherever they choose.

To snip or not to snip? When the decision is not clear cut

Jamie Oliver, who considered a vasectomy, is to be a father again. A fellow dad reflects on his own decision 11 years ago

Doctors stunned by rare twins born almost six weeks apart

To everyone's surprise, Kristen Miller "kept doing better each day", keeping her second baby safe.

Baby book ideas for modern parents

Before my son was born I was given a lovely baby book full of blank pages waiting to be filled with weights and heights and first words.

The adorable smile of a baby seeing his mum clearly for the first time

There is no doubt seeing their child smile for the first time is an unforgettable moment for parents everywhere.

Mum tells how toddler 'nearly hung himself' in cot mishap

When Alison Johnson put her 18-month-old Caleb down for a nap, she had no reason to believe her son was in any danger.

Babies are still switched at birth? Yes, it can happen

All my panic and tears aside, my biggest question looking back is about the kind of security measures used in the maternity ward.

Doctors slammed for taking selfie with newborn

Everyone who visits a mum in hospital in the days following childbirth wants to get a photo with the new baby.

ergoPouch Twosie Sleepsuit for winter breastfeeding

Finally, there's a way to keep warm while breastfeeding through winter.

Health check: How long does sex 'normally' last?

What to do with this information? My advice would be to try not to think about it during the throes of passion.

When breastfeeding sucks: fixing common problems

From niplash to tight boobs, biting to milk supply issues, Pinky McKay looks at common breastfeeding issues and how to solve them.

10 things I've learnt in my first six months with twins

Six months on we're all still alive, and the more we get to know each other the easier the days become.

Mum's loving kiss leaves baby fighting for life

Kirsty Carrington thought nothing of giving her newborn son a kiss, little did she know it would leave the baby fighting for life.

When doing chores is your new 'me time'

After children, 'me time' looks a little different.

Get going: 14 travel strollers for families on the move

A stroller can make or break travelling with a baby or toddler. Here are 15 great single travel stroller options.

10 ways toddlers are terrific

It always pays to remind yourself of how terrific toddlers can be - they're little like this for such a short time

 

ENTER NOW

Do your kids love bananas?

This is the comp for you! We have $800 worth of Myer gift cards and boxes of Australian Bananas to be won. Entry is simple: just post a pic of your little one enjoying a banana in the comments of the FB post to enter.

 
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.