Invoice & Expense Tracker
Google Sheets invoice generator with expense categorization, tax-deductible item tracking, and quarterly tax prep.
📄 Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample📁 File Structure 20 files
📖 Documentation Preview README excerpt
Invoice & Expense Tracker
By Freelancer Toolkit Pro | $29
A complete Google Sheets invoicing and expense tracking system for freelancers. Generate professional invoices, track every expense with tax-deductible flags, prepare quarterly estimated taxes, and never scramble at tax time again.
Disclaimer: This product is for informational and organizational purposes only. It is not tax or financial advice. Consult a licensed accountant for your jurisdiction.
What's Inside
Spreadsheets (CSV → Google Sheets / Excel Import)
| File | Purpose | Sample Data |
|---|---|---|
sheets/invoice-register.csv | Every invoice: client, amount, status, aging, payment method | 20 invoices ($1,500 - $4,800) |
sheets/invoice-template.csv | Reusable invoice template with all required fields | Field-by-field template with instructions |
sheets/expense-tracker.csv | All expenses with deductibility flags and receipt tracking | 41 expenses across 11 categories |
sheets/tax-deductible-summary.csv | Quarterly deduction totals by category | Q1-Q2 summary with YTD totals |
sheets/quarterly-tax-prep.csv | Full quarterly tax calculation: SE tax + federal + state | 4-quarter worksheet with worked math |
Templates
| File | Purpose |
|---|---|
templates/invoice-markdown-template.md | Professional invoice template — copy and customize |
templates/payment-reminder-emails.md | 3 escalating payment reminder emails (friendly → firm → final) |
Formulas Reference
| File | Purpose |
|---|---|
formulas/FORMULAS.md | 15 Google Sheets formulas: invoice aging, deductible totals, tax estimates |
Documentation
| File | Purpose |
|---|---|
docs/SETUP.md | Step-by-step Google Sheets import and configuration |
docs/tax-categories-reference.md | Complete deduction reference: what's deductible, percentages, documentation |
docs/CUSTOMIZATION.md | Adapt for your currency, tax jurisdiction, and business type |
Features
- Invoice Register — Track every invoice with client, amount, payment terms, status, and aging
- Invoice Template — Professional invoice format with all fields a client expects
- Expense Categorization — 11 expense categories with tax-deductible flags and percentage tracking
- Receipt Tracking — Link receipts to expenses for audit-ready documentation
- Tax-Deductible Summary — Auto-categorized deductions with quarterly and YTD totals
- Quarterly Tax Prep — Self-employment tax, federal income tax, and state tax calculations
- Invoice Aging — Automatic tracking of outstanding invoices by days overdue
- Payment Reminder Templates — 3 professionally written escalating reminder emails
- 15 Working Formulas — Invoice numbering, aging buckets, deductible calculations, tax estimates
Quick Start
... continues with setup instructions, usage examples, and more.
📄 Content Sample templates/invoice-markdown-template.md
Invoice Markdown Template
Copy this template for each invoice. Fill in the bracketed placeholders. Export as PDF or send as-is for less formal clients.
INVOICE
[YOUR BUSINESS NAME]
[Your Address Line 1]
[City, State ZIP]
[your-email@example.com] | [Your Phone]
| Invoice Number: | INV-YYYY-NNN |
| Invoice Date: | [Date] |
| Due Date: | [Date + Terms] |
| Payment Terms: | Net 15 / Net 30 / Due on Receipt |
Bill To:
[Client Business Name]
[Client Address]
[City, State ZIP]
Attn: [Contact Name]
Services Rendered
| Description | Qty | Rate | Amount |
|---|---|---|---|
| [Service line item 1 — be specific about deliverables] | 1 | $X,XXX.XX | $X,XXX.XX |
| [Service line item 2] | 1 | $X,XXX.XX | $X,XXX.XX |
| [Service line item 3] | 1 | $X,XXX.XX | $X,XXX.XX |
| Subtotal: | $X,XXX.XX |
| Discount ([X]%): | -$XXX.XX |
| Tax ([X]%): | $XXX.XX |
... and much more in the full download.