To invoice a live-sale buyer, start with accepted order lines, add shipping once, apply any agreed discount once, and subtract payments you have actually confirmed. Do not total every comment: duplicates, cancellations, and waitlisted claims need to be resolved first.
The following fictional example was created by PC Wise AI to make the calculation checkable. It illustrates a merchandise-and-shipping tally; tax and fee lines are not included in these example amounts.
Disclosure: PC Wise AI sells the optional template linked below. The example and invoice format on this page can be used without purchasing it.
1. Freeze the accepted order lines
Give each buyer an ID and keep the price that was accepted for each item. Export or copy a dated version of the accepted ledger before sending totals. If an order changes afterward, issue a new invoice version so that the buyer is not looking at two unexplained amounts.
| Buyer | Item | Quantity | Unit price | Line amount |
|---|---|---|---|---|
| BUY01 | A01 pouch | 2 | USD 12.00 | USD 24.00 |
| BUY01 | B02 tote | 1 | USD 18.00 | USD 18.00 |
| BUY03 | A01 pouch | 1 | USD 12.00 | USD 12.00 |
BUY01’s merchandise subtotal is 24 + 18 = USD 42.00. BUY03’s is USD 12.00. Those buyer subtotals must add up to the merchandise ledger total of USD 54.00.
2. Keep order-level adjustments outside item rows
In this example, BUY01 has an agreed USD 5.00 order discount, USD 4.00 shipping, and a confirmed USD 10.00 payment. BUY03 has USD 4.00 shipping and has not paid. Shipping is entered once per buyer’s shipment, not copied onto every item row.
| Calculation | BUY01 | BUY03 |
|---|---|---|
| Merchandise subtotal | USD 42.00 | USD 12.00 |
| Order discount | − USD 5.00 | USD 0.00 |
| Shipping | + USD 4.00 | + USD 4.00 |
| Invoice total | USD 41.00 | USD 16.00 |
| Confirmed payment | − USD 10.00 | USD 0.00 |
| Balance due | USD 31.00 | USD 16.00 |
If your actual sale has additional charges or taxes, add the applicable amount as a separate labelled line. Confirm those amounts before sending the final total; do not hide them in the item price calculation.
3. Send a versioned, itemised message
Here is a copyable format using BUY01’s figures. Replace the deadline and payment instructions with your actual agreed terms before sending it.
Invoice: LIVE-20261001-BUY01-v1 Buyer: BUY01 A01 pouch: 2 x USD 12.00 = USD 24.00 B02 tote: 1 x USD 18.00 = USD 18.00 Merchandise subtotal: USD 42.00 Agreed order discount: -USD 5.00 Shipping: USD 4.00 Invoice total: USD 41.00 Payment already confirmed: USD 10.00 Balance due: USD 31.00 Payment deadline: [insert agreed deadline and time zone] Payment method/reference: [insert verified details] Please reply if an item or quantity is incorrect before paying.
Check the buyer’s account before sending the message. Keep the sent version alongside the order record. If a quantity changes, record the reason and send v2 that explicitly replaces v1.
4. Reconcile payment without counting it twice
A payment ledger should identify the buyer, receipt reference, date, amount, and the invoice it settles. In the example, the existing USD 10.00 payment is already deducted. When BUY01 pays another USD 31.00, total confirmed payments become USD 41.00 and the balance becomes zero.
If the buyer’s transfer name differs from the account name, keep it unallocated until you can match the amount and receipt reference. If someone overpays, keep the negative balance visible for review instead of silently changing it to zero. Record refunds separately, including whether they were completed.
5. Make the batch totals agree
- Merchandise USD 54.00 − discounts USD 5.00 + shipping USD 8.00 = USD 57.00 invoiced.
- USD 57.00 invoiced − USD 10.00 already received = USD 47.00 outstanding.
- The two buyer balances are USD 31.00 + USD 16.00 = USD 47.00.
If these totals disagree, look for duplicated shipping, a payment counted in two places, or cancelled rows still included in the subtotal before asking buyers to pay.
Where the order ledger fits
This invoice method assumes claims and cancellations have already been resolved. Use the live-selling claim and inventory example to set up that earlier step.
A normal spreadsheet is sufficient for this small example. Our paid Live Selling Order & Inventory Tracker is an optional starting point; review its current product description against your own workflow before buying.
Updated October 1, 2026: added the complete invoice arithmetic, a message format, partial-payment treatment, and batch checks.
답글 남기기