Security Deposit Itemization Spreadsheet: Refund, Interest, Deductions and Return Deadline (Excel & Google Sheets)
Short on time? The Landlord Tenant Toolkit ($39) is the finished, tested version of what this tutorial builds.
A security deposit return is where landlords most often lose money they didn't have to, or keep money they shouldn't. Miss the return deadline and some states forfeit your right to withhold anything. Deduct "normal wear" and the tenant has a clean argument. Forget interest when your state requires it and the itemization is wrong before you mail it.
This tutorial builds a one-tab deposit itemization that calculates interest, total deductions, the refund (or the balance the tenant still owes), the return / itemization deadline and how many days you have left. It works the same in Excel, Google Sheets and LibreOffice. We tested every formula below by building a workbook with these exact formulas, recalculating it in LibreOffice, and comparing every cell to the worked example and to an independent Python calculation (plus dozens of randomized move-outs).
1. A Setup tab with the as-of date
Make a tab called Setup:
| A | B | |
|---|---|---|
| 1 | As-of date | 2026-10-20 |
B1 is the day you are measuring from (today when you prepare the letter, or a fixed date for a monthly review). Type a date, or use =TODAY().
2. The Deposit tab (inputs)
One sheet per move-out is enough. Type the yellow cells; the rest calculate.
| A | B | |
|---|---|---|
| 1 | Tenant | P. Silva |
| 2 | Unit | 7 Birch B |
| 3 | Deposit held | 1500 |
| 4 | Annual interest rate (0 if none) | 0 |
| 5 | Move-in date | 2025-06-01 |
| 6 | Move-out date | 2026-10-15 |
| 7 | Damage charges | 510 |
| 8 | Unpaid rent and charges | 0 |
| 9 | Cleaning beyond normal wear | 150 |
| 10 | Other deductions | 0 |
| 11 | State return deadline (days after move-out) | 30 |
Damage charges is the total from your move-out inspection that you are allowed to charge (not normal wear). Cleaning beyond normal wear is the extra clean-out, not ordinary turnover cleaning your local rule treats as the landlord's cost. Other deductions covers contracted repairs or utilities the lease lets you take from the deposit. Put 0 in any line you aren't using.
3. The calculated cells
B12: =IF(OR(B5="",B6=""),"",B6-B5)
B13: =IF(OR(B5="",B6=""),0,B3*B4*MAX(0,B6-B5)/365)
B14: =SUM(B7:B10)
B15: =MAX(0,B3+B13-B14)
B16: =MAX(0,B14-B3-B13)
B17: =IF(B6="","",B6+B11)
B18: =IF(B17="","",B17-Setup!$B$1)
B19: =IF(B18="","",IF(B18<0,"PAST DEADLINE",IF(B18<=7,"Due within 7 days","On track")))
Label them in column A: Days held, Interest earned, Total deductions, Refund due to tenant, Tenant still owes, Return / itemization deadline, Days left, Deadline status.
What each one does:
- B12, Days held: move-out minus move-in. Useful when you are checking an interest figure by hand.
- B13, Interest earned: deposit × annual rate × days held ÷ 365. Leave
B4at 0 when your state (or building size) does not require interest. The product sheet uses the same day-count rule; it does not round to cents, so a 1% example can show a fraction of a cent until you optionally wrap it inROUND. - B14, Total deductions: damage + unpaid rent + cleaning + other.
- B15 / B16: only one of these is positive. If the deposit plus interest covers the deductions, B15 is the refund. If deductions are larger, B16 is what the tenant still owes and the refund is 0.
- B17, Deadline date: move-out plus the number of days your state (or lease, where the statute allows) gives you to return the deposit or send the itemization.
- B18 / B19: days from the as-of date to that deadline. Status turns amber at 7 days left and red when the deadline has passed.
Optional: interest rounded to cents
Banks pay in cents. If you want the sheet to match a bank statement:
B13 (rounded to cents): =IF(OR(B5="",B6=""),0,ROUND(B3*B4*MAX(0,B6-B5)/365,2))
Use either B13 or this variant, not both in the same cell.
4. Setting the deadline days from state rules
B11 is the number you look up. Here are two common statutes, as examples of how to translate the wording. This is how we read the text. Check the current law, your city and your lease before mailing anything.
| State | Rule (summary) | Typical B11 |
|---|---|---|
| Colorado | Return the full deposit within one month after termination or surrender (whichever is later), unless the lease sets a longer period of up to 60 days; keep nothing for normal wear and tear; send a written list of reasons with any partial retention (C.R.S. 38-12-103) | 30 (or up to 60 if the lease says so) |
| Texas | Refund on or before the 30th day after the tenant surrenders the premises; if you keep any part, send the balance with a written itemized list of deductions (normal wear is not allowed) (Tex. Prop. Code §92.103, §92.104) | 30 |
New York has separate rules on interest (buildings with six or more apartments must place deposits in an interest-bearing New York bank account; the landlord may keep 1% of the deposit per year as an admin fee, and the rest of the interest belongs to the tenant — see the NY Attorney General guide). Put the interest rate the tenant is owed in B4 after subtracting any allowed admin fee, and look up your return deadline separately.
Worked example
As-of date October 20, 2026. Deposit $1,500 held from June 1, 2025 to October 15, 2026 (501 days). No interest required (B4 = 0). Damage $510, cleaning $150, unpaid rent $0, other $0. State deadline 30 days after move-out.
| Field | Value |
|---|---|
| Days held | 501 |
| Interest earned | 0.00 |
| Total deductions | 660.00 |
| Refund due to tenant | 840.00 |
| Tenant still owes | 0.00 |
| Return / itemization deadline | 2026-11-14 |
| Days left | 25 |
| Deadline status | On track |
What the example shows:
- Refund = deposit − deductions when interest is zero. $1,500 − ($510 + $150) = $840.
- The deadline is a calendar date, not a feeling. Move-out October 15 + 30 days = November 14, 2026. On October 20 you still have 25 days (On track). Change the as-of date to November 10 and the status becomes Due within 7 days; November 15 → PAST DEADLINE.
- Interest changes the refund. With the same dates and a 1% annual rate (no rounding), interest is $1,500 × 0.01 × 501 / 365 ≈ 20.589, deductions stay $660, and the refund becomes about $860.59. The rounded variant of
B13makes that $20.59 of interest and a $860.59 refund exactly.
A second case, same dates, where deductions exceed the deposit: damage $1,200 + cleaning $400 = $1,600 against a $1,500 deposit and 0% interest → refund $0, tenant still owes $100, deadline still November 14.
Common mistakes
- Charging normal wear. Pinholes from picture hangers and faded paint are usually the landlord's cost. Only put chargeable damage in
B7. - Missing the deadline. Some rules (Colorado's among them) can forfeit your right to withhold anything if the written statement is late. Watch
B19. - Interest on the wrong day count. This sheet uses move-out minus move-in over 365. If your statute or bank uses a different day-count, adjust
B13. - Dates typed as text. If
B12orB17shows#VALUE!, re-enter the dates as real dates (Format → Number → Date in Google Sheets). - One sheet for every tenant. Copy the Deposit tab per move-out, or you will overwrite the prior itemization.
Related tutorials
- Rent late fee calculator spreadsheet: grace period, flat + daily fees and a cap.
- Build a rent roll that flags late rent automatically (plus a deposit ledger).
- Lease renewal tracker spreadsheet: expiration alerts, notice deadlines and rent increases.
Want it done for you?
The Landlord Tenant Toolkit is a finished workbook with a rent ledger that calculates late fees, a move-out inspection that feeds a security deposit itemization (interest, deductions, refund, return deadline and days left), a tenant screening scorecard, a turnover-vs-renewal calculator, a maintenance log and a dashboard. It comes with a filled-in 4-unit sample and works in Excel and Google Sheets with no macros.
Not legal advice. Deposit deadlines, interest, allowed deductions and notice rules depend on your state, city and lease. Check them before you withhold or mail a refund.
Free tool: Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR
Written with AI assistance. Every formula, command and number on this page was tested before publishing (see each section). Product links go to our store.