Tools for Accountants, Bookkeepers 
& Small Business Owners
Downloads | Purchase | Support | Links | Main Page | News | Search |  
Products:
Qxtender
Qslip
Qxtender Plugins:
CA - BOE-401
Sales Tax Report
CA - DE-542
Contractor Report
CA - DE-6
Quarterly Report
CA - DE-7
Annual Report
CO - UITR-1
Quarterly 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

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 "Modify..." 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"
"Account"
"Amount"

Click "OK" to continue.

 

Click the "Print..." button.

 

3. Change the "Print to:" option to "File:", and change the type to "Tab 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 the QuickBooks 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 & QuickPayroll are registered trademarks of Intuit, Inc.