Instead of following the steps below, you can download this importable QuickBooks Report Group: Qxtender Payroll Reports (with pre-configured Employee, Payroll Items, and Payroll Transaction reports)

In QuickBooks open the Memorized Reports List (Reports | Memorized Reports)

Drop down the lower left button "Memorized Reports" and choose "Import Template..."

Locate the QBR file and click Open.

Now your Reports | Memorized Reports menu will have a new sub-menu named "Qxtender Reports". Within that are three reports:

QX - Payroll Transaction Detail
QX - Payroll Item Listing
QX - Employee Withholding (Incl. SSN)

If you have already memorized the required reports just Drop down the "Reports" menu and select them from the "Memorized Reports list" menu item.

(If not, just follow the instructions found later on this page to configure and memorize these two reports.)

For each report:

Click the "Print..." button on the report, then set "Print to:" to "File:" and select "Tab-delimited" or "Comma Separated" from the drop-down list.

Click the "Print" button to open a Filesave dialog.

Name the Employee List something like "Emplist.txt" and the Payroll Items List something like "PayItemlist.txt".

Then hit the "Save" button. Note where you save the files, so you know where to browse to when the QxPlugin requests them. QxPlugins will look in the QuickBooks folder first, but will recall any folder in which you choose to regularly save your export files.

1. Drop down the "Reports" menu and select the "Employees & Payroll|Employee Withholding report" menu item.

2. Click the "Modify Report..." or "Customize Report..." button and select at minimum the following columns:

• Active Status
  
• Employee
  
• First Name
  
• M.I.
  
• Last Name
  
• SS No.
  
• Hire Date
  
• Release Date
  
• State Lived
  
• State Worked
  
• SUI
  
• Soc. Sec.
  
• Medicare
  
• FUTA

-- or select all the available columns listed (by placing a check mark next to each -- you can do this quickly by dragging the mouse down the list).

Important: On the "Filters" tab, set "Active Status" to ALL.

4. Click the "Memorize..." button.

Name the report something like "Employee List Export" and hit the "Ok" button.

1. Drop down the "Reports" menu and select the "Employees & Payroll|Payroll Item Listing report" menu item.

2. Click the "Modify Report..." or "Customize Report..." button and select at minimum the following columns:

• Active Status
  
• Payroll Item
  
• Type
  
• Amount
  
• Limit
  
• Expense Account
  
• Liability Account
  
• Locality
  
• State
  
• Payable To
  
• Tax Tracking
  
• Account Id
  
• Gross or Net
  
• Limit Type

-- or select all the available columns listed (by placing a check mark next to each -- you can do this quickly by dragging the mouse down the list).

Important: On the "Filters" tab, set "Active Status" to ALL.

4. Click the "Memorize..." button.

Name the report something like "Payroll Item List Export" and hit the "Ok" button.