Report Catalog

Find the right report fast — field counts, key fields, enumerations, and the report-selection matrix.

Use this page to find the right report fast — field counts, key fields, enumeration values, and the task-to-report selection matrix. For full field-by-field detail, sample values, and reconciliation workflows, go to the Field Schema Reference.

All reports at a glance

#ReportFormatColumnsPrimary use case
1activity-detailStandard CSV14Transaction-level activity tracking
2activity-summaryStandard CSV14Merchant performance aggregation
3activity-exceptionsStandard CSV13Refund and chargeback tracking
4settlement-summaryStandard CSV23Settlement-batch reconciliation
5settlement-detailStandard CSV15Transaction-level settlement detail
6settlement-exceptionsStandard CSV10Failed-settlement tracking
7feesStandard CSV10Fee expense breakdown
8monthly-settlement-summaryStandard CSV11Monthly financial overview
9monthly-settlement-detailStandard CSV23Monthly batch-level detail
10dispute-detailMulti-section (RH/RD/RF)53Chargeback management
11disbursement-feeMulti-section (RH/RS/RD/RF)81Comprehensive disbursement reconciliation

Multi-section field counts

The two multi-section reports carry a header, one or more content sections, and a footer, each with its own record-type prefix (the prefix is a section identifier, not a counted field):

  • dispute-detail — RH (4 fields) + RD (46 fields) + RF (3 fields) = 53
  • disbursement-fee — RH (4 fields) + RS (14 fields) + RD (60 fields) + RF (3 fields) = 81

Key fields by report

The fields most reconciliation work keys on. Full field lists are in the Field Schema Reference.

ReportKey fields
activity-detailAmount, OrderState, TransactionType
activity-summaryTotalProcessedAmount, ProcessingFees, NetAmount
activity-exceptionsExceptionType, ExceptionReason, Amount
settlement-summarySettlementAmount, BatchId, SettlementDate
settlement-detailDepositAmount, FlexFactorFee, ConsumerAmount
settlement-exceptionsBatchAmount, PayoutStatus, ExceptionReason
feesFeeType, FeeAmount, OrderAmount
monthly-settlement-summaryTotalSettledAmount, TotalFees, NetSettlement
monthly-settlement-detailSame 23 fields as settlement-summary, filtered to one month
dispute-detailKind, Dispute Amount, Reason, Reply Before Date
disbursement-feeNetDisbursedAmount, Sales, Refunds, Disputes, NetFees

Field families

Fields recur across reports in a few consistent families.

Identity (all reports). Pid, Mid, ExternalMerchantIdentifier, Currency.

Transaction matching (detail reports). OrderId (FlexFactor internal ID), ExternalId (your order reference), EventTimestamp.

Amounts. Amount / ConsumerAmount (transaction value), TotalProcessedAmount (gross), SettlementAmount / DepositAmount / NetDisbursedAmount (net paid out).

Fees. ProcessingFees (aggregate), FlexFactorFee (per transaction), FeeType + FeeAmount (itemized in the fees report).

Reserve (settlement reports). ReserveAmount (held), ReserveReleaseAmount (released), ReserveUtilizationAmount (applied to cover losses).

Settlement identifiers. BatchId (batch UUID), CED (FlexFactor settlement tracking reference), TxnId (transaction ID from batch), SenderId / ReceiverId (financial account IDs, nullable).

Card data (PCI-compliant partial only). Bin (first 6 digits or N/A), Last4 (last 4 digits or N/A). Present in activity-detail, activity-exceptions, and settlement-detail.

Enumeration quick-reference

Complete definitions are in Data Formats & Enumerations.

EnumValues
TransactionTypeOrder · Return
OrderStatecompleted · refunded · disputed · voided · cancelled · processing · onhold · problem
ExceptionType (activity)refunded · disputed · voided
ExceptionType (settlement)FAILED · ERROR · REJECTED
FeeTypeFlexFee · FlexReturnFee · FlexChargebackFee
PayoutStatusSUCCESS · FAILED · ERROR · REJECTED · PENDING
DisputeStage / KindRDR · CHARGEBACK · PRE-DISPUTE · REVERSED · EARLY_WARNING · DISPUTE_NOTICE · FRAUD_NOTICE · UNMAPPED · ORDER_INSIGHT · CONSUMER_CLARITY
Payment Instrument Typecredit · debit · prepaid (processor-supplied; open set)

Critical calculations

The derived amounts each report expects to balance to. Full derivations and workflows are in the Reconciliation Guide.

activity-summary:
  NetAmount = TotalProcessedAmount - ProcessingFees

settlement-summary:
  SettlementAmount = TotalProcessedAmount - ProcessingFees
                     - ReturnsAmount - ChargebacksAmount
                     - ReserveAmount + ReserveReleaseAmount
                     - ReserveUtilizationAmount + Adjustments

settlement-detail:
  DepositAmount = ConsumerAmount - ConsumerFee - FlexFactorFee

monthly-settlement-summary:
  NetSettlement = TotalSettledAmount - TotalFees

disbursement-fee (RS section):
  NetDisbursedAmount = Sales + Refunds + Disputes + Other + NetFees
  (Refunds, Disputes, and NetFees are negative values)
📘

Sign conventions differ by report family — flat-report aggregates are positive magnitudes (subtract), detail rows and the RS section are signed (sum). See the Reconciliation Guide.

Report selection matrix

Match a reconciliation task to its primary report and the reports that support it.

Reconciliation taskPrimary reportSupporting report(s)
Daily transaction verificationactivity-detailsettlement-detail
Bank-deposit reconciliationsettlement-summarysettlement-detail
Fee expense accountingfeesactivity-summary
Refund trackingactivity-exceptionsactivity-detail
Chargeback managementdispute-detailactivity-exceptions
Monthly closemonthly-settlement-summarymonthly-settlement-detail
Merchant performance analysisactivity-summaryactivity-detail
Settlement-failure resolutionsettlement-exceptionssettlement-summary
Complete disbursement auditdisbursement-feesettlement-summary
Reserve-balance trackingsettlement-summarymonthly-settlement-detail

Did this page help you?