++ ++++

Switch to dark theme

Switch to light theme

Standard reports

Report: Load report

Report description: Load report is a summary report of all account credits (and credit reversals, if any) done for all account holders associated with a Fintech for the period of time.

Column NameDescription (format / sample value)
DateTimestamp of PPI account credit (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Product typeClassification of account product that is being credited/ debited (MCC_VOUCHER_RECIPIENT)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channel (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
RemarksRemarks passed during initiating the request (eg. wallet load from pg)
Account holder attributesCustom account holder attribute passed at the time of account holder creation

Report: User spend report

Report description: User spend report is a summary report of all spends (and corresponding reversals, if any) done by the account holders associated with a fintech for a period - across all channels. Types of txns included: card txns, Onus txns, A2A, UPI, IMPS/NEFT OUT.

Column NameDescription (format / sample value)
DateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Product typeClassification of account product that is being credited/ debited (MCC_VOUCHER_RECIPIENT)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
RemarksRemarks passed during initiating the request (eg. wallet load from pg)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
Reversal transaction IDID of reversal transaction for reference purpose. This is populated only if the original transaction is reversed.
MCCMerchant Category Code for the merchant where the transaction is done (e.g. 4211)
Supercard MIDMerchant ID (e.g. 81800518)
Supercard RRNRetrieval reference number for the payment as shared by the network (e.g. 15719447806)
Supercard TIDTerminal ID (e.g. 81800519)
Merchant CityMerchant City (e.g. Bangalore)
Merchant NameMerchant Name (e.g. UtilitiesCC)
Account holder attributesCustom account holder attribute passed at the time of account holder creation
Auth typeAuthentication mechanism used for the txn (e.g. Super PIN, OTP etc.)

Report: User balance report

Report description: User balance report is a summary of end of period balances for all accounts under a fintech.

  • This report will have EOD balance for all ledgers in Fusion system for a fintech. This report can then be pivoted at an AH ID level to get AH balance.
Column NameDescription (format / sample value)
DateBalance as of this date (IST) (YYYY-MM-DD HH:MM:SS+05:30)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Product typeClassification of account product for which balance is being reported (GPR_min_KYC)
KYC statusKYC status of the Account Holder (e.g. Aadhaar OTP)
Balance (INR)Account balance (e.g. 10.00)
Account holder attributesCustom account holder attribute passed at the time of account holder creation

Report: All card spends report

Report description: All card spends report is a summary report of all card spends (and corresponding reversals, if any) done by the account holders under a fintech in a period.

Column NameDescription (format / sample value)
DateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
RemarksRemarks passed during initiating the request (eg. wallet load from pg)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
Auth typeAuthentication mechanism used for the txn (e.g. Super PIN, OTP etc.)
Payment receipt IDUnique Identifier for every payment affected on the account (excludes A2A transfers) (e.g. 152295000000)
Supercard card 6x4First 6 and last 4 digits of the card used to initiate the transaction (e.g 608281-xxxxxx-4457)
Supercard RRNRetrieval reference number for the payment as shared by the network (e.g. 15719447806)
MCCMerchant Category Code for the merchant where the transaction is done (e.g. 4211)
Supercard merchant nameMerchant Name (e.g. UtilitiesCC)
Supercard MIDMerchant ID (e.g. 81800518)
Supercard TIDTerminal ID (e.g. 81800519)
Account holder attributesCustom account holder attribute passed at the time of account holder creation

Report: OnUs merchant spend report

Report description: ONUS merchant spend report is a** **summary report of all onus merchant spends (and corresponding reversals, if any) done by the account holders under a fintech in a period.

Column NameDescription (format / sample value)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
AmountTransaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
Zeta business IDUnique ID for the Merchant in Fusion System (e.g. 298466)
Zeta store nameMerchant Name (e.g. Cashfree)
Record typeType of transaction (CREDIT / DEBIT)
Reversed txn IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Product typeClassification of account product that is being credited/ debited (MCC_VOUCHER_RECIPIENT)

Report: Unsettled card transactions

Report description: Unsettled card transactions is summary of all card transactions pending settlement with the network.

Column NameDescription (format / sample value)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Product typeClassification of account product for which balance is being reported (GPR_min_KYC)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
RemarksRemarks passed during initiating the request (eg. wallet load from pg)
Auth typeAuthentication mechanism used for the txn (e.g. Super PIN, OTP etc.)
Payment receipt IDUnique Identifier for every payment affected on the account (excludes A2A transfers) (e.g. 152295000000)
Supercard card 6x4First 6 and last 4 digits of the card used to initiate the transaction (e.g 608281-xxxxxx-4457)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
Supercard RRNRetrieval reference number for the payment as shared by the network (e.g. 15719447806)
Supercard Transaction TypeUnique Identifier for transaction type (e.g. eCom, POS etc.)
MCCMerchant Category Code for the merchant where the transaction is done (e.g. 4211)
Merchant NameMerchant Name (e.g. UtilitiesCC)
Merchant IDMerchant ID (e.g. 81800518)
Supercard TIDTerminal ID (e.g. 81800519)
IFI IDIssuer (RBL/IDFC etc.) identifier as per Fusion system (e.g. 156699)
Account holder attributesCustom account holder attribute passed at the time of account holder creation

Report: Settled card transactions

Report description: Settled card transactions is summary of all card transactions settled with the network.

Column NameDescription (format / sample value)
Settlement DateDate of settlement
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Product typeClassification of account product for which balance is being reported (GPR_min_KYC)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
RemarksRemarks passed during initiating the request (e.g. Physical Super Card ECOM Purchase)
Auth typeAuthentication mechanism used for the txn (e.g. Super PIN, OTP etc.)
Payment receipt IDUnique Identifier for every payment affected on the account (excludes A2A transfers) (e.g. 152295000000)
Supercard card 6x4First 6 and last 4 digits of the card used to initiate the transaction (e.g 608281-xxxxxx-4457)
Supercard RRNRetrieval reference number for the payment as shared by the network (e.g. 15719447806)
ARNAcquirer Reference Number
Refund ARNAcquirer Reference Number for refund transaction
Supercard Transaction TypeUnique Identifier for transaction type (e.g. eCom, POS etc.)
Merchant NameMerchant Name (e.g. UtilitiesCC)
Merchant IDMerchant ID (e.g. 81800518)
MCCMerchant Category Code for the merchant where the transaction is done (e.g. 4211)
Supercard TIDTerminal ID (e.g. 81800519)
Account holder attributesCustom account holder attribute passed at the time of account holder creation

Report: OnUs merchant settled transactions

Report description: The following report is only relevant if you have onboarded an on-us merchant with Fusion.

OnUs merchant settled transactions is a summary report of all onus merchant spends that have been settled with the issuer for a fintech in a period.

Column NameDescription (format / sample value)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Product typeClassification of account product that is being credited/ debited (MCC_VOUCHER_RECIPIENT)
AmountTransaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
Zeta business IDUnique ID for the Merchant in Fusion System (e.g. 298466)
Zeta store nameMerchant Name (e.g. Cashfree)
Record typeType of transaction (CREDIT / DEBIT)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.

Report: OnUs merchant unsettled transactions

Report description: The following report is only relevant if you have onboarded an on-us merchant with Fusion.

OnUs merchant unsettled transactions is a summary report of all onus merchant spends that have been unsettled with the issuer for a fintech in a period.

Column NameDescription (format / sample value)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Product typeClassification of account product that is being credited/ debited (MCC_VOUCHER_RECIPIENT)
AmountTransaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
Zeta business IDUnique ID for the Merchant in Fusion System (e.g. 298466)
Zeta store nameMerchant Name (e.g. Cashfree)
Record typeType of transaction (CREDIT / DEBIT)
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.

Report: OnUs Business settlement report

Report description: The following report is only relevant if you have onboarded an on-us merchant with Fusion.

This report provides Settlement ID to transaction dump mapping for ONUS merchants.

Column NameDescription (format / sample value)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30)
Transaction AmountTransaction amount (20)
Zeta business IDUnique ID for the Merchant in Fusion System (e.g. 298466)
Zeta store nameMerchant Name (e.g. Cashfree)
Settlement IDUnique Identifier for the settlement transaction in Fusion System
Settlement DateDate of settlement
Settlement AmtAmount of settlement transaction
Settlement StatusSuccess/ pending - latest status here as on the timestamp this report is being generated.

Report: Funding account dump

Report description: Funding account dump is a summary report of all credits/ debits from fintech’s funding ledger for a period.

Column NameDescription (format / sample value)
Transaction dateTimestamp of transaction (YYYY-MM-DD HH:MM:SS+05:30
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
Account IDUnique identifier for the account as per Fusion System (e.g. 5204440346096229054)
Ledger IDID of the ledger associated with the account in Fusion System (349000000000000000)
Transaction IDUnique Identifier for the transaction in Fusion system (20200601041613663_1077680_bbfa3a5ee0524f9e83a3f037bc4180ed)
Record typeType of transaction (CREDIT / DEBIT)
Amount (INR)Transaction amount (20)
Journal voucher codeTransaction type identifier in Fusion system to uniquely identify channels (e.g. Visa/MC etc), usecase (e.g. eCom, POS etc.) and the state of txn (e.g. Auth, reversal etc.). Sample code: A2A_P2P_AUTH
Reversed transaction IDID of Original transaction for reference purpose. This is populated only if the record is for a reversal.
RemarksRemarks passed during initiating the request (e.g. Physical Super Card ECOM Purchase)

Report: KYC report

Report description: On-boarding report containing details of AHs created in a period for a Fintech along with KYC status and validity details.

Column NameDescription (format / sample value)
Account holder created dateTimestamp of account holder creation (YYYY-MM-DD HH:MM:SS+05:30)
Account holder IDUnique identifier of account holder as per Fusion system (0e5c40eb-558b-4ab5-ac66-cf0820878151)
First nameFirst name of the account holder
Middle nameMiddle name of the account holder
Last nameLast name of the account holder
KYC statusKYC status of the account holder (e.g. Minimal, Aadhaar OTP)
Account statusStatus of the account (enabled/blocked/deleted)
KYC expiry dateTimestamp at which the KYC will expire (YYYY-MM-DD HH:MM:SS+05:30)