previous

Financial Payment and Revenue (findeptcodes with CAS3.FMX)

The Financial Payment and Revenue Report shows a sum of all transactions posted for the date specified. The transactions are grouped first by Transaction Group, then Transaction Subgroup, and then by Transaction Code with a subtotal for each Group and Subgroup.

Note: Transaction codes that were made Inactive without any postings ever being made against them do not show in this report.

The balance of the findeptcodes report equals that of the finjrnlbytrans, finjrnlbytrans2, and finjrnl_blk reports for the corresponding date. Ensure when comparing that you are balancing the figures for Gross amounts, as this is the only way to balance all these reports. The transaction total balances to the trial_balance line Transaction Total Today.

Note: Internal transaction codes and the transaction code set as the AR > Credit Card Trn Code application setting do not show in the results of the report.

Selection Criteria

Transaction Codes

This area is only appears when the OPP_GCA PTS Gaming and Comp Accounting add-on license code is active.

Standard. The report output only includes the regular Transaction Codes configured for your property. Transaction Codes are configured in Configuration > Cashiering > Codes > Transaction Codes.

Comp. The report output only includes Comp Transaction Codes that have been configured for your property. Comp Transaction Codes are configured in Configuration > Comp Accounting > Comp Transaction Codes. When selecting to print Comp Transaction Codes only, the Payments option button in the Types section is not available for selection because Comp Transaction Codes cannot be configured as Payments.

All. The report output includes both Regular Transaction Codes AND Comp Transaction Codes.

Types

Payment. Shows only those transactions that have been marked as payments. This is configured in Configuration > Cashiering > Codes > Transaction Groups > Payment and the Payment option button is marked. When selected to print by payments, the additional filters in the Display group are not available.

Revenue. Shows only those transactions that have been marked as revenue. This is configured in Configuration > Cashiering > Codes > Transaction Groups, the Revenue option button is marked, and the Revenue Group check box is selected.

Non Revenue. Shows only those transactions that have been marked as non-revenue. This is configured in Configuration > Cashiering > Codes > Transaction Codes. The Revenue Group check box is not selected. When selected to print by payments, the additional filters in the Display group are not available.

All. Shows all transaction codes that have been posted for the date specified. You have the additional option of showing the transaction code amounts for Revenues as Net or Gross.

Date Range

Calendar or Fiscal (available when the Cashiering > Period Definition application function is set to Y). Select the option button that corresponds to the type of report period you want to apply to this report. You can choose a Calendar period (month, week, or month to date) or a Fiscal period (which you have defined for your property's use). Fiscal periods are configured using Configuration > Cashiering > Period Definition > Period.  Whether you select a Calendar or Fiscal period type determines your other Report Period options and Date options.

Filter

Transaction Code. Select the down arrow to choose specific transaction codes to filter the report results by. Transaction codes available for selection are based on which Transaction Code Type is selected in the Transaction Codes section of the report form.

Room Class. Available when the General > Room Class application function is set to Y, the Revenue and Net option buttons and Tax Columns check box are selected, select the down arrow to choose a specific room types to filter the report results by. When the selected criteria have been chosen and a room class is selected, the time to run the report could take a long time as the data is being pulled from a much larger source and could be pulling data from up to the past 2 years.

Display

Net. If Revenue display is selected, you can additionally choose to show the amount for each transaction code without any inclusive charges. Additional options for Style, of Horizontal and Vertical, are also then available to select on the Form.

Gross. If Revenue display is selected, you can additionally filter to show the amount for each transaction code inclusive of additional charges.

All. If Revenue display is selected, you can additionally filter to show the amount for each transaction in both Gross AND Net figures.

Include

Last Year. When checked, the report output prints a comparison of the same date format, for the previous year.

Include Budgets. This option is only available for selection when Cashiering > Budgets application function is active. When checked, the report output includes the Budget configured for each Transaction Code for the current year. Budgets for the previous year do not show, even when the Last Year check box is selected.

Tax Columns. This is only available for selection if the Transaction Type of Revenue is selected to show on the report AND if the Display option is NET. When selected, additional columns of associated Taxes appear on the report output. Selecting to include the Tax Columns in the report output will take longer to run the report due to the large amount of detailed information that needs to be considered.

Currency. Displays the default currency configured for the property. Select the down arrow to specify another currency for the report. If the report is run for a currency other than the base currency, the specified currency appears as a column header for those formats that accommodate the space required. In the report column header image below, USD is the base currency for the property, but the Japanese Yen was selected for the report:

findeptcodes_alternate_currency_header

The exchange rate for the report is as follows:

Group By. Transaction Group, Transaction Sub Group or Blank (No Group By). When the Group By selection is blank, the report output shows just the Transaction Codes in numeric sequence order. The report should be run without Group By when saving the file as a delimited data file.

Sort Order. Alphabetical, Sequence. This option is only available if the selection of ‘Group By’ is not left Blank. In Transaction Group and Transaction Sub Group configuration, the property may assign a Sequence number to each Transaction Group and Transaction Sub Group. The report output then appears in the assigned Sequence number. If a sequence number is not defined for some Groups/Sub Groups, the report output first sorts by Sequence number and then Alphabetical.

Report Output