Hotel & Restaurant Reports — Daily Revenue & Analytics

Get Started with our Free Forever plan

Zitlin emails you a revenue report every morning before you start your day. Your accountant gets a GST-ready invoice CSV. Your kitchen manager exports a per-item sales breakdown. No manual number-pulling.

Most independent hotel and restaurant owners find out how yesterday went when they sit down to reconcile manually — adding up receipt stubs, checking the register, cross-referencing the OTA dashboard. By the time the picture is complete it's mid-morning. Problems from yesterday are already a day old.

Zitlin sends you a revenue report every morning at 5 AM, before your shift begins. 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 — before you've had your first cup of tea. The same report is available to download from the dashboard at any time.

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.

Are reports available on the free plan? The daily revenue email and basic dashboard revenue summary are available on the free plan.

Get started for free

Explore other features

Short Term Rentals

Manage multiple Airbnb listings from one calendar

OTA Channel Management

Sync with Airbnb, Booking.com, MakeMyTrip, Traveloka & 50 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, 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

Banquet & Events

Plan and invoice event spaces

      Chat