Common approaches your colleagues
use to forecast in Dynamic Budgets
1. Duplicate your line item details and full payroll from your original budget.
- Mark it as a forecast in Manage Budgets to override Jan-Mar budget values with Actuals.
- Have your staff update the remaining months.
2. Same as Above, but Lock the original copied rows.
- Your staff will insert additional lines below the grey locked rows to notate increase or decrease adjustments
3. Edit a single blended row of YTD Actual & Budget (or PY, or Annualized)
- Import that single line of data into each account
- Allow users to simply overwrite with new values in the single row of data.
4. Same as Above, but Lock the first row.
- Lock the single line base projection.
- Your staff will insert additional lines below the grey locked rows to notate increase or decrease adjustments
5. Use a simple 4 line standard calculation for each account
- Import a blend of YTD Actual & Budget (or PY, or Annualized)
- Multiply by a change percent
- and/or enter a dollar adjustment amount
- to calculate the result
- This can be done with Copy Bulk Assumptions to embed this in individual accounts
or we can set up a Custom Worksheet to do this for a large volume of accounts on 1 screen.
If you need help setting up forecasts
please schedule an appointment with our support staff.