Start from a template that already knows your business
Every Time On It template is generated fresh from your connected QuickBooks Online account. The Employee, Customer, and Service Item columns are dropdown lists built from your actual QBO data - not free text - so there's no way to misspell a client name or reference a service item that doesn't exist. Your team fills in dates and hours; the template handles the rest.
Upload without worrying about double entry
Before creating anything, every row is checked against your existing QuickBooks time entries. If a row already exists - because someone re-sent last week's file, or you're re-uploading after fixing a typo - it's skipped and reported as a duplicate rather than created a second time. That means you can always re-upload a corrected file without manually figuring out what's already gone through.
- ✓ Billable status, descriptions, and spell check included on every row
- ✓ Handles batches of hundreds of rows from multiple employees in one file
- ✓ Every upload is logged - see exactly what happened on the Audit Trail
What to expect the first time you import
Connect your QuickBooks Online account, download the template, and open it in Excel or Google Sheets. Each dropdown column shows exactly what's in your QBO file, so filling it in is a matter of selecting the right employee, customer, and service item rather than typing anything. Once you upload, results appear within seconds: how many rows were imported, how many were duplicates, and details on any row that didn't match - with the specific field and reason. For a full step-by-step walkthrough, see How to Import Excel Timesheets into QuickBooks Online.
Frequently asked questions
Does the spreadsheet need to match my QuickBooks setup exactly?
You don't need to type anything from memory. The template's employee, customer, and service item columns are dropdown lists pulled directly from your QuickBooks Online account, so every entry is guaranteed to match an existing record.
What happens if I upload the same file twice?
Time On It checks each row against existing QuickBooks time entries before creating anything. Rows that already exist are skipped and reported as duplicates, not re-created - so re-uploading a corrected file is always safe.
How many rows can I import at once?
There's no practical row limit for a single upload - teams regularly import several hundred rows covering a dozen employees in one file.
Try it with your own QuickBooks data
Connect your QuickBooks account and download your first template in under a minute.
Start free trial →