ThinkReservations offers a wide array of standard reports that provide you with the tools to efficiently conduct and monitor your daily operations, effectively analyze your performance, and easily interface with your accounting system. This document briefly describes each report along with suggested uses.
ThinkReservations Reports
Reservations Reports
Reservations by Booking Date
This report displays Confirmation IDs with reservations that were booked within a specific date range. Only Confirmation IDs associated with a room reservation are included in this report. Reported dollar amounts include room and non-room charges.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To find a reservation when you know the approximate date the guest made the reservation.
To determine the volume of reservations booked in a specific date range in the past.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Reservations by Arrival Date
This report displays Confirmation IDs with reservations arriving within a specific date range. Only Confirmation IDs associated with a room reservation are included in this report. Reported dollar amounts include room and non-room charges.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To find a reservation when you know an approximate arrival date.
To determine the volume of reservations that arrived/will arrive in a specific date range.
By looking at future arrivals, you can determine future cash flow for reservations booked as of today.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Canceled Reservations
This report displays all reservations that were canceled within a specific date range. Reported are canceled amounts for tracking lost revenue and the post-cancellation values for cancellation fees and other charges that guests are held accountable for after cancellation. The notes section will show the reason for cancelation if one is present on the reservation.
Notes on report content:
Canceled Subtotal - includes room and non-room charges immediately before cancellation except that items added directly to a folio within the reservation are not included.
Subtotal - non-room charges remaining after cancellation. Items that are added directly to a folio within the reservation are not included. Important to know: Cancelling a reservation does not cancel items added directly to a folio within the reservation. The items need to be deleted from the folio if they are no longer valid charges to the guest.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation after it was canceled, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To find a reservation that has been canceled.
To review canceled reservations for outstanding balances. Reviewing this report on a frequent/regular basis can help ensure that all outstanding balances on canceled reservations are resolved promptly.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Reservations by Channel
This report displays Confirmation IDs with reservations arriving within a specific date range and groups them by booking channel. Only Confirmation IDs associated with a room reservation are included in this report. Reported dollar amounts include room and non-room charges.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To determine the volume of reservations (number and dollars) for each reservation channel for a specific date range. From this report, you can calculate the percentage of reservations made online, by phone, through Expedia, etc.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Reservations by Payment Status
This report displays Confirmation IDs with reservations that arrived within a specific date range and groups them by payment status. Confirmations are grouped by the following payment statuses: Overpaid, No Payment, Partially Paid, and Paid in Full. Run this report for a period of a few months to get the full picture of any confirmations requiring attention.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To review reservations for outstanding balances. Review this report on a frequent/regular basis to ensure all outstanding balances on reservations are resolved promptly.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Payment Status: Overpaid, No Payments, Partially Paid, Paid in Full. No filter will produce the entire report sorted in the order above.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Reservations by Attribute
This report displays custom bill attribute contents for Confirmation IDs with room reservations within a specific date range. Only Confirmation IDs with room reservations that have a bill attribute entered are included. You must select an attribute to be displayed.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Total - Subtotal plus taxes applied to room and non-room charges included in the Subtotal.
Best Uses:
To determine the number of reservations that contain custom attributes. For example, this report can help you understand how guests heard about you, why guests stay with you, etc. if these are set up as custom attributes to ask of the guests.
Other features:
Group By: Not available.
Filter by Attribute: Yes. You must specify an attribute to show results.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Reservations by Agent
This report groups reservations within a specific date range by the agent that created them. You can choose the report to display reservations "Booked", "Arriving", or "In House" between the dates selected. The agents are identified by their user login ID. The agent "ThinkReservations" will include all non-phone reservations.
Notes on report content:
Subtotal - includes room and non-room charges except that items added directly to a folio within the reservation are not included.
Amount Paid - includes payments added to the reservation and any folio within the reservation.
Balance - the balance due from (+) or to (-) the guest. The balance includes items added to the reservation, items added directly to a folio within the reservation, and payments added to the reservation and directly to a folio.
Best Uses:
To determine the volume of reservations created by each system user for the specified date range. This report is particularly helpful if you are incentivizing staff based on reservation volume. To be most useful, each staff member should have a unique user in ThinkReservations, and staff should log out of the system when leaving a computer.
Other features:
Find Reservations: Booked Between, Arriving Between, In-House Between
Filter by Agent: Yes. No filter produces the entire report sorted in alphabetical order of users.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Booking Pace Report
This report compares the rate at which customers make reservations at one point in time versus another point in time. The dates you select are flexible to allow comparison of any points in time and any date ranges that you want to compare. "Booked As Of" date - includes reservations booked up to the close of the previous day. This is because the report shows booked as of the beginning of that day, and won't include reservations made that day. Not included are sales on "fake" rooms, Point of Sales (POS) sales, gift certificates, or sales on canceled reservations. Fake rooms are indicated to the system by checking the box in that room's settings page labeled: "This room is not a real room and should not be counted for room revenue or occupancy (i.e., meeting room, event space, parking spot, etc.)"
Notes on report content:
Room Subtotal - includes room rate only.
Item Subtotal
Items that are added to the reservation if they are dated within the "Staying Between" dates.
Items that are added directly to a folio within the reservation are not included.
Additional Guest Fees and Pet Fees are included in the Item Subtotal.
Best Uses:
To evaluate how well reservations for future dates are booked this year, compared to the same dates last year.
Can be used to compare 2 periods in the past when evaluating the impact of marketing strategies, guest services changes, etc.
Other features:
Full flexibility to compare any 2 date ranges and related booking dates.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Guest Forecast
This report displays the number of overnight guests that will be at your business within a specified date range, based on reservations booked to date. Additional information includes the number of nights booked and nights blacked out.
Notes on report content:
Arrivals - the number of rooms arriving on the date(s) selected.
Stayovers - the number of rooms staying over on the date(s) selected.
Departures - the number of rooms departing on the date(s) selected.
Adults - the number of adults arriving and staying over on the date(s) selected.
Children - the number of children arriving and staying over on the date(s) selected.
Guests - the total number of guests arriving and staying over on the date(s) selected.
Best Uses:
To plan staffing levels, food requirements, etc. for future dates.
To analyze the adult/child guest mix.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Occupancy Reports
You can choose to view occupancy by day, week, month, quarter, or year within the date range specified. The following notes relate to all occupancy reports.
Notes on report content:
# Days - the number of days in the date(s) selected.
# Rooms - the number of rooms you have on the date(s) selected.
# Available Rooms - multiply # Days by # Rooms.
# Nights Booked - the number of nights booked for the date(s) selected.
# Nights Blacked Out - the number of nights blacked out for the date(s) selected.
Occupancy - Divide # Nights Booked by # Available Rooms.
Occupancy w/Blackouts - # Nights Booked plus # Nights w/Blackouts then divide the sum by the # Available Rooms.
Occupancy reports do not include "fake" rooms - those rooms set to "This room is not a real room and should not be counted for room revenue or occupancy (i.e., meeting room, event space, parking spot, etc.)" in their Rooms settings.
Occupancy reports do not include rooms set to "This room should not be counted for occupancy" in their Rooms settings. This setting is particularly useful with certain linked rooms scenarios to yield an accurate occupancy rate for the property.
Occupancy by Date
This report displays occupancy information by date for the date range selected.
Best Uses:
Run this report if you want to know occupancy for the entire property.
Other features:
Group By: Day (default), Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Occupancy by Room
This report displays occupancy information by room for the date range selected.
Best Uses:
Run this report if you want to know occupancy by room within the property.
Other features:
Group By: Day (default), Week, Month, Quarter, Year.
Filter Rooms: Choose a single or multiple rooms to include in the report. No filter will produce a report including all rooms.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Occupancy by Room Type
This report displays occupancy information by room type for the date range selected. If you do not have Room Types set up, the report will be the same as Occupancy by Room.
Best Uses:
Run this report if you want to know occupancy by room type within the property. This is only useful if you are using room types.
Other features:
Group By: Day (default), Week, Month, Quarter, Year.
Filter Room Types: Choose a single or multiple room type to include in the report. No filter will produce a report including all room types.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Geographic Origin
This report displays the geographic origin of all reservations arriving within a specific date range. The report determines location based on data entered in the State and Country fields on a reservation. Tip: Be consistent when entering the state on a reservation.
Notes on report content:
Origin - the state and country entered in the State and Country fields of a reservation.
Count - the number of reservations arriving on the date(s) selected.
Percent - the the Count for a specific origin divided by the total Count.
Total - the revenue (room and non-room) plus sales tax for the reservations arriving on the date(s) selected.
Best Uses:
To determine which state and country your guests reside in.
Other features:
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Point of Sales Reports
Point of Sales by Date
This report displays sales that were created within a specific date range. A Point of Sale is a bill that does not contain any rooms.
Notes on report content:
Subtotal - includes items added to the bill except that items added directly to a folio within the bill are not included.
Amount Paid - includes payments added to the bill and any folio within the bill.
Balance - the balance due from (+) or to (-) the customer. The balance includes items added to the bill, items added directly to a folio within the bill, and payments added to the bill and directly to a folio.
Best Uses:
To find a point-of-sale bill when you know the approximate creation date.
To determine the volume of point-of-sales invoices and associated dollars created in a specific date range in the past.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Canceled Point of Sales
This report displays sales that were canceled within a specific date range. A Point of Sale bill is a bill that does not contain any rooms. This report shows canceled amounts to track lost revenue as well as post-cancellation amounts that reflect charges the customer is responsible for after the cancellation if any.
Notes on report content:
Canceled Subtotal - includes item charges to the bill immediately before cancellation except that items added directly to a folio within the reservation are not included.
Subtotal - item charges remaining after cancellation. Items that are added directly to a folio within the bill are not included. Important to know: Cancelling a bill does not cancel items added directly to a folio within the bill. The items need to be deleted from the folio if they are no longer valid charges to the customer.
Amount Paid - includes payments added to the bill and any folio within the bill.
Balance - the balance due from (+) or to (-) the customer. The balance includes items added to the bill after it was canceled, items added directly to a folio within the bill, and payments added to the bill and directly to a folio.
Best Uses:
To find a point-of-sale bill that has been canceled.
To review canceled point of sales bills for outstanding balances. Reviewing this report on a frequent/regular basis can help ensure that all outstanding balances on canceled point-of-sales bills are resolved promptly.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Point of Sales by Attribute
This report displays custom bill attribute contents for Point of Sale bills within a specific date range. Only point of sale bills that have a bill attribute entered are included. You must select an attribute to be displayed. The report displays sales revenue excluding tax and including tax for each bill containing a value in the selected attribute.
Notes on report content:
Subtotal - includes items added to a POS bill except that items added directly to a folio within the bill are not included.
Total - Subtotal plus taxes applied items included in the Subtotal.
Best Uses:
To determine the number of bills that contain custom attributes and how much point of sale revenue can be attributed to a specific attribute. For example, this report can help you understand how guests heard about you, why guests stay with you, etc. if these are set up as custom attributes to ask of the guests.
Other features:
Group By: Not available.
Filter by Attribute: Yes. You must specify an attribute to show results.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Point of Sales by Payment Status
This report displays sales that were created within a specific date range and groups them by payment status. A Point of Sale bill is a bill that does not contain any rooms.
Notes on report content:
Subtotal - includes items added to the bill except that items added directly to a folio within the bill are not included.
Amount Paid - includes payments added to the bill and any folio within the bill.
Balance - the balance due from (+) or to (-) the customer. The balance includes items added to the bill, items added directly to a folio within the bill, and payments added to the bill and directly to a folio.
Best Uses:
To review point of sales bills for outstanding balances. Reviewing this report on a frequent/regular basis can help ensure that all outstanding balances on point-of-sales bills are resolved promptly.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Payment Status: Overpaid, No Payments, Partially Paid, Paid in Full. No filter will produce the entire report sorted in the order above.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Accounting Reports
Note for all Accounting Reports: Accounting reports will be most effective if all Rooms, Items, Taxes, and Payments Types are assigned to an appropriate account as set up in the Chart of Accounts.
Also, see our article on Accounting Reports and Features for examples of how you to effectively use our reports and features to interface with your accounting system.
Summary
This report displays the net debit or credit for each account for the dates specified. It is a high-level view of exactly how your account balances/activity changed within a specific date range. The report is in the form of an adjusting journal entry.
Best Uses:
To review daily, weekly, or monthly business.
To create a journal entry in your accounting records to record the results of your business activity.
Other features:
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - No
Accounts
This report shows journal postings by account for the dates specified. This report is useful to understand why an Account value has changed within a specific date range. It supports the Summary report with transaction details.
Best Use:
To research the activity in an account as reported in the Summary report.
Other features:
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Journal
This report shows each journal entry for the dates specified. A journal entry details how an individual transaction (sale, payment, etc.) affected the account activity reported in the Accounts report.
Best Use:
To view the accounting entry for a single transaction to understand the impact on the accounts as reported in the Accounts and Summary reports.
Other features:
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Night Audit
(Requires the Night Audit feature to be enabled)
This report walks you through a structured audit process to ensure that your past activity recorded in ThinkReservations is accurate. Once completed, Night Audit will lock the dates that you audited in ThinkReservations, which will prevent changing or deleting a transaction that was audited or adding a transaction to an audited date. When the night audit has locked dates, they cannot be unlocked. For more details, see Night Audit Explained.
Best Uses:
Increase the integrity of your financial reports when you run Night Audit in conjunction with preparing accounting entries in your accounting system. ThinkReservations will support in detail the balances and activity reported in your accounting system.
Increase control over your records and your security. Prevent unauthorized predated transactions which may be used to cover nefarious behavior.
Guest Ledger
(Requires the Night Audit feature to be enabled)
The Guest Ledger report displays the status of guest reservations/folios for in-house guests as of a specified date. It will also include the outstanding balance for a guest who has departed. The balance is calculated through the date of the report by adding the revenue earned through the date of the report, plus applicable taxes, less payments applied through the date of the report. The report will run only for dates that have been subjected to Night Audit.
Best Use:
Use the Guest Ledger report to reconcile to and support the balance of the Guest Ledger account in your financial system.
Other features:
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Ledger Comparison
(Requires the Night Audit feature to be enabled)
The Ledger Comparison report compares the ending balance of the date selected to the ending balance of the previous day for each of the four account ledgers in ThinkReservations. The four account Ledgers are: 1) the Advance Deposit Ledger which is supported by the detail in the Deposit Liability report, 2) the Gift Certificate Ledger which is supported by the detail in the Gift Certificate Liability report, 3) the Guest Ledger which is supported by the detail in the Guest Ledger report, and 4) the Accounts Receivable Ledger which is supported by the detail in the Accounts Receivable Aging report.
Best Use:
The Ledger Comparison report provides a high-level view of the changes in the daily balances of the four important account ledgers.
Other features:
Printable - Yes
Exportable - No
Live links to supporting reservations or bills - N/A
A/R Aging Summary
(Requires the Night Audit and Accounts Receivable features to be enabled)
The A/R Aging Summary report displays the balance due on House, or City Ledger, Accounts grouped by aging category 0-30, 31-60, 61-90, 91-120, and over 120 days. These House Accounts are typically for corporate and institutional entities that have negotiated billing and payment terms with a property in exchange for a large volume of business over a period of time. For more details on the Accounts Receivable feature, see Accounts Receivable Feature.
Best Uses:
Used to manage customer Accounts Receivable to ensure balances due are collected on a timely basis.
To reconcile to and support the balance in the Accounts Receivable account in your accounting system.
Other features:
Printable - Yes
Exportable - No
Live links to supporting account numbers - Yes
Revenue Reports
Revenue by Date
This report displays how much revenue was earned within a specific time period. It includes all revenue (items and rooms) and related sales/occupancy taxes.
Best Uses:
To determine total revenue for a specific date range.
To find the source of a particular sale when an approximate date is known.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Revenue by Room
This report displays how much revenue was earned from the rental of rooms within a specific time period. It includes room revenue only and related sales/occupancy taxes. Quantity is the number of room nights. Additional Guest Fees and Pet Fees are not included. Subtotals are calculated for each room.
For settings that can affect the content of the Revenue by Room report, see Linked Rooms - Room Settings and Reports.
Best Uses:
To determine room revenue in total and/or for a room for a specific date range.
Assist in evaluating the performance of one room versus another.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Room: Yes. No filter produces the entire report sorted in alphabetical order of rooms.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Revenue by Item
This report displays how much revenue was earned from your sales of Items and Packages within a specific time period. This report contains item revenue only and related sales/occupancy taxes. It includes Additional Guest Fees and Pet Fees. This report does not contain Room revenue. Subtotals are calculated for each item.
Best Uses:
To determine revenue for a particular item for a specific date range.
Assist in evaluating the performance of non-room revenue sources such as gift shop items, food & beverage items, and other upsell items.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Item: Yes. No filter produces the entire report sorted in alphabetical order of Items.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Revenue by Rate Type
This report displays how much revenue was earned per rate type within a specific time period. Room rental, Additional Guest Fees, and Pet Fees are included. Items that are bundled together within the rate type in a room package are also included. All other Items are excluded from this report.
Best Uses:
To determine the reservation volume and revenue booked by each rate type for a specified date range.
To evaluate the effectiveness of special rate types and package rate types.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Rate Type: Yes. No filter produces the entire report sorted in alphabetical order of Rate Type.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Revenue by Account
This report displays how much revenue was recognized per revenue account within a specific time period. All items and rooms are included in this report. Items and rooms that are not assigned to revenue accounts will be included in "Uncategorized" Revenue. To get the most out of this report, revenue accounts must be set up in advance in Settings > Chart of Accounts, and then assigned to Items and Rooms in their respective settings. See Chart of Accounts.
Best Uses:
To determine revenue earned classified by revenue account for a specified date range.
As additional detailed support for the revenue account totals on the Accounting Summary report.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Account: Yes. No filter produces the entire report sorted in alphabetical order of Account.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Revenue by Agent
This report displays how much revenue was recognized per agent (employee at your property) within a specific time period. The Agent that adds an item or room is the agent that will be attributed to the revenue. This report contains all revenue. Revenue booked online (rooms and items) through your Booking Engine will be included under user tr_booking_engine. Revenue booked through OTA's connected to ThinkReservations' Channel Manager will be included under user "ThinkReservations."
Best Uses:
To determine revenue generated per employee for use in an incentive compensation plan.
To look for trends and compare who is selling what items/rooms.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Agent: Yes. No filter produces the entire report sorted in alphabetical order of Agent.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
RevPAR (Revenue Per Available Room) Reports
Room revenue on these reports includes pet fees and additional guest fees. Other items are not included. For settings that can affect the content of the RevPAR reports, see our article Linked Rooms - Room Settings and Reports.
RevPAR is calculated by dividing room revenue (rooms, pet fees, and additional guest fees) by the total room nights available for a specified date range. Alternatively, multiplying the ADR by the occupancy rate yields the same result. It measures the revenue-generating performance of the property by incorporating both ADR and occupancy into the measurement.
You can choose to view RevPar by day, week, month, quarter, or year within the date range specified. The report displays the number of Nights (in the date range specified), Number of Rooms (room nights available in the date range specified), Number of Occupied Rooms, Occupancy (# Occupied Rooms / # Rooms), Room Revenue, Average Daily Rate (Room Revenue / # Occupied Rooms) and RevPAR (Room Revenue / # Rooms).
RevPAR by Date
This report calculates your Revenue Per Available Room (RevPAR) for the entire property by day within a specific time period.
Best Use:
To determine your total RevPAR by day for a specified date range.
Other features:
Group By: Day (default), Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
RevPAR by Room
This report calculates your Revenue Per Available Room (RevPAR) for each room within a specific time period.
Best Use:
To determine your RevPAR by day at the room level for a specified date range. The report may be helpful when making pricing decisions and exploring marketing and promotional opportunities.
Other features:
Group By: Day (default), Week, Month, Quarter, Year.
Filter by Room: Yes. No filter produces the entire report sorted in alphabetical order of Room.
Printable - Yes
Exportable - Yes
Payments Reports
Payments applied to House Accounts (Accounts Receivable) are not included in the following Payments reports. These Payments reports include only payments applied to reservations and POS bills. Payments applied to House Accounts are included in the Accounting reports where applicable.
Payments by Date
This report displays the payments received from customers for the date range specified in chronological sequence showing the payment type, Confirmation ID, guest name, reference #, and the amount for each payment.
Best Use:
To research or review payments received from customers within a specific date range.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Payments by Type
This report displays the payments received from customers for the date range specified in chronological sequence by payment type showing the payment type, Confirmation ID, guest name, reference#, and the amount for each payment, subtotaling for each payment type.
Best Uses:
To research or review payments received from customers within a specific date range.
To analyze and look for trends in payment processing.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Payment Types: Yes, for the standard payment types only - Cash, Check, Credit Card, Direct Bill, Gift Certificate, Third Party Credit Card Processor, and Third Party Gift Certificate. Custom payment types are not included in the filter at this time., No filter produces the entire report sorted in alphabetical order of Payment Type.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Payments by Agent
This report displays the payments received from customers for the date range specified in chronological sequence by agent/user (employee) showing the payment type, Confirmation ID, guest name, reference#, and amount for each payment, subtotaling for each agent.
Best Uses:
To research or review payments entered by users within a specific date range.
To analyze and look for trends or irregularities in payment processing.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Filter by Agent: Yes
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Payments by Agent and Type
This report displays the payments received from customers for the date range specified in chronological sequence by agent/user (employee) and type showing the payment type, Confirmation ID, guest name, Folio #, Folio Customer Name, reference#, and the amount for each payment, subtotaling for each agent.
Best Uses:
To research or review payments entered by users within a specific date range.
To analyze and look for trends or irregularities in payment processing.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Shift Change
This report displays payments created within the date and times specified. It is subtotaled for each payment type. The report displays the Date/Time created, payment date, payment type, confirmation #, guest name, folio #, folio customer name, reference # and amount. Please note the time zone is always the business time zone.
Best Uses:
To reconcile and report payments received for each shift at the front desk. You have the flexibility to define the shift time parameters.
To analyze and look for trends or irregularities in payment processing.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Credit Card Batch
This report displays credit card payments with a payment date between the dates specified. Note that your payment processor might not be set to batch out at the end of the day, batch several times a day (Braintree), or batch after every transaction (Stripe). Payments are sorted and totaled by credit card type. Payments are shown in chronological sequence within each payment type showing payment date, payment type, confirmation # guest name, folio #, folio customer name, reference #, and amount.
Best Uses:
To reconcile the credit card payments entered in ThinkReservations to your payment processor's batch or daily report of payments processed.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Deposits Received by Date
This report shows advance deposits (payments made before the first billing date on the reservation) that were received between the dates specified. The report displays the date of payment, payment type, confirmation ID#, guest name, reference #, and the amount of payment. Please note that multiple payments made in advance on one reservation or bill will be displayed separately in the report.
Best Uses:
To review advance deposits received and added to the Deposit Liability account.
To assist in the Deposit Liability account reconciliation.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Deposits Applied by Date
This report shows deposits that were applied to guests' folios and added to the Guest Ledger for the dates specified. The report displays the date of payment, payment type, confirmation ID#, guest name, reference #, and the amount of payment. Please note that if there are multiple payments made in advance on one reservation or bill, each payment will be displayed in the report separately. Deposits are applied to the folios and Guest Ledger on the date the guest arrives. Deposits on a non-room bill will be applied on the earliest date of sale of an item on the bill.
Best Uses:
To review advance deposits applied to guest folios and added to the Guest Ledger for the specified date range.
To assist in the Deposit Liability and Guest Ledger account reconciliations.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Deposit Liability
This report shows your total liability for advance deposits as of a specified date. The report displays the date of payment, payment type, confirmation ID#, guest name, reference #, and the amount of payment. Please note, that if there are multiple payments made in advance on one reservation or bill, each payment will be displayed in the report. The report should contain only payments received for future reservations or bills as of the date specified.
Best Use:
Use the Deposit Liability report to reconcile to and support the balance of the Deposit Liability account in your financial system.
By grouping the report by month or week, you may get a high-level understanding of how far in advance guests are booking. It depends on your deposit policy when making a reservation.
Other features:
Group by: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations or bills - Yes
Front Desk Reports
Front Desk reports are designed to provide you with the added tools to manage your time and the time of your front desk, housekeeping, and kitchen staff.
Availability Calendar
This report displays a chart detailing availability within a specific date range. If the room is available, we will display the price of that room for the requested rate type.
Room Assignment Chart
This report displays a chart that displays which guests are staying within the dates specified.
Arrivals
This report displays all the customers who are arriving within the dates specified. The report is sorted by date and displays the guest name, room, check-in and check-out dates, # nights, # guests, and notes accompanying the reservation.
Departures
This report displays all the customers who are departing within the dates specified. The report is sorted by date and displays the guest name, room, check-in and check-out dates, # nights, # guests, and notes accompanying the reservation.
Guests in House
This report displays all the customers who are in-house within the dates specified. The report is sorted by date and displays the guest name, room, check-in and check-out dates, # nights, # guests, and notes accompanying the reservation.
Housekeeping
This report details the housekeeping activities for reservations within the dates specified. The report is sorted by date and then by Arrivals, Departures, and Staying Over. The report displays the room, guest name, status, check-in and check-out dates, # guests, and notes accompanying the reservation.
Housekeeping by Room Group
This report details the housekeeping activities for reservations within the dates specified and groups them by room group.
Kitchen
This report displays all dietary preferences of the customers who are in-house. The report is sorted by date and displays room, guest name, status, check-in and check-in dates, # nights, and notes accompanying the reservation.
Batch Printing
This report allows you to print many reservations in a batch. You select either arriving or departing reservations, select the date of arrival or departure, and choose which form you want to be printed. You will be able to choose from any of the print templates created for your property, the same forms that are available to print on an individual reservation. All reservations meeting the selection criteria will be displayed. Click on "Print" to print the forms.
Gift Certificate Reports
Gift Certificates Sold
This report shows gift certificates sold for the dates specified. The report displays the date issued, gift certificate #, expiration date, sale price, redeemable value, and amount remaining.
Best Uses:
To review gift certificates sold and added to the Gift Certificate Liability account for the specified date range.
To assist in the Gift Certificate Liability account reconciliation.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting gift certificates.
Gift Certificates Redeemed
This report shows gift certificates redeemed for the dates specified. The report displays the date redeemed, gift certificate #, confirmation #, guest name, and the amount redeemed.
Best Uses:
To review and quantify gift certificates redeemed for the specified date range.
To assist in the Gift Certificate Liability account reconciliation.
Other features:
Group By: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - No
Live links to supporting reservations or bills - Yes
Gift Certificates Liability
This report shows your total gift certificate liability as of a specified date. The report displays the date issued, gift certificate #, expiration date, sale price, redeemable value, and amount remaining. Note that the report includes only gift certificates that have not expired. The ledger comparison report (enabled for some clients) does include expired certificates in the Gift Certificate Ledger balance.
Best Use:
Use the Gift Certificate Liability report to reconcile to and support the balance of the Gift Certificate Liability account in your financial system.
Other features:
Group by: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting gift certificates.
Taxes
Our tax reports are designed to help you understand, analyze, and summarize the taxes you have collected on behalf of your state and local tax authorities so that you can accurately report and remit these taxes to the proper authorities. For the most accurate tax reporting, ensure your taxes are set up individually under Settings > Taxes. Refer to Changing Tax Settings for guidance in setting up your taxes.
Tax-Exempt Sales and Non-Taxable Sales
Tax-exempt sales include revenue derived from rooms and items that have taxes associated with them in settings and therefore would be otherwise taxable except for a special tax-exempt status marked on the bill. This is usually allowed to a class of customers by a tax authority, which is typically written into its tax law. Tax-exempt sales data is collected from specific Bills/Reservations where the tax-exempt edit is applied to select or all taxes. Tax-exempt sales are explicitly reported in a separate column in the tax reports.
Non-taxable sales include revenue derived from items where no tax is assigned to an item, and from room revenue associated with a rate type where a tax or taxes have been overridden or not applied. Non-taxable items may include gift certificate sales, cancellation fees (in many states, not all), and shipping/handling fees to cover shipping guest clothing left behind. Non-taxable sales will also include room revenue from Airbnb and OTA reservations where Airbnb and OTAs collect and remit taxes. Non-taxable sales are not explicitly reported in our tax reports. They are not included in the revenue reported in the Tax Summary and Taxes by Date reports. They are included in the revenue reported in the Taxes by Item and Taxes by Account reports.
Tax Summary
This report provides tax collected by tax name for the period specified. It also displays total taxable sales and total tax-exempt sales by tax name. This report does not contain non-taxable sales.
Best Use:
Use the Tax Summary report to complete your tax collection and remittance report to your state and local authorities.
Other features:
Group by: No grouping. This is designed as a summary report for the period specified. See the Taxes by Date report.
Printable - Yes
Exportable - Yes
Live links to supporting reservations and bills - No. See the Taxes by Date report.
Taxes by Date
This report provides detailed support for taxes collected for the period specified. For each tax name, it reports in chronological sequence every line item on every reservation and bill where the tax is calculated. The report includes the Date, Name (of room or item), Confirmation ID, Guest Name, Folio #, Folio Customer Name, Quantity, Subtotal, Taxable Sales, Tax Exempt Sales, and Tax Collected. This report does not contain non-taxable sales.
Best Use:
Supporting detail for the Tax Summary report.
Other features:
Group by: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations and bills - Yes
Taxes by Item
This report provides detailed support for taxes collected for the period specified. It reports in chronological sequence within each item every instance of the item being sold on every reservation and bill. The report includes Date, Name (of room or item), Confirmation ID, Guest Name, Folio #, Folio Customer Name, Subtotal (revenue $), Tax Name, Taxable Sales, Tax Exempt Sales, and Tax Collected. This report does contain non-taxable sales in the Subtotal column.
Best Use:
To research potential tax inconsistencies at the Item level.
To derive sales not subject to any tax by comparing the Subtotal column in Taxes by Item to the Subtotal column in Taxes by Date.
Other features:
Group by: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations and bills - Yes
Taxes by Account
This report provides detailed support for taxes collected for the period specified. By account, it reports in chronological sequence every instance of an item being sold on every reservation and bill. The report includes Date, Name (of room or item), Confirmation ID, Guest Name, Folio #, Folio Customer Name, Subtotal (revenue $), Tax Name, Taxable Sales, Tax Exempt Sales, and Tax Collected. This report does contain non-taxable sales in the Subtotal column.
Best Use:
To research potential tax inconsistencies at the Account level.
To derive sales not subject to any tax by comparing the Subtotal column in Taxes by Account to the Subtotal column in Taxes by Date.
Other features:
Group by: None, Day, Week, Month, Quarter, Year.
Printable - Yes
Exportable - Yes
Live links to supporting reservations and bills - Yes
Google Hotel Ads
These reports are found in the menu at the top of ThinkReservations
Google Ads Campaign
The Front Desk Report shows Arrivals, Departures, and Stay-overs for any one day. The report will also show all the reservation notes. If the guest is a repeat guest, they will have a white star in a green square.
Google Ads Reconciliation
The Tasks Report shows all overdue tasks, tasks that are not associated with a bill, and tasks for the next two weeks.
New reports will be added and updated from time to time. If you have a request for a report, please let us know!