Budget vs actual tracking puts what you planned to spend next to what you spent, by category and month, with the difference in dollars and percent. If your receipts are rows in a spreadsheet, one SUMIFS formula fills the actual column and two short formulas give the variance.
The useful part is what the table shows. In our example, the monthly total looked steady while 12 of 15 category-months missed the budget by more than 10%.
The setup: receipts, a budget and one formula
This is an example on synthetic data: 20 made-up receipts from April to June 2026, totaling $2,034.43, in the same nine-column layout we use in other posts. The monthly budget is made up too: saas $300, restaurant $80, rideshare $40, office $50 and hardware $100, so $570.00 a month and $1,710.00 a quarter. Within plus or minus 10% counts as on budget.
Paste the receipt rows into a sheet named receipts, with date in column A, total_amount in C and category in F. On a second sheet, put the category in column A, the first day of the month in column B and the budget in column C. Then the actual for that row is:
=SUMIFS(receipts!C:C, receipts!F:F, A2, receipts!A:A, ">="&B2, receipts!A:A, "<"&EDATE(B2,1))
Variance is =D2-C2 and percent is =E2/C2. This is standard spreadsheet SUMIFS. We tested it in LibreOffice Calc, and its results matched our script to the cent for all 15 rows.
The 15-row budget vs actual table
| category | month | budget | actual | variance | % | status |
|---|---|---|---|---|---|---|
| saas | April | $300.00 | $584.16 | +$284.16 | +94.7% | over |
| saas | May | $300.00 | $311.50 | +$11.50 | +3.8% | on |
| saas | June | $300.00 | $125.00 | -$175.00 | -58.3% | under |
| restaurant | April | $80.00 | $18.47 | -$61.53 | -76.9% | under |
| restaurant | May | $80.00 | $181.32 | +$101.32 | +126.6% | over |
| restaurant | June | $80.00 | $146.69 | +$66.69 | +83.4% | over |
| rideshare | April | $40.00 | $24.83 | -$15.17 | -37.9% | under |
| rideshare | May | $40.00 | $19.42 | -$20.58 | -51.4% | under |
| rideshare | June | $40.00 | $41.19 | +$1.19 | +3.0% | on |
| office | April | $50.00 | $67.34 | +$17.34 | +34.7% | over |
| office | May | $50.00 | $0.00 | -$50.00 | -100.0% | under |
| office | June | $50.00 | $53.21 | +$3.21 | +6.4% | on |
| hardware | April | $100.00 | $0.00 | -$100.00 | -100.0% | under |
| hardware | May | $100.00 | $156.88 | +$56.88 | +56.9% | over |
| hardware | June | $100.00 | $304.42 | +$204.42 | +204.4% | over |
The total looks steady; the categories do not
Monthly totals were $694.80 in April, $669.12 in May and $670.51 in June, against $570.00. Read alone, that says you run a little over every month. The category rows say something else: only 3 of 15 landed within 10% (saas in May, rideshare and office in June), 6 were over and 6 were under. Overs in one category hid unders in another.
Three kinds of miss, three responses
Timing. SaaS in April was +$284.16 (94.7%), mostly one Amazon Web Services bill of $428.17. SaaS in June was -$175.00. The spend moved between months; it did not grow. Leave it, or budget that category by quarter.
One-off. The biggest single miss was hardware in June, +$204.42 (204.4%). It is one Best Buy receipt for $214.99. Without it, June hardware was $89.43, under budget. Note it in the notes column and move on.
A real pattern. Restaurant was over two months running: +$101.32 in May and +$66.69 in June. That is the one that looks like a habit, not an accident. Either rebudget it or change the spending.
Monthly view to spot it, quarterly view to judge it
| category | quarter budget | quarter actual | variance |
|---|---|---|---|
| saas | $900.00 | $1,020.66 | +$120.66 |
| restaurant | $240.00 | $346.48 | +$106.48 |
| rideshare | $120.00 | $85.44 | -$34.56 |
| office | $150.00 | $120.55 | -$29.45 |
| hardware | $300.00 | $461.30 | +$161.30 |
| total | $1,710.00 | $2,034.43 | +$324.43 |
Over the quarter, the example ran +$324.43 over budget, about 19%. Hardware and saas look worse by quarter than their causes deserve, because a one-off purchase and a timing shift sit inside them. Restaurant is the overage that a new budget should absorb. Rideshare and office came in under.
Tax in or out
We also ran the table on pre-tax amounts (total minus tax_amount). At a 10% band, none of the 15 over, on or under calls changed. That is one example, so do not read more into it: pick totals or pre-tax amounts and stay consistent.
Getting the receipts into rows
Slipsheet turns uploaded receipt photos and PDFs, plus receipts forwarded by email on paid plans, into rows in one nine-column CSV: date, merchant, total_amount, currency, tax_amount, category, client_tag, notes and file_name. That is the layout the SUMIFS above reads. Slipsheet does not build budgets or variance reports; the budget and the formulas live in your spreadsheet. Google Sheets sync is on Pro. Starter is $5 a month for 250 receipts and Pro is $12 a month for 1,500, with a 14-day free trial and no card.
More on the receipt side: how to turn receipts into a spreadsheet and how to organize receipts by category.
FAQ
What is budget vs actual tracking?
It is a table that puts what you planned to spend next to what you did spend, for each category and period, with the difference in dollars and percent. Receipts supply the actual column. A budget vs actual view tells you where the plan was wrong, not just whether the total went over.
What formula do I use for budget vs actual in a spreadsheet?
Use SUMIFS to add up actual spend for one category within one month, then subtract the budget. With receipts in a sheet called receipts, date in column A, total in C and category in F, the actual is the SUMIFS shown above; variance is actual minus budget and percent is variance divided by budget.
What variance should count as on budget?
Pick a band and keep it. We used plus or minus 10% in this example. Small categories swing in percent from a single receipt, so read the dollar variance too. In May, a $40 rideshare budget missed by $20.58, a 51% miss that is rarely worth a meeting.
Should I budget with or without sales tax?
Pick one and stay consistent. In this example, switching from totals to pre-tax amounts (total minus tax) did not change any of the 15 over, on or under calls at a 10% band. That held for this data set; check your own before you rely on it.