Budget Planner Spreadsheet for Google Sheets

Подписаться 3,4 тыс.

Просмотров 226 тыс.

50% 1

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

Опубликовано:

18 дек 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 148

@Thereallisadee 10 месяцев назад

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

@HayeCreatives 10 месяцев назад

Glad you like it!

@dancerbabe02 10 месяцев назад

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

@HayeCreatives 10 месяцев назад

Glad it was helpful!

@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!

@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 11 месяцев назад

A zero Based Budget would be even better

@kbanghart 5 месяцев назад

@@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 4 месяца назад

@@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.

@pparks8776 21 день назад

@@Bisola_Adekoya I have zero-based budget, but I also use sinking funds, so they carry a balance.

@BurrProductions16 Год назад

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

@HayeCreatives Год назад

Hope you enjoy it!

@Tupsx57 Год назад

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

@HayeCreatives Год назад

Glad you like it!

@vanessaisso1839 7 месяцев назад

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

@HayeCreatives 7 месяцев назад

Glad you like it!

@lesamccree466 16 дней назад

Oh my goodness I love this spreadsheet! Thank you so much!!

@HayeCreatives 5 дней назад

Glad you like it!

@sharmanic4130 7 месяцев назад

Just purchased! Thank you :)

@HayeCreatives 7 месяцев назад

Hope you like it!

@rachelbelcher3463 22 дня назад

What a beautiful budget, thank you 😘❤️

@HayeCreatives 21 день назад

Glad you like it!

@jupywood 9 месяцев назад

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

@HayeCreatives 9 месяцев назад

I hope you will like it!

@nguyenthimyduyen3845 11 месяцев назад

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 10 месяцев назад

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.

@vanesabotella7084 3 месяца назад

muchas gracias super util gracias!

@HayeCreatives 3 месяца назад

Thanks!

@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!

@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.

@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.

@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!

@dadraduffus1108 10 месяцев назад

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

@HayeCreatives 10 месяцев назад

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.

@ginnupdotcom 5 месяцев назад

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

@HayeCreatives 5 месяцев назад

I hope you will like it!

@qariaa.3887 10 месяцев назад

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 10 месяцев назад

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!

@RileyOutside 7 месяцев назад

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

@HayeCreatives 7 месяцев назад

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

@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!

@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!

@pparks8776 21 день назад

Thank you!! quick question, how do you add sinking funds to this? Any suggestions? I have it in savings, but I don't see how to carry the balance.

@pparks8776 21 день назад

Never mind, I just found your savings template!! Thank you.

@HayeCreatives 21 день назад

Hi! Send us a message on Etsy so we can have a look together at what would work best for you!

@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 11 месяцев назад

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!

@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 :)

@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?

@louiefuentes567 9 месяцев назад

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 9 месяцев назад

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

@louiefuentes567 9 месяцев назад

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

@HayeCreatives 8 месяцев назад

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

@eladngujede6634 7 месяцев назад

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 7 месяцев назад

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!

@anvisionerandcreator8462 9 месяцев назад

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 9 месяцев назад

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!

@aby_creativejourney 7 месяцев назад

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 7 месяцев назад

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.

@user-wv5hi6kz1d 8 месяцев назад

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

@HayeCreatives 8 месяцев назад

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

@user-wv5hi6kz1d 8 месяцев назад

@@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 8 месяцев назад

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

@user-gt6rb9ko6j 21 день назад

Hi, I want to avail but I don't know how to change it into peso instead of dollar. Can you help me with it?

@HayeCreatives 18 дней назад

Hi! You can change the currency on the top left! If you are still experiencing issues after your purchase send us a message on Etsy!

@alyssamojica4421 3 месяца назад

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

@HayeCreatives 3 месяца назад

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

@MrKoobear 7 месяцев назад

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 7 месяцев назад

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!

@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!

@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/

@sukornsinging 11 месяцев назад

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

@HayeCreatives 11 месяцев назад

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.

@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!

@user-ks2lh7gf3s 7 месяцев назад

The etsy link is not working on mine. kindly assist

@HayeCreatives 7 месяцев назад

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

@user-sl9bc8yq4u 5 месяцев назад

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

@HayeCreatives 5 месяцев назад

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

@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.

@darrinleeedwards9 3 месяца назад

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

@HayeCreatives 3 месяца назад

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 3 месяца назад

@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 3 месяца назад

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 :)

@angelinaoosterhof8300 5 месяцев назад

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 5 месяцев назад

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 6 месяцев назад

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!

@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

@sapalicio_ehla 8 месяцев назад

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

@HayeCreatives 8 месяцев назад

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

@anactc8299 10 месяцев назад

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

@HayeCreatives 10 месяцев назад

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!

@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.

@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 :)

@annecarbonel588 8 месяцев назад

Can I use this for iPad?

@HayeCreatives 8 месяцев назад

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

@piwifvbt8157 Месяц назад

I think it is very useful. How can I purchase this template? thx

@HayeCreatives 25 дней назад

Link is in the description!

@YOUSSEFIBAALAL 21 день назад

hey i like what are you doing i wish you all the best, is there any courses available to make this spreedshet?

@HayeCreatives 18 дней назад

Unfortunately not, sorry about that!

@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.

@AstridValkyrie 6 месяцев назад

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 6 месяцев назад

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!

@Simo-zn9nn 2 месяца назад

Can I buy the resell rights from you haye

@HayeCreatives 2 месяца назад

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

@rajhere_in Год назад

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.