Once your data is uploaded to FundPanel, it is highly recommended to perform an audit of your uploaded data to ensure everything has been added to FundPanel correctly. 

The best way to quickly review and audit your data is to create a report that shows you all of the data you have just uploaded. Below we will share best practices regarding creating and organizing reports for performing data validation.

TABLE OF CONTENTS

• Create a Report Folder (Optional)
• Reviewing Investor Accounts
  • Salesforce Report
  • Steps to Compare Spreadsheet vs Salesforce
• Investment Vehicle Review
  • Salesforce Report
  • In Excel
• Unique Contact Load Review
  • Salesforce Report
  • In Excel
• Contact Role Load Review
  • Salesforce Report
  • In Excel
• Capital Commitment Review
  • Salesforce Report

Create a Report Folder (Optional)

In Salesforce

• Navigate to Reports tab.
• Click Folder icon.
• Click New Report Folder.
• Name the folder something to align with your data upload project. In this example we will use a generic name: Investor Relations Review.
• Click Save.

⠀

Reviewing Investor Accounts

The first step to validating your data is confirming that all of the records were uploaded. Each of the sections below will walk through creating a report to show all unique records added in your data upload, so can compare against your import spreadsheets to confirm all of the data exists in FundPanel with the correct field values. 

Salesforce Report

• Navigate to the Reports tab.
• Click New Report.
• Type Account in the search bar.
• Click Accounts.
• Click Create.

Match the appropriate highlighted filters. You can do so by dragging the appropriate fields from the left hand side to the right hand columns. 

Required Filters:

• Show: All accounts.
• Date Field: Created Date.
• Range: All Time.
• Account Record type 'equals' Investor.

⠀

Required Columns:

• (Account) External ID.
• Account Name.
• Account Record Type.
• Last Modified Date.

⠀

• Click Run Report.

⠀

• Click Save As.
• Name the report 'Unique Investor Account'.
• Select Investor Relations Review report folder.
• Click Save & Return to Report.

⠀

Steps to Compare Spreadsheet vs Salesforce

• Open your Investor - Investment Vehicle Account excel sheet.
• Click on the 'Investor Name' column.
• Click the Data tab.
• Click Advanced icon.
• Select Filter the list, in-place.
• Make sure the List range is the Investor Name column.
• Select Unique records only.
• Click OK.

⠀

You are now presented with only unique Investor Account records in the excel sheet. Go ahead and compare the data between the 'Unique Investor Account' Salesforce report and your excel sheet.

Investment Vehicle Review

Salesforce Report

• Navigate to the Reports tab.
• Click New Report.
• Type Investment Vehicles in the search bar.
• Click Investment Vehicles and Investor Accounts.
• Click Create.

⠀

Match the appropriate highlighted filters. You can do so by dragging the appropriate fields from the left hand side to the right hand columns. 

Required Filters:

• Show: All accounts.
• Date Field: Created Date.
• Range: All Time.
• Account Record type 'equals' Investment Vehicle.

⠀

Required Columns:

• (Investment Vehicle) External ID.
• Investor Account: Account Name.
• Investment Vehicle Name.
• Account Record Type.
• Shipping Address.
• Phone.

• Click Run Report.

⠀

• Click Save As.
• Name the report 'Unique Investment Vehicle Load'.
• Select Investor Relations Review report folder.
• Click Save & Return to Report.

⠀

In Excel

• Open your Investor - Investment Vehicle Account excel sheet.
• Click on the 'Investment Vehicle Name' column.
• Click the Data tab.
• Click Advanced icon.
• Select Filter the list, in-place.
• Make sure the List range is the Investment Vehicle Name column.
• Select Unique records only.
• Click OK.

⠀

You are now presented with only unique Investment Vehicle records in the excel sheet. Go ahead and compare the data between the 'Unique Investment Vehicle Load' Salesforce report and your excel sheet.

Unique Contact Load Review

Salesforce Report

• Navigate to the Reports tab.
• Click New Report.
• Type Contacts & Accounts in the search bar.
• Click Contacts & Accounts.
• Click Create.

⠀

Match the appropriate highlighted filters. You can do so by dragging the appropriate fields from the left hand side to the right hand columns. 

Required Filters:

• Show: All accounts.
• Date Field: Created Date.
• Range: All Time.
• Contact Record type 'equals' Contact - Investor Relations.

⠀

Required Columns:

• Account Name (Group by this field).
• (Contact) External ID.
• Last Name.
• Email.
• Contact Record Type.

⠀

• Click Run Report.

⠀

• Click Save As.
• Name the report 'Unique Contacts Load'.
• Select Investor Relations Review report folder.
• Click Save & Return to Report.

⠀

In Excel

• Open your 'Contacts - Contact Roles' excel sheet.
• Click on the 'Contact Name' column.
• Click the Data tab.
• Click Advanced icon.
• Select Filter the list, in-place.
• Make sure the List range is the Contact Name column.
• Select Unique records only.
• Click OK.

⠀

You are now presented with only unique Contact records in the excel sheet. Go ahead and compare the data between the 'Unique Contact - Contact Role Load' Salesforce report and your excel sheet.

Contact Role Load Review

Salesforce Report

• Navigate to the Reports tab.
• Click New Report.
• Type Contacts with Contact Roles in the search bar.
• Click Contacts with Contact Roles.
• Click Create.

⠀

Match the appropriate highlighted filters. You can do so by dragging the appropriate fields from the left hand side to the right hand columns. 

Required Filters:

• Show: All contacts.
• Date Field: Created Date.
• Range: All Time.
• Contact Record type 'equals' Contact - Investor Relations.

⠀

Required Columns:

• Account: Account Name (Group by this field). Please note: this field is under the Contact Roles folder.
• Account Name: Account Name. Please note: this field is under the Contacts folder.

⠀

• Account Type.
• Full Name.
• Contact ID.
• Contact Record Type.
• (Contact) External ID.
• Email.
• Role.

⠀

• Click Run Report.

⠀

• Click Save As.
• Name the report 'Contact Role Load'.
• Select Investor Relations Review report folder.
• Click Save & Return to Report.

⠀

In Excel

• Open your 'Contacts - Contact Roles' excel sheet.
• Click the Data tab.
• Click Sort icon.
• Select My List has headers.
• Make sure the Column is set to Investor Name.
• Sort On: Values.
• Order: A to Z.
• Click OK.

⠀

You are now presented with only unique Contact Role records in the excel sheet. Go ahead and compare the data between the 'Unique Contact - Contact Role Load' Salesforce report and your excel sheet.

Capital Commitment Review

Salesforce Report

• Navigate to the Reports tab.
• Click New Report.
• Type Funds with Capital Commitments and Accounts in the search bar.
• Click Funds with Capital Commitments and Accounts.
• Click Create.

⠀

Match the appropriate highlighted filters. You can do so by dragging the appropriate fields from the left hand side to the right hand columns. 

Required Filters:

• Show: All funds.
• Date Field: Date of Inception.
• Range: All Time.

⠀

Required Columns:

• Fund: Fund Name (Group by this field).
• Capital Commitment: Capital Commitment Name.
• Investment Vehicle: Account Name.
• Capital Commitment.
• GP Commitment. Please note: this field is under the Capital Commitment: Info folder.

⠀

• Click Run Report.

⠀

• Click Save As.
• Name the report 'Commitment Load'.
• Select Investor Relations Review report folder.
• Click Save & Return to Report.

⠀

No adjustment to the 'Commitment Load' sheet will be required in Excel. Go ahead and compare the data between the 'Commitment Load' Salesforce report and your excel sheet.