Tools for Accountants, Bookkeepers 
& Small Business Owners
Downloads | Purchase | Support | Links | Main Page | News | Search |  
Products:
Qslip
Prints Deposit Slips
Qxtender
Hosts Plugins
Qxtender Plugins:
Contacts
Exporter
Leads
Exporter
ShipTo Address
Exporter
CA - DE-9/9C
Quarterly Report
CA - DE-542
Contractor Report
IRS - 941 &
Schedule B
NY - NYS-45
Quarterly Report
TX - C-3/C-4
Quarterly Report
 

Exporting the Payroll Transaction Detail report from QuickBooks® 2001 & Above

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)

 

1. Drop down the "Reports" menu, go down to "Employees & Payroll " and expand the sub-menu, then select "Payroll Transaction Detail".

 

2. The report will open with its default dates.

Change the "From" date to January 1st of the year of the reporting period (eg. 01/01/1999).

Change the "To" date to the end of the reporting period, or later to ensure final liability payments are picked up. Press [tab] to recalculate the report.

 

IMPORTANT:

You must click the "Customize Report" button and place a checkmark next to the following columns:

  • Trans #
  • Type
  • Date
  • Num
  • Name
  • Source Name
  • Paid Through
  • Payroll Item
  • Income Subject To Tax
  • Wage Base
  • Wage Base (Tips)
  • Account
  • Amount
  • Account Type
  • Pay Period Begin Date
  • Pay Period End Date

Do not select all columns as a shortcut as this will cause the report size to be very large and cause performance problems.

Click "OK" to continue.

The first time you modify this report, save it for future use. Click the "Memorize..." button and name the report something like "QX Payroll Detail Report" and hit the "Ok" button.

 

Click the "Print..." button.

 

3. Change the "Print to:" option to "File:", and change the type to "Tab delimited file" or "Comma delimited file".

Click the "Print" button.

 

4. Name the file something like "Payrpt.txt" and hit the "Save" button.

Note where you save the file. QxPlugins will look in your documents folder first, but will recall any folder in which you choose to regularly save your export files.

 

Copyright Qtools Software - © all rights reserved

QuickBooks, QuickBooks Pro, QuickBooks Premier & QuickBooks Enterprise are registered trademarks of Intuit, Inc.