Create and publish a cash flow forecast template

Modified on Wed, 18 Nov at 10:21 AM

Print

A template defines how subsidiaries report their cash flow forecasts: who reports, what they report and when. You create the template, set up its rows, and then publish it so subsidiaries can report with it.

Steps

Create the template

  1. Go to Templates.
  2. Select Create Template.
  3. Enter a name for the template.
  4. On the Settings tab, under Who reports, fill in these fields:
    • Subsidiaries (required): select the companies that report using this template.
    • Consolidated Reporting Company: if one company should report for all the companies in one form, choose that company from the companies you selected under Subsidiaries. Otherwise, leave it as None.
  5. Under What is reported, fill in these fields:
    • Currencies (required): select specific currencies, or use each subsidiary's accounting currency.
    • Reporting Unit (required): choose the unit that reported values are shown in.
    • Reporting Decimals (required): choose how many decimals are shown for reported data.
    • Time Buckets (required): select the time buckets that subsidiaries report in. You can mix time buckets, such as days, weeks and months. In reports, you can also analyse the data in other time buckets.
  6. Under When it is reported, fill in these fields:
    • Reporting Schedule (required): set when reporting takes place.
    • Reminders: select the field, then set Days before and Repeat every. Days before is the number of days before the due date that the first reminder is sent; 0 means no reminders. Repeat every is the number of days between reminders; 0 means only one reminder. For example, 5 and 2 send reminders 5, 3 and 1 days before the due date.
    • Exclude Weekends: skips Saturdays and Sundays in the forecast.
  7. Under Bank data, fill in these fields:
    • Excluded Bank Accounts: select the accounts whose balances and flows are excluded. Only accounts owned by the selected subsidiaries are listed.
    • Exclude Only Balances: turn on to exclude only the balances of the excluded accounts and keep their cash flows.
    • Balance Status: select the statuses of the balances to include. If you leave it empty, all bank balances are included.
  8. Under Forecast behaviour, fill in these fields:
    • Ignore Overdue Forecasts: turn on to give forecasts that are past due the status Ignore, so subsidiaries don't have to report them.
    • Collapse Forecasts: turn on to open forecasts collapsed on each grouping level instead of expanded.

Set up the rows

  1. Select the Row Setup tab. You don't need to save the settings first.
  2. Under Commercial Rows, select Add row for each row you need.
  3. For each commercial row, set Name, Tag, Rolling behaviour, Currencies and Subsidiaries.
  4. Under Financial Rows, select Add row for each row you need.
  5. For each financial row, set Name, Deal types, Flow types, Internal/external and Subsidiaries.
  6. Under Forecast Layout, choose the grouping order for commercial and financial rows.
  7. Turn on Preview to see how the forecast will look.
  8. Select Save. This saves both the settings and the rows.

Publish the template

  1. When the template is ready, select Publish.

Result

The template appears under Published Templates. Until you publish it, a new template is a draft and is listed under Drafts.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

More in Cash Flow Forecast Premium

Still need help? Reach people who already know your configuration.

Submit a ticket