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

 

The day my daughter almost drowned

We had six adults standing there, so I felt like I could relax a bit. After all, what could go wrong with so much supervision?

Sydney siege survivor names baby after victim Katrina Dawson

A Sydney barrister who survived the Lindt cafe siege has named her newborn daughter after her best friend who died in the tragedy.

Banishing bloat

How to avoid a bloated tummy

Here are some foods to eat in order to escape feeling ghastly and gassy.

The great new picture book for anxious kids

My son is a worrier by nature. I learnt long ago that it was completely pointless to say to him "Don't worry about it!".

Budget stripped more than $15b from families

The combined impact of the two budgets for low and middle income people was "devastating", new analysis by the Australian Council of Social Service shows.

Pregnant women urged to get flu shots

As the winter chill starts to arrive, NSW Health is urging pregnant women to get their flu shots.

65-year-old gives birth to quadruplets

A 65-year-old German woman, who already has 13 children, has given birth to quadruplets.

What you need to know about pregnancy and health insurance

It's not just waiting periods that couples need to consider - there are other factors to consider when thinking about health insurance.

Yummy mummy

Nicole Trunfio breastfeeds baby on Elle magazine cover

Australian model Nicole Trunfio has taken the concept of multitasking to a fashionable new level for Elle Australia.

Warnings after baby girl died while sleeping in bouncer

Parents have been warned about the dangers of letting babies sleep in bouncers and swings following the death of a three-month-old girl.

Coping with fatigue as a parent

Sleep deprivation is a real hazard of caring for a baby. But there are ways to manage the challenges of fatigue better.

A very 21st century issue: parents, parks and smart phones

It's not all the parents, and it's not all the time, but there is often at least one doing it. And sometimes, that 'one' is me.

Appliances

Faulty washing machines linked to house fires

More than 80,000 faulty Samsung washing machines pose a fire threat in homes throughout Australia despite a nationwide recall of the machines.

'I had a lotus birth and I loved it'

Lotus birthing is not all that common, but for a number of women it feels like the most natural thing to do.

7 things you might not know about postnatal depression

Despite its widespread nature, there is still a great amount of mystery surrounding PND - and it's important to try unravelling as much of that as we can.

Is your family's car part of the world's biggest safety recall?

More than 50 million vehicles recalled for potentially lethal airbag fault - is your car affected?

Why drinking water can be deadly for babies

H2O is one of the necessities of life, but for babies a seemingly harmless amount of water can be fatal.

Mother-in-law faceplants during proposal

He had it all planned: a romantic proposal on a windswept beach. The whole family would be there so they'd all be able to celebrate the joyous moment together.

A preschooler suddenly goes mute - and it's not just shyness

When our son stopped talking, our sense of loss was painful and acute.

The mums who ask for a 'wife bonus'

They run their homes like domestic CEOs and work tirelessly to improve their family's social standing. And now, according to a new book, they want an annual perk from their husbands.

Woman shares photo of dimple on breast to warn others of cancer risk

A widely-shared Facebook photograph of a British woman's breast has raised awareness of a more subtle breast cancer symptom.

Starting a family despite a low sperm count

"I'd never really failed a test - how could I fail this particularly manly test?"

It's official: we must better protect our kids from toxic lead exposure

New guidelines have been released, aimed at reducing children's harmful exposure to lead. But they still don't go far enough.

Trouble-shooting toddler social skills

Chances are your toddler's behaviour is all completely normal - but here's how to tackle some common social problems.

Helping your first-born welcome a sibling

We did sigh with joy at the arrival of a royal princess - but, mostly, we sighed with pity at the sight of Prince George being taken to meet her.

Farewell, daytime nap

I've been in denial and I'm not too proud to beg, but it appears I must accept the fact that you have gone. I need to let you go.

The identical triplets who are one in 50 million

The father of identical triplets born in a Texas hospital says his three daughters, including conjoined twins, are "a miracle" sent by God.

Seven questions you should be asking about your health cover

If the last time you assessed your health cover was five years ago, there?s a chance it may no longer suit your needs. To ensure it?s still right for your family, click here for seven questions to ask.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

How to use gas effectively in labour

Many women in labour don't use gas effectively and suffer more side effects than benefits. Here's how to get the most out of this pain relief option.

'He has gastro but that's okay, right?': sick kid etiquette

We cannot place all children who are sick in a bubble till they recover, but we can give other parents a choice about exposing their kids to them.

Welcome to Winter

Now that the colder months are here, Essential Baby as all the information you need for staying healthy and happy during the chilly season.

Ada Nicodemou: 'I can never be completely happy again'

Home and Away actress Ada Nicodemou has opened up about the loss of her stillborn baby.

10 things to consider when you're thinking about trying for a baby

Before you start tracking your menstrual cycle and reading up on the best positions to get pregnant, there are a few other things you may want to consider.

How special surgery and IVF can create a post-vasectomy baby

Cricket legend Glenn McGrath and his second wife Sara are expecting their first child together, thanks to IVF and a delicate surgical sperm retrieval process that helped the couple to conceive.

Belle Gibson's mother 'disgusted and embarrassed'

The mother of disgraced wellness blogger Belle Gibson has accused her daughter of lying about her childhood in an attempt to garner public sympathy.

Doctor's mobile phone 'left inside c-section mum'

A new mum claims a doctor left his mobile phone inside her after delivering her baby via caesarean section.

I'm a mum and I'm following my dreams

I want my kids to know that no matter what happens in life, you can still be who it is that you've always wanted to be.

Those first daycare days

I had this innate 'mum' moment the other day.

'If one person had listened, my life would have been so different'

Katherine's father will die in prison for the horrifying sexual abuse of his daughter. Yet she is the one with the true life sentence.

This new plan undermines breastfeeding and baby health at everyone's expense

Mothers, babies, the health system and the wider society are going to pay the price of this new budget.

Couple to celebrate terminally ill baby's birthday in unique way

Baby Jai Bishop has lived at Starship Hospital for the past seven months, with his parents flying back and forth from Hokitika, 1100km away, to be by his side.

Life On Mars

It's men who need 'retraining', not women

We are all responsible for our own behaviour. Telling victims to harden up is wrong.

Baby Gammy's dad tries to claim charity money

The biological father of baby Gammy has reportedly tried to access charity money raised for the little boy's medical costs.

Where are the childcare places?

It?s all very well to encourage women to work if they choose to, but how can the measures lead to increased workforce participation when women are once again left holding the baby?

The pain of not having babies and not knowing why

After seven years of wishing, hoping, crying, punching pillows and shouting "why me?!", the end result is more than I ever thought possible.

Getting your family finances in order

Whether you're after a new car for a growing family, a bigger house, or are just fixing up your finances, here are the basics on borrowing.

Mum shares graphic selfie to warn against tanning

A mum has shared a graphic photo of her skin cancer treatment as a warning to others.

Does parenthood make us happier?

We can certainly gain higher levels of happiness when we become parents, but the trick is to not get overwhelmed by the pressures of raising our kids.

No, having a dog is not like having a human child

It's obvious these people dote on their pets, but they're barking up the wrong tree.

 

Top baby names

Baby Names

The numbers are in and we can now bring you the 2014 top baby name list for Australia.

 
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.