mO SharemO Share

#Ledger Summary - Cost Centre#

Report Name

#Ledger Summary - Cost Centre#

Report Location

Finance\Register

Report Type

Register

Report Description

This report will show summary of the ledgers (cost centre wise) during a given period. Click on 'Site' to get transaction details in a separate report.

Report Objective

This Report is designed to have the financial posting details with respect to Cost Centre for Each Ledger / Sub Ledger. This Report is suitable to view Ledger / Sub Ledger wise cost center posting details. There is a hyperlink on Cost Centre which will redirect to Ledger Detail Cost Centre for better understanding.

Target Audience

Accounts Executives, Accounts Manager, Finance Manager, Finance Executive, Senior Management

Selections

Name

Selection type

Objective

From Date

Single

Report to be shown based on transaction happened for the period starts from this date

To Date

Single

Report to be shown based on transaction happened for the period ends to this date

Show Sub Ledger

Single

If it is ‘True’ then report will display along with Sub Ledger else it will be grouped with Ledger Only.

Include Unposted Entries

Single

If it is ‘True’ then report will consider all those transactions which is not released/posted yet also.

Include Zero Balance Records

Single

If it is 'True' then report will show all the Ledger (or group which do not have non-zero balance)

Chart of Accounts. LEVEL 1

Multiple

If needed Level 1 of Chart of Accounts can be selected for which the Ledgers to be shown in Report. If not needed then can be kept blank/Remove.

Chart of Accounts. LEVEL 2

Multiple

If needed Level 2 of Chart of Accounts can be selected for which the Ledgers to be shown in Report. Option for Selection will be dependent on previous Selection in Level 1. If not needed then can be kept blank/Remove.

Chart of Accounts. LEVEL 3

Multiple

If needed Level 3 of Chart of Accounts can be selected for which the Ledgers to be shown in Report. Option for Selection will be dependent on previous Selection in Level 2. If not needed then can be kept blank/Remove.

Chart of Accounts. LEVEL 4

Multiple

If needed Level 4 of Chart of Accounts can be selected for which the Ledgers to be shown in Report. Option for Selection will be dependent on previous Selection in Level 3. If not needed then can be kept blank/Remove.

Ledger Name

Multiple

If needed Ledger can be selected for which records to be shown in Report. Option for Selection will be dependent on previous Selection in Level 4. If not needed then can be kept blank/Remove.

Sub Ledger

Multiple

If needed Sub Ledger can be selected for which records to be shown in Report. Option for Selection will be dependent on previous Selection in ledger. If not needed then can be kept blank/Remove.

Cost Centre

Multiple

If needed Cost Centre(s) can be selected for which records to be shown in Report. Option for Selection will be dependent on previous Selection. If not needed then can be kept blank.

Dependencies

NA

Alternative reports to validate

#Cost Centre Analysis#, #Ledger Detail - Cost Centre#

Sample Output

 

Data Source Category Used

01-Master\Chart of Accounts [LV_CHART_OF_ACCOUNTS]
01-Master\Ledger [LV_LEDGER]
02-Finance\04-Report Specific\Ledger Summary - Cost Centre [TV_GL_SUMMARY_CC]
01-Master\Owner Site [LV_SITE]
01-Master\Sub-Ledger [LV_SUBLEDGER]