Two suppliers can both say “30 days” and mean two different due dates.
Payment terms set when a supplier invoice is due. Net 30 means 30 days from the invoice date. EOM terms count from the end of the month. Terms like 30 days end of month add 30 days after the month the invoice is dated. Record each supplier's terms in the vendor master and calculate due dates with a formula, so every invoice is paid on time, not early or late.
| Term | Due date |
|---|---|
| Due on receipt | Immediately |
| Net 7, 14, 30, 60, 90 | That many days after the invoice date |
| EOM (end of month) | End of the month the invoice is dated |
| 30 days EOM | 30 days after the end of the invoice month |
| Net 10th prox. | The 10th of the following month |
| 2/10 net 30 | 30 days, with a 2% discount if paid within 10 |
Contracts sometimes count from the date the invoice is received, not the date on it. Your terms should say which.
With the invoice date in A2:
Net 30: =A2+30
End of month: =EOMONTH(A2,0)
30 days end of month: =EOMONTH(A2,0)+30
10th of the following month: =EOMONTH(A2,0)+10
End of the following month: =EOMONTH(A2,1)
Many teams interpret "30 days end of month" as the end of the following month instead. Agree the interpretation with the supplier and use the matching formula.
Store each supplier's terms in the vendor master, not on the invoice alone. When an invoice shows different terms from the master, flag it: either the contract changed, or someone is trying to shorten your payment period. Changes to terms in the vendor master should be approved like any other master data change. See vendor master file clean-up.
With the next payment run date in a cell named NextRun, include an invoice in this run if:
=DueDate<NextRun
A supplier base with dozens of different terms is hard to manage and to forecast. Agree a standard term for new suppliers, review exceptions when contracts renew, and report the spread of terms each quarter. Fewer variations make the cash forecast more reliable and the payment run simpler.
For the cash side, see days payable outstanding; for discount terms, early payment discounts.
"Net 30" is common in the US; UK invoices often say "30 days" or "30 days end of month". In the UK, statutory late payment interest can apply to business debts paid late. Check the current rules where you operate.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Payment is due 30 days after the invoice date, unless the contract says the days count from receipt of the invoice.
Usually 30 days after the end of the month the invoice is dated. Some businesses read it as the end of the following month, so agree the meaning with the supplier.
They are agreed in the contract or purchase terms. Finance should set a standard and approve exceptions, and changes in the vendor master should be authorised.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.