• Email Support


    OnRes Systems Inc.
    506 -145 West Keith Road
    North Vancouver, BC
    Canada V7M 1L3
    1.866.687.7057 Toll Free in North America
    1.604.484.2483 Local

    © 2021 - OnRes Systems

    Financial System


    1. Overview

    1.1 What does the Financial System do?

    OnRes Financial System allows you to manage the financial aspects of the reservation system, such as billing, payments, and financial reports. More specifically, it provides the following functionalities.

    • Manage Guest Bills (Folios)
      • Post charges (room charge, add-on, laundry, etc) to a folio manually or automatically (by the automated Night Audit process)
      • Generate seperate bills for Guest, Company and/or Travel Agent ((Accounts Receivable accounts)
      • Generate Invoices/Receipts based on Folios
      • Track the posting recorders in the three ledgers: Guest Ledger, Advanced Deposit Ledger, and the Accounts Receivable (A/R) Ledger.
    • Manage Payments
      • Supports two credit cards on file
      • Support Direct Billing to pre-configured Accounts Receivable (A/R) accounts
      • Integrate with Payment Gateway for automatic payment processing
    • Track financial transactions and produce financial reports
      • Provides Financial Journals
      • Produce payment reports
      • Produce ledger verification reports.

    1.2 Get Started

    To use the Financial System, you can start with the following steps. You can read through the HELP sections below for details.

    1. Configure the Financial System
    2. Enable the automated Night Audit process
    3. Learn how to manage billing (Folios) for the reservations
    4. Learn about various financial reports

    2. Configurations

    2.1 Tax Codes

    Set up the Tax Codes at Financial >> Settings page

    Tax Codes are used to generate tax postings based each time a posting code to which the tax type is attached is used. All taxes will be posted as an additional charge, i.e. appears as a separate entry in the financial jounal and the invoice/receipt.

    OnRes supports up to 4 taxes, each one is associated with a unique Posting Code. For any entry that is not needed, leave the Amount and Posting Code sections empty.

    Note: all codes must be letters, numbers and dash (or underscore) only, max 15 characters, no space is allowed

    2.2 Revenue Types

    Revenue Types are used to group Posting Codes for the Management Report. Typical Revenue Types are: Room, F&B, Laundry, Telephony, PayTV, etc, but you can also create more detailed types as needed, such as,

    Instead of just Room, you can create Corporate Room Revenue, Group Room Revenue, Transient Room Revenue etc.

    Instead of just F&B, you can go with Room Service Breakfast, Room Service Lunch, Room Service Dinner, Room Service Night, BuffetRest Breakfast, BuffetRest Lunch, BuffetRest Dinner, FancyRest Lunch, FancyRest Dinner, MiniBar, Lobby Coffee, Lobby HighTea, Bar Lunch, Bar Dinner, Bar Night, etc.

    With revenue types, we can produce different reports based on these types.

    Note: all codes must be letters, numbers and dash (or underscore) only, max 15 characters, no space is allowed

    To add new code, click on the Add Code button

    To edit an existing code, click on the icon

    To delete a code, click on the icon Note: once a code is being used, charges have been posted with this code, it should never be deleted, otherwise it will lose track with the financial records that are tagged with this code

    2.3 Posting Codes

    Posting Codes are used to post charges on a folio. Different charges need different codes. Here are some example codes that are typically used:

    • Room Charges - typical codes can be "ROOM", or "10001", etc
    • Breakfast - typical codes can be "BFST", or "10002", etc
    • Laundry - typical codes can be "LDRY", or "10003", etc
    • Bar Charges - typical codes can be "BAR", or "10004", etc
    • Paid Out - typical codes can be "PO", or "20001", etc

    Note: all codes must be letters, numbers, dash or underscore only, max 15 characters, no space is allowed

    To add new code, click on the Add Code button

    To edit an existing code, click on the icon

    To delete a code, click on the icon

    Field Descriptions:

    • Posting Code: unique alphanumeric code (with dash or underscore) that identifies a posting charge (max 15 characters)
    • Description: short description (max 30 characters). Description will appear on the invoices/receipts
    • Tax 1-4: check the checkbox if this charge is associated with certain tax
    • Billing Instruction Type: Billing Instructions are a set of "rules" defined to instruct the system to transfer charges from a guest folio to another receiving folio automatically. OnRes supports 5 pre-defined instruction type codes: ROOM, BREAKFASST, LUNCH, DINNER, LAUNDRY. Here you can set different Posting Codes to the Billing Instruction Types that they belong. For example, you may have 3 different Posting Codes for different types of breakfast: breakfast buffet, breakfast through room services and a take-away breakfast, but you can set all 3 codes to the same Billing Instruction Type "BREAKFAST". Details about how Billing Instructions work is described in a later section
    • Posting Factor: Options are: Per Stay, Per Night, Per Adult, Per Child, Per Adult Per Night, and Per Child Per Night. It's used for Posting Codes associated with Add-on Items. When it's set properly, the Night Audit process, which is responsible to post daily charges in the reservation, to calculate the posting amount for the add-on items in the reservation. For example, when a Posting Code "BREAKFAST" is set with the factor "Per Adult Per Night", then the Night Audit process will calculate the amount by multiplying the breakfast price by the # of adults and post it to the guest folio for the day.
    • Revenue Type: associate the posting codes to the Revenue Type configured in the previous section. This allows the posting codes to be grouped by revenue type for the Management Report.
    • Affects Cash: this is specifically for the PaidOut posting code. If you have a posting code for Paid Out, then this should be checked.
    • Do Not Void: Certain postings should not be voidable. A paid-out for instance. When cash was taken out of a till to pay something for a guest, the posting shouldn't be voided, instead, the payment type “Cash” should be used to put money back in the till, because voids are not show on receipts, whereas “Paid out” and “Cash” do.
    • Invisible in Selection: certain Posting Codes, used by the system, should perhaps never be used manually. If this is checked, the code will not appear in the list of codes for manual posting
    • General Leger Acct No.: for backoffice integration
    • Notes: notes for office use. Not appearing in folios

    2.4 Accounts Receivable Accounts

    You can create Accounts Receivable accounts (A/R accounts) to identify companies (and travel agents) that have been deemed credit worthy by the hotel. The Accounts Receivable account ID (A/R Acct #) is attached to the reservation as well as to a company or a travel agent, to allow you to create folios for the A/R accounts, and/or pay a folio with Direct Billing method that is associated with these A/R accounts.

    To add new account, click on the Add Account button

    To edit an existing account, click on the icon

    To delete an account, click on the icon

    2.5 Payment Type Codes

    Payment types are used to process payment. Typical examples can be: Cash, Visa, Master, Amex, Diners, Direct Bill (if you allow credit to any A/R account).

    For cash payment types, check the Affects Cash checkbox

    For direct billing type to A/R accounts, check the Requires AR checkbox

    For credit card payment types, check the Is Credit Card checkbox

    To add new code, click on the Add Code button

    To edit an existing code, click on the icon

    To delete a code, click on the icon

    Note: all codes must be letters, numbers, dash or underscore only, max 15 characters, no space is allowed

    2.6 Associate Posting Codes to Rate Groups

    Important: In order for the Night Audit process to post room charges to the folios, you must associate a Posting Code to every Rate Group. If you have Applicable Fees set up in your account, you must associate a Posting Code to the fees as well.

    You can set this globally (to all Rate Groups at once) when configuring the Posting Codes. Click the "Is this code for a room charge?" or "Is this code for the Applicable Fee?" to expand the question, and check the checkbox as shown below. If the checkbox is checked, the system will apply this code to all existing Rate Groups when saving.

    Note: if you would like to set different codes for different Rate Groups, you can do it at Setup >> Rates. Open the Rate Group details window and set the codes under the Financial Settings tab

    2.7 Associate Posting Codes to Add-on items

    Important: In order for the Night Audit process to post add-on charges to the folios, you must associate a Posting Code to every Add-on item.

    You can do it at Setup >> Add-Ons. Open the Add-On Item details window and set the codes under the Financial Settings tab

    3. Night Audit

    3.1 Enable Auto Nightly Audit

    Night Audit performs the following financial related tasks

    • For each reservation that's checked-in, post room charges for the day
    • For each reservation that's checked-in, post add-on item charges for the day
    • Process Ledger Verification and generate verification report

    It is important that night audit is done every night when there is no more check-in activity for the day. While you can choose to run the audit manually every night, it is recommended to enable the automatic auditing function so the system performs the task for you at the designated time.

    The Night Audit feature can be accessed at Analytics & Reperts >> Night Audit. More details can be found at this HELP page

    4. Manage Reservation Bills (Folios)

    4.1 How to open / create a folio?

    A default Folio is automatically created when a reservation is made. For a multi-room reservation, each room has its own folio.

    Open the Reservation Details window, the folio is under Bill & Patments tab. Click on the Folio # to open the Folio.

    Create additional folios for a Company or Travel Agent
    Sometimes you may want to create another folio for the room, e.g. you can post all room charges to a folio for the company (whose profile is linked in the reservation), and all other charges, such as food & beverage to your own guest folio. You can do that by clicking on the "ADD FOLIO" link button and choose the owner of it.

    The Folio IDs will follow the pattern of [RESERVATION ID]-[ROOM INDEX][A,B,..]. For example, When you have two rooms in the reservation,

    • the Folio ID for the default Folio of the 1st room will be XXXXXXX-01A
    • the Folio ID for the 2nd Folio of the 1st room will be XXXXXXX-01B
    • the Folio ID for the default Folio of the 2nd room will be XXXXXXX-02A.
    • the Folio ID for the 2nd Folio of the 2nd room will be XXXXXXX-02B

    Once the folio is open, you can perform the following tasks:

    • POST - post charges manually
    • PAY - make payment to this particular folio. Note: when you have multiple folios, you can go back to the Reservation Details window and click the Pay All Bills button to pay for all folios under the reservation at once.
    • VOID - void selected entries if needed
    • TRANSFER - transfer selected entries to another folio
    • RECEIPT - open receipt for this particular folio (for printing or email) Note: when you have multiple folios, you can go back to the Reservation Details window and click the All Receipts button to print all receipts for the reservation at once.
    • CHECK OUT - Check out the guest from the room. Note: when you have multiple rooms in one reservation, this button will become SET VACANT which set the Housekeeping Status to VACANT for this room. You can check-out all rooms at the Reservation Details window

    4.2 How to post charges to a folio?

    If the Night Audit is enabled with the Auto mode, the room and add-on charges will be posted to each folio for every checked-in reservation automatically, but if you have any manual charges, e.g. a room serviced meal or landry, you can open the folio and click the POST button to post the charges manually.

    On the Post popup window, click on the Posting Code box and choose a code from the list. You can type part of the code to filter the list. Enter the Amount and Count, the system will calculate the total.

    Note: since this is a manual post, the Posting Factors are not counted into the calculation. For example, if you are posting a BREAKFAST with a Posting Factor of "Per adult per night", the posting factor is counted into the calculation, so you must enter the actual # of breakfast purchased in the Count field.

    Reference - you can enter something like an external invoice number or transaction number here. It will appear in the invoice/receipt.

    Notes - you can enter some notes related to this posting for internal use. It will not appear in the invoice/receipt.

    4.3 How to make payment?

    Pay a single folio

    Open the folio and click the PAY button to make payment to the folio you just opened.

    Pay all folios within the same reservation

    At the Reservation Details window, click the Pay All Bills button to make payment to all folios in this reservation.

    Pay all folios within the Master Reservation

    At the Master Reservation window, click the Pay All Bills button to make payment to all folios in this master reservation.

    On the Pay popup window, choose the Payment Type from the dropdown list.

    When a credit card type is selected, the guest's credit card number will appear below for confirmation. If there are 2 cards saved in the reservation, they will listed as options for you to choose which card this payment will go to.

    When this reservation is associated with a Company Profile or a Travel Agent profile that has an Accounts Receivable (A/R) account associated, the Direct Billing option will be provided in the Payment Types list.

    If you account is linked to a Payment Gateway interface, when the Pay button is clicked, the system will connect to the Payment Gateway and charge the card in real time.

    Reference - you can enter something like an external invoice number or transaction number here. When a Payment Gateway is connected, the transaction number will be recorded in this field.

    Notes - you can enter some notes related to this payment for internal use. It will not appear in the invoice/receipt.

    4.4 How to void a posting?

    First, select the entry that you would like to void. If there are tax entries associated with it, they will be automatically selected too.

    Then click on the VOID button to open the popup

    Then enter the Void Reason (mandatory) and click the Void button to proceed.

    Voided entries will not show in Folio by default, but you can check the "Show All" checkbox to view them.

    Note: If an entry is associated with a Posting Code that has the "DoNotVoid" flag set, the void isn't allowed.

    4.5 How to transfer a posting to another folio?

    A posting can be transfered from a folio to another by the following means

    • Manual transfer - described in this section
    • Automatic transfer (by setting up the Billing Instructions) - described in the next section

    Manual transfer

    First, select the entry that you would like to transfer. If there are tax entries associated with it, they will be automatically selected too.

    Then click on the TRANSFER button to open the popup

    Step 1 - choose the receiving folio for the transfer. By default, the other folios within the same reservation will be listed as the receiving folios. If you'd like to transfer to another folio that's not in the list, you can enter the Guest Name, Room # or Reservation ID to search.

    Step 2 - enter notes if needed (optional)

    Step 3 - click the Transfer button to proceed.

    Transfered entries will not show in the original Folio by default, but you can check the "Show All" checkbox to view them.

    4.6 How to setup Billing Instructions for automatic transfers?

    Sometimes you may want to have two separate bills for a reservation, for example, a bill for the guest and a bill for the company or a travel agent. And you may want all room charges go to the company bill and all other charges to the guest's own bill.

    In these scenarios, Billing Instructions may come handy to allow charges to be transfered to your desired folios automatically. They are basically a set of "rules" defined on a source folio (e.g. the folio for the guest) to instruct the system to transfer charges from the source to another receiving folio (e.g. the folio for the company) automatically at the time when you make a payment (i.e. when you press the Pay Bills button).

    To create or modify the Billing Instructions:

    1. Click on the B.I. button next to the Source Folio to open the popup.
    2. On the Setting up Billing Instructions popup,
      1. Choose what type of charges you need to transfer to the receiving folio. Once chosen, the Posting Codes that are associated with these types (described in Section 2.3 Posting Codes) will be transfered when the Billing Instructions are processed.
      2. Choose the receiving folio that the charges will go do. The other folios within the same reservation will be listed by default. If you want to transfer to a folio that is not in the list, you can use the Search button to search for any other folios that are currently IN-HOUSE.
      3. Press the Save button to save the changes

    To delete an existing Billing Instruction:

    1. Click on the B.I. button next to the Source Folio to open the popup.
    2. Press the Delete button to delete the current Billing Instruction

    To process the Billing Instructions:

    When the Billing Instructions are processed, the system will select the postings from the source folio based on the instructions and automatically transfer them to the receiving folio.

    If Billing Instructions are setup on any folio, when you pay all bills at the Reservation Details window, or open a single folio and pay in the Guest Billing window, the Billing Instructions will be automatically processed before you can open the Payment popup.

    Depending on whether there are any pending transactions in the Source folio that haven't been transfered to the receiving folio, the system will display messages like

    • "Billing Instruction processed and balance updated", or
    • "Billing Instruction processed - no pending transactions to process"

    Then you can click "Continue to pay the bills" to continue with the payment, or close the popup window and open the source (or receiving) folio to review transfered postings and balances if needed.

    4.7 Receipts

    Postings for each folio will be listed in the respective receipt. Each folio will produce its own receipt with its own transactions.

    You can generate receipts for each individual folio by openning each individual folio, and then clicking on the Receipt button at the Guest Billing window

    Or you can generate receipts at the reservation level when there are multiple folios in the reservation. Go to Reservation Details window, click on the All Receipts button.

    If it's a Master reservation, you can also generate receipts at the Master reservation level. Go to Master Reservation Details window, click on the All Receipts button.

    When there are multiple folios in the receipt, the folios are listed in multiple pages. You may see a line marked as "(page break)" between the folios. This will not show in the actual receipts (in PDF). Instead, when you click on the Print button, they will appear as actual page breaks in the PDF document.

    4.8 Check-out

    When all folios for a reservation have a balance of zero, the CHECK OUT button is activated.

    You can check-out the reservation at the Reservation Details window, the Master Reservation Details window, or the Guest Billing window (when there is only one folio in this reservation)

    When there are multiple rooms in the reservation, you cannot check-out the entire reservation (all rooms) at the Guest Billing level, but you can instead set the room to VACANT for a particular room by clicking on the SET VACANT button. This will sets the Housekeeping status to VACANT for this room, and housekeepers will be able to see the status in the Housekeeping module.

    To check-out the reservation (or a master reservation), you can click on the CHECK OUT button at the Reservation Details window (or the Master Reservation window).

    4.9 How to bill a reservation to an Accounts Receivable (A/R) account

    Assume the A/R account is associted to a company (for Travel Agents, they are similar - details in the later paragraphs). You will need to do the following steps

    1. Create an A/R account in Financial Settings (see Section 2.4 Accounts Receivable Accounts above)
    2. Create a Payment Type "Direct Billing" (or any name of your choice) with "Check AR" flag set (see Section 2.5 Payment Type Codes above)
    3. Create a company profile and link the reservation to it
    4. Link the company profile to the A/R account
    5. Create a separate folio for the company
    6. Choose Payment Type "Direct Billing" when making the payment.

    Create a company profile and link the reservation to it

    Open the Reservation Details window, click on the button in the Company Name field to choose one from a list of existing company profiles. You can also click on the "Create a new profile" button to create a new profile

    You can also create a company profile at the Contact Manager

    Link the company profile to the A/R account

    Open the profile details of the company profile in the Contact Manager, set the Accounts Receivable field. You must already have the A/R accounts configured in the Financial Settings section.

    After link the company profile to the A/R account, you will be able to see the A/R Acct # in the Reservation Details window:

    Create a separate folio for the company

    Details can be found in Section 4.1 above

    Choose Payment Type "Direct Billing" when making the payment

    Assuming you have a Payment Type "DB" (Direct Billing) configured in the system, when an A/R account is associated to the reservation, you will be able to choose it when you make a payment. Then the system will post the payment to the A/R Ledger instead of the Guest Ledger.

    To bill a reservation to a Travel Agent profile

    Follow similar steps above. You can link a Travel Agent profile to a reservation by entering the TA informaiton under the OTA/GDS & TA tab

    When you enter the TA name in the Travel Agent Name box, a list of existing TA profiles will show in the dropdown list. Select one from the list, or enter the new information for a TA profile.

    Note: the TA profile is identified by its IATA number, which is a mandatory field

    5. Financial Reports

    5.1 Reports produced by Night Audit

    The Night Audit process produces Ledger Verification report every night, with the daily total posting amount for the following three ledgers against the respective ledger amount.

    • Guest Ledger (Guest Lgr)
    • Advanced Deposit Ledger (Adv Lgr)
    • A/R Ledger (A/R Lgr)

    5.2 Other Financial Report

    You can find other financial related reports in the Financial >> Reports section. Currently there are

    • Journal - All financial postings of given date range
    • Payments - All payment records of given date range
    • Ledger Verification - Summary for Postings and Ledger tables for verification

    To run the report, click on the RUN REPORT button and enter the desired date period, output format, and press Download Report button or Email Report button to produce the report.

    You can also generate the report of entries done by a particular user by selecting the User ID (or Name) from the By User dropdown list.