How to Add an Existing Tenant to Your Records

A clean go-live method for mid-lease tenants: opening balances, deposits held, lease dates, and payment history without rewriting history.

By RentalNoodle Editorial Team · Updated 2026-09-13 · Published 2026-09-13

Add an existing tenant by creating the property/unit, entering the real lease dates and rent amount, recording the security deposit still held, and setting an opening rent balance as of a chosen go-live date — then post new payments only after that date. Do not invent a fake “move-in today” that erases the actual tenancy start; courts and tax records care about what actually happened.

Deposit ownership, required notices, and mid-lease fee changes vary by state and local jurisdiction. This guide is educational — not legal advice. Confirm requirements with local counsel or your housing authority before relying on any deadline, notice form, or deposit rule.

Gather source documents before you type

Choose a go-live date and opening balances

Pick a clean boundary — usually the first of the month or the day you switch tools. Everything before that date stays in your old spreadsheet or bank history as an archive. Everything on or after posts in the new system. Opening balances answer: Does the tenant owe rent today? Are they prepaid? How much deposit do you hold?

Example: Tenant paid September rent early on August 28. On a September 1 go-live you record prepaid rent of $1,875 (or mark September as paid) so you do not charge them again. The deposit of $2,500 is logged as held funds, not as September income.

Reconcile common opening balance scenarios

Most migration errors come from one of a few recurring situations. Map your tenant to a row before you type anything — guessing creates duplicate charges or invisible balances.

Deposits are not rent

Security deposits are typically liabilities until lawfully applied or returned. CFPB renting resources emphasize that return timing and allowable deductions depend on state law. When migrating records, copy the original collected amount and any lawful deductions already documented. Do not “recognize” the deposit as income in your operating ledger just because you are setting up software.

Tax rules change and depend on your situation. RentalNoodle organizes income and expenses you record and can export Schedule E preparation summaries — it does not file taxes or give tax advice. Confirm treatment with a CPA or enrolled agent.

Recurring charges beyond base rent

If the lease lists pet rent, parking, storage, or utility reimbursements, enter them as separate recurring charges with the same start date as base rent — not as a lump sum you adjust manually each month. That keeps ledger exports honest for Schedule E prep and prevents “rent” from silently absorbing fees tenants dispute later.

Month-to-month tenants already in place

When the original fixed term expired and the tenancy continued without a new end date, record lease type as month-to-month with the conversion date if known. Enter the actual tenancy start (move-in), not the day you discovered the lapse. Notice rules for rent changes and termination differ from fixed-term renewals in many states — your records should reflect periodic tenancy so renewal calendars do not fire false alarms.

Example: Fixed lease ended 2026-06-30; tenant stayed and pays monthly. Go-live 2026-09-01: lease start 2024-07-01, end date blank or marked month-to-month since 2026-07-01, rent 1,875, deposit 2,500 held since move-in. Do not create a fake end date twelve months out unless both parties signed a renewal.

Step-by-step entry workflow

1. Create the property and unit with your standard ID (e.g., 12-OAK).
2. Add the tenant profile: legal names, phone, email, forwarding address if known.
3. Create the lease record with actual start/end, rent, and late-fee terms as written.
4. Enter deposit held as a deposit balance, with original received date if known.
5. Set rent opening balance / prepaid flag as of go-live.
6. Attach the lease PDF and any inspection photos you have.
7. Optional: import recent payment history for continuity in disputes.
8. Send the tenant a short note: how to pay going forward and how to request repairs.

Income recognition at go-live (tax angle)

IRS Publication 527 treats rent as income when received or when constructively received — migrating software does not create new income events. Deposits held before go-live were never income; prepaid rent collected before go-live may already belong in a prior tax year. Your opening balance should mirror cash-basis reality: if the tenant prepaid September on August 28, September’s rent is not “new” income on September 1 in your books — it is already satisfied. RentalNoodle organizes what you record and exports Schedule E preparation summaries; it does not file returns or tell you how to report prior years.

Partial history vs full rebuild

• Minimum viable: lease + deposit held + opening rent balance + documents
• Better: last 12 months of payments for pattern evidence
• Best for disputes: full ledger from move-in plus inspection set
• If old records are messy, freeze them as a dated PDF archive and start clean at go-live with accurate balances

Sample opening journal (illustrative)

When old records are a mess

If prior years are inconsistent, freeze what you have: export the spreadsheet to PDF, save bank statements, and attach a one-page memo listing known gaps (“2025 Q2 — no separate pet rent line”). Start clean at go-live with accurate opening balances rather than inventing twelve months of fictional payments. Courts and CPAs prefer honest gaps with correct current balances over a pretty ledger full of guesses.

Roommates, guarantors, and mid-lease changes

List every adult occupant the lease names. If only one person is on the lease, do not invent co-tenants in your records to “match reality” without a signed amendment — occupancy and liability are legal facts. Guarantors belong on the file with their signed guaranty. When someone moves out mid-lease, follow the lease and state rules for release; update records only after paperwork is done.

Post-entry verification walkthrough

Common migration mistakes

• Setting lease start = today and losing renewal math
• Booking the deposit as rental income on go-live
• Double-charging a month that was prepaid
• Leaving outstanding balances at $0 when the tenant actually owes
• Failing to store the old spreadsheet as a frozen archive
• Changing rent in the software without a signed renewal or lawful notice

After entry, run a one-page audit: lease PDF rent = system rent; deposit PDF/receipt = system deposit; tenant confirms last payment date. Fix mismatches before the next due date.

Educational content for independent landlords. RentalNoodle is property management software — not a law firm, CPA firm, or government agency. Rules vary by state and locality. Confirm legal and tax questions with qualified professionals.