|
Quick
Links Quick Facts Use
this tool to track your time in Excel and import time into QuickBooks. This
tool has a free trial. Supported
on Windows only. Other Tools New! Package Deals |
XL
Timesheets for QuickBooks
Manage your Employee’s timesheets in Excel and
Import them into QuickBooks! Use this tool to
quickly enter time in Excel for individual employees, groups of employees, or
have your employees fill out excel-based timesheets (included!) and then
import into QuickBooks. You can batch-create
customized timesheets using Excel, email timesheets to employees, and then
batch-import timesheets into QuickBooks.
The XL Timesheet also supports importing time records from other
sources, such as time clock software. Enter start/stop times
in Excel. Timesheets will automatically calculate the time worked for import
into QuickBooks. Create timesheets for
one or multiple employees. Or, include multiple employees on one timesheet so
you can copy/paste time from one employee to another to speed data entry. Version 3 now includes key new features making this tool a solution for individuals &
for time tracking administrators! ·
New! Enter start/stop time in
time templates. They’ll automatically calculate total time worked. ·
New! Support for 1099 Vendor
timesheet. ·
Multiple timesheet templates: Use ours or easily create custom
templates! ·
Batch-create multiple timesheets at once for selected employees.
Auto-save them as individual Excel workbooks on local or network drives. ·
Batch email timesheets to employees (when integrated with the XL Email Manager.) ·
Export multiple timesheets to a single IIF file for one import into
QuickBooks! The tool works with
Excel 97 - 2007 for Windows. It creates IIF files for import that are
compatible with QuickBooks 99 – 2008 Pro and all versions of QuickBooks
Enterprise (note that QuickBooks Basic and Simple Start do not have timesheet
features.) Trial Period This tool
can be downloaded for a free trial, allowing you to try before you buy. Download
your free trial & give it a test drive now! In trial
mode, you can use the tool to create a limited number of time records for
import into QuickBooks, but all other features are available. After purchase,
you can use the tool to import hundreds or thousands of time records at a
time. Purchase Information Registration keys can be purchased for just $49. Purchase Now. Screenshots Creating a new Timesheet. Here
two employees of three are selected, for batch-creating. Note there will be 14 days on the resulting
timesheets and they will be automatically emailed to the employees at their
email addresses (entered in QuickBooks on each employee record.)
Choose which columns are displayed on the new timesheets:
Include pick-lists on the timesheets:
Timesheets ExamplesAn single-employee timesheet:
A timesheet with start/stop times and automatically calculated total
hours per day:
The Manage Template dialog allows you to create new templates, which
are then available when creating timesheets:
The XL Timesheet can automatically calculate overtime based on your
time data:
|
MS Excel is a registered
trademark of Microsoft, Inc. QuickBooks
is a registered trademark of Intuit, Inc.