Merchandise settlement workbook

A clear starting point.

Made for

Merchandise managers, tour managers, venue sellers, and finance reviewers

When to use it

After each show or selling session, once sales, refunds, fees, and tender reports are confirmed.

What is included

• ✓Item sales with refund and discount checks
• ✓Entered commission basis, tax, fees, and artist balance
• ✓Cash, card, and other receipt variance

How to use this template

Fill the PDF fields, save a copy, and reopen it to confirm your entries before printing or sharing. Use a desktop PDF reader if your browser does not save fields correctly. Use a referenced attachment when more space or additional terms are needed. Excel entry cells are unlocked; formulas, labels, and sheet structure are protected. Excel calculates totals; the PDF requires manual calculation and review. Start another copy when all rows are used.

1. 01Use one currency. Enter units before returns, gross unit price, refunds, and discounts by item / price; enter 0 where none applies. Reference sales reports.
2. 02Enter included tax, the contract-approved commission basis and rate, and approved fees. Use 25% for a 25 percent rate. Attach the agreed basis calculation.
3. 03Enter net cash excluding opening float, card receipts before processor fees, and other receipts, all after refunds. Resolve the collection variance.
4. 04Enter prior remittances and review the signed balance, deductions, and evidence together. The PDF is for manual completion; calculations run in Excel.

A show-level reconciliation aid, not a tax return or payment authorization. Do not count refunds or fees twice. Handle cross-show returns and unusual adjustments in a separately reviewed calculation.

Complete and share this original UPP form for your production work. Keep UPP wording and branding intact. Check the requirements for your project before use. Content use permissions.