T-Ledger analyser

Reports menu ››
Parent Previous Next

The T-Ledger analyser 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.

oColumn balances - This will list the net balances (debits minus credits).

oColumn balances - Debit / Credit - This will list the debit and the credit balances separately.

Debtor's ledger - List balances for the individual debtor (customer / client) accounts.

oColumn balances - Debtors - This will list the net balances (debits minus credits).

oColumn balances - Debtors - Debit / Credit - This will list the debit and the credit balances separately.

Creditor's ledger - List balances for the individual creditor (supplier) accounts.

oColumn balances - Creditors - This will list the net balances (debits minus credits).

oColumn balances - Creditors - Debit / Credit - This will list the debit and the credit balances separately.

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

The export feature of the T-Account Analyser 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 favourite Spreadsheet program (e.g. OpenOfficeCalc / LibreOffice Calc or Microsoft Excel, etc.) to analyse, 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.).

To access the T-Ledger analyser:

1.On the Reports ribbon, select T-Ledger analyser 1 or T-Ledger analyser 2. The T-Ledger analyser screen is displayed:

2.Select the following options:

a)Report type - These are the eleven (11) standard views of the T-Ledger analyser.

i)Trial balance (All accounts as per the Chart of Accounts)

ii)Income statement

iii)Balance sheet

iv)Standard column balances

v)Column balances

vi)Budget vs actual

vii)This year vs last year

viii)Column balances - Debtors

ix)Column balances - Creditors

x)Column balances - Debit / Credit

xi)Column balances - Debtors - Debit / Credit

xii)Column balances - Creditors - Debit / Credit

xiii)Budget - This will list the Budget figures for This Year or Last Year as entered.  

b)Select a period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates to include transactions in the report.

c)Group - Select None (will list in account code sequence),Reporting group  1 orReporting group  2. (Not applicable to the Column balances report types).

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 Debtor / Creditor - Do not select (tick) if you only need to view only the control accounts of the Debtor Creditor accounts. If this field is selected (ticked), it will list all the individual accounts in the following ledgers:

i)Debtor's ledger - all debtor (customer / client) accounts.

ii)Creditor's ledger - all creditor (supplier) 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 batches and documents. It will also not be updated automatically when batches or documents are updated (posted) to the ledger.

5.Once the T-Ledger analyser is updated, you may view, analyse 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 Debtor / Creditor option. This will list all individual debtor (customer / client) for the debtor's control account and creditor (supplier) account balances for the creditor's control account.


Export to CSV Files

The export feature of the T-Account Analyser 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 favourite Spreadsheet program (e.g. OpenOfficeCalc or Microsoft Excel, etc.) to analyse, 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.).

To create a Ledger Export report:

1.Once finished, selecting your options, click on the Report button to update the T-Ledger analyser screen.

2.You may then click on the Export button. This will launch the Save as screen.

3.Select the folder in which you wish to save the file.

4.The default file name will be ExportLedger. Overtype this with your own, if necessary. If you do not do this, you may replace existing (previously exported) files.

5.Select the file type Comma Separated Value (*.csv).

6.Click on the Save button. This will automatically open (launch) the file in the program associated with the Comma Separated Value file type (e.g. OpenOfficeCalc or Microsoft Excel, etc.).

Created with the Personal Edition of HelpNDoc: Free help authoring environment