Black Friday sales make it very easy to "save" money right up until December's card statement arrives. A simple spreadsheet fixes most of that. Here is a build-it-yourself version that works in Google Sheets or Excel in about 15 minutes.
1. One table for every gift
Create a sheet called Gifts with these columns:
| A: Person | B: Gift idea | C: Budget | D: Actual price | E: Bought? | F: Store / deal link |
|---|
Make column E a checkbox (Google Sheets: Insert → Checkbox; Excel 365: Insert → Checkbox, or just type TRUE/FALSE).
2. A small dashboard
On a second sheet called Dashboard:
Total budget =SUM(Gifts!C2:C200) Spent so far =SUMIF(Gifts!E2:E200,TRUE,Gifts!D2:D200) Left to spend =B1-B2 Gifts still to buy =COUNTIFS(Gifts!A2:A200,"<>",Gifts!E2:E200,FALSE) Days to Christmas =DATE(YEAR(TODAY()),12,25)-TODAY() SUMIF only counts gifts you actually bought, so "Spent" never includes items you are just watching.
3. Turn over-budget gifts red
Select Gifts!D2:D200 → Format → Conditional formatting → custom formula:
=AND(D2<>"",D2>C2) Pick a red fill. Now any gift that costs more than you planned jumps out before you check out.
4. Track Black Friday deals without impulse buying
Add three more columns to Gifts: G: Normal price, H: Deal price, I: Saving %.
I2 =IF(AND(G2<>"",H2<>""),1-H2/G2,"") Format I as a percentage. Rule of thumb I use: only buy if the gift is already on the list and the saving is real (compare against the normal price you wrote down before the sale started).
5. Per-person totals
Need to know you spent 3× more on one kid than the other? On the dashboard:
=QUERY(Gifts!A2:D200,"select A, sum(C), sum(D) where A is not null group by A label sum(C) 'Budget', sum(D) 'Spent'",0) (Excel: use a PivotTable with Person as rows and Budget/Actual as values.)
That's it
Five formulas and one conditional format cover 90% of holiday budgeting. If you would rather not build it, I put a ready-made version (dashboard, deal tracker, per-person view, works in Excel and Google Sheets, no macros) here: Holiday Gift & Budget Planner.
Happy (and solvent) holidays!
