Skip to content

Every finance report

This page lists every report in Money → Reports, in the same groups as the library. For each one you see what it shows, how often hotels usually use it, the files it downloads as, and what the accountant, a manager and the front desk may do with it by default. The owner always sees and downloads everything, and can change any default in Schedules and access.

What the access words mean:

  • See and download: open it on screen and download it.
  • See only: open it on screen, no download.
  • Own shifts only: a cashier sees their own drawers and nobody else’s.
  • No: the report does not appear for that role.

Everyone can read this list. Opening a report depends on your role and your owner’s choices.

Sidebar → Money → Reports. Search for a report by the name shown below.

  1. Find the report you need under its group below.
  2. In Reports, search for its name and open it. See Finance reports for dates, downloads and emailing it to yourself.
  3. If your role shows No or See only and you need it, open the report card and click Ask the owner to give access.
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Daily flash (manager’s report)The day in one page: rooms, revenue by department, movement and money collected, against the month, the year and last year.DailyPDF, Excel, CSV, WhatsApp (when scheduled)See and downloadSee and downloadNo
Night audit packThe stored PDF of each closed day: flash, ledgers, payments, exceptions and who closed it. It never changes after the close.DailyPDFSee and downloadSee and downloadNo
Daily revenue report (DRR)Revenue by department and charge line with SAC, GST rate, CGST and SGST.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
Trial balance (four ledgers)The four ledgers for a day: opening, added, taken off, moved, earned and closing, with the tie checks.DailyPDF, Excel, CSVSee and downloadSee onlyNo
Day close historyEvery business date: closed or not, by whom, how, with revenue and money collected.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
ArrivalsGuests due to arrive, with advance paid, balance, ID status and ETA.DailyPDF, Excel, CSVNoSee and downloadSee and download
DeparturesGuests due to leave, with the bill, what is paid and what is still owed.DailyPDF, Excel, CSVNoSee and downloadSee and download
In-house guests with balancesGuests in the house tonight, the bill so far, what is paid and who pays.DailyPDF, Excel, CSVSee and downloadSee and downloadSee and download
No-showsArrivals who did not come, the charge kept and who it was billed to.DailyPDF, Excel, CSVSee and downloadSee and downloadSee only
CancellationsBookings cancelled, the fee kept and the refund.DailyPDF, Excel, CSVSee and downloadSee and downloadSee only
High balanceGuests in the house paying themselves who owe more than the hotel’s limit.DailyPDF, Excel, CSVSee and downloadSee and downloadSee only
Room status and out of orderRooms out of order or out of service, and the room nights they take off sale.DailyPDF, Excel, CSVNoSee and downloadSee only
Guest register (police)The day’s arrivals in the police register layout.DailyPDF, Excel, CSVNoSee and downloadSee and download
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Cashier shift reportEach cashier shift: float, cash in, UPI and card, paid out, expected and counted cash, and the difference.Every shiftPDF, Excel, CSVSee and downloadSee and downloadOwn shifts only
Payments by modeMoney collected by mode, day by day.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
All paymentsEvery payment, receipt and banquet payment, with reference and who took it.Any rangeExcel, CSVSee and downloadSee and downloadNo
Refund registerEvery refund, against the payment it came from.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
Discounts and allowances by personDiscounts, waivers and goodwill given, by person, with the limit and who approved.DailyPDF, Excel, CSVSee and downloadSee onlyNo
Voids and corrections by personCharges voided or corrected and payments voided, by person.DailyPDF, Excel, CSVSee and downloadSee onlyNo
Paid-outs (petty cash)Petty cash taken out of the drawer, with purpose and receipt.DailyPDF, Excel, CSVSee and downloadSee and downloadOwn shifts only
UPI and card settlement matchUPI, card and online payments matched to what reached the bank.DailyExcel, CSVSee and downloadNoNo
Payment links: open and expiredPayment links sent and not paid yet.DailyExcel, CSVSee and downloadSee and downloadSee only
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Revenue by departmentRevenue by department, its share and last year.Daily · MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Source and channel productionRoom nights, revenue and ADR by where the booking came from, with commission.Weekly · MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Market segmentRoom nights and revenue by market segment.MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Company and travel agent productionWhat each company and travel agent booked, was invoiced, paid and owes.MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Room type revenueOccupancy, ADR and revenue by room type.MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Rate plan reportRoom nights and revenue by rate plan and promo code.MonthlyExcel, CSVSee and downloadSee and downloadNo
Complimentary and house useFree rooms and house use, with their value and who approved.MonthlyPDF, Excel, CSVSee and downloadSee onlyNo
Occupancy and ADR by dayOccupancy, ADR and RevPAR day by day, against last year.MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Pace and pickup (on the books)What is on the books for the next 90 nights, what was picked up in the last day and week, and the same point last year.Daily · WeeklyExcel, CSVNoSee and downloadNo
Forecast: next 30 and 90 daysExpected occupancy, rate and room revenue for the next 30 or 90 nights, with the weddings and functions on each date. An estimate.WeeklyPDF, Excel, CSVNoSee and downloadNo
Lead time and length of stayHow far ahead guests book and how long they stay, by your biggest sources.MonthlyExcel, CSVNoSee and downloadNo
Direct vs OTA, and what OTAs costWhat each OTA brought in and what it cost: commission, GST on commission, TCS and TDS.MonthlyPDF, Excel, CSVSee and downloadNoNo
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Guest ledgerEvery open guest bill: charges, payments, transfers and balance.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
Advance deposits heldAdvances held for future stays and functions.DailyPDF, Excel, CSVSee and downloadSee and downloadNo
City ledger ageingWhat companies, agents, event hosts and OTAs owe, by age.Weekly · MonthlyPDF, Excel, CSVSee and downloadSee onlyNo
Company statementsA statement per company for a period: invoices, receipts and closing balance.MonthlyPDFSee and downloadSee and downloadNo
OTA payout reconciliationAn OTA payout statement matched booking by booking.Each payoutExcel, CSVSee and downloadNoNo
Upstay payout statementWhat Upstay collected, its commission, transfers to the hotel and the balance.MonthlyPDF, Excel, CSVSee and downloadSee onlyNo
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Restaurant salesRestaurant sales charged to rooms.Daily · MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Room service and minibarRoom service and minibar orders by day and by item.Daily · MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Free and cancelled food ordersFood orders that were free, cancelled after the kitchen started, or reversed.DailyExcel, CSVSee and downloadSee onlyNo
Banquet revenue and function diaryFunctions held and booked, with food, hall, extras, GST, paid and due.MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Banquet advances and scheduleBanquet bookings with their payment schedule, paid and overdue.WeeklyExcel, CSVSee and downloadSee and downloadNo
Event and wedding blocksEvent and wedding room blocks: blocked, picked up and what the hosts owe.Per eventExcel, CSVSee and downloadSee and downloadNo
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
GST output registerOutput GST by SAC and rate, from stored tax lines, credit notes negative.MonthlyExcel, CSVSee and downloadNoNo
GSTR-1 data fileThe month’s GSTR-1 data: B2B, B2C, credit notes, HSN/SAC and documents issued.MonthlyExcel, CSV, GSTR-1 JSONSee and downloadNoNo
GSTR-3B summaryThe month’s 3B summary: outward supplies, TCS credited by OTAs, ITC Upstay knows.MonthlyPDF, Excel, CSVSee and downloadNoNo
Invoice and credit note registerEvery tax invoice and credit note in number order, with gaps flagged.MonthlyExcel, CSVSee and downloadSee onlyNo
TCS and TDS registerTCS and TDS deducted by OTAs and companies, and TDS you owe on agent commission.Monthly · QuarterlyExcel, CSVSee and downloadNoNo
Form C registerForeign arrivals and their Form C (Form-III) filing.DailyExcel, CSVNoSee and downloadSee and download
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Profit and lossRevenue by department and the costs Upstay records, for a period.Monthly · YearlyPDF, Excel, CSVSee and downloadNoNo
Day book and journalsEvery journal entry with its lines.Any rangeExcel, CSVSee and downloadSee onlyNo
Account balances as of a dateEvery ledger account’s balance as of a date.MonthlyPDF, Excel, CSVSee and downloadNoNo
Tally exportVouchers for Tally import, with the hotel’s ledger names.Daily · MonthlyTally XML, Excel, CSVSee and downloadNoNo
Budget vs actualOccupancy, rate and revenue by department against the budget the owner set.MonthlyPDF, Excel, CSVSee and downloadSee onlyNo
Month-end packThe month-end files for your accountant in one ZIP.MonthlyPDF, ZIPSee and downloadNoNo
Yearly summaryThe financial year month by month: occupancy, rate, revenue by department, GST, money collected and where it came from.YearlyPDF, Excel, CSVSee and downloadNoNo
Payroll summaryThe payroll runs in a month: gross, deductions, contributions and net.MonthlyPDF, Excel, CSVSee and downloadNoNo
ReportWhat it showsHow oftenFilesAccountantManagerFront desk
Who changed whatWho changed what on bills, payments, rates and settings.On demandExcel, CSVSee and downloadSee onlyNo
Cash drawer variancesShifts whose drawer was short or over, and totals by cashier.Weekly · MonthlyPDF, Excel, CSVSee and downloadSee and downloadNo
Approvals givenApprovals asked for and decided, by whom and how fast.MonthlyExcel, CSVSee and downloadSee onlyNo
  • Wherever Excel is offered, CSV is too.
  • The Night audit pack is the stored PDF of a closed day. It never changes, which makes it the record to show an auditor.
  • Reports marked WhatsApp (when scheduled) can be sent to you by WhatsApp when your owner schedules them and WhatsApp is enabled for your hotel.
  • Every report reads the same closed days, so their numbers always agree with each other and with Finance home.
  • A report on this list is not in your library → Your role has No for it, your owner changed it, or your hotel does not have the module it needs. Tick Show the … I cannot open in Reports to see it.
  • A download button is locked → Your role has See only for that report.