Export your payroll data into QuickBooks
by Intuit•16• Updated 3 weeks ago
Learn how to export your QuickBooks Online Payroll data to QuickBooks Online or QuickBooks Desktop after you have set up your payroll.
If you're using QuickBooks Online Payroll Core, Premium, or Elite without accounting (standalone payroll), you may have another QuickBooks company file. You may use this file for your accounting without payroll being turned on. To keep your company file updated, export payroll transactions to QuickBooks Online directly or QuickBooks Desktop using Intuit Interchange Format (IIF).
Notes:
- This article is for customers who have finished payroll setup. Export connection on the standalone payroll will expire if you have payroll attached to your QuickBooks Online account.
- Export setup must be completed by the Primary Admin. If the Primary Admin is also a Firm user, they must transfer the role to a non-Firm user first.
- Standalone Payroll can't export transactions to QBO accounts with payroll.
For a better experience, open this article in QuickBooks Online. Launch side-by-side view .
Standalone Payroll export blockers and limitations
- Export setup must be completed by the Primary Admin. If the Primary Admin is also a Firm user, they must transfer the role to a non-Firm user first.
- Standalone Payroll can't export transactions to QBO accounts with payroll.
Step 1: Setup your preferences in your payroll account
- Go to your Core, Premium, or Elite payroll account.
- Select Settings ⚙, then Payroll settings.
- In Export, select Edit ✎.
- Choose your accounting software:
- QuickBooks Desktop for Windows
- QuickBooks Desktop for Mac
- QuickBooks Online - You’ll be asked to sign in to your QuickBooks Online account to sync them. Sign in to your QuickBooks Online, then select the company your payroll transactions should sync to.
- Quicken for Windows or Mac
- Select Continue.
- QuickBooks will create default accounts for your wages, expenses, and liabilities. Select Edit ✎ to modify these accounts as it appears on your QuickBooks chart of accounts.
- When complete, select Done twice.
You can make changes to your preferences at any time.
Step 2: Export your payroll transactions
Each time you process payroll, you'll see an option to export the transactions from the most recent payroll run.
For any other time, you have multiple ways to export your payroll transactions. Choose the one that best fits your situation.
Step 3: QuickBooks Desktop only: Import .IIF into QuickBooks Desktop
After selecting Export or Export selected paychecks, an .IIF file will be downloaded to your Downloads folder. Don’t open the IIF file.
Next, import the exported payroll transactions into your Quickbooks Desktop:
- Sign in to your QuickBooks Desktop.
- Go to File, then Utilities.
- Select Import, then Import IIF.
- Select the IIF file you want to import, then select Open. Check your downloads folder to locate the .IIF file.
- Select OK.
Check out Export, import, and edit IIF files to learn more.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Export reports as Excel workbooks in QuickBooks Desktopby QuickBooks•36•Updated January 08, 2024
- Cancel Your QuickBooks Payroll Subscriptionby QuickBooks•1157•Updated June 25, 2024
- Sync data between ADP RUN and QuickBooks Timeby QuickBooks•14•Updated over 1 year ago
- Import and export employee data in QuickBooks Onlineby QuickBooks•100•Updated January 29, 2024