Contents - Index


QuickBooks Import Facility


 

The QuickBooks Import Facility is designed to access your Payroll W-2 or Accounts Payable 1099 data maintained in QuickBooks and import that data into The W-2/1099 Filer program. 

 

There are two areas which can be imported which have their own detailed instructions and should be read:

 

Payroll W-2 Import Instructions

Accounts Payable 1099 Misc Import Instructions

 

If this is the first time you are using this program you should definitely read the following:

 

Important Items to note:

QuickBooks must be running in single-user mode.

 

You must be running QuickBooks 2004 or higher for the Auto Extract to work.  In addition to our program, you are required to install the QuickBooks SDK version 5 which is distributed free of charge by Intuit

 

The Payroll Detail Review report can be generated using either a first name / last name or last name / first name format.  You must tell the program which format you are using in Step 1: Settings.  The AP 1099 Detail report must be generated using First Name / Last Name only.

 

All numeric values that are negative must be set to print out using either a preceding negative sign or parenthesis.  These settings can be found under Edit / Preferences.  We will automatically determine the format and handle it accordingly.

 

For versions 2002 to 2003, the Manual Extract should work.  That method involves printing out either the Payroll Detail Review Report or the 1099 Detail Report with specific fields and then exporting to a CSV File.  We have tested it successfully with QB 2003.  We assume it will work on versions 2002 because that version has the same modifications available on the Payroll Detail Review Report.  Unfortunately on versions 2001 and lower, Intuit does not allow the employee's address to appear on the Payroll Detail Review Report.  If you are running a version of QuickBooks 2001 or lower we have a solution for you but you will need to contact us.

 

Assumptions made concerning QuickBooks Data: