Manage budgets and forecasts

Learn how to create a budget workbook by naming it, choosing a database, setting the budget period, and deciding how to populate it, for example with last year's actuals or all zeros. You'll also review hierarchy settings, see why to finalize the setup before budgeting begins, and manage access and permissions for administrators.

Learn how to add detail when changing the budget setup isn't practical, by adding database or balance sheet tabs and new rows on the main tab. You'll see how a database tab drives values into the main tab, how a balance sheet tab adds a cash flow tab for a three statement model, and how to add accounts or entities.

Learn how to configure comparison rows that appear beneath each budget row, starting from the default of last year's actuals. You'll change the stream, measure, and offset, add more comparison rows, apply custom formatting, and see how contributors can show or hide them while variance percentages update as they edit.

Learn how to publish a budget from an output tab by creating a new stream, publishing to an existing stream, or exporting to Excel. You'll also learn which options control what gets published, such as completed rows only, zero-value rows, and a date range, and how to open the published data afterward.

Learn how to create a budget at the regional and branch level using Financial Statements and Budgets and Forecasts together. You'll set up levels and a budget period, assign sections to region and branch managers, and review, approve, and submit their budgets through to the admin.

Learn how to cater for multiple currencies in a budget created in one base currency by adding a manual entry driver tab for key variables such as exchange rates. You'll then use working lines to convert local currency values back to that base currency and search for everywhere a currency is referenced.