Convert Bank Statements for Security Deposit Tracking
A security deposit is money you hold in trust, not income. Convert bank statements to track each tenant's deposit, its return, and the itemized deductions.
TL;DR - Quick Summary
A tenant's security deposit is not rent; it is money you hold in trust and owe back, often from a separate account and with an itemized statement of any deductions at move-out. Converting bank statements to a spreadsheet lets you track each deposit received, the interest where required, and the return, so the trust ties out per tenant.
A deposit is a liability, not income
The single most important thing about a security deposit is what it is not: it is not rental income. It is money that still belongs to the tenant, held in trust and owed back at the end of the lease minus any allowed deductions. Treating it as revenue overstates your income and, in many states, commingling it with operating money is not allowed at all. So a deposit needs to be tracked on its own as a liability, and the bank statement is where the money coming in and going back out is recorded.
Track each deposit per tenant
With more than one unit, the deposits pile up and blur together, so each one has to stay tied to the tenant and unit it belongs to. When a tenant moves in, their deposit lands in the account; until they move out, you are holding it. Converting the statements to a spreadsheet lets you tag each deposit received to its tenant and keep a running total of what you hold across the portfolio, so you always know the exact liability rather than an approximate one.
Interest and the separate account
Many places require deposits to sit in a separate, sometimes interest-bearing, account, and some require the interest to be paid to the tenant. That makes one check especially useful: the balance of the deposit account should equal the sum of the deposits you are holding, plus any interest owed. A converted spreadsheet that totals the per-tenant deposits gives you that sum to reconcile against the account balance, so a shortfall or a stray withdrawal shows up instead of hiding.
The itemized return at move-out
When a tenant leaves, the deposit has to be returned within your state's deadline, along with an itemized statement of any deductions, and those deductions are generally limited to unpaid rent and damage beyond normal wear and tear. The bank statement records the refund going out; the spreadsheet holds the arithmetic behind it: the deposit held, less each itemized deduction, equals the amount returned. Keeping that record makes the itemization defensible if the tenant disputes it.
Accuracy and privacy
Because a mishandled deposit can mean a penalty or a dispute, every deposit and refund is reviewable in the converter before export, so the trust accounting rests on accurate figures. The output is a clean spreadsheet ready to track by tenant. Since the statements hold real tenant funds, they are processed to build the spreadsheet and then deleted automatically, with nothing kept on a server afterward.
How it works
- Convert the statements: Convert the deposit account's bank statements into a CSV or Excel spreadsheet.
- Tag each deposit: Tag each deposit received to its tenant and unit, and keep a running held balance.
- Reconcile the account: Confirm the account balance equals the sum of deposits held, plus any interest owed.
- Record the return: At move-out, record the refund and the itemized deductions against the deposit held.
Comparison
| Task | Mixed in the books | Tracked in a spreadsheet |
|---|---|---|
| Classify a deposit | Counted as income | Held as a liability |
| Per-tenant balance | Unknown | A running total |
| Account reconcile | Guess | Sum of deposits held |
| Itemized return | Scramble | Deposit minus deductions |
| Compliance record | Risky | Clear and defensible |
A year of statements tallies deposits held per tenant in about 40 seconds. Convert your statements now.
See pricing