Monthly Tour Profit Calculator
Monthly Tours Profit Calculator
Why Busy Months Still Lose Money
The problem
- Everything can look successful on the surface. Full dates, steady bookings, happy guests, and glowing reviews all point to a “great” month — at least at first glance.
- But the bank balance never quite catches up. You work harder each month, yet there’s still too little left to hire help, reinvest, or pay yourself properly.
What’s really happening
- Margins are quietly eaten away across the whole month. OTA commissions, discounts, low-occupancy tours, extra staff, and “free” inclusions slowly erode profit.
- A busy schedule can still be underpriced or underfilled. Several tours running below ideal guest numbers can drag down the whole month, even if a few tours perform well.
- A full month of departures can hide a weak business model. Top-line revenue looks strong while net profit stays flat or even slips into loss.
What this calculator shows
- The exact point where your monthly tour schedule breaks even. You see when the month stops just covering costs and starts generating real profit.
- How much profit your tours actually produced this month. Total net income, total tour costs, gross profit, and true monthly margin — in one place.
- How pricing, occupancy, commissions, and volume affect your margin. Change any one of them and see how it shifts your monthly result.
What you can do next
- See which tours carry the month and which ones drag it down. Use revenue per guest, cost per guest, and profit per guest to spot winners and troublemakers.
- Know what to fix right now. Adjust pricing, review OTA commissions, refine inclusions, or cut low-performing departures.
- Move from busy and stretched to consistently profitable. Run months where “fully booked” also means “financially healthy.”
How to Use This Calculator
- Tour costs only — not company P&L. This calculator tracks income and costs for your tours only. Do not include company salaries, office rent, or overhead that lives outside your tour operations. It is not a company profit & loss statement.
- Start at the top. Enter your business name, select the month and year, and type in the total number of guests you served that month across all tours.
- Income — Direct Bookings first. Enter the total you received directly (website, phone, walk-ins, repeat guests).
- Income — OTA Bookings. Enter each OTA platform on its own line — type the platform name, the gross amount they collected, and the commission rate they charge. Your net payout calculates automatically. 💡 Tip: if two or more platforms charge the same commission rate, combine them onto one line (e.g. "Viator + Klook" at 25%).
- Income — Add-ons & Extras. Add any add-on revenue (upgrades, optional extras sold during tours) and other income (photography, merchandise, private hire, tips kept).
- Costs section. Enter the monthly total for each tour cost category — guide fees, transport, meals, entrance fees, accommodation, equipment, fuel, and any other direct tour cost. Only include costs directly tied to running your tours.
- Profitability Summary. Scroll down to see total net income, all costs, gross profit, margin %, revenue per guest, profit per guest, and a colour-coded verdict on how the month performed.
- Print / Reset. Use Print / Save as PDF to export a snapshot for your records. Use Reset to clear all fields and start fresh for a new month.
Monthly Tour Income $0.00
| Income Type | Amount ($) | Net to You | |
|---|---|---|---|
|
Direct Bookings
Your website, phone, walk-ins, repeat guests
|
—
|
—
|
|
|
OTA Bookings
Viator · GetYourGuide · Klook · TripAdvisor Experiences · Airbnb Experiences
💡 Tip: OTAs with the same commission rate can be combined into one line.
|
|||
| OTA Name | Gross ($) | OTA Comm % | Net to You |
|
—
|
|||
|
—
|
|||
|
—
|
|||
|
—
|
|||
|
—
|
|||
| Total OTA Net (after all commissions) | Total comm: — |
—
|
|
|
Add-ons
Upgrades, optional extras sold during tours
|
—
|
—
|
|
|
Extras & Other Income
Photography, merchandise, private hire, tips kept
|
—
|
—
|
|
|
—
|
—
|
||
| Total Net Income (after OTA commission) |
—
|
||
Monthly Tour Costs $0.00
| Cost Item | Monthly Total ($) | % of Income |
|---|---|---|
|
Guide / Staff Fees
All guide wages, freelance staff paid for tours
|
—
|
|
|
Transportation
Vehicle hire, bus, taxi, train tickets for tours
|
—
|
|
|
Meals & Refreshments
Food and drinks provided to guests
|
—
|
|
|
Entrance Fees & Permits
Park fees, site entry, activity permits
|
—
|
|
|
Accommodation
Hotels, ryokan, guesthouses for multi-day tours
|
—
|
|
|
Equipment & Supplies
Gear, props, printed materials used on tours
|
—
|
|
|
Fuel & Toll Fees
Petrol, expressway tolls, parking
|
—
|
|
|
—
|
||
| Total Tour Costs |
—
|
|
Profitability Summary
Total Direct Income —
Total OTA Income (net after commission) —
OTA Commission Paid —
Add-ons —
Extras & Other Income —
Total Net Income —
Total Tour Costs —
Gross Profit —
Gross Margin % —
Total Guests This Month —
Revenue per Guest —
Cost per Guest —
Net Margin % —
MONTHLY TOUR NET PROFIT (USD) Total Net Income minus all Tour Costs
—
—
Profit per Guest —
⚠ Disclaimer This calculator is provided for informational and planning purposes only and is not a substitute for professional accounting, financial, or tax advice. Results are entirely dependent on the accuracy of the data you enter and should be treated as estimates, not official financial records. The tool does not account for taxes, depreciation, loan repayments, or any company-level overhead outside of tour operations. For official financial reporting, compliance, or tax obligations, please consult a qualified accountant or financial advisor. The creator of this tool accepts no liability for any financial decisions made based on its output.
Use of this site and its tools is subject to our:
Disclaimer.