Sharing an editable spreadsheet with three roommates is asking for trouble. To be honest, someone always accidentally deletes a formula, types over a total, or questions who paid what two years ago. Exporting a finalized security deposit tracker to a PDF creates a clean, unchangeable record for everyone on the lease. Can you generate that PDF without cutting off the running balance column? Yes. You just need to set the print area and scale the width before exporting.
Essential Columns for a Shared Deposit Ledger
A security deposit tracker handles money differently than a monthly rent roll. Rent resets to zero each month. A security deposit is a static fund held for months or years. It only changes when someone moves in, pays an extra pet deposit, incurs a deduction, or receives a refund.
Keep your layout simple. Five columns cover the entire history:
| Date | Roommate | Description | Amount | Running Balance |
|---|---|---|---|---|
| 2026-06-01 | Jordan | Initial security deposit | 1200 | 1200 |
| 2026-06-01 | Morgan | Initial security deposit | 1200 | 2400 |
| 2026-08-15 | Jordan | Added pet deposit | 300 | 2700 |
| 2027-05-31 | Morgan | Move-out carpet repair deduction | -150 | 2550 |
Use positive numbers for deposits and negative numbers for deductions or returns. That way, basic math works without complex nested conditions.
Formulas for Running Balances and Individual Totals
Turns out, keeping a running balance does not require complicated math. In cell E2, enter =SUM($D$2:D2) and copy it down the column. The dollar sign anchors the first reference to row 2, while the second reference moves with each row you add. Each line shows the exact balance remaining in the account at that moment.
To see what a single roommate has contributed or deducted, put a summary table off to the side. Use SUMIF to isolate their entries:
=SUMIF(B:B, "Jordan", D:D)
This formula scans the roommate name column, finds every matching entry, and adds up the corresponding amounts. It handles unequal move-in dates and differing deposit splits cleanly. If Jordan paid a $300 pet deposit that Morgan had no part in, Jordan's individual total reflects that extra stake without confusing the household total.
Locking Formula Cells Before Sharing
When sharing the workbook with roommates, lock down the math. You want them to view the ledger or type in new entries without accidentally breaking the formulas. Worksheet protection in Excel is a standard two-step process detailed by Microsoft Support:
- Unlock the input cells: Select only the cells where roommates should type, such as columns A through D. Press Ctrl+1 (or Command+1 on Mac) to open Format Cells, switch to the Protection tab, and uncheck Locked.
- Protect the sheet: Go to the Review tab on the top ribbon and select Protect Sheet. Check the box allowing users to select unlocked cells, and leave locked cell selection optional. Set a password if you want, but keep it simple so you do not lock yourself out later.
Once active, roommates can add transaction rows, but clicking into the balance column will trigger a warning.
Page Setup for a Clean Single-Page Width PDF
Thing is, default Excel print settings are notorious for splitting tables. You export a PDF, open it, and discover the running balance column was shoved onto an awkward second page. That looks unprofessional and confuses people reading it on a phone.
Fix this before you hit export:
First, highlight your table from the top-left header down to the last data row. Under the Page Layout tab, click Print Area and choose Set Print Area. This isolates the ledger and cuts off blank rows or random scrap calculations sitting to the right.
Next, look at the Scale to Fit section on that same Page Layout tab. Change Width from Automatic to 1 page. Leave Height set to Automatic. This forces Excel to shrink the column widths just enough to fit on one sheet across, while allowing a long lease ledger to flow naturally down multiple pages if needed.
Finally, go to File, select Export, and click Create PDF/XPS. In the dialog box, click Options and make sure Active Sheet is selected. Save the file with a clear name like 2026_Deposit_Ledger_Statement.pdf.
Documenting Deductions and Move-Out Rules
Detailed notes matter just as much as accurate numbers. If a landlord or master tenant deducts money for damages, writing repairs in the memo field will almost certainly spark an argument. Be uncomfortably specific. Write professional steam cleaning for master bedroom carpet or replaced broken window blind in dining room. Attach the repair invoice number right inside the cell if there is room.
State laws govern security deposits strictly. Most states require landlords to return funds and provide an itemized statement within 14 to 60 days of move-out, and several jurisdictions require interest payments on funds held over a year. A personal Excel tracker does not replace official state disclosure notices or legal lease agreements. It simply acts as an agreed internal record of who paid, who owed, and who got refunded.
When a roommate moves out early or the lease wraps up, generate the final PDF export. Attach copies of the move-out inspection checklist, paid repair receipts, and bank transfer screenshots, then email the whole package to the group. That paper trail ends arguments before they start.