Freelancer Invoice & Billing Tracker — Google Sheets + Offline App

**Sending the invoice is easy. Getting paid is the hard part.**

The **Freelancer Invoice & Billing Tracker** is a complete billing system for solo service providers who need to know what's been sent, what's been paid, what's overdue — and who their best-paying clients are.

No subscription. No accounting software. No learning curve.

**This purchase includes two versions — use whichever fits your setup:**

🗂 **Google Sheets version** — click the included link, make a copy to your Google Drive, and start logging invoices immediately. No setup, no script to run.

💻 **Standalone offline app** — a single `.html` file that opens in any browser. No login, no internet required, no Google account needed. Data saves automatically in your browser.

Both versions have identical features: five-tab structure, overdue alerts, live dashboard, charts, and full sample data pre-loaded.

---

### WHAT YOU GET

**📊 Dashboard**
Your billing command center:
- 4 KPI cards: unpaid invoice count, outstanding amount, collected this year, collection rate
- Invoice status breakdown table: count, total, average, and age by status
- Overdue invoice alert banner — flags anything past due
- Monthly collections bar chart + invoice breakdown by status doughnut chart

**🧾 Invoice Log**
One row per invoice. Track client, invoice number, invoice date, due date, amount, status, paid date, project description, and notes. Status color-codes automatically — green for Paid, amber for Unpaid, red for Overdue, gray for Cancelled. Due date turns red automatically if the invoice is unpaid and past due.

**💼 Client Rates**
Your rate card in one place. Log each client's rate type (hourly, retainer, flat rate, project-based), their rate, average hours per month, estimated monthly value, and payment terms.

**💳 Payment History**
A receipts log for every payment received. Log client, invoice number, amount, payment date, method (PayPal, Stripe, bank transfer, check, etc.) and a reference or memo. Useful for reconciling payments and pulling data at tax time.

**💰 Revenue Summary**
Month-by-month: Invoiced, Collected, Outstanding, and Cumulative Collected for the year. Annual totals auto-calculate. Client leaderboard shows your top 5 earners by total paid amount.

---

### HOW IT WORKS

**Google Sheets version:**
1. Open the included `google-sheets-link.txt`
2. Click the link — Google will ask "Make a copy?"
3. Click yes — your private editable copy opens immediately
4. Clear the sample data rows and start adding your invoices

**Standalone offline app:**
1. Open `invoice-tracker.html` in any browser (Chrome, Edge, Firefox, Safari)
2. Sample data is pre-loaded — explore the dashboard and all tabs
3. Clear the sample data and add your first invoice
4. Everything saves automatically — no account, no sync, no setup

No plugins. No add-ons. No monthly fee.

---

### WHY THIS BEATS A PLAIN SPREADSHEET

❌ No manually formatting headers every billing cycle
❌ No staring at a row trying to remember if that invoice got paid
❌ No hunting through PayPal history to find which client paid what
❌ No "wait, what's my collection rate this year?"

✅ Due dates turn red automatically when an invoice is overdue
✅ Dashboard shows outstanding amount and collection rate at a glance
✅ Client leaderboard shows your most valuable clients without any manual work
✅ Payment History gives you a clean log ready for tax time

---

### WHO THIS IS FOR

- Freelancers who lose track of which invoices have been paid
- Consultants juggling multiple retainer clients with different billing cycles
- Designers, developers, writers, and marketers who want to know their real collection rate
- Anyone who has chased a client for payment and lost track of what they were owed
- Solo service providers who want billing clarity without paying $20/month for software

---

### WHAT'S INCLUDED

- `invoice-tracker.html` — the standalone offline app, opens in any browser
- `google-sheets-link.txt` — one-click copy link to your Google Sheets version
- `README.txt` — instructions for both versions
- Sample data pre-loaded in both versions so you can see it working before you clear it

---

### FAQ

**Do I need a Google account?**
Not if you use the standalone `.html` app — it runs entirely offline in your browser. If you prefer Google Sheets, a free Google account is all you need.

**Do I need to know how to code?**
No. The Sheets version is a copy link — click and go. The HTML app is a file you open like any document.

**Where does my data go in the offline app?**
It saves automatically to your browser's local storage. It never leaves your device. Export to CSV any time from the toolbar.

**How does the overdue alert work?**
If an invoice has a Due Date set and that date has passed and the Status is still Unpaid, the due date turns red automatically. Works the same way in both the Sheets and HTML versions.

**Does this replace FreshBooks, Wave, or QuickBooks?**
No — it's a visibility and tracking tool, not accounting software. It won't generate PDF invoices or send emails. This tells you exactly who owes you money and how much, without a monthly fee.

**Can I track partial payments?**
Log the partial payment in Payment History and add a note to the invoice. Mark the invoice Unpaid until fully paid.

**Does the dashboard update automatically?**
Yes in both versions — it reflects your current data at all times.

**Can I customize the invoice number format?**
Yes. Invoice # is a free-text field. Use INV-001, 2026-001, client initials — any format you like.

**Refund policy?**
Because this is a digital product, all sales are final. If you have any trouble getting set up, email support@intacon-studios.com and I will help.

---

*Send the invoice. Log the payment. Know exactly where your money is.*