Cash Application
Overview
The Cash Application report provides a detailed analysis of cash application across various accounts and billing elements. This report tracks how each cash receipt is allocated, including the billing accounts, specific bills, bill lines, or general suspense accounts where the funds have been applied.
Report
| Column | Description |
|---|---|
| Division | Division or business unit associated with the record. |
| Source Customer ID | Unique identifier assigned to the customer in the source system. |
| Customer Name | Name of the customer. |
| Account ID | System-generated identifier that uniquely represents an account. |
| Bill Group ID | Unique identifier assigned to a group of bills that are billed and paid together. |
| Bank | Bank code indicating the financial institution from which the payment information was received. |
| Bank Account Key | Unique, country-dependent bank key that identifies the customer's bank account. |
| Contract Type | Specifies the type of service agreement linked to the customer account. |
| Source Policy ID | Identifier of the policy associated with the customer’s contract. |
| Source Plan ID | Identifier of the plan linked to the customer’s policy. |
| Tender Type | Code that specifies the payment method, such as cash, check, or direct debit. |
| Tender Source | Code that indicates the source of the funds for the payment. |
| Source System | Indicates the originating system from which the data was sourced. |
| Payment Tender ID | Unique identifier of the payment tender record. |
| Tender Control ID | Identifier of the remittance processor batch or cash drawer bundle in which the tender was included. |
| Payment Event ID | System-assigned unique identifier of the payment event containing related payments and tenders. |
| Payment ID | System-generated unique identifier of the payment record. |
| Deposit Control ID | System-assigned identifier of the related deposit control created during payment processing. |
| Payment Segment ID | Identifier representing individual segments of a payment divided into portions. |
| Check Number | Check number associated with the payment. |
| External Reference ID | External reference linked to the payment tender for tracking or reconciliation. |
| MICR ID | MICR (Magnetic Ink Character Recognition) identifier associated with the payment tender. |
| Deposit Control Date | Date when the deposit control was created |
| Tender Control Date | Date when the tender control record was created. |
| Payment Date | Business date associated with the payment event. |
| Payment Applied Date | Date when the payment was applied to a bill or outstanding account balance. |
| Adjustment ID | System-generated unique identifier of the adjustment record. |
| Adjustment Type | Specifies how the adjustment affects the payoff and current balances.< |
| Match Type | Code indicating how the payment amount should be distributed or matched to bills. |
| Bill ID | Identifier of the bill associated with the payment transaction. |
| Bill Segment ID | System-generated unique identifier of the bill segment within a bill. |
| Coverage Start Date | Start date of the billing coverage period. |
| Coverage End Date | End date of the billing coverage period. |
| Tender Amount | Total amount tendered. |
| Applied Amount | Portion of the payment amount that has been applied to a bill or outstanding balance. |
| Payment Amount | Amount credited to the customer’s account to settle outstanding debt. |
| Currency | Currency used for the transaction. |
Filters
You can filter the report using the following parameters:
- Division
- Customer Name
- Payment Date