You can perform a bulk import of your deal syndication investors into MCA Suite instead of entering each manually. To import your investors, you must create and format a comma separated value (csv) file with the following columns:
|A||Investor Name||Y||Exact name of the investor company in MCA Suite|
|B||Merchant Name||Y||Exact name of the merchant company in MCA Suite|
|C||Deal Name||Y||Exact Deal Name in MCA Suite|
|D||Investor %||The investor percentage of the syndicated deal. Either D or E are required.|
|E||Investor Amount||The investor dollar amount of the syndicated deal. Either D or E are required. If both entered D will replace E.|
|F||Fee %||The fee percentage for this syndicated investor. Either F or G are required.|
|G||Fee Amount||The fee amount in dollars for the investor. Either F or G are required and F will replace G if both are entered.|
|H||Fee Type||Use 'Concurrent' or 'Backend'. The default is Concurrent if nothing entered.|
A sample template is attached at the bottom of the page.
Once you have your file ready, go to Admin > Import > Syndicated Investors page to select the file to be imported. After the file has been uploaded. Click 'Process' to proceed.
All correct rows in the CSV will be uploaded into the system while any rows with errors will not be uploaded and skipped. A message will be displayed regarding the erroneous rows.
Note it is your job to ensure your investor amount/percentages total to 100%. The system will only catch the last investor being imported exceeds 100%.
This feature is unavailable if you are using the Syndication Multi Fees feature.