Chapter 2: Report Structure
Prerequisites: Chapter 1: Getting Started
2.1 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 |
2.2 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 SYSTEMThe Three Levels of Identification
Level | ID Field | What it identifies | Use it to... |
|---|---|---|---|
1 |
| A bank deposit/withdrawal | Match to bank statement |
2 |
| A single transaction or event | Track individual items, contact support |
3 |
| Your internal reference | Match to your 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?" |
2.3 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 / Corrections