You can use Spotlight Forecasting to create a budget or forecast for a period up to 60 months. When working in Spotlight Forecasting, there are two main tasks you can work on - creating a budget or forecast, and copying the budget or forecast to predict alternative possible outcomes.
You can go to the Task Manager at any time to perform a different task. To edit your budget or forecast, in the Actions column click the Edit button alongside the budget or forecast name.
You can use the Profit & Loss budget only option within the task setup,to set up or import budget values for profit and loss accounts, for a period of up to five years. If needed, you'll then be able to use this budget in a forecast.
You can use the Full three way forecast option to set up a profit and loss, balance sheet and cash flow forecast for a period of up to five years. You can base this on the data imported from your accounting software, Excel or Google Sheets, or manually enter the data. Once you've created this, you can work with the values, rules and other options, creating both cash and non-cash journals, to customise this to be accurate for the business.
You can use the Make a Copy option alongside your budget or forecast to create a copy of this and flex the numbers as needed to predict other possible outcomes. For example, you can see the impact of an increase or decrease in revenue, cost of sales, and expenses, create a best or worst case forecast, or change payment terms to see the impact of improved debtor collection. You can now create up to 30 budgets and forecasts, so there's plenty of scope to predict possible outcomes and work with different business decisions.
Elsewhere in the Help Centre:
Create an audit trail
Customise your report layout and content
Export your report
Export your report
