Skip to main content
All CollectionsForecastingImport predictionsTemplates
Custom daily and Custom monthly templates
Custom daily and Custom monthly templates

How to populate data in the Custom daily and Custom monthly templates.

Updated over a week ago

How to use these blank templates that let you pull any daily or monthly value directly into your cash flow.

Once you've done this, we explain below how to add data to the Custom daily or Custom monthly 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 additional rows, use a separate template

If you accidentally do any of the above, you may corrupt the sheet. If this happens, you will 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.

  4. Unlike some other templates, the Loan Amortization template requires no hidden settings to be opened and completed. You'll only need to add data to the white boxes.

  5. Set the first day/month the data will be uploaded for. You can do this simply by overriding the first day/month.

    For example, if you wanted to select October 2022 in the Custom Monthly, you'd need to type 10/2022. The following months will then automatically update.

    GIF showing a user type 10/22 to change from Jun 2021 to Oct 2022.


  6. Enter your data in the appropriate cells.

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

    Both daily and monthly templates have the same setup. Both require:

    • An account the prediction will be set up against

    • A prediction name

    • An invoice date

    • A VAT/GST/sales tax amount

    • Payment days

  7. Add the relevant figures against the day/month.

    GIF of the template showing green ticks.


  8. 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.

    GIF of the template showing green ticks.


    If this isn't green, you'll be able to open the rows to see which information is missing.

Did this answer your question?