Balance and Status Reports
Qolo's balance and status reports help clients monitor account balances, track card statuses, identify dormant accounts, and flag negative balances. These reports provide key financial insights, ensuring effective account management and proactive resolution of balance issues.
Overview
Balance and status reports provide insights into account balances, card statuses, dormant accounts, and negative balances within a Qolo program. These reports help clients track financial standing across accounts, monitor card activity, and identify accounts that require attention due to inactivity or negative balances.
The following reports fall under this category:
- Balance Summary – Provides an overview of total balances across all accounts in a program.
- Status Summary – Summarizes the status of cards at the time the report is generated.
- Dormancy Report – Identifies dormant accounts with no recent financial activity.
- Negative Balance Report – Lists accounts or cards that have a negative balance.
Balance Summary
Report Overview
The Balance Summary report provides a snapshot of the total balance across all accounts under a program. It is a daily report that captures the end-of-day (EOD) balances, including both ledger and available balances.
Report Data Elements
- Date – The date for which the report is generated.
- Client Name – The client associated with the program.
- Program GUID – A unique identifier assigned to the program.
- Program Name – The name of the program under which the accounts are managed.
- EOD Total Account Balance – The total balance for all accounts under the program at the end of the day.
- EOD Total Available Balance – The total open-to-buy balance across all accounts under the program.
- Account Type – Specifies whether the account is a program-level or cardholder-level account.
- Account Currency – The designated currency of the account.
- Account Status – Indicates whether the account is active, inactive, or closed.
- Account Count – The total number of accounts within the program that match the given status.
- Masked Program Parent Account – The last four digits of the program’s parent account, when applicable.
Status Summary
Report Overview
The Status Summary report provides a breakdown of all card statuses within a program at the time the report is generated. This report is useful for tracking active, blocked, or closed cards.
Report Range
This report captures data for a single day and only reflects the status of cards at the moment the report is pulled.
Report Data Elements
- Client Name – The client associated with the program.
- Program GUID – A unique identifier assigned to the program.
- Program Name – The name of the program under which the cards are issued.
- Card Status – Indicates whether a card is active, blocked, closed, or otherwise categorized.
- Total Number of Cards – The number of cards within the program that match the corresponding status.
Dormancy Report
Report Overview
The Dormancy Report identifies accounts that have been classified as dormant due to inactivity. An account is considered dormant if it has not had any financial activity, except for possible fees, for a predefined period.
Report Range
This report only provides current dormancy information as of the date the report is generated.
Report Data Elements
- Inactivity Type – Categorizes accounts based on their dormancy period (e.g., 30-day, 60-day, or 90-day inactivity).
- Number of Accounts (With Balance) – The count of dormant accounts that still have a positive balance.
- Total Balance Outstanding – The total balance across all dormant accounts for the given dormancy type.
Negative Balance Report
Report Overview
The Negative Balance Report lists accounts or cards that have a negative balance. This report helps clients identify overdrawn accounts and take corrective action.
Report Range
This report only provides current negative balance information as of the time the report is generated.
Report Data Elements
- Company Short Name – The short name of the company, as saved in the Qolo platform.
- Program GUID – A unique identifier assigned to the program.
- Program Name – The name of the program under which the accounts are managed.
- Post Date/Time – The date and time when the transaction caused the negative balance.
- Account GUID – A unique identifier for the affected account.
- Account Type – Specifies whether the account is a program-level or cardholder-level account.
- Person Name – The name of the cardholder or account owner.
- Client Reference ID – A unique reference ID provided by the client.
- Balance – The current negative ledger balance of the account.
- Available Balance – The current negative available balance of the account.
- Person Status – The status of the cardholder or accountholder on the Qolo platform.
- Account Status – The current status of the account (e.g., active, blocked).
- Negative Since Date – The date when the account first went negative.
- Negative Since Days – The total number of days the account has been in a negative balance state.
- Card Reference Data – Information about the card(s) linked to the account, displayed in key-value pairs. Example:
cproxy6521454336353:ACTIVEcproxy0000444937928:STOLEN
- Masked Account Instrument – The last four digits of the pseudo account number, mapping to the account instrument on the Qolo platform.
- Masked Program Parent Account – The last four digits of the parent account associated with the program.
- Master Proxy – The proxy identifier of the first card issued on the account.
- Master PAN (Masked) – The last four digits of the first card issued on the account.
- Top Program Name – The top-level program name within the Qolo platform.
Related Topics
Updated 19 days ago