← Back to all products

Invoice & Expense Tracker

$29

Google Sheets invoice generator with expense categorization, tax-deductible item tracking, and quarterly tax prep.

22 files
MarkdownJSONGoogle SheetsExcel

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 22 files

invoice-expense-tracker/ ├── LICENSE ├── README.md ├── docs/ │ ├── CUSTOMIZATION.md │ ├── SETUP.md │ └── tax-categories-reference.md ├── formulas/ │ └── FORMULAS.md ├── free-sample.zip ├── guide/ │ ├── 01_what-s-inside.md │ ├── 02_quick-start.md │ └── 03_support.md ├── index.html ├── interactive.html ├── invoice-expense-tracker.xlsx ├── sample.xlsx ├── sheets/ │ ├── expense-tracker.csv │ ├── invoice-register.csv │ ├── invoice-template.csv │ ├── quarterly-tax-prep.csv │ └── tax-deductible-summary.csv └── templates/ ├── invoice-markdown-template.md └── payment-reminder-emails.md

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)

FilePurposeSample Data
sheets/invoice-register.csvEvery invoice: client, amount, status, aging, payment method20 invoices ($1,500 - $4,800)
sheets/invoice-template.csvReusable invoice template with all required fieldsField-by-field template with instructions
sheets/expense-tracker.csvAll expenses with deductibility flags and receipt tracking41 expenses across 11 categories
sheets/tax-deductible-summary.csvQuarterly deduction totals by categoryQ1-Q2 summary with YTD totals
sheets/quarterly-tax-prep.csvFull quarterly tax calculation: SE tax + federal + state4-quarter worksheet with worked math

Templates

FilePurpose
templates/invoice-markdown-template.mdProfessional invoice template — copy and customize
templates/payment-reminder-emails.md3 escalating payment reminder emails (friendly → firm → final)

Formulas Reference

FilePurpose
formulas/FORMULAS.md15 Google Sheets formulas: invoice aging, deductible totals, tax estimates

Documentation

FilePurpose
docs/SETUP.mdStep-by-step Google Sheets import and configuration
docs/tax-categories-reference.mdComplete deduction reference: what's deductible, percentages, documentation
docs/CUSTOMIZATION.mdAdapt 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]

[[email protected]] | [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

DescriptionQtyRateAmount
[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.