T-Ledger analyzer

The T-Ledger analyzer allows you to generate, print or export eleven (11) different report types of your data. You may view, print and export your Budget, Trial balance, Income statement and Balance sheet in various formats. In addition to this, you may also view and export the data in column balances (balances per period) for the following:

•General ledger - List Balances for the accounts in the Trial balance.

You may double-click on any account in the T-Ledger analyzer to view the Transactions in the T-Account viewer.

The export feature of the T-Account analyzer allows you to create export files of any view of the data to the Comma Separated Value (*.csv) file format. You may then use your favorite Spreadsheet program (e.g. OpenOfficeCalc / LibreOffice Calc or Microsoft Excel, etc.) to analyze, sort and filter the data.

You may also build charts in your Spreadsheet program and use it to make powerful presentations in your presentation program (e.g. OpenOfficeImpress, Microsoft Powerpoint, etc.).

d)Include zero balances - If this field is selected (ticked), it will list only those accounts with balances within the selected periods. If this field is not selected, it will list all accounts including those with zero (null) balances.

e)View Customer /Vendor - Do not select (tick) if you only need to view only the control accounts of the Customer Vendor accounts. If this field is selected (ticked), it will list all the individual accounts in the following ledgers:

i)Customer's ledger - all customer accounts.

ii)Vendor's ledger - all vendor accounts.

An example, in the trial balance and balance sheet, is as follows:

3.(Not applicable to the Income statement report type).

a)Include opening balances - If you select (tick) this field, you may include the opening balances (of the previous financial year). This will display the Opening balances only option. (Not applicable to the Income statement report type).

b)Opening balances only - If the Include opening balances option is selected, you may select (tick) this option to exclude transaction totals of this financial year's periods. Only the opening account balances (for the previous financial year) will then be listed. (Not applicable to the Income statement and Column balances report types).

4.Once finished, selecting your options, click on the Report button to generate the report. A "Processing" screen may be displayed.

The T-Account viewer does not include unposted journals and documents. It will also not be updated automatically when journals or documents are updated (posted) to the ledger.

5.Once the T-Ledger analyzer is updated, you may view, analyze or select an account to view the transactions in the T-Account viewer. If necessary, you may export it to the Comma Separated Value (*.csv) file format.

Report Type Views

The Trial balance and the Balance sheet report types allows you to select the Viewer Customer /Vendor option. This will list all individual customer for the customer's control account and vendor account balances for the vendor's control account.

Export to CSV Files

The export feature of the T-Account analyzer allows you to create export files of any view of the data to the Comma Separated Value (*.csv) file format. You may then use your favorite Spreadsheet program (e.g. OpenOfficeCalc or Microsoft Excel, etc.) to analyze, sort and filter the data.

You may also build charts in your Spreadsheet program and use it to make powerful presentations in your presentation program (e.g. OpenOfficeImpress, Microsoft Powerpoint, etc.).