Enter values into a worksheet
3:08 min
Enter values into a budget or forecast worksheet to complete your tasks in the workflow. Save time using keyboard shortcuts, formulas referencing comparison data, and the copy forward and spread features.
Supporting documentation
Phocas product
Budgets & Forecasts Category
Related video tutorials
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
Budgets & Forecasts How to handle key variables, such as currency, in the budget
Variables such as inflation, exchange rates, price adjustments and so on can impact multiple areas of the budget. In this video Dan shows you how to use a Manual Entry tab to cater for a multi-currency situation. He covers tips such as putting the currencies into working lines on the budget worksheet.
2:57 min
Budgets & Forecasts Use your Sales database to drive the budget
In this video for the Finance Office, Dan shows you how to connect the budget to your Sales database using the Database Driver tab. This pulls in detailed revenue information, which you can map to your financial data and use as the basis to drive the budget. Dan also takes you through adding an additional level of detail that allows you to budget by Sales Rep and product class.
4:59 min
2:32 min