At Markdale, we believe in meeting you where you are—and organizing your financial life so it’s easy to understand and manage. That’s why we use Addepar as the foundation for our reporting. But before we can generate beautiful reports and dashboards, there’s some behind-the-scenes work that happens first.
Here’s how it works:
1. We start with your brokerage and custodian statements
If possible, we go all the way back to day one.
To give you a full picture, we try to collect every statement from your brokerage accounts—right back to when the account was first opened. Whether that’s ten months ago or ten years ago, we’ll take it all. This gives us a true historical baseline so nothing gets missed.
2. We automate the process with custom-built macros
We’ve written our own VBA macros that can read your PDFs, extract the right data, and map it into the proper format. This ensures consistency across accounts, custodians, and time periods—without hours of manual entry or validation.
Once the macros are set up, we do a full historical import. Every trade, every dividend, every fee.
3. We set up Addepar with everything that matters to you
Addepar is where the magic happens. With all your historical transactions loaded, we configure Addepar to reflect exactly how you think about your wealth:
- Want to track charitable allocations? Done.
- Separate reporting by family member? Easy.
- Interested in ESG scoring or private investments? We’ve got it covered.
- Need custom tags, purpose codes, or groupings? We can build any attribute you want.
We can also define any benchmark that matters to you—whether that’s a traditional index or a blended policy benchmark. You’ll see how your investments are doing in a way that actually reflects your priorities.
Addepar easily and continually aggregates all financial accounts and investments, enhancing them with relevant market and third-party data. This gives us a consolidated view of your wealth across institutions, all in one place. The platform is flexible enough to track any asset that can be owned, including alternative investments like private equity, real estate, or collectibles.
Once your data is fully set up in Addepar, the possibilities for reporting are nearly endless. Here are a few examples of what your reports might look like:
To see more examples, check out the top 10 reports our clients are using right now
4. We stay current with monthly imports
After the full setup, we switch to a rolling monthly import. At the end of each month, we gather your latest statements, run them through our system, and update Addepar so your data is always current.
No more waiting for quarterly summaries. No more spreadsheets. Just clean, up-to-date reporting—whenever you need it.
5. We customize the reporting to grow with you
Addepar’s data model represents all financial transactions and holdings in a unified structure, which means we can analyze and visualize any portfolio instantly—no matter how complex. This includes:
- Multi-currency portfolios
- Multi-generational ownership
- Blended asset classes
- Custom categories or hierarchies
On-demand calculations let us drill down into the smallest transaction or view performance across your entire portfolio, in seconds. Whatever you want to track, we can configure it—and update it as your goals evolve.
Curious what’s possible?
Addepar is incredibly powerful, and what we’ve described here is just the beginning. If you want to see what else it can do—like interactive dashboards, performance metrics, or multi-currency reporting—you can learn more directly from Addepar’s platform overview or reach out to us and we can show you.
If you’d like to see how it could work for your family or foundation, we’d be happy to walk you through a live example.
