Why use Google Sheets for invoices
Google Sheets is free, works on any computer or phone, and keeps every file in Drive. A cleaning business with two or three people can share one folder of invoices, and anyone can check what was billed without passing files around.
A spreadsheet also does the sums, which is the big advantage over a document. The downside is everything a spreadsheet does not know: which number comes next, which clients you have, whether last month's invoice was paid. Those stay manual in Sheets.
Making the invoice here first gives you automatic numbering and correct VAT, and the file you open in Sheets still has working formulas for later changes.
How to open the invoice in Google Sheets
There is no button that sends the invoice straight to Sheets. You download the Excel file and Drive opens it:
- Fill in and finish the invoice above.
- On the done screen, under Also as Word · Excel, tap Excel to download the .xlsx.
- In Google Drive, choose New, then File upload, and pick the file.
- Right-click it and choose Open with, then Google Sheets.
- Choose File, then Save as Google Sheets if you want a native Sheets copy you can share and edit freely.
From then on, File, Download, PDF gives you a copy to send the client.
The formulas, and how to add a line
Column D holds the amounts. Each line is Qty × Price (for example =B14*C14), the subtotal is a SUM over the item rows, VAT is (Subtotal − Discount) × 20%, rounded to the penny, and the total is Subtotal − Discount + VAT. Prices show the currency code, such as 280.00 GBP.
The SUM covers a fixed block of rows, so a line typed below the last item will be left out of the total. To add one properly:
- Right-click the row number of an item that is not the last one, and choose Insert 1 row above.
- Select the Amount cell of the row above, copy it, and paste it into the new row. Sheets adjusts the row numbers in the formula.
- Fill in the description, quantity and price.
- Click the Subtotal and check the range in the formula bar includes the new line.
If you charge a different VAT rate, edit the number inside the VAT formula. With more than one rate on the same invoice, the tax cells hold fixed amounts, so redo the invoice here if the lines change.
Details a business client will check
Letting agents, offices and property managers pay from an accounts department, and an invoice missing a detail often goes to the bottom of the pile. If you are VAT-registered in the UK, a full VAT invoice usually needs:
- A unique invoice number and the date.
- Your business name and address, and your VAT registration number.
- The customer's name and address.
- A description of each service, the price excluding VAT, the VAT rate and the VAT amount.
- The total, including VAT.
It also helps to quote the property or job reference, as in the example, so their team can match it to a work order. Not VAT-registered? Leave the VAT number off and set the rate to 0.
Last checked October 23, 2026.