I bought this spreadsheet and my first complete month August 2023 was very eye opening and really so easy to use. I really like this. One suggestion is to have balances of the payment accounts. if someone is looking for a budget spreadsheet I STRONGLY suggest you try this one.
Now this is a true Girl Boss! I had a few problems opening and sorting out the spreadsheet as i have never done anything like it before. Our Boss Girl walked me through it and after numerous lovely emails i was well happy and satisfied! i Highly recommend our beautiful lady and her amazing spreadsheets 💯✨️🥰
I also wanted to say thank you so much for teaching these amazing video's. i just love the way you teach it and it's easy to understand. I bought alot of them thank you.
Yeah! I have an annual one but they are completely different layouts. Here's the video in case you would like to check it out th-cam.com/video/Jqmeykw5H2M/w-d-xo.html 😊👩🏻💻✨
Have you considered an end of the year summary? Vertical track months, horizontal track categories? Section for expenses vs income as well as debt paid each month?
Hi! I don't have a dedicated product for credit cards at the moment, I'm sorry! This one is meant to help you plan and track your spending throughout the month, regardless of when you actually pay your cards.
Hi! I used conditional formatting for that behavior. I selected the option "custom formula" and made it check if the row is marked as paid. If it is, I selected the formatting option that creates the scratching effect 😊 I don't have a full video on conditional formatting yet but I will make one this year explaining different tricks like this one 😊👩💻✨
I'm so glad I found your channel! Really helpful and inspiring. I made a mission for myself this year to create a sheet that will work for me and help me track my finances. I would really like to know how you made it work with the checkboxes in the Bills and Subscriptions table. Thank you!
Hi Beautiful!!! I told you I would be back!!! I am looking for a financial projections sheet and I think I may be able to use this to get to my overall goal and edit it accordingly to my needs. You are amazing at these sheets!
Hi! I'm so happy you like it! Thank you! Could you send an email to hello@thinklikeagirlboss.com with the symbol you need? I'll send you the file in your currency 😊👩💻✨
Hi! Thank you so much!! I like to keep all my balances separately on a Net Worth spreadsheet (I just keep a table with all my bank balances and savings, nothing too elaborate) in the end I just make sure my net worth increased by the same amount I put away in savings for that month, but that's just what works for me you can totally do it differently 😊👩🏻💻✨
Hi, I made my own spread sheet but Can you please explain to me how you made the drop-down with the months that change the info per month? I know how to make the actual drop-down, but when I select a different month from my drop-down list, the info I have entered does not change.
Hi! In this particular template all the monthly drop-down does is handle the DATE columns (the functionality in which you just add the day and the full date is created) What I do is use the DATE(year, month, day) formula. The year and month come from what the user set for the sheet in general and the day comes from the day the user set for each transaction. The "tricky" part is figuring out the month number based on the month text selected from the dropdown. You could use the VLOOKUP formula for example, to pull that value from a hidden table. I think I could include that in one of my tutorials in the future 😊👩🏻💻✨
Well executed!! I recently ordered someone else's spreadsheet from Etsy, however, this one is more me. Question: If I enter dates out of order under expenses, can I double click on the date title and it will reorder my items from the less date to most current date? I hope my question makes sense.
Hi! I have a way to do that (but not exactly with the double clicking). I thought it would be easier to create a visual explanation, so I made this pdf with how it can be done: drive.google.com/file/d/112QdIAoz_vK0epuARFnRQ9uB4vF4oHJ3/view I hope it helps! 😊👩🏻💻✨
I have a question for you: I noticed that you've recorded all your expenses in dollars. I'm curious to know if you've ever considered converting the currency to a different one. If so, I would love to learn how to convert it to Philippine peso and change the color theme if possible. 😊
Highlight the data you want to format. Click Format. Number. Click Custom currency. Search in the menu text box to select a format. You can also add your own custom currency format into the text box. Click Apply.
Hi! Really love this template, super functional and looks easy to use! How would you recommend tracking a major purchase or vacation? For example, if you had previously saved up for the purchase, it will appear that you went over your income for this month (which is technically true, but not a reason for a red flag since you had actually saved up for it). Appreciate this video and thanks for your answer!!
Hi! Thank you so much!! One idea is you could play around with negative numbers to maybe "remove" an amount from the savings section and then use it in the expenses section. Please let me know if this helps! 😊👩💻✨
Hey ty so muh for your lovely videos! They're mind blowing! When will you create a tutorial on how to make this? Im so excited for your tutorial videos! They are well done! I was wondering if you can also show a video on how you can do a digital planner for 12 months! That would be great! NEW SUBSCRIBER DEFINITELY! ❤❤
Hi! Thank you so much!! I have one tutorial in which a teach much of what I used to create this one that you might find useful th-cam.com/video/He5cJ33CRu4/w-d-xo.html Thank you so much for subscribing! I will definitely continue creating content, I'm not sure which one will come next but more planning and calendar stuff sounds great 😊👩💻✨
Hi, Girl Boss. First off, this is an insanely impressive spreadsheet so I HAD to buy it😁It’s exactly what my fiance and I have been looking for. Quick question, is there any way to add a line graph that projects our savings/how close we are to our savings goal? Thanks in advance✌🏾
Hi! I'm so happy you like it! Thank you! The only product I have that might help is this savings tracker: th-cam.com/video/lCM4VA2qabU/w-d-xo.html it's not a graph but it's a visual representation of your progress, please let me know if this helps! 😊👩🏻💻✨
Hi! Thank you! 😊👩💻✨ I don't have one with this monthly layout but I have a different one in case you would like to check it out th-cam.com/video/Jqmeykw5H2M/w-d-xo.html
Hi! To change the currency you can select groups of cells you want to change and then click on FORMAT -> NUMBER then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊 If you run into any issues please let me know and I can help you do it (you can message me on Etsy to make sure I get notified) 👩💻✨
Hi, this looks amazing, thank you! The monthly tracker will really help me. However some of my bills are quarterly, how can I add this to the tracker please?
Hi! Thank you so much!! You can totally add extra tabs to the template so you could keep a record of those quarterly ones and check that list when setting up a new month 😊👩🏻💻✨ I also have a standalone bill tracker available if you would like to check that one out: th-cam.com/video/baQ2dUfAs_o/w-d-xo.html
I just bought it after contemplating if I should re-create it or save myself and buy it. huhu just wanna change the currency without damaging the template
Hey! How do I change the currency in the spreadsheet? Also, how do I carry forward the savings or the money left over to the next month to reflect in the starting amount?
Hi! I created this as a zero based budget so I didn't include a section for a start amount. The way I created it is you assign every penny from your income from each month to either bills, expenses, savings or debt. The difference between money in and money out should be zero. If you want to go over your monthly income and not end up with a negative amount left, what people usually do with my file is use negative numbers in the savings section whenever they are withdrawing money. If you do decide to purchase, you can send an email to hello@thinklikeagirlboss.com before purchasing and I'll have the file ready in whatever currency you need beforehand 😊👩🏻💻✨
I love the clear instructions since there are so many functionalities! I love the colors too! Could I please know what hex codes you used for the two/three pink(ish) colors? Wanted to use them for a poster
You are amazing with your knowledge of Google sheets! I’m no where near your level of knowledge, however I did create me a monthly budget spreadsheet. One question I haven’t seen you cover is if you do not use all your money for various expense categories and want to roll it over to the next month, is there a formula for that or do you have to just manually add that to the next months available expenses?
Hi! Thank you so much!! I'm glad you created your own! 😊 In this version I used zero-based budgeting so all your money from the month must go into one of the available sections. I built it with that in mind but you can totally adapt it to your needs. You can add an additional section to include an amount left from previous months, you could add it in the income section as money left from the past month, you can do whatever makes sense to you as long as your numbers match and you are not duplicating any information by accident 😊👩🏻💻✨
i was trying to make one myself, i said screw it my brain is about to burst haha then i saw ur vid, i love it and the only thing i feel is missing is the annual summary, but apart from that this is definitely worth the price
Hi! Thank you! 😊👩🏻💻✨ You can open it on your phone with either the Google Sheets app or using the browser version. Personally, I am not a big fan of using Google Sheets on my phone. What you could do is try one of my free templates and see how comfortable you are with using them on the phone. These are the ones I have available at the moment 😊👩🏻💻✨ thinklikeagirlboss.com/en-mx/pages/free-youtube-tutorials I hope this helps! 😊
Hi there, just purchased your spreadsheet! For each month, do you just make a new copy? or is there a way to keep all 12 months on one spread document? thanks!
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle,for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
Thank you so much! It's totally up to you. As long as you don't duplicate any information, you can do whatever makes sense to you and your personal situation. You could add it after tax when it comes to your regular job and have a dedicated section (maybe in savings) in which you put aside money for future tax payments for your other income sources 😊👩🏻💻✨
Question here… I was going over the budget and should I remove 401k from the investment section because it takes it away from our income in the cash flow summary?
Hi! As long as numbers match and you don't duplicate any information you can do whatever makes sense to you, knowing that the "amount left" is calculated this way: + Income - Bills - Expenses - Savings - Investments - Debts = Amount Left When the amount left is zero it means every penny from your income section was allocated somewhere 😊👩🏻💻✨
I loveee this spreadsheet! Could you clarify how you would be able to utilise the savings and update the expense tracker, so all expenses can be tracked. As it is a zero based budget diff, would you just add it to the income or would you add a negative value from the savings transactions to include? Thanks in advance!
Hi! I'm so happy you love it! Thank you!! As long as your numbers match and you're not duplicating information by accident you can do it however you prefer. From your two options I would personally choose the second one but it totally depends on what makes sense to you 😊👩💻✨
@@thinklikeagirlboss i’m trying to build this from scratch but sooo difficult 🤣 will be purchasing this soon along with the sinking fund one that you have, so will try combining those two! I just wish theres an overall for savings page as well but i think i can do with the sinking fund I cant wait to see how you incorporate an annual overview in the near future
@@AtMirah Thank you so much!! I will definitely keep on creating new things, eventually I want to end up with an amazing annual product that incorporates everything 😊👩💻✨
I love this template and I'm thinking about getting it. I saw that you have an annual template too, but I like this one better. Is it possible to add an annual tab to this template?
Hi! I don't have an annual version for this at the moment, I'm sorry! I have a 12 month income and expense tracker (with 12 month summaries) that you might find useful. This is the link in case you would like to check it out th-cam.com/video/VHKFLDjyBQI/w-d-xo.html 😊👩💻✨
Hi love, I love how thought out this spreadsheet was made. I am wondering if I am able to use biweekly and if not could you make a format for biweekly ?
Hi! Thank you so much!! I don't have a bi-weekly format right now, I'm sorry! I do get asked a lot about it so at some point I will for sure make one 😊👩🏻💻✨
Hello! When I try to duplicate the sheet to make the next month it automatically duplicated all of my entires as well rather than just the blank template. But in the video it seems like yours made a fresh blank one. Is there something I should do differently so that I don't have to do through and delete all of the previous entries on the copy? thank you so much, this spreadsheet is awesome.
Hi! You need to make sure you keep one tab that has everything you want to reuse each month, but no actual amounts, you keep this one as your blank original and you create duplicates from it each month 😊👩💻✨ If you need more help with this could you send me an email to hello@thinklikeagirlboss.com? I answer faster over there 😊👩💻✨
Very nice spreadsheet, I am trying to create one myself as well like your annual sheet. I want to highlight total and row of transaction if category or description is empty. How can I do that, I will really appreciate if you help.
I just purchased it, but let me know what is the purpose of not assigned cell in customize here sheet. I don’t really use that one, but if I delete that not assigned cell in customize here sheet, there are occasional blank cell in main spreadsheet. What is the purpose of it, and how can I make the main sheet not use that not assigned cell??
Hi! If you scroll all the way to the very end you will find 3 detailed summaries (Money Out Categories, Custom Tags and Payment Methods). If a transaction doesn't have these fields assigned, it will be added up in the "Not Assigned" row (on its corresponding table). The way I created it, this row has to exist to make sure every transaction is taken into consideration for the summaries 👩🏻💻✨
@@thinklikeagirlboss Yes, I get it, but we did all the customization in customize here sheet, and all of those 3 fields are created based on our needs, so I couldn’t really think of any transaction without any fields assigned. Yeah. About “has to exist” thing, I get it, because i know it created a blank cell here and there A LOT. So yeah, just reporting. it’s a bit annoying to see one particular cell that I don’t need (to see) while everything I need is already customized by me.
i got so stress to pick which one i shoud use, i need daily expenses for a year and i do freelance so complicated to take it down. i got my own sheet but i guess urs is better organize.
Hi! In this case I don't have anything that supports multiple currencies so I think you would need to stick to one. In my case my credit cards end up charging everything in my own currency, no matter where I am, so that is the amount I use 👩💻✨
For your savings goals I would do the sinking funds tracker and for everything else I would choose either the annual budget planner or the monthly budget planner. The monthly one doesn't have a yearly overview so if that's important to you then I would choose the annual one 😊👩💻✨
This is such a great video! I've been trying to get the full date in a spreadsheet I am working on for work and cannot figure out the formula! It is similarly set up like this, with a drop down month and when the user picks the month from drop down and the date is entered, the full date is populated, but my formula keeps returning months either before or after the month is selected from the drop down. So crazy!
Hello! This video was really comprehensive and fun. I'm just wondering for the Expense Transactions, how were you able to highlight the category from the transactions that was selected in the dropdown? I would really appreciate your reply. Thank you so much!
This is amazing and I definitely want to buy! Can this work in Excel or just Google sheets? And I see there are many sections in the spreadsheet, should we be filling it out bi-weekly or monthly? I just want to make sure I am using it to its full purpose, Thank you!
Hi! Thank you so much!! It works in Google Sheets only and it's totally up to whichever you prefer 😊. You can duplicate the tab for each month but lately I've also seen some people duplicate it for each week (or two weeks) I tried to make it super flexible so you can do it however makes sense to you 😊👩🏻💻✨ Please let me know if this helps! 😊
Hi, is there a way that I can add starting Balance left over money from previous month to the tracking expenses, Or is there a possibility that you can make a updated version with Starting and ending balance within the budget sheet and a location for sinking funds, I have your sinking funds sheet but it would be great if it was in all one spot.
Hi! I will be making an annual version this year that will sort of work that way but I don't have a specific date for it yet 😊👩🏻💻✨ I will definitely make a video for it once it's up 😊
This is beyond incredible and would have taken so much work to set up! Is there a way to view all your income, expenses, and savings for the year by pooling all the information across the months?
Thank you so much!! 😊👩💻✨ I don't currently have a yearly version, I'm sorry! For a yearly overview I have a 12 month income and expense tracker, but it's a different layout. This is the video in case you would like to check it out: th-cam.com/video/VHKFLDjyBQI/w-d-xo.html
I've just purchased your sheet and I'm coming up against a problem (I think?). I have sinking funds and some of the expenses I'd be tracking would be paid from those sinking funds and not from my monthly income. How do I appropriately track those so that they're accounted for and that my sinking funds accounts are accurate? For example, next month I have to put new tires on my car. I've saved up for that in a sinking fund throughout the last year. When I go to pay for them, I'm pulling the money from that account, not from the funds from my paycheck. I'm worried that if I track in my expenses, it'll look like I'm going over budget when I'm really not.
Hi! You could "withdraw" money from the savings section by using negative numbers 😊👩💻✨ Would you mind sending an email to hello@thinklikeagirlboss.com if you have more questions about this? I sometimes don't get notifications for replies on comments 😊👩💻✨
Hi, I hope you could answer this question. I'm planning to sell spreadsheet template on esty. I wonder, how can I hide and secure the format of my digital products? Thanks in advance
Good morning, Question is possible to export everything into Mircosoft Excel? Noticed the calendar function does not work. And some of the check boxes do not look the same as google sheets.
Hi! I use some Google Sheets features that are not compatible with excel so if you try downloading it there it will break. I'm sorry! It will only work as intended in Google Sheets 👩💻✨
Hi! Thank you!! You can totally choose just one, you can watch both videos and decide what fits your needs best 😊👩💻✨ Please let me know if you have any questions about them 😊
I really love your spreadsheet since it helped me have more visibility into my money flow. I just have one question: where do I keep track of my credit card bill? I understand that expenses is the amount I incurred, but would the credit card fall under Bill & Subscription section, or Debt?
Hi! There's no one specific way to do it, as long as numbers match and you don't duplicate any information you can do whatever makes sense to you. I've seen people use negative numbers to remove amounts from the expenses they plan on paying next month and then use the debt or bill section to pay that the next month. I tried to make it as flexible as possible so you could use whatever section makes sense to you 😊👩🏻💻✨
Hi! To change the currency in Google Sheets you can select groups of cells you want to change and then click on FORMAT -> NUMBER. Then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊 If you have any issues along the way you can contact me and I'll help you 😊👩💻✨ (email or Etsy because I don't always get the TH-cam notifications)
Hi! There's no one specific way to do it, as long as numbers match and you don't duplicate any information you can do whatever makes sense to you. I've seen people use negative numbers to remove amounts from the expenses they plan on paying next month and then use the debt or bill section to pay that the next month. I tried to make it as flexible as possible so you could use whatever section makes sense to you 😊👩💻✨
This is incredible! Thank you so much. Just purchased on Etsy 😊 what would you do in the case where you have a few annual subscriptions? What would be the best way to incorporate those into this budget system? Thanks again
Hi! Thank you!! You could keep them in a separate tab and add them to their corresponding months whenever you are setting up a new month. Please let me know if this helps! 😊👩💻✨
Hi tanks for triste hard work. Yesterday il made à purchase of your product following thé link in the bio.i have not received thé order confirmation, neither the link to dowload it. Is it normal ?
Hi! I just met your channel and i love it. Are you going to update this sheet so we can analyze it from a year view? If it is please let mi know! I will appreciate it. If it's not Do you have any video where I can learn how to do it?
Hi! To change the currency you can select groups of cells you want to change and then click on FORMAT -> NUMBER then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊 If you run into any issues, you can let me know and I can help you do it 😊👩💻✨
Hi! Right now I have one video that shows how to create some of the features in this template in case you would like to check it out 😊👩🏻💻✨ th-cam.com/video/He5cJ33CRu4/w-d-xo.html
I need this in excel so bad! I know there’s tools to convert google sheets to excel but I’ve heard that some functions won’t work :( Do you know if that’s the case for this? I really love Excel and I want this budget spreadsheet so bad!!! but I’m not a fan of google sheets😭
Hi! There's several features that I don't think will be compatible, I'm sorry!! I'm actually the other way around 👩💻✨ I love Google Sheets I do everything there. I'm sorry!! ✨
Hello, your template was incredible! I tried crafting something similar, but it just didn't come together. I was wondering if you offer any paid courses or guidance on creating these kinds templates. I saw your video on 'How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL,' which was great, but I'm specifically interested in learning how to build such templates. Can you help me with this?
Hii!! I really love your planner. I've been really curious how you automate your day entry and automatically change to the same date. I would really appreciate your response. Thank you! 💛
@thinklikeagirlboss yes! If it's alright with you to share your knowledge about it? whether in a short clip, tiktok, or story. We will be greatly appreciative and be happy to support your future contents. ✨️🥰
I'm sorry for the late reply! I'm not sure why but I don't get notifications for replies just the first comment. What I do is use the DATE(year, month, day) formula. The year and month come from what the user set for the sheet in general and the day comes from the day the user set for each transaction. The "tricky" part is figuring out the month number based on the month text selected from the dropdown. You could use the VLOOKUP formula for example, to pull that value from a hidden table. I think I could include this in one of my tutorials in the future 😊👩🏻💻✨
@@thinklikeagirlboss I see. I'll go google it and see how it works. I really want to learn so much and thank you for this. Because of you, I am eager to learn more about forming formulas and functions. I hope you more blessings on your career. ^^
I can’t think you enough, it’s only been about 6 months and my life has changed so much because of this😫
I loved reading this! I’m so happy it has been helpful!! Thank you so much for commenting 😊👩🏻💻✨
Omg!!! I’m not sure how I found your page but I am so glad I did! This is exactly what I needed in my life!!! Thank you so much for sharing.
Hi!! I'm so happy you liked it!! Thank you so much for commenting! 😊👩💻✨
I came here to learn how to make this on my own and ended up just buying the template 😂😂😂😂 thank you girl!!!!!!
Hi!! I hope you enjoy using it! 😊👩💻✨
How much is the template?
ME TOO! if i'm here its because i can't pay for this lol
I bought this spreadsheet and my first complete month August 2023 was very eye opening and really so easy to use. I really like this. One suggestion is to have balances of the payment accounts. if someone is looking for a budget spreadsheet I STRONGLY suggest you try this one.
Hi! You're awesome! Thank you so much for leaving a comment! I'm so happy you found it useful!! And thank you for your suggestion! 😊👩💻✨
Now this is a true Girl Boss! I had a few problems opening and sorting out the spreadsheet as i have never done anything like it before. Our Boss Girl walked me through it and after numerous lovely emails i was well happy and satisfied! i Highly recommend our beautiful lady and her amazing spreadsheets 💯✨️🥰
You're so sweet! Thank you so much for this comment! I was so happy I could help 😊👩💻✨💕
Very nice budget sheet! Very well thought out and very customizable. A+++
Thank you SO much!! I really wanted to do a good job on this ☺️👩💻
hi where can I fin this template?
Hi!! You can find it in my Etsy Shop 😊👩🏻💻✨ This is the direct link:
www.etsy.com/listing/1302328355/monthly-budget-spreadsheet-google-sheets
I also wanted to say thank you so much for teaching these amazing video's. i just love the way you teach it and it's easy to understand. I bought alot of them thank you.
Hi! I just saw your order, those were indeed a lot! Thank you SO much for supporting my work, I hope you like them! 😊👩💻✨💕
It's simply good. Can you do a video on how you created this sheet ( formulas , some one can create their own by looking at that video)
Hi! Thank you! I will definitely be making more tutorials next year and will include money trackers as well 😊👩💻✨
weeeh i just got mine today. So excited!
Thank you so much!! I hope you enjoy using it!! 😊👩💻✨
Here after purchasing the spreadsheet 😊
I hope you like it!! 😊👩💻✨
Blown away!!! Thank you this was brilliant 😇
Thank you so much!! 😊👩💻✨
I neeeed a tutorial on how to build these for myself! Love love your videos.
Thank you SO much!!! 😊👩💻 I will definitely add that to my list! ✨
Very nice. So clean!
Thank you so much!! 😊👩🏻💻✨
This is amazing! I just got it from Etsy. I'm going to try to make one page for the year😊
Ohhhh you have a annual spreadsheet 😂😂, I'll use this until December!
Thank you so much!! I hope you like it!! 😊👩🏻💻✨
Yeah! I have an annual one but they are completely different layouts. Here's the video in case you would like to check it out th-cam.com/video/Jqmeykw5H2M/w-d-xo.html 😊👩🏻💻✨
You are so creative for this!
Thank you!! 😊👩🏻💻✨
This is incredible!
I'm so glad you liked it! Thank you so much for commenting! 😊👩🏻💻✨
Awesome worksheet
Hi! Thank you so much!! 😊👩🏻💻✨
I haven't no words for thank you🥺 very usefull very clear introduction beutiful creativity work 🤗❤️ . Thank u
Hi!! I am SO happy you liked it!! Thank you so much for letting me know 😊👩🏻💻
AWESOME - great piece of work. Great Value.
Continued success with your channel. 123
Thank you so much!!! 😊👩💻✨
This helped me so much! thank you!
I'm so happy to hear that!! 😊👩🏻💻✨ Thank you so much for commenting!!
Thanks you so much for the your video
Awesome....❤❤❤
Thank you!! 😊👩💻✨💕
id love to be able to try and make this.
THANKYOUUUU ❤❤❤❤❤
Have you considered an end of the year summary? Vertical track months, horizontal track categories? Section for expenses vs income as well as debt paid each month?
Hi! Yeah! I plan on creating an annual version sometime soon. I have other things in the works right now but that's on my list as well 😊👩💻
I have an annual template, but it's totally different, in case you want to check it out 😊 th-cam.com/video/Jqmeykw5H2M/w-d-xo.html
@@thinklikeagirlboss ahh thank you! Will do
Thank you so much. I would love a tutorial on how to design this spreadsheet ☺️
how do you record credit card transactions? and how to reconcile credit card payments
Hi! I don't have a dedicated product for credit cards at the moment, I'm sorry! This one is meant to help you plan and track your spending throughout the month, regardless of when you actually pay your cards.
i bought it already!
I hope you enjoy using it!! 😊👩💻✨
Hi, can you explain the formula to make the amount due and paid system? I like how the due value is crossed out when you write the amount paid...
Hi! I used conditional formatting for that behavior. I selected the option "custom formula" and made it check if the row is marked as paid. If it is, I selected the formatting option that creates the scratching effect 😊 I don't have a full video on conditional formatting yet but I will make one this year explaining different tricks like this one 😊👩💻✨
I'm so glad I found your channel! Really helpful and inspiring. I made a mission for myself this year to create a sheet that will work for me and help me track my finances. I would really like to know how you made it work with the checkboxes in the Bills and Subscriptions table. Thank you!
Hi Beautiful!!! I told you I would be back!!! I am looking for a financial projections sheet and I think I may be able to use this to get to my overall goal and edit it accordingly to my needs. You are amazing at these sheets!
I just love it when I get any comments from you!! 😊👩💻 Thank you so much!! Can you message me on Etsy before you purchase?
@@thinklikeagirlboss Absolutely!!!!! You got it!
I think this is exactly what I’m looking for. To have one that includes sinking funds and debt snowballing/avalanche or custom
Hi! I'm happy it was what you're looking for! 😊👩💻✨
Can you do a video of spread sheet on comparison on for different grocerie store?
I will add that to my list of ideas! 😊👩💻✨
this is a very thought out template been using it for a few mneth now. how do i change the currency?
Hi! I'm so happy you like it! Thank you! Could you send an email to hello@thinklikeagirlboss.com with the symbol you need? I'll send you the file in your currency 😊👩💻✨
What formula do I use to make the individual expenses highlight when I select the category from the dropdown?
Holy Cow! This is exactly what I was looking for. Where do I buy this spreadsheet?
Hi! You can get it here thinklikeagirlboss.etsy.com/listing/1302328355 I'm so happy you like it! 😊👩💻✨
Plz don’t delete one of ur videos.. I need them soon..... 🎉🎉🎉🎉 thx for transparency... Tho
Don't worry I won't delete them 😊👩💻✨
Great job!! Thinking of purchasing this but wondering how you reconcile it with your bank account amount?
Hi! Thank you so much!! I like to keep all my balances separately on a Net Worth spreadsheet (I just keep a table with all my bank balances and savings, nothing too elaborate) in the end I just make sure my net worth increased by the same amount I put away in savings for that month, but that's just what works for me you can totally do it differently 😊👩🏻💻✨
Super impressive
Thank you so much!!! 😊👩💻
Hi, I made my own spread sheet but Can you please explain to me how you made the drop-down with the months that change the info per month? I know how to make the actual drop-down, but when I select a different month from my drop-down list, the info I have entered does not change.
Hi! In this particular template all the monthly drop-down does is handle the DATE columns (the functionality in which you just add the day and the full date is created) What I do is use the DATE(year, month, day) formula. The year and month come from what the user set for the sheet in general and the day comes from the day the user set for each transaction.
The "tricky" part is figuring out the month number based on the month text selected from the dropdown. You could use the VLOOKUP formula for example, to pull that value from a hidden table. I think I could include that in one of my tutorials in the future 😊👩🏻💻✨
Well executed!! I recently ordered someone else's spreadsheet from Etsy, however, this one is more me. Question: If I enter dates out of order under expenses, can I double click on the date title and it will reorder my items from the less date to most current date? I hope my question makes sense.
Hi! I have a way to do that (but not exactly with the double clicking).
I thought it would be easier to create a visual explanation, so I made this pdf with how it can be done: drive.google.com/file/d/112QdIAoz_vK0epuARFnRQ9uB4vF4oHJ3/view
I hope it helps! 😊👩🏻💻✨
@@thinklikeagirlboss thank you so much! I look forward to purchasing this!
Thank you! I hope you like it!! 😊👩💻
I have a question for you: I noticed that you've recorded all your expenses in dollars. I'm curious to know if you've ever considered converting the currency to a different one. If so, I would love to learn how to convert it to Philippine peso and change the color theme if possible. 😊
Hi! You can send an email to hello@thinklikeagirlboss.com after your purchase and I can provide a new file with any currency you need 😊👩🏻💻✨
Highlight the data you want to format.
Click Format. Number.
Click Custom currency.
Search in the menu text box to select a format. You can also add your own custom currency format into the text box.
Click Apply.
Thank you for this! 😊👩💻✨
Hi! Really love this template, super functional and looks easy to use!
How would you recommend tracking a major purchase or vacation? For example, if you had previously saved up for the purchase, it will appear that you went over your income for this month (which is technically true, but not a reason for a red flag since you had actually saved up for it). Appreciate this video and thanks for your answer!!
Hi! Thank you so much!! One idea is you could play around with negative numbers to maybe "remove" an amount from the savings section and then use it in the expenses section. Please let me know if this helps! 😊👩💻✨
I have seen some people treat the amount from the saved sinking fund as income so that the transaction doesnt go over the income.
Hey ty so muh for your lovely videos! They're mind blowing! When will you create a tutorial on how to make this? Im so excited for your tutorial videos! They are well done! I was wondering if you can also show a video on how you can do a digital planner for 12 months! That would be great! NEW SUBSCRIBER DEFINITELY! ❤❤
Hi! Thank you so much!! I have one tutorial in which a teach much of what I used to create this one that you might find useful th-cam.com/video/He5cJ33CRu4/w-d-xo.html
Thank you so much for subscribing! I will definitely continue creating content, I'm not sure which one will come next but more planning and calendar stuff sounds great 😊👩💻✨
Hi, Girl Boss. First off, this is an insanely impressive spreadsheet so I HAD to buy it😁It’s exactly what my fiance and I have been looking for. Quick question, is there any way to add a line graph that projects our savings/how close we are to our savings goal?
Thanks in advance✌🏾
Hi! I'm so happy you like it! Thank you! The only product I have that might help is this savings tracker: th-cam.com/video/lCM4VA2qabU/w-d-xo.html it's not a graph but it's a visual representation of your progress, please let me know if this helps! 😊👩🏻💻✨
Hi great video, is there any 12 months budget tracker like Income and expenses tracker video that you had ever made?
Hi! Thank you! 😊👩💻✨ I don't have one with this monthly layout but I have a different one in case you would like to check it out th-cam.com/video/Jqmeykw5H2M/w-d-xo.html
Hello! Thank you for this sheet. Is super helpful! I have a question, how can I change the currency for all the cells?
Hi! To change the currency you can select groups of cells you want to change and then click on FORMAT -> NUMBER then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊
If you run into any issues please let me know and I can help you do it (you can message me on Etsy to make sure I get notified) 👩💻✨
@@thinklikeagirlboss thanks! You are a superstar!
That's so sweet thank you so much!! 😊👩💻✨
Hi, this looks amazing, thank you! The monthly tracker will really help me. However some of my bills are quarterly, how can I add this to the tracker please?
Hi! Thank you so much!! You can totally add extra tabs to the template so you could keep a record of those quarterly ones and check that list when setting up a new month 😊👩🏻💻✨
I also have a standalone bill tracker available if you would like to check that one out: th-cam.com/video/baQ2dUfAs_o/w-d-xo.html
Could this be used to track a persons business budget as well.
Hi! If the sections I included are useful to you in your business you can totally use it as well 😊👩💻✨
Can you show how to create the automatically full date when entering the day column?
is there a way we can change the currency?
I just bought it after contemplating if I should re-create it or save myself and buy it. huhu just wanna change the currency without damaging the template
Hi! Could you send an email to hello@thinklikeagirlboss.com and let me know what currency you need? I'll send you a new file in that currency 😊👩💻✨
Hey! How do I change the currency in the spreadsheet? Also, how do I carry forward the savings or the money left over to the next month to reflect in the starting amount?
Hi! I created this as a zero based budget so I didn't include a section for a start amount. The way I created it is you assign every penny from your income from each month to either bills, expenses, savings or debt. The difference between money in and money out should be zero.
If you want to go over your monthly income and not end up with a negative amount left, what people usually do with my file is use negative numbers in the savings section whenever they are withdrawing money.
If you do decide to purchase, you can send an email to hello@thinklikeagirlboss.com before purchasing and I'll have the file ready in whatever currency you need beforehand 😊👩🏻💻✨
Beautiful & Superhelpful💯! Thank you 🫀!!
I'm so happy you found it useful!! Thank you for commenting! 😊👩💻✨
I love the clear instructions since there are so many functionalities! I love the colors too! Could I please know what hex codes you used for the two/three pink(ish) colors? Wanted to use them for a poster
Hi! thank you!! Here are the values #f7f1f0 #d0aba7 #e2cbc9 😊👩🏻💻
@@thinklikeagirlboss Thank you! 💛 Can't wait for your future projects
How do you automate the cells in google sheets? Does it come automatically automated when I purchase this?
Hi! All the functionalities shown in the video are included in the template 😊👩💻✨
You are amazing with your knowledge of Google sheets! I’m no where near your level of knowledge, however I did create me a monthly budget spreadsheet. One question I haven’t seen you cover is if you do not use all your money for various expense categories and want to roll it over to the next month, is there a formula for that or do you have to just manually add that to the next months available expenses?
Hi! Thank you so much!! I'm glad you created your own! 😊 In this version I used zero-based budgeting so all your money from the month must go into one of the available sections.
I built it with that in mind but you can totally adapt it to your needs.
You can add an additional section to include an amount left from previous months, you could add it in the income section as money left from the past month, you can do whatever makes sense to you as long as your numbers match and you are not duplicating any information by accident 😊👩🏻💻✨
i wantto purchase this but is there a wy i can see the annual summary
Hi! I didn't add that in this monthly version but I will make an annual one sometime next year that includes an annual summary 😊👩💻✨
i was trying to make one myself, i said screw it my brain is about to burst haha then i saw ur vid, i love it and the only thing i feel is missing is the annual summary, but apart from that this is definitely worth the price
Just wondering if you already sell a version with annual summary
Is it possible to change the currency quite easily?
Hi! You can send an email to hello@thinklikeagirlboss.com letting me know the currency symbol and I can have a file ready before you purchase 😊👩🏻💻✨
@ thank you so much. I’ll send an email, it’s for the South African Rand, the symbol is R
Hi. I love this template. The only consern i have is if I'm going to be able to use it on my phone?.
Hi! Thank you! 😊👩🏻💻✨ You can open it on your phone with either the Google Sheets app or using the browser version. Personally, I am not a big fan of using Google Sheets on my phone.
What you could do is try one of my free templates and see how comfortable you are with using them on the phone.
These are the ones I have available at the moment 😊👩🏻💻✨ thinklikeagirlboss.com/en-mx/pages/free-youtube-tutorials
I hope this helps! 😊
Hi there, just purchased your spreadsheet! For each month, do you just make a new copy? or is there a way to keep all 12 months on one spread document? thanks!
Hi! You can duplicate the blank tab as many times as you need to keep it all in one file 😊👩🏻💻✨
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle,for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
Thank you so much! It's totally up to you. As long as you don't duplicate any information, you can do whatever makes sense to you and your personal situation.
You could add it after tax when it comes to your regular job and have a dedicated section (maybe in savings) in which you put aside money for future tax payments for your other income sources 😊👩🏻💻✨
Question here… I was going over the budget and should I remove 401k from the investment section because it takes it away from our income in the cash flow summary?
Hi! As long as numbers match and you don't duplicate any information you can do whatever makes sense to you, knowing that the "amount left" is calculated this way:
+ Income
- Bills
- Expenses
- Savings
- Investments
- Debts
= Amount Left
When the amount left is zero it means every penny from your income section was allocated somewhere 😊👩🏻💻✨
I loveee this spreadsheet! Could you clarify how you would be able to utilise the savings and update the expense tracker, so all expenses can be tracked. As it is a zero based budget diff, would you just add it to the income or would you add a negative value from the savings transactions to include? Thanks in advance!
Hi! I'm so happy you love it! Thank you!! As long as your numbers match and you're not duplicating information by accident you can do it however you prefer. From your two options I would personally choose the second one but it totally depends on what makes sense to you 😊👩💻✨
@@thinklikeagirlboss i’m trying to build this from scratch but sooo difficult 🤣 will be purchasing this soon along with the sinking fund one that you have, so will try combining those two! I just wish theres an overall for savings page as well but i think i can do with the sinking fund
I cant wait to see how you incorporate an annual overview in the near future
@@AtMirah Thank you so much!! I will definitely keep on creating new things, eventually I want to end up with an amazing annual product that incorporates everything 😊👩💻✨
I love this template and I'm thinking about getting it. I saw that you have an annual template too, but I like this one better. Is it possible to add an annual tab to this template?
Hi! I don't have an annual version for this at the moment, I'm sorry! I have a 12 month income and expense tracker (with 12 month summaries) that you might find useful. This is the link in case you would like to check it out th-cam.com/video/VHKFLDjyBQI/w-d-xo.html 😊👩💻✨
Very nice budget sheet, is it possible to put those different section on a separate sheet?
Thank you! I only have a one tab version at the moment, I'm sorry! 👩💻✨
If purchased, Can download from excel sheet?
Hi! My templates only work in Google Sheets. If you would like an Excel version you can purchase from this shop instead: alphatwoseven.etsy.com
Hi love, I love how thought out this spreadsheet was made. I am wondering if I am able to use biweekly and if not could you make a format for biweekly ?
Hi! Thank you so much!! I don't have a bi-weekly format right now, I'm sorry! I do get asked a lot about it so at some point I will for sure make one 😊👩🏻💻✨
Hello! When I try to duplicate the sheet to make the next month it automatically duplicated all of my entires as well rather than just the blank template. But in the video it seems like yours made a fresh blank one. Is there something I should do differently so that I don't have to do through and delete all of the previous entries on the copy? thank you so much, this spreadsheet is awesome.
Hi! You need to make sure you keep one tab that has everything you want to reuse each month, but no actual amounts, you keep this one as your blank original and you create duplicates from it each month 😊👩💻✨
If you need more help with this could you send me an email to hello@thinklikeagirlboss.com? I answer faster over there 😊👩💻✨
do you have a tutorial for this template? This is so amazing!
Hi! Thank you! I don't have a tutorial for this one, I'm sorry! 👩🏻💻✨ This is the only one that gets close: th-cam.com/video/He5cJ33CRu4/w-d-xo.html
Very nice spreadsheet, I am trying to create one myself as well like your annual sheet.
I want to highlight total and row of transaction if category or description is empty.
How can I do that, I will really appreciate if you help.
Hi! Thank you! You can use conditional formatting with custom formulas for that 😊👩💻✨
@@thinklikeagirlboss Can you tell me which formula to use I am trying to use countif but it is not working properly.
Hello! Considering purchasing. Is there a yearly automatic report that ads all the monthly statistic?
Hi! I don't have an annual version with yearly summaries yet, but I'll be making one soon 😊👩💻✨
I just purchased it, but let me know what is the purpose of not assigned cell in customize here sheet. I don’t really use that one, but if I delete that not assigned cell in customize here sheet, there are occasional blank cell in main spreadsheet. What is the purpose of it, and how can I make the main sheet not use that not assigned cell??
Hi! If you scroll all the way to the very end you will find 3 detailed summaries (Money Out Categories, Custom Tags and Payment Methods).
If a transaction doesn't have these fields assigned, it will be added up in the "Not Assigned" row (on its corresponding table).
The way I created it, this row has to exist to make sure every transaction is taken into consideration for the summaries 👩🏻💻✨
@@thinklikeagirlboss Yes, I get it, but we did all the customization in customize here sheet, and all of those 3 fields are created based on our needs, so I couldn’t really think of any transaction without any fields assigned. Yeah. About “has to exist” thing, I get it, because i know it created a blank cell here and there A LOT. So yeah, just reporting. it’s a bit annoying to see one particular cell that I don’t need (to see) while everything I need is already customized by me.
i got so stress to pick which one i shoud use, i need daily expenses for a year and i do freelance so complicated to take it down. i got my own sheet but i guess urs is better organize.
how to do with different currency as i travel a lot
1. daily track money in and out difrent currency
2. pay check freelance
3. saving for diffrent goals
4. shopping list goals
Hi! In this case I don't have anything that supports multiple currencies so I think you would need to stick to one. In my case my credit cards end up charging everything in my own currency, no matter where I am, so that is the amount I use 👩💻✨
For your savings goals I would do the sinking funds tracker and for everything else I would choose either the annual budget planner or the monthly budget planner. The monthly one doesn't have a yearly overview so if that's important to you then I would choose the annual one 😊👩💻✨
This is such a great video! I've been trying to get the full date in a spreadsheet I am working on for work and cannot figure out the formula! It is similarly set up like this, with a drop down month and when the user picks the month from drop down and the date is entered, the full date is populated, but my formula keeps returning months either before or after the month is selected from the drop down. So crazy!
I do stuff behind the scenes for that to work, maybe I can do a video about that 😊👩🏻💻✨
@@thinklikeagirlboss Ooo that would be so helpful!! I love your work, great job!
Thank you so much! 😊👩🏻💻✨
Hello! This video was really comprehensive and fun. I'm just wondering for the Expense Transactions, how were you able to highlight the category from the transactions that was selected in the dropdown? I would really appreciate your reply. Thank you so much!
Hi! Thank you so much! I used conditional formatting and created a custom formula to check if the category selected matches each row's category 😊👩💻✨
This is amazing and I definitely want to buy! Can this work in Excel or just Google sheets? And I see there are many sections in the spreadsheet, should we be filling it out bi-weekly or monthly? I just want to make sure I am using it to its full purpose, Thank you!
Hi! Thank you so much!! It works in Google Sheets only and it's totally up to whichever you prefer 😊. You can duplicate the tab for each month but lately I've also seen some people duplicate it for each week (or two weeks) I tried to make it super flexible so you can do it however makes sense to you 😊👩🏻💻✨ Please let me know if this helps! 😊
Hi, is there a way that I can add starting Balance left over money from previous month to the tracking expenses, Or is there a possibility that you can make a updated version with Starting and ending balance within the budget sheet and a location for sinking funds, I have your sinking funds sheet but it would be great if it was in all one spot.
Hi! I will be making an annual version this year that will sort of work that way but I don't have a specific date for it yet 😊👩🏻💻✨ I will definitely make a video for it once it's up 😊
This is beyond incredible and would have taken so much work to set up! Is there a way to view all your income, expenses, and savings for the year by pooling all the information across the months?
Thank you so much!! 😊👩💻✨ I don't currently have a yearly version, I'm sorry!
For a yearly overview I have a 12 month income and expense tracker, but it's a different layout. This is the video in case you would like to check it out: th-cam.com/video/VHKFLDjyBQI/w-d-xo.html
Very nice!!! can you teach us to insert pie charts in habit tracker
how to change the dollar sign?
Hi! You can send an email to hello@thinklikeagirlboss.com letting me know the currency symbol and I can have a file ready before you purchase 😊👩🏻💻✨
I've just purchased your sheet and I'm coming up against a problem (I think?). I have sinking funds and some of the expenses I'd be tracking would be paid from those sinking funds and not from my monthly income. How do I appropriately track those so that they're accounted for and that my sinking funds accounts are accurate? For example, next month I have to put new tires on my car. I've saved up for that in a sinking fund throughout the last year. When I go to pay for them, I'm pulling the money from that account, not from the funds from my paycheck. I'm worried that if I track in my expenses, it'll look like I'm going over budget when I'm really not.
Hi! You could "withdraw" money from the savings section by using negative numbers 😊👩💻✨
Would you mind sending an email to hello@thinklikeagirlboss.com if you have more questions about this? I sometimes don't get notifications for replies on comments 😊👩💻✨
Hi, I hope you could answer this question. I'm planning to sell spreadsheet template on esty. I wonder, how can I hide and secure the format of my digital products? Thanks in advance
Hi! Can you send me a DM on Instagram? 😊👩💻✨
Good morning,
Question is possible to export everything into Mircosoft Excel? Noticed the calendar function does not work. And some of the check boxes do not look the same as google sheets.
Hi! I use some Google Sheets features that are not compatible with excel so if you try downloading it there it will break. I'm sorry! It will only work as intended in Google Sheets 👩💻✨
Wow, amazing! I'm on your etsy shop, I see you have an annual one too, do I need a monthly one if I get the annual?
Hi! Thank you!! You can totally choose just one, you can watch both videos and decide what fits your needs best 😊👩💻✨ Please let me know if you have any questions about them 😊
@@thinklikeagirlboss okay thank you! I totally didn't see the annual video glad you mentioned it!
Please let me know which one you like better! 😊👩💻✨
I really love your spreadsheet since it helped me have more visibility into my money flow. I just have one question: where do I keep track of my credit card bill? I understand that expenses is the amount I incurred, but would the credit card fall under Bill & Subscription section, or Debt?
Hi! There's no one specific way to do it, as long as numbers match and you don't duplicate any information you can do whatever makes sense to you. I've seen people use negative numbers to remove amounts from the expenses they plan on paying next month and then use the debt or bill section to pay that the next month. I tried to make it as flexible as possible so you could use whatever section makes sense to you 😊👩🏻💻✨
can i chnage the currency? and how do I do this?
Hi! To change the currency in Google Sheets you can select groups of cells you want to change and then click on FORMAT -> NUMBER. Then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊
If you have any issues along the way you can contact me and I'll help you 😊👩💻✨ (email or Etsy because I don't always get the TH-cam notifications)
How do you tracker credit card debt?
Hi! There's no one specific way to do it, as long as numbers match and you don't duplicate any information you can do whatever makes sense to you. I've seen people use negative numbers to remove amounts from the expenses they plan on paying next month and then use the debt or bill section to pay that the next month. I tried to make it as flexible as possible so you could use whatever section makes sense to you 😊👩💻✨
I may have missed it but can I change the currency?
Hi! You can email me before your purchase and I'll have the currency you need ready 😊👩🏻💻✨
This is incredible! Thank you so much. Just purchased on Etsy 😊 what would you do in the case where you have a few annual subscriptions? What would be the best way to incorporate those into this budget system? Thanks again
Hi! Thank you!! You could keep them in a separate tab and add them to their corresponding months whenever you are setting up a new month. Please let me know if this helps! 😊👩💻✨
@@thinklikeagirlboss That helps a lot! Thank you. I randomly came across your channel, and I'm so glad I did. Amazing content :)
Thank you so much!! I'm so happy you like it!! 😊👩💻✨
Hi tanks for triste hard work. Yesterday il made à purchase of your product following thé link in the bio.i have not received thé order confirmation, neither the link to dowload it. Is it normal ?
Hi! It should arrive almost instantly, do you mind messaging me on Etsy? If you can't find the email I'll send it to you manually 😊👩💻✨
@@thinklikeagirlboss OK.i try to message through your Etsy
Do you have a tutorial how to do this?
Hi! I just met your channel and i love it. Are you going to update this sheet so we can analyze it from a year view? If it is please let mi know! I will appreciate it. If it's not Do you have any video where I can learn how to do it?
Hi! I don't have one yet but I will be making a new annual version this year 😊👩💻✨
Hi! are we able to change the dollar sign to our own currency at all? x
Hi! To change the currency you can select groups of cells you want to change and then click on FORMAT -> NUMBER then you can choose either CURRENCY and select a country or you can choose CUSTOM CURRENCY and then have more flexibility over how you want your numbers to look 😊
If you run into any issues, you can let me know and I can help you do it 😊👩💻✨
Hi, I’m from Philippines and I really wanted to avail this one but I don’t know how 😢
how would you incorporate using sinking funds with this template? ☺️
Hi! You could use the savings section for that 😊👩💻✨
How do I change the month?
Hi! You can set the month on cell B4 and the year on cell D4 👩🏻💻✨
Can you show how to create templates(from Scratch) similar to what you have above?
Hi! Right now I have one video that shows how to create some of the features in this template in case you would like to check it out 😊👩🏻💻✨ th-cam.com/video/He5cJ33CRu4/w-d-xo.html
I need this in excel so bad! I know there’s tools to convert google sheets to excel but I’ve heard that some functions won’t work :( Do you know if that’s the case for this? I really love Excel and I want this budget spreadsheet so bad!!! but I’m not a fan of google sheets😭
Hi! There's several features that I don't think will be compatible, I'm sorry!! I'm actually the other way around 👩💻✨ I love Google Sheets I do everything there. I'm sorry!! ✨
That’s okay! I love this so much I guess I’ll just learn google sheets haha. I appreciate you answering, I’m going to purchase the spreadsheet now🤩
I'm so happy to hear that!! Please let me know if you need any help with it 😊👩💻✨ I answer faster on Etsy or email 😊✨
Hello, your template was incredible! I tried crafting something similar, but it just didn't come together. I was wondering if you offer any paid courses or guidance on creating these kinds templates. I saw your video on 'How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL,' which was great, but I'm specifically interested in learning how to build such templates. Can you help me with this?
Hi! Thank you so much! I don't currently have any paid courses but I would love to make them in the future 😊👩🏻💻✨
Hii!! I really love your planner. I've been really curious how you automate your day entry and automatically change to the same date. I would really appreciate your response. Thank you! 💛
Hi! You mean the part where you enter just the day and it forms a date?
@@thinklikeagirlboss Hi Im interested how you did this, I love your tracker so much!
@thinklikeagirlboss yes! If it's alright with you to share your knowledge about it? whether in a short clip, tiktok, or story. We will be greatly appreciative and be happy to support your future contents. ✨️🥰
I'm sorry for the late reply! I'm not sure why but I don't get notifications for replies just the first comment.
What I do is use the DATE(year, month, day) formula. The year and month come from what the user set for the sheet in general and the day comes from the day the user set for each transaction.
The "tricky" part is figuring out the month number based on the month text selected from the dropdown. You could use the VLOOKUP formula for example, to pull that value from a hidden table. I think I could include this in one of my tutorials in the future 😊👩🏻💻✨
@@thinklikeagirlboss I see. I'll go google it and see how it works. I really want to learn so much and thank you for this. Because of you, I am eager to learn more about forming formulas and functions. I hope you more blessings on your career. ^^