Ideas

Finance Workbench

Need a workbench to view all financial Statements along with drill down functionality.

Also need to export any financial data in Excel.

Module

Sub Module

Finance

General Ledger

 

Menu

Sub Menu

Explore

Account Summary

Account by Sub ledger

Account by Month

Account Detail

Account Summary

Selection Parameters   

Org Unit :   

Always 1 Auto Flow

Not Null

Presently Disabled

Accounting Year :  

By Default login Year

List

YearName

Not Null

User can go to previous accounting year as well.  Even if those are closed.

Date Range  :   

Date From

Year Start Date

Date To

Login / Connect Date

Or Year End Date if Login Date > End Date

Not Null

Cannot overlap different Accounting Periods

Group  

Any particular Group

Group Name Lev3

Lev1

Lev2

Type

 

 

 

Asset

Can be Null

If Null Trial Balance will come - single selection

Site :   

As per User Site Mapping

List

SiteName

ShortName

SiteType

 

Can be Null

If Null then all records will come at Ledger level sum of all Sites (User Site mapping) but breakup can be seen if 'Show Site =Yes' .


Include Unposted

Tick

 

If Unposted records are to come.

 

Grid

 

Options

Account  by Sub ledger

Account by Month

Account Detail

 

Group Lev1  

Group Lev2  

Group Level3  

Type  

Ledger Name  

Last Activity  

Site

Opening  

Debit  

Credit  

Closing  

Lev1

Lev2

Lev3

Assets

XYZ

Date

 

 

 

 

 

Lev1

Lev2

Lev3

Liability

ABC

Date

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Grand Total

 

Total  

Total  

Total  

Total  

Once we Double Click  Account Detail will come

 

 

 

 

Account by Month

Org Unit :   

Always 1 Auto Flow

Not Null

Presently Disabled (Not Null)  

Accounting Year :  

By Default login Year

Not Null

User can go to previous accounting year as well.  Even if those are closed.

Flow from Summary

Date Range  :   

Default Accounting Year Start Date to As on Date

Not Null

Cannot overlap different Accounting Periods

Flow from Summary

Site :   

As per User mapping

Can be Null

Flow from Summary or User selection. Site wise Breakup not possible

Include Unposted

Tick

 

If Unposted records are to come. 

General Ledger

User Selection

List

GL Name

Type

Nature

Group

Not Null

Flow from Summary

Sub Ledger

User selection

List

Sl Name

Sl Code

SL Type

 

To filer subledger wise record

Options

Account  by Sub ledger

Account Detail

 

Month

Opening

Debit

Credit

Closing

 

 

 

 

 

Once we Double Click  Account Detail will come

 

 

 

 

 

Account by Sub ledger

Org Unit :   

Always 1 Auto Flow

Not Null

Presently Disabled

Accounting Year :  

By Default login Year (Not Null)  

Not Null

User can go to previous accounting year as well.  Even if those are closed.

Date Range  :   

Default Accounting Year Start Date to As on Date (Not Null)  

Not Null

Cannot overlap different Accounting Periods

Flow from Summary (As is)

Flow from Account by  Month (Month start / End Date)

Site :   

As per Privilege Site

Null Allowed

Flow from Summary or User selection. Site wise breakup not possible.

Include Unposted

Tick

 

If Unposted records are to come. 

General Ledger

Flow from Summary or User selection

Can be Null

 

Sub Ledger

User selection

Null Allowed

To show General ledger wise summary

Options

Account Detail

 

General Ledger

Sub ledger

Opening

Debit

Credit

Closing

 

 

 

 

 

 

Once we Double Click  Account Detail will come

 

 

 

 

Account Detail

Org Unit :   

Always 1 Auto Flow

Not Null

Presently Disabled

Accounting Year :  

By Default login Year (Not Null)  

Not Null

User can go to previous accounting year as well.  Even if those are closed.

Date Range  :   

Default Accounting Year Start Date to As on Date (Not Null)  

Not Null

Cannot overlap different Accounting Periods

Flow from Summary (as is)

Flow from Account Month (as is)

 

Site :   

As per Privilege Site (Can be Null)  

 

Records will come either particular site or all site.  Summary not possible.

General Ledger

Auto flow from Summary

Not Null

 

Sub Ledger

Auto Flow from Account by Sub ledger

 

 

Include Unposted

Tick

 

If Unposted records are to come. 

Grid Details

Entry Type  

Entry Date  

Doc Site  

Entry No  

Ref No  

Sub Ledger  

Opening  

Debit  

Credit  

Closing  

Ref Site

Remarks

SL Class

Pending Amt

Status

Opening

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Voucher

XX

SiteA

12234

 

SL1

 

 

 

 

 

 

 

 

 

 

 

 

Grid Column Search

Number

Text

Date

 

 

 

 

 

 

 

 

  • Sushil Agarwal
  • Nov 24 2015
  • Likely to implement
  • Attach files
  • Admin
    Product Team commented
    28 Apr, 2016 12:59pm

    Thanks for your comments. We shall do our best to incorporate all your suggestions.  Entry Modification would be added later once all finance entry modules are converted to WEB. 

  • Sushil Agarwal commented
    20 Apr, 2016 08:09am

    This workbench should also have following features:

    - option to see GL / SL having balance more or Less than specified amount

    - Entries having more / Less than specified amount or narration etc

    - Dates on which balance in Cash in Hand was negetive or more than specified amount

    in short if the USER wants to search one or more entry / ledger giving specific amount or range or narration etc they should be able to get it and the system should allow opening of entry from here and the USER depending upon their right to modify, can modify and save the entry from here.

Note : Do not post a lengthy title for an Idea. Post your Idea clearly supported by Screenshots, Examples and Case Studies (if possible).