Softwiro
Free Excel template

Building agent bookkeeping: one account per flat, with rent and collection entries (free sheet)

11 worked entries for a ten-flat building: rent due, full, partial and advance payments, expenses, owner transfers and the trial balance.

7 min read

A building agent needs to know at any moment who has paid and who has not, how much cash is on hand, how much was spent on the building, and how much the owner is due. The easiest way is double-entry bookkeeping with a separate account for every flat. This article explains it with 11 worked entries for a ten-flat building, shows the trial balance they end in, and how to produce a statement for any flat or for the owner. You can apply all of it in the free building agent accounts sheet (the sheet is in Arabic).

A suggested chart of accounts

AccountIts job
CashThe cash you hold: up with collections, down with expenses and transfers.
One account per flat (named with the tenant)What the tenant owes. A debit balance is owed; a credit balance was paid in advance.
Rent revenueWhere the monthly rent for all flats is recognised.
Building expensesMaintenance, cleaning, electricity and so on.
Owner accountWhat sits between you and the owner: what he received and what is left.

The rule in one line

Every entry has two equal sides: total debit = total credit. Assets (cash and the flat accounts) go up on the debit side and down on the credit side, revenue goes up on the credit side, an expense goes up on the debit side. If the two sides differ, the entry is wrong and should not be posted.

The entries, one by one

The numbers are illustrative. Opening balances: cash 5,000 debit, flat 3 owes 3,000 from the previous month, and the owner has 8,000 in credit.

Entry 1: Rent due for October, all flats

AccountDebitCredit
Flat 1 (Ahmed)3,000
Flat 2 (Maha)3,500
… the other eight flats26,500
Rent revenue33,000

The rent is owed before it is paid: flat accounts (assets) go up, and so does revenue.

Entry 2: Flat 1 pays in full, in cash

AccountDebitCredit
Cash3,000
Flat 1 (Ahmed)3,000

Cash goes up, the flat's debt goes down.

Entry 3: Flat 2 pays in full

AccountDebitCredit
Cash3,500
Flat 2 (Maha)3,500

The same entry with that flat's amount.

Entry 4: Flat 3 pays this month and leaves the old balance

AccountDebitCredit
Cash3,000
Flat 3 (Khaled)3,000

It owed 3,000 before + 3,000 October rent − 3,000 paid = 3,000 still owed on its statement.

Entry 5: Flat 5 pays part

AccountDebitCredit
Cash2,000
Flat 5 (Tarek)2,000

A partial payment is an ordinary entry; the rest (1,500) stays as a debit on the flat.

Entry 6: Flat 9 pays two months in advance

AccountDebitCredit
Cash7,000
Flat 9 (Amr)7,000

October is only 3,500, so the flat's account ends 3,500 in credit: an advance that covers November.

Entry 7: Elevator maintenance

AccountDebitCredit
Building expenses800
Cash800

The expense goes up as a debit; cash goes down.

Entry 8: Cleaning and staircase electricity

AccountDebitCredit
Building expenses300
Cash300

Another expense. If you typed 250 on the credit side instead of 300, the sheet warns that the entry is unbalanced by 50.

Entry 9: Transfer to the owner

AccountDebitCredit
Owner account12,000
Cash12,000

What you hand the owner is debited to his account: it had 8,000 in credit at the start, so it ends with 4,000 in debit.

Entry 10: Rent due for November

AccountDebitCredit
The ten flats, each at its rent33,000
Rent revenue33,000

Copied from the "Rent entries" sheet in seconds. Flat 9 goes back to zero by using the advance.

Entry 11: Flat 7 pays the late October rent

AccountDebitCredit
Cash2,500
Flat 7 (Hesham)2,500

The same collection entry, dated in the next month.

The trial balance after October (entries 1 to 9)

AccountDebit balanceCredit balance
Cash10,400
Flats 3, 4, 5, 6, 7, 8 and 10 (owed by their tenants)21,000
Flat 9 (paid in advance)3,500
Rent revenue33,000
Building expenses1,100
Owner account4,000
Total36,50036,500

The trial balance balances: total debit = total credit = 36,500. If the two figures differ, look for an unbalanced entry or a line with a wrong account code.

A statement for a flat, and for the owner

A flat's statement is its movements in date order with the balance after each one, and the tenant's name on top: hand it to anyone who asks "how much do I owe?". The owner's statement is the owner account: what he took and what remains for or against him. In the sheet you choose the flat or account code in "Statement of account" and its movements and balance appear.

What the sheet does for you

  • The monthly rent entry: the "Rent entries" sheet prepares the entry for all flats (each flat debited, revenue credited with the total) with a number and a date, ready to paste into the journal.
  • An unbalanced-entry warning: any entry with a difference turns red with the difference, and the count of unbalanced entries shows at the top of the journal.
  • One account per flat: the tenant's name is in the account name, so you search by code or by name.
  • The trial balance shows what each flat owes and its status: owes a balance, settled, or paid in advance.

For general entries in any business use the journal and trial balance sheet; to follow rents, late tenants and lease dates only, use the rent collection sheet. For entries of a small shop read journal entry examples. And when the number of buildings and tenants grows, Accountwiro records the invoice and the payment the moment they happen and shows one statement with its balance.

Questions this raises

Do I need an account for every flat?

Yes. It is what lets you see what each tenant owes and give them a statement. In the sheet each flat's account is created automatically from the "Flats and tenants" sheet.

How do I record the monthly rent for all flats quickly?

From the "Rent entries" sheet: type the first day of the month and one balanced entry is prepared for every rented flat; paste it as values into the journal.

What does a credit balance on a flat mean?

The tenant has paid more than they owed so far, that is, paid in advance, and the balance is taken off the coming rents.

What if I enter an unbalanced entry?

The sheet shows "unbalanced entry" in red with the difference and the count at the top of the journal, so you fix it before relying on the trial balance.

How many flats does it hold?

40 flats and up to 1,500 journal lines; the statement shows the first 200 movements of an account.

Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project