Difference between revisions of "How do I deal with company loans?"
From Catalyst
m |
m |
||
| Line 2: | Line 2: | ||
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 a loan as well as interest on the loan. This article will also explain how to make a payment against the loan, to the point that the loan has been paid. | 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 a loan as well as interest on the loan. This article will also explain how to make a payment against the loan, to the point that the loan has been paid. | ||
| − | + | == More Information == | |
| − | == Creating the Nominal Codes == | + | === Creating the Nominal Codes === |
To start, you will need to create the nominal codes for both the Bank Loan and for the bank charges and interest that will be charged. Please see [[How do I Create a Nominal Code?]] to create nominal codes and then set up the codes as follows: | To start, you will need to create the nominal codes for both the Bank Loan and for the bank charges and interest that will be charged. Please see [[How do I Create a Nominal Code?]] to create nominal codes and then set up the codes as follows: | ||
| − | === Bank Loan Nominal === | + | ==== Bank Loan Nominal ==== |
Following the instruction of how to create a nominal code you will need to set-up the "Bank Loan" as follows: | Following the instruction of how to create a nominal code you will need to set-up the "Bank Loan" as follows: | ||
* [[How do I Create a Nominal Code?|Create]] a Nominal code with a number 198?? (To Coincide with Standard nominal code structure), giving it the {{DataPrompt|name}} of {{DataValue|Bank Loan}}. | * [[How do I Create a Nominal Code?|Create]] a Nominal code with a number 198?? (To Coincide with Standard nominal code structure), giving it the {{DataPrompt|name}} of {{DataValue|Bank Loan}}. | ||
** The bank loan Nominal Code will need to be a set-up as a {{DataPrompt|Balance Sheet Indicator}} {{DataValue|Asset/Liability}} type. | ** The bank loan Nominal Code will need to be a set-up as a {{DataPrompt|Balance Sheet Indicator}} {{DataValue|Asset/Liability}} type. | ||
| − | === Bank Interest/Charges Nominal === | + | ==== Bank Interest/Charges Nominal ==== |
Following the instruction of how to create a nominal code you will need to set-up the "Bank Interest/Charges" as follows: | Following the instruction of how to create a nominal code you will need to set-up the "Bank Interest/Charges" as follows: | ||
* [[How do I Create a Nominal Code?|Create]] a Nominal code with a number 153?? (To Coincide with Standard nominal code structure), giving it the {{DataPrompt|name}} of {{DataValue|Loan Interest/Charges}}. | * [[How do I Create a Nominal Code?|Create]] a Nominal code with a number 153?? (To Coincide with Standard nominal code structure), giving it the {{DataPrompt|name}} of {{DataValue|Loan Interest/Charges}}. | ||
** The bank interest/charges Nominal Code will need to be a set-up as a {{DataPrompt|Profit & Loss Indicator}} {{DataValue|Overhead}} type. | ** The bank interest/charges Nominal Code will need to be a set-up as a {{DataPrompt|Profit & Loss Indicator}} {{DataValue|Overhead}} type. | ||
| − | == Journalling the Bank Loan == | + | === Journalling the Bank Loan === |
| − | The first step is to journal into the system the full amount of the loan. To do this, you will need to go to : | + | The first step is to journal into the system the full amount of the loan. To do this, you will need to go to : {{Menu|Nominal Ledger|Journal Entries|Double Entry}}. |
| − | === Bank Lending Fee === | + | ==== Bank Lending Fee ==== |
The first item that will need to be journalled is the initial Bank Charge for taking out the loan. To journal this : | The first item that will need to be journalled is the initial Bank Charge for taking out the loan. To journal this : | ||
| − | * On the {{DataPrompt|1st Centre:}}, enter the centre for the Bank Loan Account, e.g. | + | * On the {{DataPrompt|1st Centre:}}, enter the centre for the Bank Loan Account, e.g. {{DataValue|19860}}. Press {{KeyPress|Enter}}. |
* On the {{DataPrompt|Date:}}, enter the date at which the Bank lending fee was charged. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Date:}}, enter the date at which the Bank lending fee was charged. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|Amount:}} enter the amount that is being charged for the fee, e.g. | + | * On the {{DataPrompt|Amount:}} enter the amount that is being charged for the fee, e.g. {{DataValue|-200.00}}. |
* Press {{KeyPress|Enter}}. | * Press {{KeyPress|Enter}}. | ||
| Line 29: | Line 29: | ||
* On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Lending fee}}. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Lending fee}}. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|2nd Centre:}}, enter in the centre for the Loan Interest/Charges, e.g. | + | * On the {{DataPrompt|2nd Centre:}}, enter in the centre for the Loan Interest/Charges, e.g. {{DataValue|15319}}. Press {{KeyPress|Enter}}. |
| − | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. | + | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. {{DataValue|200.00}}. Press {{KeyPress|Enter}}. |
* Click {{Button|Accept}}. | * Click {{Button|Accept}}. | ||
| − | === Bank Loan === | + | ==== Bank Loan ==== |
The second item that will need to be journal is the amount of the loan. To journal this you will need to: | The second item that will need to be journal is the amount of the loan. To journal this you will need to: | ||
| − | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Bank Loan Account, e.g. | + | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Bank Loan Account, e.g. {{DataValue|19860}}. Press {{KeyPress|Enter}}. |
* On the {{DataPrompt|Date:}}, enter the date of which the Bank loan was given. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Date:}}, enter the date of which the Bank loan was given. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|Amount:}} enter the amount of the loan, e.g. | + | * On the {{DataPrompt|Amount:}} enter the amount of the loan, e.g. {{DataValue|-15000.00}}. Press {{KeyPress|Enter}}. |
{{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | {{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | ||
* On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Bank Loan}}. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Bank Loan}}. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|2nd Centre:}} enter in the centre for the Current Bank Account, e.g. | + | * On the {{DataPrompt|2nd Centre:}} enter in the centre for the Current Bank Account, e.g. {{DataValue|Z992}}. Press {{KeyPress|Enter}}. |
| − | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. | + | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. {{DataValue|15000.00}}. Press {{KeyPress|Enter}}. |
* Click on {{Button|Accept}} on the screen prompt that appears. | * Click on {{Button|Accept}} on the screen prompt that appears. | ||
| − | == 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. To journal the interest/charges you will need to: | 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. To journal the interest/charges you will need to: | ||
| − | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Bank Loan Account, e.g. | + | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Bank Loan Account, e.g. {{DataValue|19860}}. Press {{KeyPress|Enter}}. |
* On the {{DataPrompt|Date:}}, enter the date of the Interest Charge, or the Charges that have been added to your account. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Date:}}, enter the date of the Interest Charge, or the Charges that have been added to your account. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|Amount:}} enter the amount that is being charged for interest, e.g. | + | * On the {{DataPrompt|Amount:}} enter the amount that is being charged for interest, e.g. {{DataValue|-131.70}}. Press {{KeyPress|Enter}}. |
{{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | {{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | ||
* On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Interest Charged}}. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Interest Charged}}. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|2nd Centre:}}, enter in the centre for the Loan Interest/Charges, e.g. | + | * On the {{DataPrompt|2nd Centre:}}, enter in the centre for the Loan Interest/Charges, e.g. {{DataValue|15319}}. Press {{KeyPress|Enter}}. |
| − | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. | + | * The system will automatically enter in the opposite amount to that which was entered previously, i.e. {{DataValue|131.70}}. Press {{KeyPress|Enter}}. |
* Click on {{Button|Accept}} on the screen prompt that appears. | * Click on {{Button|Accept}} on the screen prompt that appears. | ||
| − | == Journalling the Payments == | + | === Journalling the Payments === |
Now it is time to journal the payment into the system. To journal this you will need to: | Now it is time to journal the payment into the system. To journal this you will need to: | ||
| − | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Current Bank Account Account, e.g. | + | * On the {{DataPrompt|1st Centre:}}, enter in the centre for the Current Bank Account Account, e.g. {{DataValue|Z992}}. Press {{KeyPress|Enter}}. |
* On the {{DataPrompt|Date:}}, enter the date of which the Bank payment has been paid. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Date:}}, enter the date of which the Bank payment has been paid. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|Amount:}} enter the amount of the payment, e.g. | + | * On the {{DataPrompt|Amount:}} enter the amount of the payment, e.g. {{DataValue|-490.68}}. Press {{KeyPress|Enter}}. |
{{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | {{Note|text=This needs to be entered as a negative figure as it is a crediting the account.}} | ||
* On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Loan Payment}}. Press {{KeyPress|Enter}}. | * On the {{DataPrompt|Cheque No./Comment:}}, enter a comment of {{DataValue|Loan Payment}}. Press {{KeyPress|Enter}}. | ||
| − | * On the {{DataPrompt|2nd Centre:}} enter in the centre for the Bank Loan, e.g. | + | * On the {{DataPrompt|2nd Centre:}} enter in the centre for the Bank Loan, e.g. {{DataValue|19860}}. Press {{KeyPress|Enter}}. |
| − | * The system will automatically enter in the opposite amount to that which was entered previously, e.g. | + | * The system will automatically enter in the opposite amount to that which was entered previously, e.g. {{DataValue|490.68}}. Press {{KeyPress|Enter}}. |
* Click on {{Button|Accept}}. | * Click on {{Button|Accept}}. | ||
You will need to continue in this fashion journalling all charges in the method described above, as well as journalling all payments made. To view the amount outstanding you will need to view the centre of "Bank Loan". Eventually this centre will balance back to zero at the point the loan has been fully paid for. | You will need to continue in this fashion journalling all charges in the method described above, as well as journalling all payments made. To view the amount outstanding you will need to view the centre of "Bank Loan". Eventually this centre will balance back to zero at the point the loan has been fully paid for. | ||
| − | == See | + | == See also == |
* [[How do I Create a Nominal Code?]] | * [[How do I Create a Nominal Code?]] | ||
* [[What is a Nominal Code?]] | * [[What is a Nominal Code?]] | ||
Revision as of 12:02, 1 November 2011
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 a loan as well as interest on the loan. This article will also explain how to make a payment against the loan, to the point that the loan has been paid.
More Information
Creating the Nominal Codes
To start, you will need to create the nominal codes for both the Bank Loan and for the bank charges and interest that will be charged. Please see How do I Create a Nominal Code? to create nominal codes and then set up the codes as follows:
Bank Loan Nominal
Following the instruction of how to create a nominal code you will need to set-up the "Bank Loan" as follows:
- Create a Nominal code with a number 198?? (To Coincide with Standard nominal code structure), giving it the "name" of 'Bank Loan'.
- The bank loan Nominal Code will need to be a set-up as a "Balance Sheet Indicator" 'Asset/Liability' type.
Bank Interest/Charges Nominal
Following the instruction of how to create a nominal code you will need to set-up the "Bank Interest/Charges" as follows:
- Create a Nominal code with a number 153?? (To Coincide with Standard nominal code structure), giving it the "name" of 'Loan Interest/Charges'.
- The bank interest/charges Nominal Code will need to be a set-up as a "Profit & Loss Indicator" 'Overhead' type.
Journalling the Bank Loan
The first step is to journal into the system the full amount of the loan. To do this, you will need to go to : " Nominal Ledger Journal Entries Double Entry".
Bank Lending Fee
The first item that will need to be journalled is the initial Bank Charge for taking out the loan. To journal this :
- On the "1st Centre:", enter the centre for the Bank Loan Account, e.g. '19860'. Press <Enter>.
- On the "Date:", enter the date at which the Bank lending fee was charged. Press <Enter>.
- On the "Amount:" enter the amount that is being charged for the fee, e.g. '-200.00'.
- Press <Enter>.
 | This needs to be entered as a negative figure as it is crediting the nominal account. |
- On the "Cheque No./Comment:", enter a comment of 'Lending fee'. Press <Enter>.
- On the "2nd Centre:", enter in the centre for the Loan Interest/Charges, e.g. '15319'. Press <Enter>.
- The system will automatically enter in the opposite amount to that which was entered previously, i.e. '200.00'. Press <Enter>.
- Click [Accept].
Bank Loan
The second item that will need to be journal is the amount of the loan. To journal this you will need to:
- On the "1st Centre:", enter in the centre for the Bank Loan Account, e.g. '19860'. Press <Enter>.
- On the "Date:", enter the date of which the Bank loan was given. Press <Enter>.
- On the "Amount:" enter the amount of the loan, e.g. '-15000.00'. Press <Enter>.
| This needs to be entered as a negative figure as it is a crediting the account. |
- On the "Cheque No./Comment:", enter a comment of 'Bank Loan'. Press <Enter>.
- On the "2nd Centre:" enter in the centre for the Current Bank Account, e.g. 'Z992'. Press <Enter>.
- The system will automatically enter in the opposite amount to that which was entered previously, i.e. '15000.00'. Press <Enter>.
- Click on [Accept] on the screen prompt that appears.
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. To journal the interest/charges you will need to:
- On the "1st Centre:", enter in the centre for the Bank Loan Account, e.g. '19860'. Press <Enter>.
- On the "Date:", enter the date of the Interest Charge, or the Charges that have been added to your account. Press <Enter>.
- On the "Amount:" enter the amount that is being charged for interest, e.g. '-131.70'. Press <Enter>.
| This needs to be entered as a negative figure as it is a crediting the account. |
- On the "Cheque No./Comment:", enter a comment of 'Interest Charged'. Press <Enter>.
- On the "2nd Centre:", enter in the centre for the Loan Interest/Charges, e.g. '15319'. Press <Enter>.
- The system will automatically enter in the opposite amount to that which was entered previously, i.e. '131.70'. Press <Enter>.
- Click on [Accept] on the screen prompt that appears.
Journalling the Payments
Now it is time to journal the payment into the system. To journal this you will need to:
- On the "1st Centre:", enter in the centre for the Current Bank Account Account, e.g. 'Z992'. Press <Enter>.
- On the "Date:", enter the date of which the Bank payment has been paid. Press <Enter>.
- On the "Amount:" enter the amount of the payment, e.g. '-490.68'. Press <Enter>.
| This needs to be entered as a negative figure as it is a crediting the account. |
- On the "Cheque No./Comment:", enter a comment of 'Loan Payment'. Press <Enter>.
- On the "2nd Centre:" enter in the centre for the Bank Loan, e.g. '19860'. Press <Enter>.
- The system will automatically enter in the opposite amount to that which was entered previously, e.g. '490.68'. Press <Enter>.
- Click on [Accept].
You will need to continue in this fashion journalling all charges in the method described above, as well as journalling all payments made. To view the amount outstanding you will need to view the centre of "Bank Loan". Eventually this centre will balance back to zero at the point the loan has been fully paid for.
See also
