Net 30 Payment Terms Tracker Excel - Free Template

1. Open the Instructions tab and review the payment-term lookup table. The supplied choices are Net 15, Net 30, Net 45, and Due on Receipt.
2. Go to Payment Tracker and enter an Invoice ID, customer name, contact, city, state, invoice date, payment terms, and invoice amount in the pale-yellow input cells.
3. Select the applicable term from the Payment Terms dropdown. The Terms Days and Due Date fields are calculated from the lookup table and invoice date.
4. When money arrives, enter the Payment Date and update Amount Paid. For a partial payment, enter the amount received rather than replacing the original invoice amount.
5. Add collection activity in Collection Notes, including the date of a reminder, a promised payment date, or a dispute explanation.
6. Review Payment Status, Balance Due, Days Outstanding, Aging Bucket, and Days Overdue. These fields use formulas driven partly by TODAY(), so results change as the workbook is opened on different dates.
7. Use the Dashboard for management review. Compare status counts and balances with the aging summary before deciding which accounts require collection attention.

A Net 30 tracker is most useful when your business sends invoices today but expects cash roughly one month later. A bookkeeper at an LLC may update it after the weekly billing run, while an office manager at a contractor may use it every Friday to decide which customers need a reminder. A service company with 40 open invoices can lose sight of a $6,500 balance even when every invoice is stored in email.

The Payment Tracker tab is built for that working moment. Image 1 shows columns for Invoice ID, Customer Name, Contact, City, State, Invoice Date, Payment Terms, Terms Days, Invoice Amount, Due Date, Payment Date, Amount Paid, Balance Due, Payment Status, Days Outstanding, Aging Bucket, Days Overdue, and Collection Notes. You enter the transaction facts; the calculated columns turn them into collection information.

During Billing And Weekly Collections

For a marketing agency invoicing $8,000 on 04/01/2026 under Net 30, the calculated due date is 05/01/2026. If the client pays $3,000, the tracker shows a $5,000 balance and identifies the invoice as Partially Paid until the remaining amount is recorded.

A sole proprietor can use the same process after each invoice batch, then review the Dashboard before making payroll or transferring money for estimated taxes. The Dashboard shows total invoiced, total collected, total outstanding, collection rate, overdue balance, open invoice count, and average invoice amount. It also separates payment status from aging, which answers two different questions: what happened to the invoice and how long has the unpaid amount been outstanding?

At Month-End Close

At month-end, a small business can compare the spreadsheet's outstanding balance with its accounts receivable ledger. The template has 100 prepared rows, from row 5 through row 104, so it suits a modest invoice list without requiring a separate database.

Net 30 is a contract payment term, not a federal tax rule. It ordinarily means the customer owes payment 30 calendar days after the invoice date, although your written agreement should define whether the clock starts on the invoice date, delivery date, or acceptance date. In this workbook, the Instructions tab defines Net 30 as 30 calendar days after the invoice date.

The supplied lookup table also includes Net 15, Net 45, and Due on Receipt. The Payment Tracker uses VLOOKUP to retrieve the day count and adds it to Invoice Date. For example, an invoice dated 03/27/2026 with Net 15 has a calculated due date of 04/11/2026; a Due on Receipt invoice adds zero days.

Revenue, Sales Tax, And Records

Invoice terms do not determine when every business reports revenue. A cash-basis business generally records income when payment is received, while an accrual-basis business generally records revenue when earned under its accounting method. A product seller must also handle sales tax, which is state-level: there is no national VAT, and nexus obligations differ by state.

Keep invoices, payment evidence, and collection notes with your accounting records. The IRS generally expects supporting records to be retained for at least 3 years, and some situations require up to 7 years. This tracker is an operational receivables aid, not a replacement for your general ledger or tax workpapers.

What The Status Means

The formulas classify a zero balance as Paid. A positive balance past the due date becomes Overdue; a positive balance before the due date is Open unless a partial payment has been entered. Aging uses Current, 1-30 Days, 31-60 Days, and 61+ Days, while TODAY() means the displayed result changes with the workbook's opening date.

The most expensive failure is entering an invoice but never updating the payment fields. Suppose a $12,750 invoice receives $4,000 by ACH. If Amount Paid remains blank, the workbook reports the full $12,750 as outstanding and your collection review may chase a customer who has already paid part of the bill.

Incorrect Terms Create Incorrect Dates

A one-word mismatch can also distort the schedule. If a user types Net30 instead of selecting Net 30 from the dropdown, the lookup may not return 30 days. The Due Date then remains blank, and the status and overdue calculations cannot work correctly. Use the dropdown rather than manually typing terms.

Another common error is using a payment date as the invoice date. A $5,250 invoice issued 01/08/2026 under Net 30 is due 02/07/2026. If you enter 01/29/2026 as the invoice date because that is when payment arrived, the calculated due date shifts by 21 days and weakens the collection history.

Partial Payments And Stale Follow-Up

Collection notes are not decorative. Without a note such as “second collection email sent,” the next person may repeat the same request or miss a promised payment. For a company with 25 overdue invoices averaging $2,400, poor notes can tie up $60,000 in receivables and consume hours reconstructing email history.

Do not treat a Dashboard collection rate as proof that every customer is current. A business could collect $90,000 of $100,000 invoiced, showing a 90% rate, while the remaining $10,000 is concentrated in one strategically important overdue account. Review the overdue balance and aging summary, not only the percentage.

Formula Results Need A Date Context

Status and aging rely on TODAY(). A workbook opened on 09/11/2026 will not show the same days overdue as one opened on 08/31/2026. Save a dated export or retain a separate accounting record when you need a historical snapshot.

The spreadsheet works best when you attach it to a fixed event instead of opening it only when cash is short. Update new invoices immediately after the billing run, then review open and overdue balances every Friday. A 20-minute routine can cover 15 invoices if you filter your attention by status and balance rather than rereading every note.

Use The Tabs In A Consistent Order

• Enter or correct source information on Payment Tracker.
• Use the Dashboard to identify the largest outstanding and overdue totals.
• Read Instructions when changing the supplied payment-term lookup list.

Keep the term text consistent with the lookup values. If your company adds Net 60, add the label and 60 to the Instructions table, then use that exact label in the Payment Terms dropdown setup. Test one invoice before entering a full billing batch.

Make Follow-Up Measurable

Use Collection Notes to record a dated action, not a vague phrase. “Emailed 09/11/2026; customer promised ACH 09/15/2026” is more useful than “contacted.” For example, if the Dashboard shows $18,000 in 31-60 Days and $7,500 in 61+ Days, contact the older bucket first unless a customer dispute changes the priority.

Protect the calculated columns from accidental overwriting and keep a backup before changing the lookup table. The tracker has 100 prepared operational rows; when your receivables exceed that regularly, or several staff members need simultaneous access, move to an accounting system such as QuickBooks or a dedicated accounts-receivable platform. A spreadsheet is strongest for a controlled list, not as a substitute for transaction-level audit trails.