========================================
Dashboard Calculations Verification
========================================

1. TRANSACTION COUNTS
----------------------
Total Transactions: 477
Pesapal Transactions: 5
Completed Transactions: 457
Event Transactions (type 1): 411

2. BOOKING COUNTS
------------------
Total Bookings: 13
Pesapal Bookings: 5
Completed Bookings: 10
Pesapal Completed Bookings: 5

3. BOOKINGS WITHOUT TRANSACTIONS
-----------------------------------
Bookings without transactions: 0
✓ All completed bookings have transactions

4. EARNING CALCULATIONS
------------------------
Total Revenue: 278004.97
Total Earning: 61048.5
Expected Revenue (from bookings): 845.91000557691
Expected Earning (from transactions): 60073.47999457

5. ORGANIZER BALANCES
----------------------
✓ Organizer ID 23: Balance correct (468.44)
✓ Organizer ID 24: Balance correct (0)
✓ Organizer ID 25: Balance correct (266)
✓ Organizer ID 26: Balance correct (0)
✓ Organizer ID 27: Balance correct ()
✓ Organizer ID 28: Balance correct ()
✓ Organizer ID 29: Balance correct ()
✓ Organizer ID 30: Balance correct ()
✓ Organizer ID 31: Balance correct (4.75)
Total Organizer Balance: 739.19

6. MONTHLY PROFIT CALCULATIONS (Current Year)
-----------------------------------------------
Monthly profits for 2026:
  Feb: 0.50000000745058

7. PESAPAL SPECIFIC DATA
-------------------------
Pesapal bookings with transactions: 5
Pesapal bookings total: 5
✓ All Pesapal bookings have transactions

8. TRANSACTION PAYMENT STATUS FORMAT
--------------------------------------
Payment status distribution:
  '1': 457 transactions
  '2': 6 transactions
  '0': 14 transactions

========================================
SUMMARY
========================================
✓ Transaction counts: OK
✓ Booking counts: OK
✓ All bookings have transactions: OK
✓ Earning calculations: Check values above
✓ Organizer balances: Check values above
✓ Monthly profits: Check values above
✓ Pesapal integration: OK