Unit 8 – Accounting Reports 201

Given here is a screenshot of Account Ledger in the T Format.

Figure 8.6 Account Ledger – T Format

Merged Accounts

On selecting the Merged Accounts option, a Merged Ledger message box appears. In the message box, there are two options. The options are:

Account Group – Select this option if you want to view report for a particular Account Group.

Selected Account – Select this option if you want to view report for selected accounts.

On selecting any of the above option, a Report Options window appears. Given here are the data fields that appear in the Report Options window.

Account Group Name – Select the Account Group for which you want to view the report.

Starting Date – Enter the starting date from which transactions are to be displayed in the report.

Ending Date – Enter the ending up to which the transactions are to be displayed in the report.

Account to be Shown by – Select from the list whether the Account Name, Alias or Print Name is to be displayed in the report.

Show Actual Account Name – Specify ‘Y’ in this data field if you want to view account name also in the report. On specifying ‘Y’ in this data field, an Account Name column, displaying name of the account appears in the report.

After entering required data in the data fields, click the Ok button to view the report. On clicking the Ok button, a Merged Account Ledger report appears. Given here is a screenshot of Merged Account Ledger window.

202

Figure 8.7 Merged Account Ledger

Cash / Bank Book

Cash / Bank Book report displays the cash / bank transactions of the organisation sequentially for a specified date range. This report helps us to know the cash / bank balance with the organisation at any given point of time. On selecting this option, following two options appear:

Single Column

Multiple Column

In this section, we will discuss only the Single column report. Multiple Column report will be covered in Advanced Courseware.

Single Column

Single column report displays records for either of the account, Cash or Bank. On selecting this option, a Report Options window appears. Enter the required data in the Report Options window and click the Ok button. On clicking the Ok button, a Cash / Bank window appears displaying all the transactions involving the account selected in the Report Options window.

Account Registers (Standard)

In the Account Registers (Standard) option, you can view all the account registers such as Sale, Purchase, Payment and so on in the standard format. On selecting this option, a list of registers is displayed. Various registers in the list are:

Sales Register

Purchase Register

Sales Return Register

Purchase Return Register

Payment Register

Receipt Register

Journal Register

Contra Register

Debit Note Register

Credit Note Register