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.




3 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users


    Google (2)
 

Britain's youngest parents: mother 12, father 13

A 12-year-old schoolgirl and her 13-year-old boyfriend are believed to have become Britain?s youngest parents, after the birth of their baby girl earlier this week.

When Prince George met Bilby George

Prince George has met an Aussie marsupial named after him in his first official engagement in Australia.

Asphyxia link another piece of the SIDS puzzle

An Australian study has uncovered information which could lead to a better understanding of why babies die from Sudden Infant Death Syndrome.

Pregnant woman dies after doctor removes ovary instead of appendix

When a UK woman went to hospital suffering appendicitis, doctors mistakenly removed her healthy ovary - with tragic consequences.

The milestones I can't wait to celebrate

Nothing can beat the feeling of witnessing that first smile, first step and first word - but here's a list of 'firsts' I'm really looking forward to now.

How you develop in your baby's first year

Just as babies undergo rapid growth as they learn and change in their first year, we?re learning and changing quickly as parents, too. Don?t underestimate the developmental stages you go through when you have a baby.

Can you make your baby smarter even before birth?

A product new to Australia claims to help babies be born "as intelligent as possible", but not all experts agree on the benefits of educating babies while still in the womb.

How a mother's love helped unearth the skills of an autistic savant

Autistic savant Ping Lian Yeak, a prodigious artist who has had his work shown all over the world, couldn't have done it without the support and love of his proud mum.

Rescue dog Zoey and BFF Jasper star in adorable pics

Photographer, self-professed "crazy dog lady" and mum Grace Chon takes photos of rescue dog Zoey and her 10-month-old son Jasper together. The results are just too cute. See more on Instagram @thegracechon.

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.

A tiny heart: a baby?s death gives life to another

Simon Alexander Garcia lived only one brief hour. But somewhere, a little girl?s heart is beating today because of him.

Ear piercing: what age is best?

What is it that shapes our opinions on what?s an 'appropriate' age for our children to get their ears pierced? Parents share their views on how young is too young when it comes to piercing.

Why is childbirth still such a pain?

The options given to women to help them cope in labour have barely changed in years.

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

Ideas for recording baby milestones

Get the props, lights and camera ready to record the milestone moments in your baby's first months and years. Tip: set a reminder in your phone (or jot it in a calendar) to make sure you remember it every month.

From penis amputation to fatherhood

After a botched circumcision as a child, Mike Moore was left without a penis. Years later, and after meeting the right surgeon, he was able to become a dad - naturally.

Asphyxia link another piece of the SIDS puzzle

An Australian study has uncovered information which could lead to a better understanding of why babies die from Sudden Infant Death Syndrome.

Your baby's first shoes, made with your own hands

Imagine someone saying to you, "Your baby?s shoes are magnificent, where?d you get them?" And you reply, "Oh, these? I made them."

Mother bites off pit bull's ear to save toddler

What would you do if your child was being attacked by a vicious dog? One mother recently had to learn the hard way.

Couple dies 15 hours apart after 70 years of marriage

A couple who held hands at breakfast every morning even after 70 years of marriage have died 15 hours apart.

Behind the scenes of Kate and George's cuddly photo

Every face is partially obscured, but there's no denying the happiness and love in the faces of the royal mum and bub.

7 tips for a kid-free trip, not a guilt trip

Although I?m jumping out of my skin to take my child-free holiday, I?m dreading the goodbye. But I?m determined to make the most of it without tarnishing it with guilt or sadness about leaving the kids.

Your baby?s developmental roadmap

Caring for your new baby can feel like driving along a dark highway without a GPS: you know your destination ? a happy, healthy human being ? but you?re not sure whether you?re heading in the right direction.

Breaking out of the isolation of motherhood

There can be many reasons for mummy isolation ? and you don?t have to be a new mother to feel like you're often doing it all alone. Here, mums share their stories of feeling isolated, and what they do to try to break out of it.

The billionaire baby with $10,000 worth of prams

When money is no object you can go all out when it comes to baby transportation, as this billionaire socialite has shown.

Medication helps depressed mums to breastfeed

Breastfeeding mums are often told their medication may pass into their milk, but a new study suggests the benefits of taking antidepressants are greater than any risks to baby.

 

Free Printable Activities

Keeping little hands busy

Free printable acitivity pages like colouring in, cutting, word finders, mazes, maths activities and puzzles.

 
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.