Migrating to QuickBooks Online from Desktop or spreadsheets: what to plan for

Moving to QuickBooks Online can make day-to-day bookkeeping easier to reach, share, and review, especially for a Texas business with staff, customers, or locations in more than one city. It is still a change to a core business system, not just a software switch. The businesses that have the smoothest moves usually do most of the planning before anything is transferred. They decide what the new file should look like, clean up the old records, and agree on how the result will be checked.

This guide explains how to plan a move from QuickBooks Desktop or from spreadsheets, what to clean up first, what generally transfers and what needs a closer check, and the checks to run after the migration. It is general information about planning a migration, not tax or legal advice for a specific business.

Start with why you are moving, and what success looks like

Before choosing a start date, write down the problems you are trying to solve. Common reasons include remote access for an owner or bookkeeper, easier collaboration, a file that has become slow or difficult to share, or a business that has outgrown separate spreadsheets. A clear reason helps you decide what to keep, what to simplify, and what can wait until after the move.

Also decide what a good result looks like in practical terms. For example, you may want opening balances that agree with the old system, bank accounts that reconcile, customer and vendor lists without duplicates, and reports that can be compared month by month. If you cannot describe that result in advance, it is harder to know whether the migration is finished.

Choose the timing and the cutover point

Timing matters more than speed. Many businesses choose a month-end or quarter-end as the cutover point because balances are easier to compare at that date. That does not mean work must stop on that day. It means you agree on a last date for the old system, a first date for the new system, and a short period when no one enters the same transaction in both places.

For a Texas business, think about other dates that could overlap with the move, such as payroll dates, a busy sales period, a lease or contract renewal, or a filing deadline. Moving during a quieter period, and allowing time for review, usually reduces pressure. If the business has seasonal peaks in Austin, Dallas, Houston, San Antonio, or another Texas market, plan around those peaks where possible.

Clean up the data before you move it

A migration copies the habits in the old file as well as the numbers. Cleaning up first is often the most valuable part of the project. Work through the following areas before transfer:

• Chart of accounts: Remove unused accounts where it is safe to do so, merge clear duplicates, and check that similar income and expense items are not split across several accounts for no reason.
• Customers and vendors: Look for the same person or business listed under different spellings, names, or email addresses. Decide which record is the main record and how old or inactive records should be handled.
• Products, services, and items: Check for duplicate items, inconsistent names, and items that are no longer sold. Inconsistent items can distort sales and inventory reporting after the move.
• Open balances: Review open invoices, unpaid bills, and credits. An old open item that is no longer valid should be resolved in the old system, not carried forward and forgotten.
• Bank and credit card accounts: Reconcile accounts as far as possible before migration. Unreconciled differences are much easier to explain while the old system is still available for comparison.
• Payroll and tax-related records: Check that employee, pay, and deduction information is current in the system you use for payroll, and keep supporting records separate from the accounting file itself.

Keep a short cleanup log: what was changed, why it was changed, and who approved it. That log is useful if a balance looks different after migration and you need to explain why.

What transfers, and what needs checking

Exactly what transfers depends on the starting point, the version of QuickBooks Desktop, the spreadsheet structure, and the migration method used. In general, core lists and balances are the focus, including the chart of accounts, customers, vendors, items, and opening balances. Transaction history may transfer in full, in part, or as summary balances, depending on the approach chosen.

Some things almost always need a manual check, even when the transfer itself goes well. These include custom reports, saved report settings, payroll setups, recurring transactions, bank rules, payment links, third-party app connections, and user permissions. Do not assume that a setting in Desktop has an exact equivalent in QuickBooks Online. Review each one and record how it will be handled in the new system.

Spreadsheets need extra care. A spreadsheet may contain hidden sheets, manual totals, notes in cells, or formulas that are not obvious at first glance. Before migration, identify which sheets are the record, which are working notes, and which totals should agree with bank statements or other source documents. If a spreadsheet total cannot be explained, it should not be moved into QuickBooks Online without review.

Plan access, permissions, and connected apps

QuickBooks Online is designed for shared access, so access planning is part of the migration. Decide who needs access, what level of access each person needs, and who can approve payments, edit reconciled transactions, or change settings. Remove access for former staff or old contractors where appropriate, and use separate logins rather than shared logins where possible.

List every connected app, bank feed, payment processor, and reporting tool. For each one, note whether it should be reconnected, replaced, or discontinued, and who is responsible for reconnecting it. Reconnecting bank feeds too early, before opening balances are agreed, can create duplicate or confusing transactions.

Back up first, and keep the old file readable

Before any transfer, make a complete backup of the Desktop company file or a saved copy of the spreadsheets, and store it in a safe place. Keep the old file readable for a reasonable period after the move, even if it is no longer used for daily entries. If a question arises about an old balance, the old file is the reference point.

Agree on who can make changes during the migration and how changes will be recorded. A common problem is a well-meaning correction entered in the old system after the data has already been transferred. That correction then never reaches the new file, and the two systems drift apart.

Common pitfalls to avoid

• Migrating a messy file unchanged: Duplicates, unused accounts, and old open items tend to cause more confusion in a new system than in the old one.
• Choosing a cutover date without a freeze: If entries continue in both systems, reconciling the two becomes difficult.
• Skipping the comparison step: A migration is not complete when data appears in QuickBooks Online. It is complete when key balances have been compared and differences have been explained.
• Forgetting payroll and sales tax settings: Payroll, sales tax, and reporting settings should be reviewed for the new system. Texas sales tax treatment can depend on the type of sale and other facts, so general settings should be reviewed with care and, where needed, with a qualified tax professional.
• Leaving staff without a new routine: If people do not know how invoices, bills, receipts, and reconciliations should be entered in QuickBooks Online, old habits and workarounds return quickly.

Post-migration checklist

Use this checklist after the transfer, before the new file becomes the only system of record:

• Compare opening balances, bank balances, accounts receivable, and accounts payable with the old system at the cutover date.
• Reconcile bank and credit card accounts and investigate any difference, however small.
• Review customer and vendor lists for duplicates or missing records.
• Check that recurring transactions, payment terms, and tax settings are set as intended.
• Run a profit and loss report and a balance sheet report for a recent period and compare them with the old system.
• Reconnect bank feeds and other apps one at a time, and check for duplicates after each connection.
• Confirm user access and permissions, and remove any access that is no longer needed.
• Test the normal weekly routine: enter an invoice, record a bill, receive a payment, and run a basic report.
• Record any known differences, why they exist, and what action, if any, is still needed.
• Agree on the monthly routine for categorization, reconciliation, and review going forward.

If a difference cannot be explained, do not force the numbers to agree by posting an unexplained adjustment. Investigate the source transaction first, and keep a note of what you found.

What to do if you need help with the move

A planned migration is often a good time to review how bookkeeping will work after the move. If you would like help planning the transfer, cleaning up records before migration, or setting up a routine in QuickBooks Online, learn more about QuickBooks Data Migration and QuickBooks Bookkeeping services.

Get a free consultation

If you are planning a move from QuickBooks Desktop or spreadsheets and would like to talk through timing, cleanup, and the checks that should follow, request a free consultation. Bring your cutover date, a recent bank reconciliation, and a list of the systems and apps you currently use, so the conversation can focus on your business.

This article provides general information only and is not tax, legal, or accounting advice for a specific business. For questions about a particular tax or legal situation, consult a qualified professional.