Skip to main content
Loan Amortisation template

How to populate data in the Loan Amortisation template.

Updated over a week ago

The Loan Amortisation template is useful to calculate repayments and interest if you're repaying loans or looking to take one out.

Before you add data to this template to import, you must:

Once you've done this, we explain below how to add data to the Loan Amortisation template in your Master Sheet.


⚠CAUTION:

  • Don't delete any rows or columns from the sheet

  • Don't add any additional rows or columns. If you require more rows, use a separate template

If you accidentally do any of the above, you may corrupt the sheet. When this happens, you’ll need to open a new template, copy it to your Master Sheet again, and restart the process of adding data.

  1. Click the Forecasting tab, then view the forecast you want to import predictions into.

  2. Once in the forecast, click New prediction in the top right, then click Import templates on the dropdown.

  3. Click Open Master Sheet and go to the Loan amortization template.

  4. Enter your data into the white cells.

    • Unlike some other templates, there are no hidden settings to complete.

    • Start entering the details of your loan. This can be for a loan yet to be received, or a loan that has already been received and payments already taken. For existing loans, actual data will replace forecasted data within Futrli.

    • As you complete the cells with the information, you'll see the payment schedules update automatically.

      GIF showing payment schedules update automatically as the user completes cells.

      ⚠CAUTION: Only paste values if you're pasting data from another source. This is because the sheet has underlying formulas.​

  5. If you need to add more payments, click the + icon next to Expand to enter any additional fees.

    GIF showing a user expand rows in the Google Sheet.

  6. You can add up to three loans to this sheet. Open the columns to reveal the settings for predictions two and three.

    GIF of the template showing green ticks.


  7. When finished, you'll have a green tick at the top of the page. This means you can continue to sync the import template to Futrli.

  8. When the red cross is showing, the data isn’t ready to sync. ​You'll need to expand the rows next to it to see which information is missing.

Did this answer your question?