Recording Payroll from ADP into QuickBooks Online
Vložit
- čas přidán 6. 08. 2024
- In this video, I'll show you how to manually enter Payroll data from ADP into QuickBooks Online.
There are several different ways you can do this, I'll be showing you the method I prefer to use.
Please like, subscribe, and comment!
Contact Rachel for one-on-one assistance:
www.gentlefrog.com/meeting/
☕ If you found this video helpful you can say "thanks" by buying me a coffee...
www.buymeacoffee.com/gentlefrog
Connect with Rachel on Facebook:
/ gentlefrogllc
Try QuickBooks Online for free for 30 days:
bit.ly/3gXpv3b
Already know you want QuickBooks Online? Buy now and save 30% on your first 12 months:
intuit.me/3gZ0q85
Check our reviews:
proadvisor.intuit.com/app/acc...
www.yelp.com/biz/gentle-frog-...
www.gentlefrog.com/reviews/
Timestamps
00:00 - Intro
00:55 - Example Payroll Summary
01:29 - Payroll Liabilities
01:54 - Payroll Liability broken out
02:53 - Making a journal entry
03:55 - Entering gross wages
04:52 - Entering payroll liabilities
06:44 - Recording direct deposit
08:18 - Payroll taxes
08:46 - Entering employer payroll taxes
09:50 - Entering employee payroll taxes
12:08 - Overview of the journal entry
12:56 - Recording remitted taxes
13:26 - Payroll company fee
13:39 - Attach payroll report
14:12 - Outro
#quickbooksonline #bookkeeping #payroll
This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.
You are a big life saver! So easy to understand! Many many thanks!
Your welcome! I'm so glad you got the help you need.
Thanks Rachel! you are the BEST for making these very informative videos.
You're welcome! I'm so glad you found it informative.
Yes, you helped me understand it much better. Thank you!
You're welcome! I'm so glad my video helped you out.
Thank you so much, I was looking for this particular case for months, and thanks to you I understood everything, you're the best.
That's fantastic! I'm so glad to hear that you finally got the help you needed.
I loved this video! You’re a great teacher!
Thank you so much!
Thank you:) this help gets my brain wrapped around this.
You're welcome!
Thanks! Very easy to understand!
Thank you for this video, I am a volunteer and switching to a third party payroll and regretting my decision! I assumed it would import as I have normally been doing business. It will not and I'm freaking out! Your calm demeanor is helping me go back to my early accounting classes. After using QBB for long enough you forget using your db & cr thought process! I have been in business using qbb for 30 years and have never had to use GL entries. In over my head, hoping your videos will talk me back down!
I'm so happy to hear this! Journal entries are very confusing and intimidating to a lot of people. If you ever need help you can schedule a 15-meeting and I'll be happy to help walk you through it: www.gentlefrog.com/meeting/
Thank you!! Super helpful! 🥰
Thanks for the helpful vid. Yours has provided the best clarity and I've viewed several here on CZcams. Would you provide explanation as to what to do with the two adp items; ADP Wage Pay and ADP Tax that download into QB For Review.
Hi Tara, you can schedule a 30-minute meeting and we'll take a look together and I can explain what to do with those ADP items www.gentlefrog.com/meeting/
Hi Rachel. Quick question on a specific time in your video. At 8:36, you start to describe that ER stands for Employer, but columns G and H both say ER when you state in the video that column H, is employee money but the cell reads ER. My brain is all discombobulated 😅 which is which? I also noticed that those columns are switched with the wording in columns E and F. It seems confusing. Unless it's supposed to be like that. I wish my brain wasn't like this 😂
It's not your brain, it's that the Google Sheet used for this was completely made up (that's why it's name is Dummy Payroll 1). Mistakes happen when creating dummy documents. Column G should be EE for employee, the rest are correct. I was going to suggest you watch the Training Demo video where I go over payroll but I see already have, that one uses real documents so the column headings are correct.
Thank you for this video so helpful. How do we do our journal entry when it has a Simple IRA deduction?
Stay tuned, I'll be recording more payroll videos soon.
OK but side note, thanks for providing this visual. Just 1 question about the JE on line 6 for checking account for payroll taxes. Is there a way to confirm on the adp report what will be taken out for payroll taxes? The amount says $2163.29 in this example. I am really confused on the payroll taxes/liabilities by itself so in order to confirm I inputted the correct amount on line 6, can I can confirm that with another report? Thank you for these videos
This video may help make this clearer: czcams.com/video/sA2MO-VAQvg/video.htmlsi=9QV1fntJkbGDW1-T&t=411
Thank you very much for this video. You are such a great teacher!
You're welcome! Thank you for the wonderful feedback.
Thank you for your explanation in this video. I am having trouble to categorize some bank transactions. I started using QB payroll in July, so for the first semester I just enter the total amounts of wages and taxes, when setting up QB payroll. Now I have all these bank transactions, from Jan-Jun, for wages checks and taxes payments that I can't match. Do you know how I solve it. Will I have to do journal entries for each pay period of the first semester?
You can schedule a 15-minute meeting and we take a look at it together and figure out what will work best: www.gentlefrog.com/meeting/
Thank you for this video. But, shouldn't line 6 say Employer tax withheld, not Employee tax withheld (line 2) of your JE?
Yeah, this video was made with a fake ADP Payroll spreadsheet. Some mistakes were made in the creation of the spreadsheet.
Leah you were a very big help to me. I'm new to quickbooks online. I created a spreadsheet as you were going along. My spreadsheet did not come out even. Not sure what Im doing wrong. Is it possible you could help me out? I use ADP and I just have to record the Payroll Liability.
If you were following along with the video, there were some mistakes made in the data used for the example. It was fake data, sometimes that happens. If you're working with real data and having trouble you can schedule a 15-minute meeting and we can take a look at it together and figure out what's going one: www.gentlefrog.com/meeting/
I do have another video on recording payroll where I help a fellow bookkeeper add a journal entry from a real ADP report: czcams.com/video/sA2MO-VAQvg/video.html
Great video. Could you help with one more step? How about when there are pretax, after tax and employer 401k contributions?
If you need help with Payroll you can schedule a 15-minute meeting and I can walk you through all your questions: www.gentlefrog.com/meeting/
If the money is taken out of the checking account, wouldn't that decrease the checking twice? Once for the journal and once for the actual amount taking out? Or, when the transaction for the credit to checking comes through banking, will QBO show it as a "match" so we can just match it?
Finally, when are we recording the journal? The date we get the report from the third party, i.e., the date the payroll ends? Thanks!
You can match bank transactions with journal entries. If QBO doesn't automatically match it you can use the "Find a match" and in the Show drop-down select Journal Entries to find the journal entry you need.
When recording the journal entry use the date the payroll ends.
Here's another Payroll example video that might help you out: czcams.com/video/sA2MO-VAQvg/video.html
And you can always schedule a 15-minute meeting and I can walk you through the process: www.gentlefrog.com/meeting/
CAN YOU PLEASE TELL ME HOW I CAN CREATE A JOURNAL FOR A MANUAL CHECK I CUT. WE USE ADP AND I NEED TO RECORD THE TAXES? GROSS WAGES 1886.24 NET 1656.52 ( AMOUNT OF CHECK I CUT ) EMPLOYEE TAXES WITH HELD 214.90 EMPLOYER PAID TAXES 143.17 HEALTH INS WITHHELD 14.82
You can schedule a 15-minute meeting and I can walk you through the process over Zoom: www.gentlefrog.com/meeting/