--- title: "Import PCard journal entries in bulk (PAS)" slug: "importing-pcard-journal-entries-in-bulk-pas" updated: 2026-07-07T18:59:32Z published: 2026-07-07T18:59:32Z canonical: "help.wrapbook.com/importing-pcard-journal-entries-in-bulk-pas" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.wrapbook.com/llms.txt > Use this file to discover all available pages before exploring further. # Import PCard journal entries in bulk (PAS) > [!NOTE] > Importing PCard JEs in PAS is permission based > > To import JEs, your account must have one of the following [roles](/v1/docs/roles-permissions) 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)](/v1/docs/about-production-accounting) on film and television productions where the feature has been enabled. Contact your Wrapbook Customer Success Manager or the [Support Team](/v1/docs/how-to-get-help-using-wrapbook) if you don't see the import option. ## Before you start - Your account must have the bulk JE import feature enabled. [Contact Wrapbook Support](/v1/docs/how-to-get-help-using-wrapbook) 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](/v1/docs/add-a-vendor) - Prepare your file using the correct column headers before uploading (see [Step 1](/v1/docs/importing-pcard-journal-entries-in-bulk-pas#0846b14d-a725-4a6b-99cb-fd1dbfa670a8) 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** ![Untitled - 2026-05-26T133824.480.png](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/159ed081-1cdb-4aeb-9091-13feaa8687b0/8fc63303-1f6f-42f7-8c9b-c22ee01349c9?signature=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJwYXRoIjoiL2Y4NWE3MWQ4LTAwMWUtNDg4ZC1hZTkxLWMzOWNiNGYyOWUyOC8xNTllZDA4MS0xY2RiLTRhZWItOTA5MS0xM2ZlYWE4Njg3YjAvOGZjNjMzMDMtMWY2Zi00MmY3LThjOWItYzIyZWUwMTM0OWM5IiwiaWF0IjoxNzc5ODI4MTE3LCJleHAiOjE3Nzk4Mjg0MTd9.CZfXEzQoo3pSENkOlnCwYUwBtSvHm_cL4zQ7HE1Jwn0) *Select* ***Bulk import journal entrie****s* 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. ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/e29cbf40-e5c1-4c7b-8bc4-f9229a722ec4/397b7107-a363-4f44-8cb5-a0802bd3880f) *You can copy and paste spreadsheet data directly into the drawer* ### 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. ![Untitled - 2026-05-26T133925.487.png](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/c7ac61e1-7408-4d05-bb64-82e6131b12b6/cd7c58e9-7056-487e-bc05-4ec8148b3881?signature=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJwYXRoIjoiL2Y4NWE3MWQ4LTAwMWUtNDg4ZC1hZTkxLWMzOWNiNGYyOWUyOC9jN2FjNjFlMS03NDA4LTRkMDUtYmI2NC04MmU2MTMxYjEyYjYvY2Q3YzU4ZTktNzA1Ni00ODdlLWJjMDUtNGVjODE0OGIzODgxIiwiaWF0IjoxNzc5ODI4MTE3LCJleHAiOjE3Nzk4Mjg0MTd9.cELvCqvJzVYi9xHqOh0b0gUwKi66XtSzIf-bVQl9e28) *Hover your cursor over* ***See list of supported columns*** ### 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. ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/15fdc971-936c-4ecc-ab54-3b26831218cb/15046fb7-c079-43a3-954e-a906ff010901) *Click* ***Download a template*** *to save the file to your computer* ### 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. | **Column** | **Header** | **Notes** | | --- | --- | --- | | A | Number | JE or PX number (for example, JE-001, PX-002) | | B | Header description | Description for the journal entry header | | C | Transaction date | Date of the transaction | | D | Period | Accounting period. If left blank, defaults to the current open period | | E | Transaction type | JE or PX — must be the same across all rows with the same number | | F | Vendor name | Required for PX transactions; optional for JE transactions. Must be the same across all rows with the same number | | G | Currency | for example, USD | | H | Account code | Must exist in the project's chart of accounts | | I | Description | Line-level description | | J | Amount | | | K | Asset | | | L | Tax code 1099 | Optional | | M | Vendor 1099 | Optional | | N | Location | | | O | Production | | | P | Set | | | Q | Free field 1 | | | R | Free field 2 | | | S | Free field 3 | | | T | Free field 4 | | **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 ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/6430d265-aa8d-4f15-bb45-e3f8e69d7d9b/2becb499-8bdf-40b8-b669-0b68216eb9fc) Click **the toggle** if you want the first row to be the header. Use the **dropdown options** to map the headers. ## 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 ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/d9b00d1e-4298-4813-a872-bfe90842f381/dee001c1-5e42-4a71-bd49-2412f1332024) A banner at the top summarizes any rows that need attention before you can import ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/5b3d0b8e-6b59-4f80-8824-1f01738098f1/b4aa9a31-65f7-4bac-b4ca-ea1cff6a5ed7) Use the ***All / Valid / Invalid*** tabs at the top of the grid to filter rows by status ### 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. ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/2fafbe80-90eb-41bd-9810-0060db81f360/94766a93-d524-449e-9b37-9410b99b7c61) #### **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** ![](https://uploads.linear.app/f85a71d8-001e-488d-ae91-c39cb4f29e28/dcacb4c5-e979-456c-b2bf-d7adaafad584/5910cd30-e4d1-4ee3-b4d9-70a2f1dc07bb) *Select the header, select the change, and then 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](/v1/docs/add-a-vendor) 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](/v1/docs/create-a-je-pas) - **Film and television only:** Bulk PCard JE import is available for film and television productions only and must be enabled for your account