# Building agent bookkeeping: entries and a flat account each (free sheet)

> A practical guide to building bookkeeping: an account per flat with the tenant, 11 worked rent, collection, expense and owner entries, the trial balance, and…

Source: https://softwiro.com/blog/building-agent-accounts-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

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.

18 November 2026 7 min read

## In short

- A separate account per flat, named with the tenant: debit is owed, credit is advance.
- Rent due: debit the flats, credit rent revenue.
- Collection: debit cash, credit the flat account, in full, in part or in advance.
- Expense: debit expenses, credit cash. To the owner: debit his account, credit cash.
- The free sheet shows any unbalanced entry in red with the difference.

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](https://softwiro.com/ar/templates/building-agent-accounts) (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](https://softwiro.com/templates/journal-trial-balance); to follow rents, late tenants and lease dates only, use the [rent collection sheet](https://softwiro.com/templates/rent-collection). For entries of a small shop read [journal entry examples](https://softwiro.com/blog/journal-entry-examples.html). And when the number of buildings and tenants grows, [Accountwiro](https://softwiro.com/systems/budoor.html) records the invoice and the payment the moment they happen and shows one statement with its balance.

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## 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

[All writing](https://softwiro.com/blog.html)
