How can you create a rolling forecast with Pastel Accounting?

2 Set up your forecast parameters

Next, you need to define the parameters of your rolling forecast, such as the time horizon, the frequency, the level of detail, and the scenarios. You can choose how many periods you want to forecast, how often you want to update your forecast, and how granular you want your forecast to be. You can also create different scenarios to reflect various assumptions and outcomes, such as best case, worst case, or base case. Pastel Accounting allows you to customize your forecast parameters according to your needs and preferences.

3 Create your forecast model

Now, you can start building your forecast model using the data and parameters you have prepared. You can use the Pastel Budget Manager to create your income statement, balance sheet, and cash flow statement forecasts. You can also use the Pastel Report Writer to create custom reports and dashboards. You can apply formulas, functions, and calculations to your forecast model, such as growth rates, margins, ratios, and trends. You can also link your forecast model to your actual data, so that it automatically updates when you import new data.

4 Review and adjust your forecast

Once you have created your forecast model, you need to review and adjust it to ensure that it is realistic, reliable, and aligned with your goals. You can use the Pastel Analysis Tools to compare your forecast with your actual results, historical trends, and industry benchmarks. You can also use the Pastel Scenario Manager to test the impact of different assumptions and variables on your forecast. You can then modify your forecast model accordingly, by changing the values, formulas, or parameters.

5 Communicate and share your forecast

After you have reviewed and adjusted your forecast, you need to communicate and share it with your stakeholders, such as your management, team, or investors. You can use the Pastel Export Tools to export your forecast to various formats, such as Excel, PDF, or HTML. You can also use the Pastel Email Tools to send your forecast via email. You should ensure that your forecast is clear, concise, and relevant, and that you highlight the key insights and recommendations.

6 Repeat and update your forecast

Finally, you need to repeat and update your forecast regularly, based on your predefined frequency and time horizon. You can use the Pastel Update Tools to import new data, refresh your forecast model, and generate new reports. You can also use the Pastel Audit Trail to track and document the changes and revisions you make to your forecast. You should monitor your forecast performance, evaluate your forecast accuracy, and identify any gaps or opportunities for improvement.

7 Here’s what else to consider

This is a space to share examples, stories, or insights that don’t fit into any of the previous sections. What else would you like to add?