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:
- Exporting the pay run data from OnPay as a single file
- Importing that file into QuickBooks Desktop
What we'll cover
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.
Exporting from OnPay
Click Company, then App Directory.
Click My Apps and select QuickBooks Desktop.
Click Pay Runs to the right of Settings.
Identify the pay run you want to export, and click Download to save the file to your computer.
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.
Importing into QuickBooks Desktop
In QuickBooks Desktop, click File > Utilities > Import > IIF Files.
Click Import IIF.
Then locate the file and click open.
QuickBooks will prompt you that the data has been imported successfully.
v7.24