Report Structure

This guide explains how the Disbursement & Fee Report (DFR) file is organized, how the four sections relate to each other, and how identifiers connect your bank statement to individual transactions. Use this reference when you need to see how the DFR file fits together end to end.

Prerequisites: Getting Started

The Four SectionsAnchorIcon

Every DFR contains exactly four sections, identified by a prefix in the first column:

SectionNameRow CountWhat it contains

RH

Report Header

1

File metadata: report name, status, generation timestamp

RS

Report Summary

1 per bank transfer

Summary for each Transfer ID. Start here for reconciliation.

RD

Report Details

1 per transaction

Line-item breakdown of every sale, refund, dispute, fee, adjustment

RF

Report Footer

1

Record count and file totals for validation

How Records ConnectAnchorIcon

The DFR has a hierarchical structure that enables precise reconciliation:

BANK STATEMENT
       │
       │ Match by Transfer ID
       ▼
┌─────────────────────────────────────────────────────────────┐
│  RS (Report Summary)                                        │
│  • One row per Transfer ID                                  │
│  • Net Disbursed Amount = what hits your bank               │
│  • Sales, Refunds, Disputes, Fees summarized                │
└─────────────────────────────────────────────────────────────┘
       │
       │ Filter RD by Transfer ID
       ▼
┌─────────────────────────────────────────────────────────────┐
│  RD (Report Details)                                        │
│  • One row per transaction/event                            │
│  • Record ID = unique transaction identifier                │
│  • Order ID = your internal reference                       │
│  • Original Record ID = links refunds/disputes to sales     │
└─────────────────────────────────────────────────────────────┘
       │
       │ Match by Order ID
       ▼
YOUR INTERNAL SYSTEM

To see a full example of using RS and RD together to reconcile a deposit, see Reconciliation Walkthrough.

The Three Levels of IdentificationAnchorIcon

This table outlines the three ID levels you need to reconcile between your bank statement, the DFR, and your own systems. Use this section to match a deposit, trace individual records, and tie everything back to your internal orders.

LevelID FieldWhat it identifiesUse it to...

1

Transfer ID

A bank deposit/withdrawal

Match deposits and withdrawals to your bank statement.

2

Record ID

A single transaction or event

Track and debug individual transactions or events.

3

Order ID

Your internal reference

Tie DFR records back to your internal order system.

Linking Fields for TracingAnchorIcon

FieldWhat it linksExample use case

Original Record ID

Refund/dispute → original sale

"Which sale was refunded?"

Dispute ID

Chargeback → reversal

"Did we win this dispute?"

Sign ConventionAnchorIcon

Understanding the sign convention is critical for reconciliation:

POSITIVE (+) ──────────────────────────► Money TO you
   │
   ├── Sales
   ├── Chargeback Reversals (you won)
   ├── Reserve Releases
   └── Credits / Corrections

NEGATIVE (-) ──────────────────────────► Money FROM you
   │
   ├── Refunds
   ├── Chargebacks (you lost)
   ├── Fees
   ├── Reserve Holds
   └── Debits / Corrections

Next: Field Reference