Funds Administration

Fields-Fund Part A (Semi Annual & 90 Days)

Panel Name Field Name Comment
Overall Commitment and Deployment overview Name of Daughter Fund Pipeline > Deal Information > Deal Summary > Deal Name
Total approved commitment from SRI Fund Funds > Fund Information > Fund of Fund Drawdown Distribution Summary > Approved Commitment Amount(SRI Fund)
Total commitment from SRI Fund Funds > Investors > Existing LP > Total Committed Inv (of SRI Fund)
Amount of drawdown requested by Daughter Fund from SRI Fund Funds > Investors > Existing LP > Drawdown Requested (of SRI Fund)
Amount of drawdown requested by Daughter Fund as percentage of SRI Fund eligible commitment a. Funds > Investors > Existing LP > Drawdown Requested (of SRI Fund)
b. Funds > Investors > Existing LP > Total Committed Inv (of SRI Fund)
Formula:     (a/b )*100
Amount deployed to Daughter Fund by SRI Fund Funds > Investors > Existing LP > Contribution Amount (of SRI Fund)
Amount deployed to Daughter Fund by SRI Fund towards investment Funds > D/D > Drawdown / Distribution History  > Sum of all 'Investment' Drawdown of SRI Fund WHERE Transaction Primary Category is 'Total Investments'
Amount invested in Portfolio Companies by the Daughter Fund Portfolio Company > Portfolio Information > Investment Summary (Actual Cashflow) > Investment at Cost  (Sum of all PCs linked to each AIF)
Amount invested in MSMEs by the Daughter Fund Portfolio Company > Portfolio Information > Investment Summary (Actual Cashflow) > Investment at Cost (Sum of all PCs [which is marked MSME 'Yes'] linked to AIF and (including reinvestments, if any)
Amount invested in MSMEs vis-à-vis SRI Fund contribution multiple a. Portfolio Company > Portfolio Information > Investment Summary (Actual Cashflow) > Investment at Cost (Sum of all PCs [which is marked MSME 'Yes'] linked to AIF and (including reinvestments, if any)

b. Funds > D/D > Drawdown / Distribution History  > Sum of all 'Investment' Drawdown of SRI Fund WHERE Transaction Primary Category is 'Total Investments'

Formula:  a/b
Investment Overview Total Target Corpus Funds > Fund Information > Fund Summary -> Fund Size
Total approved commitment from SRI Fund Funds > Fund Information > Fund of Fund Drawdown Distribution Summary > Approved Commitment Amount(SRI Fund)
Total commitment from SRI Fund Funds > Investors > Existing LP > Total Committed Inv (of SRI Fund)
Total commitment from SRI fund as % of total Corpus a. Funds > Investors > Existing LP > Total Committed Inv (of SRI Fund)
b. Funds > Fund Information > Fund Summary -> Fund Size

Formula:  (a/b)*100
Total commitment from all investors Funds > Investors > Existing LP > Total Committed Inv (of All Investors)
Total eligible commitment from SRI Fund as % of Total commitment from all investors a. Funds -> Fund Information -> Fund of Fund Drawdown Distribution Summary -> Approved Commitment Amount(SRI Fund)

b. Funds > Investors > Existing LP > Total Committed Inv (of All Investors)

Formula:  (a/b)*100
Total drawdown requested from SRI Fund Funds > Investors > Existing LP > Drawdown Requested (of SRI Fund)
Total drawdown requested from all investors Funds > Investors > Existing LP >  Drawdown Requested (of All Investors)
Total drawdown requested from SRI Fund as % of Total drawdown requested from all investors a. Funds > Investors > Existing LP >  Drawdown Requested (of SRI Fund)

b. Funds > Investors > Existing LP >  Drawdown Requested (of All Investors)

Formula:  (a/b)*100
Total contribution from SRI Fund Funds > Investors > Existing LP > Contribution Amount (of SRI Fund)
Total contribution from all investors Funds > Investors > Existing LP > Contribution Amount (of All Investors)
Total contribution from SRI Fund as % of Total contribution from all investors a. Funds > Investors > Existing LP > Contribution Amount (of SRI Fund)

b. Funds > Investors > Existing LP > Contribution Amount (of All Investors)

Formula: (a/b)*100
Total amount available for deployment from all investors and investment proceeds a. Funds > Investors > Existing LP > Contribution Amount (of SRI Fund)

b. Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company)

Formula: (a+b)
Number of Portfolio Companies including reinvestments if any Count of Portfolio Companies from Funds Module > Portfolio Investments > Existing Portfolio 
Number of MSMEs Count of Portfolio Companies marked as MSME from Funds Module > Portfolio Investments > Existing Portfolio 
Total investments made in Portfolio Companies (including reinvestments, if any) Sum of all PCs linked to each AIF from Portfolio Company Module > Investments Tab > Funds Panel > Investment Amount
Total investments made in MSMEs (including reinvestments, if any) Sum of all PCs linked to each AIF from Portfolio Company Module > Investment Summary (Actual Cashflow) > Investment at Cost (Only PCs marked as 'MSME')
Existing investments made in Portfolio Companies Sum of all PCs linked to each AIF from Portfolio Company Module > Investment Summary (Actual Cashflow) > Investment at Cost (Only PCs marked as Exit Completed 'No')
Existing investments made in MSMEs Sum of all PCs linked to each AIF from Portfolio Company Module > Investment Summary (Actual Cashflow) > Investment at Cost (Only PCs marked as Exit Completed 'No' and 'MSME')
Total value of existing investments made in Portfolio Companies as on Sum of all PCs  Funds -> Portfolio Investments > Existing Portfolio > Current
Valuation (INR) (Only PCs marked as Exit Completed 'No')
Total value of existing investments made in MSMEs as on Sum of all PCs  Funds -> Portfolio Investments > Existing Portfolio > Current
Valuation (INR) (Only PCs marked as Exit Completed 'No' and 'MSME')
Total investment proceeds received Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company)
Total investment proceeds remitted to SRI Fund TODO
Total investment proceeds remitted to all investors TODO
Commitment and Contribution Total capital commitment of SRI Fund Funds > Investors > Existing LP > Commmitment amount (of SRI Fund)
Total commitment from SRI Fund Funds > Investors > Existing LP > Commmitment amount (of SRI Fund)
Total sponsor/ investment manager commitment Funds > Investors > Existing LP > Sum of Commitment Amount (Only for Investor Type: Sponsor / Investment Manager)
Total commitment from other investors Funds  > Investors > Existing LP > Sum of Commitment Amount (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total commitment from all investors Funds > Investors > Existing LP > Total Commmitment amount (of all Investors)
Total capital commitment of SRI Fund pending for drawdown Funds > Investors > Existing LP > Commmitment amount (of SRI Fund)
Total sponsor/ investment manager commitment pending for drawdown Funds > Investors > Existing LP > Balance Committed (Only for Investor Type: Sponsor / Investment Manager)
Total other investors commitment pending for drawdown Funds  > Investors > Existing LP > Sum of Balance Committed (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total commitment from all investors pending for drawdown Funds > Investors > Existing LP > Sum of Total Commmitment amount (of all Investors)
Total contribution pending against drawdown request from SRI Fund Funds > Investors > Existing LP > Sum of Total Contribution Amount (of SRI Fund)
Total contribution pending against drawdown request from sponsor/ investment manager a. Funds > Investors > Existing LP > Drawdown Requested (of SRI Fund)
b. Funds > Investors > Existing LP > Total Contribution (of SRI Fund)

Formula:  a - b
Total drawdown requested from SRI Fund Funds > Investors > Existing LP > Drawdown Requested (of SRI Fund)
Total drawdown requested from sponsor/ investment manager Funds > Investors > Existing LP > Sum of Drawdown Requested  (Only for Investor Type: Sponsor / Investment Manager)
Total drawdown requested from other investors Funds  > Investors > Existing LP > Sum of Drawdown Requested (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total drawdown requested from all investors Funds  > Investors > Existing LP > Sum of Drawdown Requested (of all investors)
Total contribution from SRI Fund Funds > Investors > Existing LP > Total Contribution (of SRI Fund)
Total contribution from sponsor/ investment manager Funds > Investors > Existing LP > Sum of Total Contribution (Only for Investor Type: Sponsor / Investment Manager)
Total contribution from other investors Funds  > Investors > Existing LP > Sum of Total Contribution (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total contribution from all investors Funds  > Investors > Existing LP > Sum of Total Contribution (All Investors)
Total contribution pending against drawdown request from other investors a. Funds  > Investors > Existing LP > Sum of Drawdown Requested (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)

b. Funds  > Investors > Existing LP > Sum of Drawdown Requested (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total contribution pending against drawdown request from all investors a. Funds > Investors > Existing LP > Sum of Drawdown Requested (of All Investors)
b. Funds > Investors > Existing LP > Sum of Total Contribution (of All Investors)

Formula:  a - b
Utilization of funds Total amount available for deployment from all investors and investment proceeds a.  Funds > Investors > Existing LP > Sum of Total Contribution (of All Investors)

b. Funds > Portfolio Investments > Existing Portfolio > Sum of Total Realization (INR) (of all Portfolio Company)

Formula: a+b
Total commitment made to Portfolio Companies Portfolio Company > Portfolio Information > Sum of Investment Summary (Expected Future Cashflow) > Expected Investments Amount (of All Portfolio Company linked to respective Funds)
Total commitment made to MSMEs Portfolio Company > Portfolio Information > Sum of Investment Summary (Expected Future Cashflow) > Expected Investments Amount (of All Portfolio Company which is marked MSME 'Yes' and linked to respective Funds)
Total investments made in Portfolio Companies Funds > Portfolio Investments > Existing Portfolio > Sum of Total Investment (INR) (of all Portfolio Company)
Total investments made in MSMEs Funds > Portfolio Investments > Existing Portfolio > Sum of Total Investment (INR) (of all Portfolio Company which is marked MSME 'Yes')
Total payments made towards fees, expenses, taxes & allocated to reserves Funds > Funds Cost > sum of all other Transaction Types except: Trustee Fees, Management Fees, Establishment Cost, Fund Expenses, Taxes
Total value of investments made in Portfolio Companies as on [Mar 31, 2023 based on Unaudited Management Account of the Fund] Funds > Portfolio Investments > Existing Portfolio -> Sum of Current
Valuation (INR) (of all Portfolio Company)
Total value of investments made in MSMEs as on [ based on Unaudited Management Account of the Fund] Funds > Portfolio Investments > Existing Portfolio -> Sum of Current
Valuation (INR) (of all PCs marked as 'MSME')
Total investments made in temporary investments Funds > Portfolio Investments > Existing Portfolio -> Sum of
Total Investment (INR) (of all PCs marked as Temporary Investment "Yes")
Total value of investments made in temporary investments as on [ based on Unaudited Management Account of the Fund] Funds > Portfolio Investments > Existing Portfolio -> Sum of Current Valuation (INR) (of all PCs marked as Temporary Investment "Yes")
Total amount available for deployment from all investors and investment proceeds, but pending for allocation a. Funds > Investors > Existing LP > Sum of Total Contribution (of All Investors)

b. Funds > Portfolio Investments > Existing Portfolio > Sum of Total Realization (INR) (of all Portfolio Company)

c. Funds > Portfolio Investments > Existing Portfolio > Sum of Total Investment (INR) (of all Portfolio Company)

Formula:  (a + b)  -  c
Sector wise Allocation of Investments Total corpus invested in Portfolio Companies Funds > Portfolio Investments > Existing Portfolio > Sum of Total Investment (INR) (of all Portfolio Company)
Total corpus invested in MSMEs Funds > Portfolio Investments > Existing Portfolio > Sum of Total Investment (INR) (of all Portfolio Company and MSME is "Yes")
Corpus invested in Portfolio Companies of Funds > Portfolio Investments > Existing Portfolio > Name of all Portfolio Company)
Corpus invested in MSMEs of Funds > Portfolio Investments > Existing Portfolio > Name of all Portfolio Company and MSME is "Yes")
Overall distributions received Total proceeds received from Portfolio Companies  Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company)
Total proceeds received from MSMEs Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company and MSME is "Yes")
Total proceeds received from temporary investments Funds > Portfolio Investments > Existing Portfolio -> Sum of
Total Investment (INR) (of all PCs marked as Temporary Investment "Yes")
Total investment proceeds received a.  Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company)

b.  Funds > Portfolio Investments > Existing Portfolio -> Total Realization (INR) (of all Portfolio Company and MSME is "Yes")

c. Funds > Portfolio Investments > Existing Portfolio -> Sum of
Total Investment (INR) (of all PCs marked as Temporary Investment "Yes")

Formula: a+b+c
Total investment proceeds used for reinvestment TODO
Total Investment Proceeds used for fees, expenses, taxes due for payment & allocated for reserves TODO
Total investment proceeds pending allocation TODO
Total distributions pending to be remitted to all investors TODO
Total distributions remitted to SRI Fund1 Funds  > Investors > Existing LP > Sum of Total Distribution (of SRI Fund)
Total distributions remitted to sponsor/ investment manager Funds > Investors > Existing LP > Sum of Total Distribution (Only for Investor Type: Sponsor / Investment Manager)
Total distributions remitted to other investors Funds  > Investors > Existing LP > Sum of Total Distribution (Excluding SRI Fund and Excluding Investor Type: SRI Fund / Sponsor / Investment Manager)
Total distributions remitted to all investors Funds  > Investors > Existing LP > Sum of Total Distribution (of all Investors)
Total distributions pending to be remitted to SRI Fund TODO
Total distributions pending to be remitted to sponsor/ investment manager TODO
Total distributions pending to be remitted to other investors TODO
Overall expenses Total fees, expenses, taxes due for payment & allocated for reserves Funds > Funds Cost > Transaction Amount (sum of all other Transaction Types except: Trustee Fees, Management Fees, Establishment Cost, Fund Expenses, Taxes)
Total payments made towards fees, expenses, taxes & allocated for reserves Funds > Funds Cost > Transaction Amount (sum of all other Transaction Types except: Trustee Fees, Management Fees, Establishment Cost, Fund Expenses, Taxes)
Total management fees due for payment Funds Module > Funds Cost > Transaction Amount( sum of all management fees entries where payment date is due)
Total payment made towards management fees Funds > Funds Cost > Transaction Amount (sum of all management fees entries )
Total fund expenses due for payment Funds > Funds Cost > Transaction Amount (sum of all fund expenses entries where payment date is due)
Total payment made towards fund expenses Funds > Funds Cost > Transaction Amount (sum of all fund expenses entries where payment date is not due)
Total amount allocated for reserves Funds > Fund Information > Investment Summary > Reserves & Surplus
Total trustee fees due for payment Funds > Funds Cost > Transaction Amount (sum of all trustee fees entries where payment date is due)
Total payment made towards trustee fees Funds > Funds Cost > Transaction Amount (sum of all trustee fees entries where Payment date is not due)
Total establishment expenses due for payment Funds > Funds Cost > Transaction Amount (sum of all establishment cost entries where Payment date is due)
Total payment made towards establishment expenses Funds > Funds Cost > Transaction Amount (sum of all establishment cost entries where Payment date is not due)
Total Taxes due for payment Funds > Funds Cost > Transaction Amount (sum of all tax entries where payment is due)
Total payment made towards Taxes Funds > Funds Cost > Transaction Amount (sum of all tax entries where payment is not due)
Minimum investment in MSME sector Total contribution received from SRI Fund (net of pro-rata share of fees and expenses) used for investment Funds > Fund Information > Investment Summary > Reserves & Surplus
Total investments made in MSME sector1 Sum of all PCs linked to each AIF from Portfolio Company Module > Investments Tab > Funds Panel > Investment Amount (Only PCs marked as 'MSME')
Investment made in MSME sector vis-à-vis SRI Fund investment a. Sum of all PCs linked to each AIF from Portfolio Company Module > Investments Tab > Funds Panel > Investment Amount (Only PCs marked as 'MSME')

b. Funds > D/D > Drawdown / Distribution History > Sum of all transaction amount (where Transaction Primary Category is equal to "Total Investments")

Formula : a/b
Minimum investments to be made in MSME sector a. Funds > D/D > Drawdown / Distribution History > Sum of all transaction amount (where Transaction Primary Category is equal to "Total Investments")

Formula: a * 5
Whether condition of minimum investment in MSME sector fulfilled a. Funds > D/D > Drawdown / Distribution History > Sum of all transaction amount (where Transaction Primary Category is equal to "Total Investments")

b. Sum of all PCs linked to each AIF from Portfolio Company Module > Investments Tab > Funds Panel > Investment Amount (Only PCs marked as 'MSME')

Formula:  (a*5) > b, 'Yes', 'No'
Additional investments to be made in MSME sector If value of "Whether condition of minimum investment in MSME sector fulfilled" is "Yes", "NA",
else "Minimum investments to be made in MSME sector" - "Investment made in MSME sector vis-à-vis SRI Fund investment"
Closing, term, commitment period and liquidation Total term Funds > Fund Information > Fund Summary > Total term
Term end date Funds > Fund Information > Fund Summary > Term end date
Remaining term Funds > Fund Information > Fund Summary > Remaining term
Date of first close Funds > Fund Information > Fund Summary > Date of first close
Whether any subsequent close achieved Funds > Fund Information > Fund Summary > Number of subsequent close achieved after first close
Whether final close achieved Funds > Fund Information > Fund Summary > Whether Final Close Achieved
Total commitment period Funds > Fund Information > Fund Summary > Total Commitment Period
Commitment period end date Funds > Fund Information > Fund Summary > Commitment period end date
Remaining commitment period a. Funds > Fund Information > Fund Summary > Commitment period end date
b. Current Date
Formula:  c = b - a (Where value of "C" is number of days)
Whether Daughter Fund has been liquidated Funds > Fund Information > Fund Summary > Whether Fund has been liquidated
Term start date Funds > Fund Information > Fund Summary > Term start date
Term completed (Years) Funds > Fund Information > Fund Summary > Term completed (Years)
Whether first close achieved Funds > Fund Information > Fund Summary > Whether first close achieved
If first close not achieved, time lapsed since SRI Fund commitment Funds > Fund Information > Fund Summary > Time Lapsed Since SRI Fund Commitment
Date of subsequent close Funds > Fund Information > Fund Summary > Date of subsequent close
Date of final close Funds > Fund Information > Fund Summary > Date of final close
Commitment period start date Funds > Fund Information > Fund Summary > Commitment period start date
Commitment period completed a. Funds > Fund Information > Fund Summary > Commitment period start date
b. Current Date
Formula:  c = b - a (Where value of "C" is number of days)
Date of liquidation of Daughter Fund Funds > Fund Information > Fund Summary > Date of liquidation of Daughter Fund