The average small business carries $84,000 in outstanding receivables at any given time, according to Xero. A clear, professional Invoice sent within 48 hours of completing work is 3x more likely to be paid on time — this template makes that the default.

What’s inside this Invoice template

• Deposit and instalment tracking — record partial payments and show the remaining balance
• Project-based invoicing — group line items by project phase or deliverable
• Colour-coded payment status — overdue invoices turn red automatically after the due date
• Monthly revenue summary — see total invoiced and total collected, side by side

How to use this Invoice template

1. Click above to open the template.
2. Save your own version with File → Make a copy.
3. Set up your default tax rate and payment terms in the configuration row.
4. Duplicate the invoice tab for each new invoice and increment the invoice number.
5. Mark invoices as paid in the tracker tab to keep your outstanding balance current.

Why Google Sheets for Invoice?

Google Sheets lets you send professional invoices without paying for invoicing software. The template works on any device, updates in real time if you share access with a bookkeeper, and exports to PDF in one click when the client needs a formal document.

Frequently asked questions

Can I track whether invoices have been paid?

Yes. The template includes a payment status column and a tracker tab that shows all outstanding invoices and their due dates in one view.

Does the template handle different tax rates?

Yes. The tax rate is a configurable cell — change it once and every invoice in the file applies the updated rate automatically.

What if I invoice in multiple currencies?

You can change the currency symbol per invoice by editing the formatting on the relevant cells. For businesses invoicing regularly in multiple currencies, duplicate the invoice tab and configure each version separately.