cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.

Reply to message

View discussion in a popup

Replying to:
Rubielyn_J
QuickBooks Team

Reply to message

I'm here to ensure you're able to export employee checks from QuickBooks Online to Desktop for Mac, @jheselius.

 

In preparing your transactions in a spreadsheet file, make sure that the items on it match the template on QuickBooks. This way, you'll be able to export them successfully.

 

To do this, 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.

 

When you’re ready, here’s how to import your transactions.

 

  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. If everything looks right, click Import.

 

If the same thing happens, you can use an IIF file as another option. 

 

  1. Go to the QuickBooks payroll website. 
  2. Choose the employees and then the paycheck list. 
  3. Click on the box to the left of the paycheck you want to export.
  4. Look for 3 boxes Print/Export to Accounting/Void
  5. Click Export to Accounting.

 

For more insights, feel free to review this article: Import data into QuickBooks for Mac.

 

Can I also ask if you encounter an error message when trying to export transactions from Online to Desktop for Mac? I appreciate any extra information you can give and it will help me isolate the issue and provide the best solution.

 

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!

Need to get in touch?

Contact us