Accounting Data Migration: How to Switch Without Losing Data

Switching accounting software can seem straightforward, but not everything in your old system will necessarily move with you. Historical transactions, unpaid invoices, opening balances, attachments, and other accounting records can be lost or transferred incorrectly if you don’t handle the migration properly.

A successful accounting data migration is about transferring what you need, preserving what you don’t, and making sure your new books start with accurate data. If you’re switching to software like QuickBooks Free, here are the steps I recommend:

What is accounting data migration?

Accounting data migration simply means moving your business’ financial records from one accounting system to another. You decide which records need to move, prepare them for the new system, and preserve anything that won't transfer.

This may include your customer and vendor lists, unpaid invoices and bills, account balances, and transaction history. Some older records may not need to move, but you should still keep a copy in case you need them later for taxes, reporting, or reference.

The goal isn’t to move everything. It’s to make sure the financial information you need to continue running your business is complete and accurate in the new system. That starts with deciding exactly which accounting data needs to make the move.

What accounting data should you migrate?

Before you start moving anything, decide which records you actually need in the new system. For a small business, that usually means the information needed to keep invoicing customers, paying bills, tracking cash, and producing accurate financial reports without interruption.

Depending on your business and the capabilities of your new software, this may include:

• Chart of accounts: The list of accounts used to organize your income, expenses, assets, liabilities, and equity.
• Customers and vendors: Names, contact details, payment terms, and other information you still use.
• Unpaid invoices and bills: Open amounts customers owe you and bills you still need to pay.
• Account balances: Your bank, credit card, loan, asset, and other balances as of the date you switch systems.
• Transaction history: Past sales, expenses, payments, deposits, and other transactions you want available for reference or reporting.
• Products and services: Items you use when creating invoices or recording sales.
• Inventory: Quantities, costs, and values if your business sells physical products.
• Payroll and tax records: Historical information you may need for payroll, tax filings, or future reference.
• Supporting records: Receipts, invoices, attachments, and other documents linked to your transactions.

You don't necessarily need years of transaction history inside the new software. In some cases, bringing over your current balances and open transactions while keeping older records safely archived can give you a cleaner starting point.

How to migrate accounting data to new software

A successful migration starts with a clear plan for what to move, how to move it, and how to verify that your financial records remain accurate after the switch. 

Step 1: Decide what data needs to move

You don't have to bring every transaction you've ever recorded into your new accounting software. Before migrating, choose a cutoff date, which is when your old system stops being your active set of books and your new system takes over.

You can then decide how much history you want available in the new system:

For example, if you switch on January 1, you might enter the closing balances from December 31 as your beginning balances instead of importing several years of individual transactions. Your older records can remain archived for tax, audit, and reference purposes.

The right approach depends on how much historical detail you need and what your new software can actually accept.

Step 3: Back up and archive your accounting records

Before moving any data, create a complete backup or archive of your old books. This gives you an original set of records to fall back on if something doesn't transfer correctly.

Don't rely only on the file you're using for the migration. Save copies of important accounting records separately, including:

• General ledger and trial balance
• Balance sheet and profit and loss statement
• Accounts receivable and accounts payable aging reports
• Bank and credit card reconciliation reports
• Payroll and tax records
• Inventory reports, if applicable
• Customer and vendor lists
• Receipts, invoices, and other supporting documents

Pay particular attention to attachments and historical reports. Some information available in your old software may not transfer to the new system even when the main transaction data does.

Keep these records in a secure location and organize them by year or reporting period so they're easy to retrieve later.

Step 4: Set up your new accounting system

Before importing your records, set up the basic accounting structure in the new software. This gives your migrated data somewhere to go and reduces the risk of transactions ending up in the wrong accounts.

Start by reviewing or setting up:

• Business information: Confirm your business name, address, fiscal year, and other company details.
• Chart of accounts: Make sure the accounts you'll need for income, expenses, assets, liabilities, and equity are available.
• Accounting method: Confirm whether you use cash- or accrual-basis accounting.
• Products and services: Set up the items you'll need for invoices and sales transactions.
• Sales tax settings: Configure applicable tax settings before bringing over taxable transactions.
• Tracking options: Set up any categories or other tracking features your new software supports and that you plan to use.

For example, if you're moving to QuickBooks Free, take some time to review your business and accounting settings before bringing over your records. You don't have to recreate every account or category from your previous software. Only bring over those you still need to accurately track your business going forward.

Step 5: Map your accounting data

Different accounting systems may organize the same information differently. Before importing your records, determine where each type of data from your old system belongs in the new one. This process is called data mapping.

For example, an expense account called “Software Subscriptions” in your old system might need to be matched to “Software & Apps” in the new system. The names don't have to be identical, but the account type and purpose should be correct.

Pay particular attention to your chart of accounts. Mapping an account incorrectly can affect your financial statements even if every transaction imports successfully. For example, mapping a loan to an income account could make your revenue and liabilities incorrect.

Step 6: Export and import your data

Once your data is mapped, export the records from your old accounting system in a format your new software accepts. Depending on the systems you're moving between, this might involve CSV or Excel files, a built-in migration tool, or a third-party conversion service.

Before importing everything at once, I recommend testing a small sample first, if your new software allows it. For example, import a few customers, accounts, or transactions and check that the information appears where you expect it to. A small test is much easier to correct than thousands of incorrectly imported records.

During the actual migration:

1. Export the data from your old system. Keep the original export files unchanged so you always have a clean copy.
2. Format the files for the new system. Follow its required column names, date formats, account types, and other import requirements.
3. Import one data group at a time. Start with basic records, such as accounts, customers, and vendors, before importing transactions that depend on them.
4. Review import warnings and errors. Don't assume skipped or rejected records are unimportant. Find out why they weren't imported and correct them where necessary.
5. Record what was imported. Keep a simple migration log showing the files, date ranges, and number of records moved.

Don't treat a “successful import” message as proof that the migration is complete. It only tells you the system accepted the data. The next step is to verify that the amounts and balances in your new books actually agree with the records you left behind.

Step 7: Reconcile and verify the migrated data

A migration isn't finished just because the data imported successfully. Before you start using the new system for day-to-day bookkeeping, compare it with your old books using the same cutoff date.

Start with the reports and balances that can quickly reveal whether something was missed or imported incorrectly:

If the totals don't match, don't simply enter an adjustment to force them to agree. Trace the difference first. It could come from a missing transaction, duplicate import, incorrect account mapping, wrong opening balance, or a transaction that was assigned to the wrong date.

Step 8: Reconnect your integrations and workflows

Once you've confirmed that the migrated balances are correct, reconnect the other tools that send financial data to your accounting software. Depending on your business, these may include bank and credit card feeds, payroll, payment processors, ecommerce platforms, point-of-sale systems, and expense management apps.

Reconnect them carefully and pay attention to the cutoff date you established earlier. If your migration already includes transactions through August 31, for example, you don't want an integration bringing those same August transactions into the new system again.

For each integration, check that:

• The correct accounts are connected. Make sure deposits, expenses, fees, and other activity flow to the appropriate accounts.
• There is no overlap with migrated data. Review the first transactions downloaded or synced after reconnecting.
• Automations still work as intended. Check recurring invoices, payment rules, bank rules, or other automated workflows you previously used.
• Opening transactions are reviewed manually. Don't automatically accept the first batch of synced transactions until you're confident there are no duplicates.

If you're using QuickBooks Free, this is also a good time to connect your bank account once you're confident that doing so won't duplicate transactions already brought over during the migration.

With the new system running correctly, there's one final precaution: don't get rid of your old accounting records just yet.

Step 9: Keep access to your old accounting records

Even after you've confirmed that the migration was successful, don't immediately delete your old files or close access to the previous accounting system. Some information may not have transferred, and you may need the original records later to answer questions about older transactions.

Keep access to records such as historical financial statements, transaction details, reconciliation reports, tax records, payroll information, and supporting documents. This is especially important for information you intentionally chose not to migrate.

If continuing to pay for the old software doesn't make sense, export the records you need before canceling your subscription. Store them securely and organize the files by year so you can find them easily when needed.

Your new accounting system should become the source of truth from the migration cutoff date forward, while the archived records provide the history behind it. This separation also helps prevent someone from accidentally entering new transactions into both systems.

Common accounting data migration mistakes to avoid

Even a well-planned migration can result in missing records, duplicate transactions, or incorrect balances. Here are the mistakes I recommend avoiding:

• Migrating before reconciling your books: Existing errors can follow you into the new system and become harder to trace.
• Moving more data than you need: Years of historical transactions can make the migration more complicated when beginning balances and open transactions may be enough.
• Assuming everything will transfer: Attachments, custom fields, reconciliation history, recurring transactions, and other details may not migrate the same way as your core accounting data.
• Mapping accounts incorrectly: A transaction can import successfully but still appear incorrectly on your financial statements if it's mapped to the wrong account type.
• Duplicating transactions: Imported transactions may overlap with transactions downloaded through newly connected bank feeds or integrations.
• Entering adjustments just to make balances match: If your old and new books don't agree, investigate the difference before forcing the numbers to balance.
• Canceling the old software too soon: Make sure you've exported the historical reports and supporting records you may need before giving up access.

Most of these problems are easier to prevent than correct afterward. It's also worth knowing which types of accounting data are commonly harder to transfer, even when the migration itself goes smoothly.

What may not transfer when switching accounting software

Even when your balances and transactions migrate correctly, some information from your old accounting software may not transfer automatically. What gets left behind depends on the two systems you're moving between and the migration method you use.

Pay particular attention to:

• Attachments: Receipts, bills, contracts, and other files attached to transactions may need to be downloaded and saved separately.
• Reconciliation history: Your ending balances may transfer without bringing over the complete history of previous reconciliations.
• Custom reports: Reports you've customized in your old software may need to be recreated.
• Recurring transactions: Recurring invoices, bills, and other scheduled transactions may need to be set up again.
• Custom fields and tracking categories: The new system may organize these differently or may not support the same options.
• User permissions: Employees, bookkeepers, and other users may need to be invited again and assigned new access levels.
• Integrations and automation rules: Bank rules, connected apps, and other automated workflows often require separate setup.
• Historical details: Some migration methods bring over balances without transferring every transaction behind those balances.

Before assuming something will transfer, check what your new accounting software supports and compare it with the records you use regularly in your current system. Anything that can't be migrated should be exported or archived before you leave the old software.

Knowing these limitations can also help you decide when to make the switch, since the timing of an accounting software migration can affect how much data you need to move.

When is the best time to switch accounting software?

If you have flexibility, the beginning of a new fiscal year is often the cleanest time to switch. You can close and reconcile the previous year in your old system, carry the ending balances forward, and begin recording new activity in the new software.

If you haven't chosen your new platform yet, compare your options before setting a migration date. Our guide to the best small business accounting software can help you find a system that fits your bookkeeping needs, budget, and business size.

However, you don't have to wait until year-end. A midyear accounting software migration can work well as long as you choose a clear cutoff date and decide how you'll handle transactions from earlier in the year.

For example, if you switch on October 1, finish recording and reconciling activity through September 30 in the old system. Your new books can then begin from the agreed cutoff point.

Don't delay a necessary switch solely to reach year-end. A well-planned cutoff and properly reconciled balances matter more than choosing a perfect date.

When to migrate accounting data yourself vs. hire a professional

Not every accounting software migration requires professional help. If your books are simple, reconciled, and don't contain much historical data, you may be comfortable handling the move yourself. The more complicated your accounting becomes, however, the greater the risk of bringing over incorrect balances or leaving important records behind.

Also consider the time required to verify the migration, not just the time needed to import the data. A business owner may be able to perform the technical steps but still benefit from a bookkeeper or accountant if they're unsure how to confirm that the trial balance, opening balances, receivables, payables, and other accounts carried over correctly.

What matters is that you can rely on the accuracy of your books after the switch.

Frequently asked questions (FAQs)