Trial Balance Report

The Trial Balance report provides a summary of all general ledger accounts and their debit and credit balances for the selected date. It is used to verify that total debits equal total credits, helping ensure the accuracy and integrity of financial records before preparing financial statements.

Perform the following steps to generate the report:

Navigate to Reports Dynamic Reports Accounting Trial Balance.

Refer to the following table and fill in the fields.

Field

Description

Report Name

Trial Balance.

Date

The start date for report generation. This is a mandatory field that displays the current property date by default. Users can select any date in the past up to the current property date. Future dates cannot be selected.

Click Run to generate the report.

Click Save to save the report under User Favorites section.

Sample Report

Report Fields

This report displays the following fields:

Field

Description

Group

The categories in which records are grouped. For example, Balance Brought Forward, Transactions, Transaction Total Today, Transfers, Grand Total Today, Transfers, Grand Total Today, Balance Carried Forward, Hotel Balance and so on. This column can be sorted.

Transaction Type

The specific type of financial transaction. For example, Room Revenue, Non Room Revenue, Payment, Refund and so on. This column can be filtered and sorted.

Ledger Name

The name of the ledger account impacted. This column can be sorted.

Item Name

The name of the specific item or service. This column can be filtered and sorted.

Item Code

The accounting code associated with the item. This column can be sorted.

Net Amount

The transaction amount excluding taxes.

Tax Amount

The tax amount associated with the transaction amount.

Gross Amount

The total transaction amount calculated as follows: Net + Tax.

Balance Yesterday

The closing balance of the ledger from the previous day.

Balance Today

The closing balance of the ledger for the current reported date.