How to Create a Bills & Subscriptions Tracker - FREE Tutorial - Google Sheets Template - Spreadsheet
thinklikeagirlboss
@thinklikeagirlbossAbout
Hi! I'm Pao. I build cool Spreadsheets that help make life easier ππ©π»βπ»β¨ One of my biggest passions in life is finding ways to make things more efficient. My go-to method for achieving this is what I like to call the "think once and never again method". Basically, if I find myself thinking about the same things over and over again, just to get something done, I STOP, I take a step back and create a process I can follow. I make sure to do all the "hard thinking" at the beginning, so that afterwards I can just breeze through this process effortlessly as many times as I need to. Over the years, I've turned those processes into the spreadsheets you can find on my website. I really hope you like them and find them useful! ππ©π»βπ»β¨ Shop Spreadsheets: https://thinklikeagirlboss.com/ Free Templates and Tutorials: https://thinklikeagirlboss.com/pages/free-youtube-tutorials
Latest Posts
Video Description
In this video I'm going to show you how you can use Google Sheets to create a Mini Bills and Subscriptions Tracker from scratch. I hope you like it! ππ©π»βπ»β¨ If you were able to build the entire template by yourself, please let me know in the comments. I would love to hear about it! π π *Get the FREE template:* https://optimistic-apple-336.myflodesk.com/mini-bill-tracker Please note: The template is sent automatically to your email (donβt forget to check your promotions folder). It should arrive within a few minutes, if it doesnβt please send an email to [email protected] TIMESTAMPS 00:00 Intro 03:19 Tutorial Starts 03:49 Date Picker 05:56 Basic Layout 07:49 Full Date Formula - option 1 16:59 Full Date Formula - option 2 20:59 Layout 23:08 Amount Paid Formula 31:53 Totals 33:16 Making it pretty 38:14 Scratching effect 41:53 Final Touches β»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈβ»οΈ β¨ You might also like β¨ π *More FREE resources:* https://thinklikeagirlboss.com/pages/free-youtube-tutorials π *Shop Templates:* https://thinklikeagirlboss.com Whether you're looking to boost your productivity, manage your money, or organize your home and daily life, these templates have you covered! π Meal Planner + Automated Grocery List: https://thinklikeagirlboss.com/products/meal-planner-premium-edition π Monthly Budget Spreadsheet: https://thinklikeagirlboss.com/products/monthly-budget-spreadsheet-v2 π Monthly Planner: https://thinklikeagirlboss.com/products/monthly-planner-v1-pink π Social Media Content Planner: https://thinklikeagirlboss.com/products/simple-social-media-content-calendar π Brain Dump and Idea Tracker: https://thinklikeagirlboss.com/products/brain-dump-idea-tracker-v1 π *Google Sheets Course - How to Create a Daily Schedule Template:* https://thinklikeagirlboss.thinkific.com/courses/daily-schedule-tutorial-google-sheets I love spending my days creating spreadsheets, so stay tuned for more! HAPPY PLANNING! Pao ππ©π»βπ»β¨ #googlesheets #tutorial #personalfinance #moneymanagement
Upgrade Your Everyday
AI-recommended products based on this video
Amazon Echo Show 8 (newest model), With Spatial Audio, Smart Home Hub, and Alexa, Charcoal
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Wireless Earbuds, Bluetooth 5.4 Headphones, True Wireless Stereo Earphones with IPX7 Waterproof, Noise Cancelling Mic, Fast Charging and Comfort Fit Ear Buds for Sports/Workouts - Black
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Smart Watch for Men/Women, 1.95" AMOLED Fitness Tracker Watches with Bluetooth Calls/Flashlight/100+ Sport Modes Heart Rate/Sleep Monitor Ultra Lightweight Ultrathin Design
Smart Watch for Men Women (Answer/Make Call), 1.96" HD Smartwatch Fitness Activity Tracker, 110+ Sports IP68 Waterproof, Heart Rate/Sleep Monitor/Pedometer/Calories, Fitness Watch for Android iOS
![Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/61nNNMI1cFL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
![Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/6105jZyXyPL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
NOCO Boost GB40: 1000A UltraSafe Jump Starter β 12V Lithium Battery Booster Pack, Portable Jump Box, Power Bank & Jumper Cables - for 6.0L Gas and 3.0L Diesel Engines
UGREEN Nexode Power Bank 20000mAh 130W Portable Charger 72Wh PD Fast Charging 3-Port USB C Battery Pack with TFT Smart Display for MacBook/iPad/iPhone 16/Samsung S24 and More
ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More
VOLTME Portable Charger, Slim 10000mAh 5V/3A Power Bank, USB C in&Out High-Speed Charging Battery Pack, Travel Essentials Dual Output Compatible with iPhone 16 15 14 13 12 Samsung Google iPad etc
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Bose QuietComfort Bluetooth Headphones, Wireless Headphones with Active Over Ear Noise Cancelling and Mic, Deep Bass, Up to 24 Hours of Playtime, White Smoke
Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (Black)
Eye Contact Web Camera for Desktop Computer β 1080P USB Camera with Microphone & Stand, Center Cam for Laptop or Desktop, Manual Focus, Plug & Play for macOS & WindowsοΌBlackοΌ
![PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]](https://m.media-amazon.com/images/I/61PnVkv6KKL._AC_UL960_FMwebp_QL65_.jpg)
PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]
![Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film](https://m.media-amazon.com/images/I/815keamN-BL._AC_UL960_FMwebp_QL65_.jpg)
Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film
