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

EFC variance report quick filters

On the Generate an EFC variance report page, you can use the Quick filters section to pull and analyze your data using simple, conversational language.

Here’s how it works

• In the Quick filters section, click the +

• Under What kind of report do you need? type your request

• Click the Update filters button

To provide feedback on prompt suggestions, click either of the thumbs up/thumbs down icons in the bottom corner of the Quick filters section.

Quick filter tips

The Quick filters section can process most natural language queries that are based on the following filters:

• Budget

• Period

• Account

• Variance amount

The Quick filters feature works best when you’re specific about the information you're looking for. Be sure to include relevant dates, periods, or account codes in your query.

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

EFC variance report manual filters

If you don’t want to use the Quick filters, you can 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)

Edit report columns

You can choose the columns that you want to show or hide in your EFC variance report by doing the following:

1. In the Report settings, click the Edit report columns button at the bottom of the section

2. In the popup, click to select/de-select the checkboxes next to any of the column headers listed

3. Click the Save button

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. In the left-side navigation, click the dropdown menu

2. In the dropdown menu, select the project that you want to create an EFC variance report template for

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

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

5. 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.

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

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

8. Click the Save button

9. 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. In the left-side navigation, click the dropdown menu

2. In the dropdown menu, select the project that you want to update an EFC variance report template for

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

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

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

6. 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