Home Academy Video tutorials

Use comparison rows

4:23 min
Use comparison rows
Use comparison rows in a budget or forecast worksheet to automatically include values from another data stream, such as last year's actuals, last year's budget, the current year's forecast and so on. You can use these values in formulas to calculate the new values or simply have it at hand for references purposes.

Supporting documentation

Phocas product
Budgets & Forecasts Budgets & Forecasts
Tags
Phocas Software help and support
Help & support

Have questions or need to report an issue with a Phocas product?

Get support

Related video tutorials

Contribute to the workflow
Budgets & Forecasts Budgets & Forecasts

Contribute to the workflow

Play your part in the budget or forecast workflow. View your assigned tasks, then complete and submit those tasks.
3:03 min
Spread totals
Budgets & Forecasts Budgets & Forecasts

Spread totals

Distribute total values quickly to determine the individual budget values. You can spread a total you manually enter or a total from a comparison stream, either evenly or proportionally across the period.
4:59 min
Explore the forecast workbook
Budgets & Forecasts Budgets & Forecasts

Explore the forecast workbook

This video gives an overview of the key elements of a forecast workbook, including how to save time using the ‘spread’ feature.
2:40 min
Create a forecast
Budgets & Forecasts Budgets & Forecasts

Create a forecast

This video shows how to convert a budget into a forecast. It is suitable for users who have permission to manage budgets and forecasts.
1:23 min