---
name: kanal-net-gelir
description: "Use when a net room revenue by channel analysis is requested from channel production report and commission/cost breakdown for the same period. Produce a formula-based Excel file and a Word summary."
---

# Net room revenue by channel

After commission and channel costs, which channel leaves more revenue per room night?

## Input and scope

Channel production report and commission/cost breakdown for the same period.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the outputs. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Bring accommodation revenue to the same stay period, currency, VAT and refund basis. Separate collections from accommodation revenue.

2. Do not deduct commission a second time from a net rate that already excludes it. Leave costs that cannot be allocated to a channel on a separate row. Channel net = room revenue − commission − other disclosed channel costs.

3. Calculate total net revenue per unit as total net revenue / total room nights. If the night count is zero, leave the unit value blank. In the Word report, report the leader in absolute net revenue and the leader in net revenue per unit separately.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Channel, Room nights, Gross room revenue (TL), Net room revenue (TL), Net TL / room night.

## Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: The direct channel leaves 2,900 TL per room night.
