Add and edit the Loan Amortisation rule

You can use the Loan Amortisation rule in Spotlight Forecasting to record a new or existing loan in your forecast, including the principal and interest repayments.

Note: This rule is available in the Forecast and Scenario tasks.

 

 

  1. In your forecast or scenario, open the Balance Sheet tab and then open the Current Liabilities or Non-Current Liabilities section.
  2. Click Add Rule, then enter a name for the rule. This may be the name of the loan, or another recognisable name.
  3. From the Rule Type drop-down list, choose Loan Amortisation.
  4. Complete the remaining options as follows:

    • Apply Rule To - The account to which you want to record the loan liability.
    • Journal to Account - The bank account to which the loan is paid, and from which loan repayments are taken.
    • Interest Account - The interest expense account to record interest on the loan.

    loan amortisation screen one


  5. Click Next, then complete the Loan Details screen as follows:

    • Loan Amount - The value of the loan.
    • Start Date - The date on which the loan was made.  If the loan was made in the past, this should be the original start date - you do not have to set this to a date within your forecast.
    • Interest Rate - The rate of interest due.
    • Loan Period - The duration of the loan.  This should be the full duration of the loan, even if part of this period has already passed.
    • Repayment Frequency - The timing of payments.

      Note: As Spotlight Forecasting uses monthly values only in reports, if you select the Weekly or Fortnightly option, values still appear in your reports on a monthly basis. However, for the purposes of reducing interest, the rule calculates in the background based on the frequency you select.

    • Additional Payments - If any payments were made to the loan other than the standard repayments, or to see the difference that would be made by a lump sum payment, click this option and enter the amount and date of the payment.

      loan amortisation loan details screen


  6. If this is an existing loan which was already recorded, either in your accounting system or by using the Fixed Asset rule, select the Loan already recorded in accounts check box.

    Note: When you select this check box, loan repayments and interest are still calculated, but no loan is recorded to the liability and bank accounts you chose on the previous screen.

  7. Click Next. The Loan Amortisation Schedule screen then shows you the details of the loan and the payments and interest amounts for each month.

    Note: if you chose the Fortnightly or Weekly repayment frequency, the schedule shows only the total payments for the month. 

  8. If required, to download a copy of the loan amortisation schedule, click the Excel or PDF button. If the repayment frequency is weekly or fortnightly, this schedule gives the full details of the loan, weekly or fortnightly if required.
  9. Click Next. The Loan Summary screen shows you an overview of the loan. If required, to show the loan summary on your report, select the Include in Assumptions page of report check box.

    loan amortisation summary


  10. Click Next, add any notes required, then click Save Rule.


The loan now appears in the appropriate accounts within your profit and loss, balance sheet and cashflow forecast.

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2018