Budgeting

Budgeting

Budgeting. That thing you have to do as an adult so you don’t get half way through your pay period and not know what you’re going to eat until you get paid next. Below are my tips on how to make your money last longer!

 

1. First, figure out how much money you actually have to work with after tax and how much this is per week.


 

2. Split that income up into sections.

  • 20% of it go into a separate bank account for savings in case of emergency
  • 10% to charity to help others
  • 20% for things I want such as entertainment, phone bill, clothes and holidays
  • 50% to needs, this includes food, car maintenance, medicine, fuel, rent, and utilities.

This can be done in an excel spreadsheet like so (just an example).

Capture

I got the number next to savings by entering ‘=cell with total amount earned*0.2′
You would replace the italics with your respective cell and 0.2 with the percentage you want it to be. 0.2 = 20%, 0.5 = 50% ect.


 

3. If you would like, you can split this up again into specific parts/accounts. I split my needs and wants up again into the specific things I would spend that money on. Because I have a specific amount I need every week for medicine I put that amount into the cell and then split food and fuel 50%. Next to food the cell had entered ‘=(cell with money for needscell with money for medicine)*0.5′. Make sure that you have the brackets as your calculations will be incorrect. I also did the same for clothes and entertainment as my phone bill is the same every week.

Capture2.PNG


 

4. Every week, enter in how much you have earned and transfer the respective amounts to separate bank accounts, separate cash in envelopes or write the numbers down!

 

I hope you enjoyed the tutorial I have provided you with if you have any comments or queries please comment below. Thanks!

signature_ry87xlg1ahwi70szvr

School Bag Organisation Tips

School Bag Organisation Tips

Hey!

You don’t have to spend half your life rummaging through your bag to find something, follow my school bag organisation tips!

 

1. Start with a bag that is comfy, has lots of pockets, adjustable straps and any specifics you need such as an insulated pocket or drink bottle holder. This may sound like hard work but I am very specific about what I want in a school bag and it has paid off, my school bags usually last at least a couple of years of love!


 

2. Keep only the necessities or the once weeklies.
If you are unlikely to use it at least once a week, don’t carry it around, obviously things such as panadol can be excluded in this rule but this is your own call.


 

3. Utilise sewing boxes. I love to keep my hairbands, panadol, cough lollies, bobby pins etc. all organised in a little sewing box. I have multiple of these and each are different with their own dividers.


 

4. Separate everything into specific parts of the bag. School work, food, medicine, phone/wallet that kind of thing. Give everything an area or place in the bag so that you can have a better idea of where to look for something. This can be done by using little bags, pockets or even just pieces of laminated paper.


 

5. To maintain this organised bag, pick one day in the week in which to clean it out! Going through and cleaning your school bag once a week will stop things such as mouldy sandwiches and lost permission notes.

 

Enjoy and please comment below with any feedback/comments you may have! 🙂

signature_ry87xlg1ahwi70szvr

How to Create a Store Specific Grocery List

How to Create a Store Specific Grocery List

agIn this tutorial I will teach you how to make a store specific grocery list in Google Sheets (Microsoft Excel can also be used) so that all of the items in the same aisles are together!

No more running from one side of the store to the other again!

 

1. Create a new document and make columns with the product e.g. fruit, room for type specifications  e.g.apple’s, brand specifications e.g. granny smith, aisle number and a column for how many of that item you would like [for later]!

 


 

2. Go through your regular grocery store and write down all of the general items in each aisle (this can also be found through using their online shop sometimes or getting a shop map). To make sure that you don’t confuse the computer, give aisles that don’t have a number the number 0 if they are the first that you see when you enter the store like so…

grocery list 1.JPG

 


 

3. Sort the list by Aisle number by selecting the whole list, clicking ‘data’ at the top and then ‘sort range’. Check the box ‘data has a header row’ and then click the drop down menu and select ‘Aisle Number’ and ‘A -> Z’ so that it sorts the list from zero to 10 by aisle number.

grocery list 2.JPG

 


 

4. Now, we want to delete the items that you want none of so select the table and then click ‘data’ and then ‘filter’ and your spgrocery list 3readsheet should look like this!

 

 


 

If you click the little arrow next to the ‘number of items’ column, filter by values and uncheck zero and then click okay the items that you don’t want anything of will all magically disappear! (You can also instead click ‘filter by condition and then ‘greater than’ and type in zero it will do the same thing!)

There you go! If you print the document and make sure you also bring a clipboard and pen to the grocery store you will be in and out in a jiffy!

To download this sample click the link at the end of this sentence. Grocery List

Enjoy and please comment below with any suggestions or questions! 🙂

For a bit of fun you can also click the explore button on the bottom right on the spreadsheet and it can tell you how many different things you need to get from each aisle and how many of each kind of product you are buying!

For more posts like this please click here!

signature_ry87xlg1ahwi70szvr