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

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

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

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

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

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 📊

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

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

Invoice paid status

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

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

✅ Paid

IF

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

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

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

Subscription leak counter

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

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

🚰🚰🚰🚰🚰 5 subs

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

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

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

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

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

IF

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

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

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! 💰

IF

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

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.

Unlock playground
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.