Tight Ship
All tools

Invoices and Payments

Invoice and Payment Tracker

Invoice tracker in Excel for HVAC, plumbing, electrical and other service companies.

Type in each invoice and payment. It works out every balance and how late it is, and lists who to call today.

$12.00

Buy now

Pay once. No subscription.

If a file won't open, won't work on your computer or Microsoft plan, or isn't what the page described, we fix it or refund you, your choice. Tell us within 14 days of your purchase.

Questions? Email support@tightshiphq.com

  • Made for Excel, not Google Sheets.
  • It tracks invoices; it doesn't make them.

How you use it

  1. $19,955.00OWED

    Sample data

    What's owed, by age

    Current$8,375
    1 to 30$4,280
    31 to 60$3,830
    61 to 90$2,830
    Over 90$640

    Step 1. Open the sample-data copy first.

    It shows how it all fits together.

    A sample-data copy filled with a made-up company's books (25 customers, 60 invoices, 68 payments), so you can click around before adding your own.

    See the real screen: Dashboard

  2. Settings

    Sample data

    COMPANY · prints on every statement

    Company name
    Brightline Field Services
    Address line 1
    1820 Kettle Run Rd, Unit 4
    Address line 2
    Columbus, OH 43219
    Phone
    (614) 555-0100
    Payment note
    Please make checks payable to Brightline Field Services.

    TERMS BY CUSTOMER TYPE

    Residential
    0 days
    Commercial
    30 days

    Step 2. Save the blank tracker where you keep your work files.

    On its Settings tab, type your company details, check the terms, and add your payment note.

    Settings tab in Excel: the company block that prints on statements, the As-of date, and payment terms by customer type (residential due on receipt, commercial net 30). No late fees or interest are figured.

    See the real screen: Settings

  3. Customers

    Sample data

    CustomerTypeOpen invoicesBalance
    Marcus BellResidential1$750.00
    Greg HollisResidential1$640.00
    Andre LewisResidential1$1,140.00
    Lakeside DentalCommercial1$715.00
    Hilltop ClinicCommercial3$5,020.00
    Maple Row ApartmentsCommercial1$1,890.00

    Step 3. Add your customers on the Customers tab.

    Customers tab in Excel: each customer's type and terms, then open invoices, balance, the balance split into Current, 1 to 30, 31 to 60, 61 to 90 and Over 90 days, and the last payment. Made-up sample data.

    See the real screen: Customers

  4. Invoices

    Sample data

    Invoice #CustomerAmountStatus
    INV-2043Victor Alvarez$3,650.00Paid
    INV-2044Maple Row Apartments$1,890.00Past due
    INV-2045Rachel Kim$365.00Paid
    INV-2046Lakeside Dental$715.00Past due
    INV-2047Greg Hollis$240.00Paid
    INV-2048Northgate Self Storage$2,150.00Not due yet

    Step 4. Each invoice you send: one row on Invoices.

    Invoices tab in Excel: each invoice's number, date, customer, job and amount, then the due date, paid, balance, status, days past due and age that fill in from payments and terms. Made-up sample data.

    See the real screen: Invoices

  5. Payments

    Sample data

    DateInvoice #AmountMethodReference
    9/11/26INV-2016$937.50Bank transferSAMPLE-T0802
    9/14/26INV-2004$2,150.00CheckSAMPLE-7781
    9/14/26INV-2010$410.00CheckSAMPLE-7781
    9/14/26INV-2026$690.00CheckSAMPLE-7781
    9/14/26INV-2039$310.00CardSAMPLE-R1019

    One check for INV-2004, 2010 and 2026

    Step 5. Each payment: one row on Payments.

    Payments tab in Excel: one row per payment with date, invoice number, amount, method, a SAMPLE reference and notes, including one check split across three invoices; the customer and a check column fill in.

    See the real screen: Payments

  6. FOLLOW UP TODAY · most days past due first

    Sample data

    INV-2007Greg Hollis$640.00105 days past dueCall
    INV-2009Hilltop Clinic$2,480.0072 days past dueSend statement
    INV-2030Sam Ortiz$350.0061 days past dueCall
    INV-2037Marcus Bell$750.0047 days past dueEmail
    INV-2027Hilltop Clinic$1,900.0037 days past dueSend statement
    INV-2050Andre Lewis$1,140.0021 days past dueMail a copy

    Step 6. Every morning, open the Dashboard and work the follow-up list.

    To send a customer their open invoices, use the Statement.

    Open the Dashboard each morning: its follow-up list shows the invoices you've set to follow up on, most days past due first, and the biggest past-due balances by customer.

    See the real screen: Follow-up list

Drawn from the sample data in the file. Each step links to the real screen. Made-up data only, in every file and every image.

What's included

  • Invoice and payment workbook, blank and ready to use, with seven tabs: Start Here, Dashboard, Invoices, Payments, Customers, Statement, and Settings
  • A sample-data copy filled with a made-up company's books (25 customers, 60 invoices, 68 payments), so you can click around before adding your own
  • A one-page quick-start PDF
  • A start-here text file

Before you buy

  • Needs Excel for Microsoft 365 or Excel 2021 or newer. Checked in desktop Excel for Microsoft 365 on Windows.
  • Not tested yet in Excel for the web or Excel for Mac.
  • Not for Google Sheets, Apple Numbers, or Excel 2019 and older.
  • It tracks invoices; it doesn't make them. You keep billing the way you do now and type each invoice in.
  • Nothing is sent: no invoices, statements or reminders are emailed or texted. The workbook shows what's due when you open it.
  • No late fees or interest are figured. If you charge either, check your state's rules first.
  • Not bookkeeping or accounting software: no taxes, no bank or app connection.
  • Delivered as one .zip file. Unzip it first, then open the Quick Start PDF.
  • Digital download. Nothing is shipped.

A person makes every decision

This is a workflow and organizing tool for what your customers owe you. It figures no late fees or interest, sends nothing, and decides nothing: you decide who to call and what to do. Not legal advice. Check your state and local rules.

Questions

Does it send invoices or reminders?

No. Nothing is emailed or texted. Open the Dashboard each morning: its follow-up list shows the invoices you've set to follow up on, most days past due first, and the biggest past-due balances by customer.

Does it add late fees or interest?

No. Nothing in the workbook figures a fee or interest. If you charge either, check your state's rules first.

Can a customer pay an invoice in parts?

Yes. Each payment is its own row on the Payments tab, tied to the invoice number, and the invoice's Paid adds them up. One check that pays three invoices is three rows with the same check number.

Can I print a statement for a customer?

Yes. On the Statement tab, pick the customer: their open invoices fill one page, oldest first, with the total due, what's owed by age, and payments from the last 30 days. Hold Ctrl and press P, or save it as a PDF. It shows facts only, plus your own payment note.

Does it work on a Mac or in Excel for the web?

Not tested yet. We've checked it in desktop Excel for Microsoft 365 on Windows. It uses no macros and only functions Excel 2021 has, but we haven't opened it in Excel for Mac or Excel for the web.

Invoice and Payment Tracker

$12.00

Buy now

Pay once. No subscription.