March 2, 2020

5 Things To Do With Wrap Reports

The Wrapbook Team
Free ebook
Download Now
Free Template
Download Now

The shoot has wrapped. Your editors have started assembling the cut. Now comes one of the most important duties a producer has: actualizing the final budget.

Assembled as part of the wrap binder, the final finances of your film will be spun into various reports and budgets you’ll show to your investors, clients, and accountants.

Luckily, if you’re running payroll through Wrapbook, the software will automatically generate a wrap report every time you finish a project. A detailed list of your production’s expenditures, you can easily turn this into many different reports, or just hand it off to your production accountant.

In this post, we’re going to cover 5 things you can do with Wrapbook’s wrap reports.

1. Add accounting codes

In the world of film accounting, every expense and labor component has its own unique accounting code. These numbers allow productions to track how much was spent on every line item.

Wrapbook makes it easy to assign your production’s accounting numbers.

By clicking on “Reports” on your production company dashboard, you’ll be brought to a page where you can access past payrolls, pay stubs, tax documents. Here, you’ll also find wrap reports.

Wrap Reports - Add Accounting Codes - Wrapbook
Click on Wrap Reports to access the wrap reports for each of your productions.

You’ll be prompted to download a .CSV file that you can open in Excel or GoogleSheets. Each line item of your production is organized by crew member name. To the right, you’ll find every detail about each payment automatically imported from Wrapbook.

Wrap Reports - Accounting Codes in Excel - Wrapbook
Once you import a wrap report into Excel, you'll see line items of your entire production's expenses.

To the utmost left, you’ll see a blank space where you can add accounting codes for each item on your budget.

By adding accounting codes, you can actualize your budget and see how your actual costs compare to your estimates.

2. Actualize your AICP Bid Form

If you’re working in commercial production, then there’s a good chance you’re already too familiar with the AICP Bid Form.

If not, the AICP Bid Form is simply a standardized template that production houses use to estimate costs when trying to win clients. Before each production, your producer will painstakingly outline the costs of a commercial going department by department.

Wrap Reports - AICP Bid Form - Wrapbook
The most current AICP Bid Form template, download here.

Using wrap reports, you can easily create a pivot table that matches your AICP Bid Form. Once you’ve loaded your wrap report, select the sheet, and find “Pivot Table” under “Data.”

Wrap Reports - AICP Bid Form in Excel - Wrapbook
Select Pivot Tables under Data to start building a model of the AICP Bid Form.

From there, you’ll be prompted to build a custom table, where you can add rows and columns based on your production’s raw data. In the case of an AICP form, you’ll want to add rows by title and columns by count of days worked and average of day rate.

Wrap Reports - Build Pivot Table in Excel - Wrapbook
Build your pivot table according to what information you need to pull.

You’ll see a detailed chart that will break down your costs by department. If you add accounting codes beforehand, based on the AICP Bid Form, you can also sum up totals by each number, saving time and stress when prepping the final budget.

What are pivot tables?

Whether you use budgeting software or have your own tried and true free budgeting template, having a grasp on Excel is a must in the world of budgeting. After all, Excel and film budgets go together like 1st ADs and Red Bull.

Perhaps one of the best tools in Excel (and GoogleSheets) is the pivot table.

Pivot tables are an incredible way to manipulate your project's finances to spin up all types of documents.

Once you select your data, you can use pivot tables to create graphs and tables, using any parameter your accountant calls for. While we’ll go over in depth below, it’s not a bad idea to watch this video to get a sense of how they work.

Like call sheets, pivot tables are fairly easy to use once you make one.

3. Import your wrap report into Hot Budget

Hot Budget is one of the most popular tools available to (you guessed it) budget film production projects.

While the software doesn’t allow you to run production payroll, it can be a great way to track spending before, during, and after your production ends.

Importing your production’s payroll into Hot Budget is easy.

Once you download your project’s wrap report as a CSV file, it’s ready to import into Hot Budget. That’s it.

For more detailed instructions, you can always reference their user manual. However, it’s just like importing any other spreadsheet into the software.

4. Import your wrap report into Movie Magic Budgeting

In many ways, Entertainment Partners’ Movie Magic Budgeting is one of the industry leaders when it comes to budgeting film projects.

Importing your payroll information from Wrapbook could not be easier.

Once you download your wrap report, open it in Excel. Resave the file as “.XLSX,” which is the file type for Excel sheets. From there you’ll be able to import into Movie Magic Budgeting.

5. Break out labor & expenses

When it comes to preparing your wrap binder, a deeply important question is “How much money was spent on labor vs. expenses?” Using a pivot table, you can easily get a breakdown of these costs.

After opening your wrap report in Excel, select the entire spreadsheet, click “Data”, and then “Pivot Tables.”

Wrap Report - Excel - Wrapbook
By filtering to Description you can aggregate all payments that fall under Labor.

For this pivot table, you should make your rows by description and title and your columns by sum of the day rate. You’ll then be able to view the breakdown of your production by labor and expenditures.

Wrapping up

Every production company is different and will have its own way of doing things. Wrap reports allow you to export all of your production’s data, so you can handle accounting exactly how you want to. With the right software, you can simplify this process.

Reach out to our payroll specialists to learn how, or watch the Wrapbook demo.

Last Updated 
March 2, 2020


At Wrapbook, we pride ourselves on providing outstanding free resources to producers and their crews, but this post is for informational purposes only as of the date above. The content on our website is not intended to provide and should not be relied on for legal, accounting, or tax advice.  You should consult with your own legal, accounting, or tax advisors to determine how this general information may apply to your specific circumstances.

About the author
The Wrapbook Team

The Wrapbook Team consists of individuals who are thrilled about building modern software tools for creators. We’re a team of compassionate and curious people dedicated to solving complex problems with sophisticated solutions. You can find us across the U.S. and Canada.

Stay In The Know

Sign up for the Wrapbook newsletter where we share industry news along with must-know guides for producers.