Check funeral food charges against the actual order ledger
This calculator reconciles food, drink and shop supplies ordered for a funeral in Korea against delivery records, approved returns and an invoice.
When relatives take turns hosting visitors, initial orders, later deliveries and opened packages can be recorded differently.
Using a consistent package unit for each item makes quantity and amount differences easier to discuss with the facility.
Use the funeral cost calculator for a broader planning estimate.
Here, the main result checks items already ordered, while the budget for additional visitors is a separate scenario.
Record the facility and document-check date, and compare documents covering the same event and services.
Amounts are entered in Korean won using actual tax-inclusive prices; the calculator does not supply nationwide prices or statutory refund rates.
1. Match the item and package unit first
Food, drinks and shop supplies
Group cooked dishes, rice cakes and fruit as food; water and other beverages as drinks; and disposable supplies as shop items.
These groups organize subtotals and do not determine return eligibility.
Use separate rows when the same product has different package sizes or prices.
Billing unit and package contents
Describe the actual ordering unit, such as one tub, bag or carton.
The price must be the tax-inclusive price for one such unit.
Do not multiply carton quantities by a bottle price.
Enter servings per package when you want to include that item in the additional-order scenario.
Published hospital package sizes are facility-specific examples.
A 30-serving package at one hospital does not establish the ordering unit elsewhere.
Package counts must be whole numbers; if a special agreement charges fractional packages, confirm a consistent billing unit with the provider first.
2. Keep orders, cancellations and opened packages separate
- Initial and additional orders: enter the cumulative quantities without counting both a revised total and its underlying additional-order slips twice.
- Cancellation before delivery: enter only packages cancelled before supply.
Items already supplied and then sent back belong in the returns fields.
- Opened packages: count every delivered package that was opened, whether fully consumed or subsequently requested for return.
- Unopened packages: these equal delivered packages minus opened packages.
Remaining stock is not automatically an approved return.
For example, 10 initial packages plus 2 additional packages minus 1 cancellation before delivery gives 11 delivered packages.
If 8 were opened, 3 remain unopened.
Entering the cancelled package again as a return would deduct it twice, so compare the entries with the delivery record.
3. A return request is different from an approved return
Only approved return quantities reduce the settlement
If you request a return of 3 unopened packages and the facility approves 2, only 2 are deducted.
The remaining package and its value are shown as an unapproved request for follow-up.
The records and the provider must establish whether that request is pending or rejected.
Record opened-package requests and approvals separately from unopened returns.
An approved opened return can be entered only when the opened-return condition is confirmed as ‘yes’.
Entering an approved quantity while the condition is ‘unknown’ or ‘no’ produces an error.
For each state, approved returns cannot exceed requests, and requests cannot exceed the packages in that state.
Do not extend a shop-supply return notice to all cooked dishes, rice cakes or fruit.
Keep the return date, quantity and provider confirmation, and check whether the approved deduction appears on the invoice.
4. Quantity and settlement formulas
- Delivered packages = initial orders + additional orders − cancellations before delivery
- Billable packages = delivered packages − approved unopened returns − approved opened returns
- Item amount = billable packages × tax-inclusive unit price
- Total = food + drinks + shop supplies + separate charges − agreed discount
- Balance = calculated total − amount prepaid
- Amount difference = original invoice total − calculated total
Enter the actual agreed tax-inclusive separate charges and discount.
Avoid adding a service charge already included in the unit price or deducting the same discount twice.
The calculator does not apply a tax rate, so first obtain the final tax-inclusive unit price if the document only lists a pre-tax amount.
The original invoice total must be the amount before deducting the prepayment.
A prepayment is money already paid, rather than a discount on the cost, and is deducted once when calculating the balance.
If prepayments exceed the calculated total, the negative balance is retained for discussion with the facility; it does not establish an automatic refund.
5. Illustrative example: a KRW 300,000 total
All quantities and prices below are fictional teaching inputs, not market averages or hospital prices.
For food, assume 10 initial packages, 2 additional packages, 1 cancellation before delivery and 8 opened packages.
Of 3 unopened packages requested for return, 2 are approved.
For drinks, assume 20 initial packages, 10 opened packages and approval for 8 of the 10 unopened packages requested for return.
Illustrative food and drink quantities, approved returns and calculated charges in KRW| Item | Delivered | Approved returns | Billable | Unit price | Amount |
|---|
| Food | 11 | 2 | 9 | 30,000 | 270,000 |
| Drinks | 20 | 8 | 12 | 2,000 | 24,000 |
The item subtotal is KRW 294,000.
Adding KRW 10,000 in separate charges and subtracting a KRW 4,000 agreed discount gives KRW 300,000.
A KRW 100,000 prepayment leaves a KRW 200,000 balance.
An original invoice total of KRW 320,000 produces a +KRW 20,000 difference.
The unapproved food request is worth KRW 30,000, and the 2 unapproved drink packages are worth KRW 4,000.
That KRW 34,000 is not an approved refund and is not deducted again from the total.
Approved return deductions total KRW 76,000: KRW 60,000 for food and KRW 16,000 for drinks.
They are already reflected in the item amounts above.
Because unapproved return requests remain in this example, settlement confirmation is on hold.
KRW 300,000 is the calculated total using current approvals, rather than a final settlement with every return issue resolved.
6. Additional-visitor budgets remain separate scenarios
Round additional orders up to whole packages
Additional packages = ceil(max(0, additional visitors − confirmed usable remaining servings) ÷ servings per package)
Additional budget = additional packages × the same item’s tax-inclusive unit price
For the fictional food item, suppose each package supplies 10 servings and you have directly confirmed 3 usable servings remaining.
An additional 25 visitors create a shortfall of 22 servings.
Rounding 22 ÷ 10 up gives 3 packages and a KRW 90,000 additional budget at KRW 30,000 each.
This is not automatically added to the KRW 300,000 settlement above.
Each selected item uses the same additional-visitor count, so choose whether that item is needed for every additional visitor.
The calculator does not assess food hygiene, storage or reuse safety.
Only enter remaining servings that have been directly confirmed as usable.
Obtain separate confirmation of any additional service charges and do not assume future returns will be accepted.
7. A practical reconciliation sequence
- Collect the initial and additional order slips, cancellation confirmations and delivery records from both the kitchen and shop.
Match each item name and package unit.
- Confirm opened and unopened quantities with the provider, then record requested and approved returns separately.
- Check unit prices, separate charges, agreed discounts and prepayment receipts.
Enter invoice quantities and the original invoice total for the same scope.
- Resolve invalid quantity relationships first.
For unconfirmed evidence, review the provisional calculations alongside the reasons settlement confirmation is on hold.
- Mark quantity and amount differences on the original documents, then use the TXT export or printed result in discussion with the provider.
After editing an input, recalculate instead of relying on the earlier result.
The example-loading button is for learning how the calculator works; replace fictional values with actual records before checking a real bill.
The facility name and document-check date help relatives identify which version they reviewed.
8. Interpret differences and unresolved records
Positive, zero and negative differences
Quantity difference means invoiced packages minus calculated billable packages.
A positive amount difference means the original invoice is larger; a negative difference means the calculated total is larger.
Zero means the arithmetic agrees for the entered scope, not that every contract term or supporting record has been verified.
Missing confirmation and inconsistent quantities
When prices, return evidence or invoice scope remain unconfirmed, read the reference figures together with the hold reasons.
Cancellations exceeding orders or opened quantities exceeding deliveries are errors.
Check the original records rather than replacing an impossible value with zero, which would hide the discrepancy.
The ledger is also useful when kitchen and shop returns are approved at different times, or one relative has prepaid separately.
Update the affected item when approval changes, and keep prepayment receipts separate from discounts.
Check whether a remaining difference comes from an unapplied return or another service before asking for a corrected statement.
9. Scope and limits to check before use
- Use actual tax-inclusive whole-won amounts.
No nationwide prices, refund percentages or statutory tax rates are applied automatically.
- The calculator supports up to 30 items, monetary inputs up to KRW 1,000,000,000 and quantity inputs up to 1,000,000.
These are input safeguards, not legal or contractual limits.
- If a price changes during the event, use separate rows for the applicable orders without recording the same package twice.
- Correct negative values, fractional package counts and discounts exceeding the pre-discount total before proceeding.
- The result does not determine legal refund rights, unlawful overcharging or food hygiene and safety.
Use differences as evidence to discuss with the provider.
10. Frequently asked questions
Can all unopened food be returned?
Check the facility and item-specific conditions.
A notice about shop supplies does not establish return eligibility for cooked food.
Deduct only the quantity actually approved.
What if a requested return has not been approved?
Record the requested quantity and enter only confirmed approvals in the approved field.
Unapproved request amounts remain follow-up items and do not reduce the total.
Can an approved opened package be deducted?
Yes, when the item’s opened-return condition is confirmed as ‘yes’ and the actual approval quantity is entered.
An approved quantity with an ‘unknown’ or ‘no’ condition is treated as an error.
Can I record a delivered item sent back as a cancellation?
The cancellation field is only for cancellations before supply.
Use return request and approval fields for delivered items to avoid double deductions and inconsistent quantities.
Is the additional-visitor budget included in the settlement?
It is shown separately as a scenario.
Update the actual order ledger after an additional order is confirmed, and recheck usable remaining servings and servings per package.
Does a KRW 20,000 difference mean an immediate refund?
It is the difference between the original invoice and the total calculated from your inputs.
Missing charges or approval timing can also explain it.
Discuss the delivery, return and discount evidence with the provider first.
What happens when prepayments exceed the total?
The negative balance is retained as a reference for a refund discussion.
It does not promise a refund; also check whether the prepayment covers other services.
Can I use package sizes or prices from a public hospital page?
Public pages help explain item units and service scope.
Confirm the actual package size, tax-inclusive price and return conditions at the facility you are using before entering them.
11. Official sources and verification date
The official pages were checked on 2026-11-18.
No page revision or effective dates were displayed, so the retrieval date is not a policy effective date.
These sources establish facility-specific units and service information; they do not establish nationwide return rules or fixed prices.
- Daejeon Eulji University Hospital funeral services: distinguishes kitchen services from shop supplies; its unopened-item return and refund notice appears under the shop section.
- Korea Cancer Center Hospital restaurant and shop: describes additional orders, supply, returns and settlement, and permits return of remaining shop supplies.
Opened items, partial returns and refund units require individual confirmation.
- Asan Medical Center funeral food services: lists differing units such as rice at 6kg/30 servings, soup at 8kg/30 servings and kimchi at 4kg.
This page does not provide verified prices or return rules for this calculator.
12. Review the result with the original invoice
Start with actual orders and approved returns, then reconcile billable quantities item by item.
For remaining differences, take the delivery slips, return approvals, tax-inclusive price list, discount agreement and prepayment receipts to the kitchen or shop contact.
Ask for the calculation basis, update the ledger and check date when corrected records arrive, and share the final review with the relative responsible for payment.