Old Reports -> General Ledger -> Chart of Accounts

Parent Previous Next

Bug Fixed

Sequence, Account Code, Description, Account Group 1, Account Group 2 and Type now working.

This report will list all your available General Ledger Accounts. The Account number, description and type of Account, as well as the Reporting Categories you have selected for each of those Accounts, will be displayed.

The Chart of Accounts is a list of all general ledger accounts created and edited in the Edit → Accounts menu. This Chart of Accounts or Account Listing is generated on the Accounts List Options screen. It will include Bank Accounts and Tax Accounts.

The General Ledger account master files needs to be selected on the Accounts lookup facility, Bank Accounts lookup facility and Tax Accounts lookup facility when you process transactions, documents, budgets and generate reports, etc.

Each account must be linked to an Account Group (created in the Setup → System parameters → Groups (Account Groups tab), which classifies or groups the accounts in the five Financial Categories (Income, Expenses, Assets, Capital and Liabilities). These Account Groups are linked to the Financial Categories in the Setup → System parameters → Financial Categories menu.

Print General Ledger Listing Reports (Chart of Accounts)

To Generate a List of Accounts:

1.Click on the Tools  → Old Reports → General Ledger → Chart of Accounts menu.

The Account List Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Sequence - You may select the selected accounts to be listed or displayed according to Account No., Account Description, Account Type, Account Group 1 or 2 (Reporting Group 1 or 2).

The description of Account Group 1 or 2 you have entered on the Reporting Group Name field on the Account Groups tab on the Setup → System parameters → Groups menu, may be reflected in this list.

b)From Account ... To - You may select all your accounts, a specific account, or a specified range of accounts, to be included in this report.

c)Show Sub-Accounts - Tick this option, if you wish to list all sub-accounts otherwise leave blank.

4.Click on the OK button to send the list to the medium selected in the Send Report to field.

Check that all the reporting groups are correct, and that all the types are correct, i.e. the income and expense account types should be "Inc/Exp", the Bank Account type should be "Bank Account", and the VAT/GST/Sales Tax sub-accounts type should be "Tax Account".

View General Ledger Listing Reports (Chart of Accounts)

An example of the Chart of Accounts is as follows:

This Chart of Accounts will be listed in five (5) columns:

1.Account - The account number or code is a one digit alpha character followed by three numeric digits. If sub-accounts have been created for an account, the sub-account number will be displayed as the last three digits. The first digit will indicate the account type and is as follows:

a)B - Accounts created in the Edit → Accounts menu as a Bank Account type. Each of the Bank accounts must be linked to its own Payments and Receipts batch or journal.

b)G - Accounts created in the Edit → Accounts menu as an Income or Expense Type or a Balance Sheet (Assets, Capital and Liabilities) account.

c)T - Accounts created in the Edit → Accounts menu as a Tax Account type. These would be the tax codes containing the percentages, which applies to each Tax code for Output and Input VAT/GST/Sales Tax.

2.Description - This is the account description or name of the account or sub-account.

3.Account Group 1 - This is the Account Group 1 to which an Account is linked when the Account / Sub-account was created.

4.Account Group 2 - This is the Account Group 2 to which an Account is linked when the Account / Sub-account was created.

5.Type - The following types will be displayed:

a)Inc / Exp - If a General Ledger Account or sub-account is created as an Income / Expense Account, the account balances will reflect on the Income Statement and will be used to calculate the net Profit or Net Loss.

b)Blank (No Type) - If no type is displayed the account balances, it will be reported on the Balance Sheet.

c)Bank Account - These accounts are created in the Edit → Accounts menu as a Bank Account type.

d)Tax Account - These accounts are created in the Edit → Accounts menu as a Tax Account type.

e)Retained Income (Retained Earnings) - This account type will be used to store the retained income or earnings and the net Profit or net Loss will be transferred to this account when the Financial Year is closed.

f)Debtors Control - This is the control account for the Debtors Ledger. All the transactions and balances for accounts created and edited in the Edit → Debtor menu, will be displayed as a total in the control account.

g)Creditors Control - This is the control account for the Creditors Ledger. All the transactions and balances for accounts created and edited in the Edit → Creditor menu, will be displayed as a total in the control account.

If you have converted a Set of Books from a previous version of TurboCASH or Pastel version 5.2, your Chart of Accounts will be automatically converted.

If you have created a new Set of Books, and you have selected one of the pre-installed templates, you will already have a basic Chart of Accounts which you can use.

It is recommended that you print the Chart of Accounts on the Reports → General Ledger → Chart of Accounts menu, and check that all the required accounts are available for your requirements.

You need to identify the additional Accounts you wish to add or even to create Sub-accounts for specific Accounts. You may also need to change the descriptions for some Accounts, and may even wish to delete some Accounts which you will not use at all.


Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle