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

 

WIN a $500 Visa debit card

Are you a parent? Simply take our survey for your chance to win a $500 pre-paid VISA debit card.

Breastfeeding doesn't make you a better mum - feeding your baby does

Given my immense dislike of Hopkins and her opinions, I was genuinely shocked to discover that last week she actually said something that I agreed with.

'Toni, another baby has died': the anguish of watching governments fail our babies

It has been six years since whooping cough claimed the life of four-week-old Dana McCaffery. Her parents are angry that lessons learnt weren't enough to save other babies.

Longer breastfeeding linked to higher IQ

A study of 3500 infants has found that babies who are breastfed grow up to be more intelligent and wealthy.

The 2015 flu vaccine: what's new, who should get it

For certain members of the community, catching flu can lead to severe illness or death. A vaccination can be lifesaving.

Dealing with a nappy escape artist

I hear about the tots that have a penchant for ripping their nappies off and the odd one that even smears the brown stuff on the walls and fine home furnishings, and I shudder.

Hospital apologises for 'traumatising' baby mix-up

St Vincent's Hospital has apologised "unreservedly" for a baby mix-up that left one new mum traumatised.

Tips for flying with a baby

Travelling with kids requires a whole other set of skills - ones that I have learned through (sometimes unfortunate) trial and error.

How to stay calm in an emergency

I’m not expecting you to be as calm as you might be right now. What I mean is that if your panic levels are through the roof during a stressful situation, let’s bring them down to just under the ceiling.

Toddler gets 'drunk' after cranberry juice mix-up

A toddler was taken to hospital after a waitress served her sangria instead of cranberry juice at a US restaurant.

We need to stop using this word when we talk about childbirth

Is it shaming to point out that women are often being let down in birth?

The certificate helping parents deal with pregnancy loss

For some people, this certificate will offer a sense of validation that their child was acknowledged as being here and now gone, and will help them with life post-loss.

Grieving families give warnings after toddler deaths

Two Queensland families are grieving the loss of their toddler sons after the boys drowned in separate incidents last week.

The phenomenon of phantom pregnancy kicks

'Phantom pregnancy kicks’ are encountered by many mums months - or even years - after their pregnancy is over.

The health insurance advice you can't afford to ignore

There's one simple switch that could save you hundreds of dollars a year in private health insurance.

4D scans show how smoking affects babies still in the womb

The harmful effects of smoking during pregnancy on unborn babies may be seen in tiny movements in their faces using 4D ultrasound scans, research has found.

How to babyproof your job interview

Once upon a time, I was a fan of job interviews. That all changed after I'd switched careers, had a baby and decided to spend the first year at home with her.

Sign up to our 30 days of #PlayIQ challenge

Sign up to receive 30 amazing tips and ideas for play with baby during the month of April and submit a picture or tip on our social wall for a chance to win an amazing Fisher-Price prize pack.

The most dangerous toddler food trends

Pete Evans' paleo cookbook for kids caused a storm, but there are plenty of other unsafe food trends for babies and toddlers.

Infection killed new mum of twins

Modern medicine could not save 19-year-old Sophie Burgess who died 48 hours after giving birth to twins in the UK.

Win a Ben & Holly's Little Kingdom prize pack

To celebrate the April 1 release of Holly's Magic Wand on DVD and Digital, we are giving away five DVD packs featuring the newest installment of Ben & Holly's Little Kingdom Holly's Magic Wand and many more hours of family entertainment! Enter Now!

Special Ticket Offer, Save $8!

The Essential Baby & Toddler Show is back this April! Save $8 off the door price for a limited time only!

 
Advertisement
 
Advertisement
 
 
 

What's hot on EB

Sign up to our 30 days of #PlayIQ challenge

Sign up to receive 30 amazing tips and ideas for play with baby during the month of April and submit a picture or tip on our social wall for a chance to win an amazing Fisher-Price prize pack.

Man faces jail after giving woman abortion pill smoothie

A Norwegian man is facing jail after putting abortion pills in his ex-girlfriend's smoothie, causing her to have a miscarriage.

'He's a blessing': family of baby born without eyes

Jordy Jackson was born without eyes. He has anophthalmia, which affects one in every 100,000 babies born.

Win one of 5 Cadbury Easter Hampers

With Easter fast approaching, Cadbury are giving away 5 Cadbury Easter Hampers. Enter Now!

Super fit model Sarah Stage defends her pregnancy body

Model Sarah Stage has defended her pregnancy body after critics claimed her slim figure at eight-and-a-half months pregnant wasn't "normal".

Win a Ben & Holly's Little Kingdom and Peppa Pig prize pack

To celebrate the April 1 release of Holly's Magic Wand on DVD and Digital, Essential Baby and Entertainment One are giving away five bumper DVD packs featuring the newest installment of Ben & Holly's Little Kingdom Holly's Magic Wand and many more hours of family entertainment! Enter Now!

Why I post breastfeeding photos online

I love to take pictures of my children. In some of the pictures, my younger son is nursing.

The day I broke my baby

There are things I wish I didn't know. I wish I didn't know that companies make tiny braces, small enough to hold necks no bigger than a wrist.

The place just for dads of multiples

When a couple discovers they're expecting multiples, the dad can sometimes be almost forgotten in all the excitement and preparation. But one group offers a space just for dads of twins and higher-order multiples.

Brave mum calls for domestic violence law reform

A brave mum of two has shared details of the harrowing attacks she suffered at the hands of her partner in a bid to help other victims of domestic violence.

Why I had the new test for Down syndrome

Early last year I turned 35, and having just found out I was pregnant, I opted to have the new test for Down syndrome.

Geeky baby gear

If your family is more into Star Wars, gaming and the periodic table than most, you might want to check out these geek-chic baby items.

2015: the year of the sheep

According to the Chinese zodiac, babies born in the year of the sheep are creative and enjoy spending quiet time with their own thoughts.

Breakthrough genetic testing now available in Australia

Pregnant women will for the first time have access to locally analysed, accurate, non-invasive pre-natal genetic testing when the first Australian clinic to offer the services opens its doors next week.

Grandbabies: the babies born looking old

Not a day under 65 and a lifetime of struggle! That's the look of these newborns, who look adorably older than their real age. Social networking site Reddit recently featured user submissions of adorable grandbabies, here are our favourites.

Family kicked off flight after toddler seatbelt drama

An entire family was kicked off a Cathay Pacific flight when a misbehaving toddler refused to put his seatbelt on.

Stolen baby found after 17 years

A baby stolen from her mother's arms shortly after birth has been found through an astonishing coincidence.

53 creative pregnancy announcements

Announcing that you're expecting can be a time to express your creativity, sense of humour and imagination. Check out how other parents and parents-to-be have broken the news to friends and family.

IKEA hacks for the nursery and kids' rooms

Are you one of those that know the whole IKEA catalogue by heart? Love their stuff but want to personalise it? Here's some inspiration to help you realise the potential of IKEA furniture and fittings.

36 baby names inspired by food and drinks

A French court may have ruled out Nutella as a baby name, but that doesn't have to stop you from taking inspiration from the supermarket (or bottle shop). See what parents in the US have chosen for their delicious little ones.

Clever breastfeeding products

Check out this range of products designed to help make your breastfeeding journey more enjoyable, manageable and convenient.

 

Sign up now!

30 days of #PlayIQ challenge

Receive a daily email from Essential Baby during April with great play tips and ideas, then submit your baby at play photos to our Playwall, Instagram or Twitter for your chance to win.

 
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.