# ODL statements

The On-Demand Liquidity (ODL) Statement feature in the Ripple Payments UI provides pre-generated reports for RippleNet payments that utilize On-Demand Liquidity.

Note
ODL Statement reports do not include data on fiat payments.

To retrieve data on fiat payments, apply filters to the Payments list view and click the **Download** button ![Download Button](/assets/download-button.51099c5f8d0508b4c2f5dfa593f403088497d38258fd16f87ea66feb74778f6d.6ae46ae6.png).

## Report types

The following ODL report types are available:

- [Payment operations report](#payment-operations-report)
- [Failure conversion & SSA report](#failure-conversion-and-ssa-report)
- [Reconciliation report](#reconciliation-report)


### Payment operations report

The Payment operations report provides basic payment data, including but not limited to:

- Payment ID
- Amount
- Currency
- Account info
- Payment state
- Timestamp


The Payment operations report lists one payment per line, but it does not provide the transaction data within payments. To view the complete list of fields and field descriptions, see the [Payment operations](#payment-operations-report-data-fields) report data fields.

### Failure conversion & SSA report

The Failure conversion & SSA report provides data for failed payments whose funds were transferred to the Sender Segregated Account (SSA). This type of report is only visible in case a failure conversion has happened.

To view the complete list of fields and field descriptions for the **Failure conversion & SSA report**, see the [Failure conversion & SSA](#failure-conversion--ssa-report-data-fields) report data fields.

### Reconciliation report

The Reconciliation report provides all basic payment data, as well as trade and liquidation data. The additional fields are useful for reconciling and thoroughly investigating payments. The Reconciliation report displays all transactions that may take place within a payment. A single payment with multiple transactions appears in multiple lines, one line per transaction. Each line includes data that has occurred during the transaction, and all subordinate transactions share the same **Payment ID**.

To view the complete list of fields and field descriptions for the **Reconciliation report**, see the [Reconciliation](#reconciliation-report-data-fields) report data fields.

## ODL Statement form

To view the ODL Statement form, go to the Payments screen and click **ODL Statement**.

![ODL Statement button](/assets/odl-statement-button.88079878c22995ff181a1038b0a8bbbc68b5794cac588c79f37c0a3907fee8d6.6ae46ae6.png)

The ODL Statement form displays options for the available reports.

![Report download](/assets/report-download-odl.31ca414f67aa0c0546ee49a86fa49f7f96d81a77a7e76ffde985f6ce5e541f5b.00aefa6e.png)

### Date range (UTC)

In the Date Range (UTC) section of the ODL Statement dialog, you have three options for defining the scope of a report:

| Date range | Description | Example |
|  --- | --- | --- |
| **Month before last** | Retrieves all ODL payment data from the month preceding the last month. | If the current month is October 2022, this retrieves payment data for August 2022. |
| **Last month** | Retrieves all ODL payment data from the month preceding the current month. | If the current month is October 2022, this retrieves payment data for September 2022. |
| **Current month** | Retrieves ODL payment data from the first day of the current month up to 00:00 AM of the current day. | If today's date is October 10, 2022, this retrieves ODL payment data from October 1, 2022 to 00:00 AM on October 10, 2022. |


### Format

There are two format options for ODL Statement reports:

- **CSV (Comma-Separated Values)**: A CSV file is a text file that uses a comma to delimit values. Each line of text corresponds to a unique record.
- **JSON (Javascript Object Notation)**: JSON is a file format that uses human-readable text to store and transmit data objects consisting of attribute-value pairs and arrays.


### Report Type

View descriptions for the available [Report types](#report-types).

- Payment operations report
- Failure conversion & SSA report
- Reconciliation report


## Report data fields

These data fields describe the CSV and JSON content when downloaded from the [ODL Statement form](#odl-statement-form).

### Payment operations report data fields

These are the data fields for the Payment operations report. Use this report for high-level payment investigation and reporting.

### Failure conversion & SSA report data fields

These are the data fields for the Failure conversion & SSA report. Use this for detailed state-by-state investigation.

### Reconciliation report data fields

These are the data fields for the Reconciliation report. Use this for reconciliation and detailed state-by-state investigation.