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
Finance
  • 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. 

    Attachments Open full size
  • 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.

    Attachments Open full size

Related ideas

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