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 Sections
Every DFR contains exactly four sections, identified by a prefix in the first column:
| Section | Name | Row Count | What 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 Connect
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 SYSTEMTo see a full example of using RS and RD together to reconcile a deposit, see Reconciliation Walkthrough.
The Three Levels of Identification
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.
| Level | ID Field | What it identifies | Use it to... |
|---|---|---|---|
1 |
| A bank deposit/withdrawal | Match deposits and withdrawals to your bank statement. |
2 |
| A single transaction or event | Track and debug individual transactions or events. |
3 |
| Your internal reference | Tie DFR records back to your internal order system. |
Linking Fields for Tracing
| Field | What it links | Example use case |
|---|---|---|
| Refund/dispute → original sale | "Which sale was refunded?" |
| Chargeback → reversal | "Did we win this dispute?" |
Sign Convention
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 / CorrectionsNext: Field Reference