A Black Friday budget works best as a purchase plan, not a running total you check after the fact. Set one spending ceiling, name the items allowed to use it, and decide what price makes each one worth buying — all before you start browsing.
This planner deliberately stops at the moment of decision. Recording what happened afterwards — where the receipt lives, when the return window closes, whether the parcel arrived — is a different job with a different tool, and mixing the two produces a sheet that does neither well.
Quick answer: Make one row per possible purchase. Fill in the item, store, planned amount and a dated price-check note before you buy. At checkout, record the actual price, log a buy or skip decision, and update the running total against your ceiling. Then hand the completed rows to a post-purchase tracker.
1. Set One Ceiling Before You Browse
Consumer.gov's guide to making a budget describes a budget as a plan you write down, followed by recording what you actually spent and checking it against the plan. Applied narrowly here: choose the total available for this one shopping event rather than treating every offer as its own separate decision.
Start from money available after the obligations and priorities you have already set. Write that number down as the ceiling. Then list only items you would consider buying at any time of year. A price tag is not a need, and the discount on something you never wanted is not a saving.
Give each item a planned amount and leave a small unspent buffer. If you are also running the seasonal version of this, the Halloween budget template uses the same planned-versus-actual mechanic on a smaller occasion.
2. What Each Column Is For
Every field here is either an advance decision or the outcome of one. Nothing in this table needs information you only get after the parcel arrives.
| Field | What to enter | Why it belongs here |
|---|---|---|
| Item | A specific product, with size or model where it matters | Stops a vague category becoming three purchases |
| Store | The retailer you intend to check or buy from | Identifies whose terms apply |
| Planned amount | The maximum you chose for that row, set before checkout | Ties the item to the ceiling |
| Price check | A short dated note: price seen, item detail, where you checked | Documents the comparison behind the decision |
| Actual price | What you actually paid, if you bought | Lets you compare the outcome with the plan |
| Decision | Buy or skip, and one clause of reasoning | The output of the planner — and the row you learn most from |
| Running total | Cumulative actual spend against the ceiling | Makes the limit visible at the moment it matters |
3. Copy and Paste the Planner
Paste this into a spreadsheet and put your ceiling in a cell above it. Fill the first four columns before shopping and the last three as you decide. For the running total, use a cumulative sum of the actual-price column, such as =SUM($E$2:E2) filled downward.
| Item | Store | Planned amount | Price check | Actual price | Decision | Running total |
|---|---|---|---|---|---|---|
| Noise-cancelling headphones | Example Electronics | $120.00 | Nov 20: $149 displayed | $118.00 | Buy — under planned amount | $118.00 |
| Cordless drill | Example Hardware | $90.00 | Nov 21: $96, same as October | — | Skip — not a real discount | $118.00 |
Before confirming any purchase, compare the planned amount with the actual price and update the running total. If a row is over plan, do one of three things deliberately: use the buffer, cut another row to fund it, or skip. Do not quietly raise the ceiling — that is the one move that empties the whole exercise of meaning.
The skip rows are worth as much as the buy rows. A row reading "Nov 21: $96, same as October — skip" is the planner doing its actual job.
4. Do Not Buy Assuming You Can Return It
A return policy is a pre-purchase input, not a safety net to lean on. The FTC's guidance on holiday gift returns notes that return and exchange policies vary by store, that many stores will not take returns after a set period such as 30 or 90 days, and that policies and deadlines are often printed on the back of receipts. It also warns that without a receipt you should expect store credit, often at the lowest sale price.
That belongs in the decision column, not in a tracking column. If a purchase only makes sense because you assume you can undo it, that is a signal to skip, not a reason to buy. Deep-discount and clearance items are also the ones most likely to carry tighter or final-sale terms.
5. Hand the Rows Off Once You Have Bought
The moment a row says "buy", this planner has finished its job. What happens next — where the receipt lives, whether it shipped, when the return window closes — belongs in a post-purchase record.
Move each completed row into the holiday receipt and return tracker, which carries order numbers, delivery status, return-by dates and receipt locations. Keeping the two separate means the planner stays a decision tool and the tracker stays a record, instead of both becoming a half-version of the other. If a receipt goes missing before you get that far, the store-by-store lost receipt guide covers the recovery route for each major retailer.
Where ReceiptSync Fits
ReceiptSync is an independent receipt-capture and organization layer. It extracts the vendor, date, total, tax, payment method and category from a receipt photo, syncs that to Google Sheets, and exports PDF and Excel reports.
For this planner, it fills the actual-price column without manual typing and gives the handoff somewhere to land. Review the extracted information against the original receipt before relying on it. See how to scan receipts to Excel automatically.
Common Problems and How to Prevent Them
The Ceiling Exists Only in Your Head
Write the ceiling and the planned items down before comparing options. A written total is what shows you that an extra item has no assigned amount — memory will not do that at 6am on a Friday.
The Price Check Cannot Be Understood Later
Include the date, the product detail and the displayed price. Keep the note neutral and factual; avoid words like "lowest" or "guaranteed", which turn an ordinary comparison into a claim you cannot support.
Every Row Says Buy
If nothing was skipped, the planner was a shopping list with extra columns. The ceiling and the skip decisions are the parts doing the work.
The Sheet Is Never Reviewed Afterwards
Total the actual-price column against the ceiling once the event is over and write one line about what you would change. That is the whole review, and it is what makes next year's ceiling a realistic number instead of a guess.
Final Takeaway
The point of a Black Friday budget is not to document every offer you saw. It is to make each purchase intentional and then get out of the way. A row that starts with a planned amount and a price check and ends with a buy-or-skip decision against a running total gives you exactly that — and once you have bought, the record belongs somewhere else.
Also in this series: the holiday receipt and return tracker for what happens after checkout, the Halloween budget template for a smaller occasion, and the Google Sheets budget template for the monthly view.
Capture the receipts your plan turns into purchases — start free →