← Invoice payment terms calculator

This calculator vs. a spreadsheet

A freelancer who sets payment terms more than once usually ends up with a spreadsheet: an invoice date, a terms column, and a formula that adds the two. That formula gives you the invoice's due date. It does not, on its own, tell you when the cash actually lands — and for a client that only runs payments on certain days, those are often different dates. This page names no specific product; it compares against the generic method of tracking terms in a spreadsheet or by hand.

A spreadsheet can add an invoice date to a terms count in one formula, and many freelancers already have one. What it does not do on its own is model which weekday, or which day of the month, a specific client's accounts-payable system actually pays on — so a due date that falls between two payment runs silently waits for the next one, and nothing in a plain date-add formula flags that drift or prices what it costs.

This calculator takes the invoice date, the terms, and the client's stated pay-run schedule (weekdays only, twice a month, once a month on a set day, or once a week), and works out the date cash actually lands, how many days that drifts past the stated due date, what that drift costs at your own carrying-cost rate, and whether dating the invoice a few days earlier would catch an earlier run and get you paid sooner for free. It also carries the early-pay and factoring break-even math through the same pay-run projection, so a 2/10 Net 30 offer or a factoring fee is compared against when the money would actually arrive, not just the due date on the invoice.

QuestionWhere to answer it
When is this invoice due, by its stated terms?Either one — invoice date plus terms is the same formula both use.
When does the cash actually land, given this client's pay-run schedule?This calculator's pay-run projection — a plain date-add formula has no way to know a client only pays on the 1st and 15th.
What does that drift cost at my own carrying-cost rate?This calculator, priced automatically once you set a rate.
Would dating the invoice a few days earlier catch an earlier payment run?This calculator flags it when the earlier run buys more days than it costs; a spreadsheet only tells you this if you build and maintain that comparison yourself.
Does a 2/10 Net 30 discount or a factoring fee still beat waiting for the actual landing date?This calculator's early-pay and factoring comparisons, run against the same pay-run projection.
I already have a working terms sheet and don't want to change tools.Keep it — this calculator is a free second check, not a replacement for a system you maintain.

What this page is not

This calculator is not a bookkeeping system and does not track multiple clients or invoices over time; a spreadsheet or an invoicing platform still does that job better. What it replaces is the one-off arithmetic of projecting a specific client's actual pay date from their stated schedule and pricing the drift — the part of a terms sheet most likely to be approximated as "due date equals paid date" because modeling weekday-only, semimonthly, or monthly pay runs by hand, correctly, for every invoice, is tedious enough that most spreadsheets skip it.

Common questions

Can a spreadsheet work out when an invoice is due?

Yes — =invoice_date+terms_days is one formula and most freelancers already have it somewhere. What that formula gives you is the due date the invoice states, not the date the money actually arrives. Accounts-payable departments run payments in batches: weekdays only, twice a month, once a month on a set day, or once a week — and a due date that lands between two runs waits for the next one. A plain date-add formula has no way to know which schedule a given client uses, so it is silently wrong on any client that does not pay same-day.

Where does a hand-built invoice-terms sheet usually go wrong?

Two places. First, treating the due date as the pay date — a Net 30 invoice due on a Saturday, or due the 16th at a client who only runs payments on the 1st and 15th, does not get paid on the due date; it waits for the next run, and that drift is real carrying cost at whatever rate the freelancer's own cash is worth. Second, re-deriving the early-pay or factoring break-even by hand every time terms or a client's discount offer changes, which is exactly the kind of repeated formula work a copied cell silently gets wrong on one row.

What does a spreadsheet not check for you?

Whether the due date actually falls on a day the client's accounts-payable system pays, and by how many days it drifts if not; whether a 2/10 Net 30 discount or a factoring fee still beats waiting once that drift and your own carrying-cost rate are priced in; and whether dating the invoice a few days earlier would catch an earlier payment run and get you paid sooner for no cost. None of those are hard formulas individually, but stacking all of them correctly, for every client's schedule, on every invoice, is where a hand-built sheet drifts.

Does either one know whether my client will actually pay on time?

No. Both this calculator and a spreadsheet model the schedule you tell them about — the stated payment terms and the client's stated pay-run cadence. Neither predicts whether a specific client pays on time, disputes the invoice, or pays late anyway.

Is anything I enter uploaded anywhere?

No. The calculator this page links to runs entirely in your browser; nothing you type is uploaded.

Open the invoice payment terms calculator to project your own invoice's actual landing date.