cancel
Showing results for 
Search instead for 
Did you mean: 
Hbeach
Level 2

Importing QB Online Payroll into QB for Mac Desktop

Anyone else having issues with import payroll data (IIF) into QB for Mac Desktop?

5 Comments 5
GlinetteC
Moderator

Importing QB Online Payroll into QB for Mac Desktop

Hi, Hbeach. I'm here to help you with importing data in QuickBooks.

 

To confirm, are you receiving an error message when importing Online payroll data into QuickBooks Desktop for Mac? This information will help me determine if other users are having the same issue.

 

Meanwhile, I've got some information to ensure you can successfully move your data into QBDT Mac. Let's prepare your spreadsheet file and make sure that the items match the template on QuickBooks. 

 

Here's how:

 

  1. Go to the File menu, then choose Import.
  2. Select Transactions and the transaction type you want to import.
  3. Choose the gear menu, then click Export Table Template.
  4. Enter a name, then save the template. This downloads the template in a .CSV (spreadsheet) file.
  5. Open the template on your spreadsheet application. 
  6. Attach your transactions to the template, then save your work.

Once done, you can now import your transactions. Please follow the steps I've outlined below:

 

  1. Open your spreadsheet file.
  2. In QuickBooks, go to File, then select Import.
  3. Choose Transactions, then the transaction type you want to import.
  4. Copy the transactions from your spreadsheet and paste them on the import window. 
  5. Click Import.

For more details, check out our detailed guide on importing data into QuickBooks for Mac.

 

Let me know if there's anything else I can answer for you regarding importing in QuickBooks. I'm always happy to help.

Hbeach
Level 2

Importing QB Online Payroll into QB for Mac Desktop

Thanks for reaching out. The issue I am having is that QB for Mac Desktop will not import an IIF file which contains QB payroll data.

 

When attempting to import QB for Mac Desktop backs up the company data file, but then fails to import the data...or provide an error code...it just backs up and then logs itself out of the company data file. 

 

Your work-around will not work because you cannot export the necessary data from QB online payroll to .csv file. Detailed payroll information is only available for export via IIF file.

 

We will be moving away from QB online payroll because of this issue, and the many support issues we have recently encountered from QB. Frankly we don't see the attention to detail when it comes to properly deploying software vs previous years. We were forced to move from Intuit Online Payroll to QB Online Payroll prior to QB working all the bugs out of the code.....which is unfortunate.  

robertmh
Level 1

Importing QB Online Payroll into QB for Mac Desktop

I'm having the same issue and  QuickBooks do not care as long as they get your money.

JGM55
Level 1

Importing QB Online Payroll into QB for Mac Desktop

I cannot export payroll and payroll tax transactions from Quickbooks Online Payroll to Quickbooks Desktop for Mac.  With help from support, I was able to get the payroll/paycheck info to transfer over, but none of the tax payments will export to my desktop.  Last year I was forced to hand enter every tax transaction in order to get the information I need, but I will not do that again.  I need help to figure out what the problem is.  Online Payroll says the transactions exported, but they did not (or they are lost in some unknown location.)

 

I have been transferred to every department for every program with no help.  I want a solution.

Jovychris_A
Moderator

Importing QB Online Payroll into QB for Mac Desktop

I'd be delighted to guide you through moving your data from QuickBooks Online Payroll(QBO) to QuickBooks Desktop (QBDT) for Mac, @JGM55.

 

I know this would be disappointing when the system is unable to perform a very important task. Worry no more, I'll help you transfer your data from the QuickBooks Online Payroll tax payments to QuickBooks for Mac.

 

The problem behind why we're unable to transfer tax payments is that QuickBooks Online Payroll has limited features unlike QuickBooks for Mac.

 

In this case, you'll initially need to convert the information from QBO to QBDT for Windows. Just a heads up, some data won't be converted because of feature differences. When you receive a message that says QuickBooks for Windows is best for your business, just click Yes.

 

Before getting started, there are a few things you'll want to be aware of:

  • A Windows computer with Internet Explorer 11 or higher will be required.
  • QBDT for Windows will need to be the same version as your QBDT for Mac product, or earlier. You can refer to our Download a trial for QBDT resource to obtain a 30-day trial copy that can be used for this process.

 

Once you're prepared, you can begin your data migration.

 

Here's how:

  1. Export your files from QBO to QBDT for Windows.
  2. Make sure the company file is open in QBDT for Windows.
  3. Re-sort lists if necessary.
  4. Perform a Verify Data. This identifies most known issues within files and informs users if their Rebuild Data tool needs to be utilized afterward.
  5. In the top menu bar, go to File, Utilities, then Copy Company File for QuickBooks Desktop for Mac. This creates a MAC.qbb file that can be restored in QBDT for Mac.
  6. Save your file in a preferred location. I'd recommend creating a backup copy as well.
  7. Restore the data in QBDT for Mac.

a. On your No Company Open window, click Browse.

b. Locate the file you'd like to open.

c. If your QBDT for Windows company file is stored in an external drive, it's recommended that you move it to a local area on the computer you're working with. This helps avoid data corruption.

d. Once you see a prompt asking if you want to restore a QBDT for Windows file, hit OK.

e. Enter an appropriate name for your restored file, then select Save.

 

Now your tax payments and other details from QBOP will be imported into QBDT for Mac.

 

Furthermore, you'd be able to find many useful resources about using QuickBooks for Mac here: QuickBooks Desktop for Mac User's Guide.

 

I'll be here to assist if you have additional questions about moving data from two different programs. I'll be around to help. Take care and have a nice day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us