Skip to main content
July 21, 2020
Question

Third party payroll entries and reconcile

  • July 21, 2020
  • 2 replies
  • 0 views

Hello. 

I run payroll through a 3rd party and I am attempting to reconcile our account. I am running into a couple problems as I reconcile. 

1. Our payroll service takes 4 separate payments from our bank account: Child Support, Payroll Billing, Direct Deposits, and Tax Liabilities (including MO Withholding, Federal, FUTA, and SUI all in one chunk)

 

As well as doing payroll through our third party, I use quick books to run payroll like normal, except I print stubs for the employees instead of checks. This is how I write live checks as well for newer employees and it works well. I have found that some tax numbers dont match up 100% so I do make those adjustments, making sure they match our payroll service company. 

 

I have found a way to work around everything for the reconcile EXCEPT for FUTA and SUI. Since this is quarterly and not weekly/monthly I have not found a solution to "pay the liability". Its easy to do for child support and Withholding. 

 

2. Should I just stop quickbooks from calculating liabilities and just create journal entries for them? 

*While still making sure I do the pay employee part (incase of live checks) and entering correct tax info. 

 

I have looked everywhere and cannot seem to figure out what is best to balance these months. 

 

2 replies

Rose-A
July 22, 2020

Good day, h_warren.

 

I'm here to share some information regarding handling payroll entries from a third-party payroll service provider and reconciling them in QuickBooks Desktop.

 

You can set up QuickBooks to stop calculating the FUTA and SUI and do journal entries instead. This way you can get real-time reporting and match the actual transactions from your third-party payroll service provider.

 

However, using this method (journal entry) needs the assistance of an accounting professional for the accounts you need to use. Also, your accountant can help and guide on which account to debit and credit.

 

To set up manual payroll, here's how:

 

  1. Click Edit at the top, and then select Preferences.
  2. On the left panel, select Payroll & Employees then go to the Company Preferences tab.
  3. In the QuickBooks Desktop Payroll Features section, select the Full Payroll radio button.
  4. Select OK

Once done, you can now create the manual payroll. Let me walk you through the steps:

 

  1. Click Help at the top, and then select QuickBooks Help (or press F1 on your keyboard).
  2. In the Search field, type manual payroll and press Enter on your keyboard.
  3. Select the topic Calculate payroll manually (without a subscription to QuickBooks Payroll).
  4. Under Set your company files to use the manual payroll calculations setting, click the manual payroll calculations link.
  5. Select Set my company file to use manual calculations link. When your company file is set up for manual payroll computation, QuickBooks inserts a zero amount for each payroll item associated with a tax.
  6. Close and reopen QuickBooks Desktop.

Since we can't change the filing and payment frequency for FUTA and SUI and you continue to use payroll, you can have a temporary account that will allocate all your weekly payments for the taxes.

 

When the due date appears on your Pay Liabilities page, you can record an adjustment and allocate it to the accumulated payments. 

 

The resources below are good references. You can get the detailed steps in adjusting your payroll liabilities in QuickBooks Desktop as well as things you need to check to make sure your liabilities are updated. Also, it provides you links on how to correct your year-to-date additions and deductions in QuickBooks:

 

Adjust payroll liabilities in QuickBooks Desktop

How to use QuickBooks to pay payroll taxes and other liabilities

 

You can always get back to me if you have any other payroll concerns. I'll be right here to keep helping. Have a good one.

h_warrenAuthor
July 29, 2020

When going into preferences to click "manual payroll" the box will not let me press it. Is there a step to open this up?

June 10, 2021

Thank you for following-up, Davis_S.

 

I understand how convenient it is for you to use ADP for your employees payroll. But since third party application doesn't support QuickBooks your only option is to enter those payroll entries manually inside QuickBooks Desktop.

 

I suggest contacting the third party application support to help you generate a report showing the taxes, wages, earnings, and other payroll information.

 

You can also consult an accountant to help you check and make sure each posting account for your journal entries are correct.

 

I've also included these articles that you can use as future reference: Create a journal entry in QuickBooks Desktop for Windows or Mac
 

The Community is always here to help. Don't hesitate to post or click the reply button for any follow-up questions or clarification about payroll. Keep safe.