Dynamic Reports

Sales Summary Report

This is a daily report that allows the user to view number of accounts, net sales, net cash advances, net payments, net returns, and outstanding balances by date.

Platform: Credit on Credit

Frequency: Daily Report

 

How to Access:

  1. Select Search All Your Dynamic Reports.
  2. In the Filter by Report Category field, type "Management Reporting".
  3. Select Sales Summary Report.
  4. Select Run Report.
  5. Select required fields:
  • Reporting Month
  • Card Type
  1. Select View Report.

 

 

 

Field Descriptions:

Date: Day of the month

Note: Saturday is not a Fiserv processing day.

 

Gross Active: Count of customer accounts that had a balance, a monetary posting, or an authorization for the report date.

Daily Net Sales: Count and net amount of sale transactions posted to customer accounts.

Counts and amounts in this field are calculated as follows:

Sales

+ Sales Clearing Adjustments

+ Sales Adjustments

+ Charge Off Sales

+ Small Balance Charge Offs

+ Tax Exemptions

+ Sales Convenience Checks

+ Sales Balance Transfers

+ Finance Charge Debit ADJ-Clearing

+ Finance Charge Debit ADJ-Nonclearing

MTD Net Sales: Month-to-date count and net amount of sale transactions posted to customer accounts.

AVG Daily Sales: Overall average of daily sales for report date.

AVG Daily Sales/Acct: Average of daily sales per account for the report date.

NET Cash Advances: Count and net amount of cash advance transactions posted to customer accounts.

This field is calculated as follows:

Cash Advance Regular

+ Cash Advance (ATM)

+ Cash Advance Convenience Checks

+ Cash Advance Balance Transfer

+ Cash Advance Clearing Adjustment

+ Cash Advance Adjustment

+ Charge Off Cash Advance

+ Small Balance Charge Offs

MTD Net Cash Advances: Month-to-date count and net amount of cash advance transactions posted to customer accounts.

Net Payments: Count and net amount of payment transactions posted to customer accounts.

This field is calculated as follows:

Payments

+  Payments Clearing Adjustments

+ Payments Adjustments

+ Auto Payments

MTD Net Payments: Month-to-date count and net amount of payment transactions posted to customer accounts.

Daily Net Returns: Count and net amount of return transactions posted to customer accounts.

This field is calculated as follows:

Returns

+ Returns Clearing Adjustments

+ Returns Adjustments

MTD Net Returns: Month-to-date count and net amount of return transactions posted to customer accounts.

Closing Balance: Count and amount of outstanding customer account balances at the end of the processing day.

The count of accounts included in this field are calculated as follows:

Opening

+ New Accounts

+ Type N Account Transfers In

- Deleted (month end only)

- Charged Off

+ Z Status Removed

Balance/Acct: Average balance per account.

Field is calculated as follows:

Closing Balance ÷ Closing Balance Accounts



Downloadable Version

Click below to access the printer-friendly version.

PDF (Entire Guide) PDF (This Section)