Skip to main content
December 18, 2021
Question

Creating a .iif file from my QB online payroll?

  • December 18, 2021
  • 1 reply
  • 0 views

I ran payroll last week and the file did not export to my desktop (Mac) ledger. How do I create a .iif file to export in QB online payroll, so I can import it into my QB desktop for Mac ledger?

1 reply

December 20, 2021

Thanks for dropping by here in the Community, @Kahuna1.

 

I can help you create IIF file and export payroll data to your QuickBooks Mac program.

 

First, we need to set up the preferences:


1. Go to the Gear icon.

2. Choose Payroll settings.

3. Select the Pencil icon next to Export.

4. Choose QuickBooks Desktop for Windows: downloadable IIF (Intuit Interchange Format) file and select Continue.

5. You will be asked to type in the name of each account you are exporting your liabilities and expenses to. We also suggest that you have a copy of your QuickBooks chart of accounts handy for this.

Next, you can begin exporting payroll transactions, such as paychecks and tax payments. Here's how:

1. Use the Gear icon.
2. Go to Payroll settings.
3. In your Export section, click Export transactions.

4. A screen will appear letting you know how many transactions and which types are being set up for export. You may need to allow popups in your web browser for this window to display.

5. Select Export.

For more information on exporting IOP to Excel in QuickBooks Online, you can check out this article: Setup export of IOP data to QuickBooks Online (QBO)

 

For the detailed steps, see Next, export your payroll transactions in this article: Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll. 

 

I’m also adding this article in case you need to access payroll reports in the future. This includes the description of each report and the information you can get: Run payroll reports.

 

I'll be around if you need further assistance. I'm very eager to help. Take care!