You see profit and loss per property by giving each building its own income and expense accounts on one chart, posting the building's month to those accounts, and running a statement filtered to that building for the closed month. The portfolio income statement adds every building together; the per-property statement is the same books cut to one address, and buildings are compared on it per unit, for the same period.

It is the 6th, 9:15 AM. August's income statement is on screen: net income $11,200 across six buildings, and the owner of Alder Court has emailed one line asking whether her building is doing all right. You know the answer the way you have always known it. Maple Street carries the portfolio. Alder Court has had the boiler and a vacancy. The statement in front of you says $11,200 and nothing else, and the number you are about to type into the reply is the one in your head.

This is a spoke of Property Management Reports: What Owners Actually Expect, which covers the package an owner receives and the suite behind it. This one covers the per-property statement: what it is, what a building's books need before one can be run, the procedure, how to compare two buildings, and how Scaalr reports it.

What a per-property profit and loss statement is

A per-property profit and loss statement is an income statement for one building: the income the building earned in a period, less the expenses that belong to it, ending in the building's net. Landlords call the same report a rental property P&L or a rental property income statement, and an owner statement is usually the same report cut to one owner's buildings. The portfolio income statement is the sum of every building's version plus the overhead that belongs to none of them, which is why it can say the business made money without saying which building did.

The statement can exist only if the books carry a property dimension: a way of saying, for each posted line, which building it belongs to. One chart of accounts for the whole portfolio carries that dimension when a building's own accounts are linked to it, rent income for Alder Court and repairs for Alder Court, while the accounts that run across the business stay at portfolio level. How to build the chart that way without cloning it per building is covered in Chart of Accounts for Property Management: How to Build One. Without the dimension, a per-building statement is a spreadsheet someone re-sorts every month, the same problem How to Prepare a Property Owner Statement: Step by Step solves for one owner at a time.

What a building's statement needs to carry

The table below lists the lines a per-property statement carries, and whether each one is the building's own line or a portfolio line that stays where it is.

Line Whose account it is Why it differs by building
Rent incomeThe building's ownThe rent roll differs, and a vacancy is one building's vacancy
Other income: parking, laundry, late feesThe building's ownOnly some buildings have it
Repairs and maintenanceThe building's ownThe boiler belongs to one address
Utilities the owner paysThe building's ownMetered per building
InsuranceThe building's own, or an allocated shareA blanket policy is split on a written basis
Property taxThe building's ownAssessed per parcel
Management feeThe building's ownA percentage of the building's rent
Office, software, staffPortfolio levelBelongs to the business, not to a building

The last row keeps the statement honest. Overhead pushed down to buildings by a formula makes every building look worse and none of them look different, and an owner's statement should carry only what that owner pays for. Leave it at portfolio level, where the portfolio income statement shows it.

How to set up profit and loss per property, step by step

The setup is done once per building; steps 4 through 8 repeat every month.

  1. Give each building a property code. Short, unique, and typed the same way everywhere it appears, because the code is what ties an account to a building.
  2. Create the building's own accounts and link them by that code. Rent income, other income, repairs and maintenance, utilities, insurance, property tax, and the management fee, each carrying the building's code. The portfolio's accounts stay as they are for everything else.
  3. Link the building to its owner in the register. A per-property statement is run for an owner, so a building you own yourself is linked to your own entity.
  4. Post the month to the building's accounts. Bills and manual entries can go straight to the linked accounts. Rent charges, invoices, and card payments post to the portfolio's system accounts on their own, so the building's rent is moved to its own rent income account with an allocation entry dated inside the month.
  5. Allocate shared costs on a written basis. A blanket insurance premium or a landscaper who does three buildings is split by units, by square footage, or equally, and the basis stays the same every month so the buildings stay comparable.
  6. Close the month. Reconcile each bank account and lock the period, so the statement cannot change after it is read or sent; the reconciliation is in Bank Reconciliation for Property Managers: Step by Step and the lock in Month-End Close Checklist for Property Managers.
  7. Run the statement for one building, for the closed month. Income by account, expenses by account, net. Read it top to bottom before it goes anywhere.
  8. Run it again for each building, for the same period, and compare. Per unit, not per building, so a twelve-unit building and a four-unit building are read on the same scale.

Step 4 is the one that gets skipped, and it is the one that decides whether the statement has any rent on it.

How to compare buildings: same period, per unit

Two buildings' statements are comparable only when they cover the same period and are read per unit. Net for the building divided by its units gives net per unit per month, and that is the number that answers which building makes money: a $2,100 net on twelve units is $175 a unit, and a $1,400 net on four units is $350 a unit, so the smaller building is the better one, and the portfolio total could never have said so.

Read the net before financing. The statement's net is income less operating expenses, which investors call net operating income, and it leaves out the mortgage principal and the capital purchases, so two buildings with different loans are still read on the same footing; where the money went after that is the question the cash flow statement answers, in Cash Flow Statement for Property Managers, Explained. Then read the lines that made the difference: the repairs line explains a bad quarter, and the rent line explains a bad year. Compare each building against its own prior period next, because the question after "which building makes money" is "and is that changing".

How Scaalr reports profit and loss per property

In Scaalr the property dimension is a property code: a short code on the property record, set when the property is created or edited on its page, and the same code on any account on the chart. The Add Account form carries a Property Code field with a note to leave it blank if the account is not property-specific; an account left blank belongs to the portfolio, and the chart of accounts lists each account's code beside its number, so which lines belong to which building is visible at a glance. The code is typed on both records and matched exactly, so a building's accounts carry its code character for character.

The per-property statement is the owner statement in the Reports area, run for one property at a time. Pick the owner, and their linked properties load as a checklist; tick one building, set the date range, which defaults to the current month, and view it, download the branded PDF, or print it. The statement reads every posted entry dated inside the range on accounts whose code matches the building, groups income and other income by account on one side and expenses and other expenses on the other, each with its GL code and period total, and closes with the net, labeled owner profit. On screen, the transactions behind every line are listed, so a question about the repairs line is answered from the entry. Tick two buildings and the statement totals them together without a subtotal per building, which is why the per-building read is one building at a time.

Two boundaries decide what it shows. The income statement runs for the whole ledger, one section per currency, with no property filter: the portfolio's profit stays the portfolio's, and a building's comes from the building's statement. And the automatic postings from rent charges, invoices, and card payments are addressed to the portfolio's system accounts by account number, so a building's rent reaches its statement once it has been moved to the building's own rent income account by an allocation entry; a bill that landed on the wrong building's account moves between the two with the inter-property reallocation template.

The general ledger report runs for any one account, so a building's repairs account can be read line by line for the year. On an account that encrypts its ledger, the statement locks its totals until the secret is entered and blocks the export rather than produce partial figures. The chart of accounts, the owner register, the journal, and the report suite are on every plan, including Starter.

Back to the 6th, 9:15 AM. Alder Court's August statement, run for that building alone: rent $6,800 with one unit vacant, repairs $4,900 for the boiler, the other lines in their usual range, net minus $850 on eight units. The reply to the owner is that number and the two lines that explain it, with their dates. The portfolio's $11,200 turns out to be five buildings carrying one, and the one has a reason.

Key questions

Should each rental property have its own profit and loss statement?

Yes, one statement per building, from one set of books. Each building gets its own statement so that a vacancy, a boiler, or a rent increase shows up at the address it belongs to, and the portfolio income statement stays the sum of them. What each building does not get is its own chart of accounts: one chart with a property dimension serves every building, and cloning the chart per property is the mistake the chart of accounts guide warns against.

Can I run an income statement for just one property?

Not as an income statement, no. In Scaalr the income statement runs for the whole ledger, one section per currency, and has no property filter. The one-property view is the owner statement run for that building alone: it reads the same posted entries through the accounts linked to the building and returns income by account, expenses by account, and the net for that building, so it is the building's profit and loss and its owner's statement at once.

Why is the rent missing from a property's statement?

Because it posted to the portfolio's rent income account, not the building's. Rent charges post automatically to the system revenue account by account number, and a per-property statement reads only the accounts linked to the building, so until the month's rent is moved to the building's own rent income account by an allocation entry, the statement shows the building's expenses with no income against them. That entry is step 4 of the procedure above, dated inside the month, before the lock.

How do I allocate shared expenses across properties?

On one written basis, applied the same way every month. Split a shared cost equally, by unit count, or by square footage, record which basis you used, and post each building's share to that building's expense account in one journal entry from the portfolio account to the linked accounts. Keep true overhead, your office, your software, and your staff, at portfolio level, where it belongs to the business rather than to any building.

Do I need a separate bank account for each rental property?

Not to see profit and loss per property. The statement comes from the property dimension on the accounts, not from where the cash sits, so one operating account can serve a portfolio whose buildings each report on their own. Separate bank accounts are a different decision: some managers keep one per owner or per entity for trust and liability reasons, and some markets require deposits to be held apart, which is a rule to check for your market rather than a bookkeeping choice.

How often should I run profit and loss per property?

Monthly, for the closed month, in the same pass as the owner statements, and year to date each quarter. A monthly read catches the repairs line that doubled and the unit that has been vacant for two months while there is still something to do about them; the quarterly read shows whether a building is drifting. A building read once a year is a tax document, not a management report.

Which Scaalr plan includes profit and loss per property?

All of them, including Starter. Property codes on the chart of accounts, the owner register, the journal, and the report suite with the owner statement are part of every plan; Starter is free for the first 5 units, then $0.99 a unit a month, and Growth is $99 a month for the first 50 units, then $1.49 per additional unit. Ledger encryption, which locks the statement's totals until the secret is entered, is Growth and up.

Property Management Reports: What Owners Actually Expect All articles