From XU Magazine, 
Online News

Step up with these 5 Forecasting features

April 7, 2020

For those of us who use Spotlight Forecasting (why wouldn’t you be?!), it’s easy to get into a routine of always using the same features over and over again. But don’t forget, Spotlight Forecasting is infinitely powerful and there’s lots under the hood that you may not have uncovered yet.
This article originated from the Xero blog. The XU Hub is an independent news and media platform - for Xero users, by Xero users. Any content, imagery and associated links below are directly from Xero and not produced by the XU Hub.
You can find the original post here:

From using the time-saving Loan Amortisation Rule, to performing a reality check with Comparison Pages, here are five features that will help you produce targeted, and relevant forecasts for your clients or business.

1. Loan Amortisation Rule: Secure funding and optimise repayments

Recording loans in your forecast is essential for preparing accurate and meaningful cash forecasts, however, it can be a time-consuming exercise and prone to error. With the Loan Amortisation Rule, simply enter the loan details and Spotlight Forecasting will perform the calculations and record all the relevant information in the forecast for you.

ezgif.com-video-to-gif (2)

The Loan Amortisation Rule is a deceptively straightforward solution that will impress your clients, help them achieve better outcomes, and save you time. For more on the Loan Amortisation Rule, check out the help guide or blog article.

2. Dynamic Rules: One rule, dynamic change

Dynamic Rules calculate the value of an account based on another account or formula. As the figures in the base account changes, the Dynamic Rule will automatically update the values in linked accounts.

Let’s look at a quick example. Say product costs are 10% of revenue, create a Dynamic Rule using the intuitive formula builder and now as revenue changes, you’ll notice product costs updating automatically—too easy.

For more on Dynamic Rules, check out the help guide.

3. KPIs & Covenants: Measure what matters

This one is very new! We introduced KPIs & Covenants in Spotlight Forecasting to strengthen your forecasting capabilities. Now you can quickly surface key performance indicators and loan covenants in one place to help monitor these metrics and to assist with decision making.


image7

So, how would you use this? Let’s look at an example:

Debt to Equity Ratio and Interest Coverage Ratio are two metrics that businesses need to monitor. Use the drag and drop formula builder in Spotlight Forecasting to quickly create these ratios and produce a ready-to-share report for your client or Board. A quick glance at the covenants will show all actual and forecasted values for the specified time period. You’ll see how the business in question is tracking against these covenants and also the projected position based on forecast data.

For more on KPIs & Covenants, check out the help guide or blog article.

4. Driver-Based Forecasting: Connect the Dots from Driver to Success

Using Spotlight Forecasting and the power of Drivers and Dynamic Rules, it’s easy to build forecasts based on key business drivers. You choose the inputs that drive business activity—from price and quantity, through to billable hours, head-count, or even days worked. Use these drivers as the building blocks to forecast revenue, costs and the success of the business.

Pricing change? More staff to hire? Updating drivers is simple. Manage your Drivers within Spotlight and any changes you make will automatically flow through to your forecasts and scenarios, and best of all there’s no need for spreadsheets.

For more on Driver-Based Forecasting, check out the help guide or blog article.

5. Comparison Pages: Perform a reality check

Visibility and analysis are helpful when discussing the future with clients. Comparison Pages allow you to add pages to the Cashflow forecast report so you can compare actuals to forecast as well as comparing various ‘what if’ scenarios.


Why leave it there?

To learn more about Spotlight Reporting

Straight to your inbox

Subscribe to our newsletter for updates as they happen
We hate spam too. We NEVER sell our mailing list.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.