The Affiliate Payment Import page allows you to import your affiliates' payment information quickly and allows your affiliates to view their payment history. You can also add notes into LinkTrust so your affiliates' can track their payments through the payment process. This allows you to streamline your workload when you have hundreds of affiliates to pay each month.

Affiliate payment import is the process of importing affiliate payment information into LinkTrust using a text file. To be able to import an affiliate payment file, you need to how to do the following:

• Create an Affiliate Payment File
• Import the Affiliate Payment File

Create an Affiliate Payment File

The affiliate payment file must be a comma-separated values (CSV) file. A comma-separated values (CSV) file is a set of file formats used to store table data where numbers and text are stored in plain textual form that can be read in a text editor. Lines in the text file represent rows of a table, and commas in a line separate what are fields in the table row.

The following is an example of a CSV file:

Notice the double commas after the payment reference ID. This means that there is no data given for the Affiliate Notes column in the table of the file created, but that column still must be represented in the table.

When creating an affiliate payment file, you must create all the column headers listed in the table below. To create an affiliate payment file for importing payment information into LinkTrust, do the following:

1. Open Excel.
2. Create the following column headers (Note: All column headers are required):

   Column Header	Character Length	Required	Format	Notes
   AffiliateId	7	Yes	21452, 142153, etc...	Numeric - Must be from affiliates in your account.
   CommissionAmount	n/a	Yes	00000.00	Positive values only.  Max 2 places after the decimal place.
   AdjustmentAmount	n/a	Yes	(+/-)00000.00	Positive or Negative values ok.  Max 2 places after the decimal place.
   FeesAmount	n/a	Yes	-00000.00	Negative values only.  Max 2 places after the decimal place.
   PaymentType	13	Yes	Format: Check, Wire, PayPal, DirectDeposit	Must match offered payment types for partner.
   PaymentReferenceID	50	Yes	String	Column Header must be present, but the value may be blank.
   AffiliateNotes	Unlimited	Yes	String	Column Header must be present, but the value may be blank.
   PartnerNotes	Unlimited	Yes	String	Column Header must be present, but the value may be blank.
   DatePosted	10	Yes	mm/dd/yyyy	Date in format of mm/dd/yyyy

   
   
3. Enter your affiliate payment information into the spreadsheet.
4. When you are finished, save the affiliate payment file by selecting the Excel Icon in the top left corner.
5. Select Save as.
6. Select Other Formats.
7. Select Text (Tab Delimited).

Import the Affiliate Payment File

To import the affiliate payment file into LinkTrust, do the following:

1. In the Import File field, enter the name of the file or browse to the file on your computer by selecting Browse.
2. Begin the import process by selecting Upload.