Difference between revisions of "How do I deal with company loans?"
From Catalyst
m (→Journalling Any Interest/Charges) |
(Bulk update) |
||
| (7 intermediate revisions by 3 users not shown) | |||
| Line 4: | Line 4: | ||
== More Information == | == More Information == | ||
=== Creating the Nominal Codes === | === Creating the Nominal Codes === | ||
| − | Start by creating the nominal codes for both the loan and for the associated charges and interest. Please see [[How do I | + | Start by creating the nominal codes for both the loan and for the associated charges and interest. Please see [[How do I create a nominal code?]] to create nominal codes. |
==== Loan Nominal ==== | ==== Loan Nominal ==== | ||
| − | Set up the Loan nominal code as follows: | + | Set up the Loan nominal code as follows: |
| − | * [[How do I | + | * [[How do I create a nominal code?|Create]] a Nominal code with a number in the {{DataValue|19800}} region (to coincide with standard nominal code structure), giving it the {{DataPrompt|Description}} of {{DataValue|Loan Control}}. |
| − | ** The Loan Nominal Code will need to be set up as a {{DataPrompt|Balance Sheet Indicator}} {{DataValue|Asset/Liability}} type. | + | ** The Loan Nominal Code will need to be set up as a {{DataPrompt|Balance Sheet Indicator}}{{DataValue|Asset/Liability}} type. |
==== Loan Interest/Charges Nominal ==== | ==== Loan Interest/Charges Nominal ==== | ||
| − | Set up the Loan Interest/Charges as follows: | + | Set up the Loan Interest/Charges as follows: |
| − | * [[How do I | + | * [[How do I create a nominal code?|Create]] a Nominal code with a number in the 15300 region (to coincide with standard nominal code structure), giving it the {{DataPrompt|Description}} of {{DataValue|Loan Interest/Charges}}. |
| − | ** The Loan interest/charges Nominal Code will need to be set up as a {{DataPrompt|Profit & Loss Indicator}} {{DataValue|Overhead}} type. | + | ** The Loan interest/charges Nominal Code will need to be set up as a {{DataPrompt|Profit & Loss Indicator}}{{DataValue|Overhead}} type. |
=== Journalling the Loan === | === Journalling the Loan === | ||
| − | Go to {{Menu|{{NL}}|Journal Entries}}. | + | Go to {{Menu|{{NL}}|Journal Entries}}. |
==== Loan ==== | ==== Loan ==== | ||
| − | The first item to enter is the total amount of the loan. | + | The first item to enter is the total amount of the loan. |
* At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | * At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | ||
| − | * At {{DataPrompt|Date:}}, enter the date at which the loan was taken out. | + | * At {{DataPrompt|Date:}}, enter the date at which the loan was taken out. |
| − | * At {{DataPrompt|Reversing?}} choose {{DataValue|No}}. | + | * At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. |
| − | * Enter the centre for the | + | * Enter the centre for the Loan Account and enter the total amount of the loan in the Credit(-) column. |
{{Note|title=Note|text=Because you are entering the value in the {{DataPrompt|Credit(-)}} column, the figure will automatically be a negative amount, so you do not need to enter a {{DataValue|-}} sign here.}} | {{Note|title=Note|text=Because you are entering the value in the {{DataPrompt|Credit(-)}} column, the figure will automatically be a negative amount, so you do not need to enter a {{DataValue|-}} sign here.}} | ||
| − | * Enter a comment of {{DataValue| | + | * Enter a comment of {{DataValue|Total borrowed}}. |
* Enter the centre for the Current Bank account and enter the same figure as above in the Debit(+) column. | * Enter the centre for the Current Bank account and enter the same figure as above in the Debit(+) column. | ||
* The {{DataValue|Nett}} value should show {{DataValue|Zero}}. | * The {{DataValue|Nett}} value should show {{DataValue|Zero}}. | ||
| Line 33: | Line 33: | ||
==== Lending Fee ==== | ==== Lending Fee ==== | ||
| − | The second item to enter is the initial charge for taking out the loan. | + | The second item to enter is the initial charge for taking out the loan. |
* At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | * At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | ||
| − | * At {{DataPrompt|Date:}}, enter the date at which the lending fee was charged. | + | * At {{DataPrompt|Date:}}, enter the date at which the lending fee was charged. |
* At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | * At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | ||
| − | * Enter the centre for the | + | * Enter the centre for the Loan Account and enter the amount in the Credit(-) column. |
| − | |||
{{Note|title=Note|text=Because you are entering the value in the {{DataPrompt|Credit(-)}} column, the figure will automatically be a negative amount, so you do not need to enter a {{DataValue|-}} sign here.}} | {{Note|title=Note|text=Because you are entering the value in the {{DataPrompt|Credit(-)}} column, the figure will automatically be a negative amount, so you do not need to enter a {{DataValue|-}} sign here.}} | ||
* Enter a comment of {{DataValue|Lending fee}}. | * Enter a comment of {{DataValue|Lending fee}}. | ||
| − | * Enter the centre for the Loan Interest/Charges and enter the figure | + | * Enter the centre for the Loan Interest/Charges and enter the figure in the Debit(+) column. |
* The {{DataValue|Nett}} value should show {{DataValue|Zero}}. | * The {{DataValue|Nett}} value should show {{DataValue|Zero}}. | ||
* Press {{KeyPress|Done}} and the journal will be posted. | * Press {{KeyPress|Done}} and the journal will be posted. | ||
=== Journalling Any Interest/Charges === | === Journalling Any Interest/Charges === | ||
| − | Each month there will be an interest charge for having the loan. This and any other charges will all get journalled in the same fashion. You will need to do this every time that a charge or interest is added. | + | Each month there will be an interest charge for having the loan. This and any other charges will all get journalled in the same fashion. You will need to do this every time that a charge or interest is added. |
* At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | * At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | ||
| − | * At {{DataPrompt|Date:}}, enter the date at which the interest fee was charged. | + | * At {{DataPrompt|Date:}}, enter the date at which the interest fee was charged. |
* At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | * At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | ||
* Enter the centre for the Loan Account and enter the amount in the Credit(-) column. | * Enter the centre for the Loan Account and enter the amount in the Credit(-) column. | ||
| Line 60: | Line 59: | ||
=== Journalling the Payments === | === Journalling the Payments === | ||
| − | Each month there will be a repayment against the loan that you will need to make. Again, this will be journalled into the system. | + | Each month there will be a repayment against the loan that you will need to make. Again, this will be journalled into the system. |
* At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | * At {{DataPrompt|Entry mode:}}, choose {{DataValue|Multiple}}. | ||
| − | * At {{DataPrompt|Date:}}, enter the date of the payment. | + | * At {{DataPrompt|Date:}}, enter the date of the payment. |
* At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | * At {{DataPrompt|Reversing?}}, choose {{DataValue|No}}. | ||
* Enter the centre for the Bank Account and enter the amount in the Credit(-) column. | * Enter the centre for the Bank Account and enter the amount in the Credit(-) column. | ||
| Line 72: | Line 71: | ||
* Press {{KeyPress|Done}} and the journal will be posted. | * Press {{KeyPress|Done}} and the journal will be posted. | ||
| − | You will need to continue in this fashion journalling all charges by the method described above, as well as journalling all payments made. With a number of loans, the interest charges will be variable, which is why the interest and payment journals have been split above for clarity. | + | You will need to continue in this fashion journalling all charges by the method described above, as well as journalling all payments made. With a number of loans, the interest charges will be variable, which is why the interest and payment journals have been split above for clarity. |
To view the amount outstanding you will need to view the Loan Control centre. This centre will come back to zero once the loan has been fully paid. | To view the amount outstanding you will need to view the Loan Control centre. This centre will come back to zero once the loan has been fully paid. | ||
== See also == | == See also == | ||
| − | * [[How do I | + | * [[How do I create a nominal code?]] |
| − | * [[What is a | + | * [[What is a nominal code?]] |
* [[How do I find a Nominal Ledger Number?]] | * [[How do I find a Nominal Ledger Number?]] | ||
| − | + | {{KB_Tags|loan, bank, payments, company loan, interest, fee, charge, nominal ledger, ledger numbers, nominal ledger number}} | |
| − | {{KB_Tags| | + | {{How}}{{KB_NL}}{{ZN_Accounts}} |
Latest revision as of 05:33, 19 June 2019
Contents
Summary
This article will explain how to deal with Company Loans and how to add them to the system so that you can show the loan amount, each individual fee or charge that may incur by having the loan as well as interest on the loan. This article will also explain how to make a payment against the loan.
More Information
Creating the Nominal Codes
Start by creating the nominal codes for both the loan and for the associated charges and interest. Please see How do I create a nominal code? to create nominal codes.
Loan Nominal
Set up the Loan nominal code as follows:
- Create a Nominal code with a number in the '19800' region (to coincide with standard nominal code structure), giving it the "Description" of 'Loan Control'.
- The Loan Nominal Code will need to be set up as a "Balance Sheet Indicator"'Asset/Liability' type.
Loan Interest/Charges Nominal
Set up the Loan Interest/Charges as follows:
- Create a Nominal code with a number in the 15300 region (to coincide with standard nominal code structure), giving it the "Description" of 'Loan Interest/Charges'.
- The Loan interest/charges Nominal Code will need to be set up as a "Profit & Loss Indicator"'Overhead' type.
Journalling the Loan
Go to " Nominal Ledger Journal Entries".
Loan
The first item to enter is the total amount of the loan.
- At "Entry mode:", choose 'Multiple'.
- At "Date:", enter the date at which the loan was taken out.
- At "Reversing?", choose 'No'.
- Enter the centre for the Loan Account and enter the total amount of the loan in the Credit(-) column.
 | Note: Because you are entering the value in the "Credit(-)" column, the figure will automatically be a negative amount, so you do not need to enter a '-' sign here. |
- Enter a comment of 'Total borrowed'.
- Enter the centre for the Current Bank account and enter the same figure as above in the Debit(+) column.
- The 'Nett' value should show 'Zero'.
- Press <Done> and the journal will be posted.
Lending Fee
The second item to enter is the initial charge for taking out the loan.
- At "Entry mode:", choose 'Multiple'.
- At "Date:", enter the date at which the lending fee was charged.
- At "Reversing?", choose 'No'.
- Enter the centre for the Loan Account and enter the amount in the Credit(-) column.
| Note: Because you are entering the value in the "Credit(-)" column, the figure will automatically be a negative amount, so you do not need to enter a '-' sign here. |
- Enter a comment of 'Lending fee'.
- Enter the centre for the Loan Interest/Charges and enter the figure in the Debit(+) column.
- The 'Nett' value should show 'Zero'.
- Press <Done> and the journal will be posted.
Journalling Any Interest/Charges
Each month there will be an interest charge for having the loan. This and any other charges will all get journalled in the same fashion. You will need to do this every time that a charge or interest is added.
- At "Entry mode:", choose 'Multiple'.
- At "Date:", enter the date at which the interest fee was charged.
- At "Reversing?", choose 'No'.
- Enter the centre for the Loan Account and enter the amount in the Credit(-) column.
| Note: Because you are entering the value in the "Credit(-)" column, the figure will automatically be a negative amount, so you do not need to enter a '-' sign here. |
- Enter a comment of 'Interest Charges'.
- Enter the centre for the Loan Interest/Charges and enter the figure in the Debit(+) column.
- The 'Nett' value should show 'Zero'.
- Press <Done> and the journal will be posted.
Journalling the Payments
Each month there will be a repayment against the loan that you will need to make. Again, this will be journalled into the system.
- At "Entry mode:", choose 'Multiple'.
- At "Date:", enter the date of the payment.
- At "Reversing?", choose 'No'.
- Enter the centre for the Bank Account and enter the amount in the Credit(-) column.
| Note: Because you are entering the value in the "Credit(-)" column, the figure will automatically be a negative amount, so you do not need to enter a '-' sign here. |
- Enter a comment of 'Loan Payment'.
- Enter the centre for the Bank Loan and enter the figure in the Debit(+) column.
- The 'Nett' value should show 'Zero'.
- Press <Done> and the journal will be posted.
You will need to continue in this fashion journalling all charges by the method described above, as well as journalling all payments made. With a number of loans, the interest charges will be variable, which is why the interest and payment journals have been split above for clarity.
To view the amount outstanding you will need to view the Loan Control centre. This centre will come back to zero once the loan has been fully paid.
See also
