Reconciliation

SFTP File Transfer

SFTP file transfer for our reconciliation reports is available to merchants on request.

To set up file push to a merchant server Link Money will provide the merchant with a public key for SFTP key-pair authentication and will need the following information to be shared:

• Path to server
• Host name
• Base directories of where the reports should be stored
• Desired configurations for delivery

If a merchant requests to instead use a Link Money-provided SFTP server, they will need to generate a key pair and then provide Link Money with the following information:

• Public Key
• IP addresses that will be used to connect to SFTP server
• Desired configurations for delivery to Link Money-provided server

Once a merchant has been setup for SFTP file transfer they will receive the following .CSV files to their server or be able to pull from the Link Money-provided server at the frequency and times requested.

Transactions File

File Name Format: Merchant Name_Transactions_Time Period for Which File is For

Columns included in this file:

• Update

  If the transaction has been included in a previous report shared then the value will be “Yes”. If it’s the first time the transaction has been included in a file, the value will be “No”

• Date of Transaction

  Date and time of when the transaction was initiated. This will be shared in ISO date and time with Z for the UTC indicator

• Date of Settlement

  Date and time of when the transaction was completed. This will be shared in ISO date and time with Z for the UTC indicator

• Client Reference ID

  Merchant-generated payment-related ID

• Transaction ID

  Link Money-generated payment ID

• Debit

  If the transaction is a debit/purchase then the dollar amount for the transaction will show

• Credit

  If the transaction is a credit/refund then the dollar amount for the transaction will show

• Currency

  This will show the currency used for the transaction in ISO currency code (alpha) format

• Status

  The status of the transaction at the moment the report was generated. Possible values can be Created, Pending, Authorized, Scheduled, Initiated, Succeeded, and Failed

Payouts File

File Name Format: Merchant Name_Payouts_Time Period for Which File is For

• Update

  If the payout has been included in a previous report shared then the value will be “Yes”. If it’s the first time the payout has been included in a file, the value will be “No”

• Date of Payout

  Date and time of when the payout was initiated. This will be shared in ISO date and time with Z for the UTC indicator

• Date of Settlement

  Date and time of when the payout was completed. This will be shared in ISO date and time with Z for the UTC indicator

• Payout ID

  Link Money-generated payout ID

• Status

  The status of the payout at the moment the report was generated. Possible values can be Created, Scheduled, Initiated, Disbursed, and Failed

• Last 4

  Last 4 of the account that is the destination for the payout

• Amount

  The amount of thep ayout in the specified currency

• Currency

  This will show the currency used for the payout in ISO currency code (alpha) format