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
Category
Phocas Software help and support
Help & support

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

Get support

Related video tutorials

Create a sales budget with multiple drivers
Budgets & Forecasts Budgets & Forecasts

Create a sales budget with multiple drivers

Dan demonstrates how to create a Sales budget using multiple measures for driver-based budgeting. In this example, Dan brings in quantity, price and margin as additional values and uses them to calculate cost of sales, as well as adding working and reference lines to help drive the budget.
3:35 min
Generate a budget based on previous sales (custom mode)
Analytics Analytics

Generate a budget based on previous sales (custom mode)

Learn how to use custom mode to build next year’s budget based on the past two years’ sales, and take forecasting further by analyzing individual reps and their product classes.
2:49 min
Track sales rep performance against budget
Analytics Analytics

Track sales rep performance against budget

Learn how to add a budget stream to your sales analysis, enabling you to drill into your sales figures to see how your budget is tracking. In a few steps, see which sales reps are performing well - and which ones aren't.
1:32 min
Create a budget from within financial statements
Financial Statements Financial Statements

Create a budget from within financial statements

Learn how to quickly create a profit and loss budget from your financial statements using one click budgeting and start working in a ready-to-use workbook.

1:04 min
NewSee the latest features, improvements and what's new in productView product updates