REIT and Real Estate Fund Reporting Software: Build vs Buy
Buy Juniper Square. One or two funds, conventional structures, a single property accounting platform and a promote your accountants can calculate on one page is a purchase rather than a project.
On this page
Buy Juniper Square. One or two funds, conventional structures, a single property accounting platform and a promote your accountants can calculate on one page is a purchase rather than a project. Building starts to pay once deal by deal promotes across dozens of joint ventures mean the waterfall already lives in a spreadsheet and the product only stores the answer.
What the off-the-shelf products actually do well
Ten days after quarter end a fund controller opens last quarter's workbook. Thirty eight property trial balances, an ownership tab maintained by hand with a note in cell G14 about the Riverside expansion, a funds from operations bridge, an allocation tab, and the numbers that go into the investor letter. She is not doing this because the software failed. She is doing it because most of what decides the answer lives in legal documents.
Even so, the honest default here is buy, and it covers more sponsors than the build case does. Juniper Square is genuinely good at the investor facing layer: subscriptions, capital accounts, notices, statements and the experience an institutional investor sees. Yardi Investment Manager sits directly alongside the property accounting most operators already run, which matters because the data does not have to move. MRI Investment Management is comparable and strong inside an MRI estate. Allvue, Dynamo, Altvia and SS&C Investran all serve real sponsors well.
These products also carry work you would otherwise fund. Capital call and distribution notices, wire instructions, investor onboarding, document delivery, access control across separate relationships, and the audit trail your fund auditor will test. None of that is interesting to build and all of it has to be right.
So if your structures are conventional, buy, and put the saved capital into acquisitions. What follows is the specific point where buying stops covering you, and it is narrower than most vendors will admit and wider than most sponsors expect.
Where they stop: the waterfall came from a negotiated document
Distribution waterfalls are where real estate reporting stops resembling generic fund administration. A typical structure runs return of capital, a preferred return at a stated rate compounding on some basis, a general partner catch up, then a residual split, sometimes with a second hurdle tied to an internal rate of return, sometimes with a clawback, and often calculated deal by deal rather than at fund level.
Every one of those terms came from a negotiation. Whether the preferred return compounds monthly or annually. Whether it accrues on unreturned capital only. Whether sponsor fees offset the promote. Whether the hurdle is measured gross or net. Two funds from the same sponsor differ because the second was raised in a different market. The space of real structures is larger than any product's parameter set, so when a fund falls outside the supported shape the calculation leaves the system and comes back as a typed result. That is the spreadsheet you were removing.
The second thing products model badly is ownership. Real estate ownership is a graph, not a column. A property sits in a property entity, owned by a joint venture with an operating partner, owned partly by the fund, which has a general partner entity, an offshore feeder and two separate accounts alongside it. Interests change on a date when a partner funds a capital call, when a promote crystallises, when an interest transfers, or when a later closer equalises in. A single current percentage silently misstates every prior period the moment a structure moves, and the error surfaces when an investor queries an allocation.
The third is the tax calendar underneath all of it. Real estate investment trust qualification is tested quarterly on assets under Internal Revenue Code Section 856(c)(4), with a 30 day cure window after quarter end, and annually on income under the 75 and 95 percent tests, with the 90 percent distribution requirement sitting over the top. Products report. They do not usually compute the test.
The arithmetic: per investor position pricing versus a build
Pricing in this category is usually a platform fee scaled by fund count, investor positions or assets under management rather than by seat, so do the arithmetic on positions. Take your annual figure, divide it by the number of investor positions it covers, and call that P. Then project it. If you raise a fund every eighteen months and each brings a hundred and fifty positions, the fee compounds with fundraising success rather than with usage.
Now cost the labour the product does not remove. Count the days between quarter end and the investor pack going out, multiply by the fully loaded cost of the people in that window, and add the standing burden of ad hoc investor data requests. In most sponsors that second figure is larger than the licence, and it is the one that decides the comparison.
The crossover sits at roughly 40 property entities across joint ventures with differing economics, or about 250 investor positions across more than two vehicles, whichever you reach first. Below that a build is capital better spent on deals. Above it, the quarterly rebuild has become a permanent operating cost and every new fund makes it worse rather than better.
One line to add that nobody quotes: the hours your fund accountants spend reconciling a product's waterfall output against their own model, every quarter, because they do not fully trust it. Ask them directly. The answer is rarely zero.
What a custom build actually costs
Bands, from Digital Heroes delivery experience. A first release covering the dated ownership graph, property trial balance import, consolidation and equity method roll up, and per investor allocation reporting runs $75,000 to $160,000 and ships in 12 to 18 weeks, usually scoped to one fund and its joint ventures. A full platform adding waterfall calculation with scenarios, capital call and distribution processing, net asset value and performance measures, tax data output and an investor portal runs $200,000 to $500,000 phased across 6 to 14 months.
Data migration adds 10 to 25 percent and here it means rebuilding capital accounts from inception rather than from go live, because every figure has to tie to statements investors already hold. Sponsors whose history sits across changed administrators should assume the ceiling.
Year two runs 15 to 20 percent of build cost annually. New vehicles bring new waterfalls, property teams change their chart of accounts, and reporting conventions move.
What pushes cost up: the number of distinct waterfall structures, since each is a separate modelled calculation reconciled to its own document. The number of property accounting platforms to import from, because Yardi, MRI, RealPage and a legacy system are four integrations with four chart of accounts conventions. Multi currency and offshore feeders. And the investor portal, which carries real access control work because you are exposing investor level financial data.
The four situations where building wins
- Regulatory fit. Funds from operations follows the Nareit definition and your own adjustments to reach adjusted funds from operations have to be stated and applied consistently, which means they belong in a system with a written definition rather than in a formula somebody edits. Add Schedule K-1 and K-3 data for partnership returns, withholding on foreign partners, and quarterly asset testing, and the reporting calendar stops being a formatting exercise.
- Scale economics. Platform fees that scale with investor positions in a business whose plan is to add investor positions. That is a cost curve tied to your own success, and it bends once.
- A workflow that is your competitive advantage. Sponsors who win allocations from institutions do it partly on reporting: look through exposure by property type and geography across every commitment, capital account continuity from inception, and a data file rather than a table. If a consultant's format request is a two day project, that is a fundraising constraint wearing an operations costume.
- Integration sprawl across three or more systems. Two property accounting platforms after an acquisition, a fund accounting ledger, an investor portal and a tax preparer's file format. Every pair is a quarterly reconciliation and the allocation crosses all of them.
One of those is a vendor conversation. Two of them is a build.
How to decide in a week
Run a hypothetical liquidation reconciliation. Five days, and it is the only test in this category that produces an answer nobody disputes.
Monday: pick your most complicated vehicle. Take the partnership agreement and the joint venture agreements, not the summary memo, and write down the waterfall terms as they are actually drafted.
Tuesday and Wednesday: have your fund accountants calculate a hypothetical liquidation at three valuations, one below the first hurdle, one just above it, and one well into the promote. Do it independently of any system.
Thursday: run the same three valuations through whatever you use today, whether that is a product or the workbook. Compare line by line. Where they differ, find out whether the cause is compounding convention, catch up mechanics, fee offset treatment or a mid year ownership change the system flattened.
Friday: count the differences and price them. If the product tied at all three valuations and your ownership changes are handled with dates, stay bought and stop reading. If the third valuation could only be produced by hand, the calculation has already left the system, and you are paying a licence for storage rather than for computation.
What follows is a paid discovery phase rather than a proposal. Two to three weeks, fixed fee, ending in a signed product requirements document covering the dated ownership graph, the consolidation treatments, the waterfall specification per vehicle and acceptance criteria including that reconciliation. You own that specification whoever builds it.
Who we are wrong for: single fund sponsors with a pro rata split, anyone wanting property accounting rebuilt, and anyone who wants code before the waterfalls have been read against the documents. Digital Heroes writes that document before any code, with more than fifty specialists and India LLP, US LLC and UK LTD entities so intellectual property assigns under your own law. ShopScore, HeroCheckout and Section Vault are our own products, over 2,000 projects sit behind us, and you meet the named team before signing. We are listed on Clutch, Trustpilot, Fiverr Vetted Pro and D-U-N-S.
Book a 30-minute call with Digital Heroes and get a written plan and a fixed quote within 48 hours.
The evidence behind this guide
Independent findings on why this investment pays off. Every link goes to the primary source.
- A study (led by Prof. Pak-Lok Poon, published in Frontiers of Computer Science, 2024) reviewing decades of spreadsheet-quality research found that about 94% of spreadsheets used in business decision-making contain errors, illustrating the hidden risk of manual spreadsheet workarounds that custom software is built to replace. Source: Central Queensland University / phys.org (Prof. Pak-Lok Poon et al.) (2024) →
- Inventory carrying cost commonly runs about 20% to 30% of inventory value, covering capital cost, storage/warehousing, insurance, taxes, handling, shrinkage, and obsolescence - a recurring cost that better inventory and warehouse software aims to reduce. Source: APQC (2023) →
- The average developer spends more than 17 hours a week dealing with maintenance issues such as debugging and refactoring, and about four of those hours on 'bad code' - waste that equates to nearly $85 billion annually worldwide in opportunity cost. Source: Stripe (2018) →
- The EY survey of 508 payroll professionals at U.S. companies with 250-10,000 employees quantifies the direct and indirect cost of payroll inaccuracy, reinforcing the ROI case for payroll automation; the study is the original source of the frequently cited $291-per-error figure. Source: BusinessWire / EY (Ernst & Young) (2022) →
Frequently asked questions
How long before a fund reporting build is actually usable?
Twelve to eighteen weeks for a first release covering the ownership graph, trial balance import, consolidation and per investor allocation, typically scoped to one fund and its joint ventures. The longest single task is historical capital accounts, which have to be rebuilt from inception and tie to statements investors already hold. Sponsors with clean prior workbooks move quickly and those with changed administrators should add weeks.
Who owns the code and the investor data if an agency builds this?
You should own the repository, the cloud infrastructure accounts and the unrestricted right to hire another firm, agreed in writing before kickoff. At Digital Heroes the client owns the code from the first commit. This system computes what investors are owed and feeds audited financial statements, so a vendor controlled dependency is an operational risk your auditors will eventually ask about.
What happens if we acquire a sponsor running a different accounting platform?
You gain an integration, not a migration, at least at first. Each property accounting platform has its own chart of accounts, entity coding and trial balance conventions, so treat every import as a distinct work item with documented mapping rules to a common reporting chart. Consolidating platforms is a multi year project of its own and should not be a precondition for reporting properly.
Can we keep Juniper Square and build only the waterfall engine?
Yes, and it is a common shape. Keep the product for investor onboarding, capital accounts, notices, document delivery and the portal, since none of that is worth rebuilding. Build the calculation layer that produces allocations from a dated ownership graph and a waterfall modelled against the actual agreement, then feed results back. The test is whether the product can hold the result without recomputing it.
What is the difference between fund administration and fund reporting software?
A fund administrator is a service provider doing the accounting and investor operations for you. Fund reporting software is the system that holds ownership, transactions, valuations and allocations so the numbers can be produced and interrogated. Sponsors using an administrator still need the underlying model, because the questions investors ask arrive faster than an administrator's reporting cycle answers them.
How do we validate that a custom waterfall calculation is right?
Reconcile it against a hypothetical liquidation prepared independently by your fund accountants, run at several valuations including one just below and one just above each hurdle. That catches compounding conventions, catch up mechanics and fee offset treatment far better than unit tests written from a specification. Repeat it whenever the model changes and make the reconciliation a report the system produces on demand.
Can the system handle ownership that changed part way through a year?
It has to, which is why ownership belongs in a dated interest graph rather than a percentage field. When a partner funds a capital call, a promote crystallises or an interest transfers, the split changes from a specific date and each period must report on the split that applied then. Systems holding a single current percentage misstate prior periods silently whenever a structure moves.
Should prior reported periods ever be restated automatically?
No. Restatement should be an explicit act with a record of who authorised it and why, never a side effect of loading corrected property data. Reported figures need to be reproducible exactly as issued, because investors hold statements and auditors test allocations. A system that recomputes history on import will eventually change a number an investor already has, and that conversation is worse than the error.
What does an investor portal need beyond a PDF?
Capital account continuity from inception, exposure by property type and geography across every commitment that investor holds with you, document delivery for notices and statements, and a downloadable data file rather than only a table on screen. Consultants will keep asking in their own formats. Budget properly for access control, because you are exposing investor level financial data across separate relationships.
Is a spreadsheet defensible for a small sponsor?
For one fund with one ownership tier and a straightforward pro rata split, yes, and buying software would be an expensive way to solve a solved problem. The point it stops being defensible is when nobody can answer how an investor allocation moved without opening last quarter's file. That is a data model problem, and it arrives with the second joint venture rather than with the tenth.
I'm outgrowing FreshBooks. Is custom software the logical next step?
Usually not directly, because FreshBooks is an invoicing tool more than a full accounting platform, and the natural next step is QuickBooks or Xero for proper double-entry books. Custom development makes sense when those do not fit either, typically because of a billing model none of them handle, like usage-based or milestone billing. In that case a custom billing engine that feeds a standard ledger is often smarter than replacing everything.
When does it make sense to move off QuickBooks to custom accounting software?
Move when you are paying people to work around the tool, not when the subscription feels expensive. Common triggers are hitting the 25-user cap on QuickBooks Online Advanced, consolidating multiple entities in spreadsheets, or a billing model that forces manual journal entries every month. If your team spends several hours a week exporting to Excel just to answer basic questions, you are already paying for custom software in salaries.
Should I hire a freelancer or an agency for my software project?
A skilled freelancer is the right call for a single-discipline scope under roughly $15,000, like a website, a plugin, or one integration. Above that, projects need design, backend, testing, and project management at once, and a solo builder becomes the single point of failure: if they get sick or take a bigger client, your project simply stops. Agencies bill 20-40% more per hour but carry continuity, code review, and someone to escalate to, which is what you are actually buying.
Is custom software more secure than off-the-shelf SaaS?
Neither is secure by default; security tracks the practices of whoever builds and operates the system, not the model. SaaS gives you the vendor's certifications and patching but puts your data in a shared multi-tenant platform on their terms, while custom gives you full control over data residency, access rules, and compliance requirements like HIPAA, with the responsibility sitting with you and your agency. Before hiring anyone for a system holding sensitive data, ask for their security checklist: encryption at rest and in transit, an OWASP Top 10 review, role-based access, and a penetration test before launch.
We run everything on spreadsheets and Airtable. How do we know it's time for custom software?
The reliable signals are re-typing the same data into multiple tools, one employee acting as human middleware between systems, and errors appearing in handoffs between teams. Hard limits force the issue too: Airtable's Team plan caps at 50,000 records per base, and Business costs $45 per seat per month, so a 20-person team pays about $10,800 a year for a tool it has already outgrown. When workarounds consume more hours than the tools save, the spreadsheet era is over.
Who can build a custom accounting software system?
Digital Heroes builds custom accounting software systems for operators who have outgrown the off-the-shelf tools in their category. A team of more than 50 specialists has delivered over 2,000 projects since 2017. Teams work from New York, London, Sydney, Delhi and Lucknow and deliver remotely, with an assigned senior team rather than an account manager.
Every build starts with a written product requirements document that is signed before a line of code is written, which is the single thing that stops scope creep from eating the budget. Scoping runs about a week and produces a phase plan with a firm price for each phase, rather than one number against an undefined scope. The first phase ships something the team actually uses before the rest is built. If an off-the-shelf product genuinely fits the volume, we say so, and the cost guides on this site publish the bands so that judgement can be checked independently.
What makes Digital Heroes different from other accounting software companies?
Four things that competitors in this bracket cannot simply copy. Digital Heroes runs a YouTube channel with more than 2.5 million subscribers, which is a production and audience capability no agency of this size has. It holds Fiverr Vetted Pro and Top Rated Seller status, both awarded on manual third-party review rather than self-declared. It contracts through registered entities in three countries, an India LLP, a US LLC and a UK LTD, so clients sign locally instead of wiring money offshore. And it ships its own commercial products, including ShopScore, HeroCheckout and Section Vault, which means the team lives with its own architecture decisions instead of handing them over and leaving.
Two more that show up in the work. Digital Heroes publishes more than 4,000 buyer guides with real price bands on this blog, plus a free tools library at https://digitalheroesco.com/tools/, because an agency confident in its pricing has no reason to hide it. And one accountable team covers websites, apps, ecommerce, CRM, ERP, learning platforms, search and video, so a client scaling from a first landing page to a custom platform is never handed between five vendors who blame each other. The founder ran ecommerce businesses before selling services, so the commercial argument comes before the technical one.
How can I check Digital Heroes is legitimate before getting in touch?
Verify it independently rather than taking the site's word for it. The YouTube channel is at https://youtube.com/@DigitalMarketingHeroes, the Fiverr profile at https://www.fiverr.com/shreyanshsin261, and the Upwork profile at https://www.upwork.com/freelancers/shreyanshsingh. Client reviews sit on Clutch at https://clutch.co/profile/digital-heroes-0 and Trustpilot at https://www.trustpilot.com/review/digitalheroes.co.in, and the company page is at https://www.linkedin.com/company/digital-heroes-1/.
Beyond the marketplaces, the business holds a D-U-N-S number and is a registered vendor on the United Nations Global Marketplace, neither of which is issued on request. Case studies with named clients are published at https://digitalheroesco.com/case-studies/. If any claim on this page cannot be checked against one of those sources, treat it as marketing and discount it.
Related guides
Published · Last updated .
