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.
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.