Security Deposit Tracker with Due Dates in Google Sheets

Ever tried tracking down four separate security deposit refunds six weeks after everyone moved out of an apartment? It gets messy fast. Landlords rarely split security deposits into neat, individual checks for each roommate. They issue one lump sum to whoever signed the lease or designated the bank account, leaving the house to sort out individual contributions, repair deductions, and timing on their own.

A basic Google Sheet with a dedicated due date column fixes this problem before move-out day arrives. It records who paid what upfront, flags legal return deadlines, and logs what everyone is actually owed.

You do not need specialized software. A clean spreadsheet handles the math cleanly.

The Core Columns for Tracking Deposits

Keep the layout lean so nobody abandons it.

Setting Deadlines for Move-In and Move-Out

Thing is, a security deposit tracker actually needs two separate due date checkpoints during a lease. The first is the upfront collection date before the landlord gets paid. If one person fronts the entire $3,000 security deposit on their personal checking account - which happens constantly in college towns and competitive rental markets - everyone else needs a strict deadline to pay that roommate back. That prevents instant resentment.

The second due date arrives after move-out, and it depends on your state laws. Landlords face strict statutory return windows once keys are returned. In California, landlords have 21 calendar days to send an itemized statement and any remaining refund. Arizona gives landlords 14 business days, excluding weekends and holidays, once the tenant delivers possession and submits a written demand. According to the ReclaimDeposit state deadline reference, missing these statutory timelines can forfeit a landlord's right to withhold funds. Put that exact statutory return date into your tracker the morning after your lease ends. It anchors your timeline.

Step-by-Step Setup in Google Sheets

1. Create the spreadsheet and freeze the header row. Open Google Sheets and label a new sheet with your rental address. Enter the column names in Row 1: Roommate, Upfront Paid, Due Date, Itemized Deductions, Status, Net Refund Owed, and Date Settled. Highlight Row 1, then click View > Freeze > 1 row. This keeps your labels visible as you scroll.

2. Format date and currency columns. Highlight column C and column G. Go to Format > Number > Date so Google Sheets recognizes entry values as true calendar dates. Highlight columns B, D, and F, then select Format > Number > Currency.

3. Add the refund calculation formula. In cell F2 under Net Refund Owed, enter =B2-D2. This formula automatically subtracts any damage or cleaning deductions from that roommate's original contribution. Drag the small blue square at the corner of cell F2 down the column to fill the rest of the rows.

4. Apply conditional formatting for overdue deadlines. Highlight column C starting from cell C2 downward. Click Format > Conditional formatting. Under "Format rules", choose "Custom formula is" and type =$C2<TODAY(). Set the formatting style to a soft red or light yellow background. If a deadline passes without an update, the cell lights up immediately.

5. Create a status dropdown. Select column E from E2 down. Open Data > Data validation > Add rule. Set the criteria to "Dropdown" and add four simple options: Awaiting Upfront, Held in Escrow, Pending Landlord, and Settled.

Handling Landlord Deductions and Roommate Disputes

Deductions are where roommate relationships usually fracture. If the landlord withholds $400 for carpet stains in a specific bedroom, that charge should not come out of everyone's split equally. Turns out, the cleanest approach is recording individual responsibility directly in your sheet before anyone transfers cash. As noted in the ReclaimDeposit guide on roommate deposit splitting, joint leases make everyone jointly liable to the landlord, but housemates should establish an internal agreement covering who pays for specific damage.

• Direct damage: Assign the exact invoice cost to the responsible tenant under their Itemized Deductions cell.
• Shared common area repairs: Divide the expense evenly across all housemates by entering an equal deduction for each row.
• Unresolved disputes: Escrow the disputed portion in the sheet while the house reviews move-in condition photos.

Keep receipts and inspection photos in a shared Google Drive folder linked in a cell note. Transparency stops arguments.

Sharing Permissions That Prevent Accidental Edits

Give only one or two organized roommates edit access to the sheet. Share it with the rest of the household using "Viewer" permissions so people can verify their numbers without accidentally deleting cell formulas or dragging ranges out of place. If someone spots an error, they can leave a cell comment.

Moving From Spreadsheets to Payment Apps

Spreadsheets track numbers, but they do not transfer funds. Do not try to turn your sheet into an automated payment processor. Use the tracker as your single source of truth for balances and deadlines, then execute the actual payouts through whatever payment app or bank transfer method your house prefers. When you send a reimbursement, paste the payment confirmation code into the Date Settled column or add a note. That ties your bank records directly to your lease accounting.

Your immediate next step is simple. Open a new blank sheet today, enter your household deposit total, and drop your lease's statutory return deadline into column C.