A Cape Town daily average hides the choices that drive cost: neighbourhood, room type, rental car, peninsula day, restaurants and paid attractions. Build the budget from the itinerary.
All amounts in this worksheet are blanks by design. Enter South African rand, the source and quote date. Convert only after the rand total is visible.
Accommodation row
- nightly room or apartment: R__________
- taxes and cleaning: R__________
- breakfast not included: R__________
- parking: R__________
Use the final checkout price, not the search-card rate. Divide one-time cleaning across the number of nights.
Keep refundable and non-refundable versions separate.
Airport and arrival row
- airport transfer: R__________
- late arrival or waiting: R__________
- first meal: R__________
- SIM or connectivity: R__________
Cape Town Tourism publishes transport context, but the live fare belongs to the operator. Ask the property about the exact pickup.
Do not count the arrival day as a full activity day.
Local transport row
Choose car hire, public transport, taxis, guided transport or a mix.
For car hire, add base rate, excess reduction, fuel, parking, tolls and one-way fees. For taxis, estimate each fixed journey. For public transport, check current routes and final service.
A low room rate far from the itinerary can raise this row every day.
Food row
Separate breakfast, lunch, dinner, drinks and groceries. Use menus from places the route can realistically reach.
- breakfast: R__________
- lunch: R__________
- dinner: R__________
- drinks and water: R__________
Do not publish one restaurant's menu as a city average. Add service and tip according to local practice and the actual bill.
Attraction row
Use official sources for Table Mountain Cableway, museums, SANParks and tours. Record ticket type and date.
- cableway or mountain plan: R__________
- museum cluster: R__________
- park or peninsula fees: R__________
- guided activity: R__________
Read weather and cancellation terms. A closed attraction can create another transport cost even when the ticket moves.
Peninsula or winelands row
A major day outside the central city may use a rental car, guide or tour. Compare complete costs and included admissions.
Add meals, tasting where relevant, parking and driver hours. Never mix driving and alcohol.
Keep the peninsula and winelands as separate day types rather than averaging both into every day.
Weather contingency row
Set aside an amount for changed transport, indoor tickets or a moved booking. This is a reserve, not a predicted expense.
- contingency: R__________
Do not assume insurance covers ordinary bad weather. Read the policy.
A flexible ticket may reduce the reserve needed.
Fixed trip costs
Visa where applicable, travel insurance, international flights and long-distance transport do not become daily expenses merely because they are divided by nights.
List them separately so the on-the-ground daily number remains useful. Then create a full-trip total.
Currency conversion, bank fees and card holds need their own lines.
Work one labelled example
Suppose a traveller enters a room, two local rides, three meals and one attraction. The sheet totals those current quotes for that day. Another day with a peninsula tour will be higher; a neighbourhood day may be lower.
Do not replace the blanks with invented market numbers. Update from current official tickets, property totals and real menus.
The value of the worksheet is variation, not a single answer.
Before booking, test the worksheet with three accommodation areas. Recalculate transport rather than copying one daily allowance. A higher central room can lower repeated rides, while a remote resort can make meals and transfers compulsory.
Add payment timing. Record deposits, card holds, final balances and refundable deadlines. Cash needed on arrival should remain separate from prepaid costs. Do not count a refundable security hold as spending, but ensure the card limit can support it.
After the trip, compare planned and actual by category. Keep one traveller's result as a case, not a city average. Update public prices only from current primary or supplier sources and retain the verification date.
Final total
Create low, planned and contingency totals using the same itinerary. Mark every estimate and its source date.
Recheck attraction tickets, room balance and transport before the cancellation deadlines. Keep receipts during the trip and compare actual spending by category.
A Cape Town budget becomes credible when each cost follows a choice. "Per day" is the result, not the input.
For a group, separate shared vehicle and accommodation costs from per-person tickets and meals. State the number of travellers used in the division. A family room and two standard rooms are different products even when the nightly total is similar.
Track cash flow as well as total cost. Deposits may be due months before travel, while park tickets and meals are paid locally. Record the date and payment method for each balance so card limits and currency needs are visible.
Before publication, test every attraction and transport URL. If the official price is unavailable, leave the worksheet blank or label a dated supplier quote. Do not copy a competitor's daily budget to fill the space.
Sources
- Cape Town Tourism: Getting around, accessed 12 August 2026.
- Table Mountain Aerial Cableway: Ticket prices, accessed 12 August 2026.
- SANParks: Tariffs, accessed 12 August 2026.
Filed under