EFC variance report (PAS)

Overview

The EFC variance report compares the estimated final cost changes within a selected period. This report is similar to a cost report, but focuses exclusively on EFC changes by removing all PO and Actual amounts, while adding detailed explanations and identifying which team members made each modification.

This report provides production teams with clear comparisons between reporting periods, enabling you to:

• Visualize exactly what changed between periods with intuitive highlighting

• Understand the why behind every variance with detailed explanations

• Identify potential budget risks before they impact your bottom line

• Eliminate time-consuming manual tracking across systems

• Customize views to match your specific reporting requirements

How to create an EFC variance report

In order to create an EFC variance report, Wrapbook’s Production Accounting Suite must be enabled.

Once PAS is enabled, you can begin creating your report by going to the Generate an EFC variance report page:

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

2. In the dropdown menu, select the name of the project that you want to access the EFC variance report for

3. In the left-side navigation, expand the ACCOUNTING menu, and click Accounting reports

4. On the Accounting reports dashboard, click the Create report button next to EFC variance report

What do you want to see in this report?

On the Generate an EFC variance report page, under What do you want to see in this report?, you can use simple conversational language to describe what data you want to include in the report.

Here’s how it works

• Under What do you want to see in this report? type a description of the data you want to show in the report

• For example: Show me all accounts that had a variance of more than $1,000 last period

EFC variance report manual filters

You can also click on any of the filter fields listed to apply to the report.

EFC variance report settings

In the Report settings section, you’ll have the option to configure the report in the following ways:

• Thousands separator - If you want to display a thousands separator on your report amounts, click to enable this option

• Export format (PDF or CSV)

• Page size (Letter, Legal, Ledger/RA3 or 2x Ledger/RA2)

• Show cents - If you want your report amounts to include cents, click to enable this option

• Report name

• Report type (Summary, Detail, Summary & Detail)

Customize

Under Report columns, you can click the Customize button to the following columns:

• Account

• Description

• Budget

• Approved Overages

• Total Budget

• Previous EFC

• Current EFC

• EFC Variance

• Explanation

• Changed by

After clicking Customize, use the customize Report Columns popup to:

• Select or remove columns — check or uncheck the boxes next to each column name

• Rename a column — click an existing column name and type a new one

• Reorder columns — hover over the four-dot icon to the left of a column name, then drag it to a new position

Preview your EFC variance report

In the Report preview, you can see the types of data that will appear in the report based on the filters and settings you’ve applied.

Generate your EFC variance report

• On the EFC variance report page, click the Generate report button

• After you click the button, your report will begin automatically downloading to your computer. You’ll receive an email once it’s ready.

Create an EFC variance report template

Report templates allow you to save your preferred settings for your EFC variance reports. Instead of adjusting settings every time you generate a report, you can create and save templates for quick access to your preferred views.

Create a template

1. Go to the Generate an EFC variance report page

2. In the Apply filters section, add the filters that you want to use for your report template. Use the Report preview to see an overview of what will be included in the report.

3. Once you are satisfied with the way the report is configured, click the Create template button

4. In the Create template popup, enter a template Name. You can click the checkbox to Set as default (optional).

5. Click the Save button

6. The template that you’ve just created will now appear as an option in the Custom template dropdown menu when you return to the Generate report page. If you set the template to be the default, it will automatically be selected in the dropdown menu.

Set as default, rename, duplicate, or delete an existing template

Once a template has been created, you can set it as the default, update its name, duplicate it, or delete it using the following steps:

1. Go to the Generate an EFC variance report page

2. On the Generate an EFC variance report page, under Templates, click the dropdown menu to select the template that you want to update

3. Click the gear icon, and then select an option: Set as default, Rename, Duplicate, or Delete

Updating a template

• If you make changes to a template, a Save changes button will appear next to the template’s name

• To preserve the changes be sure to click the Save changes button before running a report or leaving the page