When setting up your OnPay and QuickBooks integration, you have the option to export your payroll information either “In Detail” or “In Summary.”
This option streamlines the transaction so only two journal entries from OnPay pass to QuickBooks.
- The first details the wages, deductions, and taxes withheld from the employees.
- The second is the “Tax Sweep”, which details the employee and employer taxes that OnPay debits from your bank account.
- Map your payroll wages by pay type or by department
- Use QuickBooks Classes or Locations
- View employee salary information in QuickBooks
Here’s what a summary transaction looks like in QuickBooks.
Journal Entry (Payroll)
Note that the memo field includes only the pay run ID and check dates.
Journal Entry (Tax Sweep)
Selecting "In Detail" means OnPay will send:
- A journal entry for each employee
- The Tax Sweep (mentioned above)
- 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
Here’s what detailed transactions look like in QuickBooks.
Journal Entry (per employee)
Note that the memo field includes the employee name and number, as well as the run ID and check dates.