A Rental Income Sheet in Google Sheets from Your Bank Statements
Landlords: import converted bank statement rows into Google Sheets to log rent and property costs. Runs in your browser. File never uploaded.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for landlords
- Download the statement for the account your rent goes into as a PDF (scanned PDFs aren't supported).
- Choose the file in the converter near the top. It's opened on your device only.
- Confirm each tenant's rent shows up once per month.
- Set Export layout to Standard columns (free, like the QuickBooks, Xero and YNAB layouts), choose Download CSV, then add a Property column.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-04-01 | Rent Unit A | 1650.00 | |
| 2026-04-01 | Rent Unit B | 1475.00 | |
| 2026-04-20 | Lawn service | -120.00 |
Sample rows, Standard columns setting.
Google Sheets notes
- The Standard columns layout writes dates as YYYY-MM-DD, which Google Sheets reads as dates whatever your spreadsheet locale is.
Why it fits landlords
If a co-owner or property manager needs to see the numbers, Google Sheets keeps one copy everyone can open. Convert each month's statement and append the rows to your rental log.
Rental owners with partners often keep one sheet per year, with a tab per property and a shared summary. Appending each month's converted rows takes a minute, and everyone sees the same rent and repair figures without emailing files around.
Tip: Use a filter view per property, so each person can look at their own unit without changing what others see.
Questions
Can I import several properties' statements?
Yes. Convert each account's statement and import it to its own tab, or append it with a Property column added.
Does it total rent for me?
Add a SUMIF on the Property column for the deposit rows. RowSmith gives you the rows. The formulas are yours.
Can my property manager add rows too?
Anyone you give edit access can add rows. Agree on a column layout first so everyone's rows line up.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.