How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL Budget Spreadsheet

thinklikeagirlboss β€’ January 25, 2023
Video Thumbnail
thinklikeagirlboss Logo

thinklikeagirlboss

@thinklikeagirlboss

About

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

Video Description

In today's tutorial I will show you how to create this simple Income and Expense tracker from scratch in Google Sheets. You will be able to: - Add your Income Sources - Register Income Transactions that will be added up in their corresponding Income Source - Add Expense Categories - Register Expense Transactions that will be added up in their corresponding Expense Categories You will also be able to compare expected/budget amounts vs actual amounts. Finally, you will create a summary showing your Income and Expense totals and how much money you have left for the corresponding month. πŸ“Œ Get the FREE template: https://tinyurl.com/wjmbektp 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] πŸ“Œ Shop Spreadsheets: https://thinklikeagirlboss.com πŸ“Œ Need a more advanced version? Check out the FULL 12 Month Income and Expense Tracker: https://youtu.be/VHKFLDjyBQI I decided to create something a bit more elaborate than usual and I would love to know your thoughts! Was it too easy? Was it too hard? Please let me know! πŸ˜ŠπŸ‘©πŸ»β€πŸ’»βœ¨ #personalfinance #googlesheets #moneymanagement #tutorial

You May Also Like

Upgrade Your Gaming Setup Now

AI-recommended products based on this video

Loading...
acer Nitro V 15 Gaming Laptop, Intel i9-13900H Up to 5.4GHz, GeForce RTX 4060, 15.6" 144 Hz IPS Display, 64 GB DDR5, 4 TB SSD, Wi-Fi 6, Backlit Keyboard, Windows 11 Pro, Gaming Mouse, 256GB UFD

acer Nitro V 15 Gaming Laptop, Intel i9-13900H Up to 5.4GHz, GeForce RTX 4060, 15.6" 144 Hz IPS Display, 64 GB DDR5, 4 TB SSD, Wi-Fi 6, Backlit Keyboard, Windows 11 Pro, Gaming Mouse, 256GB UFD

(2,753)
$1,899.99
FREE delivery Tomorrow, Jun 12Arrives before Father's Day
Loading...
acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

(0)
$1,769.99
FREE delivery Jun 17 - 20
Loading...
acer Nitro V16 Gaming Laptop, 8-Core AMD Ryzen 7 8845HS Up to 5.10 GHz, 16" WUXGA 165Hz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Wi-Fi 6E, Backlit Keyboard, MS Office Lifetime & Win11 Pro

acer Nitro V16 Gaming Laptop, 8-Core AMD Ryzen 7 8845HS Up to 5.10 GHz, 16" WUXGA 165Hz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Wi-Fi 6E, Backlit Keyboard, MS Office Lifetime & Win11 Pro

(48)
$1,769.99
FREE delivery Tomorrow, Jun 12Arrives before Father's Day
Loading...
acer Nitro V16 Gaming Laptop, 16" WUXGA 165Hz Display, 8-Core AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Office Lifetime License, Win11 Pro

acer Nitro V16 Gaming Laptop, 16" WUXGA 165Hz Display, 8-Core AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Office Lifetime License, Win11 Pro

(988)
$1,769.99
FREE delivery Tomorrow, Jun 12Arrives before Father's Day
Loading...
Lenovo ThinkPad E14 Gen 5 Business Laptop (14" FHD+ Anti-glare, Intel 10-Core i7-1355U, 40GB RAM, 1TB SSD) Backlit, Fingerprint, Fast Charge, 1080p RGB Webcam, Wi-Fi 6, Win 11 Pro w/ Copilot

Lenovo ThinkPad E14 Gen 5 Business Laptop (14" FHD+ Anti-glare, Intel 10-Core i7-1355U, 40GB RAM, 1TB SSD) Backlit, Fingerprint, Fast Charge, 1080p RGB Webcam, Wi-Fi 6, Win 11 Pro w/ Copilot

(12)
$899.99
FREE delivery Wed, Jun 18
Loading...
Lenovo IdeaPad 15.6" FHD Touchscreen Laptop (40GB RAM, 1TB SSD, Intel 6-Core i3-1215U (> i5-1135G7)), Narrow Bezel, Webcam, 10-Hour Long Battery Life, Wi-Fi 6, Win 11 Home S Mode, Cloud Grey

Lenovo IdeaPad 15.6" FHD Touchscreen Laptop (40GB RAM, 1TB SSD, Intel 6-Core i3-1215U (> i5-1135G7)), Narrow Bezel, Webcam, 10-Hour Long Battery Life, Wi-Fi 6, Win 11 Home S Mode, Cloud Grey

(32)
$499.99
FREE delivery Wed, Jun 18
Loading...
Lenovo V15 Laptop | 15.6" FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB PCIe SSD | HDMI | Type-C | Webcam | Wi-Fi | THUNDEROBOT Wireless Ergonomic Mouse | Windows 11 Pro | Black

Lenovo V15 Laptop | 15.6" FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB PCIe SSD | HDMI | Type-C | Webcam | Wi-Fi | THUNDEROBOT Wireless Ergonomic Mouse | Windows 11 Pro | Black

(26)
$649.00$636.02
FREE delivery Jun 18 - 23
Loading...
Lenovo 15.6" Laptop, Intel 10-Core i7-13620H (Beat Ultra 7 255U), 40GB DDR4 RAM, 2TB PCIe SSD, WiFi 6, Bluetooth 5.2, FHD Computer for Business & Student, RJ45, Type-C, HDMI, Windows 11 Pro, Wendbo

Lenovo 15.6" Laptop, Intel 10-Core i7-13620H (Beat Ultra 7 255U), 40GB DDR4 RAM, 2TB PCIe SSD, WiFi 6, Bluetooth 5.2, FHD Computer for Business & Student, RJ45, Type-C, HDMI, Windows 11 Pro, Wendbo

(11)
$899.00
FREE delivery Jun 18 - 23
Loading...
UGREEN USB C Hub 10Gbps, 4 Ports USB 3.2 HUB with 2 USB-C 3.2 and 2 USB-A 3.2, USB Port Extender for MacBook Pro, MacBook Air, Acer Aspire, HP Laptops, iPad Pro, iPhone 15/15 Pro Max and More

UGREEN USB C Hub 10Gbps, 4 Ports USB 3.2 HUB with 2 USB-C 3.2 and 2 USB-A 3.2, USB Port Extender for MacBook Pro, MacBook Air, Acer Aspire, HP Laptops, iPad Pro, iPhone 15/15 Pro Max and More

(1,021)
19.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
50+ bought in past month