Migration vs. Starting Fresh: When to Cut Bait on Old Data
- Jun 23
- 16 min read
The instinct is always to migrate. Your historical data feels valuable. You spent years building it. Throwing it away seems wasteful.
Sometimes it is wasteful. Sometimes it's the smartest financial decision you'll make all year.
For Shopify sellers facing a major accounting transition, the question isn't always "how do we move everything?" Sometimes it's "should we move anything at all, or just start clean?" The answer affects your migration cost by 50-200% and determines whether the project finishes in 6 weeks or 6 months.
This guide walks through the actual decision framework for when migration makes sense versus when starting fresh is the better call.
💡 Key Takeaways
Starting fresh saves 40-70% on migration costs when old data has fundamental quality problems
Migration makes sense when historical data is mostly clean and multi-year reporting matters
Starting fresh makes sense when cleanup cost approaches or exceeds the value of historical data
The break-even calculation compares migration cost plus cleanup against starting fresh plus reconstructed reporting
Most decisions fall into "hybrid": migrate recent data, start fresh on older problems
Audit and tax requirements can override the financial decision; check requirements before deciding
Starting fresh is irreversible; migration can always be reduced in scope, but you can't un-discard data
What does "starting fresh" actually mean?
Starting fresh means abandoning your existing accounting data and building from scratch in your new system. The terminology varies (some call it "restart," "rebuild," or "cutting bait") but the concept is the same.
What gets discarded in a fresh start
Historical transaction detail in the accounting system
Categorization decisions from prior bookkeepers
Reconciliation history
Custom reports and report templates
Audit trail from the old system
Methodology choices that weren't documented
What stays accessible even after starting fresh
Source documents (bank statements, receipts, invoices)
Shopify transaction data (lives in Shopify, not affected)
Tax filings already submitted
CPA records and prior year tax returns
Bank and credit card statements
Customer and vendor information in Shopify
What gets created in the new system
Opening balances as of the start date
Going-forward transaction recording
New chart of accounts (often improved)
Fresh categorization methodology
Clean reconciliation history starting day one
The data still exists in source systems. You just don't import it into your accounting platform. That's the key distinction.
What's the difference between migration, partial migration, and starting fresh?
Three approaches solve the same problem with different tradeoffs.
Full migration
All historical data moves from the old system to the new system. The new system has the complete historical record.
When this makes sense:
Historical data is mostly clean
Multi-year reporting is required
M&A or audit history matters
Continuity is critical
Partial migration
Recent data (typically 12-24 months) migrates with full detail. Older data either stays in the old system as reference or gets converted to summary opening balances.
When this makes sense:
Recent data is clean but older data has issues
You need current period detail but not deep history
Cost of migrating older data exceeds the value
You're balancing cost with continuity
Starting fresh
No historical data migrates. The new system starts with verified opening balances only. Historical data stays accessible in source systems if needed.
When this makes sense:
Historical data has fundamental quality issues
Cleanup cost approaches or exceeds migration cost
Historical reporting isn't critical for ongoing decisions
You're treating this as a strategic reset
Side-by-side comparison
Factor | Full Migration | Partial Migration | Starting Fresh |
Cost | Highest | Moderate | Lowest |
Timeline | Longest | Moderate | Shortest |
Historical reporting | Complete | Partial | Limited |
Risk of inheriting problems | High | Moderate | None |
Audit defense | Strongest | Adequate | Weakest |
Year-over-year analysis | Complete | Partial | Starts from day one |
Best for | Strong, accurate historical data | Mixed quality historical data | Problematic historical data |
Most sellers don't realize that partial migration is even an option. They assume it's all-or-nothing. It isn't.
When should I seriously consider starting fresh?
Several scenarios make starting fresh genuinely the better option. Knowing these helps you spot when it applies to you.
Scenario 1: Cleanup cost approaches migration value
You get a quote for migrating your historical data and discover that cleanup alone costs $12,000. Meanwhile, starting fresh with verified opening balances costs $3,000.
If your reason for migrating was "preserve the history," ask whether that history is worth $9,000 more than a clean restart.
The calculation:
Migration with cleanup: $15,000
Starting fresh with opening balances: $3,000
Difference: $12,000
Question: Is your historical detail worth $12,000?
For most small to mid-size Shopify sellers, the answer is no.
Scenario 2: Historical data has fundamental problems
Your old books have systemic issues:
Categorizations changed multiple times over the years
Personal and business funds were mixed
Sales tax wasn't tracked by jurisdiction
Reconciliations were sporadic at best
Multiple bookkeepers used different methodologies
Migrating this data means inheriting all of its problems. Cleanup might fix surface issues, but the underlying methodology inconsistencies persist.
Starting fresh lets you build the system you should have had from the beginning, with consistent methodology going forward.
Scenario 3: You're switching platforms with major structural differences
Migrating from QuickBooks Desktop to QuickBooks Online preserves most data structure. Migrating from a spreadsheet-based system to QuickBooks Online doesn't. The data formats don't map cleanly.
When the new platform requires fundamentally different data structures than the old one, the cost of forcing old data into the new format often exceeds the cost of starting clean.
For platform-specific guidance, see our QuickBooks Desktop to QuickBooks Online migration guide.
Scenario 4: You're rebuilding methodology from scratch anyway
If you're switching from cash basis to accrual basis (or vice versa), changing your chart of accounts entirely, or restructuring how you track inventory, you're already doing a methodology reset.
Migrating old data just means converting it to the new methodology, which is essentially reconstruction. At that point, starting fresh is cleaner and often cheaper.
Scenario 5: Historical data isn't needed for decisions
Some businesses genuinely don't use historical data for analysis. They look at current month, current quarter, and tax filings. They don't run year-over-year comparisons or multi-year trends.
If you're in this category, the historical data isn't valuable to you. It's just inventory you're paying to move.
Scenario 6: Tax filings are simple and current
If your tax filings are straightforward, recent, and don't require multi-year reconstruction, starting fresh is low-risk.
The main reason to preserve historical accounting data is documentation for tax compliance and potential audits. If your tax situation is clean and current, this concern diminishes.
For more on related tax considerations, see our guide on AI Shopify sales tax compliance.
Scenario 7: You're being acquired or selling assets, not the company
If you're selling specific assets rather than the entire business entity, the acquiring party rarely needs your historical bookkeeping data. They're conducting their own valuation based on the assets being transferred.
Starting fresh for your remaining operations (or your post-transaction entity) makes more sense than preserving data that's no longer relevant.
When should I definitely migrate rather than start fresh?
Some situations make migration the clearly better choice. Don't start fresh in these scenarios.
Scenario 1: Multi-year audit risk
If you're being audited or have audit exposure, you need detailed historical records. Starting fresh creates gaps that auditors don't accept.
The IRS can audit returns for 3-6 years (longer in cases of substantial under-reporting). State tax authorities can audit even further back. Without historical data in your accounting system, you're relying entirely on source documents (bank statements, invoices, etc.), which is harder to defend.
Scenario 2: M&A activity or financing in progress
Lenders and acquirers want historical financial data. They use it to assess trends, evaluate management, and verify accuracy of recent reporting.
Starting fresh during an active financing or M&A process raises immediate red flags. It looks like you're hiding something even when you're not.
If a major transaction is coming, complete the migration with historical data preserved, then make strategic decisions about cleanup or restructuring after the transaction closes.
Scenario 3: Multi-year reporting is core to your business
Some businesses depend on year-over-year analysis for fundamental decisions:
Seasonal product businesses comparing the same period across years
Subscription businesses tracking cohort metrics over time
Brand businesses evaluating long-term marketing ROI
Investor-backed companies with multi-year reporting requirements
In these cases, the historical data is genuinely valuable. Preserve it.
Scenario 4: Recent (12-24 months) data is largely clean
If the issues are mainly in older periods but recent data is solid, partial migration is often the right answer. Migrate the clean recent data. Treat older data as opening balances or summary entries.
Starting fresh entirely throws away usable recent data. That's wasteful when partial migration is cheap.
Scenario 5: Switching to similar platforms with good migration tools
QuickBooks Desktop to QuickBooks Online has Intuit's official migration tool. Wave to QuickBooks Online has reasonable conversion options. Xero to QuickBooks Online has third-party migration services.
When good migration paths exist and the source data is reasonable, use them. The marginal cost of migration is low when the tools handle most of the work automatically.
For more on this, see our guide on how to migrate historical Shopify data without losing detail.
Scenario 6: Multi-year tax planning requires it
CPAs often use multi-year data for strategic tax planning: loss carryforwards, depreciation schedules, R&D credits, etc.
Talk to your CPA before deciding to start fresh. They may need historical detail you're considering discarding.
Scenario 7: Documentation of business decisions
Your accounting data documents the financial impact of business decisions over time. Equity transactions, owner draws, capital contributions, intercompany transfers between related businesses all leave a trail in accounting records.
If you have a complex ownership or business structure, historical accounting documentation may be more valuable than it appears.
How do I calculate whether to migrate or start fresh?
A simple framework helps make this decision objectively rather than emotionally.
Step 1: Quote the migration option
Get a detailed quote covering:
Migration of historical data (typically 12-24 months as primary)
Older historical data approach (full, partial, or summary)
Cleanup work needed on migrated data
Reconciliation through the migration period
Documentation and methodology setup
Step 2: Quote the starting fresh option
Get a detailed quote covering:
New system setup
Opening balance reconstruction
Initial methodology design
First 90 days of operation
Any source document organization needed
Step 3: Calculate the difference
Migration cost minus starting fresh cost equals "the price of preserving historical detail in your accounting system."
Step 4: Assess the value of that detail
Honestly answer:
Will I use historical accounting data for decisions in the next 12 months?
Does my CPA need historical accounting detail for tax work?
Am I facing audit risk that requires historical defense?
Will multi-year reporting affect business decisions?
Is M&A or financing on the horizon (12-24 months)?
Step 5: Compare value to cost
If the value of historical detail exceeds the cost of preserving it, migrate.
If the cost exceeds the value, start fresh.
If they're close, the right answer is often partial migration (preserve recent data, accept summaries or fresh start for older data).
A concrete example
A Shopify seller doing $750K annual revenue is migrating from Wave to QuickBooks Online with bookkeeper change.
Migration option:
Wave-to-QBO migration with cleanup: $8,500
24 months of A2X backfill: $1,200
Older data summary entries: $1,500
New bookkeeper onboarding: $1,000
Total migration approach: $12,200
Starting fresh option:
New QBO setup with opening balances: $2,500
A2X setup with go-forward sync only: $500
New bookkeeper onboarding: $1,000
Total starting fresh approach: $4,000
Difference: $8,200
The question becomes: is the historical Wave data worth $8,200 to this seller?
If they don't run multi-year analysis, don't have audit exposure, and aren't facing financing decisions, the answer is no. Starting fresh saves $8,200 with manageable downside (Wave data remains accessible for reference if needed).
If they're applying for SBA financing in 6 months, the answer is yes. The lender will want 2-3 years of accounting data, and providing it from a single system is far cleaner than explaining the transition.
What's the actual risk of starting fresh?
The fear of starting fresh is usually larger than the actual risk. Understanding the real downside helps make an informed decision.
Real risk 1: Lost analytical capability
You lose the ability to run reports comparing this year to last year (in the new system) until 12 months pass with the new system.
Mitigation: Keep the old system accessible (read-only) for the first 12-18 months. Run comparison reports from the old system when needed.
Real risk 2: Tax audit complications
If audited, you'll provide source documents (bank statements, invoices) rather than accounting system records.
Mitigation: Maintain organized source document archives. This is required regardless of whether you migrate or start fresh, but it becomes more important when the accounting system doesn't have the detail.
Real risk 3: Re-discovering old errors
Sometimes the old system, despite its problems, contained important information that gets lost. Owner contribution amounts, equity adjustments, related-party transactions.
Mitigation: Do a thorough opening balance reconstruction. Document all major transactions affecting equity and owner accounts. Cross-reference with prior tax returns to verify accuracy.
Real risk 4: Future surprise requirements
Three years from now, you discover you need 5-year financial data for a financing application or M&A discussion.
Mitigation: Keep the old system accessible. If you ever need historical data, you can extract it from the source system. It's just not actively maintained in your current accounting platform.
Less-real risk: "Losing" your business history
Most sellers feel emotional attachment to historical accounting data. It represents years of work. Discarding it feels wrong.
This is rarely a financial concern. It's an emotional one. Your business history doesn't live in your accounting system. It lives in your Shopify store, your bank statements, your tax returns, your customer relationships.
Starting fresh in accounting doesn't erase your business. It just resets one specific tool you use to manage it.
What's the hybrid approach most sellers actually use?
The decision isn't binary. Most successful migrations use a hybrid approach that takes the best of both options.
The typical hybrid pattern
Time Period | Approach | Reasoning |
Current period (cutover forward) | Full live sync | Clean methodology going forward |
Last 12 months | Full backfill via sync tool | Recent data is usually clean enough |
12-24 months | Backfill if Premium plan, otherwise summary | Available but lower value |
24-60 months | Summary opening balances or skip | Detail cost exceeds value |
60+ months | Don't migrate; reference via old system | Negligible operational value |
This approach:
Preserves the most useful detail (recent data)
Accepts limitations on older data
Minimizes cost
Provides clean methodology going forward
Keeps old data accessible if ever needed
When the hybrid approach doesn't work
Audit defense requires consistent multi-year data in a single system
M&A due diligence requires unified historical reporting
Multi-year trend analysis is core to business decisions
Regulatory requirements specify accounting system retention
If any of these apply, full migration is the right answer despite the cost.
How to scope a hybrid approach
When working with a bookkeeper or migration specialist, ask for quotes on three scenarios:
Full migration with maximum historical detail
Hybrid migration with recent detail and older summaries
Starting fresh with opening balances only
The cost difference between these tells you the price of historical detail. Then you decide what level of detail justifies the cost.
For broader context on this decision-making framework, see our complete Shopify accounting migration checklist.
How does this fit into the broader migration framework?
The migration-versus-starting-fresh decision shapes everything else in your migration project.
The decision affects:
Timing: Starting fresh is faster (see our mid-year vs. year-end migration timing guide)
Cost: Starting fresh is cheaper (see our Shopify catch-up bookkeeping cost guide)
Bookkeeper selection: Some bookkeepers specialize in clean restarts vs. cleanup work (see our switching bookkeepers guide)
Sync tool setup: Starting fresh means no backfill complications (see our native integration to A2X switching guide)
DIY to professional transitions: Sometimes the transition is the right time to also start fresh (see our DIY to professional bookkeeper guide)
Don't decide on migration timing, bookkeeper selection, or tool configuration until you've decided on migrate vs. start fresh. The other decisions flow from this one.
What if I'm not sure whether to migrate or start fresh?
This decision is hard. It's also reversible in one direction (migration scope can always be reduced) but not the other (you can't un-discard data).
When you can't decide, default to migration
If you genuinely can't tell whether to migrate or start fresh, migrate. You can always treat older data as "for reference only" and not actively maintain it. The cost premium isn't huge, and you preserve optionality.
Get a second opinion
If your bookkeeper recommends one approach, ask why. Get a competing quote from another bookkeeper or migration specialist. Different professionals will have different perspectives based on their experience.
Talk to your CPA
Your CPA has visibility into tax compliance, audit risk, and long-term planning considerations you may not see. Ask whether starting fresh creates any problems for tax work.
Check your business stakeholders
If you have investors, board members, or partners, they may have reporting expectations you should consider. Starting fresh affects their analysis too.
Don't decide under time pressure
If you're being pressured to start fresh because "it's faster," push back. The cost of a wrong decision here is significant. Take an extra week to think it through. Migration timelines can usually flex by a few weeks; starting fresh decisions can't be undone.
What about partial restart within migration?
A nuanced option: migrate selectively, treating different account areas differently.
Selective restart approach
Account Area | Approach |
Bank and credit card | Migrate with full reconciliation |
Shopify sales (recent) | Full backfill via sync tool |
Older Shopify sales | Summary entries or skip |
Inventory | Start fresh with current count |
Sales tax | Start fresh with current jurisdictional setup |
Vendor history | Migrate names; skip historical detail |
Customer data | Lives in Shopify; not migrated to accounting |
Equity accounts | Migrate completely |
This works because different account areas have different value-to-cost ratios. Equity history is irreplaceable and cheap to migrate. Inventory history is expensive to migrate and often inaccurate. Migrate what's valuable; restart what isn't.
When selective restart makes sense
Different account areas have different data quality
Some areas are easy to migrate, others require extensive work
Cost-benefit analysis varies by account area
You want the best of both approaches
When selective restart doesn't work
All account areas are interconnected
Methodology consistency across all areas matters more than perfect data
The complexity of managing mixed approaches exceeds the savings
For most Shopify sellers, full hybrid (recent data fully migrated, older data summarized or skipped) is simpler than account-level selective restart.
How does starting fresh affect future audits and tax filings?
This is the question that worries sellers most. Here's the honest answer.
IRS audit considerations
The IRS can audit returns going back:
3 years for ordinary returns
6 years if there's substantial under-reporting (25%+)
Indefinitely if there's fraud
For most legitimate business situations, 3-year audit defense is the practical concern.
What's needed for audit defense
Auditors want:
Documentation supporting reported income
Documentation supporting reported expenses
Documentation supporting tax positions taken
Reasonable explanation of methodology
This can be provided from source documents (bank statements, invoices, receipts) without requiring the accounting system to contain the historical detail. The accounting system makes it easier; it's not the only path.
How starting fresh affects this
If you start fresh, your audit defense relies on:
Source documents organized by year
Tax returns and supporting workpapers
Bank statements and reconciliations
Vendor invoices and receipts
Shopify reports for relevant periods
If you've maintained these source documents properly, you can defend an audit. It takes more work than pulling reports from an accounting system, but it's doable.
State and local audit considerations
State tax authorities (especially sales tax) often audit further back than the IRS. Some states can go back 7-10 years for sales tax.
If you have substantial multi-state sales tax exposure, this may push toward migration even if other factors favor starting fresh.
For sales tax specifics, see our guide on AI Shopify sales tax compliance.
Practical mitigation for fresh starts
When you start fresh:
Archive source documents in organized format
Keep old accounting system accessible (read-only)
Document the transition date and methodology change
Maintain prior year tax returns and workpapers
Ensure CPA has access to historical filings
With these practices, starting fresh doesn't significantly increase audit risk.
Can I do this evaluation myself, or do I need help?
Some aspects of this decision require professional judgment.
You can evaluate yourself if:
You understand your reporting needs
You can honestly assess your data quality
You have time to think through the implications
You don't have major audit, M&A, or financing exposure
Your business situation is reasonably simple
Get professional help if:
You're not sure about audit or tax implications
M&A or financing is in progress or near-term
Your business has complex ownership or related-party structures
You don't have time for a thorough evaluation
The decision affects more than just bookkeeping
For most Shopify sellers, getting both a migration quote and a starting fresh quote from a qualified bookkeeper is the right first step. The quotes themselves become an evaluation tool.
For DIY-vs-hire context on migration decisions, see our guide on when DIY Shopify bookkeeping stops being worth it.
The Bottom Line
Migration feels safe because it preserves continuity. Starting fresh feels risky because it discards history. For many situations, these instincts are exactly backwards.
When historical data is clean and reporting needs are real, migration is the right call. When historical data has fundamental problems and cleanup costs approach migration value, starting fresh is genuinely smarter.
The biggest mistake we see isn't choosing wrong. It's not asking the question at all. Sellers assume migration is the default and never consider that starting fresh might save them $5,000 to $15,000 while improving their go-forward operations.
Ask the question. Run the numbers. Talk to your CPA. Make an informed decision based on your actual business needs and budget, not on what feels emotionally safer.
Starting fresh isn't quitting. It's strategic prioritization. Done at the right time, with proper opening balance reconstruction and source document preservation, it's often the most financially intelligent choice available.
Ready to decide between migration and starting fresh?
Most Shopify sellers we work with never seriously considered starting fresh until we suggested it. Once they ran the numbers, the decision sometimes became obvious. Other times, migration remained the right call. Either way, the explicit comparison surfaced clarity they didn't have before.
At Catch Up Clean Up, we help Shopify sellers think through this decision honestly. We quote both migration and starting fresh options. We point out the tradeoffs. We recommend hybrid approaches when they make sense. The goal is the right decision for your business, not the largest possible project.
What you get:
A 30-minute scoping call to assess your specific situation
Honest assessment of your historical data quality
Quotes for migration, hybrid, and starting fresh approaches
Discussion of audit and tax implications with your CPA
Recommendation based on your business needs
Execution of whichever approach we agree on
Book a free consultation and let's figure out the right approach for your situation.
Frequently Asked Questions
When should I start fresh instead of migrating my Shopify accounting data?
Start fresh when historical data has fundamental quality problems (systemic categorization issues, mixed personal and business funds, sporadic reconciliations), when cleanup cost approaches or exceeds migration value, or when historical reporting isn't critical for ongoing business decisions. Starting fresh saves 40-70% on migration costs in these situations.
How much money can I save by starting fresh instead of migrating?
Starting fresh typically saves $5,000 to $15,000 for small to mid-size Shopify sellers compared to full migration with cleanup. The savings depend on data volume, cleanup complexity, and the number of historical years involved. For very problematic historical data, savings can exceed $20,000.
Will starting fresh hurt me in a tax audit?
Not significantly if you maintain organized source documents. Tax audits require documentation of income, expenses, and tax positions, which can come from bank statements, invoices, and receipts rather than the accounting system. Starting fresh makes audit defense more work but not impossible. Keep your old accounting system accessible as a reference.
Can I migrate some data and start fresh on other data?
Yes. Hybrid approaches are common: migrate recent data (12-24 months) with full detail, summarize or skip older data, and treat certain account areas (like inventory) as fresh starts even within the migration. This balances cost with continuity. Most successful migrations use some hybrid approach.
What does my historical Shopify data look like if I start fresh?
Your Shopify data stays in Shopify regardless of accounting system decisions. Orders, customers, products, and reports remain accessible in Shopify Admin indefinitely as long as your Shopify account is active. Starting fresh in accounting doesn't affect your Shopify data at all.
Can I change my mind after starting fresh?
Migration scope can always be reduced, but starting fresh can't be undone easily. You can't recover detail in your accounting system after discarding it. If you start fresh and later need historical detail, you'd have to extract it from source documents (the old accounting system, bank statements, Shopify reports) and recreate it manually. Default to migration if you're uncertain.
What happens to my CPA's work if I start fresh?
Your CPA's prior year work remains valid. Tax returns are already filed based on data that existed at the time. Workpapers and supporting documentation stay accessible. Going forward, your CPA works from the new system. Talk to your CPA before deciding to start fresh, especially if multi-year tax planning (loss carryforwards, depreciation schedules) is involved.
Comments