Exporting the Employee & Payroll Item lists from QuickBooks®
2001 & above
| Two (2) report exports are required from
QuickBooks to use this method: Employee List and Payroll
Item list. (these are in addtion to the transaction report that
exports the payroll data). |
|
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" 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.
|
Configuring and Memorizing the Employee List report
|
1. Drop down the "Reports" menu and select the
"Employees & Payroll|Employee Withholding report" menu
item.
|
|
2. Click the "Modify Report..." button and select at
minimum the following columns: "Active Status"
"Employee" "First Name" "M.I."
"Last Name" "SS No." "State Lived"
"State Worked" -- 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.
|
Configuring and Memorizing the Payroll Items List report
|
1. Drop down the "Reports" menu and select the
"Employees & Payroll|Payroll Item Listing report" menu
item.
|
|
2. Click the "Modify Report..." button and select at
minimum the following columns: "Payroll Item"
"Type" "Amount" "Annual Limit"
"Expense Account" "Liability Account"
"Locality" "State" "Payable To"
"Tax Tracking" "Account Id" "Gross or
Net" -- or you can 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.
|
|
