Home / Templates / Deposit Statement Line-Item Worksheet
Free worksheet

Deposit Statement Line-Item Worksheet

A line-by-line worksheet for categorizing, proving, pricing, and depreciating each security deposit deduction before it is copied onto the tenant's statement.

Download the worksheet (.csv)

Reviewed for 2026, updated September 8, 2026.

A deposit statement is a short accounting document, and it is only as defensible as its weakest line. A bundled entry such as 'repairs and cleaning' gives the tenant nothing to verify and gives a small claims judge an easy reason to strike the whole deduction. This worksheet forces each charge to stand on its own before it reaches the statement: what the charge is, which allowed category it falls under, which photo or receipt proves it, what the full cost was, how much of that cost the tenant fairly owes after depreciation, and the final figure. Fill it in first, then copy the finished lines onto the statement in the same order.

The example rows show the kinds of entries a typical move-out produces and where the supporting numbers come from. Replace every 'Your figure' with the real amount from your own receipt, estimate, or ledger, and keep the evidence references consistent with the file names in your unit folder so anyone reading the statement can find the proof in seconds. For any replacement item, run the age and expected useful life through our Deposit Deduction Depreciation Calculator at /tools/deduction-depreciation-calculator/ before entering the deducted amount. The last two rows are totals and must match the statement to the cent. Category limits vary by state, so confirm cleaning, repainting, and labor rules before relying on any row here.

Line itemAllowed categoryEvidence referenceFull cost and sourceAge and depreciationAmount on statementNotes
Deposit heldStarting balanceLease page 1 and deposit receipt dated at move-inNot applicableNot applicableYour figureEnter the full amount collected, plus any interest your state or lease requires you to credit
Carpet replacement, bedroom 2Damage beyond normal wearPhotos MI-08 and MO-08, carpet invoiceYour invoiceInstalled age and typical useful life, proratedYour figurePet stains across most of the room; charge only the remaining value, never the full new price
Drywall repair, hallwayDamage beyond normal wearPhotos MO-03 and MO-04, contractor invoiceYour invoiceNone, repair of a specific holeYour figureTwo large holes, not small nail holes, which would be wear and tear
Cleaning beyond move-in conditionCleaning, where the state allows itPhotos MO-12 to MO-15, cleaning receiptYour receiptNone, but only the portion beyond the move-in baselineYour figureConfirm whether your state limits or bars cleaning charges before including this line
Unpaid rent, final monthUnpaid rentRent ledger entry and lease clause on rentLedger balanceNot applicableYour figureProrate if the tenant left mid-month and the lease or state rules require it
Unpaid water and sewer billLease-defined chargeUtility statement and lease clause on utilitiesUtility statementNot applicableYour figureOnly chargeable if the lease clearly makes the tenant responsible for this utility
Repainting, child's bedroomGray zone, document carefullyPhotos MI-05 and MO-05, painter estimateYour estimateYears since last repaint, proratedYour figureCrayon on the walls is damage; ordinary fading or scuffs alone would be wear and tear
Broken window blind, living roomDamage beyond normal wearPhoto MO-06 and store receiptYour receiptBlind age, proratedYour figureSmall items still need a photo and a receipt to survive a dispute
Removal of abandoned furnitureLease-defined chargePhoto MO-16 and hauling receiptYour receiptNot applicableYour figureCheck your state's abandoned property notice rules before disposing of anything
Total deductionsSubtotalSum of the deduction lines aboveNot applicableNot applicableYour figureMust equal the total printed on the statement exactly
Balance refunded or owedFinal balanceDeposit held minus total deductionsNot applicableNot applicableYour figureA positive result is refunded to the tenant; a negative result is the amount the tenant still owes

Also from DepositBackr