> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lead.bank/llms.txt
> Use this file to discover all available pages before exploring further.

# Non-Posted Transactions Schema

<Info>
  Used when funds have settled to your FBO account but not yet posted to your end-user accounts.
</Info>

<Check>
  **Applicable to Balance Type = Deposit Only**\
  This file lists transactions where funds have settled to your FBO account but not yet posted to individual end-user accounts. Transactions remain in this file for N days until posted. Inaccurate data may risk proper account funding and disrupt program operations.
</Check>

<Check>
  For all optional fields where you do not plan to pass through data, please include the header and a null value.
</Check>

## IDs & Details

| **Field**             | **Description**                                                                                  | **Required** | **Data Type** |
| --------------------- | ------------------------------------------------------------------------------------------------ | ------------ | ------------- |
| transaction\_id       | The unique ID for the transaction.                                                               | Required     | string        |
| balance\_id           | Unique ID of the balance.                                                                        | Optional     | string        |
| settlement\_group\_id | If this transaction is net settled, a unique ID to group all transactions in the net settlement. | Optional     | string        |

## Transaction Information

| **Field**              | **Description**                                                                                                          | **Required**                                      | **Data Type**                                                                |
| :--------------------- | :----------------------------------------------------------------------------------------------------------------------- | :------------------------------------------------ | :--------------------------------------------------------------------------- |
| amount                 | Transaction amount                                                                                                       | Required                                          | number<br />[currency decimals](/file-integrations/file-delivery/currencies) |
| currency               | The [currency code](/file-integrations/file-delivery/currencies) for the transaction. 3 letter code, e.g. USD            | Required                                          | [ISO4217](https://www.iso.org/iso-4217-currency-codes.html)                  |
| amount\_in\_usd        | Transaction amount in USD. Only required if `currency` is not USD.                                                       | Required if the program can have non-USD balances | number decimal(M,2)                                                          |
| type                   | Transaction type.                                                                                                        | Required                                          | enum                                                                         |
| transfer\_type         | Type of transfer rail.                                                                                                   | Required                                          | enum                                                                         |
| reconciliation\_note   | Details to explain why the transaction is unsettled.                                                                     | Required                                          | string                                                                       |
| settlement\_date       | The settlement date of this transaction.                                                                                 | Required                                          | date<br />`YYYY-MM-DD`                                                       |
| transfer\_id           | The unique ID for the related transfer object, if applicable (e.g. the ACH ID or Internal Transfer ID generated by Lead) | Optional                                          | string                                                                       |
| statement\_description | The description on the customers statement for this transaction.                                                         | Optional                                          | string                                                                       |

## Other

| **Field**     | **Description**                                                                                     | **Required** | **Data Type**                                                                   |
| :------------ | :-------------------------------------------------------------------------------------------------- | :----------- | :------------------------------------------------------------------------------ |
| generated\_at | The day this file is generated. This should always be the date the file is sent to Lead Bank.       | Required     | datetime<br />[ISO8601](https://www.iso.org/iso-8601-date-and-time-format.html) |
| effective\_at | The timestamp of when the related object(s) were polled to collect the information for this record. | Required     | datetime<br />[ISO8601](https://www.iso.org/iso-8601-date-and-time-format.html) |