Blog
How to automate quarterly asset management reports when property managers send data in different formats
by Daniel Leong, GTMUpdated
Property managers send data in different formats? Compare 3 ways to automate quarterly asset management reports, with a data request and a checklist.

Short answers
Is there a way to automate quarterly asset management reports when property managers send data in different formats?
Yes, but only part of the job is a data problem. Tools like Power Query can combine property manager spreadsheets that share a layout, and document extraction tools can pull fields from PDFs, while newer AI platforms read the whole package (spreadsheets, PDF reports, leases and loan documents) and draft the report for a person to review. Whichever route you pick, the work that makes it stick is a data request every property manager signs up to, one mapping table to your chart of accounts, and a review step that traces each figure back to the file it came from.
How are CRE asset managers using AI for portfolio and investor reporting?
Mostly for five jobs: rolling up property manager packages into one portfolio view, drafting variance commentary, answering investor and board questions (including DDQs) from documents the firm already holds, monitoring assets between reporting cycles so risks such as lease expiries or covenant pressure surface earlier, and scheduling recurring reporting tasks. The pattern that works is AI drafts, people check and sign.
How can I shorten a 15-day monthly close and reporting cycle across dozens of properties?
Split the accounting close from the reporting that follows it. The accounting side shortens with a close calendar, accrued estimates and materiality rules; the reporting side shortens when property managers deliver to one spec, mapping and checks run automatically as each package lands, and analysts review exceptions instead of rebuilding every report from scratch.
Why property manager data arrives in different formats
If you own assets managed by several property managers, you are almost certainly receiving several versions of the same report. The reasons are structural, not carelessness:
- Different systems
- Each property manager runs its own property management and accounting software, so exports differ in layout, file type and level of detail. Some send a clean Excel trial balance; others send a PDF package of 40 pages.
- Different charts of accounts
- One manager books all recoveries (service charge, insurance, tax) in one line, another splits them by recovery type, a third nets them against expenses. "Repairs and maintenance" can be one account or twenty.
- Different conventions
- Accrual timing, how vacancy and free rent are shown, whether management fees sit above or below NOI, and how capital items are separated from operating repairs all vary.
- Different timing
- Packages land on different days, and corrections (restatements of prior months) arrive whenever the property manager spots them.
- Narrative lives outside the numbers
- Leasing updates, arrears commentary, capex progress and tenant issues often arrive as Word documents, PDF commentary or email.
- Mapping logic lives in one person's head
- In many teams, the knowledge of how Manager A's "Other income" maps to your house line exists only in one analyst's spreadsheet.
That last point is why many automation projects stall. Before any tool can help, the mapping has to be written down.
Three ways to automate quarterly asset management reports
There are three honest routes. Most teams end up combining them.
What it does
- Option 1: Power Query and Power BI
- Combines and reshapes spreadsheet exports, then feeds dashboards and paginated reports
- Option 2: Document extraction tools
- Pulls named fields and tables out of PDFs and scanned documents
- Option 3: AI that reads the package and drafts the report
- Reads spreadsheets, PDFs and supporting documents together, then drafts commentary and the report
Best when
- Option 1: Power Query and Power BI
- Property managers send structured files with a stable layout
- Option 2: Document extraction tools
- You receive a high volume of similar PDFs with predictable fields
- Option 3: AI that reads the package and drafts the report
- Packages are mixed format and the report needs context from leases, debt documents and commentary
Where it stops
- Option 1: Power Query and Power BI
- Breaks, or silently drops data, when a file layout changes; does not read PDF commentary, leases or covenants
- Option 2: Document extraction tools
- Extracts data but does not reconcile it, explain variances or write the report
- Option 3: AI that reads the package and drafts the report
- Still needs your data request, your mapping rules and a person who reviews and signs
Who maintains it
- Option 1: Power Query and Power BI
- A BI or finance systems person
- Option 2: Document extraction tools
- A BI or automation person, plus model or template setup as layouts change
- Option 3: AI that reads the package and drafts the report
- The asset management team, with vendor support
Typical tools
- Option 1: Power Query and Power BI
- Power Query, Power BI, Power BI paginated reports, Excel
- Option 2: Document extraction tools
- Azure Document Intelligence, Power Automate with AI Builder, Docparser
- Option 3: AI that reads the package and drafts the report
- CRE-specific AI platforms, including Fifth Dimension
Option 1: Power Query and Power BI (combine files from a folder)
Microsoft's Power Query can combine multiple files that have the same schema into a single table, for example every monthly file dropped into one folder or SharePoint site (Microsoft Learn: combine files overview (opens in a new tab)). For a quarterly asset report, a common setup is:
- One folder per property manager, with one query per manager that reshapes its export into your standard layout.
- A mapping table (see step 2 below) that converts each manager's account codes into your house chart of accounts.
- A combined fact table that feeds a Power BI model.
- A paginated report for the fixed-layout pages your investment committee or board expects (Microsoft Learn: Power BI Report Builder (opens in a new tab)).
Where it fits: low cost if you already have Power BI licences, and strong for numbers that arrive as clean spreadsheets.
Where it stops: the "same schema" requirement is the catch. When a property manager renames a column, moves the header row or switches systems, the query breaks or, worse, silently drops data, and someone has to fix it. Power Query also does not read PDF commentary, check a rent roll against the lease, or read covenant definitions from a facility agreement.
Option 2: Document extraction tools (Azure Document Intelligence, Power Automate, Docparser)
Document extraction tools pull text, fields and tables out of PDFs and scans. Microsoft offers Azure Document Intelligence (overview (opens in a new tab)) and document processing in Power Automate through AI Builder (overview (opens in a new tab)). Docparser (opens in a new tab) uses rule templates and, more recently, an AI parser. You define the fields to extract and train a model or set up templates, sometimes one per layout, then send the extracted fields into Excel, a database or Power BI.
Where it fits: a steady volume of similar PDFs, such as monthly operating statements from a manager who only sends PDF.
Where it stops: extraction gives you fields, not a report. It does not reconcile the rent roll to the operating statement, explain why NOI is below budget, notice that a lease amendment was never billed, or draft the narrative. Layouts it has not seen often need more setup.
Option 3: AI that reads the property manager reports and drafts the asset report
The newest route uses AI built to read a whole reporting package at once: spreadsheets, PDF reports, leases, loan documents and commentary. Instead of extracting fields one document at a time, it works across them and drafts first-pass outputs for review: variance commentary, portfolio summaries and a draft report.
Where it fits: mixed-format packages, portfolios with several property managers, and reports that need context from leases and debt documents, not just the trial balance.
Where it stops: it does not replace the data request, the mapping rules or the reviewer. Ask any vendor to show you where each figure in its draft comes from, how it handles a restated month, and what a reviewer sees before sign-off. If it cannot show that, treat its drafts as unverified.
Fifth Dimension is one platform in this category. More on where it fits in the "Where Fifth Dimension fits" section below.
How to automate a quarterly asset management report, step by step
This process works with any of the three routes. The tools change; the steps do not.
Step 1: Agree a data spec with every property manager
Send each property manager the same data request (Template 1 below) and get it written into the reporting schedule of the property management agreement, or an amendment to it, where you can. The spec covers which files, which format, which fields, the due date and the restatement rule. You will not get every manager onto one template, and you do not need to. You need every manager to deliver the same information on time.
Step 2: Build one mapping table to your chart of accounts
Write down how each manager's lines map to your house accounts and NOI lines. Keep it in one shared file, owned by one person, with a change log. An example, with sample data:
Manager A
- PM account code and label
- 4010 Base Rent Office
- House account
- 4000 Base rent
- NOI line
- Revenue
- Notes
- None
Manager A
- PM account code and label
- 4150 CAM Recoveries
- House account
- 4100 Recoveries
- NOI line
- Revenue
- Notes
- Includes tax and insurance recoveries
Manager B
- PM account code and label
- 40-100 Rental Income
- House account
- 4000 Base rent
- NOI line
- Revenue
- Notes
- Gross; free rent is reported separately in 40-900
Manager B
- PM account code and label
- 40-300 Service Charge Income
- House account
- 4100 Recoveries
- NOI line
- Revenue
- Notes
- None
Manager B
- PM account code and label
- 40-900 Concessions
- House account
- 4050 Free rent and concessions
- NOI line
- Revenue (contra)
- Notes
- None
Manager A
- PM account code and label
- 6200 R&M HVAC
- House account
- 6100 Repairs and maintenance
- NOI line
- Operating expenses
- Notes
- None
Manager B
- PM account code and label
- 61-000 Property Management Fee
- House account
- 6400 Management fees
- NOI line
- Operating expenses
- Notes
- House policy: above NOI
Manager A
- PM account code and label
- 7100 Bad Debt Expense
- House account
- 6500 Bad debt
- NOI line
- Operating expenses
- Notes
- Under US GAAP (ASC 842), operating lease income no longer probable of collection is generally taken off rental income, not booked as bad debt; IFRS reporters usually show expected credit losses as an expense. Set one house policy. Cross check to arrears report
Manager B
- PM account code and label
- 80-200 Tenant Improvements
- House account
- 8100 Tenant improvements
- NOI line
- Below NOI (capital)
- Notes
- Do not include in operating expenses
Manager A
- PM account code and label
- 8500 Leasing Commissions
- House account
- 8200 Leasing costs
- NOI line
- Below NOI (capital)
- Notes
- None
Rules worth writing down next to the table: how unmapped codes are handled (they should stop the run, not fall into "Other"), who approves a new mapping, and how a change to the mapping is dated.
Step 3: Set up intake in one place
Every package goes into one location, for example a SharePoint library with one folder per property and quarter. File naming follows the spec. Late packages get chased automatically on the due date plus one day.
Step 4: Run checks as each package lands
Before anyone writes commentary, run the same checks on every package:
- Trial balance balances, and the operating statement ties to it.
- Rent roll ties to billed charges tenant by tenant, and in total to rental income in the operating statement, with free rent, straight-lining and mid-month moves as named reconciling items.
- Billed rent matches the executed leases and any amendments, including rent reviews and expansions.
- Arrears report ties to the receivables balance.
- Cash per the balance sheet ties to the bank reconciliations, and security deposits held tie to the deposit liability.
- Prior months still match what you reported. If not, flag a restatement.
- Every PM code maps to a house account (no unmapped lines).
Step 5: Draft variance commentary
Set thresholds (for example, any line more than a set percentage and a set amount from budget or prior quarter) and draft commentary only for lines that cross them. Each explanation should name its source: the PM commentary, the lease, an invoice or the capex tracker.
Step 6: Assemble the report in your house template
Pull the reconciled numbers, commentary, leasing, capex, debt and valuation sections into your standard outline (Template 2 below). Keep the template fixed so readers know where to look each quarter.
Step 7: Review against the checklist
A second person works through the review checklist below. The reviewer's job is to confirm each material figure against its source, not to re-key the report.
Step 8: Sign off and log it
Record who reviewed, who signed, the date, and any open items carried into next quarter. Store the final report next to its source files so the next audit or investor question can be answered from the same folder.
Template 1: Property manager data request
Copy, adapt and send this to each property manager.
Subject: Quarterly reporting package requirements for [Property name], effective [Quarter].
- Basis of accounting: accrual, under [US GAAP / IFRS / other], on our financial year ending [month]. If you report on any other basis, tell us before the first package.
- Due date: [X] business days after quarter end (monthly packages: [X] business days after month end).
- Delivery: upload to [SharePoint library or folder link], named [PropertyCode]_[YYYY-MM]_[FileType].
- Restatement rule: if any previously reported month changes, send a revised file marked RESTATED, with a short note listing each changed line, the old and new amounts, and the reason. Do not overwrite earlier files. If your policy is to book corrections in the current period instead, show them as a separately labelled prior-period adjustment.
- Chart of accounts: use your normal codes. We map them to our house accounts. Please tell us at least [X] days before any change to your chart of accounts or reporting system.
- Contact: [Asset manager name, email] for questions about this request.
Required files, every month:
- Trial balance (Excel or CSV, with account code, account name, period and year-to-date columns)
- Operating statement versus budget (Excel preferred; PDF accepted only alongside the Excel version)
- Rent roll as at month end (Excel: tenant, unit, area, lease start, lease expiry, break or option dates, current rent, recoveries, next review date, security deposit)
- Arrears and aged receivables report by tenant
- General ledger detail for the month
- Balance sheet and bank reconciliations
Required files, every quarter:
- Leasing activity: new leases, renewals, surrenders and terminations, with key terms
- Capital expenditure tracker: budget, committed, spent, forecast to complete
- Property manager commentary: performance, tenant issues, risks, actions (Word or PDF, maximum two pages)
- Copies of any lease amendments, side letters or notices received during the quarter
Template 2: Quarterly asset report outline
- Summary (one page): headline performance, NOI versus budget and prior quarter, key risks and the decisions needed.
- Financial performance: NOI versus budget and prior year, revenue and operating expense variances above threshold, with commentary and sources.
- Leasing and rent roll: occupancy, new leases and renewals, upcoming expiries (next 12 to 24 months), WALT, rent reviews due.
- Arrears and tenant risk: arrears by tenant and age, tenants on watch, credit or rating changes.
- Capital expenditure: projects, budget versus spend, timing, and any change to the business plan.
- Debt and covenants: facility summary including maturity and any hedge expiry, covenant tests (for example interest cover and loan to value) against thresholds, headroom, upcoming reporting dates.
- Valuation and returns: latest valuation, its date and basis (independent or internal), cap rate, change in value since the previous valuation, and returns against the business plan.
- Market context: brief local market update relevant to leasing and valuation.
- Risks and actions: each risk with an owner, an action and a date.
- Restatements and open items: any prior period changes, and items carried forward.
- Sources: list of property manager files, leases and other documents used, with dates.
Review checklist for quarterly asset management reports
- Every material figure in the report traces back to a named source file and page or cell.
- Trial balance, operating statement and rent roll tie to each other.
- Billed rent has been checked against executed leases and amendments for the largest tenants.
- All PM account codes are mapped; no amounts sit in an unmapped or "Other" bucket.
- Variances above threshold all have commentary, and each explanation names its source.
- Restated prior months are flagged, with old and new amounts and the reason.
- Covenant tests use the definitions in the facility agreement, not a simplified version.
- Lease expiries, break options and notice dates in the next 24 months are listed.
- Tenant credit or rating changes during the quarter are reflected in the risk section.
- Commentary from the property manager has been read, not just pasted.
- Reviewer name, sign-off name and date are recorded, with open items carried forward.
How CRE asset managers are using AI for portfolio and investor reporting
Across vendor material and practitioner discussion, the same uses come up again and again:
- Portfolio roll-ups
- Combining property manager packages into one portfolio view that the team can review in one place.
- Variance narratives
- Drafting first-pass commentary for lines that cross thresholds, with the source behind each explanation, for an analyst to edit.
- Investor and board questions
- Answering board questions, investor queries and due diligence questionnaires (DDQs) from leases, models, IC memos and past reports the firm already holds.
- Monitoring between cycles
- Watching lease expiries, NOI variance, tenant credit and covenant headroom continuously, so issues surface before the next quarterly report rather than in it.
- Recurring automation
- Scheduling the same reporting tasks each month or quarter so drafts are ready when packages land.
What separates the useful deployments from the experiments is the same thing that separates a good manual process from a bad one: a clear data spec, written mapping rules, and a reviewer who can see where each figure came from. General-purpose assistants can summarise files and, through connectors, reach some of the systems they live in, but they do not keep a review trail behind each figure, which makes review harder for numbers going to investors. For more on that trade-off, see ChatGPT or Claude vs a CRE-built AI platform.
Shortening the reporting side of the monthly close
This article is general information, not financial, accounting or legal advice.
A 15-day monthly close across dozens of properties usually has two parts: the property managers' accounting close, and your team's reporting on top of it. The accounting close is a finance process topic (cut-off rules, accrual policies, intercompany), and this guide covers it only briefly: publish a close calendar with property manager deadlines, accrue estimates instead of waiting for invoices, and set materiality so small items roll forward. The reporting side can shrink with the same steps as the quarterly process:
- Move the due date into the spec
- A fixed delivery day per manager, with an automatic chase, removes the "waiting for packages" days.
- Check on arrival, not at the end
- Run the tie-outs and mapping as each package lands, so problems go back to the property manager while they still remember the month.
- Review exceptions, not everything
- Analysts look at lines over threshold, unmapped codes and restatements, not every line of every property.
- Reuse monthly work for the quarter
- If each month is reconciled and commented on, the quarterly report is mostly assembly.
Where Fifth Dimension fits
Fifth Dimension is AI for commercial real estate, from underwriting to lease abstraction. It connects the documents, data, systems and expertise a firm already relies on. For quarterly reporting, it is one of the AI platforms described in Option 3.
- Connects the sources. Fifth Dimension unifies Yardi, Argus, CoStar, Excel and email into one intelligence layer instead of reconciling systems manually, and connects operating partner reports and portfolio data rooms. See Fifth Dimension for asset managers.
- Review portfolio roll-ups, not reconciliations. It pulls reporting from connected sources so teams can review insights instead of reconciling spreadsheets, and brings portfolio summaries, reporting drafts and investor queries together around the documentation you already hold. See Fifth Dimension for portfolio managers.
- Decision materials. It turns analysis into the memos, reports, models and presentations your team already uses, with the working behind them intact.
- The evidence stays visible. Evidence & Controls keeps sources, assumptions, review steps and changes visible so your team can understand how an output was produced.
- Runs on a schedule. Tasks schedule recurring automations and repeatable workflows so routine work happens when it should, with review and control built in.
- Monitoring between reports. It connects asset-level evidence to portfolio reporting so the team can surface tenant, lease and performance risks while there is still time to act, and it answers board questions from one trusted foundation.
- Enterprise security. SOC 2 Type II compliant, ISO 27001 certified and GDPR compliant; customer data is never used to train the models that power Fifth Dimension; each customer operates in a separate product environment; and every operation is logged and traceable. See Fifth Dimension security.
Fifth Dimension's AI agent understands your terminology, processes and priorities, and applies them consistently across each task. Lease abstraction is also part of the Fifth Dimension platform.
You can start with what you already hold: it automates portfolio summaries, reporting drafts and investor queries using existing documentation and reports, with no integrations required to start. Put the same three questions from Option 3 to us as to any vendor: where each figure comes from, how a restated month is handled, and what a reviewer sees before sign-off.
Together, we identify the manual processes that are slowing you down across the full lifecycle of how you invest in and manage your assets. Start with the people and work that matter most, then expand as Fifth Dimension connects more of your organisation. Fifth Dimension takes on the work between receiving information and making a decision, while keeping your team in control of the judgement that matters. Request a demo.




