Recording Payroll from ADP into QuickBooks Online

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.

Пікірлер: 34

  • @LisaCParker-l8m
    @LisaCParker-l8m9 күн бұрын

    You are a big life saver! So easy to understand! Many many thanks!

  • @GentleFrog

    @GentleFrog

    9 күн бұрын

    Your welcome! I'm so glad you got the help you need.

  • @sandi2319
    @sandi23196 ай бұрын

    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!

  • @GentleFrog

    @GentleFrog

    6 ай бұрын

    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/

  • @user-gr7wu1lg5d
    @user-gr7wu1lg5d Жыл бұрын

    Thank you so much, I was looking for this particular case for months, and thanks to you I understood everything, you're the best.

  • @GentleFrog

    @GentleFrog

    Жыл бұрын

    That's fantastic! I'm so glad to hear that you finally got the help you needed.

  • @peppywood01
    @peppywood01 Жыл бұрын

    I loved this video! You’re a great teacher!

  • @GentleFrog

    @GentleFrog

    Жыл бұрын

    Thank you so much!

  • @ArlenCaasi-wq2fx
    @ArlenCaasi-wq2fx2 ай бұрын

    Thanks! Very easy to understand!

  • @karenstonephotography6649
    @karenstonephotography66492 ай бұрын

    Thank you!! Super helpful! 🥰

  • @staceyhalbert2850
    @staceyhalbert2850 Жыл бұрын

    Thank you:) this help gets my brain wrapped around this.

  • @GentleFrog

    @GentleFrog

    Жыл бұрын

    You're welcome!

  • @McquistjMcQuiston
    @McquistjMcQuiston6 ай бұрын

    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 😂

  • @GentleFrog

    @GentleFrog

    6 ай бұрын

    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.

  • @user-eq3wj7od2x
    @user-eq3wj7od2x Жыл бұрын

    Thanks for the helpful vid. Yours has provided the best clarity and I've viewed several here on KZread. 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.

  • @GentleFrog

    @GentleFrog

    Жыл бұрын

    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/

  • @McquistjMcQuiston
    @McquistjMcQuiston6 ай бұрын

    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

  • @GentleFrog

    @GentleFrog

    6 ай бұрын

    This video may help make this clearer: kzread.info/dash/bejne/pXVmr7FmhqS3pso.htmlsi=9QV1fntJkbGDW1-T&t=411

  • @user-do9kw9xt4t
    @user-do9kw9xt4t5 ай бұрын

    Thank you for this video. But, shouldn't line 6 say Employer tax withheld, not Employee tax withheld (line 2) of your JE?

  • @GentleFrog

    @GentleFrog

    5 ай бұрын

    Yeah, this video was made with a fake ADP Payroll spreadsheet. Some mistakes were made in the creation of the spreadsheet.

  • @user-qn9le4xe2d
    @user-qn9le4xe2d6 ай бұрын

    Thank you very much for this video. You are such a great teacher!

  • @GentleFrog

    @GentleFrog

    6 ай бұрын

    You're welcome! Thank you for the wonderful feedback.

  • @user-yk3vo2sr6z
    @user-yk3vo2sr6z10 ай бұрын

    Thank you for this video so helpful. How do we do our journal entry when it has a Simple IRA deduction?

  • @GentleFrog

    @GentleFrog

    10 ай бұрын

    Stay tuned, I'll be recording more payroll videos soon.

  • @ka22118
    @ka221185 ай бұрын

    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?

  • @GentleFrog

    @GentleFrog

    5 ай бұрын

    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/

  • @user-jo2mr9rv3w
    @user-jo2mr9rv3w5 ай бұрын

    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.

  • @GentleFrog

    @GentleFrog

    5 ай бұрын

    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: kzread.info/dash/bejne/pXVmr7FmhqS3pso.html

  • @kimberlycornett3565
    @kimberlycornett356510 ай бұрын

    Great video. Could you help with one more step? How about when there are pretax, after tax and employer 401k contributions?

  • @GentleFrog

    @GentleFrog

    10 ай бұрын

    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/

  • @crystalvaldez1048
    @crystalvaldez1048 Жыл бұрын

    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!

  • @GentleFrog

    @GentleFrog

    Жыл бұрын

    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: kzread.info/dash/bejne/pXVmr7FmhqS3pso.html And you can always schedule a 15-minute meeting and I can walk you through the process: www.gentlefrog.com/meeting/

  • @mariearsenault7
    @mariearsenault75 ай бұрын

    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

  • @GentleFrog

    @GentleFrog

    5 ай бұрын

    You can schedule a 15-minute meeting and I can walk you through the process over Zoom: www.gentlefrog.com/meeting/