FundPanel's Auto Match feature for portal document uploads quickly streamlines the process of uploading bulk documents to the investor portal.
This feature allows FundPanel to match files in a folder to individual Commitments/Vehicles in a Fund to be uploaded to the LP Portal as a Commitment document.
How to Prepare your Files for Upload:
Auto Match will match the files you select in a folder to each individual Commitment/Vehicle in a fund using the Vehicle ID enclosed in parenthesis or square brackets in the filename. The Vehicle ID is also named the AccountID of the Record Type "Investment Vehicle".
Example: VehicleName 123 LLC - Fund Name II,LP - Tax 2021(0015A00002G6JuN).pdf
File Preparation:
- Run the report named "Investment Vehicle Details" in FundPanel and customize it to ensure the following 2 columns are in the report.
- Account ID
- Investment Vehicle Name
- Submit this to the Document Provider (i.e. Tax Advisor...) and have them submit future documents with the Account ID column included in the filename enclosed in parenthesis or square brackets ( ) [ ].
Filenames received should like these examples:
VehicleName 123 LLC - Fund Name II,LP - Tax 2021(0015A00002G6JuN).pdf
VehicleName 123 LLC - Fund Name II,LP - Tax 2021[0015A00002G6JuN].pdf
How to Auto Match & Upload Files:
- Go to the Document Uploader - Portal tab in the Investor Relations App
and Select the Attachment Typ: "Commitment Document"
- Click Next and the Commitment Upload Screen will load.
Scroll Down to the bottom, and to the right is the new "Auto Match & Upload" button.
Click on the "Auto Match & Upload" button.
- Now the Auto Match & Upload page will load.
Next Click on "
- Now you can select files one by one using CTRL+Click or SHIFT+Click to select a range of files Or CTRL+A to select All files. Then Click Open.
- A list will be displayed of all Commitments/Vehicles Matched to a file.
Files that you select but, were NOT Matched in BLUE
Commitments/Vehicles NOT Match are in Orange
NOTE: Account ID along with () or [] will be removed from the Filename when uploaded. "File Name Clean" shows you the new filename before uploading. You may "Choose Files" again and it will refresh the matches.
Upload the Files: Once you have the files Matching as you wish, Click "Upload Matched"
The files will begin uploading 1 at a time.
Successful Uploads are marked in Green
Failed Uploads are marked in Red
NOTE: In some rare situations Vehicle ID (aka Account ID) may not be in the Filename. In this situation, you can enable: "Name Match" When enabling "Name Match", it will try and Match the Commitment/Vehicle to the Filename using the Investment Vehicle's name. To enable this, Check the "Name Match" checkbox before you click "Upload Matched"
