---
updatedAt: 2026-03-18T15:16:18.000Z
---

Fetch the complete documentation index at: https://developers.pismo.io/pismo-docs/llms.txt. Use this file to discover all available pages before exploring further. Append .md to any documentation page URL to get its markdown version.

# Transactions balance report files

The Transactions balance report contains the transactions balances from the previous day. The files for this job are saved in your designated cloud storage container in the `reports/transactions_balance/` subfolder. For more information, refer to [Scheduled reports](https://developers.pismo.io/pismo-docs/docs/scheduled-reports).

* Report frequency: Once daily
* Reporting period: Previous day
* Update type: Incremental

The following table lists the Transactions balance report fields.

> 📘
>
> Decimal values are rounded to the hundredths.

<HTMLBlock>
  {`
  <table>
      <thead>
          <tr>
              <th>Field</th>
              <th>Data type</th>
              <th>Description</th>
          </tr>
      </thead>
      <tbody>
          <tr>
              <td>Org_ID</td>
              <td>string</td>
              <td>Organization ID</td>
          </tr>
          <tr>
              <td>RefDate</td>
              <td>timestampdate</td>
              <td>File creation date</td>
          </tr>
          <tr>
              <td>Account_ID</td>
              <td>int</td>
              <td>Account ID</td>
          </tr>
          <tr>
              <td>Statement_ID</td>
              <td>int</td>
              <td>Statement ID</td>
          </tr>
          <tr>
              <td>Balance</td>
              <td>double</td>
              <td>Invoice balance</td>
          </tr>
          <tr>
              <td>CicleClosingDate</td>
              <td>date</td>
              <td>Cycle closing date</td>
          </tr>
          <tr>
              <td>DueDate</td>
              <td>date</td>
              <td>Due date</td>
          </tr>
          <tr>
              <td>DueDays</td>
              <td>int</td>
              <td>Number of days the account has been in arrears</td>
          </tr>
          <tr>
              <td>Type</td>
              <td>string</td>
            <td>Balance record type: <br>- <code>ROTATIVO</code> (Revolving) <br>- <code>CREDOR</code> (Creditor)<br>- <code>CORRENTE</code> (Current)<br>- <code>CORTADA</code> (Cut)<br>- <code>FUTURA</code> (Future)</td>
          </tr>
          <tr>
              <td>Program_ID</td>
              <td>int</td>
              <td>Program ID</td>
          </tr>
          <tr>
              <td>ProgramName</td>
              <td>string</td>
              <td>Program name</td>
          </tr>
      </tbody>
  </table>
  `}
</HTMLBlock>