For businesses that own or manage rental properties, collecting rent is only one part of managing rental income. Finance teams must also ensure that amounts recorded in the rent roll agree with the accounting records and actual payments reflected in bank statements.
A property may have several tenants, different rental agreements and varying payment dates. Some tenants pay in advance, others make partial payments, while some delay payments or settle their rent in instalments. Additional charges, such as service charges and utility recoveries, can also make it difficult to establish how much rental income has actually been received.
For example, a property management company may have a rent roll showing that tenants were expected to pay GH₵250,000 during September. However, its bank statement reflects rental-related deposits of only GH₵215,000. The difference could represent unpaid rent, partial payments, advance payments or transactions that have not been properly identified.
Without a proper reconciliation process, management may struggle to determine whether the difference represents outstanding rent, an accounting error or an actual cash collection problem.
Reconciling the rent roll with the general ledger and bank statements helps property businesses identify discrepancies, monitor outstanding payments and maintain reliable financial records.
Understanding the Rent Roll, General Ledger and Bank Statement
Before carrying out a reconciliation, finance teams must understand the purpose of the three records involved.
The Rent Roll
A rent roll is a schedule showing the rental income expected from a property’s tenants. It provides an overview of rental arrangements and the amounts due over a specified period.
A typical rent roll contains:
- Tenant names and property or unit references.
- Monthly or periodic rental amounts.
- Lease commencement and expiry dates.
- Rent due dates and payment frequency.
- Amounts billed or due.
- Payments received.
- Outstanding rental balances.
For property managers, this schedule helps monitor rental obligations and identify tenants who have not paid.
However, the rent roll does not automatically confirm that rental income has been received. It shows what tenants are expected to pay and, depending on how it is maintained, what has been collected.
This distinction is important because a property may generate significant expected rental income while experiencing poor cash collections.
The General Ledger
The general ledger contains the accounting entries used to record a business’s financial transactions.
For rental property businesses, relevant accounts may include rental income, tenant receivables, bank accounts, refundable security deposits and rental income received in advance.
When rent becomes due, the appropriate income and receivable entries should be recorded in accordance with the applicable accounting requirements. When a tenant pays, the payment should be recorded against the relevant tenant balance.
The general ledger therefore provides the accounting records against which the rent roll and bank transactions can be checked.
The Bank Statement
A bank statement provides an independent record of money received and paid through the business’s bank account.
It helps confirm whether tenants have transferred their rental payments. However, not every deposit represents rental income. Some may relate to refundable security deposits, service charges, loans or other receipts.
Finance teams must identify and classify deposits correctly rather than treating every bank credit as rental income.
Why Reconciling Rental Income Matters
Reconciliation involves comparing the information in the rent roll, general ledger and bank statements to identify differences and establish whether rental transactions have been properly recorded.
It is an important financial control for property owners, property managers and real estate investment companies.
Identifying Unpaid Rent and Arrears
Comparing expected rental payments with actual bank receipts helps finance teams identify tenants who have not paid, made partial payments or paid after the due date.
For example, if a tenant owes GH₵12,000 but has paid only GH₵8,000, the remaining GH₵4,000 should be reflected as an outstanding balance.
Without regular reconciliation, unpaid amounts may go unnoticed, making it difficult for management to follow up with tenants and take appropriate collection action.
Improving the Accuracy of Financial Reports
Rental income can be misstated when transactions are duplicated, omitted or recorded in the wrong accounting period.
For example, a tenant may pay GH₵36,000 in advance to cover six months of rent. The entire amount should not automatically be recognised as income in the month it is received.
Under IFRS 16, Leases, a lessor generally recognises operating lease payments as income on a straight-line basis over the lease term, unless another systematic basis is more representative of the pattern in which the benefit from the use of the underlying asset is diminished.
Reconciliation helps identify situations where cash received has been incorrectly treated as rental income.
Improving Cash Flow Visibility
Rental income is often used to meet property-related expenses, fund maintenance and service loan repayments.
However, expected rental income does not necessarily translate into cash available to the business. If management relies only on the rent roll, it may assume sufficient money will be available even when several tenants have not paid.
Comparing expected rent with actual bank receipts provides a clearer picture of cash collections. It also helps management identify recurring payment delays and assess whether additional collection measures are needed.
Strengthening Audit Readiness
Rental income is an important source of revenue for many property businesses. Inaccurate records can affect reported income, receivables and cash balances.
A documented reconciliation provides evidence of how rental transactions were checked and how identified differences were resolved.
It also helps auditors trace rental income from tenancy agreements and tenant schedules to accounting records and bank transactions. This can reduce the time spent investigating unexplained differences during an audit.
Common Reasons Rental Income Records Do Not Agree
Differences between the rent roll, general ledger and bank statements can arise from normal payment arrangements or weaknesses in financial controls. Understanding the causes helps finance teams investigate discrepancies more effectively.
1. Late or Partial Rental Payments
Tenants may not always pay the full rental amount by the agreed due date.
For example, a tenant owing GH₵10,000 may transfer GH₵6,000 and promise to settle the remaining GH₵4,000 later.
The bank statement will reflect the GH₵6,000 received, while the rent roll should continue to show the outstanding balance.
Finance teams must match the payment to the correct tenant and ensure that the remaining amount is properly recorded as a receivable. If the full rental amount is mistakenly recorded as received, the business may underestimate its outstanding tenant balances.
2. Payments Received in Advance
Some tenants pay several months’ rent before the rental period begins.
For example, a tenant may pay GH₵36,000 in December to cover six months of rent from January to June.
Although the bank statement will show the full amount received in December, the accounting records must distinguish between cash received and rental income earned over the relevant period.
The portion relating to future rental periods should be accounted for appropriately as income received in advance until it is earned.
Failure to make this distinction can result in rental income being overstated in one reporting period and understated in another.
3. Unidentified or Incorrectly Allocated Deposits
A bank statement may contain deposits without sufficient payment descriptions to identify the tenant or property concerned.
This is common where tenants use different bank accounts, mobile money channels or third-party payment arrangements.
Payments may also be allocated to the wrong tenant because of similar names or incorrect property references.
These errors can result in inaccurate tenant balances, unnecessary payment reminders and disputes.
Businesses should encourage tenants to include their names, property references or invoice numbers when making payments. Unidentified deposits should be investigated and monitored until their source is confirmed.
4. Security Deposits Recorded as Rental Income
Tenants may pay refundable security deposits when entering into rental agreements.
These payments appear in the bank statement as cash received, but they should not automatically be recognised as rental income. Where the business has an obligation to refund the deposit, it is generally recorded as a liability.
If security deposits are included in rental income, reported revenue will be overstated and tenant deposit liabilities understated.
Finance teams should maintain separate records for rental payments and refundable deposits.
5. Bank Charges and Payment Deductions
Some rental payments may be received net of bank or payment processing charges.
For example, a tenant may pay GH₵5,000, but the bank statement reflects GH₵4,980 after a GH₵20 processing charge.
Recording only the net amount as rental income may leave part of the tenant’s balance outstanding.
The appropriate treatment should recognise the full rental payment and separately account for the processing charge. This ensures that the tenant’s account is properly settled and the expense is not overlooked.
A Practical Approach to Reconciling Rental Income
A consistent reconciliation process helps property businesses establish whether expected rental income has been collected and accurately recorded.
The following steps provide a practical framework.
Step 1: Obtain an Updated Rent Roll
Start by obtaining the rent roll for the reporting period.
The schedule should contain details of active tenants, rental amounts, payment dates, lease periods and outstanding balances.
Finance teams should confirm that recent lease changes, new tenants, expired agreements and approved rental adjustments have been included.
An outdated rent roll can lead to incorrect expectations about how much rental income should have been received.
Step 2: Extract Rental Transactions from the General Ledger
Generate a report showing rental income, tenant receivables, advance rental payments and relevant deposit accounts.
The report should include:
- Transaction dates.
- Tenant or property references.
- Transaction descriptions.
- Invoice or receipt numbers.
- Amounts recorded.
- Accounting periods.
- Outstanding balances.
This provides the accounting position against which the rent roll and bank statement can be compared.
Step 3: Obtain the Relevant Bank Statements
Collect bank statements covering the reporting period.
Where rental payments are received through several bank accounts, all relevant statements should be included.
Identify deposits relating to rental payments and distinguish them from security deposits, service charges and other receipts.
Payment references, transaction dates and amounts should be used to match deposits to individual tenant accounts.
Step 4: Match Transactions Across the Three Records
Compare the rent roll, general ledger and bank statement to establish whether the transactions agree.
Consider a property with three tenants:
- Tenant A: Monthly rent is GH₵5,000. The bank statement confirms payment of GH₵5,000. There is no outstanding balance.
- Tenant B: Monthly rent is GH₵7,000. The bank statement confirms payment of GH₵4,000. The remaining GH₵3,000 is outstanding.
- Tenant C: Monthly rent is GH₵8,000. The bank statement confirms payment of GH₵8,000. There is no outstanding balance.
The rent roll indicates that GH₵20,000 is due, but the bank statement confirms receipts of only GH₵17,000.
The finance team should confirm that the GH₵17,000 received has been correctly recorded in the general ledger and that the remaining GH₵3,000 is reflected as a tenant receivable.
This exercise also helps management identify which tenant requires payment follow-up rather than treating the entire difference as an unexplained accounting error.
Step 5: Investigate and Resolve Differences
Once discrepancies have been identified, finance teams should investigate their causes.
Supporting documents may include:
- Signed tenancy agreements.
- Rental invoices and payment schedules.
- Bank statements and payment confirmations.
- Official receipts.
- Tenant account statements.
- Records of security deposits and advance payments.
- Approved rental adjustments and credit notes.
For example, if the rent roll shows GH₵8,000 due but the bank statement reflects GH₵7,500, the finance team should establish whether the tenant made a partial payment, whether a deduction was authorised or whether the remaining payment was received through another channel.
Necessary accounting adjustments should be reviewed and approved before posting.
Step 6: Review and Approve the Reconciliation
After investigating the differences, prepare a reconciliation schedule showing amounts due, amounts received, amounts recorded in the ledger and unresolved items.
Each outstanding difference should have an explanation, a responsible person and an expected resolution date.
An authorised finance officer should review and approve the reconciliation. Unresolved items should remain on the schedule until they are properly investigated and cleared.
This creates an audit trail and helps management establish whether rental income records are complete and reliable.
Internal Controls That Help Prevent Rental Income Discrepancies
A reliable reconciliation process depends on more than comparing figures at month-end. Property businesses should establish controls that reduce errors and improve the accuracy of rental records.
Important controls include:
- Updated tenancy agreements: Rental amounts, payment dates and lease periods should be supported by approved agreements.
- Unique tenant references: Each tenant and rental unit should have an identification code to reduce incorrect payment allocations.
- Approved payment channels: Tenants should be encouraged to pay into designated business accounts rather than personal accounts.
- Separate accounting for deposits: Refundable security deposits should be recorded separately from rental income.
- Monthly reconciliations: Rent rolls, ledger balances and bank receipts should be compared regularly.
- Independent reviews: Reconciliations should be reviewed by an authorised officer who is not solely responsible for recording rental transactions.
- Aged arrears reports: Outstanding tenant balances should be monitored by amount and how long they have remained unpaid.
- Proper documentation: Receipts, payment confirmations and approved adjustments should be retained to support accounting entries.
These controls improve accountability and help management identify collection problems before they affect financial reporting.
How Digital Accounting Systems Support Rental Income Reconciliation
When property businesses rely on separate spreadsheets, manual receipts and bank statements, reconciling rental income can become time-consuming.
Finance teams may have to compare tenant schedules with accounting reports and manually identify deposits in bank statements. This increases the risk of missed transactions, incorrect allocations and duplicated entries.
Digital accounting and financial management systems can help businesses organise financial transactions, maintain consistent accounting records and improve visibility over income and expenses.
For example, FinovatePro is a cloud-based accounting and financial management platform that supports accounting, expense tracking and financial reporting. Maintaining financial information in a central digital system can help businesses organise their accounting records and review their financial position more efficiently.
However, property businesses should assess whether their chosen system also supports their specific property management requirements. Organisations managing several properties and tenants may need additional software with features such as rent roll management, automated rental invoicing, tenant account tracking, payment matching and arrears monitoring.
The important consideration is whether the systems and procedures in place allow finance teams to identify differences between expected rental income, accounting records and actual cash collections.
Closing the Gap Between Expected Rent and Actual Collections
Rental income reconciliation is an important financial control for property owners and management companies. A rent roll may show how much tenants are expected to pay, but the general ledger and bank statements help establish whether those amounts have been correctly recorded and received.
When these records are not regularly compared, businesses may overlook unpaid rent, misclassify tenant deposits, record advance payments incorrectly or report inaccurate rental income.
The solution is to make reconciliation a regular part of the financial close process.
By maintaining updated rent rolls, matching bank deposits to tenant accounts, investigating discrepancies and reviewing outstanding balances, property businesses can improve cash collection monitoring and produce more reliable financial reports.
For businesses looking to improve the organisation of their accounting and financial information, FinovatePro can support day-to-day accounting, expense tracking and financial reporting.
Book a FinovatePro demo to explore how the platform can support your organisation’s financial management processes.