Transaction Totals

This report lists all the transactions posted on the specified date range by transaction code or transaction type. The report includes the transaction type, transaction code, transaction code description, GL account, quantity, and total amount posted for the transaction code. The report will print a section for each ledger selected, then gives a total amount for each ledger and a total amount for all ledgers combined. You can optionally include a separate Tax section will not include the offsets by design

You can filter the report by transaction type, transaction code, created by, and account. You can group the report by account, created by, revenue type or transaction type. You can select to include a cover page that includes the parameters used to run the report. You can optionally include the general ledger, accounts receivable ledger, advance deposits, and security deposits. You can optionally include discount postings. You can select to show net amounts, tax amounts, tax as a separate section, show quantity, show count, and quantity as units sold. You can sort the report by GL account, transaction code, or transaction type.

The following are some important points to be noted:

  • Include Discount Postings: If this check box is selected, the report includes total posting amount for individual transaction codes for which the Apply Adjustment as a Discount check box is selected. By default, this check box is not selected.
  • Include Lease Rental Deposits: If this check box is selected, a rental deposit ledger section and its transactions are included in the report by the system. See lease deposit.
  • Include Lease Security Deposits: If this check box is selected, a security deposit ledger section and its transactions are included in the report by the system.
  • Include Lease Incidental Deposits: If this check box is selected, a incidental deposit ledger section and its transactions are included in the report by the system.
  • Include A/R Ledger: If this check box is selected, the application displays:
    • The charges posted directly to an A/R Account(direct postings)
    • The charges that are transferred or billed directly, from an account to the Guest Ledger(direct bill charges).
      Note: The application displays the transaction totals for direct bill charges, only if an A/R charge is linked to a transaction code.
  • Include Direct Bill Transfer: If this check box is selected, the report displays the details of the Guest Ledger Posting Details, AR Postings that includes the Direct Bill Transfers.
  • When a Group By option is selected, the report will group transaction codes by the selected option and give totals for the respective group by option.
  • If a transaction code has an inclusive tax, but does not have an offset configured, the system uses the posting transaction codes as the offset. As a result, the amount total for the transaction code displays the net amount and there is no easy way to see the gross amount. The option Show Tax as Separate Section check-box must be selected as it separates out the inclusive tax offsets.
  • The separate tax section will break out additional taxes, inclusive taxes, and inclusive tax offsets into their own respective sections separate from other charges.