Sending CORE time entries to QuickBooks Desktop for payroll

Intuit and QuickBooks are registered trademarks of Intuit Inc. used with permission.

If you process payroll in QuickBooks Desktop, you can send CORE time entries to QuickBooks Desktop timesheets so that paychecks are created from the hours your employees record in CORE. When you use the BQE CORE-QuickBooks Desktop integration, each time entry is sent with a payroll item. The integration utility chooses the payroll item from the payroll items you assign to each employee and the details of each time entry.

You need to send time entries only if you use them for payroll in QuickBooks Desktop. Invoices and time entries are sent separately, and invoices, including detailed invoices, do not need their time entries in QuickBooks Desktop.

In this article, send means creating a record in QuickBooks Desktop from CORE, and map means linking a CORE record to one that already exists in QuickBooks Desktop on the Smart Match tab of the integration utility.

Before you start

  • Employees, projects, and activity items must be sent or mapped. If a record exists in both CORE and QuickBooks Desktop, map it. If it exists only in CORE, send it to QuickBooks Desktop. A time entry whose employee, project, or activity item is not sent or mapped is not sent.
  • Payroll items must be set up for each employee in QuickBooks Desktop, under Edit Employee > Payroll Info > Earnings.
  • Vacation, sick, and holiday activity items must be set in CORE under Settings > Time & Expenses > Personal Time Off.

For the steps to send and map records, see BQE CORE-QuickBooks Desktop Integration.

Assign payroll items to employees

  1. Open the CORE-QuickBooks Integration utility.
  2. On the Settings > Sync Settings tab, select Payroll Settings on the left panel.
  3. Under Default Settings, select a Default Payroll Item.
  4. Under Assign Payroll Items By Employee, select an Employee.
  5. Select a payroll item for each category, from Regular Time through Holiday. If the employee is paid the same way for several categories, select the same payroll item for each of them. You can also assign payroll items to Flag1, Flag2, and Flag3.
  6. Click Add.
  7. Repeat steps 4 to 6 for each employee whose time you send for payroll.
Payroll Settings in the CORE-QuickBooks Integration utility, showing the Default Payroll Item and the payroll items assigned to an employee for Regular Time through Flag3.

The payroll items you assign must be the same ones set up for the employee in QuickBooks Desktop.

QuickBooks Desktop Edit Employee window, Payroll Info tab, listing the employee's earnings payroll items with Use time data to create paychecks selected.

The Default Payroll Item is used only for employees who have no payroll items assigned. It does not fill in a category that is left empty for an employee who has payroll items assigned. A time entry in an empty category is sent without a payroll item.

If Use time data to create paychecks is selected for an employee in QuickBooks Desktop, every time entry for that employee must have a payroll item, and QuickBooks Desktop does not accept time entries without one. Assign a payroll item to every category from Regular Time through Holiday, and to every flag your employees use. Do not clear Use time data to create paychecks to work around this, because QuickBooks Desktop then no longer creates paychecks from the timesheet hours.

How the payroll item is chosen

The activity item on a time entry decides which service item appears on the QuickBooks Desktop timesheet. It does not decide the payroll item. The payroll item depends on the following details of the time entry:

Payroll item Time entry detail
Regular Time Billable is selected and Overtime is not
Regular Non-Billable Time Neither Billable nor Overtime is selected
Overtime Billable and Overtime are selected
Overtime Non-Billable Overtime is selected and Billable is not
Vacation The activity is the vacation activity set in Settings > Time & Expenses > Personal Time Off
Sick The activity is the sick activity set in Settings > Time & Expenses > Personal Time Off
Holiday The activity is the holiday activity set in Settings > Time & Expenses > Personal Time Off
Flag1 Flag 1 is selected
Flag2 Flag 2 is selected
Flag3 Flag 3 is selected

If more than one row applies to a time entry, the payroll item is chosen in this order:

  1. Flag 1, then Flag 2, then Flag 3.
  2. Vacation, sick, and holiday activities.
  3. Billable and Overtime.

For example, a billable overtime entry with Flag 1 selected is sent with the Flag1 payroll item, and a holiday entry marked as overtime is sent with the Holiday payroll item. If a flag is selected on a time entry but no payroll item is assigned to that flag, the next rule in the order applies.

CORE Edit Time Entry screen with the Billable, Overtime, Flag1, Flag2, and Flag3 settings highlighted.

Flag 1, Flag 2, and Flag 3 can track any characteristic of a time entry, and your company may already use them for other purposes. Assign a payroll item to a flag only if that flag is used for payroll. The labels for these flags, and for other time entry fields, may be different in your company if they are changed in Custom Labels.

In the following example, an employee records a week of time on one project. Most entries use the same activity, Drawing, but each one is sent with a different payroll item because of the details of the entry. Overtime entries are sent with the overtime payroll items, flagged entries with the payroll items assigned to their flags, and vacation, sick, and holiday entries with their time off payroll items. You do not need a separate activity item for each payroll item. As this example shows, time entries with the same activity item can be sent with different payroll items, depending on their details.

CORE Time Entries screen showing an employee's week of time on one project, with entries for regular, overtime, non-billable, vacation, sick, holiday, and flagged time.
QuickBooks Desktop Timesheet for the same week, showing each time entry with its service item and a different payroll item such as Regular Time, Hourly Overtime, Vacation Hourly, and Lead Upgrade.

Send time entries

  1. In QuickBooks Desktop, close any open timesheets. Time entries cannot be sent while a timesheet is open.
  2. Open the CORE-QuickBooks Integration utility.
  3. On the Send to QuickBooks menu, click Time Entries.

To send only approved time entries, select Approved Only on the Settings > Sync Settings > Send Settings > Time Records screen before you send. A time entry is not sent again after it is changed in CORE, so this keeps entries that are still under review off the QuickBooks Desktop timesheet.

If the integration utility reports that some time entry records were dropped, check that no timesheet is open in QuickBooks Desktop and that the employee has a payroll item assigned for the category of each time entry.

Things to know

  • Only the hours are sent, along with the employee, project, activity item, payroll item, class, and notes. Bill rates, pay rates, and accounts are not sent. Pay rates come from the employee's payroll setup in QuickBooks Desktop.
  • Changes made to a time entry in CORE after it is sent do not update QuickBooks Desktop. To send the change, delete the time entry in QuickBooks Desktop and unmap it on the Smart Match > Mapped tab, and then send it again. For details, see BQE CORE-QuickBooks Desktop Integration.
  • After time entries are on the QuickBooks Desktop timesheet, paychecks follow the employee's payroll setup in QuickBooks Desktop. For help with payroll in QuickBooks Desktop, contact your QuickBooks ProAdvisor or your accountant.