The ability to produce comprehensive and complex reports is an essential part of any financial system. SunSystems has powerful and flexible reporting tools.
TB – Trial Balance report is a fundamental accounting report. Running this report you can only select transactions by accounting period or transaction date. FA – Financial Analysis report gives you more control over the layout of your report and transaction selection; you can create your own trial balance report using this function. This report can produce up to 12 columns with different accounting data: Opening Balance, Period Movements and so on. Up to three sort levels are available to determine the sequencing and totaling of the report data.
FT – Financial Tables report is more complex reporting tool than FA – Financial Analysis. Financial Table report can be compared to a matrix where you can control both the information in the rows and columns. You can create different FTC – Financial Table Columns and FTR – Financial Table Rows formats and combine them in different ways in FTF – Financial Table Formats. Financial Table reports can be produced from FT – Financial Tables function.

Function Path: ”Financials” -> “Financial Reports”
Function Code: TB – Trial Balance

Trial Balance is a fundamental audit report. You can use Trial Balance (TB) to produce a standard trial balance report. You can choose to report on a range of accounting periods or entry dates. The trial balance report shows one line for each account which reports the following values for the period of the report: the opening balance, the total debits, the total credits, the net movement for the period, and the closing balance.
A trial balance should be printed at the end of each period. It is a fundamental audit report. You can use Trial Balance (TB) to produce a standard trial balance report. You can choose to report on a range of accounting periods or entry dates. The trial balance report shows one line for each account which reports the following values for the period of the report: the opening balance, the total debits, the total credits, the net movement for the period, and the closing balance.

If the previous year's net profit and loss is not equal to zero, the balancing figure is printed immediately prior to the report totals.

You can produce subtotals, based on the setting of Trial Balance Subtotal - Position of Character field in Ledger Setup (LS).

The trial balance is produced using the SunSystems Reporting functionality. This means that you can design your own trial balance report, if required.
You can produce subtotals, based on the setting of “Options” -> “Trial Balance Subtotal” –> “Position of Character” fielding LS – Ledger Setup: Click here to see the screenshot 

Financial Analysis (FA) is used to run a financial analysis report. The report is identified by a layout code which must have been defined using Financial Analysis Layouts Setup (FAL).

If the report uses the optional ledger balances that can be maintained by the system, you are offered the option to update the balances when you produce the report.
If you have entered a column code on the financial analysis layout that requires budget information, SunSystems looks for the relevant budget ledger. If it cannot find it, the budget amounts are shown as zero on the report.

If you have selected consolidation in Financial Analysis Layouts Setup, the first time you run the report using Financial Analysis you are prompted to enter up to thirty business unit codes for consolidation in the report. You can subsequently amend the business unit codes selected, if required.