TSheets + Xero integration: Create, edit and delete an invoice
Note: You must be an account administrator in TSheets to create, edit, or delete invoices. Invoices sync seamlessly between TSheets and Xero and will appear in both places.
Basic invoice flow
Contacts, customers, inventory items (along with their billing rates), and Employees (if in Australia) are set up in Xero.
These items are then imported into TSheets.
Employees use TSheets to track hours worked, indicating which customers they worked for, and which services were performed.
The administrator or payroll manager then creates an invoice in TSheets. The invoice is marked DRAFT.
The invoice is synced to Xero, where they can be reviewed and sent to customers. Invoices are then marked as SENT.
When the invoice is paid, it is automatically marked as PAID in TSheets.
To create an invoice
In TSheets, selec Xero at the top right > Invoicing.
In the Invoices window, select New Invoice.
In the Invoice Options window, select a customer and set the filters:
Who do you want to bill?: Displays all Xero Contacts. If time has been tracked agasint that contact, the number of uninvoiced hours display next to it. If a Contact is selected that has not been added as a Customer in TSheets or has no time tracked, it opens a “Select Work to Bill” option to choose a TSheets Customer’s time to invoice to that Contact.
If you choose Selected next to the Filter by filters, employees and inventory items imported from Xero display as choices, as well as any items from Custom fields you added in TSheets. If no time has been tracked by the selected employees or against the selected customers or inventory items, an invoice with no line items displays. You can then add items into the invoice manually.
Time: By default, All Uninvoiced time is selected. Select the drop-down to choose a week, month, or date range.
Summarize Invoice by...: Choose how you would like your invoice to appear. Detailed displays all information attached to any timesheet on that invoice.
Select Create Invoice and a draft invoice displays.
Review the invoice, make edits (if needed), and select Save Invoice or Save Invoice & View in Xero.
To edit an invoice
In TSheets, go to the Invoices list, select an invoice, and do one of the following:
Add a line item: At the bottom, select Add Line Item.
Edit individual entries: Select in any field (except Amount, which is an automated calculation), and make your changes.
Reorder a line: Select the , and drag the line up, down, or into the Write Off box (if shown).
Write off a line item: To the right of the amount, select Write Off. The line item displays in the Write Off box below the invoice. To return it to the uninvoiced section, drag it up, or uncheck Write Off.
Delete a line item: Select X .
Note: A deleted line item will not be considered "invoiced" and will appear on a later invoice for that customer. A line item that is written off will be considered "invoiced" and will not appear on a later invoice.
Select Save Invoice or Save Invoice & View in Xero.