Report on Account Ledger

Report on account ledger

The account ledger is a statement of transactions for each of the account codes. This page allows you to print a detail account ledger based on the account codes. Tell me more.

Select the “Report on Account Ledger” link under “Reports – Book keeping”.

The “Account Ledger” page appears.

Enter the following field in the “Print Criteria” group box:

Book Type

Use the drop-down list box to select the type of finance book for which you want to view the account ledger. All the types of finance books that have been deployed in the login organization unit will be available for selection in the alphabetical order. You can select from “Consolidation Finance Book”, “Main Finance Book” or “Posting Finance Book”.

Note: If tax books have been deployed in the login organization unit, the types of the tax book will also be available for selection. It could be “Posting Tax Book”, “Main Tax Book” or “Consolidation Tax Book”.

Business Unit	Use the drop-down list box to select the business unit for which you want to view the account ledger. All the business units that have been mapped to organization units in which a “Report – Book Keeping” and a “Finance Book Processing” business component has been deployed will be available for selection in the ascending order.
Finance Book	Use the drop-down list box to select the finance book for which you want to view the account ledger. All the finance books for the selected book type and/or business unit combination are available for selection in the alphabetical order. The finance books available are also determined by the mapping of “Report – Book Keeping” to a “Finance Book Processing” business component.
Document Type	Use the drop-down list box to select the type of document, which you want to view the account ledger. You can select from “Sub Ledger Voucher” and “GL Voucher”. The system displays the first value by default on launch of the page.
Layout Heading	Use the drop-down list box to select the layout heading from which you want to view the account ledger. All the account codes mapped to the Layout heading will be selected for generating account ledger. The system displays blank by default on launch of the page.
Currency	Use the drop-down list box to select the currency in which you want to view the account ledger. You can select from “Base Currency”, “Parallel Base Currency” and the “Account Currency”. The system displays “Base Currency” by default on launch of the page.

Note: “Parallel Base Currency” will be available for selection only if it is applicable for the company.

Financial Year	Use the drop-down list box to select the financial year in which you want to view the account ledger. All the financial years defined for the company till the current financial year will be available for selection. The system displays the first value by default on launch of the page.
Financial Period From	Use the drop-down list box to select the financial period in which you want to view the account ledger. All the periods of the selected financial years defined for the company till the current financial year will be available for selection. The system displays the first value by default on launch of the page.
From Date	The starting date in the range of dates from which you want to view the account ledger (Date Format). The system date is displayed by default on launch of the page.

Note: The date entered in this field must be before the date entered in the “To” field.

To	The ending date in the range of dates to which you want to view the account ledger (Date Format). The system date is displayed by default at the launch of the page.

Note: The date entered in this field must be equal to or greater than the “From Date” field.

Account Code From	The starting code number in the range of code numbers identifying the account code in which you want to view the account ledger (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
	Help facility available.
To	The ending code number in the range of code numbers identifying the account code in which you want to view the account ledger (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
	Help facility available.

Note: The number entered in this field must be equal to or greater than the value entered in the “Account Code From Field”.

Amount In	Use the drop-down list box to set whether you want to view the account ledger figures in “Billions”, “Millions” or “Thousands”. The system displays “Blank” by default on launch of the page.
Include Memorandum Vouchers	Use the check box to select whether you want to include the memorandum vouchers in the account ledger.

Click the “Print Account Ledger” push button to print the account ledger.

The system retrieves and displays a statement of all transactions based on the account codes. The system retrieves also retrieves and displays the transactions for the given date range for the selected finance book, financial year and financial period. The system also retrieves and displays either the credit or the debit running balances for a particular account code.

Report on Account Ledger – An overview

You can print the account ledger for a date range, financial year or financial period and for the selected finance book. The memorandum journal vouchers that have been created to simulate certain journal entries can also be included while generating the account ledger of a finance book. An account ledger can be generated in the base currency of the company and in the account currency. If a parallel base currency is available for a company, the account ledger can also be generated in the parallel base currency. The details of the generated account ledger can be viewed before being printed as a report.

This page allows you to set the criteria for generating an account ledger for a finance book. You can generate an account ledger for a finance book irrespective of whether it is a “Main”, “Posting” or a “Consolidation” finance book. If a “Tax Book” is maintained for an organization unit, this page also allows you to set the criteria and generate an account ledger for the individual tax books. You can also generate the account ledger by specifying a range of account codes. You can also set the figures in which you want to view the account ledger.

This page allows you to generate a detail account ledger that would contain the statement of all the transaction based on the account codes. The system also retrieves and displays either the credit or the debit balance for a particular account code along with all its transactions.

Report Heading	Account Ledger (for the period between From Date - To Date)
Header Information	Finance Book, Amount and Currency
Columns Printed	Transaction Type, Document Number, Cost Center, Analysis Code, Ref. Document No., Trading Partner Code, Narration, Debit and Credit

Note: Trading Partner Code will be displayed for all the Supplier and Customer Invoicing transactions including Debit/Credit notes.