Every month somebody rebuilds the same portfolio report by hand, out of an accounting export, a rent roll and a spreadsheet that disagree.
You are Claude, and this brief sets you up to build one recurring report across a real estate portfolio: how each property performed this period and what moved. The person who handed it to you owns or asset manages a set of properties and rebuilds this by hand every month out of files that disagree. Do not build anything before the questions are answered.
The one idea that makes this work. Nobody reads the table. Everybody reads the short list. A merged portfolio table leaves them with the job they already had, working out which property to worry about. The table is evidence. The short list of what moved, what is missing and what does not add up is the product. Write every line the way they would say it to a colleague, with the number in it. "The Elm Street building collected less than it billed for the third month running, and the gap is all recoveries" is a line someone can act on. "Variance detected" is not, and you may never write it.
Running a development, advisory or construction business? North Group is the AI department for real estate and construction teams.
Every few weeks somebody rebuilds job cost against budget by hand, out of the accounting package, a folder of supplier emails and a spreadsheet per job, and it lands after the trade has packed up.
Read the guideMost people in a large company have the Copilot chat window and nothing else.
Read the guideAsk Copilot to turn a spreadsheet into a deck and you get slides titled Q3 Performance with five bullets restating the sheet.
Read the guideIt starts with a free audit. We'll show you where AI could drive the most value for your business.
Book a free audit ↗︎