The GL/User Data Code Profitability Listing report allows you to view the GL or User Data Code profitability totals in one comprehensive report, listing all GL or User Data Code values and their corresponding totals. The report can be generated for a single bank or across multiple banks. The report can be further filtered by selecting Income totals only, Expense totals only, or both.
The report lists totals by GL Codes or User Data Codes, depending on which is selected. The report is divided into two sections, depending on the selection of Income, Expense, or both from the filter criteria page. If both are selected, the first section of the report provides GL Codes or User Data Codes and their corresponding income totals. The second section will provide GL Codes or User Data Codes with expense totals. Both sections have the same format, and have monetary columns summarized by each unique GL Code or User Data Code.
The GL/User Data Code Profitability Listing report includes the following data:
Bank #
The number that identifies the bank.
Fee Category
The selected fee category, or the one that corresponds to the GL Item Code or User Data Code.
GL Item Code
The General Ledger code defined by the Bank within Portfolio Pricing Manager.
User Data Code
- The client-defined search criteria.
- Five client-defined data fields.
Count
The number of items for this activity associated with this Fee Item Name, or the number of occurrences of the GL Item Code or User Data Code.
Amount
Depending on the report displayed, this can indicate one of the following:
- The transaction amount.
- The total dollar amount of the merchant remittance.
- The dollar amount for the transactions that were accessed for the Fee Item Name.
- The dollar amount for the transactions for the GL Item Code or User Data Code.
Income/Expense
The dollar amount of income or expense for the Fee Item Name, GL Item Code, or User Data Code.
Fees
The interchange, card brand, or debit network fees associated with the Fee Item Name, GL Item Code, or User Data Code.
Fees Paid
The fees paid associated with the Fee Item Name, GL Item Code, or User Data Code.
This field will be blank for the expense segment of the report.
