What Is a Rent Ledger? Meaning, Example and Use

A rent ledger is the single most useful record a landlord can keep, yet many Bangladeshi landlords still rely on memory, a diary with scribbled notes, or a stack of receipt counterfoils. That works until a tenant says "I paid March in cash, don't you remember?", or a probashi owner asks a relative how much rent was collected last year, or a tax adviser asks for annual rental income broken down by unit. Suddenly nobody is quite sure.

So, what is a rent ledger? This glossary article explains the meaning of a rent ledger in simple English, what columns it should contain, how to read balances, how it differs from a rent roll and a receipt book, and how to keep one on paper, in Excel or in software. You will also find a fully worked example with numbers, and practical tips for landlords of flats, shops and markets in Bangladesh.

What Is a Rent Ledger? A Simple Definition

A rent ledger is a running, date-wise record of everything a tenant owes and everything the tenant pays over the course of a tenancy. Each entry shows a charge (such as monthly rent, service charge or an electricity bill) or a payment (cash, bKash, Nagad, bank transfer or advance adjustment), and the ledger keeps a running balance showing whether the tenant currently owes money, is fully paid, or has paid in advance.

In accounting terms, a rent ledger is a subsidiary ledger for one tenant (or one unit). In everyday Bangla, landlords sometimes call it the bhara khata or hisab khata. The idea is the same: one page per tenant, where the whole money story of that tenancy can be read from top to bottom.

In one line: A rent ledger answers the question "What has this tenant been charged, what have they paid, and what is the balance today?"

Why a Rent Ledger Matters for Landlords in Bangladesh

• Clear dues: You know exactly who owes what, including partial payments and old dues.
• Fewer disputes: When a tenant disagrees, you can show dated entries and receipt numbers.
• Advance tracking: Advance rent adjusted over months is easy to forget; a ledger records each adjustment.
• Security deposit clarity: At move-out, you can see what is owed before returning the deposit (jamanat).
• Tax and accounts: Annual rental income per unit is simply the total of rent charged or received in the ledger, which helps when your adviser prepares your return.
• Handover: If a caretaker, manager or family member takes over rent collection, the ledger gives them the full picture.
• Remote oversight: Probashi owners can review ledgers sent by their representative every month.

Key Columns in a Rent Ledger

At the top of each ledger page, record the tenant's name, unit (for example "Flat 3B" or "Shop 12"), move-in date, monthly rent, service charge, advance and security deposit amounts, and phone number.

How the Running Balance Works

The balance is calculated line by line:

New balance = Previous balance + Charge - Payment

• If the balance is positive, the tenant owes that amount (rent due, or baki).
• If it is zero, the tenant is fully paid up.
• If it is negative, the tenant has paid more than charged so far, which means they have credit or advance with you.

Some landlords prefer to show "Due" and "Advance" in separate columns instead of using negative numbers. Either is fine, as long as you are consistent.

Worked Example: A Three-Month Rent Ledger

For example (illustrative): Mr Karim rents Flat 4A. Monthly rent is Tk 20,000 and service charge is Tk 2,000. His electricity is billed through a sub-meter. He paid Tk 40,000 advance at move-in, to be adjusted at Tk 4,000 per month over 10 months.

Let us check February: the balance at the start of February was Tk 0. Charges were Tk 22,000 + Tk 2,350 = Tk 24,350. The advance adjustment of Tk 4,000 reduced it to Tk 20,350. Mr Karim paid Tk 15,000, so Tk 20,350 - Tk 15,000 = Tk 5,350 was carried into March. In March, Tk 5,350 + Tk 22,000 + Tk 2,100 - Tk 4,000 = Tk 25,450, which he paid in full. The remaining advance after three months is Tk 40,000 - (3 x Tk 4,000) = Tk 28,000.

Without a ledger, the Tk 5,350 carried over from February could easily be forgotten, or argued about.

Rent Ledger vs Rent Roll vs Receipt Book

These three records are related but not the same.

A receipt proves one payment; the ledger connects all receipts into a story; the rent roll summarises every unit on one page. Read more in our glossary entry on what a rent roll is.

What Should Go Into a Rent Ledger?

Charges (debits)

• Monthly rent.
• Service charge or maintenance charge.
• Electricity through a sub-meter, water, gas, if billed by the landlord.
• Agreed one-off charges, such as a repair the tenant is responsible for under the agreement.
• Late fees, only if the agreement provides for them.

Payments and credits

• Cash, bKash, Nagad, Rocket, bank transfer or cheque payments, with references.
• Advance adjustments.
• Discounts or waivers you agree to, recorded clearly so nobody is confused later.
• Tax deducted at source by corporate tenants, recorded with the certificate reference so gross rent and net received both show.

What should be kept separate

A refundable security deposit is not rent. Record it in the ledger header or a separate deposit record, not as a payment against monthly rent, unless and until it is actually used to settle dues at move-out.

How to Keep a Rent Ledger: Paper, Excel or Software

Paper ledger (khata)

A bound register with one or two pages per tenant is simple and familiar. It works for a few units, but it is easy to lose, hard to total, and cannot send reminders. If you use paper, write in pen, never tear out pages, and cross-reference receipt numbers.

Excel or Google Sheets

A spreadsheet with one tab per tenant and a formula for the running balance is a big step up. You can total income by month and unit. The risks are accidental formula errors, multiple versions on different computers, and no automatic link to receipts or reminders. Our comparison of an Excel rent tracker vs software explains the trade-offs.

Rent management software

Software builds the ledger automatically: invoices become charges, payments become credits, and balances update instantly. It usually adds receipts, due lists and reports. This saves the most time when you have many units or someone else collects rent for you. See our article on the benefits of a digital rent ledger.

Rent Ledgers for Shops, Markets and Commercial Units

Commercial ledgers follow the same logic but often have more types of entries. A shop tenant in a market may be charged monthly rent, service charge, a share of common electricity, a separate sub-meter bill, and sometimes signboard or storage fees. Corporate tenants may deduct withholding tax and, in some cases, VAT before paying.

• Use separate description lines for each type of charge, so the tenant can see exactly what they are paying for.
• Record position money (salami), if any, in a separate record according to how it was agreed, rather than mixing it with monthly rent.
• For tax deducted at source, record the gross rent as the charge, the net cash as a payment, and the tax deducted as a separate credit with the certificate number.
• For markets with many small shops, a daily or weekly collection sheet can feed into each shop's ledger at the end of the day.

Keeping commercial ledgers this way makes rent reviews, renewals and disputes far easier, because every figure has a clear history behind it.

Step-by-Step: Starting a Rent Ledger Today

1. List all units and current tenants.
2. For each tenant, write the header: name, unit, rent, service charge, move-in date, advance and deposit.
3. Enter an opening balance for each tenant as of today, based on your best records and confirmed with the tenant if possible.
4. From now on, add a charge line on the rent due date each month.
5. Add a payment line every time money arrives, the same day.
6. Issue a receipt for every payment and write the receipt number in the ledger.
7. At month-end, review all balances and follow up on dues politely.
8. Once a year, total rent charged and received per unit for your accounts.

Reading a Ledger: Warning Signs to Watch

• Balances that grow every month suggest a tenant is paying less than the monthly charge; act early.
• Round-number partial payments month after month can mean the tenant is struggling; a conversation may help.
• Payments without references make disputes hard to resolve; always record the method and ID.
• Frequent waivers may mean your rent is above market or the unit has issues to fix.
• Advance adjustments missing means you may be over-charging the tenant, which harms trust.

Common Mistakes with Rent Ledgers

• Recording only payments, not charges, so the balance cannot be calculated.
• Mixing the security deposit with rent payments.
• Forgetting to record advance adjustments each month.
• Updating the ledger once a month from memory instead of the same day.
• Using one combined ledger for all tenants instead of one per tenant.
• Overwriting or deleting entries instead of adding a correction line.
• Not sharing a statement with tenants who ask for it.

Tip: Never erase a mistake. Add a new line such as "Correction: February electricity over-charged" with a credit. This keeps a trustworthy audit trail.

Sharing a Ledger Statement with Tenants

Tenants appreciate transparency. When there is any confusion about dues, send a short statement: the last three to six months of charges, payments and the current balance. This often resolves disagreements immediately and shows that you keep careful records. At move-out, a final statement shows how the security deposit is being settled, which is also good practice for building trust and reputation.

For wider bookkeeping beyond the tenant ledger, including building expenses and profit, see our guide on rental property accounting basics.

Final Thoughts

A rent ledger is simply a running record of charges, payments and balance for each tenant, but it transforms how you manage rent. It prevents forgotten dues, settles disputes with facts, keeps advance and deposit clear, and makes tax time easier. Whether you use a paper khata, a spreadsheet or software, the key habits are the same: one ledger per tenant, entries on the same day, a reference for every payment, and corrections instead of erasures.

Bariwala ERP maintains the ledger automatically as it generates monthly invoices, records rent payments and receipts, tracks advance adjustments and shows a live due list, which is helpful when you manage many flats or shops. Whatever method you choose, start today with an accurate opening balance.