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

 

How I learnt to relax about routines

After many routine-led, tough years, we've realised that being parenting isn't about being perfect. It isn't about following a schedule to a T.

Should you have a third child or not?

I thought our family had been complete with our two boys. I had no idea how much I needed my daughter until she was here.

Helping a toddler embrace an adopted sibling

A single parent by choice, I am preparing to adopt a second baby from Morocco. And I face a special challenge.

When pregnancy messes with your self-esteem

Pregnancy doesn't make all women feel beautiful. It certainly doesn't raise every woman's self-esteem.

Join us in The BIG nappy change

Introducing the new Coles Little Explorer Nappies! You can confidently rely on Coles Little Explorer nappies at each stage of your child's growth, so take the Big Nappy Change and try new Coles Little Explorer nappies for yourself!

Robbie Williams live tweets wife's labour

And the award for most patient woman in labour goes to ... Robbie Williams' wife, Ayda Field.

Vaccine ignorance is deadly and contagious

In the absence of credible, strong political leadership, paranoia about disease can go viral.

Parenting differently based on birth order

All children have unique personalities, but keeping birth order in mind could help when parenting.

How to get rid of the mum guilt

Motherhood and guilt seem to go hand in hand, but there are ways to focus

Paid parental leave scheme grinds to a halt

The future of Prime Minister Tony Abbott's paid parental leave scheme appears to be up in the air, despite the fact it is due to begin in less than nine months.

The devastation of foetal alcohol spectrum disorders

No one's sure how many Australians are affected by foetal alcohol spectrum disorders, but the consequences for those who are can be devastating.

The pros and cons of finding out the sex of your unborn baby

It’s often one of the biggest choices parents make during the course of their pregnancy; to find out, or not to find out, the sex of their baby before it’s born.

Toddler's awesome dress up month

Two-year-old Willow and her photographer mum, Gina Lee, made October "Dress Up Willow Month". She posted photos of Willow's costumes on her Instagram account, and her creative takes on popular culture are simply adorable.

Childhood around the world

It can be easy to assume our ideas around childhood are universal, but they are particular to where we live, as these practices show.

Best picks for baby and toddler shoes

Here's a great selection of footwear from pre-walker to walker ensuring comfort and style for growing feet.

I lost my wife and daughters to Ebola - then it came for my son

Sunday, September 21, is a day I will never forget.

The 'yucky' illness that took over my life

I have a chronic illness nobody likes to discuss. It involves toilet talk, and probably caused my miscarriage. But it needs to be talked about.

Prenatal testing: the facts

Prenatal testing is done to check if a baby has certain medical conditions before birth. Here is some important information about what the tests are for and the risks involved.

5 things to do with your baby?s old clothes

Did you think your only option for your baby?s old clothes was to pack them away or give them to the Salvos? Think again.

Why it's possible to not realise you're pregnant until the baby arrives

After hearing about 'surprise babies' born to mums who didn't know they were pregnant, it's common to ask "how did she not realise?" But experts say it's entirely possible for it to happen.

'My miracle is finally here'

How has the world continued on its pace when mine has been altered so drastically?

Dairy can help older women fall pregnant: study

Ice cream may be the ultimate comfort food, but a study suggests it could also help older women to have children.

Megan Gale goes topless for 'sexiest people' cover

Six months after a heavily pregnant Megan Gale posed nude for Marie Claire, the glowing new mum has gone topless for the cover of another magazine.

A new perspective on life from living with two diseases

A mother shares her personal story about the difficulty of living with two conditions, one of which stops her from being able to see her daughter's face.

Warning about Children's Panadol dosage

The Therapeutic Goods Administration has issued a safety advisory warning parents about confusion when using the dosing syringe supplied with Children's Panadol.

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

Take 'The Coles Big Nappy Change' Challenge

You could become part of our Test Drive team and win one of 200 packs of Coles Little Explorer Nappies as part of our 5-day challenge.

Win 1 of 5 Canon Powershot D30 cameras

Capture life more easily with the Canon Powershot D30. Shockproof, waterproof and dustproof, you can take it almost anywhere and shoot beautiful images, time after time. Enter now!

16 parenting truths you won't find in the baby books

I am five years into this parenting gig and I’ve learnt that sleepless nights and changing dirty nappies are child’s play.

Best and worst potty party cakes

It's nice to celebrate a child making the shift from nappies to 'big kid' undies, but do we really need a semi-realistic used toilet cake to do it? Here are some of the best and worst cakes parents have used at 'potty parties' around the world.

7 tips for a financially festive Christmas

Plan ahead - and do it now - to ensure festive season expenses don't break the bank.

'Go the F*** to Sleep' author's new book for frustrated parents

A sequel is coming soon to the 2011 hit book 'Go the F*** to Sleep' - and this time, it's about mealtimes.

Great birthday party buys from Etsy

Handmade crafts to decorate and personalise your child's next birthday - from banners to cake decorations, we've got gorgeous party finds from Etsy.

Join us in The BIG nappy change

Introducing the new Coles Little Explorer Nappies! You can confidently rely on Coles Little Explorer nappies at each stage of your child's growth, so take the Big Nappy Change and try new Coles Little Explorer nappies for yourself!

Creative storage ideas for the kids' rooms

Creative and practical storage ideas for the kids' toys and books can also add some stylish decor to your home. Visit babyology.com.au for more stylish modern finds for hip kids & parents.

Weird trend

Couple has five babies in 14 months

Julie and David Grygla weren't sure they'd ever have kids - but their dreams have now well and truly come true.

To the mum in the doctor's waiting room

Maybe the mum I saw in that waiting room, seemingly disconnected from her baby, doesn’t have the support she needs.

10 space-saving nursery ideas

Starting a family doesn't always mean moving into a bigger house - not yet, anyway.

 

What's in a name?

Baby Names

Looking for a classic name, or an unusual name? Our Baby Name Finder is for you, search or browse to refine your shortlist.

 
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.