Home > Questions and Answers > Data Flow
Groups
Individuals
City Ledger (Direct Bill) and General Ledger
POS to PMS
Interfaces
These are not procedural instructions. This is simply a description of data flow and a few procedural comments.
The Group is created.
Individual reservations are made.
Guests are checked in.
Reports - Reservations:
Guests are checked out.
Reports - Other
Individuals (not with a Group)
Reservation
The reservation is made. The guest's credit card is validated. The deposit is applied to the reservation (if this is your policy) and posts to the Advance Deposit Master Folio where it resides until the reservation is checked in. Note that you do not need to make a reservation for a walk-in guest. You can go straight to check-in.
Check in
The guest is checked in either from a reservation or as a walk-in. If the guest paid an advance deposit, the deposit will move from the Advance Deposit master folio to the guest folio, posting a DEPU debit to the AD master and a DEPU credit to the guest folio, giving you a NET of zero on the payment journal. If your payment journal does not show matching debits and credits for DEPU then someone posted this code manually (which you should not do), someone ran "Update Advance Deposit Master Folio" from the night audit menu (which you should not do except at its appropriate time during night audit), or something went amiss at check-in. The "total room and tax less deposit" will display at the bottom right screen. You should preauthorize the guest's credit card if this is your policy. If you do not preauthorize credit cards at check-in, you should answer Yes to "post payment now" to post the payment when the check-in is completed. NOTE: Do not both preauthorize a credit card and post a payment at check-in. You can do one or the other but not both. Doing so will cause the guest's credit card to show a sale transaction AND set aside the amount preauthorized. If you need to preauthorize a second card or set up a second payment type, then answer Y to "split folio?". This will allow you to split the guest's folio into two folio, a primary folio for room & tax charges and a secondary folio for incidental charges. This is common for direct bill and wholesaler guests.
During the stay: Restaurant and other charges may be posted to the guest's folio. If the guest has a split folio, then incidentals will automatically post to the secondary folio. Room and tax charges will post nightly when "Post room and tax" is run from the Night Audit menu. If the guest's rate code is W the room and tax charges will post only once a week, on the day selected at check-in. If the guest's rate code is M, the room and tax charges will post only once a month, on the day selected at check-in. If the guest's rate code is P, all package charges will post per the parameters of the package. If the guest is moved to another room, the guest's folio(s) will move to the new room. This will noted in the Activity Log printed from the Manager/ Setup menu. The night auditor or another staff member may print a "guest trial balance" report to make sure that guests have sufficient remaining credit. Additional funds may be preauthorized on the guest's existing credit card on file if necessary.
Check Out
At check-out the system should take you straight to the Post Payment screen if the guest folio does not have a zero balance. This will allow you to process the preauthorized credit card, void the preauthorization and process a new credit card, or receive another form of payment. You should not go to Post Payment before going to check-out if there is a credit card preauthorization, as it is the check-out process that post transactions against the preauthorization and clears any remaining held funds. The checked out guest will "sit" in the active folio file and you may reverse the check-out at this time should you need to process any further transactions. Note that after check-out there is no remaining credit card preauthorization and the approval code has cleared. You will have to look up the most recent sequence number for this guest. If you process a credit card after a reverse check-out you will be prompted for a sequence number, as the preauthorization has already been removed. After night audit Reorganize Files, checked out guest folios and closed master folios will move to Guest History and will not longer be accessible to process transactions. Once a folio is in Guest History you must open a new folio in order to process additional transactions.
City Ledger (Direct Bill) and General Ledger City Ledger / Direct Bill transactions and General Ledger transactions are created when "Create City Ledger/Gen. Ledger Postings" is run from the night audit menu. City Ledger:
General Ledger:
POS to PMS When a POS ticket/check is closed, transactions are posted into the POS master folio. The folio balance should be zero after each check. The debits posted to the folio are hotel charge codes and can include product or service sales, taxes, gratuities, and tips. The credits posted to the folio are hotel payment codes and can include cash, credit cards, checks posted to guest rooms, checks posted to master folios, and gift cards. Voided POS checks will create opposite postings in the folio. Credit POS checks will create opposite postings in the folio. POS settings must be correct for the transactions to post correctly into the POS master folio. These will print on the charge and payment journals, the recaps, and the AM & Daily Reports. When a POS check is closed to a guest or master folio, a credit is posted into the POS master folio and a debit is posted to the guest or master folio. Checks are closed to master folios if payment will be made at a later time and there is no guest room to post to. This might occur with a group's POS charges where the group entity is paying. This also will occur with POS checks closed "Manager". "Admin" etc. Some POS outlets close checks directly to City Ledger (direct bill) without going through folios. This is done as an A/R Charge and the account must exist in city ledger (direct bill). These post a debit (charge) to the account, to be later offset by payment from the customer.
Reservations - GDS/CRS, etc. - OTA/HTNG
PBX, Call Accounting, Movie, Keys, etc.