Trial Balance Reports in General Ledger

Trial Balances reports to review balances for our general ledger accounts for budges, actuals and encumbrances for any currency. The same segment security rules defined to restrict user to access to segment values in our accounting flexfield are extended to these reports.

Average Balance Trial Balance Report

Review your General Ledger standard and average account balances. We can print functional, foreign entered, or translated average balances.

This report provides a listing of standard and average balances for selected accounts based on an as of date we specify. In addition, the report displays period, quarter and year average to date balances. We can also request a additional information on this report by specifying balancing segments and account ranges.

Parameters- Currency, Currency Type, Reporting Date, Accounting From/TO

Budget Trial Balance Report

Review your general ledger budget account balances and activity for a specific currency. We can run this report for balances and activity entered in our functional currency and foreign currency or STAT or translated to a foreign currency.

General Ledger prints a page for each balancing segment value and list our accounts in ascending order by account segment value. General Ledger reports debits as positive amounts and credits as negative amounts.

Parameters- Budget Name, From TO/Period, Type , Currency

Detail Trial Balance Report

Review your general ledger actual account balances and activity in detail. We can run this report for balances and activity entered in your functional currency or STAT or translated to a foreign currency.

This report prints a line for each of your a accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity and ending balance for the period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.

Parameters - Pagebreak segment, Pagebreak segment low/high, Currency, Period, Amount Type.

Expanded Trial Balance Report

Review the beginning , ending and net balances as well as period activity for a set of accounts. View your actual balances and activity in your functional currency or translated to a foreign currency. You can also use this report to review your statistical account balances and activity.

The report prints a line for each account segment value and sorts them in ascending order. For each account segment value, the report prints the account description, beginning balances, period activity, ending activity, and ending balances for the period you request.

Parameters - Period Name, Account From /TO, Balancing Segment, Currency, Precision, Class level, Class and Sub class level, Class Sub Class and Group Level.

Foreign Currency Detail Trial Balance Report

Review actual general ledger account balances and activity entered in a foreign currency. The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for amounts and credits as negative amounts.

Parameters- Pagebreak segment, Pagebreak segment low/high, Currency, Period, Amount Type.

Foreign Currency Summary 1 Trial Balance Report

Review summarized general ledger balances and activity entered in a foreign currency. The report summarizes balances and activity by account segment value.

The report sorts the account segment values in ascending order. For each account segment value, the report prints the value, description, beginning balance, net of all debit or credit transactions, and ending balance for the period you request.

Parameters -Pagebreak segment, Pagebreak segment low/high, Period , Amount Type.

Summary1 Trial Balance Report

Review general ledger actual account balances and activity summarized by account segment value. You can run this report for balances and activity entered in your functional currency or STAT or translated to a foreign currency.

This report prints a line for each account segment value and lists them in ascending order. For each account segment value, the report prints the value , description, beginning balance, net of all debit or credit transactions and ending balance for the period your request.

Parameters- Pagebreak segment, Pagebreak segment low/high,Currency, Period, Amount Type.

Summary 2 Trial Balance Report

Review general ledger account balances and activity for combinations of account segment values with the values of a secondary segment you specify. You also specify a range of values for a third segment, which are used to control report page breaks.

General Ledger prints a line for each combination and sorts the secondary segment values from the lowest or highest. For each Secondary segment value, General Ledger sorts the account segment values from the lowest to the highest. Totals are provided for both your secondary segment and your pagebreak segment.

You can run print this report for actual , budget and encumbrance balances and activity in your functional currency, a foreign currency, or statistical units.

Parameters - Balance Type, PageBreak segment, PageBreak segment low/high, Secondary segment, Currency Type, Currency, Period Name, Budget Start Period Name, Amount Type.