Deposit deductions: spreadsheet or software?

Published 17 October 2026. Updated 17 October 2026.

Most property managers start with a spreadsheet. Most offices already have one, everyone knows how to use it and it bends to whatever your portfolio needs. The real question is not whether a sheet can hold a list of deductions. It can. The question is what the job actually takes, where a sheet lets things slip, and at what volume that starts to cost you more than a tool would.

This guide compares three ways of handling the deduction side of a move-out: a spreadsheet such as Excel or Google Sheets, a purpose-built tool that checks one move-out at a time, and a full property management platform. It is meant to help you decide, and it says when each one is the right choice. For how to build the statement itself, see how to itemize security deposit deductions.

What the job actually takes

Whatever you use, a deduction statement needs the same things for each charge:

1. A clear description of what the charge is for.
2. The condition of the item at move-in and at move-out, from your own notes.
3. Evidence for the amount: an invoice, receipt, estimate or time sheet.
4. Photos named in the notes, if you took any.
5. An amount that matches the evidence.
6. A total that adds up against the deposit held, with the refund or the amount above the deposit worked out correctly.

The tool you choose changes how much of this you do by hand and how much gets checked for you. It does not change the list. Tenants, and anyone who later looks at a dispute, will ask the same questions of a charge whichever way it was built.

When a spreadsheet is enough

A sheet is a good fit when:

• You handle a few move-outs a month.
• One person builds every statement from start to finish.
• Your evidence is already filed in a consistent place, by unit and date.
• You like to see and control every cell.

A sheet usually costs nothing extra, needs no new sign-up and can be shaped to your lease terms and your own charge categories. A careful person with a good template can produce a solid statement. For a small landlord with a few units, this is often the right answer, and an extra tool would be one more thing to learn.

Where a spreadsheet breaks down

The failures are rarely dramatic. They are small slips that only show up when a tenant disputes a line.

• Retyping errors. An amount copied from an invoice into a cell can pick up a transposed digit. Nothing in the sheet knows the invoice says something else.
• Evidence out of sight. The sheet says "cabinet repair, $180" but the invoice is in an email, the move-out note is in a different folder and the photos are on a phone. Nothing flags that a line has no document behind it.
• Typed totals and stale formulas. A total that someone overwrote, or a formula range that missed the last row after a line was added, gives a wrong refund with no warning.
• Version confusion. Two copies of the file, one with the final invoice and one without, and no way to tell which one went out.
• Nobody checks the second time. The person who built the sheet is the person who proofreads it. The same blind spot that caused a mistake hides it.
• Condition notes not side by side. Comparing move-in and move-out condition means opening two documents per line, so it gets skipped when the manager is busy.

None of these are reasons never to use a sheet. They are the places to build checks into it if you stay with one.

Where a purpose-built tool helps

A tool that does one job, taking the files of one move-out and checking the deduction lines against them, tends to help where the failures above happen: it reads the documents so you do not retype figures, it flags lines with no evidence, and it adds up the totals itself. The cost is that you work in its format and it only covers the part of the job it was built for.

It makes the most sense when you handle enough move-outs that assembling each statement is a real time cost, when several people prepare statements and you want a consistent standard, or when you have been burned by a line that turned out to have nothing behind it.

When a full platform makes more sense

A property management platform that includes deposit accounting and inspections is the better choice when you want one system for leases, ledgers, work orders and inspections together. If your inspections already live in that system and it produces the statement for you, adding a separate tool may duplicate work. The trade-offs are cost, setup time and how well its deposit features suit your process. Check what yours actually does with evidence for individual lines, since platforms differ.

Comparison at a glance

A checklist whichever way you go

• One row or line per cause, never a lump sum.
• An evidence file name next to every amount.
• A status per line, such as ready, needs a document or not charged.
• A total built by formula or by software, never typed.
• Both condition notes visible with the line.
• A second read of the statement before it goes out, by someone other than the preparer or by you after a gap.
• The final version saved once, with the date, so there is never doubt about what was sent.
• Your lease and the deposit rules that apply to the unit checked for any deadline, limit or required wording. These vary by state and sometimes by city. A sheet or tool can help organize the evidence, but the rules that apply to you are yours to confirm, with your own counsel if you are unsure.

How MoveOutLedger does this step

MoveOutLedger is a purpose-built tool for one part of the job. You upload the files of one move-out: the deduction list, inspection notes, deposit record, vendor invoices and receipts, estimates, in-house time sheets and photos. Text PDF, Word, Excel, CSV and text are read, and JPG or PNG photos are listed by file name and not analysed. A scanned invoice is not read and is flagged.

For each line it checks that a move-out note, invoice, receipt, time sheet or estimate backs the charge, that the amounts agree, that both conditions are noted and that the photos named in the notes were uploaded. Ordinary code adds up the deposit and the refund. A second, stronger AI model reviews every result, fixes what it can, and lists what is left for you to decide. Results are model output checked by code and by a second model; they are not verified by a person. A line with nothing behind it is shown as not ready and left out of the total. You get an evidence packet in PDF and Word, a line table as CSV, the dates as read and a list of items to check, with that list first.

It does not check any state's deposit law, does not write demand wording and does not send anything to the tenant. One move-out packet is 12 credits, for up to 40 lines, with no subscription. Sign in to try it on one move-out.

Questions

Is a spreadsheet good enough for deposit deductions?

For a handful of move-outs a month with one person doing the work, a well-built sheet is often enough. It starts to strain when several people touch the same file, when evidence lives in many places, or when each statement takes a long time to assemble.

Can I keep my spreadsheet and still use a tool like MoveOutLedger?

Yes. MoveOutLedger reads the files you already have, such as an Excel (.xlsx) or CSV deduction list, and does not need your sheet replaced. The packet and line table can sit beside your own records.

What should a deposit spreadsheet have so it holds up?

One row per cause, an amount, a status for the evidence, the file name of each supporting document, a move-in and move-out condition column, and a total that is a formula rather than typed. Lock or protect the formula cells.