QuickBooks Desktop - Exporting pay runs (.IIF)

  • Updated

After you've processed a pay run payroll in OnPay, you can export this pay run data to QuickBooks Desktop as a journal entry. "Exporting" means packaging information found in an application (like a pay run in OnPay) into a format that can be read by another application (like QuickBooks Desktop).

 

This is done in two steps:

  1. Exporting the pay run data from OnPay as a single file
  2. Importing that file into QuickBooks Desktop

 

Need help setting up the QuickBooks Desktop App integration?

If you haven't already done so, you'll need to enable this app, add assets and accounts, and map your payroll items before you can export your pay runs into QuickBooks Desktop.

QuickBooks Desktop App setup guide→

 

Introduction to IIF files

When you export your pay run from OnPay, you create what's called an IIF file (Intuit Interchange Format file). These are used to manage QuickBooks desktop data, and they let you share information to QuickBooks Desktop from another platform, like OnPay. 

2021-07-15_13-40-21.png

 

Exporting from OnPay

Click Company, then App Directory.

2024-01-12_15-34-06.jpg

 

Click My Apps and select QuickBooks Desktop.

2024-01-16_17-54-07 copy.jpg

 

Click Pay Runs to the right of Settings.

2024-02-20_18-23-00.jpg

 

Identify the pay run you want to export, and click Download to save the file to your computer. 

2024-02-20_18-25-34.jpg

Note: The name of the QuickBooks Export will include the date and run ID of the pay run. The above example would be formatted as: "2024-1-15_341".

 

Check your Downloads folder for a file ending in .IIF, making sure the filename matches the date and Run ID you just exported.

image (14).png

 

Importing into QuickBooks Desktop

In QuickBooks Desktop, click File > Utilities > Import > IIF Files.

2021-07-15_12-27-37.png

 

Click Import IIF.

2021-07-14_16-00-22.png

 

Then locate the file and click open.

2021-07-14_15-57-26_copy.png

 

QuickBooks will prompt you that the data has been imported successfully. 

 

v7.24