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
| Account | Its job |
|---|---|
| Cash | The 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 revenue | Where the monthly rent for all flats is recognised. |
| Building expenses | Maintenance, cleaning, electricity and so on. |
| Owner account | What 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
| Account | Debit | Credit |
|---|---|---|
| Flat 1 (Ahmed) | 3,000 | |
| Flat 2 (Maha) | 3,500 | |
| … the other eight flats | 26,500 | |
| Rent revenue | 33,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
| Account | Debit | Credit |
|---|---|---|
| Cash | 3,000 | |
| Flat 1 (Ahmed) | 3,000 |
Cash goes up, the flat's debt goes down.
Entry 3: Flat 2 pays in full
| Account | Debit | Credit |
|---|---|---|
| Cash | 3,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
| Account | Debit | Credit |
|---|---|---|
| Cash | 3,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
| Account | Debit | Credit |
|---|---|---|
| Cash | 2,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
| Account | Debit | Credit |
|---|---|---|
| Cash | 7,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
| Account | Debit | Credit |
|---|---|---|
| Building expenses | 800 | |
| Cash | 800 |
The expense goes up as a debit; cash goes down.
Entry 8: Cleaning and staircase electricity
| Account | Debit | Credit |
|---|---|---|
| Building expenses | 300 | |
| Cash | 300 |
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
| Account | Debit | Credit |
|---|---|---|
| Owner account | 12,000 | |
| Cash | 12,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
| Account | Debit | Credit |
|---|---|---|
| The ten flats, each at its rent | 33,000 | |
| Rent revenue | 33,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
| Account | Debit | Credit |
|---|---|---|
| Cash | 2,500 | |
| Flat 7 (Hesham) | 2,500 |
The same collection entry, dated in the next month.
The trial balance after October (entries 1 to 9)
| Account | Debit balance | Credit balance |
|---|---|---|
| Cash | 10,400 | |
| Flats 3, 4, 5, 6, 7, 8 and 10 (owed by their tenants) | 21,000 | |
| Flat 9 (paid in advance) | 3,500 | |
| Rent revenue | 33,000 | |
| Building expenses | 1,100 | |
| Owner account | 4,000 | |
| Total | 36,500 | 36,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.