---
title: "Trial Balance Report"
slug: "trial-balance-report"
status: "new"
updated: 2026-10-27T22:06:02Z
published: 2026-10-27T22:54:23Z
canonical: "docs.restaurant365.com/trial-balance-report"
---

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

# Trial Balance Report

The Trial Balance Report shows general ledger (GL) posting detail for the trial balance. It contains one row for each posting line, with the GL account, location, legal entity, and fiscal period. Totals of debits and credits give the beginning balance, period activity, and ending balance.

## Column reference

| Column | Type | Description |
| --- | --- | --- |
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| legal_entity_id | VARCHAR | Legal entity identifier |
| legal_entity_name | VARCHAR | Legal entity name |
| location_id | VARCHAR | Location identifier |
| location_name | VARCHAR | Name of the location |
| transaction_date | DATE | GL posting date |
| operational_period | NUMBER(2,0) | Fiscal period within the operational year (1-12, 4-4-5 calendar) |
| operational_quarter | NUMBER(9,0) | Fiscal quarter within the operational year (1-4) |
| operational_year | NUMBER(4,0) | Fiscal year based on the 4-4-5 calendar |
| transaction_id | VARCHAR | Transaction header identifier |
| transaction_detail_id | VARCHAR | Identifier of the transaction line |
| transaction_type | NUMBER(38,0) | Numeric transaction type code |
| transaction_type_name | VARCHAR | Human-readable transaction type label |
| transaction_number | VARCHAR | Document or reference number |
| comment | VARCHAR | Header-level transaction comment |
| line_comment | VARCHAR | Line-level transaction detail comment |
| approval_status | NUMBER(38,0) | Approval status (1=Unapproved, 2=Approved) |
| is_beginning_balance | BOOLEAN | True when this line represents an opening balance entry rather than an activity transaction |
| posting_role | VARCHAR(19) | Posting role: PRIMARY, OFFSET, INTERCOMPANY_DEBIT, or INTERCOMPANY_CREDIT |
| gl_account_id | VARCHAR | GL account identifier for this posting line |
| gl_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 |
| is_financial_report | BOOLEAN | True for profit and loss (income statement) accounts, and false for balance sheet accounts. |
| is_retained_earnings | BOOLEAN | True if this is the retained earnings account. Prior-year profit and loss balances roll into this account. |
| is_statistical_account | BOOLEAN | True if this is a statistical (non-financial) account |
| parent_gl_account_id | VARCHAR | Direct parent GL account identifier |
| parent1_gl_account_id | VARCHAR | Level-1 parent GL account identifier |
| parent_account_name | VARCHAR | Level-1 parent GL account name |
| parent_account_number | VARCHAR | Level-1 parent GL account number |
| debit_amount | NUMBER(38,4) | Debit amount for this posting line |
| credit_amount | NUMBER(38,4) | Credit amount for this posting line |