Skip to content

Timesheet Link

$79.00

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

Enter Employee time in Excel and Import it directly into QuickBooks!

Use this add-in to enter time in Excel for individuals or groups of employees and then import that time into QuickBooks.

Create time sheets for one or multiple employees. Also, optionally include multiple employees on a single worksheet time sheet so you can, for example, copy/paste time from one employee to another to speed data entry.

Batch-create customized time sheets, email time sheets to employees or managers, and then batch-import the returned & filled-out time sheets into QuickBooks.

The Excel Timesheet Link can also convert worksheets containing time records generated from other sources, such as an export from your time clock software.

 

Key Features

  • Support for employee and vendor time sheets.
  • Multiple time sheet templates are included. Use one of the included templates or create and save your own custom templates.
  • Optionally, enter start/stop times instead of durations and the add-in will automatically calculate time worked.
  • Batch-create multiple time sheets and, optionally, save them as individual Excel workbooks for later use – such as to email to employees or managers.
  • When paired with our Excel Email Manager, email time sheets directly to employees as they’re created.
  • For quick and consistent data entry, lists are pulled from your company file and included as pick lists on your time sheets. Lists of employees, items, payroll items, classes, and customer:jobs and all be included.
  • Direct connect to QB to integrate these lists with your company file.

When creating IIF files for import into QuickBooks:

  • Automatic calculation of overtime and double time based on rules you specify.
  • Auto-select overtime and double time items based on your employee records & payroll item list.
  • Automatically select the default hourly / salary item from employee records if omitted.
  • Error checking of your time sheets to prevent errors when importing into QuickBooks.

 

Free Trial

Download this add-in for a free trial, which allows you to try before you buy. You can use it to test in your environment to create up to 100 individual time records. After purchase use your product key to unlock the trial to the full version.

Screenshots

Release Notes

4.39: Ensure logos added to custom time sheet templates retain their size and shape on new time sheets. Bring the success message forward after creating time sheets.

4.38: Rework automatic overtime calculation configuration dialog to make it easier to use.  Resolve ribbon tab conflict between the List Importer and Timesheet Link.

4.37: New feature to try to detect and repair a broken QuickBooks connection with no need to re-run the installer.

4.36: Fix the 32 bit connection method again. This time… really!

4.35: Fix issue seen during integration when using the 32 bit connection method where an erroneous message indicated an invalid list. Spruced up the success message shown after creating time sheets.

4.34: Make sure that when saving time sheets as files no reserved characters are used.  Update various windows for usability.  Major edit and reorganization of the documentation file.

4.33: Fixed an issue where an employee could appear twice on the lists of employees. Refined lists integration dialog window.

4.32: Make sure older annual keys work properly with newer primary keys. Better alert messages when subscription is due or overdue. Add warning to delete key message to explain that it’s unusual to delete keys. Optimize searching for names as when creating time records for the IIF file.  Add help text to connection dialog regarding connection issues.  Fix issue on the create time sheets window where previously selected employees were not saved and set automatically.

4.31: Add list integration options to skip the customer, vendor, other name, and items lists.

4.29: Make the special import instructions button actually work.

4.27: Add QB version info to exported IIF file for support.  Add special import instructions to ‘success’ dialog for QB 2019 & newer.

4.24: Fix code that saves preference for filtered payroll item pick list.

4.22d: Reapply the digital signature to the installer.

4.22c: Additional changes to installer related to repairing the QuickBooks connection.

4.22b: Installer related changes to repairing the QuickBooks connection.

4.22: Extend changes in 4.21 to handle worksheets protected with a password.

4.21: Better handling for protected worksheets – allowing the Timesheet Link to correctly determine cell formulas where present.

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.