Help Guide
Everything you need to know to import your timesheets into QuickBooks Online quickly and accurately.
Process Overview
-
1
Connect to QuickBooks
Click Connect to QuickBooks on the home screen. You will be redirected to Intuit to authorise access. Once approved, you are returned to the app automatically. The connection status in the top-right of every page shows whether you are connected.
Your connection is held in memory. If the server restarts, you will need to reconnect.
-
2
Download the Template
Click Download Template after connecting. The template is generated live from your QuickBooks data — employee names, customers, and service items are pulled directly from your company and pre-loaded as Excel dropdowns. If you download before connecting, these dropdowns will be empty.
-
3
Fill in the Template
Each row is one time entry. Use the dropdowns for Employee, Class, Customer, and Service Item — names must match QuickBooks exactly, and the dropdowns guarantee this. The columns are:
Column Format Required Date Select from date picker or type yyyy-mm-dd Yes Employee Name Dropdown — from your QBO employees Yes Class Dropdown — Netfront's 11 business segments Yes Customer Dropdown — from your QBO customers Yes Service Item Dropdown — from your QBO service items Yes Hours Decimal number, e.g. 1.5 Yes Description Free text No Billable (Yes/No) Yes or No No — defaults to No Blank rows between entries are fine — they are skipped automatically.
-
4
Import
Save your file as
.xlsxand upload it in Step 3 on the home screen. Click Import to QuickBooks. Depending on the number of rows, this may take a few seconds while the app validates names against QBO and creates each time entry. -
5
Review the Results
Every import shows a result summary broken into four tiers. See below for a full explanation of each.
Understanding Your Results
Successfully created as a time entry in QuickBooks Online.
An identical entry (same date, employee, customer, and service) already exists in QuickBooks. The row was skipped to prevent double-counting.
A name in the row (employee, customer, service item, or class) could not be matched in QuickBooks. Check the list below the summary for details. Re-download the template to get fresh dropdowns, correct the data, and re-upload.
The QuickBooks API rejected the entry after a valid match was found. This is usually a temporary API issue. Try re-importing the affected rows.
Pricing
Monthly Subscription — $2 per user per month
Billing is based on the number of active users in your QuickBooks Online company. You are invoiced monthly. There are no setup fees and no lock-in contracts.
For billing enquiries, contact SheetSyncs@netfront.com.au.
Tips
- Always download a fresh template if you have recently added new employees or customers to QuickBooks — the dropdowns are generated live.
- You can upload the same file multiple times safely — duplicate entries are detected and skipped.
- Leave the Description column blank if you want the app to generate one automatically (Service Item – Customer Name).
- Use the Billable column to control whether time appears on customer invoices in QuickBooks.