How can we help?

Bulk Document Uploader - K-1 Matching

There are several ways admins can upload documents to investor profiles in IMS. If unique documents need to be uploaded to a specific group of investors, such as tax documents, admins can utilize the bulk document uploader to save time and improve efficiencies. 

There are 3 methods admins can use when bulk uploading documents; Manual Match, Upload by Filename, and K-1 Matching. To begin, navigate to Documents in the top navigation, then select Personal and Project Documents, then click the drop down arrow in the top right corner of the screen. 

step_1.png

 

Document Uploader Best Practices 

No matter which upload method you choose to use, there are several universal best practices to help admins get the most of this feature. 

  • Documents uploaded need to be computer generated and in a readable format PDF. The system cannot read documents that are scanned and turned into PDFs. 
  • While the system is processing the documents for matching, users can navigate to another tab within IMS or can begin another batch upload without losing their progress. But, do not refresh the page, log out, or shut the browser completely. 
  • When the batch is finished uploading, the batch name will change from grey to blue and the user will be able to click into the batch. 
  • To bulk rename a K-1 document batch, at least one document must be matched to an investor. The system will only rename documents that are matched to investors. Admins can bulk rename document batches as many times as they wish. The system renames the matched documents to ‘Entity Name_Investor Name_Year K1’

K-1 Matching

This method is recommended for bulk uploading Schedule K1 documents to your investors. It will associate the tax document to the investment in the investor portal. The K-1 Matching tool reads the tax ID number on the document and looks for the investor within the given Entity that has this tax ID saved to their profile. If the investor is not associated to the Entity within IMS or does not have their tax ID saved to their profile, the system will not be able to automatically match a K-1 document to them.

To use this method, select K-1 Matching on the drop-down menu.

Begin filling in the fields prompted on the screen. *Note - all fields on the K-1 Matching page are required. Only investors associated with the Project and Entity will be prompted during the match process. 

2019-10-01_08-18-24.png

Select the documents that you wish to upload and then click the Upload button.

2019-10-01_08-29-43.png

Once the upload is complete, select the blue batch name.

2019-10-01_08-23-16.png

Once within the batch manager, navigate to Unmatched to begin matching any documents that the system was not able to match on the Tax ID number. You can click on the filename to preview the document to the right.

2019-10-01_08-33-13.png

To assign a document to an investor, begin typing in the white box that initially says 'unassigned'. The system will prompt investors associated to the entity selected when uploading the batch. Select the appropriate investor. 

Once the document has been matched, it will move to the Matched folder.

2019-10-01_08-36-30.png

Once all documents have been matched, navigate to the Matched folder.

2019-10-01_08-39-26.png

If you need to edit a recipient for a document, click on the investor name to update the investor or change it back to Unassigned. You can also delete document entirely by clicking on the trash can.

Once you have matched the documents, they are ready to be published. Matched documents can be published in 3 ways. The system will only publish documents that have been matched to an investor.

  1. On the Manage Batches page, click on the arrow next to the batch name and then choose Publish All.
  2. From within the batch manager page, click on the Publish button in the bottom right corner of the screen.
  3. From within the batch manager page, click on ‘Publish Now’ in the yellow notification bar.

If you choose to ‘Notify Investors,’ investors associated to the document will get an email notification as well.

2019-10-01_08-42-17.png

Once published, you can navigate back to the Batch Manager page to see a status of all batches. 

2019-10-01_08-43-49.png

If you would like to export an audit log to see an excel spreadsheet showing how all documents were matched, click on the drop-down arrow next to the batch name then choose Download Audit Log. This will download an excel file.

Screen_Shot_2019-10-01_at_8.44.42_AM.png

If you would like to rename tax documents to ‘Entity Name_Investor Name_Year K1’ this can be done on the Manage Batches page. Click on the drop-down arrow next to the batch name and then choose Bulk Rename. The system will prompt you for the year you would like to attach to the file name. Only documents that are matched to an investor will be renamed.

 

If documents need to be unpublished for any reason, simply navigate back to the Manage Batches page and select the drop-down arrow next to the batch name. Select Unpublish All.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request