Google Sheets Budget Tracker Formulas

Savings goals, expense caps, and budget meters for finance tabs.

Savings goal percent bar

Put saved in A1 and savings goal in B1. Piggy blocks track your goal percent.

=REPT("🐷",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&ROUND(A1/B1*100,0)&"% saved"

🐷🐷🐷🐷🐷🐷○○○○ 62% saved

REPT ROUND MIN MAX

Income vs expense bar

Put income in A1 and expenses in B1. Dollar blocks show surplus left after bills.

=IF(A1>=B1,REPT("💵",MIN(10,MAX(0,ROUND((A1-B1)/A1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((A1-B1)/A1*10,0)))))&" surplus","⚠️ overspent")

💵💵💵💵💵💵░░░░ surplus

IF REPT MIN MAX ROUND

Monthly budget remaining

Put spent in A1 and monthly budget in B1. Blocks show budget left this month.

=REPT("█",MIN(10,MAX(0,ROUND((B1-A1)/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((B1-A1)/B1*10,0)))))&" $"&MAX(0,B1-A1)&" left"

███████░░░ $420 left

REPT ROUND MIN MAX

Tax refund countdown

Put days until refund in A1. Hourglasses count down to refund day.

=REPT("⏳",MIN(A1,5))&" "&A1&" days to refund"

⏳⏳⏳ 3 days to refund

REPT MIN

Estimated tax owed meter

Put tax owed in A1 and safe harbor in B1. Red blocks rise as owed tax climbs.

=REPT("🔴",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" tax owed"

🔴🔴🔴🔴🔴🔴░░░░ tax owed

REPT ROUND MIN MAX

Profit margin display

Put profit in A1 and revenue in B1. Shows margin percent with a chart emoji.

=IF(B1>0,ROUND(A1/B1*100,1)&"% margin 📊","—")

32.5% margin 📊

IF ROUND

Revenue cumulative counter

Put total revenue in A1. Money bags stack as cumulative sales grow.

=REPT("💰",MIN(10,MAX(1,ROUND(A1/1000,0))))&" $"&TEXT(A1,"#,##0")

💰💰💰💰💰 $12,500

REPT MIN MAX ROUND TEXT

Expense category mood

Put spend tier 1-5 in A1. Emoji mood reflects how painful the category feels.

=CHOOSE(A1,"😌 Essentials","🙂 Routine","😐 Meh","😬 Ouch","😱 Yikes")

😐 Meh

CHOOSE

Invoice paid status

Put 1 for paid or 0 for unpaid in A1. Quick invoice collection flag.

=IF(A1=1,"✅ Paid","📄 Unpaid")

✅ Paid

Cash flow arrow

Put net cash in A1. Up arrow for positive flow, down for negative.

=IF(A1>=0,"📈 Cash in +$"&A1,"📉 Cash out -$"&ABS(A1))

📈 Cash in +$850

IF ABS

Debt payoff snowball progress

Put paid down in A1 and total debt in B1. Snowballs melt debt blocks away.

=REPT("❄️",MIN(A1,B1))&REPT("🧊",MAX(0,B1-A1))&" $"&A1&" paid"

❄️❄️❄️❄️🧊🧊🧊 $4,000 paid

REPT MIN MAX

Emergency fund blocks

Put fund balance in A1 and three-month target in B1. Vault blocks fill the cushion.

=REPT("🏦",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" fund"

🏦🏦🏦🏦🏦🏦░░░░ fund

REPT ROUND MIN MAX

Subscription leak counter

Put active subscriptions in A1. Dripping taps count recurring leaks.

=REPT("🚰",MIN(A1,10))&" "&A1&" subs"

🚰🚰🚰🚰🚰 5 subs

REPT MIN

Net worth milestone stars

Put milestone tier 0-5 in A1. Stars celebrate each net worth checkpoint.

=REPT("⭐",MIN(A1,5))&REPT("☆",MAX(0,5-A1))&" net worth"

⭐⭐⭐☆☆ net worth

REPT MIN MAX

Expense category emoji picker

Put category 1-6 in A1. Rent, food, transport, fun, health, or misc.

=CHOOSE(A1,"🏠 Rent","🍔 Food","🚗 Transport","🎉 Fun","💊 Health","📦 Misc")

🍔 Food

CHOOSE

Financial health stars

Put health score 0-5 in A1. Stars rate your overall money picture.

=REPT("⭐",MIN(A1,5))&REPT("☆",MAX(0,5-A1))&" health"

⭐⭐⭐⭐☆ health

REPT MIN MAX

Side hustle income bar

Put side income in A1 and monthly target in B1. Laptop blocks track hustle revenue.

=REPT("💻",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" $"&A1

💻💻💻💻💻💻○○○○ $600

REPT ROUND MIN MAX

Tax deadline warning status

Put days until filing deadline in A1. Green, yellow, or red filing alert.

=IF(A1>30,"🟢 On track",IF(A1>7,"🟡 Due soon","🔴 File now"))

🟡 Due soon

Paycheck allocation bar

Put allocated dollars in A1 and paycheck in B1. Slices show where pay went.

=REPT("🍕",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" allocated"

🍕🍕🍕🍕🍕🍕🍕○○○ allocated

REPT ROUND MIN MAX

Budget burn rate meter

Put days left in month in A1 and budget percent used in B1. Flame tracks burn pace.

=REPT("🔥",MIN(10,MAX(0,ROUND(B1/10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(B1/10,0)))))&" "&B1&"% used"

🔥🔥🔥🔥🔥🔥░░░░ 62% used

REPT ROUND MIN MAX

Profit celebration burst

Put profit in A1 and target in B1. Beats target triggers a profit party row.

=IF(A1>=B1,"🎉 Profitable! 💰","📉 Below target")

🎉 Profitable! 💰

Cash reserve thermometer

Put reserve months in A1 (0-6). Thermometer blocks show runway cushion.

=REPT("🌡️",MIN(A1,6))&REPT("○",MAX(0,6-A1))&" "&A1&" mo runway"

🌡️🌡️🌡️🌡️○○ 4 mo runway

REPT MIN MAX

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

See membership options