mO SharemO Share

#Balance Sheet Tabular#

Report Name

#Balance Sheet Tabular#

Report Location

Finance\Financial Statement

Report Type

Register

Report Description

This Report will display Balance Sheet for the user given period for the Connected Organization Unit. This is tabular report format for analysis purpose.

Report Objective

This is Balance Sheet Report, developed with an objective that user can use this Report for further spread sheet analysis for more meaningful insight. This Report can be run at user defined level of Accounting Group

Target Audience

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

Selections

Name

Selection type

Objective

From Date

Single

Balance Sheet to be shown for the period starts from this date. Opening Balance to be shown for the transactions happened before this date.

To Date

Single

Balance Sheet to be shown as on closing balance for this date.

Include Un-posted Entries

Single

If it is 'Yes' then report will also consider all those transactions which is not released/posted yet also

Include Zero Balance Records

Single

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

Amount display format

Single

User can opt to display the value as per the following formats :

Actual, Crore,Lacs,Million,Thousand,

Level

Single

User will have option to choose Level of Accounting Group or Ledger. If user option for Level 1 then the report display at Asset & Liability level similarly for Level 2 - 4 user can consider. Apart from the Levels of Account Group user can opt to see the report at Ledger Level.

Dependencies

Not Applicable

Alternative reports to validate

Ledger level balance will be same as with #Ledger Detail#, #Ledger Summary# and #Balance Sheet#, #Balance Sheet Periodic# Report.

Sample Output

 

Data Source Category Used

01-Master\Ledger [LV_LEDGER]
02-Finance\04-Report Specific\Balance Sheet New [TV_BS_NEW]