Budgeting

Monthly budget burn-down chart in Google Sheets

Build a monthly budget burn-down chart in Google Sheets with daily spend, remaining budget and an ideal line to check your pace mid-month.

Editorial illustration for Monthly budget burn-down chart in Google Sheets

A budget burn-down chart plots how much of your monthly budget is left each day, alongside a straight line showing how much should be left if you spent evenly. If your actual line sits below the ideal line, you are spending faster than planned. Here is how to build one in Google Sheets with a handful of formulas.

What do you need before you start?

  • A sheet called Txns with a date in column A and the amount in column C, one row per spend.
  • A flexible monthly budget. Leave out rent and EMIs, which are paid early in the month and would make the line fall off a cliff on day 1.
  • The first day of the month you want to chart.

How do you set up the sheet?

On a new sheet, put these settings in H1 to H4.

  • H1: the flexible budget, for example 36000.
  • H2: the first day of the month, for example 1 November 2026, entered as a date.
  • H3: the days in the month, =DAY(EOMONTH($H$2,0)).
  • H4: today's day number, =TODAY()-$H$2+1.

Then set up columns, with headings in row 1 and days 1 to 30 (or 31) in A2 downwards.

ColumnHeadingFormula in row 2
ADay1, then 2, 3 and so on
BActual remaining=IF(A2>$H$4,NA(),$H$1-E2)
CIdeal remaining=$H$1-$H$1/$H$3*A2
DSpent that day=SUMIFS(Txns!$C$2:$C$1000,Txns!$A$2:$A$1000,$H$2+A2-1)
ECumulative spend=SUM($D$2:D2)

Copy each formula down to the last day of the month. The NA() in column B stops the actual line at today, because Google Sheets charts leave a #N/A point blank instead of drawing it as zero.

How do you draw the chart?

  1. Select A1 to C31, which covers Day, Actual remaining and Ideal remaining.
  2. Choose Insert, then Chart.
  3. Pick a line chart in the chart editor. Check that column A is used as the labels along the bottom.
  4. Title it with the month, and set the vertical axis to start at 0.

You will see a falling actual line and a straight ideal line from the full budget down to zero on the last day.

How do you read it?

Say the budget is ₹36,000 for a 30-day month, so the ideal pace is 36,000 divided by 30, which is ₹1,200 a day. On day 12 you have spent ₹17,000 so far. Actual remaining is 36,000 minus 17,000, which is ₹19,000. Ideal remaining is 36,000 minus 12 times 1,200, which is 21,600. You are ₹2,600 below the ideal line, which means ahead of the spending pace.

At that rate, 17,000 divided by 12 is about ₹1,417 a day, so a 30-day month would end at about ₹42,500, which is ₹6,500 over. To finish on budget you would need to average 19,000 divided by 18, about ₹1,056 a day for the remaining 18 days. These figures are made up, but the method is the same for yours.

What if your spending is irregular?

Most households spend more on weekends and at the start of the month. A straight ideal line is a simplification, so treat a small gap as normal and watch for a gap that keeps widening for several days. You can also replace the ideal line with last month's actual line to compare like for like.

When does a sheet stop being enough?

Copying transactions into the Txns sheet every few days is the weak point. If that becomes a chore, SpendixAI lets you import statements as PDF, CSV or Excel and set budgets, so your spending is already organised. You can still download a CSV if you want to keep your chart.

A short routine

  • Update the Txns sheet twice a week.
  • Glance at the chart on the 10th, the 20th and the last week.
  • If you are below the ideal line, pick one flexible category to hold back.
  • At month end, save a copy of the chart for comparison next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports