Cost reports (PAS)

Overview

A cost report in Wrapbook compares budgets to actual expense transactions, including purchase orders (POs)

Cost reports can be used by production accountants to:

Track budget versus actual spending
Monitor department costs
Forecast remaining expenses

Cost reports can be generated to include any of the following:

Summary view
Detail view
Combined summary/detail

Cost reports can be exported in multiple formats:

PDF
XLSX (Excel)
CSV (raw data export)

How to create a cost report

In order to create a cost report, Wrapbook’s Production Accounting Suite must be enabled.

Once PAS is enabled, you can begin creating your report by going to Accounting reports dashboard:

In the left-side navigation, click the dropdown menu
In the dropdown menu, select the name of the project that you want to create a cost report for
In the left-side navigation, expand the ACCOUNTING menu, and click Accounting reports
On the Accounting reports dashboard, click the Create report button next to Cost report

Accounting reports section with options for general ledger, trial balance, and cost report. — *Select a project, expand the ACCOUNTING menu, click Accounting reports, and then click the Create report button next to Cost report*

Cost report generation interface showing filters, budget details, and report settings. — *Screenshot of the Generate a cost report page*

With PAS enabled, you can also access cost reports from the project’s Budget/EFC dashboard:

In the left-side navigation, click the dropdown menu
In the dropdown menu, select the name of the project that you want to create a cost report for
In the left-side navigation, expand the ACCOUNTING menu, and click Budget/EFC
On the Budget/EFC dashboard, click the Cost report button

Budget management interface displaying various budget entries and their details. — *Select a project, expand the ACCOUNTING menu, click Budget/EFC, and then click the Cost report button*

Cost report filters

You can apply the following filters to the cost report:

Period range
Transaction date range
Posted date range
ACCT numbers
LO
PRD
SET
FF1

Budget management interface displaying filters for transaction and account dates. — *Screenshot of the cost report filter options*

Cost report settings

Before you generate a cost report, you’ll be required to enter the following information in the Report settings section:

Report title
Report type (Detail or Summary)
Export format (PDF or CSV)
Page size (Letter, Legal, Ledger/RA3 or 2x Ledger/RA2)

You’ll also have the the options to:

Show $0 accounts
Show period variance
Edit the report columns

You can click the Edit report columns button to enable editing of the following:

Account
Description
Period actuals
Actuals to date
POs
Total to date
ETC
EFC
Budget
Approved overages
Total budget
Variance
Period variance
Percent complete -this column of the cost report displays the percentage of completed spend within each account, giving you a clearer view of progress against budget. By default, Percent complete is turned off, but you can display it by clicking the checkbox in the Edit report columns popup.

Settings for generating a detailed cost report in PDF format with specific options. — *Screenshot of the cost report settings options. Click the* ***Edit report columns*** *button to choose which columns to include or exclude from the report.*

Options to edit report columns including account, budget, and variance settings. — *Click the checkboxes to edit the cost report columns, then click the* ***Save*** *button*

Preview your cost report

In the Report preview section of the Generate a cost report page, you can see how the report will appear based on the filters and settings you’ve applied.

Generate your cost report

On the Generate a cost 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.