Budget Planner Spreadsheet for Google Sheets

Welcome to the demo video of our budget planner spreadsheet for Google Sheets!
UPDATE: This spreadsheet has been updated, find the latest version of this spreadsheet on Etsy:
etsy.com/listing/1473595073/
The new demo video can be found here:
• Simple Budget Spreadsh...
Start budgeting with our easiest budget planner for Google Sheets yet! This 1 tab budget is the budget for beginners and those who want to start taking control of their finances. Start budgeting with 3 easy steps, budgeting has never been so easy! No matter if you want to budget by paycheck, budget monthly, weekly or even biweekly with this spreadsheet you can do it all.
FEATURES
• customise your categories
• budget by paycheck
• budget by week, biweekly or monthly
• cash flow overview
• expense tracker
• expense breakdown
• cash flow overview
• left to budget graph
• left to spent graph
• spending breakdown
• checkboxes to mark off paid bills
• example budget included
• budget vs actual graph
• add a start balance
QUESTIONS
If you have any questions about this spreadsheet be sure to reach out to us on Etsy:
www.etsy.com/shop/hayeameri
ABOUT ME
My name is Odette, I have a background in Economics and spent most of my time creating new Google Sheets spreadsheets for my Etsy shop: Haye Ameri. I try to design spreadsheets that are functional but minimalistic and aesthetically pleasing in design that will hopefully not only make keeping track of your business or personal finances a bit easier, but also more fun!
All of our spreadsheets are created for you, by you! After a year of selling spreadsheets on Etsy we decided to completely redesign our line, listening to everything our customers had asked for to create the ultimate line of personal finance and small business spreadsheets!
© Haye Creatives // © Haye Ameri

[@DebbyHerold]

I love your budget spreadsheet. It’s the best I’ve seen from most of them out there. The one thing it is missing and I’d love to see added is a column in the Spending category that shows how much is left to spend for each category. It’s great to see what has been spent but it would be better to see what is left. Then this spreadsheet would be 100% perfect!

[@HayeCreatives]

Hi Debby! I am glad to hear you like the spreadsheet, and I will be sure to add that to our idea list for future updates!

[@Bisola_Adekoya]

A zero Based Budget would be even better

[@kbanghart]

​@@HayeCreatives​ hi, hoping I might get a response from this question. I get paid every week so I'm looking for an app or excel formula that will look at all my income and the dates I get paid, then look at all my bills per month and plot out where to pay them during the month (example.. I have $100, bill is $120, so then it automatically figures out how to spread that out). Do you offer an app or something that will do this for me?

[@jonathanhadinger7453]

@@kbanghart hi! I recommend saving up a small amount so you're not living paycheck to paycheck. Solves this problem immediately! If you're budgeting already, and can save even 1-2 thousand dollars, keep that in the same account your paychecks are sent to. Then you just spend less than you make and pay bills before they're due.

[@Thereallisadee]

Just purchased! I love hoe simple this is but captures everything!

[@HayeCreatives]

Glad you like it!

[@user-gd4zu2qi4j]

Thank you so much! I have ADHD and I'm about to live together with my boyfriend. I was panicking about how we would afford rent, pay bills and still have some money to spend on fun stuff, and seeing it all in a template really eased my worries

[@HayeCreatives]

Hi! So glad to hear you like it, if you have any questions about the spreadsheet be sure to reach out to us on Etsy!

[@BurrProductions16]

Just purchased this, thanks for the tutorial! I am so excited to get this started!

[@HayeCreatives]

Hope you enjoy it!

[@dancerbabe02]

Wow, Wow, Wow!! I was spending hours trying to get charts to update on Excel. Thank you for this!

[@HayeCreatives]

Glad it was helpful!

[@Tupsx57]

Simple. Beautiful. Thank you very much for sharing this.

[@HayeCreatives]

Glad you like it!

[@vanessaisso1839]

Love this template - just purchased it! Thank you so much

[@HayeCreatives]

Glad you like it!

[@jupywood]

Just purchased! Wish me luck first-time using Google sheets and a budget planner 😅

[@HayeCreatives]

I hope you will like it!

[@nguyenthimyduyen3845]

I have to thank god to know such a wonderful budget planner maker like you. I'm so sad when I can't even afford to own one as it's so helpful to me for life. I wish you can share it in some ways to me. 😭😭😭😭

[@HayeCreatives]

Hi! You can find our full range of spreadsheets on our Etsy store. We have a full range of spreadsheets available with prices starting at ±$3.

[@sharmanic4130]

Just purchased! Thank you :)

[@HayeCreatives]

Hope you like it!

[@rudydantas8804]

Great tool! I just purchased and added all the data - super easy! Can you, after inputting the Bills and Debts, organize them by date automatically? Thanks

[@HayeCreatives]

Hi! Unfortunately there is no easy option to put them in order. It might be easier to duplicate the template and then one by one readd them in order, sorry about that!

[@HayeCreatives]

Hi! We have now made it possible to sort your bills and debts in order! We have updated the template which you can access by clicking on the link in the file you originally downloaded. You will find a new instruction video linked on the read me tab where we show in detail how to do this!

[@vanesabotella7084]

muchas gracias super util gracias!

[@HayeCreatives]

Thanks!

[@zephyr2841]

Hi! I bought this one. I really like it, but I want to use it in as a yearly budget planner. What changes would you suggest?

[@HayeCreatives]

Hi! You could duplicate the tab 12 times to create monthly overviews. Unfortunately we do not have any add ons that are compatible with this spreadsheet to create an annual overview, but we have other spreadsheets available that do have this compatibility if you want to check these out! If you do, send us a message on Etsy so we can have a look together and what you are looking for in a spreadsheet so we can be sure we send you the right links.

[@aby_creativejourney]

Hi! I'm new to your channel but your spreadsheets look pretty and easy to use! I would like to know if you have a spreadsheet that you can suggest me to keep track of my income and expenses from my business. Thanks! This is my first year doing some budgeting !

[@HayeCreatives]

Hi! We have an income and expense tracker: www.etsy.com/listing/1473598061/income-and-expense-tracker-spreadsheet?click_key=003b9165cc4c53d1bb8a900c5f32af6f59ddb3f8%3A1473598061&click_sum=012343d9&ref=shop_home_active_12&pro=1&sts=1 That one is quite popular, we also have a bookkeeping spreadsheet if you want to keep track of VAT/Sales Tax collected and paid! You can also send me a message on Etsy and we can have a look together at what would best suit your needs.

[@louiefuentes567]

I love your sheet. I don’t have the budget yet to purchase this but I am trying to recreate your sheet but I am not sure how you did the charts as it won’t automate just like yours. Did you do pivot on this one? I hope you can maybe explain how you did this please?

[@HayeCreatives]

Hi! Glad to hear you like it! None of our charts are made with pivots, they are created with formulas.

[@louiefuentes567]

@@HayeCreatives Thank you. I would really appreciate if you can maybe share how you did the charts and the formulas. Early christmas gift :)

[@HayeCreatives]

Hi! Unfortunately we do not do any Google Sheets tutorials, sorry about that!

[@micahtherese4031]

hello! will changing the color of the different headers and such mess up the formulas?

[@HayeCreatives]

It will not! You can change these to whatever colour you like.

[@user-wv5hi6kz1d]

Hi, great template! Can I edit the categories/subcategories titles in this template or it is offered in only the Monthly planner + Spreadsheet?

[@HayeCreatives]

Hi! You cannot edit the categories but you can edit the subcategories in both this template and the monthly budget +!

[@user-wv5hi6kz1d]

@@HayeCreatives As in I cannot edit the Bill and Expenses as they are main categories. But I can remove grocery and write/create new subcategory of stationary instead? Right?

[@HayeCreatives]

Exactly. So bills, expenses, savings, income and debt cannot be changed but all the subcategories can!

[@qariaa.3887]

Hi, I loved the Budget planner and plan to purchase as well. But I'm confused what is difference betwern Budget and Actual? What are we supposed to write in Actual field? Also, Is currency option avaiable in PKR?

[@HayeCreatives]

Hi! It works with any currency, you just replace the dollar sign on the top left with your currency sign or abbreviation. And budget is for those who want to plan their budget, so plan ahead where they want to spend their money. Then in the actual fields you keep track of when you have actually spend the money. So in there you write the actual amounts!

[@enni9659]

Hi! My ‘left to budget’ does not have the amount in numbers, only the purple circle. What do i do?

[@HayeCreatives]

Hi! On the Google Sheets app the backgrounds are white instead of transparent so the number is not visible. Unfortunately the app is a lot more limited in design and function. The number is still visible in the cash flow overview on the left!

[@dadraduffus1108]

Hi I just bought mines and it looks so pretty but how do I add extra columns to the ones that already exist

[@HayeCreatives]

Hi! Glad to hear you like it! We would not recommend adding or deleting columns as it could alter the function of the spreadsheet. However, if you have any questions be sure to send us a message on Etsy so we can have a look together.

[@user-ct4dx4xd8q]

I purchased this today. So I can only access this through the web?

[@HayeCreatives]

Either through a web browser or the Google Sheets app!

[@ginnupdotcom]

Immediately sold and this video link sent to 4 homies. THANK you for this intentional tool!

[@HayeCreatives]

I hope you will like it!

[@sanaulla_h9635]

Can you please tell us the formula when we set currency and how it's changed in other cells

[@jefne]

HI! My Expense tracker doesn't have any categories, so it isn't connected to the Expenses above. How do i connect them?

[@HayeCreatives]

Hi! When you add expense categories up top (under the orange expense header) the dropdown will automatically update will all your expense categories!

[@ames005.]

can you do a tutorial on how to upload excel onto etsy so people can create a copy?

[@HayeCreatives]

Hi! We only offer Google Sheets spreadsheets, we do not offer any Excel spreadsheets, sorry about that!

[@eladngujede6634]

Hello awesome how can i do a chart comparism so i can see how i did X month vs Y month and say at the end of the year . Is there a way to do that . Cheers

[@HayeCreatives]

Hi! There is a new version included that has the option for an annual tab add-on so you can see a month by month breakdown. This will be linked on the NEW! tab!

[@laraspratiwi5499]

can you tell me in details what is the breakdown chart is? i don't get it :( thank you

[@HayeCreatives]

Hi! The breakdown chart shows where your income went so how much went to savings, debt, bills and expenses! There is also a spending breakdown where you can see exactly where your money went with a breakdown of all subcategories!

[@melonpeaches9306]

hello! just a question on the left side the income tab something, what if there's more that I want to insert in income but the sheet has only 5 how do you add that?

[@HayeCreatives]

Hi! There is a version included on the most up to date version that has 10 spots!

[@sapalicio_ehla]

Can you please make a tutorial for left to budget chart?

[@HayeCreatives]

Hi! We unfortunately do not do any Google Sheets tutorials!

[@RileyOutside]

Is there any way to sync this to a google form for quick-adding spent items?

[@HayeCreatives]

Unfortunately not but I will add this as feedback to our idea list!

[@sheilagonzalez7096]

Hi, I added my expenses + income but it’s not showing me how much I have left to budget, throughout me working on it the charts never changed. Could I get some help please¿

[@HayeCreatives]

Hi Sheila! Could you send us a message on Etsy so we can have a better look at your budget together?

[@harshyadav4697]

Hey I just wanted to will I have to duplicate tab for each month.

[@HayeCreatives]

We do recommend this to start with a empty expense tracker each month. This way you will not have to delete anything :)

[@alyssamojica4421]

Hello! I purchased your tracker. Why I can’t open it on the google sheet app / excel app using ipad 😢

[@HayeCreatives]

Hi! It should work without issue. Can you send us a message on Etsy so I can help you further?

[@MrKoobear]

Mine doesn't work at Mobile Phone. I can't see any graphics and spreadsheets. Guess it's only for PC or Laptop. I updated things on my laptop. Then, few hours later to update on my mobile, graphs, charts and data were all gone.

[@HayeCreatives]

Hi! The Google Sheets app is more limited in design. All graphs and info work but it hides numbers (such as left to spend) as the backgrounds are made white instead of transparent, sorry about that!

[@darrinleeedwards9]

So, to create the next month... Do I save and copy the original to start from again?

[@HayeCreatives]

Hi! You can duplicate the budget tab. There is a new video linked on the read me tab where we show how to do this :)

[@darrinleeedwards9]

@HayeCreatives thank you. I love the product and have had a few friends purchase as well. I have another question. At times I am not able to make changes to the (actual) categories. It shoes the code instead?

[@HayeCreatives]

That is very kind of you! The actual subcategories have formulas in them that load the totals for you so we do not recommend changing those! If you enter the transactions in the log below the totals are calculated for you by these formulas :)

[@mohammedaslam8092]

Hi, it's Not Available I am Trying to buy, Is there any another way to purchase..?

[@HayeCreatives]

Hi! It is now available on our second store: www.etsy.com/ca/listing/1473595073/

[@anvisionerandcreator8462]

Hi there, been multiple times to check out , but they didnt receive my card. Can yoi help me? Add another alternative of payment gateaway that i should pay?

[@HayeCreatives]

Hi! Can you send us a message on Etsy? Unfortunately the payment options are set by Etsy and we cannot add any other payment options. Sorry about that!

[@sukornsinging]

Hi, how can I change the month without messing up the formula?

[@HayeCreatives]

Hi! On the top left in the orange overview section, right next to start date and end date you can change the dates! It will update the month on the top automatically.

[@smritideepa]

How to make these boxes?

[@user-sl9bc8yq4u]

what is the difference between expenses and the expenses tracker below?

[@HayeCreatives]

The expense tracker that is below is for individual transactions, the expenses section up top shows the total!

[@JuliaSchmidt-kb4wl]

How can I enter the categories for the expense tracker? It doesn´t work

[@HayeCreatives]

Hi! You can enter them in the orange "expenses" section up top, when you enter your subcategories there the dropdown will automatically update!

[@JuliaSchmidt-kb4wl]

@@HayeCreatives Amazing that worked, thank you so much

[@user-dg6bm7qc9m]

How do you change the date on the budget sheet

[@HayeCreatives]

You can adjust this on the top left! Double click on the field and a calendar will pop up where you can select the date.

[@user-ks2lh7gf3s]

The etsy link is not working on mine. kindly assist

[@HayeCreatives]

Try this link: www.etsy.com/listing/1473595073/

[@angelinaoosterhof8300]

I purchased this and went to download and nothing occurred it just asked to me sign in to account again and when I did that purchase was nowhere to be found. Didn’t get an email receipt. No indication that I made a purchase other than my account being charged. Not sure if this is a scam or what but not cool.

[@HayeCreatives]

Hi! Can you please send me a message on Etsy so I can see what happened? You should have been able to download this instantly, not sure why it did not show up in your account. You can contact us here: www.etsy.com/shop/hayeameri

[@michivanbelle591]

How do you the doughnut chart? I tried but I don’t know how to get all the different columns into the chart 😔

[@HayeCreatives]

Hi Michi! Do you mean in this template or in Google Sheets? In this template all charts shown are preset and will update automatically when you start adding info!

[@michivanbelle591]

@@HayeCreatives yes I meant in this sheet, how do you get it all the different columns to be in the chart.

[@HayeCreatives]

Once you start adding actuals it will update automatically! If it is still not working send us a message on www.etsy.com/shop/hayeameri so we can have a better look together to see what is happening!

[@user-yj4ql2pf1n]

Do you support different currency like korean won?

[@summeredmo2734]

It won't automatically add the amount to the expense column. how do I fix this?

[@HayeCreatives]

Hi! It could be that the formula was deleted! Send us a message on Etsy so we can help to resolve your issue. Be sure to also check the following: * Are you using it in Google Sheets? The spreadsheet will not work in Excel * Was the amount added as 10.00 and not 10,00? Google Sheets cannot read the latter. I hope that helps!

[@breannebeaver5392]

I’m having the same problem. Can you send me a message:)

[@HayeCreatives]

Hi! Please send us a message on Etsy: www.etsy.com/shop/hayeameri so we may assist you further!

[@AstridValkyrie]

This has some nice features but when I bought it there were a few faults - Budget I - the spending chart wasn't added and Budget II had columns (Actual) in Income, Savings and Expenses colored out with a warning not to change it. It doesnt match this tutorial video.

[@HayeCreatives]

Hi! We have updated it to allow for more features, the most up to date video is linked on the read me tab. The spending chart should be on both tabs and the second tab has a different setup where you add all the transactions in the log, but we explain this in more detail in the new video but if you have any other questions send us a message!

[@raksaKhan1337]

what different to Monthly budget ?

[@HayeCreatives]

Hi! Thank you for your message. This spreadsheet, our simple budget, can be used monthly but we offer a monthly budget spreadsheet as well. The main difference is that this is a one tab spreadsheet, our monthly budget, however, has multiple tabs. It has a separate log tab where you enter all transactions (income, savings, bills, expenses and debt). In addition it has a calendar tab that can be used to keep track of bills and payments as well as a priority tracker. Our monthly budget is also set up to be compatible with our add-ons, such as our annual overview, the account balance tracker and more. These add-ons are not compatible with the simple budget.

[@annecarbonel588]

Can I use this for iPad?

[@HayeCreatives]

Yes! You can use it with your mobile browser or with the Google Sheets app.

[@juliakwan4572]

how would you change this to pound currency? its not letting me

[@HayeCreatives]

You can change it on the top left in the overview section. Simply click on the field, hit the backspace button and then type in your own currency sign.

[@juliakwan4572]

@@HayeCreatives great thank you! loving the template :)

[@amandadankbar5875]

Why is my actual in my expenses not populating?

[@HayeCreatives]

Hi! This is taken from the expense tracker section below. If it is not populating be sure to check if you entered your expenses as "10.00" and not "10,00", Google Sheets is standard set to read numbers with a "." not a ",". And be sure to check if for each row a subcategory is selected. If that does not work send us a message on Etsy so we may assist you further.

[@anactc8299]

How can I change 1,900.00 to 1.900,00 bc in Europe is andersrum

[@HayeCreatives]

Hi! On the read me page there is a link to our Tips and Tricks Page, here we share in detail (with pictures) how to change this. Let me know if that helps!

[@RajPatel-mz8pr]

Can I copy and sell them?

[@HayeCreatives]

Hi, No, we do not allow any resell or any commercial use of any kind. As mentioned on all of our listings: this design and this spreadsheet is copyrighted by Haye Ameri/Haye Creatives. Your purchase of this product is for personal use only and commercial/public use of any kind is strictly prohibited. It is prohibited to resell, share, reproduce this product or distribute this product, either in part or in full, with or without modifications.

[@Simo-zn9nn]

Can I buy the resell rights from you haye

[@HayeCreatives]

Hi! Sorry we do not offer any resell rights or allow any commercial use, all our spreadsheets are for personal use only!

[@gotchaneedofficial]

can I sell it again?

[@HayeCreatives]

No, all our spreadsheets are for personal use only, we do not allow any commercial use. This is also stated on the Etsy listing.

[@renannalesso4806]

where is the tutorial to create it from scratch?

[@HayeCreatives]

Hi! We do not have any tutorials on how to create spreadsheets, sorry about that!

[@renannalesso4806]

​@@HayeCreativeswhat a pity😢 . Thank you!

[@wolficeir]

why is this not free

[@HayeCreatives]

Hi! This template is only available for purchase on our Etsy, sorry! We currently do not offer any free templates.