Budget/EFC dashboard (PAS)

Prev Next

This help article is related to the Production Accounting Suite (PAS)

In Wrapbook, production accountants and administrators can manage budgets using either the Production Accounting Suite or Cost tracking. To understand the differences, click here.

The Production Accounting Suite (PAS) is permission based

To access PAS features in Wrapbook, your account must have one of the following roles enabled:

  • Role: Company Admin, Accountant

  • Custom role with: Accounting & Cost Tracking / Budgets (Production Accounting) - Full access

Overview

The Budget/EFC dashboard in the Production Accounting Suite (PAS) is where you can manage and track all costs associated with a production project.

Access the Budget/EFC dashboard

  1. Make sure Production Accounting has been enabled for your company’s account

  2. In the left-side navigation, click the dropdown menu

  3. In the dropdown menu, select the project that you want to see the Budget/EFC for

  4. In the project dashboard’s Budget & EFC overview, click View budget

Budget/EFC dashboard layout

The Budget/EFC dashboard displays totals in the column headers.

  • These totals update in real time as you enter or change values in the grid.

  • The column headers remain visible as you scroll, so you can continue to see the balances while working on lower accounts.

Use the tabs above the grid to switch between the default view and any custom views you have saved.

  • Select + to create a custom view (tab), enter a name, set the filters you want to save, and select Save. Your saved view retains its filter selections when you return to it.

Dashboard elements

The Budget/EFC dashboard contains the following information:

Project budget overview

At the top of the budget is an overview of real-time totals for:

Overview

Definition

Period activity

Sum of items posted within the current period

Activity to date

Sum of items posted up to and including the current period

Purchase orders

Sum of open PO commitments up to the current period

Total to date

Sum of (Activity to date + Purchase orders)

Estimated to complete (ETC)

Sum of (Estimated Final Cost -Total to date)

Estimated final cost (EFC)

The expected total spend at completion based on current information. Often user-entered or imported, then updated as actuals and commitments change.  

Total budget

Sum of (Budget + Approved overages)

Variance

Sum of (EFC - Budget)

Period variance

Sum of (Current-period EFC -  Prior-period EFC)

Filters

Available filters depend on the project and may include:

  • Location

  • Production/episode

  • Free fields

  • Sets

  • Effective Date - Select Effective Date from the filter menu and choose a From and To date

  • ETC - For the ETC filter, choose Any, Non-zero, or Negative only

  • Posted date

  • Period - By default, the Period filter is set to Current period. You can select any other period available for the project.

  • Show $0 accounts - By default, accounts with no budget and no actual costs are hidden. Use Show $0 accounts to include or hide zero-dollar accounts.

  • Transaction date

Notes:

  • You can filter by Period or Effective Date, but not both at the same time. Selecting one removes the other.

  • When you select a current or future period, editable amounts remain editable

  • When you select a previous period, the grid displays the values for that period and the amounts become read-only. This lets you review prior-period activity and budget values without leaving the Budget/EFC dashboard.

  • When you select an effective date within an open period, the amounts remain editable

  • When you select an effective date in a previous period, the amounts become read-only

  • Filters selected in the Budget/EFC dashboard carry forward when you generate a Cost report

  • Select Clear filters to return to the default filter state. Filters reset when you refresh the page or leave and return to it; saved custom views retain the filters saved with the view.

Project budget details & settings

On the Budget/EFC dashboard you can:

  • Click the Details tab to see a breakdown of the line items within each ACCT section

  • Use the Search box to find specific line items

  • Click the toggle next to Show $0 accounts to hide/show ACCTs with no entries

  • Use Display to show or hide available columns. Some columns may be required and cannot be hidden. Select a column header to sort the grid with one click.

  • Select the gear icon to review or edit the budget settings, including the budget name, default production codes, whether cents are displayed, whether the budget is locked, and whether approved overages are enabled

Budget details are listed under the following headers:

Header

Definition

ACCT

The account code tied to your project’s Chart of Accounts (COA). Each line item is tracked against its account number.

Description

The label or name of the account or cost code, such as Cast or Equipment Rental

Period actuals

The amount of money actually spent during the current reporting period (for example: this week or this month)

Actuals to date

The total of all actual costs incurred from the start of the project through the current period

POs

The dollar value of committed costs from purchase orders associated with the account. These are funds reserved but not yet fully expensed.

Total to date

A combined figure showing Actuals to date plus committed POs. Represents everything spent or committed so far.

ETC (Estimate to Complete)

The projected costs still expected to be incurred for the account from today until project completion

EFC Budget (Estimated Final Cost)

The running forecast of what the total cost will be for the account by the end of the project

Formula: EFC = Actuals to date + POs + ETC

Variance

The difference between the EFC Budget and the original budgeted amount. Shows if you’re tracking over or under budget.

Period variance

The difference between actual costs for the current period and what was budgeted for that same period

EFC reason

A short explanation provided by the production accountant when updating or overriding an EFC value, recording why the forecast was changed (for example: vendor quote revised)

Budget summary

  • Click the Summary tab to see a summary of each ACCT section

Entering in-cell calculations

When editing budget cells, you can type a value to adjust directly in the cell , without calculating the new total yourself. This is useful when moving money between accounts or making incremental adjustments.

How it works:

  • To add to the current amount: click the cell, type + followed by the value you want to add, and press Tab or Enter

  • To subtract from the current amount: click the cell, type - followed by the value you want to remove, and press Tab or Enter

The cell will automatically calculate and display the updated value. All related totals — including EFC, variance, and period totals — will update accordingly.

Generate reports from the Budget/EFC dashboard

Click Reports to open a Cost report, EFC history report, or EFC variance report.