Frequently Asked Questions

The template is generated live from your QuickBooks company. Employee names, customers, and service items are pulled directly from QBO and embedded as dropdown lists so that every name you enter is guaranteed to match. If you download before connecting, these dropdowns will be empty and your import will likely result in Skipped rows.

Connections are held in memory. If the server restarts for any reason, you will need to reconnect via the Connect to QuickBooks button. Your existing QuickBooks data is not affected — only the session token is lost.

Yes — open the downloaded template in Google Sheets, fill in your data, then export it as File → Download → Microsoft Excel (.xlsx) before uploading. Note that Google Sheets may not enforce the dropdown validation, so take care to match names exactly.

The dropdowns are sourced directly from your QuickBooks company. If a name is missing, it either doesn't exist in QBO yet or is marked as inactive. Add or reactivate the record in QuickBooks first, then re-download the template — the new name will appear in the dropdown.

Yes. Blank rows are detected and skipped automatically. You can structure your spreadsheet however suits you — entries below a blank row will still be imported.

The app generates a description automatically in the format Service Item – Customer Name. You can override this by entering your own text in the Description column.

Setting a row to Yes marks the time entry as billable in QuickBooks, meaning it can appear on a customer invoice. No marks it as non-billable. If left blank, it defaults to non-billable.

Yes — it is safe to re-upload. Before creating any entry, the app checks whether an identical record (same date, employee, customer, and service item) already exists in QuickBooks. Duplicates are counted and listed in the results but never created twice.

Skipped rows contain a name (employee, customer, service item, or class) that could not be matched in QuickBooks. The results list will show you exactly which rows and which field caused the skip. To fix:

• Re-download the template to get an up-to-date dropdown list
• Check that the name exists and is active in your QuickBooks company
• Correct the affected rows and re-upload — duplicates from the previous upload will be skipped automatically

No. Failed rows were rejected by the QuickBooks API after a valid name match was found — this is usually a temporary API issue. The error message in the results will indicate what went wrong. Wait a few minutes and re-upload; the duplicate check will skip any entries that already succeeded.

The app first loads your QuickBooks employee, customer, service item, and class lists, then creates each time entry one at a time via the QBO API. A typical import of 20–30 rows takes 10–20 seconds. Larger imports may take longer.

Billing is $2 per user per month, based on the number of active users in your QuickBooks Online company. You are invoiced monthly with no lock-in contract.

Email SheetSyncs@netfront.com.au for any billing enquiries.