The Balance Sheet Report shows period-end balances for asset, liability, and equity accounts. It contains one row for each tenant, location, GL account, and fiscal period, with the cumulative balance as of the period end date.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier |
| gl_account_id | VARCHAR | GL account identifier |
| typical_balance_inferred | BOOLEAN | True when the account's GL type was missing or deleted, so the account was treated as debit-normal (a debit increases the balance). Treat the cumulative balance with caution for these accounts. |
| parent_gl_account_id | VARCHAR | Direct parent GL account identifier |
| parent1_gl_account_id | VARCHAR | Level-1 parent GL account identifier in the account hierarchy |
| parent_account_name | VARCHAR | Level-1 parent GL account name |
| parent_account_number | VARCHAR | Level-1 parent GL account number |
| operational_year | NUMBER(4,0) | Fiscal year from the 4-4-5 calendar |
| operational_period | NUMBER(2,0) | Fiscal period number (1-12) from the 4-4-5 calendar. Blank for the extra week at the end of a 53-week year, which has no period number. |
| period_end_date | DATE | Last calendar date of the fiscal period. This is the as-of date for the cumulative balance. |
| period_debit | NUMBER(38,4) | Sum of debit amounts posted to this account in this period |
| period_credit | NUMBER(38,4) | Sum of credit amounts posted to this account in this period |
| period_net_change | NUMBER(38,4) | Sign-adjusted net activity within the period. A positive value is an increase in the account balance: a debit for assets, or a credit for liabilities and equity. |
| cumulative_balance | NUMBER(38,4) | Running balance as of the period end date. This is the cumulative sum of the period net change over every period from the account's first posting to the current period, including periods that have no row. Includes beginning balance transactions. A positive value is a balance in the account's natural direction: debit for assets, and credit for liabilities and equity. |
| account_number | VARCHAR | GL account number |
| gl_account_name | VARCHAR | GL account name |
| typical_balance_is_credit | BOOLEAN | True if the account's typical balance is credit (Liabilities, Equity); false for debit-normal accounts (Assets) |
| is_statistical_account | BOOLEAN | True if this is a statistical (non-financial) account |