Import PCard journal entries in bulk (PAS)

Importing PCard JEs in PAS is permission based

To import JEs, your account must have one of the following roles enabled:

• Role: Company Admin, Accountant

• Custom role with: Journal entries - Full access, Create and manage

Overview

If your production uses PCards, you can now import multiple journal entries into Wrapbook at once — uploading a file or pasting data directly — instead of entering each transaction one at a time. This is especially useful for productions processing large volumes of PCard envelopes, where uploading files individually creates unnecessary risk of errors.

The bulk import is available to companies that have enabled Wrapbook's Production Accounting Suite (PAS) on film and television productions where the feature has been enabled. Contact your Wrapbook Customer Success Manager or the Support Team if you don't see the import option.

Before you start

• Your account must have the bulk JE import feature enabled. Contact Wrapbook Support if you don't see this option.

• All vendors referenced in your import file must already exist in Wrapbook. You cannot create new vendors from within the import flow.

  • To create a new vendor in Wrapbook, see Add a vendor

• Prepare your file using the correct column headers before uploading (see Step 1 below)

Step 1: Prepare your file and open the import

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

2. In the left-side navigation, expand the ACCOUNTING menu and then click Journal entries

3. On the project's Journal entries dashboard, click the arrow within the + Create journal entry button and then select Bulk import journal entries

In the Bulk import journal entries drawer, you'll bring your data into Wrapbook. You have two options:

• Upload a file — Click the Choose a file button to upload a CSV file from your computer

• Paste your data — Copy your data directly from a spreadsheet and paste it into the drawer

Either way, your data must use the correct column headers before you proceed. You have three options for getting your data ready:

Option 1: Copy and paste directly from your spreadsheet

If your data is already in a spreadsheet that uses the correct column headers, you can copy the data and paste it directly into the box in the drawer — no file upload needed.

Use this option when your spreadsheet is already formatted correctly and you want to bring the data in quickly without saving a separate file first.

Option 2: Copy the required headers into your existing file

Hover over See list of supported columns in the drawer to view all required and optional column headers.

Use this option if you've already prepared your data in a spreadsheet and just need to match the header names — it's faster than starting from scratch.

Option 3: Download the CSV template

The drawer also gives you the option to download a pre-formatted CSV template with the correct headers already in place.

Use this option if you're starting fresh or want to ensure your file structure is exactly right before entering data.

CSV column reference

Your file should use the following headers. Columns A–G are header fields that apply to the journal entry as a whole. The remaining columns are distribution line fields that apply to each individual line.

Note: Header fields (columns A–G) must be consistent across all rows that share the same journal entry number. If they differ, Wrapbook will flag those rows as errors in the review step.

Step 2: Map your columns

After uploading or pasting your data, Wrapbook takes you to the Map your columns screen.

• Confirm that the toggle The first row is a header is enabled if your file includes a header row

• Wrapbook automatically matches each column in your file to the corresponding field. If it can't find a match, it will suggest the closest option or set the column to Ignore

• Review each column mapping. Adjust any that aren't correct using the dropdown options.

• When you're confident everything is mapped correctly, click the Continue button

Step 3: Review and fix errors

The review screen shows all rows from your file in a grid, grouped by journal entry. A banner at the top summarizes any rows that need attention before you can import:

X rows need attention before import. Correct the errors below before continuing or choose to only import valid rows without errors.

Use the All / Valid / Invalid tabs at the top of the grid to filter rows by status.

Use the Filter by issue type links to see which rows are affected by each error type. Common errors include:

• Production episode: Please fill out this field

• Vendor name: Must be the same across all rows with this JE number

• Transaction type: Must be the same across all rows with this JE number

• Transaction date: Must be the same across all rows with this JE number

• Account code: Doesn't exist in the project's chart of accounts

Fixing errors directly in the grid

You can correct errors without re-uploading your file. The review grid uses a nested grid — each journal entry is a collapsible group with its header row and individual distribution lines.

Fixing header-level fields (for example, period, transaction type, vendor)

Edit any header-level cell directly in the grid. When you click out of the row, Wrapbook automatically applies the change to all rows in that journal entry.

Fixing multiple rows at once

1. Select the rows you want to update using the checkboxes

2. Click Bulk edit (bottom right of the screen)

3. In the Bulk edit popup, choose the column you want to change and the new value

4. When you’re ready, click the Apply button

Fixing line-level fields (for example, account code)

Click the Invalid tab to filter to only rows with errors. Edit the field directly in the grid row.

Tip: You don't need to fix every error before importing. You can choose to import only the valid rows and address the remaining ones separately.

Step 4: Import your entries

Once errors are resolved (or you've decided to proceed with only valid rows), click Import [X] rows to complete the import.

Wrapbook processes the file and creates the journal entries. You can review the newly created transactions on the project's Journal entries dashboard — each import appears as a separate transaction.

Notes

• New vendors: You cannot create vendors from within the import flow. If a vendor in your file doesn't exist in Wrapbook, that row will show an error. Add the vendor manually first, then re-import.

• Manual entry still available: Bulk import is an additional option — you can still create journal entries one at a time using the standard workflow

• Film and television only: Bulk PCard JE import is available for film and television productions only and must be enabled for your account