Consolidated Trial Balance

Overview

Each Agency prepared Trial Balance Monthly/Quarterly/Anually basis for the statutory requirement to send COA and for preparation of financial statement.

Navigation

General Ledger ► Reports ► Philippines Reports ► Consolidated Trial Balance

Consolidated Trial Balance Report Screen Fields

Fields

Description

Fiscal Year

Mandatory-Allow to select fiscal year.

Fiscal Period

Mandatory - Allow to select fiscal period from the drop down.

Organization

Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down)

Multi-Fund Concept

Optional - Allow to select one fund or mutiple fund (From-To).

Group By

Optional - Allow to select group by fund.

Is Opening Balance Included

Mandatory - Allow to select include opening balance or not.

Show Opening Balance Only

Optional - Select this flag to show only the balance in the beginning of the year.

Object

Mandatory - Allow to select concept of sub-object code.

Trial Balance Report Type

Mandatory - Allow to select period from the drop down. It is a close domain period for the month or Up to the month.

Comment

Optional.  This will be filled up after the report is printed.