Exporting Patriot Software Payroll to QuickBooks Desktop via IIF
Background on Generating Your QuickBooks IIF
If you use the desktop version of QuickBooks for your accounting software and Patriot Software to run payroll, you may want to export your payroll data into QuickBooks. An Intuit Interchange Format (IIF) file is a file specifically used to import transactions into QuickBooks. You can create this file using Patriot and then upload it to your QuickBooks, so that you have all your payroll data easily accessible. If you use QuickBooks Online, see the help article Integrating Patriot Software with QuickBooks Online.
Setting Up Your Export for QuickBooks Desktop
First, you will need to select QuickBooks Desktop by going to Settings > Payroll Settings > Payroll Integration Options.
Choose QuickBooks Desktop from your list of options.
You will then be able to add your QuickBooks account names in order to match the information from Patriot Software into QuickBooks. This is a set-up process that you’ll only need to do once, or whenever your QuickBooks account names change.
There are categories of payroll information that you’ll need to assign QuickBooks account names in order to create a journal entry for your payroll. You may use the same accounts for multiple categories.
Matching Up Your QuickBooks Chart of Accounts
You must type the name of your QuickBooks account name exactly how you have it set up in QuickBooks (including spaces) in order for the export file to match it to the correct account. Do not include the account number or the dot before the account name. Otherwise, if the account names don’t exactly match, QuickBooks will create a new account with the name you have entered in Patriot Software. You will then need to change it to the correct class in QuickBooks.
If you use sub-accounts, you must enter a colon (:) in between your main account name and sub-account name. Example: “MainAccount:SubAccount”
If you have multiple locations set up on your account, you can include the location as a class name. Be sure your Quickbooks class names exactly match the location nicknames on your Settings > Company Settings > Manage Locations page.
Gross Pay – Gross pay is the total compensation you pay to your employees.
Net Pay – Net pay is the employee’s actual check amount after taxes and deductions have been taken.
Employee Taxes – Employee taxes are your employee’s tax obligations that you withhold from their pay and remit on their behalf. If you are a basic payroll customer, select the liability account to apply these entries. If you are a Full-Service payroll customer, select the asset account these taxes will be withdrawn from.
Employer Tax (Expense) – This includes all employer taxes such as Social Security, Medicare, unemployment, and any other employer-paid taxes you may have in your state.
Employer Tax (Remittance) – This represents the asset or liability account you will use to record your employer taxes expense. If you are a basic payroll customer, select the liability account to apply these entries. If you are a Full-Service payroll customer, select the asset account these taxes will be withdrawn from.
Employee Deductions – This includes all employee deductions, such as 401(k) or health insurance. You will only see this if you have at least one company level deduction set up in your Patriot Software payroll account. You will enter an account for each employee deduction.
Employer Contributions – This includes all employer-paid contributions such as employer 401(k) contributions or the company portion of health insurance premiums. You will only see this if you have at least one company level contribution set up in your Patriot Software payroll account. You will be required to enter both an expense and liability account for each company level contribution in your Patriot Software payroll account.
Non-Remitted Taxes – This only applies if you are a full-service payroll customer located in New York, Hawaii, or Washington. Because Patriot does not remit or collect New York SDI and FLI, or Hawaii SDI you will choose a liability account to apply these entries. The exported file will show these as a separate entry in QuickBooks.
Creating the QuickBooks File
You can create an IIF File any time after you run a payroll. Go to Payroll > Payroll Tasks > Export Payroll.
- Enter the Start Date and End Date range for the pay dates you want to include.
- Select the employees to include.
- For the Source, you can include all payroll sources, or select certain types of payroll information.
- Enter a starting entry number for QuickBooks.
- Click “Run Export.”
The IIF file will download. Save this file to your computer, and import it into QuickBooks. We recommend that you also read Intuit’s help articles on importing transactions into QuickBooks and backing up your QuickBooks information prior to importing.
If you need to change account names after you have downloaded the file, you can re-run the export to recreate a new QuickBooks IIF file with new account names at any time.
QuickBooks is a registered trademark of Intuit Inc.