Updating a Historical Distribution

If you find that you need to update a historical distribution that has already been published to the investor dashboard, you can do so by following these steps:

Step 1:  Navigate to your name at the top right-hand corner of your screen and select Import Data.

Step 2:  Select the Archived tab, search for the project and locate the distribution batch in question using the Created On date or the 'i' icon (which provides distribution details, if you hover over it) as a reference.  

Step 3:  Select Edit in Spreadsheet from the dropdown next to the distribution batch you need to update.

Step 4:  Download and open the spreadsheet that is provided.  Select Enable Editing at the top of the spreadsheet.

Step 5:  Right click on the Distributions by Batch tab and select Unprotect Sheet.

Step 6:  Only make updates to the data in Columns H-L.  This can include adjusting the distribution amounts paid to investors, updating the Detail Buckets or changing the Payment Method.  For example, if you need to update the way the distribution was categorized (Detail Buckets in Columns H-K), you can simply cut / paste the amounts into the appropriate column.

Pro tip:  Use the column filters in Row 10 to help narrow or sort the list of investors.

Step 7:  Save and close the updated spreadsheet.  Navigate back to the Import Data screen, select the Upload tab and select Browse your files to locate your updated spreadsheet.

Step 8:  Select Upload File.

Step 9:  Select Upload Distribution.  Note:  This will simply replace the original distribution, and it will not notify investors.

Step 10:  Once the file has been successfully uploaded, you will see a window pop up at the top right-hand corner of your screen.

Pro tip:  To ensure the changes look as expected, you can either view the distribution batch within the project itself or masquerade as an investor to view the distribution on the investor portal.