沒找到想要的模板? 提出需求 →
Property Management KPI Dashboard, the Dashboard tab

The dashboard: units let, rent in against rent due, every door as a lit window, who owes and what sits empty.

№ · 試算表 · 房產

Every building you run, and what each owner is owed.

Log units, leases, rent, repairs and bills. The dashboard draws every door as a lit window and says who has not paid and what sits empty; the Owner Statement works each owner down to net to owner.

  • Google Sheets
  • Excel .xlsx
  • 空白版 + 示例版
語言

即時下載。帳戶中有永久連結。

線上開啟,只讀

即時下載。帳戶裡有永久連結。一次買斷,永久屬於你,無需訂閱。

Owner Statement

One statement per owner.

Pick an owner and a month: rent collected, other income, your fee, repairs and costs per property, down to net to owner, with every line behind it. Prints on one page.

Property Management KPI Dashboard, the Owner Statement tab

Tenancies

Past leases count too.

Every lease, one row each, the past ones too, so vacancy days, turnover and the renewal rate are worked out, not typed. A renewal is a new row.

Property Management KPI Dashboard, the Tenancies tab

Work Orders

Every repair, against the clock.

From the call to the close: priority, first response, vendor, cost and who pays, each timed against the response targets you set.

Property Management KPI Dashboard, the Work Orders tab

Rent Ledger

Every payment in, one line each.

Rent, late fees, other income, deposits and refunds. A late payment goes against the month it pays for.

Property Management KPI Dashboard, the Rent Ledger tab

還有那些安靜的

Your doors, your bills and where to start, with a Night edition in Google Sheets.

Property Management KPI Dashboard, Units

單元

Every door with its property and market rent; tenant, rent, lease end and status are worked out for you.

Property Management KPI Dashboard, Expenses

支出

Every bill against its property, and whether the owner is charged.

Property Management KPI Dashboard, Start here

從這裡開始

每個標籤頁用一句話說明,再告訴你填寫的順序。這是你開啟的第一個標籤頁,也是你需要的唯一說明。

Property Management KPI Dashboard, Light or Night

淺色或深色

每份 Google Sheets 副本都有兩個版本:淺色版,以及適合深色螢幕的深色版。同樣的標籤頁,同樣的公式;留下你看著最順眼的那一份。Excel 檔案只有淺色版。

分工很清楚

You log the doors. It runs the numbers.

你來輸入

  • Your owners, buildings and units, once
  • Each lease and each payment as it comes
  • Every repair and every bill

自動算出

  • Who has not paid, unit by unit
  • Each owner’s statement, down to net to owner
  • Vacancy days, turnover and the renewal rate
  • Repairs timed against your targets
兩個應用程式,一個價格

Google Sheets 或 Excel,不必二選一。

下載內容兩種都有:Sheets 複製連結和原生 .xlsx。每個公式都選用在兩邊表現一致的寫法,每個版本我們都會來回測試。

Google Sheets
空白版和示例版,一鍵存入你的雲端硬碟。
Excel .xlsx
原生檔案,不是匯出的。含空白版和示例版。
購買流程

一個連結,不用費心保管檔案。

一

買一次就夠

€44,無需訂閱。訂單郵件和你的帳戶裡都有下載連結,永久有效。

二

複製到你的雲端硬碟

點一下就歸你了,存在你自己的 Google 帳戶裡,永久保留。我們無法存取你的副本,表格裡也沒有任何回傳資料的內容。

三

先從示例開始

示例版裡每個標籤頁都已經能用。隨便點、隨便改,然後開啟空白版,輸入你自己的內容。

提問之前

大家真正會問的問題

Is this the landlord spreadsheet?

No, its twin. You own the buildings: the 房東與出租房管理表. You run them, for yourself or for owners: this one, with an owner statement for each owner and repairs timed against your targets.

裡面印有年份嗎?

沒有。檔案裡任何地方都沒有印年份,所以你從哪天開始用,它就從哪天開始,明年也能繼續用。

能在 Excel 裡用嗎?

Yes. The same workbook comes as two .xlsx files, one blank and one filled with an example, checked in Excel with every formula recalculated. Excel 2010 and later, Excel for Mac and Microsoft 365; no macros, no scripts, no add-ons.

我具體會收到什麼?

A one-page PDF with your Google Sheets links, a blank copy and an example copy in a Light and a Night edition, and the two Excel files. Buying once covers your own use in both apps, forever.

Property Management KPI Dashboard

Every door, every owner, every month.

Units, leases, rent, repairs and owner statements, in Google Sheets and Excel, with a Night edition in Google Sheets, no subscription, no year baked in.

Get the dashboard · €44

還在考慮?線上開啟看看,只讀。這不是你要的表格?檢視全部表格模板,或者到 Templacity Hall 問一問。

№ · 評價

來寫第一條評價吧。

還沒有人評價過這一款。如果你已經在裝置上用了,你的評價會是下一位讀者看到的第一條。

釋出前會由真人閱讀,通常一天內完成。你的信箱只留在我們這裡,不會出現在頁面上。

即時下載。

結帳後文件立刻出現在你的帳戶裡,隨時可以重新下載。收據也會發到你的信箱。

一次購買。

沒有訂閱,沒有年費續訂,也沒有升級提示。付一次費,檔案就是你的。

簡潔、安全的結帳。

Stripe。Apple Pay。沒有垃圾郵件,沒有「合作夥伴」,不轉賣你的資訊。收據、檔案,就這麼簡單。