Generating the Property Ledger Posting Journal report

Use this screen to generate a report that includes all the transaction codes posted on the specified date range. The report includes transaction related to folio posting, advance deposit posting or a manually posted Charge or Payment to an A/R account.

This report is used by the front desk staff, the A/R clerk and the accounting manager.

To generate the Property Ledger Posting Journal Report:

  1. Select Administration > Reports > Accounting > Property Ledger Posting Journal.
  2. Specify this information in the Report Parameters section:
    Property
    The property code for which the report is generated. This value is defaulted.
    Note: 

    You can modify the value.

    Transaction Code
    The transaction code and description based on which the report is generated.
    Note: 

    You can select multiple transaction codes.

    Transaction Type
    The type of the transaction such as food and beverage revenue, room revenue and tax.
    Posted By
    The user who posts the transaction.
    Note: 

    You can select multiple users.

    Group By
    The category based on which the information in the report is grouped.
    Note: 

    The default value is Transaction Code (TC). However, you can modify the value.

    Account
    The account for which the transaction is posted.
    Note: 

    You can select multiple accounts.

    Exclude Posted By
    The user name or ID. The transaction posted by the user are not included in the report.
    Note: 

    You can select multiple users.

    Building
    The building code based on which the transactions were posted are included in the report.
    Note: 

    You can select multiple building codes.

  3. Set these parameters in the Report Options section:
    Adjustments
    If this check box is selected, the report includes the adjustment postings.
    Note: 

    By default, this check box is selected. However, you can modify the value.

    Include Advance Deposits
    If this check box is selected, transactions that posted to the advance deposit ledger are included in the report.
    Note: 
    • By default, this check box is selected. However, you can modify the value.
    • If this check box is not selected, the report only includes the transactions that are posted to the folio.
    Include Lease Security Deposits
    If this check box is selected, the report includes the transactions related to the lease security deposits.
    Include Lease Incidental Deposits
    If this check box is selected, the report includes the transactions related to the lease incidental deposits.
    Include Lease Rental Deposits
    If this check box is selected, the report includes the transactions related to the lease rental deposits.
    Show Credit Card Details
    If this check box is selected, the report includes the credit card name and details used for the payment transactions.
    Show Comments
    If this check box is selected, the report includes the comments related to the transaction posting.
    Discount Postings Only
    If this check box is selected, only the transactions that are associated with the discount are included in the report.
    Note: 

    If this check box is selected, the system does not consider these parameter settings:

    • Include Advance Deposits
    • Include Credit Card Details
    Show Net Amount
    If this check box is selected, the report includes the net amount of transaction.
    Show Tax Amount
    If this check box is selected, the tax amount is included in the report.
    Include Guest Ledger
    If this check box is selected, the report includes the transactions that are posted to the general ledger.
    Note: 

    By default, this check box is selected. However, you can modify the value.

    Include Adjustment Reason
    Select this check box to include the adjustment reason for the folio postings with negative amount, in the report.
    Include Direct Bill Transfers
    If this check box is selected, the report includes the transactions that are associated with the Direct Bill Transfer.
    Note: 

    By default, this check box is selected. However, you can modify the value.

    Show Tax as a separate section
    If this check box is selected, the report displays all the tax transactions in a separate section.
    Show Void Section
    If this check box is selected, the report includes an additional section for the adjustment transactions. The report main section does not display any transaction other than adjustments in the void section. The total remains zero.
    Note: 

    If the transaction is reversed, both the voided and the void transaction are included in this section of the report.

    Show Transfer Section
    If this check box is selected, the report includes an additional section for the transfer transactions.
    Group By Building
    If this check box is selected, the information in the report is grouped based on the building code.
  4. Specify the Start Date and the End Date in the Data Range section.
    Note: 

    By Default, the Start Date and the End Date are set to the Hotel Date.

  5. Click Print Record.
    Note: 

    By default, the report is sorted by Time. You can also sort the report by Posted By, Guest Name, Status, Transaction Code, Transaction Type, Room and Account.