Pre-event Sales (customers table)
(These are the pre-event currencies set in the customers table.)
Standard Currency: 0 (P)
VIP Currency: 0
Total: 0 (A)
Pre-event Sales (customers_qr table - claimed)
(These are the claimed pre-event currencies from the customers_qr table.)
Standard Currency: $17,042.00 (Q)
VIP Currency: 0
Total: $17,042.00 (B)
Pre-event Sales (customers_qr table - unclaimed)
(These are the unclaimed pre-event currencies from the customers_qr table.)
Standard Currency: $5,182.00
VIP Currency: 0
Total: $5,182.00
Activation Fee Sales
Cash: $4,242.00
Credit Card: $78,366.00
Other:
Total: $82,608.00
Currency Sales
(These totals do not include the Pre-event Sales or Activation Fee Sales figures, above.)
Other Pre-event Currency:
Cash: $97,437.00 (R1)
Credit Card: $1,576,472.00 (R2)
Standard Currency:
VIP Currency: $131,413.00
Total: $1,805,322.00
Currency Refunds
Cash: $357.00 (S1)
Credit Card: $3,492.00 (S2)
Standard Currency:
VIP Currency:
Pre-event Currency:
Total: $3,849.00
Net currency sales: $1,801,473.00 (C)
Currency Removals
(Unlike currency refunds, currency removals do not affect the report figures.)
Standard currency removed from wristbands:
VIP currency removed from wristbands: $1,378.50
Product Sales
(These are the totals from the product_sales_items table.)
Total paid with standard currency: $1,606,147.70 (T)
Total paid with VIP currency: $118,276.10
Total paid with entitlements - priced: 0
Total paid with entitlements - units: 0 (0)
Total sold: $1,724,423.80
Product Refunds
(These are the totals from the product_refunds_items table.)
Total refunded to standard currency: $222,835.00 (U)
Total refunded to VIP currency: $59.00
Total refunded to entitlements - priced: 0
Total refunded to entitlements - units: 0 (0)
Total refunded: $222,894.00
Net product sales: $1,501,529.80 (D)
Wristband Leftovers
Total standard currencies calculated from transactions: (E)
Total VIP currencies calculated from transactions:
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
VIP during event: $131,413.00
Total VIP issued: $131,413.00
VIP Used
Total product purchases from VIP: $118,276.10
Total product refunds to VIP: $59.00
Net purchases made with VIP currency: $118,217.10
Entitlements Summary
Entitlements - Priced
Issued: 0
Purchases: 0
Refunds: 0
Net purchases: 0 (G)
Entitlements - Units
Issued: 0
Purchases: 0 (0)
Refunds: 0 (0)
Net purchases: 0 (0) (H)
Entitlements - Combined
Purchases: 0
Refunds: 0
Net purchases: 0 (I)
Standard currencies breakage - new calculation: $303,789.30 ([P + Q] + [R - S] - [T - U] - E)
