Import Transactions using Excel

Fairways Debt enables you to batch/bulk import transactions, i.e. simultaneously create multiple transactions, using an Excel file.

 

Navigate to the Debt & Derivatives Application
  1. Log in to your Fairways Debt account, e.g. https://login.financeactive.com/eu.
  2. Select a customer account.
  3. Navigate to Applications > Debt & Derivatives.

 

Import Transactions
  1. Click Add Transaction.
  2. Click Batch Update > Import Excel.

AddTransaction_EN.png

  1. Click Download Template to download the template file.

Transaction_Import_EN.png

  1. Select the sheet(s) matching the transaction(s) to import.
  2. Complete the file with all relevant details.

Notes:

  • Fields marked with an asterisk * are mandatory.
  • See specific transaction articles for more details about the fields.
  • If you leave the status blank, the draft status is selected by default.

In this example, we are importing two standard loans, one with the status Actual and the other with no status defined.

Excel_1_EN.png

Excel_2_EN.png

  1. Navigate back to Fairways Debt and select the file containing the transactions to import.
  2. Click Apply.

Transaction_Import_Browsed_EN.png

Fairways Debt verifies the file and informs you of potential errors.

  1. Click Import.

Import_EN.png

The transactions are imported in the relevant portfolios in Fairways Debt.

Portfolio_EN.png

Draft_EN.png

Was this article helpful?
0 out of 0 found this helpful