MCA Suite

This import is a custom and very specific import and not available to all customers due to the complexity of import.  If you would to use this, please contact [email protected].

MCA Syndication and Transaction Imports

Clients can use MCA Suite to setup and track syndicated deals they participate in as investors with other funders. Using MCA Suite’s syndication deal and syndication transaction import templates, clients can import syndicated deals and transaction directly into MCA Suite.
 
The syndicated deal import process creates the merchant company, deal and syndication set-up all at once. The syndicated transaction import applies transactions to the deal and syndication schedule.
 
Broker commissions will also be imported as part of the syndication deal upload. We create the commission using: 

1)  a unique broker ID (the broker receiving this commission needs to be entered in the CRM as a broker company beforehand; assign the broker company a “broker ID” number using the “Third Party ID” field on the Broker Company Details page);

2)  the broker commission percentage (percentage of the deal advance amount that is being paid to broker) and

3)  the broker gross commission (equal to the broker commission percentage of the advance amount).

Syndicated Deals
 
Clients can import syndicated deals into MCA Suite using an import template.
 
Setup before Import
 
Before being able to use the import template and upload syndicated deals to MCA Suite, you will have to fulfill the following set-up prerequisites:
 
1) Deal Categories - The import spreadsheet will have a column for Deal Category (classifies the uploaded deal with a particular deal category). Make sure the deal categories you want to upload via the template (to assign to the deals you are uploading) are already set-up in MCA Suite.
 
To do this, go to the Admin main tab, and click on the Setup left-navigation tab. Then click on the Application Configuration tab within Setup. Scroll down to the section called “Cash Advance Deal Category.” Input cash advance categories to match the types you are including in the spreadsheet for the syndicated deals you want to import.



2)  Create company records for the companies that will be primary underwriters/funders on a deal. When creating these funding companies, make sure to select “Funder” and “Collector” as the “Contact Type.”


 
Advanced ID from the import template gets copied to deal name (ie, becomes the default deal name) and into the collection method’s “Merchant Number” field. The “Collection Method” Collector company is the same as the “funder” on the syndicated deal. We do this to try and mimic our current upload process.  This is why the user needs to choose “Collector” as contact type for the primary underwriter/funder companies.
 
3)  Create company records for the companies that will be secondary participants or syndicators on a deal. These companies can be any contact type; we recommend checking them off as “Investor” contact types.


 
4)  Create company records for the Brokers you will be including on the upload spreadsheet and importing as part of the syndicated deal. When you enter the broker companies, on the Add Company page, you will see a field called “Third party Id.” Assign the broker company a Third party ID, and then include both pieces of information on your import spreadsheet.   




Syndicated Deals Template (CSV)
Please note that all fields are required

Validations
 
We implemented the following validation checks for information on the deal syndication import:
 
1)  Merchant ID MUST be unique in our system (we are creating the new merchant and merchant ID).
 
2)  Broker ID must exist in our system. As explained above, users enter this Broker ID # on the Add New Company page when creating the new Broker Company record (enter in the field labeled “Third Party ID.”)
 
3)  Deal Categories listed on the template must exist in MCA Suite. Go to the Admin > Setup > Application Configuration page and then scroll down to the “Cash Advance Deal Category” section to input the new deal categories.
 
4)  Calculation Validations:
 
A.  Payback Amount (must equal advance amount * factor);
B.  Syndicator Amount (must equal advance amount * syndicator factor);
C.  Syndication Payback (must equal payback amount * syndicator factor);
D.  Broker Gross Commission (must equal advance amount * broker commission percent);
E.  Syndicator Gross Commission (must equal advance amount * broker commission percent * syndicator commission percent);
F.  Syndication Percent + Underwriting Percent + Other Percent must add up to 100.

5)  Advance ID and Funder combination must be unique in MCA Suite.
 
6)  Percentages should be written in integer form from 0-100 (i.e., 10% should be entered as 10, not as .10).
 
7)  Advance Date format must be mm/dd/yy (e.g., 12/25/14). 

Importing Syndicated Deals
 
To import syndicated deals, go to the “Admin” main tab. Click on the “Import” left side navigation tab, and then click on the “Syndicated Deals” subtab.

You will see Four (4) text fields: “Funder,” “Syndicator,” “Other Investor,” and "Broker." These fields are “look-up” fields that search against existing companies in MCA Suite; this is why you need to create these potential funders and syndication participants as company records FIRST, before importing syndicated deals.  The “Funder” field searches against “funder” or “collector”-type companies. The "Broker" field searches against "broker" contact type companies. “Syndicator” and “Other Investor” fields search against companies of any contact type. 



After inputting these company names, drag and drop your csv-format import template from your computer onto this page. Click the “Verify” button to have MCA Suite verify and accept the information contained in the spreadsheet. You will be notified if any rows contain some error that prevents the information from being processed. 



The “Advance ID” column needs to contain a unique Advance ID number. If you attempt to upload a spreadsheet that contains a duplicate Advance ID number, MCA Suite will notify you that an Advance ID has already been used and prevent the template from being processed.
 
Once the information on the import template has been verified, you will see a summary of the deal information you are attempting to import. After you have checked and approved this information, click the “Confirm Import” button.
 
 

Doing this will:

1)  create the new merchant company records;



2)  create the deals, with deal details and deal tracking pages and



3) create the syndicated deals, showing syndication details and participation breakdowns.



NOTE:  The default name we give the deal upon import is the Advance ID of the deal + Broker ID (in this example, that is 200_100). You can always change this name to one of your choosing by clicking on the Deal Details tab and editing the Deal Name field.

Syndicated Transactions
 
Syndicated Transactions Template
Please note that all fields are required