Accounts That Changed Type in a QuickBooks Migration

2026-07-27 · 3 min read

An account that migrates with the correct balance but a changed account type is one of the few migration errors a trial balance structurally cannot detect. The numbers agree, so nothing looks wrong — but the account has moved to a different section of your balance sheet or profit and loss. Compare the Account Listing from both systems to catch it.

How can a balance be right and the account still be wrong?

Because a trial balance compares numbers, and this error does not change any number.

Say a Fixed Asset in Desktop arrives in Online classified as an Expense. Its balance is identical. Your trial balance ties out to the penny. But that amount has now moved off your balance sheet and onto your profit and loss, where it reduces reported profit — and follows through to the tax return.

Desktop Online Balance sheet — Fixed Assets Equipment 12,400.00 Profit and loss — Expenses Equipment 12,400.00 Same account. Same 12,400.00. Different financial statement. A trial balance compares the number, so it reports no difference at all.
The balance is identical, so every numeric check passes. Only a comparison of account types catches it.

Which report catches it?

The Account Listing, from both systems. In QuickBooks Desktop it is under Reports, List, Account Listing. It carries the account name, type, detail type, and balance.

Column Why it matters
Type The section of the financial statements the account lives in
Detail type Online's sub-classification — usually harmless if it changes
Balance Lets you spot zero-balance accounts a trial balance hides

Type changes are the ones to chase. Detail type changes are usually QuickBooks Online mapping to its nearest equivalent and rarely matter.

What else does the Account Listing catch?

Accounts with a zero balance that never migrated at all.

Trial balances are commonly exported with zero-balance rows suppressed, so an account sitting at 0.00 in Desktop is simply absent from the comparison. Nothing is misstated today — but the next transaction posted to it has nowhere to go, and someone will create a duplicate account instead.

Which type changes actually matter?

Change Consequence
Fixed Asset to Expense Profit understated, balance sheet understated
Expense to Cost of Goods Sold Gross margin changes, net profit does not
Other Current Asset to Bank Account appears in cash reporting and reconciliation
Income to Other Income Revenue understated on the profit and loss
Liability to Equity Debt disappears from where lenders look for it

Any of these can be correct, if somebody chose it deliberately. The problem is when nobody chose it and nobody noticed.

Quick reference

Question Answer
Can a trial balance detect this? No — the balance does not change
Which report does? Account Listing, both systems
Which changes matter? Type. Detail type is usually benign
What else does it catch? Zero-balance accounts that never came across
When should I check? Before clearing Opening Balance Equity

Upload both account listings to the free check and it compares every account's type, flagging the ones that moved.

Related guides