Published 2026-10-05 · sources checked 2026-10-05

Late fee calculator in Excel: a formula with a grace period

A late fee is three decisions: how many grace days, flat or percent, and whether there is a cap. Here is a formula that applies all three, with a worked $1,800 example.

General information only, not tax, legal or accounting advice. Late-fee, deposit and notice rules vary by state, city and lease; check your own. Tax references describe US federal pages on irs.gov as of the date above.

What a late-fee formula has to decide

Three choices sit behind every late-fee calculation: how many grace days the tenant gets, whether the fee is a flat amount or a percentage of rent, and whether the fee has a cap. Your lease should state all three. A spreadsheet only applies them consistently; it cannot tell you what you are allowed to charge.

The inputs

Monthly rent, due date, and the date the rent was paid. If the paid date is empty, the formula below uses today's date.
Grace days: how many days after the due date pass before a fee applies.
Fee type (Flat or Percent) and fee amount. Type a dollar figure for a flat fee, or a percentage such as 5% so the cell holds 0.05.
Cap: the most the fee can be. Leave it empty for no cap.

The formulas

An example layout, inputs in column B and outputs under them. Yours can sit anywhere.

B1  Monthly rent     1800
B2  Due date         2026-03-01
B3  Paid date        2026-03-10     (empty if unpaid)
B4  Grace days       5
B5  Fee type         Percent        (or Flat)
B6  Fee amount       5%             (or 75 for a flat $75)
B7  Cap              (empty = no cap)

B8  Days late        =MAX(0, IF(B3="", TODAY(), B3) - B2 - B4)
B9  Fee before cap   =ROUND(IF(B5="Percent", B1*B6, B6), 2)
B10 Late fee         =IF(B8=0, 0, IF(B7="", B9, MIN(B7, B9)))
B11 Total due        =B1 + B10

Days late is the whole grace-day test. Paid date minus due date counts calendar days; subtracting the grace days leaves the days past the grace period, and MAX(0, ...) stops an on-time payment from going negative. The fee applies only when that number is 1 or more. If you want the test to read as words, with a paid date entered, use =IF(B3-B2>B4, "Fee applies", "Within grace").

Worked example: $1,800 rent, 5 grace days, 5% fee

Rent $1,800 is due March 1. Fee before cap is 1,800 x 0.05 = $90.00. A payment on March 10 is 9 days after the due date and 4 days past the 5 grace days, so days late is 4, the late fee is $90.00 and the total due is $1,890.00. The fee is charged once, so a payment on March 31, 25 days late, still carries $90.00. The last column shows what a $50 cap typed into the cap cell would do.

Paid date	Days late	Fee, no cap	Fee, $50 cap
March 5	0	$0.00	$0.00
March 6	0	$0.00	$0.00
March 7	1	$90.00	$50.00
March 10	4	$90.00	$50.00
March 31	25	$90.00	$50.00

Flat and percent behave differently across rents. A flat $75 is $75 on any row with 1 or more days late, while 5% is $60 on $1,200 rent and $120 on $2,400.

Count the grace days the way your lease does

The edge case is where grace ends. With rent due on the 1st and 5 grace days, a payment on the 6th is 5 days after the due date, so days late is 0 and the first fee day is the 7th. If your lease says rent is late if not received by the 5th, set grace days to 4 instead, which makes the 6th the first fee day. Read the lease wording and set the input to match. The formula counts calendar days and knows nothing about weekends or holidays; if your lease moves a due date that lands on one, enter the moved date as the due date.

Check the rules where you rent

Late-fee rules differ between states. Two official texts, both checked on 2026-10-05, show how different the wording can be. New York's Real Property Law section 238-a, as published by the New York State Senate, says no fee for late payment of rent may be demanded unless the rent "has not been made within five days of the date it was due", and that the fee "shall not exceed fifty dollars or five percent of the monthly rent, whichever is less" (the section has exceptions, so read it in full): NY Real Property Law 238-a. Oregon's ORS 90.260 lets a landlord impose a late charge only if the rent "is not received by the fourth day of the weekly or monthly rental period" and a written rental agreement specifies the late charge, its type and amount, and when it becomes due: Oregon ORS chapter 90.

The two count days differently and limit the amount in different ways. On $1,800 rent, the New York wording would hold the $90 in the table to $50, which is why the table has a cap column. This is not a summary of either state's law and not a statement about your unit. Check your lease and your state's landlord-tenant rules.

What this does not cover

This models one fee charged once. It does not model daily or repeating late charges, interest, partial payments, waived fees, or notices. It does not know whether a fee is allowed, whether a payment arrived in time under your lease, or how your local rules treat any of that. It applies whatever numbers you type into the inputs.

Sources

More landlord guides

Already built

The Landlord Rent & Expense Tracker's Rent Ledger has a row per unit-month with days late and a late fee worked out from the fee type, amount, cap and grace days you set once on the Start Here tab. It does not know your state's rules; you enter the numbers from your lease. One Excel file, $29 one-time, no bank link and no account.

See what is inside