22 free Excel templates
Invoice & billing trackers
Know who owes you and since when. These trackers total what you have billed, split it into collected and outstanding, and flag invoices past their due date until you mark them paid. Use them alongside your invoicing tool, or on their own if you bill a handful of clients a month.
Before you start
- Only a Paid-type status stops the overdue flag: a sent invoice is still money owed.
- Sort by due date once a week and follow up on the highlighted rows first.
- These track billing; keep using accounting software or an accountant for tax filing.
Invoice & billing trackers
Property Appraiser
Appraisal Fee Tracker
A free appraisal fee spreadsheet: track fees, AMC splits, and invoiced vs. paid per order with monthly totals for appraisers, in Google Sheets and Excel.
Calculates your net, month · Tabs: Orders, Summary
Law Firm
Billable Hours Log
A free billable hours spreadsheet: log time by matter with auto fee totals and billed vs. unbilled views for attorneys, in Google Sheets and Excel.
Calculates amount · Tabs: Time entries, Summary
Commissary Kitchen
Commissary Member Billing
A free billing sheet for commissary kitchens: bill members by plan, hours, and overage with outstanding invoices in Sheets or Excel.
Calculates overage hours, invoice total · Tabs: Members, Billing summary
Court Reporting Agency
Court Reporting Invoice Tracker
A free invoice tracker for court reporting agencies: bill per page and appearance, split reporter payouts, and track paid status in Sheets or Excel.
Calculates invoice amount, reporter payout, agency share · Tabs: Invoices, Summary
Interior Design
Design Client Invoice Tracker
A free design invoice spreadsheet: track client invoices, design fees, and markup with overdue alerts for interior designers, in Google Sheets and Excel.
Calculates invoice total · Tabs: Invoices, Summary
Architecture Firm
Design Fee Tracker
A free design fee spreadsheet: split contract fee by phase and track billed vs. remaining with add services for architecture firms, in Sheets and Excel.
Calculates earned, remaining fee, ready to bill · Tabs: Fees by phase, Fee summary
Food Hall
Food Hall Vendor Rent Roll
A free rent roll for food halls: track stall rent, percent-of-sales, and outstanding balances by vendor in Google Sheets or Excel.
Calculates percent rent, total due, balance · Tabs: Rent roll, Totals
Freelancing
Freelance Invoice Tracker
A free invoice tracker for freelancers: see billed, paid, and overdue at a glance, with an auto tax set-aside, in Google Sheets or Excel.
Calculates tax set-aside · Tabs: Invoices, Settings, Summary
HOA Management
HOA Dues Tracker
A free dues tracker for HOA management: track assessments by unit with paid, balance, and delinquency status in Google Sheets or Excel.
Calculates late fee, balance, standing · Tabs: Dues, Settings & totals
Home Care Agency
Home Care Billing Tracker
A free home care billing spreadsheet: track hours by client and payer with invoiced vs. paid and private-pay splits for agencies, in Google Sheets and Excel.
Calculates amount · Tabs: Billable hours, Billing summary
Music Lessons
Music Lesson Invoice Tracker
A free music lesson invoice spreadsheet: turn lessons into invoices by rate and track invoiced vs. paid with overdue alerts, in Google Sheets and Excel.
Calculates amount · Tabs: Invoices, Totals
Freelance Paralegal Service
Paralegal Billable Hours Tracker
A free billable hours tracker for freelance paralegals: log time by matter with rate and billable amount and invoice-ready totals in Sheets or Excel.
Calculates amount · Tabs: Time, Summary
Patent Search Service
Patent Search Client Invoice
A free invoice template for patent search services: bill clients by project with hours, flat fees, and outstanding totals in Sheets or Excel.
Calculates line total · Tabs: Invoice lines, Summary
Permit Expediter Service
Permit Expediter Client Invoice
A free invoice template for permit expediters: bill clients by project with service fees and pass-through jurisdiction fees in Sheets or Excel.
Calculates line total · Tabs: Invoice lines, Summary
Pool Service
Pool Service Billing
A free pool service billing spreadsheet: track recurring fees charged vs. paid, balances, and extra repairs per customer, in Google Sheets and Excel.
Calculates total due, balance · Tabs: Billing, Totals
Preschool
Preschool Tuition Billing
A free tuition billing sheet for preschools: bill families by plan with paid, balance, and subsidy notes in Google Sheets or Excel.
Calculates family owes, balance · Tabs: Families, Totals
Property Management
Rent Roll
A free rent roll spreadsheet: track rent collected, outstanding, occupancy, and lease ends across units with income totals, in Sheets and Excel.
Calculates balance, days to lease end · Tabs: Rent roll, Portfolio
Land Surveying Firm
Surveying Project Invoice
A free invoice template for surveying firms: bill clients by job and phase with percent-complete and outstanding totals in Sheets or Excel.
Calculates amount this invoice · Tabs: Phases, Summary
Tenant Screening Service
Tenant Screening Billing Log
A free billing log for tenant screening services: track invoices by landlord with reports run and outstanding totals in Sheets or Excel.
Calculates amount · Tabs: Invoices, Summary
Towing & Recovery
Towing Invoice Tracker
A free towing invoice spreadsheet: track invoices, payer, and motor-club status with aging on unpaid balances, in Google Sheets and Excel.
Calculates age (days) · Tabs: Invoices, Receivables
Tutoring
Tutoring Invoice Tracker
A free tutoring invoice spreadsheet: bill from sessions and rate, track paid and overdue, and total income by month, in Google Sheets and Excel.
Calculates amount, month · Tabs: Invoices, Summary
Accounting Firm
WIP & Billing Tracker
A free WIP and billing spreadsheet: track unbilled work in progress, hours-to-value, and realization per client for accounting firms, in Sheets and Excel.
Calculates wip at standard, unbilled wip, realization · Tabs: Engagements, Firm view