Quick Reference Guide to view and match your transactions using reports.
Summary Table - Quick Reference
Description | Where to view/match | How to view/match | Comments |
Cash Transactions for a Business Day | Day End Report Cashier Report | Select business day date | These reports show transactions of Business day and not calendar day. A business day is as per Day End settings on OYO OS and preferable timings are 4 AM till 7 AM. |
Card Transactions for a Business Day | Day End Report Cashier Report | Select business day date | These reports show transactions of Business day and not calendar day. A business day is as per Day End settings on OYO OS and preferable timings are 4 AM till 7 AM. |
All Transactions for a calendar day or date range | Transaction Report | Select a Calendar Date and Date range | This report shows transactions occurred from 12 AM from FROM DATE till 12 AM on TO DATE. |
Matching Revenue | Bookings Report, Monthly Financial Report and Day End Report | Select a Date or Date range on Bookings report, Month on Monthly financial or Date on Day end report | The revenue is based on URN(Used room Nights) Select In stay filter in case you need to check details of In Stay guests. |
Matching Payments on URN basis | Bookings Report, Monthly Financial Report, and Payment Split Report | Select a Date or Date range on Bookings report, Month on Monthly financial or Date on Day end report | Payments in these reports are on the URN basis. URN basis means only the revenue and charged on that date/ date range, payment collected before check-in is realized on check-in date and payment collected on or after checkout is realized on checkout -1 date |
Matching payments on the transaction date | Day End report, Cashier Report, and Transaction Report | Select date range or date and match the transactions happened at the property | These reports show transactions on the transaction date. |
Matching Revenue and Payment mismatch between Recon and OS reports | Bookings and Variance Report | View Variance report once Recon is frozen | The variance report gives details on all transactions where Recon and OS numbers are different. This will happen mainly in spillover bookings from month “n” to “n+1” |
Tracking your Daily Cash/Card transactions at property
Cashier Report
Cashier reports can be enabled by enabling shift and staff management system under Setting > Features. Day end time should be configured between 4 A.M and 7 A.M.
Cash/ card payment collected by all staff in a shift is available in this report. Transactions for each staff member are also available in the transactions part of the report.
NOTE: This report is a record for transactions occurred in a Business Day i.e. Day End time settings.
Day End Report
Payments collected between day closing time are reflected in this report. Revenue and bookings for that day are available in this report. This report can be used to provide visibility for a day’s events happening at a property whether its collection or refunds.
NOTE: This report is a record for transactions occurred in a Business Day i.e. Day End time settings.
Transaction Report
Transactions report provides details of all transactions for a property during a calendar day or date range as selected by the user. One important point to note here is that transaction report day selections work on a calendar day and not a business day set by each property.
Summary of all transactions can be seen in the Summary box and all detailed transactions can be seen in transactions part of the report. Various filters are provided to filter out desired transactions.
How and where to match your daily cash/ card transactions
Important Note: Daily cash/card transactions should be matched in Cashier, Day End and Transactions report.
Cashier and Day End report works for Business Day(as set by the property) and Transaction report works for Calendar Day(12 AM to 12 AM)
So all transactions in the Transaction report happening between business day hours should match the Cashier and Day End report.
Cashier report
It provides all the transactions conducted by staff in their shift whether it's cash/card and collection/returns/refunds.
Transaction wise data is available to match transactions.
Day end report
Shift wise data similar to cashier report is available here, all transactions within day end time are available here.
Any transaction which is done by a backed team as requested by PM/ Owner is available under Undefined User/Shift.
If in case the day end report and cashier report do not match please ensure that day end time is configured after 4 AM only. (It can be configured under Settings > Features)
Transactions Report
All payment and security deposit transactions are available in this report.
Using filters
Select charge type as charge (Payment transactions only),
For cash or card select payment mode,
Select the date you want to check as the start date and next day as end date (as day end time overlaps two days)
Download the report in CSV/XLSX.
Sort the transactions on the basis of date and check the transaction between your day end time.
How and where to match your revenue and payments
Revenue in Bookings Report for a day/date range will match with Revenue Report, Monthly Financial Report and Day End Report for any given date.
Payments in Bookings Report will match with Monthly Financial Report and Payment Split report only, as payments in these reports are calculated on URN basis (it is defined below) while payments in Day End, Cashier Report and Transaction Report are shown on the transaction date.
Bookings Report
Bookings report shows URN based booking and payment information. This information can be changed to arrival/departure/booking date based on the date type filter.
URN: Used Room Nights
URN basis means only the revenue and charged on that date/ date range, payment collected before check-in on check-in date and payment collected on or after checkout on checkout -1 date.
Monthly Financial Report
It contains daily/monthly revenue, payments, occupancy information on URN basis, with additional information about taxes, security deposit bills, hotel EDC break up, etc.