Budgets & Forecasts

In this session, learn how to:

• Set up a budget workbook and assign tasks to contributors using role-based access
• Accept or reject submissions, add comments, and track changes through workflow history
• Publish a completed budget so it flows through to Financial Statements and Analytics
• Compare actuals vs budget, save favorites, and build a dashboard to track actuals against budget

In this session, learn how to:

• Set up and configure the balance sheet driver tab in a budget workbook
• Map balance sheet line items to GL accounts so they populate automatically from your P&L
• Model working capital items such as receivables, payables, and inventory
• Validate your balance sheet and understand how it feeds directly into your cashflow forecast

In this session, learn how to:

• Understand how the cashflow tab is automatically derived from your P&L and balance sheet, and how to manage it
• Adjust key assumptions such as receivable days and inventory levels, and see the impact on projected cash
• Model cashflow scenarios to understand the cash implications of different business decisions
• Publish your P&L and balance sheet, then create a scenario in Financial Statements to derive and report your cashflow

In this session, learn how to:

• Use the Lookup tab to isolate key assumptions (such as sales growth, pricing, and margin)
• Use the scratchpad to model what-if scenarios without affecting your live budget
• Use baseline and comparative data to understand the scale of change between scenarios
• Clone an existing workbook to build and manage alternative scenarios
• Publish alternative scenarios as separate streams and compare them in Financial Statements