Scaling software

Protecting PMC financial history data: A 4-step process

4/10/2026

Four steps to financial continuity (and what happens when PMCs migrate without it)

Picture this: it’s January 1st with a new property, and pressure is on to collect rent. Except there’s zero historical data in your property management system. You’re scrambling to get tenants entered, but there’s no time to input anything but their basic details.

Owners face losses, because outstanding balances weren’t recorded. Tenants get frustrated, because you’re trying to collect rent they prepaid.

It’s an entirely predictable failure. Yet somehow, when onboarding a big property or changing management systems, it’s the norm.

Mike Schmansky, founder and CEO at Red Cedar Advisory Services, is on a mission to change that. After a decade’s experience building property management operations for 5,000+ multifamily units, Mike wanted to help other PMCs build rock-solid processes.

Today, Mike shares Red Cedar’s 4-step process for one of the trickiest moments in a PMC’s story: onboarding a large property into your system, or changing property management systems entirely.

“We've helped a lot of companies not just get up and running, but bring in valuable historical information. That’s what it takes to build a system people trust when they’re making decisions.” _{— Mike Schmansky, founder and CEO at Red Cedar Advisory Services}

Why financial continuity is the bedrock of a successful transition
How to identify, clean, and migrate your most important historical property data
When to be skeptical about standard property management system vendor advice
What to do in the last month pre-transition to avoid launch day chaos

Property management growth needs accounting rigor

Outgrowing your property management tool, especially when you onboard a very large property, is a natural part of growing your business.

More square footage, more tenants, more vendors—it all adds more complexity and risk, and it calls for more granular record-keeping. “As you scale, you need to know what you’re spending on paint or plumbing,” explains Mike. “Those numbers tell a story. If water bills are through the roof, you could be dealing with a leak.”

Yet many companies migrate with bad quality data, or none at all. It’s like turning the page on a new chapter, but burning the story you’ve written so far.

But over and over again, that’s what happens. Teams know their data history matters, but feel overwhelmed and under-resourced to plan a migration. Tool vendors are telling them to “just start fresh,” so they think “okay, we’ll figure it out.”

And, sure—adopting a new system or onboarding a property is simpler when there’s no data to migrate. But you’ll pay for it the entire time you use that system, and the first 12 months are especially painful.

The continuity bedrock of a property transition

Historical data is infrastructure. It supports good decisions, accurate reports, and understanding of your business performance. If you migrate without it, you’re throwing away a year of ROI. Even after that, visibility is compromised forever.

That’s why financial continuity makes or breaks a PMC transition. When you implement a new system, or onboard a large property, data migration is non-negotiable.

"It’s important that your system is a source of truth for the entire time you've owned a property. If you go in blind, you wait a year to see the full picture.” _{— Mike Schmansky}

Four steps to a data-driven PMC migration

Data continuity won’t happen by accident. Migration is a big project, and it needs to be resourced and planned for.

By treating historical migration as an essential project, with defined steps and quality checkpoints, you can set your company’s new era up for success.

Step 1: Identify your must-migrate data

First up: what do you need to migrate? Decide which categories of data, in which timeframe, are essential to hit the ground running.

To help you get clarity, try working backward from reporting deliverables. What historical data will you need to populate them?

For most property managers, that’s T12 income statements, life-to-date reports for lenders, occupancy trends, and owner and investor expectations. They’ll require at least 12 months of transactions (or current and prior fiscal year), and potentially capital expenditure tracking and investor reporting from the entire life of the property.

Step 2: Assess data quality and refine as needed

Historical data is only valuable if it's accurate. Once you know what data you’re migrating, you’ll be able to assess its quality, and plan to reorganize it or fill gaps as needed.

In real-world terms, this often means prepaid rent or late payments—outliers that lead to first-day chaos and inaccurate reporting if they’re not recorded.

Mike recommends using a data quality checklist. For each tenant or vendor, note down:

Lease or contract terms and status
Outstanding balances or open invoices
Prepayments and deposits
Capital expenditure categorization
Date of assessment

“You need a good foundation, or historical data will create inconsistencies in your new system,” says Mike. “It can be complicated to prepare data for accuracy, but it’s part of getting value from your new system."

Step 3: Ensure the new system can process your data

Clean source data is the starting point, not the finish line. Your system needs to be able to analyze new and historical data together, without silos. For example, prepayments from last month should credit against next month’s charge.

At this stage, work closely with your implementation team and system provider to support structured data mapping into the new system. Set consistent rules for:

Account code mapping
Transaction categorization
Tenant balance calculation
Vendor payment application
Bill and expense categorization

This may sound technical, but the end goal is simple. “Does the system know what existed the day before we took over?” Mike asks. “Can it handle the transactions correctly going forward?" Take water bills—they’re commonly miscoded as sewer expenses, which tenants aren’t responsible for.

Step 4: Double-check output to get decision-ready before day one

To make sure everything’s running smoothly, you’ll want to thoroughly validate the new system’s output. Are balances and accounts consistent across both systems, and old and new datasets?

Plan validation checks before going live, comparing reports from new and old systems for accuracy.
After launch, run parallel validation for your first month and continue comparing reports.
Before sending off your first external reports, like T12s or owner statements, put them through extra review with your finance team.
Update stakeholders about the migration. Explain report formatting changes, emphasize that you’re preserving financial continuity, and highlight the advantages of the new system.

If you’ve laid the groundwork, managers will trust the system enough to use it for real decision-making, right away. That means you’re set up for success, not chaos, on launch day and through your first year.

Trustworthy systems that support owners’ bottom line

At these big moments, millions of dollars and hundreds of homes are on the line. PMCs need their systems to deliver the operational ease they promise. Data continuity is the path to get there.

“When people trust their property management system, they make decisions faster. They’re not feeling like they need to double-check against a parallel accounting system like Quickbooks or bank accounts. The system is a source of truth on a real-time, daily basis.” _{— Mike Schmansky}

That translates into clean accounting, efficient operations, and happier relationships. “Kicking off a transition with clean, historical data means you’re closing month-end in under a week, and sending out accurate reports from day one,” Mike advises. “That’s a good way to build trust, and keep your customers happy.”

As PMCs grow, they need systems to manage their data. Revela helps you move from chaos to clarity, speed, and integrity.