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

 

Heartwarming prank gives single mum the house she was hired to clean

Cara Simmons arrived at work to clean a large and beautiful house in time for a party planned for that evening. It was soon hers.

Why we should stop telling new parents to 'enjoy every moment'

A few weeks ago, some dear friends of mine had their first baby. As the proud dad texted me a picture I had to fight the natural instinct to say “Enjoy every moment!”

Transgender dad breastfeeds his babies

A transgender man who breastfed his first baby - despite having his breasts removed as part of his transformation from female to male - has now had a second child.

Couple face $1 million medical bill and bankruptcy after babymoon birth

A Canadian couple were slammed with a million dollar medical bill after their daughter was prematurely during their babymoon.

Win one of 5 Little Tikes Cozy Coupe Sport

Australia?s No 1 selling car is now available in a Sports model and we have 5 to give away to some lucky Essential Baby families.

Cigarettes, junk food dominate supermarket sales growth

One in every five dollars spent at supermarkets goes on cigarettes or junk food, according to industry data.

Teacher under fire for breastfeeding in class

There is no doubt mums have a right to continue breastfeeding after they have returned to work, but one teacher in the US has taken it to the extreme.

Video: Baby sniffs beardless dad to make sure it's him

She looks him up and down and then touches his chin, but baby Lindsey still isn't sure this clean-shaven man is her dad.

The tragedy of losing a favourite teddy bear

We were green and uninitiated, perhaps a little naïve when it came to the favourite toy responsibility.

It's possible to workout while pregnant

Medical experts say intense fitness routines can be done safely during pregnancy - if the mums-to-be follow some guidelines.

Baby for Asher Keddie and Vincent Fantauzzo

Fans followed every step of her on-screen pregnancy in Offspring, now Asher Keddie is going to be a mum in real life too.

What parents really want for their kids

Are our hopes, dreams and expectations for our children what they really need?

'I had a feeling something was seriously wrong': the fight for Kaden's diagnosis

Before even giving birth, Katie Myers' maternal instincts warned her something was wrong with her baby.

When your pregnancy causes a relationship rift

Some dads-to-be don't miss a beat when their partner is pregnant; others struggle with a range of issues and can become withdrawn, right when their support is needed most.

Couple uses group photo trick to announce pregnancy to loved ones

Katharine and Kris Camilli devised a clever trick to immortalise their family and friends' reaction to their exciting pregnancy news.

Why Tracey Spicer has given up make-up

"After 30 years on television, I had become what I despised: a painted doll who spent an hour a day and close to $200 a week putting on a mask."

Empowering bikini photo of 46-year-old mum goes viral

When a group of teenagers made rude remarks about her body as she walked past them in a bikini at the local beach, Julie Cross refused to cover up.

Devastated widow discovers she's pregnant the day before husband's funeral

They had been trying to conceive a baby for seven years. Tragically Kristy Kirchner found out she was pregnant the day before her husband Royce's funeral.

Win a family pass to Disney Live!

We have 4 family passes to give away to see Disney Live! presents Three Classic Fairy Tales, touring Australia this December/January.

Gabriella Goat sues Peppa Pig

Every toddler's favourite television pig is being sued by an Italian woman who shares a name with a Peppa Pig character.

Meet the Mpregs, the male pregnancy enthusiasts

"Men can't have babies - that's something only women can do! But our community is full of like-minded people who wish otherwise."

Your new motherhood survival kit

Forget about the bright, pretty baby things - while you're in survival mode, all you'll need are the essentials.

More than 100,000 cars recalled globally after death of pregnant woman

The announcement of a mass recall comes as Malaysian police investigate the death of pregnant woman in July.

I had a 'good baby' but still suffered from postnatal depression

I had a much wanted precious baby girl, a 'good baby' who slept well, self settled and was mostly content. It just seemed implausible to think I could succumb to depression.

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

Win one of 5 Little Tikes Cozy Coupe Sport

Australia?s No 1 selling car is now available in a Sports model and we have 5 to give away to some lucky Essential Baby families.

Join PADDINGTON on the red carpet!

To celebrate the release of PADDINGTON, we are giving five lucky winners the chance to win a family pass to the exclusive Australian Premiere in Sydney on December 7!

Knowing you are one of the lucky ones

I am secure, confident and strong, but the responsibility of protecting my children can almost bring me undone.

Why I am so emotional now I have kids?

There are so many ways in which parenthood changes us as women, but one of the most noticeable, for me, has been the changing state of my emotions.

Baby survives despite sharing womb with 'foreign body'

Baby Maia was conceived against the odds, only to find she was sharing a womb with an ominous "foreign body".

Video: Baby shows dog how to jump - or vice versa

They say dog is man's best friend, but this playful pooch seems to have chosen a jumping baby as her number one buddy.

10 ways to soothe a crying baby

New paernts can get frustrated when their newborn gets fussy and can't settle down. When you're feeling overwhelmed, try some of these simple tips to help soothe your baby.

20 baby names that are becoming more popular every year

The data-lovers at nameberry.com have been at it again – this time, they’ve discovered the names that are continually rising up the ranks, ready to take out some top spots in the next few years.

10 great meals to make for new parents

Ideally, you want to give food that isn’t expensive to make, isn't too difficult to create, and freezes well; stews, bakes, soups and pasta sauces are perfect.

'It's not you, it's me': Boston bombing survivor mum to have leg amputated

Rebekah DiMartino is going through a break-up. She even wrote a farewell love letter. But it's not to her husband.

What it's like to go through early menopause

In a cruel twist, Carla had been breastfeeding and perimenopausal at the same time. But she's far from the only one to go through menopause early.

Restaurant served alcohol to two-year-old

Busy restaurants can be forgiven for getting food and drink orders mixed up from time to time, but not when the confusion leads to a two-year-old being served an alcoholic cocktail instead of the child-friendly beverage they ordered.

Julia Morris tells of miscarriage on a flight

Julia Morris has spoken about the devastation of suffering a miscarriage while on an international flight.

Woman's survival after birth 'a story of two miracles'

A US mother is home and tending to her new baby less than a month after surviving without a pulse for 45 minutes.

Eating ice may give mental boost to the iron deficient: study

A new study proposes that, like a strong cup of coffee, ice may give those with insufficient iron a much-needed mental boost.

Tiny lives in caring hands: Thank U NICU Day

Each year in Australia, over 40,000 newborns need the help of a special care nursery or neonatal intensive care unit. One day a year, the staff are honoured by the parents they help through those dark days.

I paid $50,000 to have a girl

This time my husband and I hadn't taken any chances. We had paid $50,000 and travelled 13,000 kilometres to make sure the baby growing inside me was female.

Weird pregnancy products

Some pregnancy products come to market and are just awesome. Others just leave you scratching your head.

Dear firstborn, I'm sorry

Being a first-time mum is tough for so many reasons – particularly because you really have no idea what you're doing.

A trace of sesame could kill my son

Helen Richardson son's had two anaphylactic reactions in a month. It's traumatic for everyone.

When you know before the test says yes

It wasn't a pregnancy test or missed period that told me I was pregnant with my second baby; it was too early for those things. A doner kebab told me I was going to be a mum again.

What not to do when your partner is in labour

Robbie Williams stole the show during his wife Ayda's labour, pretty much demonstrating everything on the "what not to do when your partner is in labour" list.

Best maternity swimwear and beach cover-ups

Thinking about a tropical babymoon but have nothing to wear? Here are some great swimwear and beach cover-up options for mums-to-be.

Dad breastfeeds his babies

Trevor Macdonald has now been pregnant twice, and is successfully breastfeeding his newest family member.

 

How many weeks til Christmas?

On your To-Do list

Get the "Santa" shopping done without the kids in tow.

 
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.