Invoice Template Google Sheets | Invoice Tracker with Payment Dashboard | Small Business Invoicing | Instant Download

🧾 Invoice Template — Google Sheets Edition

Fill in one clean invoice, send it as a PDF, and log it in one place — then watch exactly who's paid, who's outstanding, and who's overdue update automatically. Built for freelancers, consultants, and small business owners who bill clients regularly.

---

✨ WHAT YOU GET

✅ A clean, printable Invoice tab — company info, client info, 15 line items, auto-calculated Subtotal/Discount/Tax/Total Due
✅ An Invoices log with 40 built-in rows to track every invoice you send
✅ Automatic red flag when an unpaid invoice is past its due date — no manual status updates needed
✅ Full payment Dashboard — Total Invoiced, Total Paid, Total Outstanding, Overdue Amount, Avg Invoice Value
✅ Paid vs. Outstanding and by-status breakdown with visual bars and charts
✅ Color-coded, protected cells — formulas can't be accidentally overwritten
✅ Works in Google Sheets AND Excel — no special functions, no compatibility gaps

---

📦 FILES INCLUDED

• InvoiceTemplate_GoogleSheets.xlsx — the spreadsheet (import into Google Sheets or open in Excel)
• Instructions.html — full user guide

---

🚀 HOW IT WORKS

1. Download the .xlsx file
2. Upload it to Google Sheets (File → Import → Upload) or open it directly in Excel
3. Fill in your company info once at the top of the Invoice tab
4. Fill in the client's info, invoice #, dates, and line items — totals calculate instantly
5. Export to PDF (File → Download → PDF) or print, and send it to your client
6. Log it on the Invoices tab — mark it Paid once you've been paid, and the Dashboard updates automatically

---

📊 KEY FEATURES

• Auto-calculated Subtotal, Discount %, Tax %, and Total Due on the Invoice tab
• Invoices log: invoice #, client, issue date, due date, amount, status, paid date
• 🎉 Overdue invoices highlight automatically — the Dashboard counts them, the log flags them red
• Paid rows highlight green so your fully-collected invoices are obvious at a glance
• Dashboard breakdown by Paid / Unpaid (not due) / Overdue — count, value, % of total

---

🔒 100% PRIVATE & OFFLINE-CAPABLE

Your data lives in your own Google Sheets copy or local Excel file — nothing is sent anywhere.

---

❓ FAQ

Q: Do I need a Google account?
A: To use Google Sheets, yes (it's free). The file also works fully in Microsoft Excel — every formula is a standard function supported in both.

Q: Can I send the actual spreadsheet tab to my client, or do I need to convert it?
A: Most people export the Invoice tab to PDF (File → Download → PDF) and send that — it looks like a normal printed invoice.

Q: Can I track more than 40 invoices, or add more than 15 line items?
A: Yes — just insert more rows on the Invoices tab or above the Subtotal line on the Invoice tab, following the same pattern.

Q: Does it calculate sales tax or VAT automatically based on my location?
A: No — you enter your own Tax % per invoice, since rates vary by location and business type.

---

⭐ PLEASE LEAVE A REVIEW
Your review helps other freelancers get paid on time. Thank you! 🙏

---

*Instant digital download — no physical product shipped.*