---
updatedAt: 2026-03-18T15:16:11.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.

# Account balances report files

The account balances report contains the account balances from the previous day. The files for this job are saved in your designated cloud storage container in the `/reports/accounts_balances/` 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 account balances report fields.

<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>date</td>
              <td>Date the report file was generated</td>
          </tr>
          <tr>
              <td>Account_ID</td>
              <td>int</td>
              <td>Account ID</td>
          </tr>
          <tr>
              <td>Program_ID</td>
              <td>int</td>
              <td>Program ID</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 type:<br>
                <ul>
                  <li><code>RotativoEmDia</code> (RevolvingOnDay): Includes all balances from transactions that are still within the allowed payment period, even if the statement due date has passed. It reflects transactions up to the current date.
                  <li><code>RotativoAtraso</code> (RevolvingDelay): Includes all balances from transactions that are overdue and have not been paid.
                  <li><code>Corrente</code> (Current): These are balances from transactions included in the open statement (current cycle) and also those mapped to future statements (future cycles).
                  <li><code>Futuro</code> (Future): Includes balances from transactions that will be charged in future statements, such as installment purchases.
  					</td>
          </tr>
          <tr>
              <td>AccountStatus</td>
              <td>string</td>
              <td>Account status</td>
          </tr>
          <tr>
              <td>Balance</td>
              <td>double</td>
              <td>Balance summarized according to Type</td>
          </tr>
      </tbody>
  </table>
  `}
</HTMLBlock>