T-Ledger Analyser

Previous Next

The T-Ledger Analyser allows you to generate eleven (11) different report types of your data. You may view, print and export your Budget, Trial Balance, Income / Expenses (Income Statement) and Balance (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) 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 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.Click on the T-Ledger Analyser button on the Sidebar.

Alt + R + G + E.

The T-Ledger Analyser screen is displayed:

2.Select the following options:

a)Reports 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 / Expenses (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)Which Year - Select Last Year or This Year option. (Not applicable to the Budget and Column Balances report type.

c)From ... To - Click on th Lookup icons and select the period from and to (until which) you need to include in the T-Ledger Analyser. (Not applicable to the Column Balances report types).

d)Group - Select None (will list in account code sequence), Reporting Group 1 or Reporting Group 2. (Not applicable to the Column Balances report types).

e)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 tose with zero (nill) balances.

f)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) accounts

ii)Creditor's Ledger - all creditor (supplier) accounts.

3.(Not applicable to the Income / Expenses report type).

a)Include Opening Balances - If you select (tick) this field, you may include the opening balances (of the previous fianacial year). This will display the Opening Balances Only option. (Not applicable to the Income / Expenses 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 / Expenses and Column Balances report types).

4.Once finished, selecting your options, click on the Report button to generate the report.

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) 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 Microsift 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-Leger 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.).


To Open the CSV Ledger Export Report:

You may also open the exported file using Windows Explorer (or your Filer Browser program) with another program.

If the file is not launched automatically in a spreadsheet program; or the incorrect program, you may change this. To do this; you need to:

Select the saved *.csv file.

Right-click on it and select the Open with option on your system's context menu.

If your program is not listed as one of the Recommended programs on your system's context menu, select the Choose Default Program... option. On this screen, select your default program (e.g. OpenOffice Calc, Microsoft Excel, etc.). You may need to click on the Browse button to do this.

Make sure that the Always use the selected program to open this kind of file option is selected (ticked), and click on the OK button.

1.The Text Import [Your File name] screen will be displayed.

The first 4 rows consists of the report parameters. This is your selection on the T-Ledger Analyser before clicking on the Report and Export buttons.

2.Select the Separator options as “Standard by” as well as select (tick) the Tab and Comma options; if necessary.

3.Click on the OK button. The data will be imported into a comma separated file (*.csv) file.

4.Once the data is displayed in your spreadsheet, you may use the features to create charts from the data. Using the Chart Wizard (as in this example of OpenOffice) you may create a chart in basically 4 easy steps (i.e. Chart Type, Data Range, Data Series and Chart elements).


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