New Given Credit - By Payment Plan
The Given Credits and Leases document type is used for managing the kinds of documents where the company gives credits and loans to other companies or individuals.
In this chapter, we have prepared a user manual example, where our own company gives credit, and the installments are calculated: By payment plan.
 |
Case summary
The person responsible wishes to create a Given Credit document. On July 1th 2023, The Tecta a.d. company gave Alpha Trade CA Ltd. a credit in the amount of 2,000,000 EUR, with a repayment term of 36 months, and with the first 3 months being a grace period. Interest is calculated at 1% per annum, and is added to the principal debt. Repayment is made after the grace period, in 35 rates by payment plan. This is done as follows:
- Opening the Given Credit document
- Entering data into the Header tab
- Preparing Installments
|
The person responsible wishes to create a new credit document. For this purpose, the option Credits and Leases | Given is selected in the Financials module.
The document form GKR0 – Given Credits appears on the screen.
To create a new document, the person responsible clicks the toolbar button 
(Insert record). A new record appears in the field 23-GKR0-??????, among the navigation buttons, which receives a new serial number, and is saved when the button 
(Post edit) is clicked.
In the next step, the data is entered into the document header:
- Clerk: Enters the clerk's name (Adele Administrator), by typing in the first letters of the person's name, or by selecting it from the list that the program has generated, based on contact persons entered in the Subjects register.
- Document date: Specifies the date of the document, 1.07.2023.
- Status: Defines the status of the document from the list.
- Note: Writes the note for this specific document.
The person responsible begins entering the data into the Header tab:
- Subject: Alpha Trade CA Ltd, the subject to whom the company gave the credit.
- Date of Approval: 01.07.2023., the date of credit approval, specified in the credit contract.
- Repayment Start: 01.10.2023, the actual start date of loan repayment.
- Loan Start: 01.10.2023, the date when the interest calculation starts.
- Months of Moratorium: 3 months, the number of months for moratorium on payback of the principal.
- Interest Rate: C1, this is a code that is selected from the dropdown menu, and was previously entered in the Interest Rate Markups.
- Currency: EUR, because the credit is in a foreign currency, the person responsible selects it from the dropdown menu.
- Principal: Enters the loan principal value.
- Format: Credit, from the Document Types register.
- Repayment Type: By payment plan, the data specified in the credit contract.
- Interest Rate Calculation Method: Monthly. Selects what kind of instalment type it is. In this case, it is 12 moths per year.
The next step is creating installments.
The person responsible has received the Payment plan that was agreed on with Alpha Trade CA Ltd., in Excel form. In order to have exactly the same data in PANTHEON, the person responsible selects the option By payment plan.
After that, the person responsible selects Import from XLS for individual installments, from the Import/Export Data menu.
The following form appears on the screen:
The path to the Excel file has been defined by clicking the 3 dots on the right side of the File path field (option 1 in the picture Import Data). The Excel file has been prepared according to the Requested import structure.
Names of the columns in the Excel table (A: Annuity; B: Interest; C: Repayment...) correspond to the names given in the Import Structure. This structure can be seen by clicking the Structure button (option 2 in the picture Import data ).
After making sure that the file structure is correct, the person responsible clicks the button Import from File (option 3 in the picture Import data).
Data from the Excel file is prepared, and the person responsible can select which lines in the document he/she would like to transfer, by selecting them.
Finally, everything is ready for creating installments, by clicking the Create lines button (option 4 in the picture Import data).
Now, the credit given to Alpha Trade CA Ltd has all the essential data: Total Credit, Outstanding, and the Installments tab has all 36 Installments, which are filled in based on the data from the Excel table.