KBX Payroll Toolkit

The templates delivered with the Payroll Toolkit are designed to make running reports out of Oracle® as efficient as possible. The templates are loaded through and can be customized within Microsoft® Excel and Word.

Delivered Kubes

The KBX™ Kube Manager Payroll Toolkit comes complete with over 30 delivered Kubes that you can immediately begin using for your reporting needs:



941 Worksheet
  • 941 Template

    This template provides, for each GRE, all of the relevant totals for filing of the 941 in a format suitable for submission for the date range.
Back to List of Kubes

Balance Classification
  • Balance Classification - 2 Levels of Drilldown

    This template provides totals by balance for the date range by organization.
  • Balance Class No Org - 2 Levels of Drilldown

    This template provides totals by balance for the date range.
Back to List of Kubes

Balance Classification - Employee Summary
  • Balance Classification - Employee Summary

    This template provides the employee level balance for the selected classification. Note that two versions of this template are provided, one for Excel and the other for Access.
Back to List of Kubes

Balance Trending
  • Balance Trending

    Balance Trending compares two time periods for each balance, including total employee head count and total balance amounts by classification. The differences between the two periods are expressed in both totals and percentages.
Back to List of Kubes

Canadian Payroll Register
  • Canadian Payroll Register

    This template provides information relevant to identifying problematic balances such as negative balances and no withholding, for the Canadian legislation.
Back to List of Kubes

Canadian Tax Balance Analysis
  • Canadian Tax Balance Analysis

    Provides information relevant to identifying problematic balances such as negative balances and no withholding, for the Canadian legislation.
Back to List of Kubes

Canadian Tax Details
  • Canadian Tax Details

    Provides values for each tax type by payroll for the date range, for the Canadian legislation.
Back to List of Kubes

Costing
  • Costing (with DrillDown)

    Provides a costing summary by classification for the date range.
Back to List of Kubes

Costing Reconciliation
  • Costing Reconciliation

    Provides relevant information to reconcile Payroll to Costing. It displays a summary of what was processed by Payroll, and what was Costed and not Costed. For the items not Costed, it displays what was configured not to Cost (“Not Configured to Cost”) and what was “Not Costed” due to the Costing process not being run.
  • Not Configured to Cost Summary

    Summarizes elements that were not configured for costing at the element link level.
Back to List of Kubes

Costing by Org & Location
  • Costing by Org Location

    Provides a costing summary by classification for the date range. Organization and location have been added as additional reconciliation tools.
Back to List of Kubes

Deduction Register – Employee Summary
  • Deduction Register

    Provides the deduction element, taken, arrears, not taken, and accrual balance per employee.
Back to List of Kubes

Employee Assignments Not Processed
  • Unpaid Assignments

    For a given date range, shows employees with: Employee Assignments set to Process where they have a payroll run, but has a zero Net, Payment, or Gross. Under a separate tab, the template also shows employee assignments set to process, but have no payroll attached.
Back to List of Kubes

Employee Balance Comparison
  • Employee Balance Comparison

    Provides values for 2 user specified balances, by payroll for the specified date range.
Back to List of Kubes

Employee Balance Tolerance
  • Employee Balance Tolerance

    Allows you to specify a balance value and a condition, and then provides a list of employees that meets that condition.
Back to List of Kubes

Employee Dimension Balances
  • Employee Dimension Balances

    Summarizes the balance specified by period to date, month to date, quarter to date and year to date.
Back to List of Kubes

Employee Payroll Balance Details
  • Employee Balance Details

    Provides values for a specific balance for the date range. Information is displayed at the employee level.
Back to List of Kubes

Employee Run Results
  • Employee Run Results

    Displays employee level detail including Run Results, Balance Details, Tax Details, Person History, Assignment History, Address History, Element History, Federal, State, County and City Tax information for a specified employee for a specified date range. Information is organized across multiple tabs.
Back to List of Kubes

Form 940
  • 940 Template

    Provides, for each GRE, all of the relevant totals for filing of the 940 in a format suitable for submission for the date range.
Back to List of Kubes

HR/Payroll Year End Analysis
  • Box 1 – Box 16 Differences

    Shows employees with W2 discrepancies between Box 1 and Box 16.
  • Year End

    Provides detailed employee information for a specific year.
  • US W2 Info

    W2 information by employee for the year.
  • Invalid SSN

    Detailed employee information for employees with an invalid social security number for the year.
  • Invalid Address

    Detailed information for employees with an invalid address for the year.
  • Deceased People

    Detailed employee information for deceased people for the year.
  • Paid Headcount

    Headcount paid by payroll for the year.
Back to List of Kubes

Multiple Worksite
  • Multiple Worksite

    Provides a head count of employees for each worksite based on the pay period which includes the twelfth of each month. Also provides a summary of the total quarterly wages by worksite.
Back to List of Kubes

Payment Register
  • Payment Register

    Provides a check and advice summary with details (includes voids, reversals, not paid, and unprepaid). A separate tab provides a head count of employees for each payment method for the date range.
Back to List of Kubes

Payroll Balances Workbook
  • Balances Workbook (with 4 levels of Drilldown)

    Provides values for all configured balances, by payroll for the specified date range.
Back to List of Kubes
Payroll Register
  • Payroll Register (with Drilldown)

    Provides tax and earning details by payroll for the date range.
Back to List of Kubes

Payroll Register - Employee Summary

  • Payroll Register - Employee Summary

    Provides summarized payroll balance information for the selected date range. Includes employee level detail.
Back to List of Kubes

Payroll Summary
  • Balance Classification Summary (with 2 levels of Drilldown)

    Provides summarized totals by balance for the date range.
  • Payroll Register Summary (with 2 levels of Drilldown)

    Provides summarized tax and earning details by payroll for the date range.
  • Tax Details Summary (with 3 levels of Drilldown)

    Provides summarized values for each tax type by payroll for the date range.
Back to List of Kubes
PTO Net Entitlement
  • PTO Net Entitlement

    Per accrual plan per person shows the net information for the specified date range.
Back to List of Kubes

Tax Balance Analysis
  • Tax Balance Analysis (with 3 levels of Drilldown)

    Provides information relevant to identifying problematic balances such as negative balances and no withholding.
Back to List of Kubes

Tax Details
  • Tax Details (with 3 levels of Drilldown)

    Provides values for each tax type by payroll for the date range.
Back to List of Kubes

Tax Details - Employee Summary

Summarizes tax data for the selected range. Values are grouped at the employee level.

  • Federal Taxation Summary
  • State Taxation Summary
  • County Taxation Summary
  • City Taxation Summary
Back to List of Kubes

Tax Details by Criteria
  • Tax Details by Criteria

    Provides values for each tax type by payroll for the selected date range. Can be run using any combination of SSN, JD Code and/or Tax Type.
Back to List of Kubes

Unprocessed Actions
  • Unprocessed Actions

    Displays Payroll actions that have not been processed.
  • Prepayments

    Payroll actions that have not been pre-paid.
  • Payments

    Actions that have not been processed by CheckWriter or Deposit Advice.
  • Costing

    Payroll actions that have not been Costed.
  • Transfer to General Ledger

    Costed actions that have not been transferred to the GL.
Back to List of Kubes