Home Academy Video tutorials

Use your Sales database to drive the budget

4:59 min
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.
Phocas product
Budgets & Forecasts Budgets & Forecasts
Phocas Software help and support
Help & support

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

Get support

Related video tutorials

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
How to handle key variables, such as currency, in the budget
Budgets & Forecasts 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
Workflow history
Budgets & Forecasts Budgets & Forecasts

Workflow history

See history of cells and workflow.
2:32 min