Skip to main content

Are you using Intuit Payroll? Here's how to pull the payroll data for your books

Find net pay and employee and employer taxes in your QuickBooks Payroll reports, so your Intuit Payroll payments are recorded correctly in your books.

Written by Emily Burrows

About

Applies to: Finaloop Accounting

Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, records your Intuit QuickBooks Payroll payments correctly once you tell us how each payment splits between net pay, employee taxes and employer taxes, and two QuickBooks reports give you those numbers: Paycheck History and Payroll Tax Payments.

For a more automated option, check out Gusto for payroll. Finaloop integrates directly with Gusto to pull this info automatically: Connecting Payroll apps - Gusto.

In the meantime, just follow these directions and you'll easily find exactly what you're looking for.


1. Find your salaries and wages in the Paycheck History report

  1. Log in to your QuickBooks.

  2. On the left-hand bar, select Reports, then Standard reports.

  3. Under Payroll, select the Paycheck History report. If you don't spot it right away, you can also find a report by searching for its name.

    QuickBooks Payroll report list with the Paycheck History and Payroll Tax Payments reports outlined.

    ① Paycheck History, ② Payroll Tax Payments.

  4. Select the relevant pay date. For the total salaries & wages paid to employees, look under the column that says Net pay.

QuickBooks Paycheck history report header with the Net pay column outlined.

2. Split employee and employer taxes in the Payroll Tax Payments report

  1. Go back to Reports and, under Payroll, select the Payroll Tax Payments report.

  2. Select the relevant payment date and click the relevant transaction to open it.

  3. Split the amounts between employee and employer taxes to accurately track your payroll taxes, using the rule for each tax type.

Note: The Payment Date presented in QuickBooks' reports can be 1 to 3 days before the transaction date reported in your bank, so look for a bank transaction dated up to 3 days later.

Federal Taxes (941/943/944)

The employer taxes amount is the sum of Social Security Employer plus Medicare Employer.

The employee taxes amount is the sum of Federal Income Tax plus Social Security plus Medicare.

QuickBooks Federal Taxes (941/943/944) payment detail with employer and employee tax items outlined.

① Employer tax items (Social Security Employer, Medicare Employer), ② employee tax items (Federal Income Tax, Social Security, Medicare).


State Income Tax

Report the total amount as employee taxes.


Federal Unemployment (940)

Report the total amount as employer taxes.


State Unemployment

Report the total amount as employer taxes. Employees in Alaska, New Jersey and Pennsylvania also pay part of state unemployment, so if your payment lists an employee item for one of those states, report that item as employee taxes.


State Employment Taxes

Report all tax items ending with "Employer" as employer taxes (for example, "SUI Employer"). Report the rest of the tax items as employee taxes.


All other state taxes

Report the total amount as employer taxes.


3. Enter your payroll numbers in Finaloop

Once you have your numbers, you can give them to us right on the payment.

  1. In Transactions, open the Intuit payment marked Additional input required or Waiting for your input.

  2. Under What type of payment to Intuit Payroll is this? (the question shows the vendor name on your transaction), select Salaries & wages for a net pay payment or Payroll taxes for a tax payment. If one payment covers both, select More than one of the categories above.

  3. For a tax payment, enter your totals in Employee Tax Amount and Employer Tax Amount. The two amounts need to add up to the transaction's amount.

  4. Click Next and finish any remaining questions.

The payment no longer shows as waiting for your input, and your payroll amounts are recorded in your books.


4. Add Finaloop as your accountant in QuickBooks Online

To make sure your QuickBooks Payroll transactions get properly included in your books, you can also add Finaloop as your accountant in your QuickBooks Online account. You'll need to be a primary admin or company admin in QuickBooks to send the invite, and you'll send it from QuickBooks in a web browser.

  1. Log in to your QuickBooks Online account.

  2. From the Settings gear icon, choose Manage users, then select the Accounting firms tab.

  3. Select Invite, enter Finaloop team as the name if QuickBooks asks for one, and enter [email protected] as the email.

  4. Select Save, then follow any remaining prompts to finish.

Our team shows as Invited on the Manage users page. After we accept the invite, the status changes to Active.


Related articles


Need help?

If you have any questions or trouble finding the information you need, feel free to contact us at [email protected]!

Did this answer your question?