Skip to main content

Search

QuickBooks export: Summary vs. Detail

  • Updated

When OnPay exports pay run data to QuickBooks, you may choose how the data is formatted:

  • In Summary
  • In Detail

 

In Summary

This option streamlines the transaction so only two journal entries from OnPay are sent to QuickBooks. 

  • Payroll - All wages, deductions, and taxes withheld for all employees
  • Tax Sweep - All employee and employer taxes that OnPay debits from your bank account

You can:

  • Map your payroll wages by pay type or by department
  • Use QuickBooks Classes or Locations

You cannot:

  • View employee salary information in QuickBooks

 

"In Summary" journal entry examples

Here’s what a summary transaction looks like in QuickBooks.

Journal Entry (Payroll)

2020-10-26_15-38-29.png

Note that the memo field includes only the pay run ID and check dates.

 

Journal Entry (Tax Sweep)

2020-10-23_10-42-58.png

 

In Detail

Selecting "In Detail" means OnPay will send:

  • Separate journal entries for each employee
  • The Tax Sweep
  • The Direct Deposit Sweep 

This makes it easy to:

  • Reconcile the Tax Sweep and Direct Deposit Sweep with the debits OnPay makes to your bank account
  • See any uncashed employee paychecks and reconcile them with your bank feed

 

"In Detail" journal entry examples

Here’s what detailed transactions look like in QuickBooks.

Journal Entry (Payroll)
2020-10-26_15-36-03.png

The memo field includes the employee name and number, as well as the run ID and check dates.

 

Journal Entry (Tax sweep)

QBO_In_detail_.png

About employee journal entries

QuickBooks Classes, Locations, and custom mapping details will show under each employee’s journal entry. Please note, the bank account register will not show the individual employees paid by direct deposit. This is because the net pay is considered " $0.00" and QBO automatically reconciles these entries. 

If you'd like to view employee-level detail for the expenses or liabilities, you can do so in the applicable account. For example, if you wanted to see the wage expense breakdown by each employee, you can look at the expense account used for wages.

 

v7.24