Payroll Log (payroll level)

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

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.

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)

How to use the export with Hot Budget:

1. Open the file to review the data in Excel or Google Sheets

2. In Hot Budget, go to the Actuals section

3. Use the Import Actuals tool to bring in the CSV file

4. Map any necessary columns (if prompted) to ensure alignment

Tip: Make sure your department and GL codes in Wrapbook match those in your Hot Budget template for seamless syncing.

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.

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.