Skip to content

Excel Timesheet Link


Import time records into QuickBooks from Excel. Batch-create time sheets for your employees to fill out. Includes several customizable time sheet templates to suit many needs.

Purchase License

Manage your Employees’ time sheets in Excel and Import them into QuickBooks!

Use this addin to quickly enter time in Excel for individual employees or groups of employees.  Or or have your employees fill out excel-based time sheets and then import into QuickBooks.

You can batch-create customized time sheets using Excel, email time sheets to employees, and then batch-import time sheets into QuickBooks. The Excel Timesheet also supports importing time records from other sources, such as time clock software.

Enter start/stop times in Excel. Time sheets will automatically calculate the time worked for import into QuickBooks.

Create time sheets for one or multiple employees. Or, include multiple employees on one time sheet so you can copy/paste time from one employee to another to speed data entry.

Key Features

  • Support for employee and vendor time sheets. Choose between no vendors, 1099 vendors only, or all vendors.
  • Multiple time sheet templates included. Use one of the included templates or create your own custom time sheet templates.
  • Enter start/stop time on time sheets. They Excel Timesheet add-in will automatically calculate total time worked.
  • Batch-create multiple time sheets all at once for selected employees. Auto-save them as individual Excel workbooks for later use.
  • Export multiple time sheets to a single IIF file for one import into QuickBooks!
  • When paired with our Excel Email Manager, email time sheets directly to employees as they’re created.
  • For quick data entry, pick lists are pulled from your company file and included on your time sheets.  These include lists for employees, items, payroll items, classes, and customer:jobs.
  • Automatic calculation for overtime and double time & now auto-selects overtime and double time items from your employee records or payroll item list.
  • Automatically gets the default hourly or salary item from employees.
  • Additional error checking to prevent error messages when importing into QuickBooks.
  • Direct connect to QB to integrate lists with your company file.

Free Trial

Download this addin for a free trial, which allows you to try before you buy. You can use the trial to test the addin in your environment to create up to 100 individual transactions (e.g. 100 time records.)  When you purchase then use your product key to unlock the trial to the full version.


Release Notes

4.19: Re-enable the Options tab on the Integrate with QuickBooks dialog, which was accidentally hidden in release 4.11.

4.18: Make sure 0.00 time records aren’t written to the IIF file when they’re a result of shifting all the time to overtime or double time.

4.17: Fix issue with Customer:Job changes in 4.16 where Customer:Job wasn’t being included in the IIF file.

4.16: Make sure time sheet and time list subtotal rows aren’t seen as time rows when exporting.  Add option to reorder and sort the Customer:Job list by Job:[Customer] for easier data entry.

4.15: Set and correctly display good through date in About dialog for certain upgrade paths.

4.13: Updates name mapping logic. Made the mapping dialog wider for improved usability.

4.12b: Installer updated related to integration issues.

4.12: Make sure that Jobs names entered on the time sheet are not too long and they are formatted correctly with no spaces between the name levels – in the format [Customer]:[Job] – when written to the IIF file.

4.11: Resolve QuickBooks integration issues with recent QB patch releases.

4.08: Handle issue when integrating to avoid QB crash.

4.07: Now export time records to IIF when the duration is 0.00 (but not blank.)

4.06: Add details to the IIF files created by the app to assist support.

4.05: Update connection error messages to include more details and updated help text.

4.04: Change code that finds the Excel custom Ribbon file.

4.03: Fix name loading/matching for very large names lists.

4.02: Fix issue with time list export and overtime calculation.

4.01: Enabled automatic OT calculation for multi-employee time sheets. Fix an issue with double-time calculation. Make integration prompt hide-able for a day. Update dialog windows for clarity.

3.99: Now find Jobs even when only the Job name is specified instead of the Customer:Job.  Fix key display issue in the About & Purchase dialog.

3.98: Changes to accommodate QuickBooks 2019 and Enterprise 19.0

3.97: Changes to About & Purchase dialog to handle more than one product key.  Fix for Excel 2016 to resolve issue where app would not load properly.

3.96: Changes when saving custom time sheets to prevent excel information messages about file formats.

3.95: Changes to connection method when pulling QB lists, especially when using 64-bit Excel.  Now default to faster alternate connection method for all versions of Excel. It appears to be more reliable as previously implemented in the IIF Transaction Creator and other apps.   Also, user interface changes for a better experience using newer versions of Excel.