Pre-event Sales (customers table)
(These are the pre-event currencies set in the customers table.)
Standard Currency: $0.00 (P)
VIP Currency: $0.00
Total: $0.00 (A)
Pre-event Sales (customers_qr table – claimed)
(These are the claimed pre-event currencies from the customers_qr table.)
Standard Currency: $0.00 (Q)
VIP Currency: $0.00
Total: $0.00 (B)
Pre-event Sales (customers_qr table – unclaimed)
(These are the unclaimed pre-event currencies from the customers_qr table.)
Standard Currency: $0.00
VIP Currency: $0.00
Total: $0.00
Activation Fee Sales
Cash: $2,815.00
Credit Card: $9,112.50
Other: $0.00
Total: $11,927.50
Currency Sales
(These totals do not include the Pre-event Sales or Activation Fee Sales figures, above.)
Other Pre-event Currency: $0.00
Cash: $95,069.50 (R1)
Credit Card: $359,851.00 (R2)
Standard Currency: $0.00
VIP Currency: $0.00
Total: $454,920.50
Currency Refunds
Cash: $856.00 (S1)
Credit Card: $775.00 (S2)
Standard Currency: $0.00
VIP Currency: $0.00
Pre-event Currency: $0.00
Total: $1,631.00
Net currency sales: $453,289.50 (C)
Currency Removals
(Unlike currency refunds, currency removals do not affect the report figures.)
Standard currency removed from wristbands: $0.00
VIP currency removed from wristbands: $0.00
Product Sales
(These are the totals from the product_sales_items table.)
Total paid with standard currency: $271,853.50 (T)
Total paid with VIP currency: $0.00
Total paid with entitlements – priced: $0.00
Total paid with entitlements – units: 0 ($0.00)
Total sold: $271,853.50
Product Refunds
(These are the totals from the product_refunds_items table.)
Total refunded to standard currency: $58.00 (U)
Total refunded to VIP currency: $0.00
Total refunded to entitlements – priced: $0.00
Total refunded to entitlements – units: 0 ($0.00)
Total refunded: $58.00
Net product sales: $271,795.50 (D)
Wristband Leftovers
Total standard currencies calculated from transactions: $181,494.00 (E)
Total VIP currencies calculated from transactions: $0.00
VIP Summary
(The VIP issued pre-event figure is the total of claimed VIP currencies from the customers_qr table, plus the total of all pre-event VIP currencies from the customers table.)
VIP Issued
VIP issued pre-event: $0.00
VIP during event: $0.00
Total VIP issued: $0.00
VIP Used
Total product purchases from VIP: $0.00
Total product refunds to VIP: $0.00
Net purchases made with VIP currency: $0.00
Entitlements Summary
Entitlements – Priced
Issued: $0.00
Purchases: $0.00
Refunds: $0.00
Net purchases: $0.00 (G)
Entitlements – Units
Issued: 0
Purchases: 0 ($0.00)
Refunds: 0 ($0.00)
Net purchases: 0 ($0.00) (H)
Entitlements – Combined
Purchases: $0.00
Refunds: $0.00
Net purchases: $0.00 (I)
Standard currencies breakage – new calculation: $0.00 ([P + Q] + [R – S] – [T – U] – E)
