A travel site can send thousands of readers to booking partners and still produce little usable income. Clicks look good. Pending commissions can look even better. Neither pays your operating costs.
A travel affiliate income report separates attention from approved earnings and approved earnings from cash received. Build it on fixed source records, clear formulas, and a monthly review process.
Set the Rules Before You Export Data
Your report needs three money stages. Keep them separate from the first row.
- Platform-reported earnings are the rewards shown in Travelpayouts reports. They may be pending, confirmed, canceled, or adjusted later.
- Paid earnings are funds Travelpayouts has sent through your chosen payout method.
- Personal profit is what remains after business costs and taxes. It is not a Travelpayouts dashboard metric.
Travelpayouts reports can show impressions, clicks, bookings, cancellations, payments, income, and potential income. The available fields can vary by program and report view. Review the current Travelpayouts Reports overview before locking your spreadsheet columns.
A pending commission is a possible result. An approved commission is a commercial result. A paid payout is cash movement.
Set one reporting period. A calendar month works for most publishers. Use the same start and end dates for traffic, clicks, bookings, earnings, and reversals. Mixing March clicks with April approvals will distort your EPC.
Pull Source Records From Travelpayouts
Start with exports or saved screenshots from your account. Do not build the report from memory or one dashboard total.
Use Performance for the top-level view
Open the Performance or program reporting view. Pull results by program, project, SubID, content source, and date range when those filters are available.
Record impressions, clicks, bookings, cancellations, confirmed earnings, potential earnings, and eCPC where the platform provides them. Travelpayouts may use labels such as “Earnings,” “Reward,” or “Affiliate Reward.” Use the labels in your account, then map them to your fixed report fields.
A booking does not always mean a commission has cleared. A high-click page can also send readers who browse but never complete a booking.
Use booking details to explain changes
Open booking-level records when totals move unexpectedly. The booking history can show status changes, cancellations, confirmation events, and changes to payout or sale values.
Save the export date, reporting date range, program name, and source file name. Keep the original download unchanged. If a reward reverses later, add an adjustment record. Do not replace last month’s value and lose the history.
For larger sites, the Travelpayouts booking statistics API can support scheduled exports. Use it only after you confirm your fields and test a small date range against the dashboard.
Build a Travel Affiliate Income Report Spreadsheet
Use Google Sheets, Excel, Airtable, or your existing reporting database. The tool matters less than the structure.
Create three tabs: Monthly Summary, Source Data, and Adjustments.
Keep one row for each measurable source
In Source Data, use one row per content URL, program, traffic source, and reporting period. If you use SubIDs by link placement, include the SubID too.
| Field | What to record |
|---|---|
| Reporting period | Start date and end date |
| Content source | Article URL, newsletter, social post, or video |
| Program and offer | Travelpayouts program name and destination |
| Tracking detail | Project, SubID, campaign, or placement |
| Clicks | Outbound affiliate clicks for the period |
| Bookings | Booking or purchase count if reported |
| Pending rewards | Potential commissions still under review |
| Approved rewards | Confirmed rewards accepted by the program |
| Reversals | Cancellations, rejected rewards, or adjustments |
| Paid amount | Amount included in a completed payout |
| Terms checked | Date you reviewed rate and program conditions |
This structure lets you compare a Rome hotel guide with a flight-deals newsletter without mixing the results.
Keep adjustments in their own tab
A $40 reward can later become zero after a cancellation, refund, fraud review, or program-rule issue. Enter the change on the Adjustments tab with the original record ID, adjustment date, amount, reason, and evidence source.
Your monthly summary should pull the net figure through formulas. It should not depend on a person manually changing a previous total.
Calculate the Metrics That Drive Decisions
Clicks are useful. They tell you a call to action gets attention. They do not tell you whether that click produced a valid booking.
Use approved results for your core calculations.
Calculate net affiliate earnings
Use this operating formula:
Net affiliate earnings = approved percentage rewards + approved fixed rewards – reversals
If your program report already shows a net approved amount after adjustments, store the raw figure and note the platform definition. Do not add or subtract a second time.
Use paid earnings for cash tracking. Paid earnings may differ from approved earnings in a given month because of payout timing, thresholds, or review status.
Calculate approved EPC and booking conversion
Approved earnings per click puts pages with different traffic volumes on the same scale:
Approved EPC = approved earnings / outbound clicks
For example, Page A gets 1,000 clicks and produces $30 in approved earnings. Page B gets 120 clicks and produces $48. Page B has an approved EPC of $0.40. Page A has $0.03. Page B deserves closer attention.
If booking counts are available, calculate:
Click-to-booking conversion rate = bookings / outbound clicks x 100
Travelpayouts Content Analytics may show CR1 and CR2. CR1 measures unique-visit-to-click conversion. CR2 measures click-to-booking conversion. Check the field definitions in your account before using them in management reporting.
Do not treat potential earnings as revenue in this calculation. Keep a separate potential EPC if you want to monitor the pipeline.
Reconcile Earnings Against Payouts and Costs
Your report needs a finance check. A dashboard balance is not the same as money in your bank account.
Travelpayouts describes balance as unpaid rewards. Its Finance area also includes booking and earnings information, payout methods, and payment history. Check the Finance section guidance when labels or payout records are unclear.
Match paid amounts to payout history
At month-end, compare your Paid amount column with the completed payout record. The Travelpayouts payout history report is the source record for payout transactions.
Record:
- Payout date and payout status
- Payout method and payout currency
- Gross paid amount
- Transfer, conversion, or receiving-bank fees
- Amount that reached your business account
Travelpayouts states that payouts are automatic and monthly, but timing and minimum requirements depend on your account and selected payment method. A payout marked “Sent” can still take time to arrive. Check current account details before planning cash flow.
Calculate profit outside the affiliate dashboard
Use a separate profit line:
Affiliate profit before tax = paid earnings – business expenses
Business expenses can include writing, editing, hosting, keyword tools, email software, paid traffic, contractors, and payment fees. Add tax as a separate estimate or an actual paid-tax line.
Tax treatment depends on your country, business structure, accounting method, and income type. A creator in the United States may face different reporting obligations than a publisher operating through a UK limited company. Use a qualified local accountant for tax treatment.
Find Pages Worth Improving
A monthly report should lead to a content decision. Otherwise, it is only a spreadsheet with more tabs.
Fix high-click pages with weak approved earnings
Start with pages that have many clicks but weak approved EPC. Check the destination URL first. Confirm it loads, contains your tracking, and matches the reader’s intent.
Then test the page on a phone. Travel readers often research across maps, search results, airline emails, and messaging apps. A slow or irrelevant booking path loses them fast.
A broad “Italy travel tips” page may create curiosity clicks. A page comparing train routes, airport transfers, or hotels in a specific neighborhood often has stronger booking intent.
Expand patterns that already work
Find your three highest approved-earning pages. Check the destination, travel stage, offer type, traffic source, device, and link placement.
Do not copy the wording. Copy the commercial pattern.
If readers book hotel stays after you publish practical neighborhood guides, build more destination pages with the same decision support. If flight widgets create clicks but no approved earnings, test placement and audience fit before adding them site-wide.
Add Controls, Disclosure, and Human Review
Travelpayouts programs set their own reward conditions. A percentage can apply to booking value, the advertiser’s commission, or another defined base. Approval rules, eligible products, cookies, and payout conditions can change.
Save the live offer details and date checked for every program you promote. The Travelpayouts platform overview explains that brands use different reward structures across travel categories.
Use a visible status on every monthly report:
- Draft
- Ready for review
- Approved
- Needs correction
- Archived
Human review still matters. A formula can calculate EPC correctly while using the wrong program status or a duplicate export. Review unusual changes, large reversals, missing data, and payout mismatches before sharing the report.
Affiliate disclosure: This article may contain affiliate links. If you sign up or book through a link, Gist Junction may earn a commission at no extra cost to you.
Final Thoughts
A useful travel affiliate income report tracks the full path: reader interest, approved reward, payout, cost, and profit. It does not treat clicks or pending commissions as spendable income.
Build the first version with one month of source data. Reconcile it against payouts. Then use approved EPC and reversal patterns to decide which pages deserve your next update.
FAQ
How often should I update a Travelpayouts income report?
Update the source data monthly. Review high-value pages and major reversals sooner if you run paid campaigns or publish frequent travel content. Booking approvals can take time, so compare mature reporting periods when judging page performance.
Are pending Travelpayouts earnings part of income?
No. Pending rewards are possible commissions under review. Keep them in a separate pipeline column. Use approved earnings to assess content performance and paid earnings to track cash received.
What is the difference between earnings and profit?
Earnings are affiliate rewards reported or paid by the platform. Profit is what remains after your business costs. Personal profit after tax is lower again if you owe tax on the income.
Should I use the Travelpayouts dashboard or a spreadsheet?
Use both. The dashboard is the live source for program activity, bookings, earnings, and payouts. A spreadsheet gives you a stable monthly record, content-level comparisons, adjustment history, and a clear profit calculation.
