Reports

Finix offers several pre-defined reports that detail the activity on your account. These reports get generated regularly and are available for review in the Finix Dashboard.

To view these reports:

  1. Log in to your Finix Dashboard .
  2. Click Reports on the left.

The following reports are available on the Finix Dashboard:

Report Name Description
Net Profit Report Gross revenue and fees collected.
Transaction Interchange Report Per-transaction fees and costs including interchange.
Transactions Settled All transactions that settled the previous day.
Fee Profile - Merchant Active fee profiles for all onboarded Merchants.
Settlement Merchant All settlements generated the previous day, aggregated by the Identity of the Merchant.
Settlement Application All settlements generated the previous day, aggregated by Application.
Settlement Processor All settlements generated the previous day, aggregated by Application and processor.
Chargeback Merchant (Daily) All new chargebacks and any chargebacks with updates from the previous day. The report is blank if there's no new chargeback activity.
Chargeback Merchant (Historical) Details all chargeback-related metrics for Merchants. Merchants with higher disputes in the last 30 days get sorted to the top of the report.
Failed Funding Instructions Details all the Funding Transfers that got returned. For more information about Funding Transfers, see Payouts.

Net Profit Report

The Net Profit report provides an end-to-end view of all the fees you've collected. This report also breaks down how the collected fees get used for interchange & assessments, program fees, and revenue share.

  • All currencies are in the local currency (USD).
  • All timestamps are in UTC.
  • The report is generated monthly, containing transactions settled in the previous month.
    • An estimate version of the report gets generated on the 1st of the month; this estimate report only includes zero or estimated assessments.
    • A final version of the report is generated on the 16th of the month, containing the final assessment data.
attention

The Net Profit Report is only available in early access and will be publicly available shortly. For more information, reach out to your Finix point of contact.

The different Net Profit reports that are available include:

File Name Description
net_profit_per_merchant_report_v3 Details all the fees collected per Merchant.
net_profit_per_application_report_v3 Details all the fees collected per Application.
net_profit_per_merchant_report_v3 Details all the fees collected per Platform (Finix Core only).
Field Description
merchant_id
  • ID of the Merchant associated with the transaction.
  • The unique merchant_id begins with MU.
merchant_name The legal name saved in the Merchant resource.
merchant_doing_business_as The "doing business as" name saved in the Merchant resource.
mid MID of the Merchant.
mcc The Merchant Category Code (MCC) the Merchant is classified under.
card_sale_count Total count of card sales and capture transactions.
card_sale_amount Total amount of card sales and capture transactions.
echeck_sale_count Total count of eCheck (also called ACH payments) sale transactions.
echeck_sale_amount Total amount of eCheck sale transactions.
total_sale_count The total sum of card_sale_count and echeck_sale_count (in dollars, e.g. 1102 = $11.02).
total_sale_amount The total sum of card_sale_amount and echeck_sale_amount.
card_refund_count The number of card refunds performed (in dollars).
card_refund_amount The total sum of all card refunds (in dollars).
echeck_refund_count The number of eCheck refunds performed.
echeck_refund_amount The total sum of all eCheck refunds (in dollars).
echeck_return_count The number of returned eChecks. Returned eChecks are eCheck transactions that returned as unpaid.
echeck_return_amount The total sum of all returned eChecks. Returned eChecks are eCheck transactions that returned as unpaid.
dispute_count The number of card disputes such as chargebacks. Follow-up dispute activity such as re-presentment is not included here.
dispute_amount The total sum of all of card disputes such as chargebacks (in dollars). If a dispute has multiple movements of money such as if a merchant wins the dispute, those additional money movements don't get included.
card_bps_rate Card transactions only. The base variable fee that was applied to card transactions. This column might not reflect any older rates that applied to this Merchant or for specific transactions.
card_per_item_rate Card transactions only. The base per-item fee that was applied to card transactions. This column might not reflect any older rates that applied to this Merchant or for specific transactions.
card_fees_amount Total sum of card fees collected from the merchant.
echeck_bps_rate eCheck transactions only. The base variable fee that was applied to eCheck transactions. This column might not reflect any older rates that applied to this Merchant or for specific transactions.
echeck_per_item_rate eCheck transactions only. The base per-item fee that was applied to eCheck transactions. This column might not reflect any older rates that applied to this Merchant or for specific transactions.
echeck_fees_amount Total sum of eCheck fees collected from the Merchant.
total_fees_amount Sum of card_fees_amount and echeck_fees_amount.
interchange_fees_amount All card interchange fees assessed. Note: This includes eCheck processing fees.
dues_and_assessments_fees_amount All dues and assessments fees assessed. Note: Due to the time it takes for our processor to deliver data, this column can be incomplete or blank until Finix receives and processes all data up to the 15th day of the following month.
total_network_fees_amount Sum of interchange_fees_amount and dues_and_assessments_fees_amount.
total_program_fees_amount All Finix per-transaction and additional fees assessed.
residual_amount Total amount of residual revenue. Represents total_fees_amount minus total_network_fees_amount and total_program_fees_amount.
application_id ID of the Application associated with the transaction.
application_business_name The registered name saved in the Application resource.
application_doing_business_as The "doing business as" name saved in the Application resource.
platform_id The ID of the Platform.
platform_name The name saved in the Platform resource.
report_created_at A timestamp of when the report was created (in UTC using ISO8601 formatting).
report_range_start A timestamp that details the beginning of the range covered by this report (in UTC using ISO8601 formatting).
report_range_end A timestamp that details the end of the range covered by this report (in UTC using ISO8601 formatting).

Transaction Interchange Report

The Transaction Interchange report details all the settled transactions and their associated fees and costs. Fees that are detailed include:

  • Total fees withheld.
  • Interchange rates and fees.
  • Payment facilitator program fees.

A transaction will still appear in this report if the merchant's Settlement is pending approval and the merchant's Funding Transfer hasn't gotten generated. For more information on approving Settlements, see Payouts.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated daily, including weekends and holidays.
attention

The Transaction Interchange Report is only available in early access and will be publicly available shortly. For more information, reach out to your Finix point of contact.

Reports generated for Payment Facilitators (Finix Core) include additional fields noted below.

Field Description
merchant_id
  • ID of the Merchant associated with the transaction.
  • The unique merchant_id begins with MU.
merchant_name The legal name saved in the Merchant resource.
merchant_doing_business_as The "doing business as" name saved in the Merchant resource.
mid MID of the Merchant.
mcc The Merchant Category Code (MCC) the Merchant is classified under.
trace_id
  • Trace ID of the Transfer. The processor sends back the trace_id so you can track the transaction end-to-end.
  • The unique trace_id begins with FNX, but can change depending on the processor of the transaction.
transaction_id
  • Finix's ID for the Transfer resource.
  • The unique transaction_id begins with **T
created_at Timestamp of when the transaction was received by the processor (in UTC using ISO8601 formatting).
updated_at Timestamp of when the transaction was last updated (in UTC using ISO8601 formatting).
last_4 Last 4 digits of the payment card or bank account used in the transactions.
statement_descriptor The description of the transaction that appears on the buyer's bank or card statement.
item_type The type of the transaction.
item_subtype The subtype of the transaction. Provides additional details for item_type.
payment_type The type of payment method used for the transaction.
payment_subtype If available, the subtype of the payment method used for the transaction.
payment_channel For card transactions only. Details if a card was present for the transaction. Available values include:
  • CARD_PRESENT
  • CARD_NOT_PRESENT
transaction_currency 3-letter ISO code designating the currency of the transaction .(e.g. USD)
transaction_amount The amount processed by the transaction (in dollars).
fee_profile_id
  • The ID of the Fee Profile associated with the transaction.
  • The unique fee_profile_id begins with FP.
card_bps_rate Card transactions only. The base variable fee that was applied. Note: The fee_profile can contain additional details or overrides that apply to this transaction. Use the linked fee_profile_id to find the details in the fee_profile_merchant report.
card_per_item_rate Card transactions only. The base per-item fee that was applied. Note: The fee_profile can contain additional details or overrides that apply to this transaction. Use the linked fee_profile_id to find the details in the fee_profile_merchant report.
echeck_bps_rate eCheck transactions only. The base variable fee that was applied. Note: The fee_profile can contain additional details or overrides that apply to this transaction. Use the linked fee_profile_id to find the details in the fee_profile_merchant report.
echeck_per_item_rate eCheck transactions only. The base per-item fee that was applied. Note: The fee_profile can contain additional details or overrides that apply to this transaction. Use the linked fee_profile_id to find the details in the fee_profile_merchant report.
fee_amount The total amount of fee collected for this transaction.
program_fee_amount The per-transaction fee collected by Finix for this transaction. (Finix Flex only)
  • This doesn't include any additional fees not directly tied to this transaction.
  • This field is left blank for Finix Core customers.
card_brand Card transactions only. The brand of the card used.
interchange_category A description of the interchange rates applied to this transaction.
interchange_category_id The category ID of the interchange rate for this transaction.
interchange_bps_rate In basis points, the interchange variable rate charged for this transaction.
interchange_per_item The interchange per-item rate charged for this transaction.
interchange_amount The total interchange amount charged for this transaction.
merchant_settled_amount The total amount of the transaction that's settled to the merchant. For settlement scenarios such as split or combined settlement, this includes the sum of all non-fee settled amounts.
original_trace_id Refunds, reversals, or disputes only. The trace_id from the original transaction.
original_transaction_id Refunds, reversals, or disputes only. The transaction_id from the original transaction.
original_transaction_method Refunds, reversals, or disputes only. Details the method used to process the original transaction.
original_transaction_currency Refunds, reversals, or disputes only. The currency of the original transaction.
original_transaction_amount Refunds, reversals, or disputes only. The amount, in dollars, processed in the original transaction.
authorization_id Captures only. The ID of the related authorization.
authorization_currency Captures only. The currency of the related authorization.
authorization_amount Captures only. The amount, in dollars, of the related authorization.
gateway Name of the gateway that processed this transaction. (Finix Core only).
processor Name of acquiring processor that settled the transaction. (Finix Core only).
settlement_id ID of the Settlement. (Finix Core only).
settlement_created_at A timestamp of when the merchant Settlement was created (in UTC using ISO8601 formatting).
settlement_updated_at A timestamp of when the Settlement was last updated (in UTC using ISO8601 formatting).
settlement_status The status of the Settlement. Available values include:
  • PENDING
  • STAGED
  • AWAITING_APPROVAL
  • APPROVED.
Merchants only receive payouts when Settlements are APPROVED. For more information, see Payouts.
application_id ID of the Application associated with the transaction.
application_business_name The registered name saved in the Application resource.
application_doing_business_as The "doing business as" name saved in the Application resource.
platform_id The ID of the platform that processed the transaction.
platform_name The name saved in the platform resource.
report_created_at A timestamp of when the report was created (in UTC using ISO8601 formatting).
report_range_start A timestamp that details the beginning of the range covered by this report (in UTC using ISO8601 formatting).
report_range_end A timestamp that details the end of the range covered by this report (in UTC using ISO8601 formatting).

Transactions Settled

The Transactions Settled report details all the transactions that have settled since the previous business day. The report also includes transactions that settled over the weekend or on bank holidays.

Note the Settlement itself does not need to be approved or funded for the transaction to appear in this report.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description
transfer_id
  • ID of the Transfer resource.
  • The unique transfer_id begins with TR.
trace_id
  • Trace ID of the Transfer. The processor sends back the trace_id so you can track the transaction end-to-end.
  • The unique trace_id begins with FNX, but can change depending on the processor of the transaction.
transfer_created_at Timestamp of when the transaction was created.
transfer_type Type of transaction. Valid values include:
  • DEBIT (Sale and capture transactions)
  • CREDIT (Refunds, reversals)
application_id
  • ID of the Application associated with the transaction.
  • The unique application_id begins with AP.
application_name Name of the Application associated with the transaction.
processor_id ID of the processor handling the transaction.
processor Name of the transaction processor.
merchant_id
  • ID of the Merchant associated with the transaction.
  • The unique merchant_id begins with MU.
merchant_identity_id
  • ID of the Identity associated with the Merchant.
  • The unique merchant_identity_id begins with ID.
processor_mid MID of the Merchant.
currency 3-letter ISO code designating the currency of the Transfers. (e.g. USD)
amount The amount of the transaction (in dollars).
fee The total fee that was withheld from the transaction (in dollars).
platform_fee If assessed, the platform fee that was applied to the transaction (in dollars).
application_fee If assessed, the application fee that was applied to the transaction (in dollars).
instrument_type The type of Payment Instrument used in the transaction. Possible values include:
  • BANK_ACCOUNT
  • PAYMENT_CARD
  • PAYMENT_CARD_PRESENT
  • APPLE_PAY
  • GOOGLE_PAY
  • VIRTUAL (for credits and reversals)
settlement_id
  • The ID of the Settlement associated with the transaction.
  • The unique settlement_id begins with ST.
settlement_created_at A timestamp of when the Settlement was created (in UTC using ISO8601 formatting).
settlement_total_amount Total amount of the Settlement (in dollars).
settlement_total_fees The total sum of fees in the Settlement (in dollars).
settlement_net_amount Total amount sent to the Merchant (in dollars).
latest_funding_transfer_id
  • The ID of the latest Funding Transfer associated with the Settlement. For more information about Funding Transfers, see Payouts.
  • The unique latest_funding_transfer_id begins with TR.
latest_funding_transfer_trace_id
  • The latest funding trace_ID associated with the transaction.
  • The unique latest_funding_transfer_trace_id begins with FNX, but can change depending on the processor of the transaction.
funding_transfer_state The state of the Funding Transfer. Possible values include:
  • PENDING
  • SUBMITTED
funding_transfer_created_at A timestamp of when the Funding Transfer was created.
fee_profile_id
  • The ID of the Fee Profile associated with the transaction.
  • The unique fee_profile_id begins with FP.
fee_profile_bps The Basis Point Fees on Credit Cards and Debit Cards.
fee_profile_fixed The Fixed Fee on Credit Cards and Debit Cards.
fee_profile_interchange_enabled
  • If TRUE Interchange is enabled.
  • If FALSE Interchange is not enabled.
fee_profile_ach_bps The Basis Point Fees on ACH (eCheck) transactions.
fee_profile_ach_fixed The Fixed Fee on ACH (eCheck) transactions.

Transaction Types for Reporting

Transaction metadata is available to help you quickly filter, find, and manage transactions. The metadata details the transactions processed and the Payment Instruments used.

Finix provides the following fields in the Transactions Settled and Transaction Interchange Reports:

  • item_type : Type of transaction for the reported line.
  • item_subtype : Additional information describing the item_type .
  • payment_type : The type of Payment Instrument used in the transaction (or the original payment).
  • payment_subtype : Additional information describing the payment_type .
  • payment_channel : Details if the transaction was card-present (a debit card was used), or card-not-present (e.g. eCommerce transactions).

The different values that can appear in the above fields include:

Field Values Description
item_type ADJUSTMENT A manual transfer of funds between the For Benefit of (FBO) account and the users' accounts.
item_type DISPUTE_TRANSFER A withdrawal or deposit to a merchant account following the outcome of a disputed charge.
item_type FEE The fees (in dollars) charged to the sub-merchant or the client
item_type P2C Real-time payments that use Finix's Push to Card APIs. This includes P2P payments and disbursements.
item_type PAYMENT Payments from cards, bank accounts, or other Payment Instruments, including captured charges.
item_type RETURN Payments or reverses that get returned following a payment failure.
item_type REVERSE Payments that got refunded to the buyer.
item_subtype APPLICATION_FEE Any fee that exceeds the program fee that's defined for the Merchant and/or Application.
item_subtype CAPTURE The clearing and transfer of funds from the buyer following the second part of a dual-message transaction.
item_subtype CUSTOM_FEE The subscription fee.
item_subtype MERCHANT_DEPOSIT A transfer of funds to a merchant account, for item_type DISPUTE_TRANSFER and ADJUSTMENT
item_subtype MERCHANT_WITHDRAWAL A transfer of funds from a merchant account, for item_type DISPUTE_TRANSFER and ADJUSTMENT
item_subtype PLATFORM_FEE The program fee.
item_subtype PULL_FROM_CARD A transfer of funds from a payment card using Finix's Push to Card APIs.
item_subtype PUSH_TO_CARD A transfer of funds to a payment card using Finix's Push to Card APIs.
item_subtype REFUND A payment refunded to the buyer.
item_subtype REFUND_RETURN A return of refunded funds to the Merchant, following a payment failure.
item_subtype RETURN A return of funds following a payment failure.
item_subtype SALE A transfer of funds from a buyer in a single-message transaction.
item_subtype UNREFERENCED_REFUND A payment that has been refunded to the buyer, but does not reference the original transaction.
payment_type CARD A payment card (e.g. A debit or credit card).
payment_type ECHECK A bank account.
payment_type VANTIV_OMNI_TOKEN A Worldpay-specific token that represents a Payment Instrument.
payment_subtype APPLE_PAY Indicates that a Payment Instrument was used with Apple Pay in a CARDNOTPRESENT transaction.
payment_subtype GOOGLE_PAY Indicates that a Payment Instrument was used with Google Pay in a CARDNOTPRESENT transaction.
payment_channel CARD_PRESENT A physical card got used in-person to process the payment (e.g The card was swiped, dipped, tapped, etc.).
payment_channel CARD_NOT_PRESENT The Payment Instrument used for the transaction got entered remotely. (e.g. online, phone, eCheck)

item_types and available subtypes

item_type item_subtype
PAYMENT
  • CAPTURE
  • SALE
P2C
  • PULL_FROM_CARD
  • PUSH_TO_CARD
REVERSE
  • REFUND
  • UNREFERENCED_REFUND
  • RETURN
  • REFUND_RETURN
DISPUTE_TRANSFER
  • MERCHANT_DEPOSIT
  • MERCHANT_WITHDRAWAL
  • PLATFORM_DEPOSIT
  • PLATFORM_WITHDRAWAL
ADJUSTMENT
  • MERCHANT_DEPOSIT
  • MERCHANT_WITHDRAWAL
  • PLATFORM_DEPOSIT
  • PLATFORM_WITHDRAWAL
FEE
  • APPLICATION_FEE
  • CUSTOM_FEE
  • PLATFORM_FEE

payment_types and available subtypes and channels

payment_type payment_subtype payment_channel
CARD NULL CARD_PRESENT, CARD_NOT_PRESENT
APPLE_PAY, GOOGLE_PAY CARD_NOT_PRESENT
ECHECK NULL CARD_NOT_PRESENT
VANTIVOMNITOKEN NULL CARD_NOT_PRESENT

Fee Profile - Merchant

The Fee Profile - Merchant report details all of your onboarded merchants and the fees applied to their transactions.

If a fee profile isn't set up for a merchant, the application or platform level fee profile gets applied instead.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays Monday to Friday (excluding bank holidays).
Field Name Description Prefix of the Finix Resource ID
identity_id
  • ID of the Identity resource associated with the Merchant.
  • The unique identity_id begins with ID.
merchant_id
  • ID of the Merchant resource associated with the transaction.
  • The unique merchant_id begins with MU.
merchant_created_at A timestamp of when the Merchant was created.
application_id
  • ID of the Application associated with the transaction.
  • The unique application_id begins with AP.
business_name The full legal business name saved for the Merchant.
doing_business_as The "doing business as" name saved in the Merchant resource (if applicable).
processor Name of the transaction processor.
mcc The Merchant Category Code (MCC) the Merchant is classified under.
fee_profile_id The ID of the Fee Profile associated with the transaction.
card_basis_points The fee, in basis points, applied to credit and debit card transactions.
card_fixed_fee The fixed fee on credit and debit card transactions.
ach_debit_basis_points The fee, in basis points, on ACH Transfers.
ach_debit_fixed_fee The fixed fee on ACH Transfers.
charge_interchange_fees Set to True to incur interchange fees for card-based Transfers
fee_profile_created_at A timestamp of the date the Fee Profile associated with the transaction was created.
line_1 The first address line saved in the Merchant resource.
line_2 The second address line saved in the Merchant resource.
city The city saved in the Merchant resource.
region The 2-letter State code saved in the Merchant resource.
postal_code The Postal code saved in the Merchant resource.
country The country saved in the Merchant resource.
processing_enabled Details if transaction processing is enabled for the Merchant.
settlement_enabled Details if settlement processing is enabled for the Merchant.
onboarding_state Details the state of the Merchant's Onboarding
application_name Application name
processor_submerchant_id Processor’s submerchant identification number
rounding_mode Details if a single TRANSACTION or a whole SETTLEMENT is rounded.
qualified tiers If specific functionality for qualified tiers are enabled or disabled. Usually null.
card_basis_points_decimal Version of card_basis_points that contains fractional values rounded to 1/10 of 1 basis point.
card_fixed_fee_decimal Version of card_fixed_fee that contains fractional values rounded to 1/10 of 1 cent granularity.
ach_debit_basis_points_decimal Version of ach_debit_basis_points that contains fractional values rounded to 1/10 of 1 basis point.
ach_debit_fixed_fee_decimal Version of ach_debit_fixed_fee that contains fractional values rounded to 1/10 of 1 cent granularity.
dispute_inquiry_fixed_fee The fee charged when a dispute is created with the state INQUIRY.
dispute_fixed_fee The fee charged when a dispute is created or moved to state PENDING .
ach_debit_return_fixed_fee Fee in cents of ACH debits (withdrawals) that are returned.
ach_credit_return_fixed_fee Fee in cents of ACH credits (deposits) that are returned.
visa_basis_points The percentage-based fee charged against the full amount of each Visa Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
visa_fixed_fee The fee (in cents) charged for each individual Visa Transfer.
visa_charge_interchange Details if interchange fees are enabled for Visa Transfers.
visa_assessments_basis_points The assessment fee charged to to all Visa credit transactions
visa_acquirer_processing_fixed_fee The fee charged to all U.S.-based credit card authorizations acquired in the U.S. regardless of where the issuer/cardholder is located. If your business is based in the U.S., the acquirer processing fee will apply to all Visa credit card Authorizations.
visa_credit_voucher_fixed_fee The fee applied to refunds.
visa_kilobyte_access_fixed_fee The fee charged on each Authorization transaction submitted to Visa’s network for settlement.
discover_basis_points The percentage-based fee charged against the full amount of each Discover Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
discover_fixed_fee The fee (in cents) charged for each individual Discover Transfer.
discover_charge_interchange Details if interchange fees are enabled for Discover Transfers.
discover_assessments_basis_points The fee applied to the gross Discover card volume.
discover_data_usage_fixed_fee The Discover data usage fee that applies to all U.S.-based authorization transactions.
discover_network_authorization_fixed_fee This fee applies to all Discover network authorizations and replaces any previously assessed discover_data_usage_fixed_fee.
diners_club_basis_points The percentage-based fee charged against the full amount of each diners Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
diners_club_fixed_fee The fee (in cents) charged for each individual diners Transfer.
diners_club_charge_interchange Details if interchange fees are enabled for diners Transfers.
mastercard_basis_points The percentage-based fee charged against the full amount of each MasterCard Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
mastercard_fixed_fee The fee (in cents) charged for each individual MasterCard Transfer.
mastercard_charge_interchange Details if interchange fees are enabled for for MasterCard Transfers.
mastercard_assessments_under1k_basis_points The assessment fee charged to Mastercard transactions less than or equal to $1,000.
mastercard_assessments_over1k_basis_points The assessment fee charged to Mastercard credit sale transactions greater than $1,000.
mastercard_acquirer_fees_basis_points This fee is assessed and based on a business’s gross MasterCard processing volume. This fee varies based on MasterCard’s assessed charge as it’s distributed across your portfolio of merchants. Generally, the ALF fee is a fraction of a basis point. For example, 0.0045%, 0.0075%, etc., are likely examples of a ALF fee.
jcb_basis_points The percentage-based fee charged against the full amount of each JCB Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
jcb_fixed_fee The fee (in cents) charged for each individual JCB Transfer.
jcb_charge_interchange Details if interchange fees are enabled for JCB Transfers.
american_express_basis_points The percentage-based fee charged against the full amount of each American Express Transfer. Calculated as one hundredth of one percent (1 basis point = .0001 or .01%).
american_express_fixed_fee The fee (in cents) charged for each individual American Express Transfer.
american_express_charge_interchange Details if interchange fees are enabled for American Express Transfers.
american_express_assessment_basis_points The fee applied to the gross American Express card volume.
visa_base_II_system_file_transmission_fixed_fee The fee that's applied to all Visa transactions and is charged in addition to other transaction-based fess.
visa_base_II_credit_voucher_fixed_fee The fee applied to all U.S.-based refunds
ancillary_fixed_fee_primary An additional fixed fee that can be charged per Transfer
ancillary_fixed_fee_secondary An additional fixed fee that can be charged per Transfer if the ancillary_fixed_fee_primary is passed

Settlement Merchant

The Settled Merchant report shows you all the Settlements generated the day before and aggregated by Merchant. If a Merchant has multiple processing accounts, all accounts wil be aggregated in the report.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description Prefix of the Finix Resource ID
settlement_id
  • The ID of the Settlement resource.
  • The unique settlement_id begins with ST.
settlement_created_at A timestamp of when the merchant Settlement was created (in UTC using ISO8601 formatting).
identity_id
  • ID of the Identity resource associated with the Merchant.
  • The unique identity_id begins with ID.
merchant_id
  • ID of the Merchant associated with the Settlement.
  • The unique merchant_id begins with MU.
merchant_created_at A timestamp of when the Merchant was created.
application_id
  • ID of the Application associated with the transaction.
  • The unique application_id begins with AP.
business_name The full legal business name saved for the Merchant.
doing_business_as The "doing business as" name saved in the Merchant resource (if applicable).
processor Name of the Settlement processor.
total_amount Total sum of the Settlement (Fees+Net Settled).
total_fees Sum of the fees in the Settlement.
net_settled Details the amount paid to Merchants (total_amount - total_Fees).
currency 3-letter ISO code designating the currency of the Settlement. (e.g. USD).
total_debit_amount The sum of all debit Transfers in the Settlement.
total_debit_count The total number of debit Transfers processed in the Settlement.
total_reversal_amount The sum of of all reversal Transfers in the Settlement.
total_reversal_count The total number of reversal Transfers processed in the Settlement.
total_credit_amount The sum of of all credit Transfers in the Settlement.
total_credit_count The total number of credit Transfers processed in the Settlement.
total_dispute_debit_adjustment_amount The sum of all debit dispute adjustment Transfers in the Settlement.
total_dispute_debit_adjustment_count The total number of debit dispute adjustment Transfers processed in the Settlement.
total_dispute_credit_adjustment_amount The sum of all credit dispute adjustment Transfers in the Settlement.
total_dispute_credit_adjustment_count The total number of credit dispute adjustment Transfers processed in the Settlement.
payment_instrument_id
  • The ID of the Payment Instrument associated with the Settlement.
  • The unique payment_instrument_id begins with PI.
latest_funding_transfer_id
  • The ID of the latest Funding Transfer associated with the Settlement. For more information about Funding Transfers, see Payouts.
  • The unique transfer_id begins with TR.
funding_transfer_created_at A timestamp of when the Funding Transfer was created.
latest_funding_transfer_trace_id
  • The latest funding trace_ID associated with the Funding Transfer.
  • The unique trace_id begins with FN, but can change depending on the processor of the transaction.
funding_transfer_state The state of the Funding Transfer. Possible values include:
  • PENDING
  • SUBMITTED
payment_instrument_data Data associated with the Payment Instrument.
platform_settlement_id
  • The Settlement ID associated with the platform.
  • The unique settlement_id begins with ST.
platform_settlement_created_at A timestamp of when the Settlement for the platform was created (in UTC using ISO8601 formatting).
platform_latest_funding_transfer_id
  • The ID of the latest Funding Transfer associated with the Settlementof the platform.
  • The unique transfer_id begins with TR.
platform_funding_transfer_created_at A timestamp of when the Funding Transfer for the platform was created.
platform_latest_funding_transfer_trace_id
  • The trace_ID of the latest Funding Transfer associated with the platform.
  • The unique trace_id begins with FN, but can change depending on the processor of the transaction.
platform_funding_transfer_state The state of the Funding Transfer associated with the platform.
application_settlement_id
  • The ID of the Settlement associated with the Application.
  • The unique settlement_id begins with ST.
application_settlement_created_at A timestamp of when the Settlement for the Application was created (in UTC using ISO8601 formatting).
application_latest_funding_transfer_id
  • The ID of the latest Funding Transfer associated with the Settlementof the Application.
  • The unique transfer_id begins with TR.
application_funding_transfer_created_at A timestamp of when the Funding Transfer for the Application was created.
application_latest_funding_transfer_trace_id
  • The trace_ID of the latest Funding Transfer associated with the Application.
  • The unique trace_id begins with FN, but can change depending on the processor of the transaction.
application_funding_transfer_state The state of the Funding Transfer associated with the Application.

Settlement Application

The Settled Application report shows you all the settlements generated the day before, aggregated by Application. If you are a Flex Client, this report shows only one line of data for the transactions processed with Finix.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description
application_id
  • ID of the Application associated with the transaction.
  • The unique application_id begins with AP.
created_at Date the Application was created at
business_name The full legal business name saved for the Application.
doing_business_as The "doing business as" name saved in the Application resource.
currency 3-letter ISO code designating the currency of the Settlement. (e.g. USD)
total_amount Total sum of the Settlement (Fees+Net Settled).
total_fees Sum of the fees in the Settlement.
net_settled Details the amount paid to Merchants (total_amount - total_Fees).
total_debit_amount The sum of all debit Transfers in the Settlement.
total_debit_count The total number of debit Transfers processed in the Settlement.
total_reversal_amount The sum of of all reversal Transfers in the Settlement.
total_reversal_count The total number of reversal Transfers processed in the Settlement.
total_credit_amount The sum of of all credit Transfers in the Settlement.
total_credit_count The total number of credit Transfers processed in the Settlement.
total_dispute_debit_adjustment_amount The sum of all debit dispute adjustment Transfers in the Settlement.
total_dispute_debit_adjustment_count The total number of debit dispute adjustment Transfers processed in the Settlement.
total_dispute_credit_adjustment_amount The sum of all credit dispute adjustment Transfers in the Settlement.
total_dispute_credit_adjustment_count The total number of credit dispute adjustment Transfers processed in the Settlement.
total_merchant_settlement_count The total number of Settlements that were created with type MERCHANT.
total_merchant_debit_settlement_amount The sum of net_settled for all Settlements with type MERCHANT.
total_merchant_debit_settlement_count The total number of net_settled Settlements with type MERCHANT.

Settlement Processor

The Settled Processor report shows you all the settlements generated the day before, aggregated by Application and by processor. If you are a Flex Client, this report shows only one line of data for your business with Finix.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description
application_id
  • ID of the Application associated with the transaction.
  • The unique application_id begins with AP.
created_at When the Application was created
business_name The full legal business name saved for the Application.
doing_business_as The "doing business as" name saved in the Application resource.
processor Name of the settlement processor.
currency 3-letter ISO code designating the currency of the Settlement. (e.g. USD).
total_amount Total sum of the Settlement (Fees+Net Settled).
total_fees Sum of the fees in the Settlement.
total_debit_amount The sum of all debit Transfers in the Settlement.
total_debit_count The total number of debit Transfers processed in the Settlement.
total_reversal_amount The sum of of all reversal Transfers in the Settlement.
total_reversal_count The total number of reversal Transfers processed in the Settlement.
total_credit_amount The sum of of all credit Transfers in the Settlement.
total_credit_count The total number of credit Transfers processed in the Settlement.
total_dispute_debit_adjustment_amount The sum of all debit dispute adjustment Transfers in the Settlement.
total_dispute_debit_adjustment_count The total number of debit dispute adjustment Transfers processed in the Settlement.
total_dispute_credit_adjustment_amount The sum of all credit dispute adjustment Transfers in the Settlement.
total_dispute_credit_adjustment_count The total number of credit dispute adjustment Transfers processed in the Settlement.
total_merchant_settlement_count The total number of Settlements that were created with type MERCHANT.
total_merchant_debit_settlement_amount The sum of net_settled for all Settlements with type MERCHANT.
total_merchant_debit_settlement_count The total number of net_settled Settlements with type MERCHANT.

Chargeback Merchant (Daily)

The Chargeback Merchant (Daily) report shows all the chargebacks that got generated or updated the previous day. The CSV will be blank if no chargebacks are generated or updated on the previous day.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description
dispute_id
  • ID of the Dispute.
  • The unique dispute_id begins with DI.
merchant_identity_id
  • ID of the Identity resource associated with the Merchant.
  • The unique merchant_identity_id begins with ID.
merchant_id
  • ID of the Merchant associated with the Dispute.
  • The unique merchant_id begins with MU.
merchant_created_at A timestamp of when the Merchant was created.
application_id
  • ID of the Application associated with the Dispute.
  • The unique application_id begins with AP.
business_name The full legal business name saved for the Merchant.
doing_business_as The "doing business as" name saved in the Merchant resource (if applicable).
processor Name of the Dispute processor.
dispute_created_at The date the Dispute was created
dispute_amount The total amount of the Dispute (in cents).
dispute_currency 3-letter ISO code designating the currency of the Dispute. (e.g. USD).
reason The reason for the Dispute. Available values include:
  • INQUIRY
  • QUALITY
  • CLERICAL
  • FRAUD
  • TECHNICAL
message The messages saved in the Dispute.
action The next action required to move forward with the Dispute.
respond_by The date the Merchant needs to submit evidence to supports their claim.
transfer_id The ID of the Transfer associated with the Dispute.
transfer_amount The total sum of the Transfer associated with the Dispute.
transfer_created_at A timestamp of when the Transfer was created.
adjustment_transfer_id
  • The ID of the Transfer created to adjust funds due to the Dispute.
  • The unique transfer_id begins with TR.
adjustment_transfer_settlement_id
  • The ID of the Settlement created to adjust funds due to the Dispute.
  • The unique settlement_id begins with ST.
adjustment_transfer_settlement_created_at A timestamp of when the Transfer was created to adjust funds.
settlement_funding_transfer_state The state of the Funding Transfer associated with the adjustment Settlement. Possible values include:
  • PENDING
  • SUBMITTED
chargeback_settlement_exposure Exposure for a Settlement chargeback.
card_holder_name Name of the card holder saved in the Payment Instrument.
bin Bank Identification number for the Payment Instrument.
last_four Last four digits of the card or bank account number
brand The brand of the card saved in the Payment Instrument.
total_dispute_volume_past_30_days Total Dispute volume in the last 30 days.
total_dispute_volume_ratio_past_30_days Total Dispute volume / total processing volume in the last 30 days.
total_dispute_count_past_30_days The total number of Disputes processed over the last 30 days.
total_dispute_count_ratio_past_30_days The total number of Disputes that SUCCEEDED vs FAILED over the last 30 days.
total_dispute_volume_past_year Total Dispute volume over the past year.
total_dispute_volume_ratio_past_year Total Dispute volume / total processing volume over the last year.
total_dispute_count_past_year Total number of Disputes processed over the last year.
total_dispute_count_ratio_past_year The total number of Disputes processed over the last year.
merchant_line_1 The first address line saved in the Merchant resource.
merchant_line_2 The second address line saved in the Merchant resource.
merchant_city The city saved in the Merchant resource.
merchant_region The 2-letter State code saved in the Merchant resource.
merchant_postal_code The Postal code saved in the Merchant resource.
merchant_country The country saved in the Merchant resource.
processing_enabled Details if transaction processing is enabled for the Merchant.
settlement_enabled Details if settlement processing is enabled for the Merchant.
merchant_onboarding_state Details the state of the Merchant's Onboarding
dispute_updated_at A timestamp of the date the Dispute was last updated.

Chargeback Merchant (Historical)

The Chargeback Merchant (Historical) report gives you a view of your Merchants and how they're processing chargebacks and Disputes. Merchants with higher disputes in the last 30 days are shown at the top of the report.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays from Monday to Friday (excluding bank holidays).
Field Description
merchant_identity_id
  • ID of the Identity resource associated with the Merchant.
  • The unique merchant_identity_id begins with ID.
merchant_id
  • ID of the Merchant associated with the Dispute.
  • The unique merchant_id begins with MU.
created_at A timestamp of when the Merchant was created.
application_id
  • ID of the Application associated with the Dispute
  • The unique application_id begins with AP.
business_name The full legal business name saved for the Merchant.
doing_business_as The "doing business as" name saved in the Merchant resource (if applicable).
processor Name of the Dispute processor.
total_dispute_volume_past_30_days Total Dispute volume in the last 30 days.
total_dispute_volume_ratio_past_30_days Total Dispute volume / total processing volume in the last 30 days.
total_dispute_count_past_30_days The total number of Disputes processed over the last 30 days.
total_dispute_count_ratio_past_30_days The total number of Disputes that SUCCEEDED vs FAILED over the last 30 days.
total_dispute_volume_past_year Total Dispute volume over the past year.
total_dispute_volume_ratio_past_year Total Dispute volume / total processing volume over the last year.
total_dispute_count_past_year Total number of Disputes processed over the last year.
total_dispute_count_ratio_past_year The total number of Disputes processed over the last year.
line_1 The first address line saved in the Merchant resource.
line_2 The second address line saved in the Merchant resource.
city The city saved in the Merchant resource.
region The 2-letter State code saved in the Merchant resource.
postal_code The Postal code saved in the Merchant resource.
country The country saved in the Merchant resource.

Failed Funding Instructions

The Failed Funding Instructions report details every Funding Instruction, or payout, that was returned. Reasons Funding Instructions can return include a closed bank account, an incorrect bank account number, etc.

  • All timestamps are in UTC.
  • All currencies are in the local currency (USD).
  • The report is generated on weekdays Monday to Friday (excluding bank holidays).
Field Name Description
Return Date A timestamp that details the when the Funding Instructions were returned (in UTC using ISO8601 formatting).
Original Date A timestamp that details the when the Funding Instructions were originally processed (in UTC using ISO8601 formatting).
Attempted Funds Transfer Date A timestamp that details when the attempt to push funds to the relevant Payment Instrument happened (in UTC using ISO8601 formatting).
Merchant Name The legal name saved in the Merchant resource.
Sub Merchant Business Name Merchant's full legal business name (If INDIVIDUAL_SOLE_PROPRIETORSHIP, use the control owner's first name, Full legal last name and middle initial; max 120 characters)
Funding Sub Merchant ID ID of the Merchant associated with the returned Funding Instructions.
Funds Transfer Request ID Trace ID of the Funding Instructions.
Vantiv Payment ID Unique identifier for transaction assigned by payment processor A Worldpay-specific ID that represents the Funding Instructions.
Txn Type The type of transaction. Possible values include:
  • FIPC: Funding Instruction PayFac Credit
  • FIPD: Funding Instruction PayFac Debit
  • FIRC: Funding Instruction Reserve Credit
  • FIPD: Funding Instruction Reserve Debit
  • FISC: Funding Instruction Sub-merchant Credit
  • FISD: Funding Instruction Sub-merchant Debit
  • FIVC: Funding Instruction Vendor Credit
  • FIVD: Funding Instruction Vendor Debit
  • FICC: Funding Instruction Physical Check Credit
  • FICD: Funding Instruction Physical Check Debit
Funds Transfer Amount The total sum of the Transfer associated with the Funding Instructions.
Reason Code The Reason Code details the reason why the Funding Instructions failed.
Reason Message The Reason Message provides more detail regarding why the Funding Instructions failed.
Routing Number The routing number for the bank account where Funding Instructions were sent.
Account Number The account number for the bank account where Funding Instructions were sent.
Account Name The name of the bank account owner.

For a list of the Reason Codes that can cause Funding Instructions to return and the steps to resolve, see Resolving Funding Instruction Failures.