cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

 
Solved
Best answer October 15, 2018

Best Answers
Highlighted
Level 6

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

11 Comments
Highlighted
Level 6

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

I do manual payroll in QB.  First step input the hours accordingly.  Second step, I set up an excel spreadsheet to help calulate federal, state, city, and school.  I record those amounts on the timecard and manually added them in QB in the appropriate area.  We have been doing this since 2005 with no problems.  No Journal Entries necessary and the W2 print fine

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

Where is the appropriate areas?

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

What are the appropriate areas?

Highlighted
QuickBooks Team

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

Hi there, @EXR007.

 

Thanks for keeping in touch with us to resolve your concern. I have some information on how you can manually prepare payroll in QuickBooks Online.

 

While I'm not familiar with how gdc works his way to manually do payroll, here's what I know what appropriate areas are: Gross Pay, Net Pay, Deductions, Taxes Withheld (Employee and Employer taxes), Other Pay, Paid time off, etc.

 

On the other hand, manually creating payroll can also be done using a Journal Entry.

 

Here's how:

  1. Go to the Plus icon.
  2. Under Other, select Journal Entry.
  3. Choose the date of the paycheck.
  4. Enter the number for the journal entry. You can choose any number for the journal entry, as this is simply for reference purposes and doesn’t affect the actual entry.
  5. Enter the appropriate debit and credits for the account.

While doing this, I'd recommend consulting an accountant on which specific accounts to use in recording the transaction to ensure the best accounting for your personal business.

 

For a more in-depth information on this matter, check out this article: https://quickbooks.intuit.com/community/Employees-and-payroll-taxes/Record-payroll-transactions-manu....

 

Keep in mind that you can also use a third-party payroll service, in which case you’ll need to contact the service to give them the appropriate information. You may search the web, visit Apps.intuit.com, or click Apps in QBO to look for a third party application which will integrate well with the program.

 

You should be able to prepare payroll for your employees with the above information. Let me know how things go and if you have other questions with QuickBooks payroll. I'm always here to help. Have a great rest of the week.

Highlighted
Level 10

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?


@gdc wrote:

I do manual payroll in QB.  First step input the hours accordingly.  Second step, I set up an excel spreadsheet to help calulate federal, state, city, and school.  I record those amounts on the timecard and manually added them in QB in the appropriate area.  We have been doing this since 2005 with no problems.  No Journal Entries necessary and the W2 print fine


This may be for QB Desktop. The question is for QBO, where this answer does not make sense

Highlighted
Level 3

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

If you have 20 or fewer employees, the following method works for Quickbooks online:

* Add check for each employee  (Plus icon, add check) as follows:

*Put employee name in payee field (add as vendor or employee)

*Add expense category: Gross Wages, input gross wages as a positive number in the amount.

*Add liability category: Federal Income Tax Withheld or Payroll Liabilities, input tax withheld as a negative number.

*Add liability category: Social Security Tax Withheld or Payroll Liabilities, input tax withheld as a negative number. 

*Add liability category: Medicare Withheld or Payroll Liabilities, input tax withheld as a negative number. 

*Add liability category: State Tax Withheld or Payroll Liabilities, input tax withheld as a negative number. 

*Add liability category: Workers Comp Withheld or Payroll Liabilities, input tax withheld as a negative number. 

 

To record the employer taxes, you would either wait until you actually pay the taxes to record the Payroll Tax expense (cash basis) or record the Payroll Tax expense with every payroll as it is calculated (accrual basis). To do this requires a journal entry:

Payroll Tax expense (debit)

Payroll Tax Employer Payable (credit)

 

When paying the employees share of these taxes to the tax entity, you would write another check to the tax entity with Payroll Liabilities, or the correct category, as a positive number, and employer Payroll Tax expense as a positive number (if using cash basis) or Employer Payroll Tax Liability (if using accrual basis) as a positive number.  

 

If you have more than 5 or 10 employees, you may want to save yourself a lot of time and use Quickbooks Online payroll or another outside payroll service with general ledger export capabilities.  

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

GDC does not use this method for creating payroll checks in QB.  The method we use is very user friendly and allows us to track more information associated to that pay period (like class for specific jobs).  This allows us to run payroll reports per job. Let me know if you want a break down.

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

GDC manually calculates payroll via excel spreadsheet. We set up payroll in Quick Books as normal (hourly wages & taxes). We enter the hours as normal (alone with class info). Quick Books does the gross calculation. We manually enter the tax amounts based on excel calculations. Once everything matches (gross, net), we print checks directly out of Quick Books. We run monthly payroll reports, submit those to our CPA. Out method is a user-friendly method, and we get more data from payroll for tracking purposes.  For more info contact me..

Highlighted
Level 1

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

GDC,

What you are doing sounds like what I am doing in Quickbooks Desktop.  But I don't see how it works in GBO.  I can't even get to anything that looks like payroll without signing up for a subscription.  Did you get a subscription, then cancel it, which left the payroll structure there, so you could fill everything in manually?  I really need to figure out payroll, or the whole QBO idea is not going to work for me.

Thanks.

 

Highlighted
Moderator

I need to manually prepare payroll in Quickbooks Online. I will do the taxes calculation manually as well. How should I set this up on QB?

Hello @kberry4313,

 

While waiting for the response coming from our new member, @gdc, I've you the ways on how QuickBooks works with manual payroll entry.

 

To start with, you can create a journal entry to start recording your manual paychecks. See this article for more insights: Create a journal entry.

 

On that same page, you still need to have an active payroll subscription so that QuickBooks can report and calculate your taxes accurately.

 

That being said, here's an article you can read to learn more about how the manual payroll works: Manually enter payroll paychecks in QuickBooks Online.

 

Keep me posted in the comment section down below if you have any other questions. I'm always around happy to lend a helping hand.

Need to get in touch?

Contact us