Invoice Due Date Calculator & Open Balance Planner
Turn invoice terms into a payment or collection schedule. Count from issue, receipt, or the later of receipt and acceptance. Enter calendar or business days, choose whether to move a closed due date, and compare balances against the as-of date.
Plan invoice due dates and open balances
Apply the terms you enter, check which dates move when offices close, and see when balances need attention.
As-of date and calendar
Use the terms on your invoice or agreement. Saturday and Sunday are closed for business-day counting and rollover. Add any other known closures below.
Use invoice and payment balances known at this date.
Enter up to 60 dates in YYYY-MM-DD format, separated by lines or commas.
$4,600.00 open as of 2026-11-18. $1,500.00 overdue.
Invoice balance summary
Earliest open due date on or after as-of: · $850.00.
Open balance by due-date range
Bars compare unpaid USD amounts. The displayed days are calendar days from your as-of date to the adjusted due dates.
61+ days overdue$0.00 · 0 invoices
31 to 60 days overdue$0.00 · 0 invoices
1 to 30 days overdue$1,500.00 · 1 invoice
Due today$850.00 · 1 invoice
1 to 7 days ahead$1,000.00 · 1 invoice
8 to 30 days ahead$1,250.00 · 1 invoice
31+ days ahead$0.00 · 0 invoices
Invoice register
Counting starts on the day after your term anchor. Zero days starts on the anchor itself, with the optional closed-date adjustment applied afterward.
Invoice due-date ledger
Show due dates and balances
| Reference | Anchor date | Unadjusted due | Due date | Roll days | Days from as-of | Invoice amount | Paid | Open balance | Status |
|---|---|---|---|---|---|---|---|---|---|
| A-104 | 2026-10-05 | 2026-11-04 | 2026-11-04 | 0 | -14 | $2,400.00 | $900.00 | $1,500.00 | Overdue |
| B-207 | 2026-11-12 | 2026-11-18 | 2026-11-18 | 0 | 0 | $850.00 | $0.00 | $850.00 | Due today |
| D-416 | 2026-11-18 | 2026-11-23 | 2026-11-23 | 0 | 5 | $1,200.00 | $200.00 | $1,000.00 | Upcoming |
| C-310 | 2026-11-17 | 2026-11-26 | 2026-11-27 | 1 | 9 | $1,250.00 | $0.00 | $1,250.00 | Upcoming |
Show selectable CSV
How to use this calculator
- Set the date at which you want to measure open balances. List any weekday closures that apply to your invoice terms.
- Enter one row per invoice, including its original amount and the amount already paid on the as-of date.
- Select the term anchor and enter its date or dates. Enter the number of days, the count convention, and whether to move a closed due date.
- Check which balances are overdue or due in the next seven days. Open the ledger to compare raw and adjusted dates, or download the CSV.
The Formula
The mathematical logic powering this calculation is:
The term anchor is an entered issue or receipt date, or the later of the entered receipt and acceptance dates. Count the requested number of days after that anchor. Calendar days include closures and weekends. Business days skip Saturdays, Sundays and your entered closures. For a zero-day term the initial due date is the anchor itself. If rollover is selected, move any initial due date that is closed to the next business day.
Open balance = invoice amount minus the amount already paid as of the same date. Age is adjusted due date minus as-of date in calendar days. A past due date contributes to overdue balances only when the open amount is positive. The seven-day summary includes due today and due in the next seven calendar days.
Use the terms your invoice or agreement specifies. The calendar has no automatic holiday list. The U.S. Treasury and Federal Acquisition Regulation illustrate how later-of dates and closed-day handling may be used in a specific setting. This worksheet applies the dates and conventions you enter. It does not select a legal deadline, calculate constructive acceptance, late interest, settlement discounts, or terms tied to the end of a month. All balances are in U.S. dollars.Worked Example
If you input:
- As-of date: 2026-11-18
- Custom closed dates: 2026-11-26
- A-104: $2,400 original, $900 paid, Net 30 calendar days from 2026-10-05
- B-207: $850 unpaid, Net 4 business days from receipt on 2026-11-12
- C-310: $1,250 unpaid, Net 9 calendar days from later date 2026-11-17, move a closed due date
- D-416: $1,200 original, $200 paid, Net 5 calendar days from 2026-11-18
Result:
The four open amounts total $4,600. A-104 accounts for all $1,500 overdue. B-207 is due today and D-416 in five days, making $1,850 due today or within seven days. C-310 moves from the entered closure on November 26 to November 27.
Frequently Asked Questions
Does Net 30 mean 30 days after the invoice date?
The count starts after the term anchor specified by your agreement. For an issue-date term of 30 calendar days, add 30 days to the issue date. A receipt or acceptance term uses the corresponding entered date instead.
Which dates count as business days?
Monday through Friday count except for closures entered in the worksheet. When customs or contractual terms differ, use the calendar rules in your agreement and verify the result against the stated deadline.
What does rolling a due date do?
A due date on a weekend or entered closure moves forward to the next open business day. It is a separate choice from counting calendar or business days.
Does a partial payment change the due date?
The worksheet uses the same due date and subtracts what was paid from the invoice amount. If a contract changes the due date after a payment, enter the updated terms.
Is an invoice overdue on the due date?
An invoice with an open balance is due today when its adjusted due date equals the as-of date. It becomes overdue when the as-of date is later.
Does this determine a public contract or legal payment deadline?
Use the confirmed dates and terms for your own worksheet. Government rules and contracts may add acceptance assumptions, holiday treatment, dispute provisions, discounts or other adjustments.
Similar Calculators
Invoice Tax & Rounding Reconciliation
Reverse tax-inclusive prices, add tax to net prices, and reconcile invoice discounts and credits. Compare line and group rounding with exact audit ledgers.
Prorated Billing & Change Planner
Calculate prorated charges and credits across dated price or quantity changes. Compare invoice rounding, inspect service timelines and reconcile payment balances.
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
Date Difference Calculator
Calculate the exact number of days, weeks, months, and years between two dates.
