mO SharemO Share

#Interest Calculation - General Ledger#

Report Name

#Interest Calculation - General Ledger#

Report Location

Finance\Register

Report Type

Register

Report Description

This report will show the interest calculation for General type ledger for the selected date range. Formula Logic -
(balance * percentage/365)*days

Report Objective

This Report is design to have a report to calculate the interest need to be charged for any outstanding value of the selected date range.

Target Audience

Finance Manager, Finance executive, 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 starts from this date

Default Interest Rate :

Single

If user provides a value here then the same will considered as Interest Rate for the calculation in Report. Please Note if Ledger Master have value in ‘Interest Rate’ under General tab then that will be considered as interest rate for the outstanding instead of given value in this parameter.

Level 1 :

Multiple

User can choose a particular / multiple Accounting Group from Level 1 of Chart of Accounts

Level 2 :

Multiple

User can choose a particular / multiple Accounting Group from Level 2 of Chart of Accounts . The list of values available in this option is dependent of previous selection.

Level 3 :

Multiple

User can choose a particular / multiple Accounting Group from Level 3 of Chart of Accounts . The list of values available in this option is dependent of previous selection.

Level 4 :

Multiple

User can choose a particular / multiple Accounting Group from Level 4 of Chart of Accounts . The list of values available in this option is dependent of previous selection.

Ledger :

Multiple

User can choose a particular / multiple Ledger of Chart of Accounts . The list of values available in this option is dependent of previous selection.

Dependencies

Not Applicable

Alternative reports to validate

Ledger Summary Report (For Ledger Balance Only)

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\Interest Calculation - General Ledger [TV_INT_CALC_GL]