Expected Payments
R3,458,900
Total budgeted
Actual Payments
R2,847,500
Total paid
Variance
R611,400
17.7% under budget
Reconciled
82%
289 of 352 payments
Payment Reconciliation by Category
| Category | Expected | Actual Paid | Outstanding | Variance | Reconciled | Status |
|---|---|---|---|---|---|---|
|
Flights 24 payments |
R1,245,800 |
R1,156,800 |
R89,000 |
-R89,000 -7.1% |
|
Good |
|
Accommodation 18 payments |
R842,600 |
R758,100 |
R84,500 |
-R84,500 -10.0% |
|
Good |
|
Transport 32 payments |
R456,300 |
R398,200 |
R58,100 |
-R58,100 -12.7% |
|
Fair |
|
Food & Beverage 45 payments |
R342,800 |
R289,400 |
R53,400 |
-R53,400 -15.6% |
|
Fair |
|
Vouchers 12 payments |
R286,400 |
R245,000 |
R41,400 |
-R41,400 -14.5% |
|
Fair |
|
Tour Guides 8 payments |
R185,000 |
R185,000 |
R0 |
R0 0.0% |
|
Perfect |
|
Other 15 payments |
R100,000 |
R15,000 |
R85,000 |
-R85,000 -85.0% |
|
Poor |
|
Total |
R3,458,900 |
R2,847,500 |
R611,400 |
-R611,400 -17.7% |
|
Fair |
Group Budget Tracking
| Group | Budget | Spent | Remaining | Progress | Status |
|---|---|---|---|---|---|
|
European Explorer 2025 #GRP-2025-001 • 45 pax |
R1,245,800 |
R1,089,200 |
R156,600 12.6% left |
|
On Track |
|
Cape Town Adventure #GRP-2025-002 • 28 pax |
R842,600 |
R758,100 |
R84,500 10.0% left |
|
On Track |
|
Safari Experience #GRP-2025-003 • 32 pax |
R956,400 |
R998,200 |
-R41,800 4.4% over |
|
Over Budget |
|
Garden Route Tour #GRP-2025-004 • 22 pax |
R414,100 |
R2,000 |
R412,100 99.5% left |
|
Just Started |
Supplier Reconciliation Status
| Supplier | Total Paid | Outstanding | Last Recon | Status | Actions |
|---|---|---|---|---|---|
|
South African Airways Flights • 24 transactions |
R1,156,800 |
R89,000 |
2025-01-10 5 days ago |
Reconciled | |
|
Grand Hotel Paris Accommodation • 18 transactions |
R758,100 |
R84,500 |
2025-01-08 7 days ago |
Pending | |
|
Table Mountain Tourism Vouchers • 12 transactions |
R245,000 |
R41,400 |
2024-12-28 18 days ago |
Overdue |