How To Create Expenses Tracker in Google Sheets From Scratch ♡ For Beginners

Рет қаралды 67,299

Күн бұрын

I hope you enjoyed this video about creating an expenses tracker in Google Sheets! After watching this video, I hope this budget spreadsheet will help you stay on top of your finances! If you liked this video, check out how to create a habit tracker in Google Sheets: • How To Create Habit Tr...
EXPENSES TRACKER TEMPLATE: docs.google.com/spreadsheets/...
🌠GET MY FREE 5 STEP GUIDE TO ACCOMPLISHING YOUR GOALS 👉🏼 www.subscribepage.com/v2s9h8
0:00 - Adding text in Expenses Tracker
2:21 - Adding Difference Formula in Google Sheets
3:20 - Setting Budget Percentages
5:12 - Adding Planned Google Sheets Formula
5:40 - Calculating Totals in Expenses Tracker
7:15 - Adding a Chart in Google Sheets
9:12 - Customizing Expenses Spreadsheet
11:08 - How to Use Expenses Spreadsheet
12:25 - Get my Free Google Sheets Expenses Tracker Template
❤ Check out more Google Sheets videos from me:
CREATE A HABIT TRACKER IN GOOGLE SHEETS: • How To Create Habit Tr...
SET UP A WEEKLY MEAL PLANNER IN GOOGLE SHEETS: • How I Meal Plan for On...
🙋🏼‍♀️ Who is Anyusha?
My name is Anna, and I am here to teach & inspire you how to get your life & business organized, reach your goals and get WAY more done than you ever thought you were even capable of. 🏹 I make videos about productivity, planning, and goal setting with the help of digital tools & apps.🌷
If you want to increase your productivity with the creation of a digital project planning setup and reach the goals you have set for your business or personal life, without feeling overwhelmed, consider subscribing & stay tuned! :)
🌠 Do you want to reach your biggest goals within half the time & need help setting up an organized digital planning system? Apply for my 1:1 program: www.imanyusha.com/work-with-me
🌠5 Step Guide To Accomplishing Your Goals 👉🏼 www.subscribepage.com/v2s9h8
💌 SAY HI ON INSTAGRAM: an.yusha?h... 💌
💼 Tools I use & love!
*Camera: amzn.to/3mbcoP8
*ClickUp (link includes 20% off paid plans⭐): clickup.com/?fp_ref=anyusha31...
*Headphones: amzn.to/3uW6Bjh
*Tripod ring light: amzn.to/3lkqj4W
*Softbox lighting kit: amzn.to/3FEVaS3
*Camera microphone: amzn.to/3aA8IQt
*Clip-on microphone: amzn.to/3uTdu4J
*Laptop: amzn.to/3iJyV38
📚 Books I recommend reading!
*The Miracle Morning by Hal Elrod: amzn.to/3BrAsCi
*Atomic Habits by James Clear: amzn.to/3mAOWtt
*The Power of Habit by Charles Duhigg: amzn.to/3oID4Z6
*Deep Work by Cal Newport amzn.to/3iIvE4u
*Getting Things Done by David Allen: amzn.to/3BoCT8T
🚀 WEBSITE: www.imanyusha.com
➡ SUBSCRIBE: / anyusha
Note this description contains affiliate links: I may earn minimal sums for every purchase at no additional cost to you. You are in no way obligated to use these links, however, it does support this channel 🙂
#ExpensesTracker #GoogleSheets #Anyusha

Пікірлер: 47

@Anyusha 2 жыл бұрын

One of my focuses starting this month was to budget more, so I figured I'd share how I'm going to track my expenses! What do you want to save up for this year? 💸

@Sin12ful Жыл бұрын

You've been really helpful for me. I'd love to see a Bi-Weekly expense form since I'm paid every 2 weeks. Also, the example you showed us here, what's the easiest way to copy that format to another tab or sheet for the next month? Thanks again!

@bre7766 4 ай бұрын

this was very helpful, thank you for the template & video! :)

@cindyhalvorson2572 2 жыл бұрын

Thanks so much for the template! Saved me lots of time. 🙂

@Anyusha 2 жыл бұрын

Happy to hear Cindy 😄

@nothingtoseehere3581 2 ай бұрын

Thank you so much!! This saves me a lot of time :))) I'll surely watch another videos of yours!!

@alinacirneala3616 2 жыл бұрын

Love it! I will surely start using this spreadsheet format

@Anyusha 2 жыл бұрын

🙈🙈❤️

@Alonso.Barbieri Жыл бұрын

Gracias por el contenido! Saludos desde Chile

@Backzinho.fast.89 Жыл бұрын

Loved the simple explanations. Thx

@Anyusha Жыл бұрын

No probs :)

@superduper5698 Жыл бұрын

This is a great tracker thank you for providing a template!

@Anyusha Жыл бұрын

No problem Squidward! hope this helps you with your expenses! 😉

@emilykaelyn9875 Жыл бұрын

So helpful!!! I have been trying to make my own tracker and don't know a thing about google sheets. Thank you for the free copy of it

@Anyusha Жыл бұрын

No problem at all! I'm glad I could help 🥰

@leslyramirez1896 2 жыл бұрын

Super helpful, thank you!

@Anyusha 2 жыл бұрын

You're welcome Lesly!

@brightworld007 Жыл бұрын

i really appreciate your work.

@Anyusha Жыл бұрын

Thank you so much! I appreciate you :)

@hanapikopi Жыл бұрын

this helped so much. i wanted to use google sheets for a different purpose but i had no idea what to do and where to start. now i feel like a google sheet pro.

@Anyusha 7 ай бұрын

Yay! That's great to hear! 💕

@user-rn3fj8fy1h Жыл бұрын

Hi thank you for sharing the sheet! Do you put the salary amount to the sheet?

@user-su3er1mn9y 10 ай бұрын

So awesome! thanks for sharing

@Anyusha 7 ай бұрын

Thanks so much for watching

@mostafaeltriki 2 жыл бұрын

Amazing video Thank you

@Anyusha 2 жыл бұрын

Glad you enjoyed it!! :)

@saraj396 2 жыл бұрын

This is a very useful expense spreadsheet😊

@Anyusha 2 жыл бұрын

Thanks so much Sara! ☺️

@QVx_7997 2 жыл бұрын

thnx its really helpful video..

@Anyusha 2 жыл бұрын

anytime! :)

@mashai1161 2 жыл бұрын

So awesome!

@Anyusha 2 жыл бұрын

Thank you! :)

@vanessabarrera7826 Жыл бұрын

Thank youu!!!

@Anyusha Жыл бұрын

No problem Vanessa!!

@kassadayj Жыл бұрын

How do you save it and fill it out

@shelenehaynes660 Жыл бұрын

what's the coding for the asset????

@Kali-Ikigai Жыл бұрын

Helpful video but it could have been better if you slowed down and explained how to create the formulas in more detail. Beginners will struggle to follow as you go along

@muhammaduawwal5013 Жыл бұрын

The screen is not clear enough

@shinalee4725 Жыл бұрын

Did not understand the part adding percentage . Wish a formula was given. If you have no basic knowledge of google sheets video was hard to follow

@TheOriginalOrkdoop Жыл бұрын

I don't understand a lot of this. 3:45 "go through each category and just add the percentage" how do you add percentages, what's the formula? 5:14 "add this formula in each cell but change the numbers" specifically what cells? C6? and what numbers did you change? The section "how to use the spreadsheet" 11:08 you are creating a new spreadsheet instead of using the one you just made? why?

@pas178 7 ай бұрын

Yes I agree the video is kind of hard to follow allow with. This is what I figured out after watching it 3 times on the slowest speed. (If you still want to make the spreadsheet): 3:45 to add the percentage type the percentage bottom on the keyboard then go to cells number formula and scroll till you find percentage. On iPad it's where you change your font color. 5:14 the formula is Amount for month - (amount for month * the percentage number you put in that percent box, she just had us make, for the corresponding category) 11:08 No she isn't creating a new spreadsheet she is just saying she has a notes page. She uses to write down everything she spends in a week. So she can add all the actual numbers up in the spreadsheet we just made. I hope this helps 😊