Create a Loan as the Borrower

A loan taken from a financial institution will be created, where the authorization information will be left to default as that level of detail is not needed for the internal loan. If the loan was to an existing authorization, then this task would be very similar "Create a Loan Application".

To create a Loan Setup (LOANS) transaction in order to create a new loan authorization, perform these steps:

  1. Create an instance of the LOANS transaction.

  2. Navigate to the Authorization tab and complete as follows:

  3. Auto Generate ID: selected.

  4. Debt Type: External Taken.

  5. Skip the Authorization COA tab. (This task assumes 1 loan for the authorization and no Loan Authorization Event Type is entered for your External Taken code selected from the Debt Type page.)

  6. Navigate to the Debt Instrument tab, take the Insert Line action and complete as follows:

  7. Debt ID, Debt Instrument Name, Debt Instrument Short Name, Issue Date, and Principal: (enter values as desired).

  8. Debt Instrument Status: Active Loan

  9. Use the Save action to save the Debt Instrument Data, which will infer the Debt Type from the Authorization. This will trigger the transaction to create you a record on all the remaining transaction tabs that apply to that type of loan.

  1. Navigate to the Lender Information tab and enter the following:

  2. Vendor Code: (the financial institution that is the lender)

  3. Address ID: If there is no default payment address, choose a value else the field will default.

  1. Skip the Lender COA tab and Borrower Information tabs as they do not apply to this type of loan.

  2. Navigate to the Borrower COA tab and enter the following:

  3. Type of Payment: ALL

  4. Percentage: 100%

  5. Bank: Enter the default bank for the Fund

  6. COA: Enter all necessary to record expenditures of loan repayment

  1. Navigate to the Schedule tab to enter information about the payment schedule. The financial institution has sent you the payment schedule, which you want to upload as Schedule Details.

  2. Schedule Type: Amortized Payment

  3. Selected Schedule: true

  4. Use the Get Template action.

  5. Open the Excel file and paste in your payment schedule, completing the Schedule Detail Type column with a 1 (for Regular Payment) for all rows.

  6. Save the Excel file.

  7. Attach the Excel file to the Schedule line.

  8. Use the pick for the Import File field to choose your Schedule Details file.

  9. Take the Import Detail action.

  1. Validate the transaction.

  2. If errors exist, fix the errors and repeat Step 9. If no errors exist, continue with Step 11.

  3. Submit the transaction.