Invoice Tracker Spreadsheet, Freelancer Invoice Template and Payment Tracker, Unpaid Invoices, Small Business Billing, Google Sheets Excel

Seller's description

An invoice tracker spreadsheet for freelancers and service businesses. Choose an invoice number and the printable invoice fills itself in: your details, the client and every line item. Then always know who has paid and who still owes you. Google Sheets & Excel.

WHAT'S INCLUDED
• Freelancer-Invoice-Payment-Tracker.xlsx, with made-up sample clients so you can see how it works
• Freelancer-Invoice-Payment-Tracker-BLANK.xlsx, empty and ready to use
• Freelancer-Invoice-Payment-Tracker-Quick-Start-Guide.pdf

WHO IT'S FOR
Freelancers, consultants, designers, writers, developers and small service businesses who bill clients by the hour, by the item or with a fixed project fee, and want tidy invoices plus an easy way to chase unpaid invoices.

HOW IT WORKS
1. Settings: your business name, contact details, default hourly rate, payment terms and payment instructions. These print on every invoice.
2. Clients: one row per client, with a contact person if you bill a company.
3. Invoices: add an invoice number, issue date and client. The due date fills in from your payment terms.
4. Line Items: log hours, a quantity (like pages or items) or a fixed fee, and pick the invoice it belongs to. Rate and amount fill in.
5. Invoice tab: pick the invoice number, then print or save it as PDF and send it to your client.
6. Payments: record full or partial payments. Balances and statuses update on their own.

FEATURES
• Printable invoice: pick the invoice # and it fills in automatically, with "Attn:" for your contact person
• Prints or saves to PDF on one portrait page (up to 20 lines per invoice)
• Hourly work, per-item prices and fixed project fees (rate override)
• Full or partial payments, with any payment method
• Automatic statuses: Draft, Open, Partly paid, Overdue, Paid
• Due dates from your payment terms, with an override for clients on different terms (like Net 30)
• Built-in check flags duplicate invoice numbers, line items for the wrong client, and invoices over 20 lines
• Summary: outstanding, overdue, unpaid invoices by age (1–30, 31–60, 61+ days late), balance by client, and monthly invoiced vs. received
• Room for 100 clients, 500 invoices, 1,000 line items and 1,000 payments

WANT THE BIGGER PICTURE?
The Client & Income Dashboard https://www.etsy.com/listing/4600680015/client-tracker-spreadsheet-client-and shows income by client, prepaid packages and a quarterly tax set-aside.
At tax time, the Self-Employed Tax Organizer https://www.etsy.com/listing/4600712100/self-employed-tax-spreadsheet-2026-2027 turns your income into quarterly set-asides and a one-page preparer summary.

SAVE WITH THE BUNDLE: Get the Client & Income Dashboard, Freelancer Invoice & Payment Tracker and Self-Employed Tax Organizer together in the Freelancer Money Bundle https://www.etsy.com/listing/4601112812/freelancer-bundle-client-income for $32 (save $9 vs. $41 bought separately).

TUTOR OR MUSIC TEACHER?
This is the general edition for freelancers and service businesses. Tutors: see the Tutoring Invoice & Payment Tracker https://www.etsy.com/listing/4599088805/tutoring-invoice-template-and-payment. Music teachers: see the Music Lesson Invoice & Tuition Tracker https://www.etsy.com/listing/4599592633/music-lesson-invoice-and-tuition-tracker.

DELIVERY (INSTANT DOWNLOAD)
• Instant digital download. Nothing physical is shipped.
• The spreadsheets come in one .zip file. Unzip it first (double-click on Mac, right-click > Extract All on Windows). The PDF guide is also included on its own.
• After purchase, download the files from your Etsy Purchases page (or the link in your confirmation email).
• Price is for one business. Please don't share or resell the files.

WORKS IN GOOGLE SHEETS & EXCEL
• Google Sheets (any Google account): upload the .xlsx to Google Drive, then File > Save as Google Sheets.
• Microsoft Excel (desktop, Excel 2016 or newer, including Microsoft 365): double-click the file and click Enable Editing.
• Built with standard formulas only: no macros, no scripts, no add-ons.
• Works best on a computer. Apple Numbers and phone apps are not supported.

PLEASE NOTE
Invoices are created in the file. You print or save them as PDF and send them to clients yourself. This file doesn't email anyone or take payments. Overdue status uses today's date, so it updates each day. Not tax, legal or financial advice.

REFUNDS & HELP
Because this is a digital download, returns and exchanges aren't accepted. But if a file won't open or something doesn't work as described, message us through Etsy and we'll help or send a corrected file.

More ChalkAndLedger spreadsheets are in the shop. They work on their own and are designed to look and feel the same.

Created by ChalkAndLedger using AI-assisted tools. Every template is tested in Google Sheets and Excel.