--- title: "Payroll Log (payroll level)" slug: "payroll-log-payroll-level" tags: ["automap", "caps", "caps csv", "export caps", "export movie magic", "map", "Showbiz", "wage file"] updated: 2026-07-07T19:12:30Z published: 2026-07-07T19:12:30Z canonical: "help.wrapbook.com/payroll-log-payroll-level" --- > ## 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. # Payroll Log (payroll level) ## About the payroll-level Payroll Log The payroll-level Payroll Log provides a detailed, line-by-line breakdown of all payroll activity within a specific payroll run. It’s your go-to report for reviewing, reconciling, and exporting payroll data to budgeting software like CAPS+, Hot Budget, Acumatica, Showbiz, and Saturation.io. ## Ways to use the log The payroll-level *Payroll Log* is a vital tool for: **Payroll reconciliation** - Ensure every payment matches hours worked, rates, and deductions **Budgeting and cost tracking** - See the full breakdown of labor costs to compare against your department or project budgets **Wrap reporting** - Include in your final wrap package to deliver a full audit trail of payroll activity **Union and compliance requirements** - Provide detailed wage data to satisfy guild or labor requirements **Software integration** - Seamlessly export data into budgeting software for financial planning ## What’s included in the log The payroll-level *Payroll Log* includes detailed payroll data per worker and pay item, such as: - Worker Name - Worker Type (W-2 or 1099) - Position/Title - Work Date - Hours Worked - Pay Rate - Earnings Type (e.g., Regular, Overtime, Holiday) - Gross Wages - Deductions - Reimbursements - Employer Taxes - Benefits Contributions - Net Pay - Payment Method - Department or Cost Code (if assigned) - Payroll Run Date - Project Name ## Generate the payroll-level Payroll Log To generate the *Payroll Log* for a specific payroll run: 1. In the left-side navigation, click the dropdown menu 2. In the dropdown menu, select the project that you want to generate the payroll-level *Payroll Log* for 3. In the left-side navigation, click to expand the **PAYROLL** menu, then click **Payroll batches** 4. On the *Payroll batches* dashboard, click the **Complete** tab to see batches that have finished processing 5. Find the batch you want, then click the batch name or the **View** button next to it 6. At the top of the *Batch* page, click the **Export all to PDF** button or the **Payroll Log** button to see your export options ## Payroll Log export types When you generate a payroll-level *Payroll Log*, you’ll have the option to export the file so it’s compatible with other accounting software. Click the arrow next to each export type to see what’s included in the report. #### CAPS+ Payroll Log exports The CAPS+ format is designed to make it easy to import Wrapbook payroll data into industry-standard budgeting tools like: - Showbiz Budgeting - Hot Budget - Movie Magic (with manual adjustment) **This format ensures your data is structured correctly for:** - Actuals tracking - Payroll-to-budget reconciliation - Cost reporting by department or GL code - Wrap book preparation **The *CAPS+ Payroll Log* typically includes the following columns:** - Employee Name - Employee ID - Position/Title - Earnings Type (e.g., Regular, Overtime, Holiday) - Pay Type (Hourly, Daily, Weekly, etc.) - Work Date - Start Time (if available) - End Time (if available) - Hours Worked - Rate - Gross Wages - Fringes/Employer Burden (itemized or total fringe amount) - Deductions (e.g., union dues, advances) - Reimbursements - Net Pay - Department Code or Cost Code - GL Code (if set up in your account) - Payroll Run ID - Payroll Date - Project Name or Project Code #### Hot Budget Payroll Log exports The *Hot Budget Payroll Log* export is specifically formatted to work with *Hot Budget* which is a production budgeting tool. This export includes detailed, line-by-line payroll data that maps directly to Hot Budget's actuals import template, helping you quickly and accurately track labor costs against your budget. [Click here to see step-by-step instructions for exporting a payroll log to Hot Budget.](/v1/docs/export-a-payroll-log-to-hot-budget) **This export format is ideal when you want to:** - Import payroll actuals directly into Hot Budget - Reconcile payroll costs with your budget categories - Ensure accurate departmental and GL coding - Track actuals vs. estimated labor expenses in real time **The *Hot Budget Payroll Log* export typically includes the following columns:** - Employee Name - Employee ID (if available) - Position/Title - Work Date - Earnings Type (e.g., Regular, Overtime, Holiday) - Pay Type (Hourly, Daily, Weekly, etc.) - Rate - Hours Worked - Gross Wages - Fringes (total fringe amount per line item) - Net Pay - Reimbursements - Deductions - Check Number (if applicable) - Payment Method (e.g., Direct Deposit, Check) - Payroll Run Date - Department Code or Cost Code (if assigned) - Project Name or Project Code - GL Code (if configured in your Wrapbook project settings) **Tip:** Make sure your department and GL codes in Wrapbook match those in your Hot Budget template for seamless syncing. #### Acumatica - NFS Payroll Log exports The *Acumatica Payroll Log* export is tailored for companies that use *Acumatica* as their accounting or enterprise resource planning (ERP) system. This export provides a structured dataset designed to align with Acumatica’s journal entry and payroll import templates, making it easy to import labor costs directly into your financial system. **The Acumatica-formatted export is ideal for:** - Automating journal entry creation for payroll expenses - Mapping labor costs to specific GL accounts and departments - Project-based accounting when tracking production costs - Streamlining data entry into Acumatica without manual reformatting - Ensuring compliance with your company’s financial reporting standards **The *Acumatica* *Payroll Log* export typically includes the following columns:** - Batch ID (or Payroll Run Identifier) - Transaction Date (e.g., payroll run date or work date) - Employee Name - Employee ID (if available) - Position/Job Title - Earnings Type (e.g., Regular, Overtime, Holiday) - Department or Cost Center - Account Code / GL Account - Project Code (if using Acumatica Projects module) - Payroll Item (Wages, Fringe, Tax, Deduction, Reimbursement, etc.) - Amount - Debit/Credit Indicator - Memo/Description (usually includes worker name, project, or notes) - Payment Method - Check Number (if applicable) - Pay Period Start & End Dates **How to use this export with Acumatica:** 1. Review the file in *Excel* or *Google Sheets* to verify data 2. Import the file into *Acumatica* using your organization's payroll or journal entry import tool **Tip:** Make sure your GL codes and cost centers in Wrapbook match your Chart of Accounts in Acumatica for a seamless import. #### Showbiz Payroll Log exports The *Showbiz Payroll Log* export is specifically formatted to work with *Showbiz Budgeting*, a tool used in film and televisionproduction accounting. This export is designed to align with Showbiz’s *Import Actuals* format, allowing you to easily import payroll data and track actual labor costs against your budget. **This export is especially useful for:** - Importing actuals into *Showbiz Budgeting* to track real-time labor costs - Reconciliation of estimated vs. actual payroll - Department-level cost tracking and reporting - Production wrap book creation - Reducing manual data entry and formatting errors **What’s included** The *Showbiz* export typically includes one row per line item worked (for example: per day, per worker) and contains the following key fields: - Employee Name - Employee ID (if available) - Position / Job Title - Department (if assigned in Wrapbook) - Earnings Type (e.g., Regular, Overtime, Holiday) - Pay Type (Daily, Hourly, Weekly, etc.) - Work Date - Hours Worked - Rate - Gross Wages - Fringe Amount (total employer-paid fringe cost) - Deductions (e.g., union dues, loan repayments) - Reimbursements - Net Pay - Payment Method (Direct Deposit, Check, etc.) - Check Number (if applicable) - Payroll Run Date - GL Code or Cost Code (if set up in Wrapbook) - Project Name or Project Code **How to use this export with Showbiz:** 1. Open the exported file to review in *Excel* or *Google Sheets* 2. In *Showbiz Budgeting*, go to *Import Actuals* 3. Select the file and match any necessary fields (GL codes, employee names, etc.) **Tip:** Make sure department names and GL codes in Wrapbook match your budget categories in Showbiz for smooth integration. #### Saturation.io Payroll Log exports The *Saturation.io Payroll Log* export is specifically formatted to work with *Saturation.io*, a tool used in film and television production accounting. This export is designed to align with *Saturation.io* import actuals format, allowing you to easily import payroll data and track actual labor costs against your budget. **This export is especially useful for:** - Importing actuals into *Saturation.io* to track real-time labor costs - Reconciliation of estimated vs. actual payroll - Department-level cost tracking and reporting - Production wrap book creation - Reducing manual data entry and formatting errors **What’s included** The *Saturation.io* export typically includes one row per line item worked (for example: per day, per worker) and contains the following key fields: - Employee Name - Employee ID (if available) - Position / Job Title - Department (if assigned in Wrapbook) - Earnings Type (e.g., Regular, Overtime, Holiday) - Pay Type (Daily, Hourly, Weekly, etc.) - Work Date - Hours Worked - Rate - Gross Wages - Fringe Amount (total employer-paid fringe cost) - Deductions (e.g., union dues, loan repayments) - Reimbursements - Net Pay - Payment Method (Direct Deposit, Check, etc.) - Check Number (if applicable) - Payroll Run Date - GL Code or Cost Code (if set up in Wrapbook) - Project Name or Project Code **How to use this export with Saturation.io:** 1. Open the exported file to review in *Excel* or *Google Sheets* 2. In Saturation.io, go to the *Actuals* section and click **Import** 3. Select the file and match any necessary fields (GL codes, employee names, etc.) **Tip:** Make sure department names and GL codes in Wrapbook match your budget categories in Saturation.io for smooth integration. A process that traces the complete history of the detailed transactions relating to any item in accounting records An IRS form by which specific income (such as non-employee compensation, royalties, etc.) is reported to the federal government. Equivalent to a W-2 for independent contractors where remuneration is not being paid by the employer. (General Ledger) Original and detailed book of record for all accounting transactions arranged by departmental account codes that occurs throughout the lifetime of a production. The additional employer's cost of hiring labor over and above salary; includes statutory charges such as payroll taxes as well as benefits negotiated under a collective bargaining agreement. The master list of all the accounts used to track production costs, expenses, assets, liabilities, and income. These also can be referred to as Cost Accounts. In commercials, typically AICP line numbers are utilized in its stead. The process of tracking expenses during pre-production, production, and post-production.