My online payroll did not export to my QB ledger, how do I do it?

Welcome and thanks for joining us here in the Community, @Kahuna1.

I'd like to make sure we're on the same page so I can give you the right amount of information.

Before we can accomplish your goal for today, I want to ensure I understand the situation better. Any additional details will help me provide accurate data and resolutions for exporting your payroll info to your QuickBooks ledger as soon as possible.

In the meantime, I'm adding this article to learn more about exporting payroll transactions into QuickBooks Online (QBO) from our Standalone Payroll Product: Export into QuickBooks Online from Core, Premium, or Elite Standalone Payroll.

Keep me updated in the comments. Hope to hear from you soon. Take care and stay safe! 

My new QB payroll is online, my QB ledger is in desktop for Mac form. I called QB to get my payroll to export to my desktop version. I had to bring up the most recent payroll, click all, and then export it to the right bank ledger. I have my answer now, I am not sure I explained it well. Thanks for trying to help me out!

So here I go again I was reconciling my monthly bank statement and I noticed the payroll was missing in my QB for Mac desktop version ledger.  I went to my online QB payroll and brought up the old payday info with no problem, then I searched and found no way to export it to QB for Mac desktop, not .iif file format nothing. Please help!

It's a pleasure to have you here again, @Kahuna1. I've got your back to help you create the IIF file and export your payroll data from QuickBooks Online and reconcile your account in QuickBooks.

Since you're using QuickBooks Online Payroll, let's first set up your Export preferences in your QBO account. Doing this can help you transport your payroll transactions.

Here's how:

1. Go to the Gear icon in the top right corner.
2. Choose Payroll Settings.
3. Click the Pencil icon next to Export.
4. On the Export preferences page, click QuickBooks Desktop for Mac.
5. Enter the name of each account you are exporting your liabilities and expenses to make sure you have a copy of your QuickBooks Chart of Accounts.

Once done, you can now export your payroll data to your QBDT account. Let me guide you how: 

1. Go back to the Payroll settings page.
2. In the Export section, click Export transactions.
3. Select Export to process. 

For detailed steps, you may also consider checking out this article: Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll. It also covers how to export your tax payments or paychecks individually or re-exporting a transaction.

Once you're all set, you'll want to review this resource: Get started with Payroll. This will help you set up your new payroll in QuickBooks Desktop for Mac. Then, start reconciling your accounts so they match your bank and credit card statements.

Place a reply in the comments below if you have other issues with your payroll data in QuickBooks. I'll get back to you as soon as I can. Keep safe and take care always.

So I am using QB for Mac desktop and you want me to use the QB for windows, .iif files? Are you sure?

@Kahuna1 

Thanks for getting back to this thread, @Kahuna1. Let me clarify things for you.

I'll be adding some details about exporting Online Payroll to QuickBooks for Mac to ensure your matter be addressed.

Standalone Payroll Product, QuickBooks Online Payroll (QBOP), and QuickBooks Desktop (QBDT) for Mac have various platforms. If you're working on the said version, you'll have to manually export your file from QBO to start sending your payroll data. Then, import them to your QBDT for the Mac company file. While doing this, I recommend downloading and using import kits so you can easily transfer data to and from different platforms to better manage company records in QuickBooks.

Before you import, make sure to create a backup copy of your company file. This is to guarantee that you’ll be able to restore your company file and get back to work in case you ever run into a problem with your data. Then, know the IIF import limitations to smoothly accomplish the process.

Once you're ready to import your IIF payroll data, please follow the steps below.

1. Sign in to your company file as an admin.
2. Go to the File menu.
3. Choose Import.
4. Select From IIF Files and export your IIF file.
5. Follow the on-screen instructions to complete the procedure.

You can also check this article for more information about the process: Import data into QuickBooks for Mac.

Moreover, you can also open each of the links below about exporting your payroll data and importing them into your QBDT for Mac:

• Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll.
• Export Payroll Transactions to QuickBooks.

Additionally, let me share this resource to guide you fix some issues in exporting data: QuickBooks Desktop export troubleshooting (Mac, IIF, & One-Click).

Keep me posted if you have other concerns managing your data in QuickBooks. I'll be more than happy to help you further. Have a wonderful day!

I finally figured it out myself, just by luck I clicked on every possible choice and this is what I have, I hope it helps others as too many hours of mine have been occupied by this problem.

Do this after opening up QB for Mac Desktop

• Open QB online payroll — Use Chrome!
• go to payroll
• Overview
• View paycheck list
• last pay date or whatever date you want
• check boxes
• export to accounting
• backup file of your ledger
• once backup is completed click on .iif file to import
• Go to the date in your ledger to confirm the data has imported. Whew!