Report overview
The period end report will summarise the revenue, payments and occupancy figures processed within the start date/time and closed date/time of the given period end report.
Periods can be closed per shift, per day, per week, or per month either:
Manually: By navigating to Rezlynx, Accounting, Period End, Current periods, and selecting Close next to the required period.
Automatically: By setting fiscal periods within the system to ensure the Period Ends are closed automatically, including End of Year.
Closed periods can be viewed by navigating to Rezlynx, Accounting, Period End, Period End Archive and selecting View next to the required period, or select Detailed report to export a CSV file containing all of the information.
Report output
The report can be viewed in the following formats: direct print, viewer on screen, PDF, Excel, Email, and Detailed Extract showing a CSV file with each line of the report data detailed. The report output below is seen when selecting direct print, viewer, PDF and email.
The figures below are all taken from a test site and are just offered as an example.
The report output is broken in the following sections:
Analysis codes
This is a summary of the total revenue against each analysis code, which has been added or removed from the room bills. Minus values show a refund whilst positive values show as a positive value. This section can be compared with Revenue (By Analysis Group) when filtered by Period ID.
At the bottom of this section, a grand total of all the revenue added or removed from room bills is shown.
Payment totals
This is a summary of the total of payments taken, which shows as a minus value or a positive value if refunded.
At the bottom of this section, a grand total of all the the payments taken is shown.
This section can be compared with Payment Analysis when filtered by Period ID.
Deposit Analysis
This is a summary of the deposits taken.
DEP_BFWD: Total of all deposits held, brought forward from the previously closed "Period End" report.
DEP_RECVD: Total of all new deposits added to reservations.
DEP_REFUD: Total of all deposits that have been refunded.
DEP_RETND: Total of all deposits retained, rather than refunded.
DEP_INHOUSE: Total of all deposits that are now activated on residential bills.
DEP_BAL_ACT: Total of all deposits that are currently held on reservations (not yet checked in).
This section can be compared with Payment Analysis when filtered by Period ID.
Ledger Analysis
This is a summary of ledger or aged debtor activity.
LEDG_BFWD: Total of the outstanding ledger balances brought forward from the previous closed Period End report.
LEDG_DEBITS: Total of all new transaction and invoices added to ledger balances.
LEDG_CREDITS: Total of all credit notes and payment transactions added to ledger balances.
LEDG_BAL_ACT: Total of all outstanding ledger balances that are currently held on your aged debtors.
LEDG_TOTCC: Total of all credit card payments added to ledger balances.
LEDG_TOTNCC: Total of all non-credit card payments added to ledger balances for example cash, BACs, etc.
This section can be compared with Ledger Analysis report within Rezlynx when filtered by Period ID.
In House Analysis
This is a summary of the room balances for guests checked in at the time the report was created.
IHO_BAL_BFWD: Total of the in-house room bill balances brought forward from the previously closed period end report.
IHO_TO_ANAL: Total of all analysis code postings added to in-house room bill balances, including deposits retained.
CHO_TO_ANAL: Total value of sales received during the end of period, that have also been checked out in the same period.
IHO_TO_PAYS: Total of payments added to in-house room bill balances, less deposits retained.
CHO_TO_LXFR: Total of revenue sales on all checked out to a ledger or aged debtor.
IHO_BAL_ACT: Total of the in-house room balances on folios.
Balance Brought Forward Analysis
This is a summary of the balances brought forward from the previous periods report. Should you wish to see the breakdown of these totals you could view the previous days Detailed Extract report or using the storage reports if these are configured for your site.
LEDG_BFWD: Total outstanding ledger balance, brought forward from the previous Period End report.
DEP_BFWD: Total deposits held balance, brought forward from the previous Period End report.
IHO_BAL_BFWD: Total of all in-house room bill balances, brought forward from the previous Period End report.
BFWD_TOT: Total of all the balances above brought forward from the previous Period End report.
Balance Carried Forward Analysis
This is a summary of the balances to be taken or carried forward to the next period end report. These values will show within the Balance Brought Forward Analysis within the next period end report.
LEDG_BAL_ACT: The current total outstanding ledger balance, to be carried forward to the next Period End report
DEP_BAL_ACT: The current total deposits held balance,, to be carried forward to the next Period End report
IHO_BAL_ACT: The current total of all in-house room bill balances, to be carried forward to the next Period End report
CFWD_TOT: The total of all of the above, deposit/ledger/in-house, to be carried forward to the next Period End report
Debt Movement
This is a summary of the balance brought forward from the previous period end report, the balances to be carried forward and the difference between those balances.
BFWD_TOT: The total of all ledger/deposit/in-house balances, brought forward from the previous Period End report. This is calculated as: IHO_BroughtForward + Ledg_BroughtForward + Dep_BroughtForward = BFWD_TOT
CFWD_TOT: The current total of all ledger/deposit/in-house balances be carried forward to the next Period End report. This is calculated as: IHO_Balance_Actual + Ledg_Balance_Actual + Dep_Balance_Actual = CFWD_TOT.
DEBT_MVMT: The difference between the brought forward and carried forward figures.
Tax Analysis
This section summarises the total sales with the tax analysis, for each of your tax codes. Your property may have more than two tax codes and this is dependant on how your tax rules have been configured. The Tax Totals are made up of the total VAT of any analysis codes that have been posted to for that period. The Tax Totals also include any VAT calculated on the Deposits Received for that day considering any deposits which have been refunded, retained or changed to an in-house status and these calculations can be reviewed further.
Occupancy
⚠️ Important: Your occupancy figures are generated once your 'Period End' report has been closed, when viewing a current period these figures will not be present. When viewing a closed 'Period End' report you will find these figures at the end.
ROOM STOCK - The total number of rooms you had in the hotel (minus any room put 'Out Of Order' as 'Deducted From Stock').
ROOM OOS - The total of rooms you have put out of order, with a status of 'Out Of Order'.
ROOMS DFS - The total of rooms you have put out of order with a status of 'Deducted From Stock'
ROOMS SOLD- The total of rooms you sold.
ROOMS AVAILABLE- The total of rooms you had left available.
OCCUPANCY % - Your occupancy percentage (not including rooms 'Deducted from Stock')
SLEEPERS- The total of adults, children and infants for your sold rooms.
AVERAGE ROOM RATE - Your average room rate (based on your accommodation analysis codes revenue figure and the number of rooms sold).
AVERAGE PACKAGE REVENUE- Your average package rate (based on the rate plan totals and the rooms sold)
YIELD- Revenue per room (based on your accommodation figures and the number of rooms in your stock)
