Import & Export to Quickbooks Pro
Return to Introduction  Previous page  Next page

For those using Quickbooks Pro, Power Clock can replace the QBTIMER program. Power Clock offers the ability to import and export data from/to Quickbooks in a fashion similar to how Quickbooks interfaces with its QBTIMER program.

Import from Quickbooks
importqb
This task must be performed before any data may be exported to Quickbooks.

Load Quickbooks and select the "Export Timer Lists" option. Quickbooks will create a file in the QBTimer directory. This is the file you will import into Power Clock.

From Power Clock select "Import from Quickbooks". Select the file you just exported from the open file dialog. Power Clock will create Job, Phase, and Employee records that correspond with what is setup in Quickbooks.

After you import the timer lists you may then use Power Clock to record time and later export the time records to Quickbooks to perform payroll or other reporting.


Export to Quickbooks
You must first use the Import from Quickbooks option to setup Power Clock properly.

exportqb


Quickbooks Pro version
Power Clock supports all versions of Quickbooks Pro. Select your version from the list.

Starting and Ending date

Enter the starting and ending dates for the time records you want to export.

Export only this employee
If you only want to export records for a specific employee, enter her employee ID here. Leave blank to export data for all employees.

Include already exported items
Power Clock keeps track of which records have already been exported to Quickbooks. Normally you would not want to export records more than once.

Include records with zero pay rate
Check this box to include time records with no pay rate. Examples of such records would be lunch and break time. You normally wouldn't need to import those into Quickbooks payroll.

After entering these options you are prompted for the file name to export to. The default export name is EXPORTQB.IIF.

OTHER NOTES

When exporting to Quickbooks Pro you need to make sure the following payroll items exist in QBPro.

Regular Pay
Overtime Pay
Doubletime Pay
Lunch Pay
Break Pay
Sick Hourly
Holiday Hourly
Vacation Hourly