# Google Sheets for property managers on Mac: rent rolls, late fees and lease tracking

> Google Sheets for property managers on Mac: rent rolls, lease dates, late fees, Mac shortcuts, and how to get voice help from Lazur.

URL: https://www.lazur.app/for/property-managers/google-sheets
Updated: 2026-11-06

Google Sheets works on a Mac through your browser, and it covers most of what a property manager tracks. The core file is the rent roll, with one row per unit for tenant, rent, deposit and lease dates. This guide shows how to set it up, which formulas catch problems, the Mac shortcuts that save time, and where Lazur helps inside the sheet.

## Quick answer

- Google Sheets on a Mac works well for a rent roll: one row per unit, with tenant, rent, deposit and lease dates.
- Use Data > Data validation for status dropdowns, and Format > Conditional formatting to flag late rent and ending leases.
- Build your checks with SUMIFS, COUNTIFS, IF, TODAY and EDATE, and test each formula on a copy first.
- Excel files open in Sheets, but cells over 50,000 characters are removed when the file converts.
- Lazur sees your screen only while you hold ⌥⌘. It points, explains, guides and drafts. It does not click for you.

## What a property manager tracks in Google Sheets

Most property managers start with a rent roll. A rent roll lists every unit you manage, who lives there, and what they pay. It answers the questions that come up every week. Who paid? Who is late? Which lease ends next? How much deposit do you still hold?

Stessa, a landlord software company, publishes a rent roll template in two forms: a downloadable .xlsx file and a Google Sheets file. Its guide lists the fields it recommends for each unit. Treat that list as a checklist. Your state, your owner agreement and your company policy decide what you must keep.

- Unit number, size, beds and baths
- Tenant name and monthly rent
- Rent collected and late fees
- Additional rent for pets, roommates or parking
- Security deposit held
- Lease start date, end date and length
- Renewal options and annual increases

Stessa's guide says the rent roll helps you check three things. Is rent paid in full and on time? Should a late notice go out? How much security deposit do you hold, which matters at inspections? Build the sheet around those three questions first. Add the rest once the basics work.

- **20 million** Cells a Google Sheets file can hold, per Google's file limits page ([source](https://support.google.com/drive/answer/37603))
- **100MB** File size limit for a spreadsheet created in or converted to Google Sheets ([source](https://support.google.com/drive/answer/37603))
- **50,000** Characters per cell. Longer cells are removed when an Excel file converts ([source](https://support.google.com/drive/answer/37603))

## Set up the rent roll so the numbers stay honest

Use one tab for units and one for leases. The unit tab holds facts about the building that rarely change. The lease tab holds the tenant, the dates and the money. Link the two by unit name, so a renewal does not mean retyping the building details.

Keep each column to one kind of value. Dates go in date cells. Rent goes in number cells. Status goes in a dropdown. Avoid merged cells inside the data. Merged cells break sorting and filtering, and they make formulas harder to write.

![Property manager on a Mac using Google Sheets for rent rolls, lease dates and late fees](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/property-managers-google-sheets/google-sheets-for-property-managers-on-mac-1-3292d2.jpg)

| Tab | What it holds | Why it matters |
| --- | --- | --- |
| Units | Unit name, size, beds and baths | Stable facts that rarely change |
| Leases | Tenant, rent, deposit and lease dates | Where most of your checks happen |
| Payments | Date, unit, amount and method | A record of what came in |
| Notices | Late notices, renewal letters and dates sent | Keeps the paper trail in one place |

_One tab per job keeps each fact in one place._

### Freeze the header and select with the keyboard

Open View > Freeze to keep the header row visible as you scroll. Without it, you lose track of which column is rent and which is deposit after a few screens.

Use ⌃Space to select a whole column and ⇧Space to select a whole row. Google lists both on its Mac shortcut page. Select a full rent column before you format it, so every row gets the same number style.

## Dropdowns and conditional formatting for status

### Use dropdowns for rent status

Select the status column, then open Data > Data validation. Set the rule to a list of items, such as Current, Late, Notice given and Vacant. A dropdown stops typos like 'Lat' or a stray space from breaking your counts. Formulas match exact text, so one extra space can hide a row.

Dropdowns also keep filters reliable. A filter on Late shows every late row, because every late row says Late in the same way. Free text gives you spelling variants, and a filter misses them.

### Flag late rent with conditional formatting

Select the rent status column, then choose Format > Conditional formatting. Pick the rule that says the text is exactly Late, and choose a fill color. Late rows now stand out when you scroll, even on a small laptop screen.

Use the same tool for lease end dates. Create a rule that colors a date cell when it falls inside a window you set. Put the window length in its own cell. You can change it later without editing the rule.

## Formulas for rent, deposits and lease dates

You do not need advanced formulas for a rent roll. A few functions cover most of it: SUMIFS, COUNTIFS, IF, TODAY and EDATE. Learn one at a time, and test each one on a copy of the sheet first.

SUMIFS adds a column only where another column matches. For example, =SUMIFS(Leases!F:F, Leases!H:H, "Late") adds the amounts in column F on rows where column H says Late. Swap in your own tab name and column letters.

COUNTIFS counts rows that pass more than one test. Use it to count late units in one building. The result tells you how many late notices to write this week, without scrolling through the tab.

TODAY returns the current date, and it updates each time the sheet recalculates. Compare a lease end date with it. A formula like =IF(D2-TODAY()<$B$1,"Renew","") flags leases that end inside the window in B1, counted in days. Adjust the cell references to match your layout.

EDATE adds whole months to a date. Use it to calculate a renewal date from a start date and a lease length in months. Keep the length in its own column, so every lease follows the same rule.

- SUMIFS: total rent or fees for one status
- COUNTIFS: count rows that match more than one test
- IF: label rows that need action
- TODAY: the current date, so flags stay current
- EDATE: a renewal date from a start date and lease length

## A worked example: one late tenant, step by step

1. Open the Leases tab and find the tenant's row.
2. Check the rent status cell. It should say Late, picked from the dropdown.
3. Confirm the row turned color. If it did not, check the conditional formatting rule.
4. Run a COUNTIFS on the building column to see how many late rows that building has.
5. Ask Lazur to draft a reminder, then read it and change anything before you send it.

Keep the order. Check the data before you act on the count. A count built on a misspelled status comes out low, and you will miss a late tenant. The check takes less time than the mistake.

## Lease dates, sorting and renewal reminders

Sort the Leases tab by end date with Data > Sort range, so the next lease to end sits at the top. Turn on Data > Create a filter when you want one building or one status. A filter hides rows. It does not change the data, and you clear it when you finish.

Sort the whole table, not one column. If you sort a single column, each name separates from its rent. That mistake puts the wrong rent on the wrong tenant, and it is hard to spot later.

A cell nobody opens will not remind you. Put renewal tasks in Apple Reminders instead. Lazur can add one by voice. Say the task and the date, and Lazur adds it to Apple Reminders for you.

## Edge cases: partial payments, roommates and move-outs

A partial payment needs two columns. Keep rent due and rent collected apart. A partial payment then shows a balance still owed, instead of a row that says Paid. Check the balance column when you run the late count.

Roommates and pets go in the additional rent column, as Stessa's list suggests. If you add them into the main rent cell, your rent totals drift from what the lease says. Keep them separate, and total them with a formula.

On a move-out, keep the row. Change the status to Vacant and record the date. Keep the deposit line until the deposit is returned or applied. A deleted row loses a record you may need at an inspection.

## Owner statements and connected tools

Owner statements often start from the rent roll. Google's Sheets page lists third-party connectors for Asana, HubSpot, Intuit QuickBooks and Salesforce. If your accounting already runs in QuickBooks, check that connector before you build a manual bridge.

A connector depends on your Google account and on what your organization allows. Ask whoever manages your accounts before you turn one on. Read Google's current help pages to see what your account can connect.

## Excel files in Google Sheets: what changes on conversion

Owners, banks and tenants often send Excel files. Google says you can open and edit Excel files in Sheets without making a copy. Read that carefully. Some Gemini features only work after you convert the file to Sheets format.

Converting an Excel file removes cells over 50,000 characters. This matters for long notes pasted into a single cell. Keep notes short, or move long text to a Google Doc and link to it from the cell.

### Check the file before you convert

Keep the original Excel file in Google Drive, unchanged. Work in a copy. Scan the notes column for long cells before you convert, and compare the totals in both files afterward. If a total moves, you know where to look.

If you still run your portfolio in Excel, read [Excel for property managers on Mac](https://www.lazur.app/for/property-managers/excel) for rent rolls, lease tracking and owner statements.

> **Name your tabs plainly:** Use names like Units, Leases, Payments and Notices. A plain name makes a formula easy to read months later, when you have forgotten why it was built.

![Keys handed over at an apartment move in, the kind of change a rent roll records](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/property-managers-google-sheets/google-sheets-for-property-managers-on-mac-2-856914.jpg)

## Mac shortcuts for Google Sheets on macOS

Google's Mac shortcut page is the reference for these. Press ⌘/ in Sheets to see the common list. Use the shortcuts below for the moves you repeat most.

- ⌘/ shows the common shortcuts for Sheets on a Mac
- ⌥/ opens Tool finder, which Google used to call Search the menus
- ⌃⌥ plus a letter opens a menu, such as ⌃⌥F for File
- ⌃Space selects a whole column
- ⇧Space selects a whole row
- ⌘Z undoes your last change

Tool finder is faster than digging through menus. Press ⌥/, type Data validation, then choose it from the list. Tool finder only finds the command. You still choose the list values yourself.

## Google Sheets limits you should know

Google's file limits page says a spreadsheet can hold up to 20 million cells, and a file can be up to 100MB. A rent roll for a small portfolio stays far below both limits.

The real risk is habit. People paste years of bank exports into one file. The file grows, gets slower to open, and becomes hard to audit. Keep exports in their own files, and link only the totals you need.

The same page does not list a maximum number of tabs. Do not assume there is no limit. Test a large file before you depend on it, and keep archives in separate files.

## Gemini in Google Sheets: what needs a plan

Google's Sheets page says Gemini can write formulas, explain and fix errors, and create pivot tables and charts from a prompt. It can also fill a table with categorized or new data. Some of this needs a Workspace plan. Excel files must be converted first.

Google also highlights Sheets canvas, which builds small apps such as dashboards, heat maps and Kanban boards from a text prompt. Google calls it the newest addition. Check whether your account has it before you plan around it.

Treat Gemini formula help as a draft. Read the formula before you trust it. A formula can look right and still point at the wrong column, which is easy to miss in a tab full of numbers.

## Mistakes that lead to bad rent numbers

- Dates typed as text. They will not sort or compare correctly. Format the column as dates first, then type.
- One fact in two places. If the rent lives on both the Units tab and the Leases tab, one copy goes stale.
- Pasting exports over formulas. A paste can overwrite summary cells. Paste raw data into a data tab only.
- Long notes in one cell. Cells over 50,000 characters are removed when an Excel file converts.
- Sharing the whole file with everyone. Share with the people who need it. Lock summary tabs with Data > Protect sheets and ranges.
- Skipping version history. If a total moves and you cannot explain why, open File > Version history > See version history.

## Using Lazur in Google Sheets on your Mac

Lazur is a voice assistant for the Mac. It lives in the notch. Hold ⌥⌘ to ask about anything on your screen, and Lazur answers out loud. It listens and looks only while you hold the shortcut.

Ask where something is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click. You keep your hands on every change.

For text, hold fn and speak. Dictation produces clean, formatted text at the cursor in any app. Snippets, a personal dictionary and clipboard slots help with the phrases you repeat, such as your standard late notice opening line.

### What Lazur does not do in your sheet

Lazur does not click buttons, edit files or operate other apps for you. It is not a plugin or add-in for any app, and it has no partnerships with any app maker. Think of it as a helper that points, explains and types, not a second person in the file.

Research jobs run in Lazur's own Chrome tabs and come back with a summary and a report. Use that for checking local rules. Then confirm the rule with your attorney or your state's official site.

## Privacy before you paste tenant data

A rent roll holds tenant names, rent and deposit amounts. Read your company policy before you show that data to any AI tool. Lazur sends audio and the screenshot to AI providers so it can answer. Those are not stored, and content is never used to train AI models.

A safer habit is to point Lazur at the menu or the formula, not the tenant list. Ask the question first, then read the answer on screen. Hide sensitive columns before you hold the shortcut, if your policy requires it.

> **Check your policy first:** Your management agreement or company policy may limit what you share with any AI tool. Lazur does not replace that check, so confirm it before you hold the shortcut over tenant data.

## Start with a clean copy this week

1. Copy your current rent roll into a new file, and leave the old one untouched.
2. Build the Units and Leases tabs, then add the status dropdown.
3. Add the conditional formatting rules and two or three formulas.
4. Run the late count and compare it with your paper records.

## Where to go next

Start with one tab, one dropdown and one formula. Once the status column stays clean, add the lease tab, the reminders and the owner view. Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned but not available.

There is a free trial, and no credit card is needed to start. You can get the app from the [download page](https://www.lazur.app/download), and compare plans on the [pricing page](https://www.lazur.app/pricing). For the wider picture, see [AI assistant for property managers on Mac](https://www.lazur.app/for/property-managers).

![Man using a Mac laptop to check a spreadsheet at a desk](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/property-managers-google-sheets/google-sheets-for-property-managers-on-mac-3-514111.jpg)

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where do I set up a dropdown for rent status?”: Lazur circles the Data menu and labels it. You click Data, then Data validation, and set the list of statuses yourself. (Points at it)
- “Where is Data validation in this sheet?”: Lazur circles the Data menu in the menu bar and labels it, so you know where to look first.
- “Walk me through making a dropdown for rent status.”: Lazur guides you one click at a time and waits for each click. You make each change yourself.
- “What does this SUMIFS formula do?”: Lazur reads the formula on screen and explains each part in plain English, out loud.
- “Draft a short late rent reminder for this tenant.”: Lazur drafts the text and types it where your cursor sits. Read it and change anything before you send.
- “Dictate a lease renewal note into this cell.”: Hold fn and speak. Clean, formatted text appears at the cursor in any app, ready for you to check.
- “Look up the late fee rules for my state and summarize them.”: The research runs in Lazur's own Chrome tabs and comes back with a summary and a report to check.
- “Remind me Friday to check which deposits are still held.”: Lazur adds the reminder to Apple Reminders by voice, so the task shows up on your Mac.

## FAQ

### Is Google Sheets good for property managers on a Mac?

Yes, for a rent roll, lease tracking and simple owner summaries. It runs in your Mac browser and keeps one file shared with the people who need it. It is less suited to maintenance requests, accounting and tenant messaging, which usually need other tools.

### Which Mac shortcuts help most in Google Sheets?

Press ⌘/ to see the common shortcut list. Use ⌥/ to open Tool finder, ⌃Space to select a column and ⇧Space to select a row. Ctrl and Option plus a letter opens a menu, such as ⌃⌥F for File.

### How big can a Google Sheets file get?

Google's file limits page says a spreadsheet can hold up to 20 million cells, and a file can be up to 100MB. The page does not list a maximum number of tabs, so test a large file before you rely on it.

### Do Excel files lose data when I open them in Google Sheets?

Google says you can open and edit Excel files without making a copy. When you convert an Excel file, cells over 50,000 characters are removed. Keep the original file in Drive and check the notes column before you convert.

### Can Lazur edit my Google Sheet for me?

No. Lazur does not click buttons, edit files or operate other apps. It points at things, guides you one click at a time, explains formulas and drafts text that you place and review yourself.

### Is Lazur an add-in for Google Sheets?

No. Lazur is not a plugin or add-in for any app, and it has no partnerships with any app maker. It works with what is on your screen while you hold the shortcut.

### Does Lazur record my screen all the time?

No. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer you. They are not stored, and content is never used to train AI models.

### Where can I get Lazur for my Mac?

Use the download page. Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned but not available yet. There is a free trial, and no credit card is needed to start.

## Sources

1. [Google Workspace: Google Sheets](https://workspace.google.com/products/sheets/), Google, checked 2026-11-06
2. [Keyboard shortcuts for Google Sheets - Computer](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google Docs Editors Help, checked 2026-11-06
3. [Google Drive/Docs/Sheets file limits](https://support.google.com/drive/answer/37603), Google Help, checked 2026-11-06
4. [A Simple and Free Rent Roll Template for Landlords](https://www.stessa.com/blog/rent-roll-template/), Stessa, checked 2026-11-06