Financial Reports
Lodgix offers a comprehensive suite of reports to slice, dice and export your data in a variety of ways.
List of Financial Reports
All financial reports can exported to excel or printed as a pdf.
Advance Deposits Report
The Advance Deposits report allows the property manager to report on how much money has been taken in as a reservation deposit for stays that have not yet occurred.
Comparative Revenue Report
The Comparative Revenue Report compares two income detail reports to show all bookings that were recorded by a certain date for any given year. This data allows you to make mid course corrections in the event that your bookings are down (or up!).
Note: The Comparative Revenue report uses the same data calculation methodology as the Income Detail report -
Data Dump Report
The Data Dump report is not really a report. It's primary purpose is use as a data backup. However if you have data that you want to parse using your own tools, the Data Dump Report will spit it all out for a given time frame, and download it directly into excel. It doesn't output to the screen due to the number of columns in the report.
How is the Data Dump Report calculated?
The data dump report includes only invoices where the reservation end date (departure date) falls within the reporting period. Thus if the departure date is not within the chosen reporting period, the invoice will not show up in the data dump report.
As an example, if the data dump report is run for a period of 1 December to 31 December and there is a guest invoice with an arrival date of 30 Nov and a departure date of 7 Dec, the invoice totals for that entire guest stay will be included on the data dump even though 1 night of the stay was in November.
This differs from the Income Detail report. The Income Detail Report includes all days for an invoice that fall within the chosen reporting period. The Income Detail Report does not consider the arrival date or departure date of an invoice.
Discounts Report
The Discounts Report displays an itemized list of any invoices containing automated or coupon code related discounts for a specific period of time.
Fees and Services Report
The Fees and Services Report displays an itemized list of all service and fee revenue for the reporting period. One-time fees manually added to invoices are all grouped and listed as "Other Fees".
Note that this report is based on departure date, and will only include reservations with end dates that fall within the reporting period. It will not include reservations that start during the reporting period and end outside of it. The data is calculated in the same fashion on the data dump report.
However, for the income detail report, which also reports on fee / service revenue, days are prorated in a reservation if the reservation spans through the reporting period. That will result it inconsistencies if amounts are compared across multiple reports. How the report is calculated is always shown at the bottom of the report.
Receivables Report
The Receivables Report shows all owed monies broken out by month. The report can also report on all or selected individual units. If an invoice is in an unconfirmed state and the guest has to pay the confirmation amount by a certain date and the remaining balance at a later date, that invoice will be listed twice on the report in the respective month in which monies are owed.
Income Detail Report
The Income Detail report limits revenue reporting to a given period. Unlike the data dump report, which includes the totals for an entire guest invoice if the departure date on the invoice falls within the data dump reporting period, the Income Detail report will slice through a guest invoice if the arrival and departure date of a guest's stay don't both fall within the reporting period. This results in differences between the numbers reported on the data dump report and Income Detail report.
How is the Income Detail Report Calculated?
NOTE: TOTAL REVENUES = DOES NOT INCLUDE TAX
If the arrival and departure dates on the guest invoice fall within the reporting period of the report, then the invoice totals are used. However, using the same example as was used in the data dump report, if the Income Detail report is run for a period of 1 December to 31 December and there is a guest invoice with an arrival date of 30 Nov and a departure date of 7 Dec, the Income Detail report will use a formula to determine what portion of the revenue on that invoice can be attributed to 1 Dec to 7 Dec.
Cancellation Fees
Remember when an invoice is canceled, a cancellation fee may be assessed. If a cancellation fee is assessed it will show up under Fee / Service revenue on the Income Detail report. This can be confusing as when the calendar tape is referenced and the individual invoices summed to arrive at the report numbers, the canceled invoices containing those cancellation fees are obviously not present on the calendar tape. To see the canceled invoices containing the cancellation fees the data dump report would have to be run.
Income Summary Report
Income Summary Report reports income,occupancy rate, days rented, total tax - by month.