A2 - Income records, real estate

A structured alternative to your rental income spreadsheet

A spreadsheet row tells you that Unit 2B paid $1,450 in March. What it can't hold is the signed lease that sets that rent, the bank screenshot proving the payment landed, or the e-transfer confirmation for the month a tenant paid late. Cash Workspace lets you keep a rent-received ledger as records keyed by rental unit, so the lease and every rent payment proof live attached to the unit they belong to instead of in a folder three clicks away from the number. This page is about rent received only, the income side of your rental records. Recording the property's expenses (repairs, mortgage interest, property tax, insurance) is a separate job covered elsewhere on the site. Cash Workspace is free, and it is organizational software, not accounting or tax software.

The problem

Why a rent row stops being enough

A rent tab works until the year you actually need the paperwork behind it. When a tenant disputes whether April was paid, when you're handing a year of figures to whoever does your taxes, or when you simply can't remember which lease set the current rent, the spreadsheet cell is just a number with nothing behind it. The documents that prove the number live somewhere else: the lease in your email, the deposit slip on your phone, the e-transfer confirmation in your messages. The spreadsheet and the proof drift apart, and reuniting them is the part that eats an afternoon.

  • The rent figure sits in a cell, but the signed lease that sets it is in your inbox, so nobody can see at a glance what the tenant actually agreed to pay.
  • A row says 'paid' but holds no payment proof; when April is questioned there's no deposit slip or transfer confirmation attached to settle it.
  • A late or partial month gets a note like 'paid $700 of $1,450' that loses the second-half proof when it finally arrives.
  • Multiple units share one sheet, so rent for 14 Oak St Unit 2B and the duplex on Pine Ave blur together when you scroll.
  • At year end you re-hunt every lease and deposit slip across email, phone, and bank app to back up totals you already typed months ago.

The workflow

Keeping rent received as per-unit records

The shift is small: instead of one tab with a row per payment, you keep a folder per rental unit and a record per rent payment inside it, with the lease attached to the unit and the payment proof attached to each month. Here is a practical way to set it up.

  1. 1

    Make a folder per rental unit

    Create one folder for each unit you rent out, named so it sorts cleanly: '14 Oak St - Unit 2B', '14 Oak St - Unit 2C', 'Pine Ave Duplex - Left'. Residential or commercial, the unit is the key. This keeps each tenancy's rent and paperwork in one place instead of blurred across a shared sheet.

  2. 2

    Attach the current lease to the unit

    Upload the signed lease (or commercial tenancy agreement) into that unit's folder so the document that sets the rent sits beside the rent records it explains. When the rent changes at renewal, add the new lease and note the effective date; the old one stays for history.

  3. 3

    Add a rent-received record each period

    For each month (or each commercial billing period), create a record with the tenant, the period it covers, the amount received, and the date it landed. One record per period keeps the ledger readable and gives every payment its own home for proof.

  4. 4

    Attach the payment proof to that record

    Drop the bank deposit screenshot, e-transfer confirmation, or rent-receipt PDF onto the record for that month. Now 'March: $1,450 received' carries the evidence with it, not a memory that it happened. Cash Workspace does not connect to your bank; you upload the proof yourself.

  5. 5

    Handle late and partial months on the record

    If a tenant pays $700 now and $750 later, record both amounts on the period with both proofs attached, and note the outstanding balance until it's settled. The month stays one record that tells the whole story instead of two disconnected rows.

  6. 6

    Close the year into a fiscal-year folder

    At year end, keep the year's rent records together under a fiscal-year folder per unit, and export the records when you hand figures to whoever prepares your return. The lease and every proof travel with the numbers, so the totals are backed by documents you don't have to re-hunt.

Record structure

Fields to record per rent payment

These are the details worth capturing on each rent-received record so the ledger stays readable and every figure traces back to a tenant, a period, and a proof. Keep it to rent received; the unit's expenses belong in separate records.

Rental unit
Which unit the rent is for, e.g. '14 Oak St - Unit 2B'. This is the key the whole ledger is organized around.
Tenant name
The tenant or company paying, e.g. 'M. Alvarez' or 'Greenfield Cafe Ltd' for a commercial lease.
Period covered
The month or billing period the payment covers, e.g. 'March 2026' or 'Q2 2026', not just the date it arrived.
Amount received
What actually landed for that period, e.g. $1,450.00. Record partial amounts separately if the rent came in two pieces.
Date received
When the money actually arrived, which can differ from the date it was due, e.g. received 2026-03-05 for a March 1 due date.
Payment method
How it was paid, e.g. e-transfer, bank deposit, check, or standing transfer, so the attached proof type makes sense at a glance.
Outstanding balance
Any amount still owed for the period, e.g. '$750 of $1,450 outstanding', cleared when the rest arrives.
Attachments
The lease (on the unit folder) and the payment proof for the period: deposit slip, e-transfer confirmation, or issued rent receipt.

Example setup

An example rental income layout

A worked example for a small landlord with three units across two properties. Each unit is a folder holding its lease and a rent record per period, with proof attached to each.

14 Oak St - Unit 2B (2026)

Lease_Alvarez_2025-08.pdf attached to the folder. Rent records: 'Jan 2026 - $1,450 received 01-03 (e-transfer confirmation attached)', 'Feb 2026 - $1,450 received 02-02', 'Mar 2026 - $1,450 received 03-05'. Tenant: M. Alvarez.

14 Oak St - Unit 2C (2026)

Lease_Nguyen_2026-01.pdf attached. Rent records: 'Jan 2026 - $1,375 received 01-04 (deposit slip attached)', 'Feb 2026 - $700 received 02-03 + $675 received 02-19, balance cleared (two proofs attached)'. Tenant: T. Nguyen.

Pine Ave Duplex - Left (2026)

Lease_Greenfield_2025-11.pdf (commercial tenancy) attached. Rent records: 'Q1 2026 - $4,200 received 01-08 (wire confirmation attached)'. Tenant: Greenfield Cafe Ltd.

_Leases on file

Optional reference copies of all current signed leases gathered in one place, mirroring the lease attached on each unit folder, so renewals are easy to find.

2025 (closed)

Prior fiscal-year folders for each unit, each holding that year's rent records and proofs, kept read-only for reference and handoff.

Common mistakes

Common mistakes to avoid

  • Recording a rent figure but attaching no proof, so the record can't back up the number when a payment is questioned.
  • Mixing rental expenses (repairs, insurance, property tax) into the rent-received records; keep the income side clean and file expenses separately.
  • Logging by the date money arrived instead of the period it covers, so a late January payment looks like February income.
  • Letting a partial payment lose its second proof; keep both amounts and both attachments on the same period record until the balance clears.
  • Sharing one folder across multiple units so tenants' rent blurs together; one unit, one folder.
  • Expecting Cash Workspace to pull payments from your bank or read your deposit slips; you add records and attach proofs yourself.

How it helps

How Cash Workspace helps here

A folder per rental unit

Organize rent records into folders keyed by unit, so each tenancy's income and paperwork stay together instead of merging on one shared tab.

Lease and proof attached to the record

Attach the signed lease to the unit and each payment proof to its period record, so every rent figure carries the document that explains and proves it.

Fiscal-year folders

Group each year's rent records under a fiscal-year folder per unit, keeping closed years separate and easy to reference or hand off.

Export when you hand off figures

Export your rent records, with attachments intact, when you send the year's income to whoever prepares your taxes; this is record organization, not tax filing.

FAQ

Frequently asked questions

Does Cash Workspace pull rent payments from my bank automatically?
No. Cash Workspace does not sync with your bank and cannot import transactions. You create each rent-received record yourself and attach the proof, such as a deposit screenshot or e-transfer confirmation, manually. It is an organization tool for records you enter and documents you upload.
Does it read my lease or deposit slip to fill in the rent figure?
No. There is no OCR or automatic extraction; Cash Workspace does not read your documents. You attach the lease and the payment proof, and you type the amount, period, and tenant into the record yourself. The attachments sit beside the number you entered as evidence, nothing is pulled from them.
How should I handle a month a tenant pays late or in two parts?
Keep it as one record for that period. Enter each amount as it arrives with its own proof attached, and note the outstanding balance until the rest is paid. That way the period tells the full story instead of splitting into disconnected rows that lose their proofs.
Can it track my rental expenses too?
This page is about rent received, the income side. Recording the property's expenses, like repairs, property tax, or insurance, is a separate job covered by the expense pages on the site. Keeping income records and expense records distinct keeps each ledger clean and readable.
Is this tax or accounting advice?
No. This is organizational guidance for keeping rent records and their supporting documents tidy. Cash Workspace is not accounting or tax software and does not calculate what you owe or what you can deduct. For how rental income should be reported, consult a qualified professional.

Organization, not tax advice

Cash Workspace helps you organize rent-received records and attach the lease and payment proof to each. It is not accounting or tax software, does not sync with your bank, and does not read or extract figures from your documents; you enter records and upload proofs yourself. It does not calculate taxable rental income or deductions and is not a substitute for advice from a qualified tax or accounting professional. Operated by HELPERG LLC. Questions: info@helperg.com.

Start a free rental income workspace

Set up a folder for each rental unit, attach the lease, and start logging rent received with the proof beside every figure. It's free to begin, and your records and documents stay together from the first month. When tax season or a tenant question comes around, the answer is one click away instead of an afternoon of hunting.