An external audit does not begin when the auditors arrive. It begins months earlier, in the quality of records maintained during the year, the completeness of period-end reconciliations, and the accuracy of the disclosures prepared for the financial statements. A well-managed portfolio produces an audit that moves quickly and closes without material adjustments. A poorly documented one produces an audit that is slow, expensive, and frequently results in adjustments that affect the reported financial position.
Finance directors and controllers searching for how to prepare for a real estate audit, what documentation auditors require, or how to reduce audit queries are typically dealing with the same problem: the records exist but are not organised or reconciled in a way that allows an auditor to verify them efficiently. Every hour an auditor spends reconstructing information that should have been readily available is an hour billed at audit rates.
This guide covers audit preparation across three dimensions: the documentation package, the pre-audit reconciliations, and the financial statement disclosures. It is written for finance directors, controllers, and property accountants responsible for delivering an audit-ready set of records on time and without unnecessary adjustments.
Real estate portfolios have audit characteristics that distinguish them from general commercial entities. The asset values are large, the lease structures are complex, the entity architecture is often multi-layered, and the accounting judgments involved, particularly around property valuations, lease classification, and revenue recognition, are areas of elevated auditor scrutiny. A generic month-end close process is not sufficient preparation for an external audit of a real estate portfolio. A dedicated audit preparation process is required because the volume and complexity of audit evidence needed is materially greater than for most other businesses.
Here is where real estate audit preparation consistently presents challenges:
Property values are the largest balances on the balance sheet of a real estate portfolio and the ones subject to the most auditor scrutiny.
The challenges that arise in this area are:
Independent valuation currency:
Where the portfolio carries properties at fair value, the auditor will require independent valuations that are current as at the balance sheet date or within an acceptable staleness period. Valuations that are more than twelve months old at the balance sheet date will typically require a desktop update or a fresh appraisal before the auditor will accept them.
Valuation methodology consistency:
Where the methodology or key assumptions used in the current year valuation differ from the prior year, the auditor will require a documented explanation of the change and its financial effect. Undisclosed changes in capitalisation rates or discount rates that materially affect the carrying value are a standard audit finding.
Cost model asset register accuracy:
Where properties are carried at cost less accumulated depreciation, the fixed asset register must reconcile to the general ledger, all capital expenditure additions must be supported by invoices and board or management approvals, and the depreciation calculation must be correct and consistent with the prior year policy.
Impairment assessment:
Where there are indicators that a property's carrying value may exceed its recoverable amount, the auditor will require evidence that an impairment assessment has been performed and documented, even if the conclusion is that no impairment is required.
Lease accounting and revenue recognition are areas of persistent complexity in real estate audit preparation.
The specific challenges are:
Lease register completeness:
The auditor will test whether every material lease in the portfolio is reflected in the lease register and whether the key terms used in the accounting, including the lease commencement date, the lease term, the rent schedule, and the applicable options, agree to the executed lease documents.
Straight-line rent receivable reconciliation:
The straight-line rent receivable balance must reconcile to the individual lease schedules for every tenancy that has a rent-free period or scheduled rent increases. An unreconciled straight-line rent balance is a standard audit finding in commercial real estate portfolios.
Deferred revenue accuracy:
Every prepaid rent balance, last month's rent holding, and non-refundable lease fee deferred at commencement must be supported by a recognition schedule that reconciles to the general ledger balance.
For guidance on how deferred revenue schedules should be structured and maintained, see the deferred revenue and prepaid rent recognition guide.
ASC 842 or IFRS 16 compliance:
Where the portfolio has leases that are recognised on the balance sheet as right-of-use assets and lease liabilities, the auditor will require the full lease liability schedule, the discount rate applied, the remeasurement calculations for any lease modifications during the year, and the reconciliation of the opening and closing lease liability balance.
Real estate portfolios typically operate through multiple entities, and the consolidation of those entities into a single set of financial statements is an area of elevated audit complexity.
The specific challenges are:
Intercompany balance agreement:
All intercompany balances between entities in the group must agree at the consolidation level. A difference in intercompany balances between two entities that has not been investigated and resolved before the audit will generate an audit query that is time-consuming to resolve under audit pressure.
Elimination completeness:
Every intercompany transaction eliminated in the consolidation must be supported by documentation showing the nature of the transaction, the entities involved, and the elimination entry. Incomplete eliminations that leave a residual balance in the consolidated accounts are a standard finding in multi-entity real estate audits.
Minority interest and joint venture accounting:
Where the portfolio includes joint ventures or properties held through entities in which the fund does not hold a controlling interest, the accounting for the minority interest or equity accounted investment must be supported by the relevant entity's financial statements and the applicable accounting standard.
The audit documentation package is the set of records and workpapers that the finance team prepares and provides to the auditors at the commencement of the audit fieldwork. A complete and well-organised documentation package reduces the volume of auditor queries and the time required to resolve them. An incomplete or disorganised package extends the audit timeline and increases the audit cost.
Here is how to structure it:
The fixed asset and property valuation documentation package should include:
Fixed asset register:
A complete listing of all properties and capital assets held by the portfolio, showing the original cost, the date of acquisition, the accumulated depreciation, and the carrying value at the balance sheet date, reconciled to the general ledger
Independent valuation reports:
The full valuation report for each property carried at fair value, including the valuation date, the methodology, the key assumptions, and the valuer's conclusion, with the valuer's independence from the fund manager confirmed
Capital expenditure schedule:
A schedule of all capital expenditure additions during the year, cross-referenced to the invoices, contracts, and board or management approvals that support each addition
Depreciation calculation workpaper:
The depreciation calculation for each asset class showing the useful life, the depreciation method, the opening accumulated depreciation, the charge for the year, and the closing accumulated depreciation, reconciled to the general ledger
Impairment assessment:
Where an impairment indicator exists for any property, the impairment assessment documentation showing the recoverable amount calculation and the conclusion
The lease and revenue documentation package should include:
Executed lease agreements:
The fully executed lease for every active tenancy, with all schedules, variations, and side letters included. Where a lease variation has been executed during the year, the variation document should be available alongside the original lease.
Lease register:
The complete lease register showing the key terms for every tenancy, including the commencement date, the expiry date, the rent schedule, the rent-free periods, and the renewal options, with a confirmation that the register agrees to the executed lease documents
Straight-line rent schedule:
The straight-line rent schedule for every tenancy with a rent-free period or scheduled rent increase, showing the total contracted rent, the straight-line rent per period, the cumulative straight-line rent receivable, and the reconciliation to the general ledger balance
Deferred revenue schedules:
The recognition schedule for every prepaid rent balance, last month's rent holding, and deferred lease fee, showing the opening balance, the amounts recognised during the year, and the closing balance reconciled to the general ledger
ASC 842 or IFRS 16 workpapers:
Where applicable, the full lease liability schedule for every recognised lease, including the opening balance, the interest accretion, the repayments, any remeasurement adjustments, and the closing balance reconciled to the general ledger
For guidance on how the ASC 842 lease liability schedule should be constructed and maintained, see the ASC 842 compliance guide.
The cash, receivables, and liability documentation package should include:
Bank reconciliations:
Completed bank reconciliations for every bank account held by every entity in the group, as at the balance sheet date, with the reconciling items identified and supported
Accounts receivable aged trial balance:
The complete AR aged trial balance as at the balance sheet date, with the basis for any provision for doubtful debts documented and the provision amount reconciled to the general ledger
Security deposit register:
The complete security deposit register reconciled to the security deposit liability in the general ledger, with every deposit traced to the underlying tenant and lease record
For guidance on how the security deposit register should be structured and maintained, see the security deposit accounting guide.
Accounts payable listing:
The complete accounts payable listing as at the balance sheet date, with any material accruals supported by invoices, contracts, or estimates documented with the basis for the estimate
Loan facility statements:
Lender statements confirming the outstanding balance, accrued interest, and covenant compliance position for every loan facility as at the balance sheet date
The reconciliations completed before the audit fieldwork begins are the controls that identify and resolve errors before the auditor encounters them. An error identified and corrected during pre-audit reconciliation costs nothing beyond the time to fix it. The same error identified by the auditor costs audit time to investigate, management time to explain, and in some cases an audit adjustment that affects the reported financial position.
Here is how to structure the pre-audit reconciliation program:
Every balance sheet account should be reconciled to supporting documentation before the audit commences. The reconciliation program for a real estate portfolio should confirm:
Property carrying values:
The carrying value of each property in the general ledger agrees to the fixed asset register, which in turn agrees to the independent valuation or the depreciated cost calculation
Straight-line rent receivable:
The total straight-line rent receivable in the general ledger agrees to the sum of all individual lease straight-line rent schedules
Deferred revenue:
The total deferred revenue liability in the general ledger agrees to the sum of all individual tenant deferred revenue recognition schedules
Security deposit liability:
The total security deposit liability in the general ledger agrees to the sum of all individual tenant deposit records in the security deposit register
Loan balances:
The loan balances in the general ledger agree to the lender statements, with accrued interest calculated to the balance sheet date
Intercompany balances:
All intercompany receivable and payable balances agree between the entities in the group, with any differences investigated and resolved before the consolidation is prepared
For guidance on how intercompany balances should be reconciled and eliminated in the consolidation process, see the intercompany eliminations guide.
The income statement reconciliations confirm that the revenue and expense lines in the financial statements are accurate and complete. The key reconciliations for a real estate portfolio are:
Rent roll reconciliation:
The total rental revenue recognised in the income statement for the year reconciles to the rent roll, with the straight-line rent adjustment separately identified and supported by the lease-level schedules
CAM and outgoings recovery:
The outgoings recovery income reconciles to the CAM reconciliation statements issued to tenants during the year, with any over or under recovery identified and correctly treated
Property operating expenses:
The property operating expense lines reconcile to the invoices and contracts supporting each expense category, with any accruals or prepayments identified and correctly treated
Interest expense:
The interest expense for the year reconciles to the loan facility statements, with the opening and closing accrued interest balances confirmed against the balance sheet
The auditor will compare the current year balances to the prior year and will expect to understand material movements. A movement analysis prepared by the finance team before the audit begins allows the team to explain variances proactively rather than reactively.
The movement analysis should cover:
The change in total property carrying value from the prior year, attributed to acquisitions, disposals, capital expenditure additions, depreciation charges, and revaluation movements
The change in total rental revenue from the prior year, attributed to new leases commencing, leases expiring, rent reviews, and vacancy changes
The change in total debt from the prior year, attributed to new facilities, repayments, and any refinancing events
Any other material balance sheet or income statement movements that are not self-evident from the face of the financial statements
The financial statement disclosures for a real estate portfolio are more extensive than those required for a general commercial entity, because the applicable accounting standards require specific disclosures about property valuations, lease arrangements, and financial instruments that are material to the reader's understanding of the portfolio's financial position. Inadequate disclosures are an audit finding regardless of whether the underlying numbers are correct.
Here is how to prepare the key disclosure areas:
Where properties are carried at fair value, the financial statements must disclose:
The valuation methodology applied to each class of property, including the key unobservable inputs such as the capitalisation rate, the discount rate, and the adopted market rent
The fair value hierarchy classification of each property under ASC 820 or IFRS 13, confirming whether the valuation is based on observable market inputs (Level 2) or significant unobservable inputs (Level 3)
A sensitivity analysis showing the effect on the carrying value of a reasonable change in each key unobservable input, such as a twenty-five basis point movement in the capitalisation rate
The name and qualifications of the independent valuer and confirmation of their independence from the fund manager
Where properties are carried at cost, the disclosures must include the carrying amount, the accumulated depreciation, the depreciation rate and method, and the estimated fair value where materially different from the carrying amount.
The lease disclosures required under ASC 842 or IFRS 16 for leases where the portfolio is the lessee include:
The right-of-use asset balance by asset class at the opening and closing balance sheet date
The lease liability balance split between current and non-current at the balance sheet date
A maturity analysis of the undiscounted lease liability payments, showing the amounts due within one year, between one and five years, and beyond five years
The interest expense on lease liabilities and the depreciation charge on right-of-use assets for the year
The weighted average discount rate applied to the lease liabilities
As a lessor, the portfolio must also disclose the maturity profile of future lease receivables, the variable lease revenue recognised during the year, and any significant terms and conditions of material leases.
Where the portfolio operates across multiple segments or jurisdictions, the financial statements must disclose segment information that enables the reader to assess the contribution of each segment to the overall financial performance. The segment disclosures should include the revenue, operating profit, and total assets for each reportable segment, defined consistently with the internal reporting structure used by management.
The International Financial Reporting Standards Foundation publishes the applicable disclosure requirements under IFRS 8 Operating Segments that most international real estate funds adopt.
Preparing the documentation and reconciliations is the foundation of audit readiness. Managing the audit process itself is what determines whether that preparation translates into an efficient audit with a clean outcome.
Here is how to manage the audit process from fieldwork through to sign-off:
Before the auditors commence fieldwork, an audit readiness meeting between the finance team and the audit team confirms:
The audit timeline, including the commencement date for fieldwork, the target date for completion of substantive testing, and the expected sign-off date
The information request list, which itemises every document and workpaper the auditors require, and the format in which they should be provided
The key contact for each audit area, so that auditor queries are directed to the person with the most relevant knowledge rather than being routed through the finance director for every question
Any significant accounting judgments or estimates that the audit team has flagged as areas of focus, so that the finance team can prepare the supporting documentation in advance rather than in response to a query
Audit queries should be managed through a defined process rather than handled informally. The query management process should:
Log every query received from the auditors, the date it was received, the person responsible for responding, and the target response date
Track the status of every query from receipt through to resolution, with overdue queries escalated to the finance director
Confirm that responses are accompanied by the specific supporting documentation requested rather than a general explanation, because an explanation without evidence does not close an audit query
Maintain a complete record of every query and response as the audit file for the year, which becomes the reference point if the same issue arises in subsequent years
Where the auditor proposes an adjustment to the financial statements, the finance team should assess each proposed adjustment on its merits before agreeing or disagreeing.
The assessment should confirm:
Whether the proposed adjustment reflects a genuine error in the financial statements or a difference in accounting judgment between the finance team and the audit team
The financial effect of the proposed adjustment on the income statement, the balance sheet, and any key metrics that affect investor reporting, covenant compliance, or performance fee calculations
Whether the proposed adjustment is above the auditor's materiality threshold, because adjustments below materiality may be proposed but are typically not required to be recorded
A pattern of audit adjustments in the same area in successive years indicates a systemic process failure that needs to be addressed in the ongoing accounting process rather than corrected at audit time each year.
Q1: How far in advance of the balance sheet date should audit preparation begin?
Audit preparation should begin at least sixty to ninety days before the balance sheet date, with the balance sheet reconciliation program completed within two weeks of the balance sheet date so that the documentation package is ready when the auditors commence fieldwork.
Q2: What is the most common cause of audit delays in a real estate portfolio?
The most common cause is an unreconciled balance sheet account, typically the straight-line rent receivable, the deferred revenue liability, or the intercompany balances, that the auditors cannot verify without a complete supporting schedule that the finance team has to reconstruct under audit pressure.
Q3: Do auditors require original lease documents or are copies sufficient?
Auditors typically accept certified copies of executed lease documents for testing purposes, but they will require access to the originals for any lease that represents a significant balance or that involves a complex or unusual structure, and the originals should be held securely and accessible within the audit timeline.
Q4: How should a property valuation that has changed significantly from the prior year be presented to the auditors?
The finance team should prepare a proactive explanation of the valuation movement before the audit commences, showing the prior year and current year key assumptions, the market evidence supporting the current year assumptions, and the financial effect of the movement, so that the auditor can assess the reasonableness of the change with the supporting context already available.
Q5: What is the difference between an audit adjustment and a reclassification?
An audit adjustment changes the total of an income statement or balance sheet line and affects the reported financial position or performance, while a reclassification moves an amount between line items without changing any total and affects only the presentation of the financial statements, not the underlying numbers.
An external audit produces a clean, timely outcome when the records presented to the auditors are complete, reconciled, and organised before fieldwork begins. The audit is not the test of the accounting. It is the test of the process that produced the accounting. A finance team that maintains accurate records throughout the year, completes the balance sheet reconciliation program before the audit commences, and presents the auditors with a structured documentation package is a finance team that controls the audit timeline rather than being controlled by it.
The portfolios that consistently achieve clean audits are not necessarily the ones with the simplest structures or the smallest number of judgments. They are the ones with the most disciplined ongoing process. Every reconciliation completed at month end is one less reconciliation to be reconstructed under audit pressure. Every disclosure prepared in draft during the year is one less item to be written under time pressure at year end. That discipline does not eliminate audit risk. It reduces it to the irreducible minimum of genuine judgment differences, which is the only kind of audit query worth having.
Preparing for an external audit across a real estate portfolio on disconnected systems?
See how RIOO maintains the audit-ready records, reconciliations, and lease data that make external audits faster and cleaner inside a single NetSuite platform at riooapp.com/netsuite-property-accounting-software