Editing Capital Account Records (Individual/Mass Edit)

When Editing a Capital Account record, it is important to know:

• Changes made to a particular Capital Account record do not affect any other existing Capital Account record(s).  For example, if you make changes to the Q118 Capital Account record, this will not automatically affect the existing Q417 or Q218 Capital Account records
• The 'Opening Balance' field is directly editable 
• The 'Capital Balance' field is not directly editable as it is a custom calculation field:
  • 'Capital Balance' = 'Opening Balance' + 'Contributed Capital' - 'Distributions' + 'Management Fee' + 'Other Income/Loss' + 'Net Realized Gain/Loss' + 'Net Unrealized Gain/Loss' + 'Syndication Costs' + 'Transfer' + 'Contingent Loss'
• The 'Contributed Capital' and 'Distributions' fields are not directly editable as they are custom calculation fields:
  • 'Contributed Capital' = Sum of 'Capital Call Amount' for all Capital Call records that exist for a Capital Commitment between the Capital Account record's 'Previous As Of + 1 Day' and 'As Of' dates.  The Capital Call record's 'Due Date' field is used for this calculation.
    • Exception:  If a Capital Call record has the 'Transferred' checkbox ticked, the Capital Call will not be included in the applicable Capital Account record's 'Contributed Capital' field calculation
  • 'Distributions' = Sum of 'Distribution Amount' for all Distribution records that exist for a Capital Commitment between the Capital Account record's 'Previous As Of + 1 Day' and 'As Of' dates.  The Distribution record's 'Distribution Date' field is used for this calculation.
    • Exception:  If a Distribution record has the 'Transferred' checkbox ticked, the Distribution will not be included in the applicable Capital Account record's 'Distributions' field calculation
  • EXAMPLE:
    • $10 Capital Call Due 12/31/2016 and $20 Capital Call Due 03/31/2017
    • $5 Distribution on 02/10/2017 and $10 Distribution on 04/01/2017
      • Capital Account:  Previous As Of 12/31/2016 and As Of 03/31/3017
        • Contributed Capital = $20    Distributions = $5
      • Capital Account:  Previous As Of 03/31/2017 and As Of 06/30/2017
        • Contributed Capital = $0    Distributions = $10

Please note: The only difference between editing an existing Capital Account record and creating a new Capital Account record:  

• When initially creating a new Capital Account record for a Capital Commitment, the 'Opening Balance' field of the new Capital Account record gets set initially to equal the 'Capital Balance' field of the Capital Account record directly before it. If there is no preceding Capital Account record for a Capital Commitment, the 'Opening Balance' field will get set initially to equal $0.00.  Once created, per above, the 'Opening Balance' field of an existing Capital Account record is editable - so a user can over-ride a potentially incorrect 'Opening Balance' value (if ever applicable)
• EXAMPLE - *In this scenario, upon creation, Capital Account B's 'Opening Balance' initially gets set to equal $50 - the 'Capital balance' of the preceding Capital Account A record.  Subsequently, the user has the option to edit the 'Opening Balance' of any existing Capital Account record(s):
  • Capital Account A:  Previous As Of 12/31/2016 and As Of 03/31/2017
    • Opening Balance = $0    Capital Balance = $50
  • Capital Account B:  Previous As Of 03/31/2017 and As Of 06/30/2017
    • Opening Balance* = $50    Capital Balance = $200

Mass Editing Capital Account Opening Balances

Navigate to the appropriate Fund record:

• Click into the appropriate Parent Capital Account record under the Capital Accounts related list.
• Click 'Show More' link at the bottom of the Capital Account related list (until all Capital Account records are displayed).
• Click the top Checkbox (next to the Action column) under the Capital Accounts related list to select all Capital Account records (to be mass edited).
• Click 'Mass Edit' button on the Capital Accounts related list.
• Edit the 'Opening Balance' field for the appropriate Capital Account records.
• Click Save.

Additional Notes:

• When editing the Opening Balance field, you will want to validate these balances with your finalized (excel) financials external from FundPanel
• After editing/saving the Capital Account record(s):
  • The 'Contributed Capital' and 'Distributions' fields will update/calculate
  • The 'Capital Balance' field will update/calculate

Please refer to this Freshdesk Article 'How to Add Mass Edit and Mass Update buttons onto Capital Account Related List' if you do not see the Mass Edit or the Mass Update buttons on your Capital Accounts related list.

Mass Editing Capital Account Opening Balances for a specific Capital Commitment

Navigate to the appropriate Fund record:

• Click into the appropriate Capital Commitment record under the Capital Commitments related list.
• Click 'Show More' link at the bottom of the Capital Account related list (until all Capital Account records are displayed).
• Click the top Checkbox (next to the Action column) under the Capital Accounts related list to select all Capital Account records (to be mass edited).
• Click 'Mass Edit' button on the Capital Accounts related list. 
• Edit the 'Opening Balance' field for the appropriate Capital Account records.
• Click Save.

Please refer to this Freshdesk Article 'How to Add Mass Edit and Mass Update buttons onto Capital Account Related List' if you do not see the Mass Edit or the Mass Update buttons on your Capital Accounts related list.

Editing an Individual Capital Account Opening Balance

Navigate to the Fund record:

• Click into the appropriate Parent Capital Account record under the Capital Accounts related list.
• Click into the appropriate Capital Account record under the Capital Accounts related list.
• Click Edit.
• Edit the Opening Balance value.
• Click Save.

Additional Notes:

• When editing the Opening Balance field, you will want to validate this balance with your finalized (excel) financials external from FundPanel
• After editing/saving the Capital Account record:
  • The 'Contributed Capital' and 'Distributions' fields will update/calculate
  • The 'Capital Balance' field will update/calculate