Hotel Reports — Occupancy, Revenue and Where the Money Went

Get Started with our Free Forever plan

Four report tabs you can open at any moment, a revenue summary that arrives by email before your first cup of tea, and exports your accountant and your kitchen manager can each take away on their own. Nothing to build, and no numbers to add up by hand.

Most owners of independent properties find out how yesterday went by sitting down and working it out: receipt stubs, the register, the OTA dashboard, a calculator. By the time the picture is complete it is mid-morning, and yesterday's problems have had a day's head start.

Zitlin answers the same questions two ways. Reports in the main menu is open whenever you want it, with four tabs that each answer one question a property asks every day. And a revenue summary arrives by email each morning at around 5 AM, so the shape of yesterday is waiting for you before your first cup of tea.

Four tabs, four questions

Tab The question it answers
Revenue What came in, what went out, and which way we came out — for today, this week, this month, or any range you pick
Kitchen Which dishes sold, at what price, and what was comped or sent back
Breakfast How many people are we feeding tomorrow morning
Daily Reports What did the property look like on this particular date

Revenue is the one most owners live in. Money in against money out, income by category — rooms, restaurant, room service, event spaces — and spending by expense category beside it, with a cashflow view across the period so a difficult week reads as a shape rather than a number. Underneath sit the figures you check against the till and the card terminal: what was collected by cash, card, QR and transfer, what is still unsettled, what you are holding in prepayments, and the tax inside it all.

Kitchen and Breakfast are for the people who cook. The first is dish by dish — quantity sold, unit price, value, and what was removed or comped. The second counts covers from the meal plan on each booking rather than from tickets rung up at the buffet, so tomorrow's number is ready tonight and nobody has to count heads.

Daily Reports is the dated snapshot. Pick a date and you can open occupancy and revenue on the screen, or take any of seven reports away as a PDF: occupancy with the night's arrivals and departures, revenue by source and by OTA, folios and their balances, channel mix — what direct, walk-in and each OTA actually brought in — exceptions, housekeeping, and expenses.

And a summary that comes to you

You see yesterday's room revenue, room service, restaurant sales, tax collected, discounts applied, and exactly how much came in by cash, UPI, card and credit — without opening anything. The same report can be downloaded from the dashboard whenever you want it.

The Daily Revenue Report — What It Contains

The report is a one-page PDF covering a 24-hour window. An actual report generated for a real Zitlin property looks like this:

Line What it shows
Revenue Total revenue from all invoices in the period
Tax Total GST collected across all invoice types
Discount Total discounts applied in the period
Invoices Count of invoices generated
Room Revenue from accommodation charges
Room Service Revenue from in-room food and beverage orders
Restaurant Revenue from restaurant table orders
Total Amount Received Settled invoice total
Unsettled invoices Count and value of invoices not yet fully settled — flagged separately
Cash Amount received in cash
Instant Payment (UPI, Thai QR, etc.) Amount received via QR payment systems
Credit/Debit Card Amount received by card
Bank or Wire Transfer Amount received via bank transfer
Credit Amount settled by room credit or internal transfer
NC or Complimentary Complimentary invoices
Third Party (OTA, agents, etc.) Amount settled through OTAs or travel agents

The payment method breakdown is particularly useful for properties transitioning to UPI or QR payments — you can see in a single line what proportion of daily revenue is coming through each channel versus cash and card.

Check Your Numbers Before Breakfast

Zitlin hotel and restaurant revenue reports on mobile

Invoice Export — GST-Ready CSV for Your Accountant

Every invoice Zitlin generates — room, room service, and restaurant — is exportable as a CSV. Each row in the export contains everything your accountant needs to file monthly GST returns:

Column Example
Invoice Number ZIT/26-27/RO-996
Invoice Type Room / Room Service / Restaurant
Date and time Jun 28, 2026 10:43
Settled Yes / No
Customer Name Guest name as entered
Customer Address Full address including state
Customer Tax ID GSTIN if provided for B2B invoice
Discount Rate and Amount 0% / ₹0.00
Total Amount Pre-tax subtotal
Tax Details [email protected] on ₹4,400 = ₹110, [email protected] on ₹4,400 = ₹110
Tax Amount Total GST on this invoice
Advance / Deposit Any deposit applied
Net Amount Post-tax, post-deposit total
Round Off Rounding adjustment
Amount Payable Final amount
Payment Modes Card: ₹4,620 / Cash: ₹260; Credit: ₹2

Invoice numbers follow financial-year-aware sequential format (ZIT/26-27/RO-996) — the 26-27 denotes the financial year, and RO/RS/RE denotes room, room service, and restaurant respectively. This format is consistent with GSTR-1 invoice series requirements.

The CSV export covers any date range you select. Filter by invoice type, settlement status, or date range, then export. Your accountant receives a spreadsheet with every invoice, every tax component, and every payment method — ready to map to GSTR-1 without manual data entry.

F&B Sales Report — Per-Item Breakdown for Kitchen Managers

The kitchen manager or restaurant operator can independently export a per-item sales report in CSV format for any date range. Each row is one menu item and shows:

Column What it tells you
Item / Dish Menu item name
Removed How many times this item was added and then removed from an order
Complimentary How many units were served complimentary (0-cost)
Quantity Sold Total units sold in the period
Unit Price Price per unit
Value Total revenue from this item

The "Removed" column is the one most kitchen managers don't expect to find useful but do — it shows items that guests ordered and then cancelled before billing. A dish that gets added and removed frequently is either slow to prepare (causing order cancellation) or frequently mis-sold by staff.

Zitlin daily revenue report — room, room service, restaurant breakdown

What You Can Track

Revenue by category. Room revenue, room service revenue, and restaurant revenue are separated on every report. You see immediately whether a slow day was a front desk problem or a restaurant problem.

Payment method mix. Cash versus UPI versus card versus credit — broken down daily. Useful for cash flow planning and for verifying that QR payment adoption is moving in the right direction.

Discounts applied. Total discounts in the period, visible on both the daily report and the invoice export. If discounts are climbing without a corresponding increase in volume, that shows up.

Tax collected. Total GST per period, matching the invoice export totals. Your accountant can cross-check the summary figure against the line-by-line CSV.

Unsettled invoices. The daily report flags any invoices that have been generated but not fully settled with a payment method. These are potential revenue leakage — cash that hasn't been recorded or a folio that was closed without confirming how the guest paid.

Menu performance. Via the F&B CSV — which items sold, at what volume, at what price. Identify your highest-revenue dishes and your highest-cancellation dishes in the same export.

Who Gets Which Report

Report Format Who accesses it How
Daily revenue summary PDF Owner / manager Email at 5 AM daily + dashboard download
Invoice export CSV Accountant / owner Dashboard export, any date range
F&B sales report CSV Kitchen manager / owner Dashboard export, any date range

Report access is role-based. A kitchen manager can export the F&B sales report without having access to financial invoices or room revenue. An accountant given export-only access sees invoices without being able to modify reservations or pricing.

Frequently Asked Questions

Can we export daily sales, payment modes, and tax logs into CSV for our accountant to file monthly GST? Yes. The invoice export CSV contains every invoice generated in the selected date range, with CGST and SGST broken down per invoice, customer details (name, address, GSTIN if applicable), invoice type (Room/Room Service/Restaurant), payment method per invoice, and financial-year-aware sequential invoice numbers. Your accountant can map this directly to GSTR-1 without manual data entry. The daily revenue report also provides a summary tax total that can be cross-checked against the CSV line items.

When is the daily report emailed, and who receives it? The daily revenue report is emailed at approximately 5 AM each day to the registered owner or manager email address for the property. It covers the previous 24-hour window. The same report can be downloaded from the Zitlin dashboard at any time — you are not dependent on the email.

Can the kitchen manager export the F&B report without accessing financial data? Yes. Role-based access controls what each user can see and export. A kitchen manager role can export the per-item F&B sales CSV — item name, quantity sold, removed items, complimentary items, and revenue per item — without access to invoice financials, room revenue, or guest payment details.

Does the invoice export include CGST and SGST separately, or only a combined GST total? Both. Each invoice row in the CSV shows the tax calculation broken down — for example, "[email protected] on ₹4,400 = ₹110, [email protected] on ₹4,400 = ₹110" — as well as a combined tax amount column. This format is compatible with GSTR-1 requirements for intra-state supplies.

Does the report separate room revenue, room service revenue, and restaurant revenue? Yes. The daily report and the invoice export both distinguish between Room, Room Service, and Restaurant invoice types. You can see at a glance whether a drop in revenue was accommodation-driven or F&B-driven.

What does the "Removed" column in the F&B export mean? It shows how many times a menu item was added to an order and subsequently removed before the bill was generated. A high removal count on a specific dish often signals a preparation delay causing guests to cancel the order, or a frequent mis-sell by floor staff. It's different from unsold items — it's items that were ordered and then taken off the bill.

Can I see which invoices are unsettled — where payment hasn't been confirmed? Yes. The daily revenue report flags unsettled invoices with a count and total value. These are invoices that have been generated but where no payment method has been recorded — a potential sign that cash was collected but not entered into the system. The invoice export also includes a Settled column, so you can filter for unsettled invoices specifically.

Can I export data for a custom date range — weekly, monthly, quarterly? Yes. Both the invoice export and the F&B sales report let you select a custom start and end date. There is no restriction to pre-set weekly or monthly windows. For GST quarterly filing, select the full quarter range and export once.

Does the payment method breakdown include UPI and QR payments separately from card? Yes. The daily report shows Instant Payment (UPI, Thai QR, etc.) as a separate line from Credit/Debit Card, Cash, and Bank or Wire Transfer. If you are tracking QR payment adoption over time, you can compare the Instant Payment line across daily reports without any manual calculation.

How far back can I export invoice data? Invoice history is retained for the life of your account. You can export invoices from your first day on Zitlin to the current date in a single CSV export if needed.

Does Zitlin report occupancy and average room rate? Yes. The occupancy report for any date shows rooms sold against rooms available with the night's arrivals and departures, alongside the average daily rate and revenue per available room for that day. It opens on the screen and can be taken away as a PDF.

Can I see which OTA or channel my revenue came from? Yes — the channel mix report breaks a day's room revenue down by booking source and by OTA, so you can see what direct bookings, walk-ins and each connected channel actually brought in. It covers room bills only, since a restaurant tab has no channel behind it.

Are reports available on the free plan? The daily revenue email and the dashboard revenue summary are on the free plan and stay there. The manager reports — occupancy, revenue, folios, channel mix, exceptions, housekeeping and expenses — are part of Zitlin Pro, free for your first 60 days.

Get started for free

Explore other features

Short Term Rentals

Manage multiple Airbnb listings from one calendar

Guest ID Records

Held privately, seen only with a PIN, deleted on time

Security Deposits

Taken, tracked and given back — never counted as revenue

OTA Channel Management

Sync with Airbnb, Booking.com, MakeMyTrip, Traveloka & 60 more OTAs

Walk-in Bookings

Seamless check-ins, every time

Spas, Saunas & Clubhouses

Hourly slots, invoicing, QR payments

Multi-Property Calendar

All units, one view

QR Payments

UPI, Pix, VietQR, QRIS, DuitNow & more

Booking Engine

0% commission direct bookings

Restaurant POS

Orders on folio, one bill at checkout

Invoicing

GST, non-GST, and multi-country VAT

Inventory

Every sale mapped to stock

Guest CRM

Know your returning guests

Large Hotels & Resorts

Up to 200 rooms, three shifts, 60+ channels

Staff Sign-In & Roles

A PIN per person, a name on every action

Cash Drawer

Count the till at every shift handover

Banquet & Events

Plan and invoice event spaces