Recording a Confirmed Refund Without Hiding the Original Purchase

This is an invented planning exercise, not a customer event or testimonial.

Background and constraints

A fictional mystery tea bought 90 GBP of materials and later received a confirmed 30 GBP refund for unopened items. The calculator accepts nonnegative actual costs, so the host needs a clear net-cost record.

Exact tool inputs

700

14

GBP

Room | 180 | 180
Food | 280 | 260
Materials net after refund | 100 | 60
Reserve | 140 | 0

Actual generated result

currency

GBP

rows

• category

  Room

  planned

  180

  actual

  180

• category

  Food

  planned

  280

  actual

  260

• category

  Materials net after refund

  planned

  100

  actual

  60

• category

  Reserve

  planned

  140

  actual

  0

total

700

planned

700

actual

500

remaining

200

unallocated

0

perGuest

35.714285714285715

overBudget

false

Planning process

The host enters 60 as the net actual material amount and explains the original 90 payment and 30 refund in project notes. Actual spending becomes 500, leaving 200. The row label makes clear that the amount is net of a refund rather than a lower original purchase.

Result explanation

The arithmetic 90 minus 30 equals 60 is preserved in the supporting note. A refund that is only requested would not justify this update. The remaining balance increases only after the host confirms the money was returned.

Alternative

Keep a separate transaction ledger outside the calculator if every payment and refund must be individually reconciled. Use BudgetBeacon as the category summary.

Execution notes

Never enter a negative actual category simply to force a preferred balance. Keep receipts and refund evidence according to the group’s real recordkeeping process.

Continue planning

Open BudgetBeacon

How to Create a Realistic Event Budget

Planning a Zero-Spend Gathering Without Dividing by Zero

FAQ