OwnerRez reports are extremely powerful and complex, and not all situations are immediately obvious as to how they are best handled.
- Is there a report that will give me the ADR ("Average Daily Rent") or ADG ("Average Daily Gross") for a month period?
- How can I see how many times / on what bookings my Discount Codes were used?
- Is there a report showing the values for custom fields on my Bookings?
- How can I see what door lock codes were assigned to Bookings?
- How can I see how much I had to pay in a given surcharge for bookings that were canceled and refunded?
- I'm using a Detail report, and it's showing the same type of charges in multiple columns when they should be in just one column.
- How can I get a report of taxes remitted directly by the channels, as opposed to taxes I have to remit?
- How can I get a report of scheduled cleaning dates?
- How can I get a report of cancelled bookings?
- How can I see what money is still owed to me?
- How do I configure a report to display undeposited payments?
Our Booking Summary report has a selector for the value to show. ADR and ADG are options in that selector. The Booking Detail and Line Item Pivot reports include this selector as well.
ADR means Average Daily Rent
ADG means Average Daily Gross
They are essentially the same, except "gross" looks at the total collected per night (including cleaning, taxes, etc) and the other just gives you pure rent.
There isn't a report that does this specifically, but the Line Item Pivot Table report includes a column for any Discount Codes that may have been used in the direct bookings it's reporting on. You can export this report to Excel, filter or sort by discount code, and sum up totals.
There isn't a report that does this specifically, but there's an option for that in the Stays By Date Range report:
This will display all custom fields on all Bookings (including canceled) that have not been deleted.
Go to Reports > Stays By Date Range. That report will include any door code values you have set in the Custom Fields column, including the ones from manual door lock setup.
How can I see how much I had to pay in a given surcharge for bookings that were canceled and refunded?
Run the Line Item Pivot report - make sure to select the option to include canceled bookings.
Then you can look at the Status column to find the canceled bookings, and the column for that surcharge to total the amount. It may be easiest to Export the report to Excel and manipulate it there.
I'm using a Detail report, and it's showing the same type of charges in multiple columns when they should be in just one column.
When a Detail report is generated, the system sorts charges into columns based on the charge descriptions. Charges with identical descriptions will appear in the same column; charges with different descriptions will appear in different columns. If you are seeing multiple columns that are actually the same type of charge, that's because the descriptions of your charges are inconsistent. This is most likely caused by mistakes in the settings of your Surcharges, or occasionally with certain channels. You can identify the specific bookings with mismatched charge descriptions and fix them in their Charges tab, to make your report sort properly.
How can I get a report of taxes remitted directly by the channels, as opposed to taxes I have to remit?
The regular Taxes report only shows taxes where the money passed through your hands and you needed to send it in to the appropriate taxing authority yourself.
However, Airbnb commonly collects some or all taxes and remits the money themselves directly. You don't ever receive this money, but you also aren't liable for those taxes since they've already been paid. Non-API Vrbo bookings will also have taxes collected and remitted by Vrbo.
Taxes handled this way, appear in OwnerRez as guest fees charged by the channels. They appear on the Listing Site Fees report.
There isn't one, as such. But, if you go to the main Bookings screen, List view, and Export, the cleaning dates will be included in the resulting Excel file.
There isn't one, as such. But, you can go to the main Bookings screen, List view, and use the Filters to get a list of them - select Booking Status = Cancelled.
Go to the main Bookings screen, List view. If desired, use the Filter to control what bookings are included in the list. Then, Export to Excel. The resulting Excel file will include an Owed column.
Users can run the Payment Summary report to see if there are any undeposited payments for a previous time frame with the following configuration.
Users can also run the Payment Details report with these criteria so they can see a list of each reservation with undeposited payments.