English is the source language for this site. Sister sites in Spanish, French, German and Brazilian Portuguese were written for native readers, not as word-for-word translations; they still need a native review before launch.

What's inside

Four editions share the same file format, and Team / Office includes all four for up to 10 people at one firm, with clean files. Acquisition covers the pro forma and deal analyzer. Portfolio covers bookkeeping and an annual budget for up to 20 properties. Complete includes both and adds actual vs forecast, the full CapEx planner, bank import, and the AI pack. Investor adds closed-end and open-end fund waterfalls and one-off deal waterfalls, and includes the other three editions; it runs in Excel 2016 or newer and LibreOffice, not Google Sheets. Tab names stay in English so the formulas keep working when you switch the language of every label.

01

Guided Inputs

Numbered questions for a building you are buying or already own: price, size, year built, a unit-type table (square feet, count, rent, vacancy, rent growth), other income, and expenses as a fixed amount, a percent of income, per unit or per square foot.

Guided Inputs
02

10-year pro forma and returns

NOI, cap rate, cash-on-cash, DSCR from the annual debt service you enter, break-even occupancy, unlevered and levered IRR, and equity multiple. A waterfall shows where every dollar of rent goes.

10-year pro forma and returns
03Complete

123-component CapEx planner

Tick what the building has, set age or condition, override any cost with a bid, and get a 10-year schedule by system plus a recommended reserve per unit and room for value-add projects.

123-component CapEx planner
04

Actual vs forecast

Monthly actuals from the ledger against the Year-1 budget, YTD variance, a full-year reforecast, an 'if the trend continues' run-rate, and the effect of overruns on NOI, cash flow and returns.

Actual vs forecast
05Complete

Bank CSV import

Paste an export as-is. The workbook maps columns, applies 138 editable rules, skips transfers and personal spending, flags duplicates, and can lock accepted rows into the ledger as values. It does not connect to a bank.

Bank CSV import
06

Books for any size building

Any size building; Portfolio and Complete track up to 20 properties per file (make another copy for more). Long-term or short-term. A dashboard, mileage log, and — for US filers — Schedule E lines 3–21 totaled per property. Outside the US, ignore that tab.

Books for any size building
07

Five languages, your currency symbol

English, Spanish, French, German or Portuguese, plus a date format. The Translations tab is editable. Currency symbols display in Excel; Google Sheets may show plain numbers.

Five languages, your currency symbol
08

AI Assistant Pack

Eighteen copy-and-paste prompts for Copilot, Gemini, ChatGPT and Claude, including a walkthrough of every Inputs question and a helper that drafts import rules from your file. You still check every row.