QuickBooks cleanup · Structural issues
QuickBooks structural issues: fixing a broken file structure.
Some QuickBooks files aren’t just full of miscategorized transactions — the file’s underlying framework is wrong, so every report inherits the problem. Opening Balance Equity that never cleared, a chart of accounts built generic or duplicated or miscategorized by type, balance-sheet accounts that won’t reconcile: these are structural, and no amount of re-coding individual transactions fixes them. Below: the structural problems we find, how we fix the structure, and when reports that never look right mean it’s a cleanup. Independent firm, not affiliated with Intuit Inc.
QuickBooks structural issues are problems in the file’s underlying framework — the chart of accounts, equity, and balance-sheet structure — rather than in individual transactions. Because reports are built on that framework, a structural problem means every report inherits the error: the balance sheet won’t balance, retained earnings looks wrong, or numbers never tie no matter how carefully transactions are coded. The most common single tell is an Opening Balance Equity account that still carries a balance. Fixing it is structural cleanup work — clearing Opening Balance Equity correctly, rebuilding the chart of accounts, and reconciling every balance-sheet account — not transaction re-coding, and it’s deeper than a typical categorization cleanup.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, and not Intuit’s official software support. Not affiliated with Intuit Inc.
Certified by Intuit
Real credentials held by our firm and operators — verification available on request.
Structural issues, in five questions.
What are “structural issues” in a QuickBooks file?
Problems in the file’s underlying framework — the chart of accounts, the equity section, and the balance-sheet accounts — rather than in individual transactions. Because every report is built on that framework, a structural problem means reports inherit the error: the balance sheet won’t balance, retained earnings looks wrong, or the numbers never tie no matter how carefully transactions are coded.
How are structural issues different from a normal cleanup?
A normal cleanup fixes transactions — miscategorized, duplicated, or uncategorized entries. Structural issues are deeper: the framework those transactions post into is wrong. Re-coding transactions on a broken structure never makes the reports tie. Structural cleanup rebuilds the chart of accounts, clears Opening Balance Equity correctly, and reconciles the balance-sheet accounts first.
What structural problems do you most often find?
An Opening Balance Equity account that was never cleared; a chart of accounts that’s generic, duplicated, or miscategorized by account type; balance-sheet accounts that don’t reconcile (old loans, negative cash, stale receivables or payables); retained-earnings and equity errors; items and products mapped to the wrong accounts; cash-vs-accrual confusion baked into the file; and broken sub-account / parent structure.
How do you fix a broken file structure?
We start with a free file review and a written fixed-fee scope, then clear Opening Balance Equity correctly, rebuild and consolidate the chart of accounts, reconcile every balance-sheet account, fix item and account mappings, and verify the reports tie — so the file is CPA-ready. We fix the structure; your CPA confirms the tax impact, because we don’t file taxes.
How do I know it’s structural and not just messy data?
Three tells: reports never look right no matter how transactions are coded; the balance sheet won’t balance; or Opening Balance Equity still carries a balance. Any one of those points to the structure, not the data entry — that’s a structural cleanup, scoped after a free file review.
“Structural issues,” plainly.
A QuickBooks file has two layers: the transactions (the day-to-day entries) and the structure they’re posted into — the chart of accounts, the equity section, and the balance-sheet accounts that everything rolls up to. Structural issues live in that second layer. The framework itself is wrong, so the file produces wrong reports even when individual transactions are entered correctly. That’s what makes structural problems different from — and deeper than — the usual cleanup of miscategorized transactions.
The classic tell is the balance sheet that simply won’t balance, or reports that “never look right” no matter how carefully the bookkeeping is done. Underneath is usually an Opening Balance Equity account that was never cleared, a chart of accounts that grew generic and duplicated, or balance-sheet accounts — old loans, negative cash, stale receivables or payables — that no longer reconcile to reality. Because every report is built on the structure, fixing the structure is the only thing that makes the numbers tie. We do that structural work; your CPA confirms the tax impact, because we don’t file taxes.
The structural problems we find.
Ranked roughly by how often they sit at the root of a file whose reports never tie — the fix steps below address them in the same order.
Problem 01 · Opening Balance Equity was never cleared
The single most common structural tell. Opening Balance Equity is a temporary holding account QuickBooks uses while a file is set up or accounts are connected — it’s meant to be zeroed out to the correct equity accounts. When it never is, it sits on the balance sheet carrying a balance that distorts equity and signals the file was never properly finished.
Problem 02 · A chart of accounts that’s generic, duplicated, or miscategorized by type
The chart of accounts is the skeleton every report hangs on. We routinely find it left at generic defaults, grown with duplicate accounts for the same purpose, or with accounts assigned the wrong type — an expense filed as an asset, a liability filed as income. When the type is wrong, the account lands in the wrong section of every report.
Problem 03 · Balance-sheet accounts that don’t reconcile
Old loans that were paid off but still show a balance, negative cash that can’t be real, stale accounts receivable or accounts payable for invoices and bills long since settled. These balance-sheet accounts no longer match reality, so the balance sheet they roll up to can’t be trusted — or won’t balance at all.
Problem 04 · Retained-earnings and equity errors
Equity is where prior-year results and owner activity accumulate, and it’s easy to corrupt: prior-period entries posted into the wrong year, owner draws and contributions miscoded, retained earnings overridden by hand. The result is an equity section that doesn’t reflect the business’s real history — and a CPA who can’t rely on the opening figures.
Problem 05 · Items and products mapped to the wrong accounts
In QuickBooks, every product or service item is mapped to income (and often inventory and cost-of-goods) accounts behind the scenes. When those mappings are wrong, sales and costs post to the wrong accounts automatically on every transaction — a structural error that silently miscategorizes the books no matter how careful the data entry is.
Problem 06 · Cash-vs-accrual confusion baked in
A file set up or run inconsistently between cash and accrual basis — or switched without the proper adjustments — produces reports that don’t agree with either basis. Because the inconsistency is built into how the file records and reports, it’s structural: it has to be untangled before any report can be relied on.
Less common · Less common: broken sub-account / parent structure
Sub-accounts grouped under the wrong parent, parents that double as posting accounts, or a hierarchy that no longer reflects how the business reports. It distorts totals and roll-ups on the reports — the kind of structural tangle that surfaces once the bigger problems above are cleared.
How we fix the structure.
Structural cleanup runs in order — we never re-code transactions on top of a broken framework. Every engagement starts free and is scoped in writing before any work begins.
Free file review
We start by looking at the actual file — the chart of accounts, the equity section, Opening Balance Equity, and whether the balance sheet balances — before quoting anything. The review tells us how deep the structural problems run and what it will take to fix them. No charge, and no obligation.
Written, fixed-fee scope
Based on the review, we put the structural cleanup in writing: what’s wrong, what we’ll fix, and a fixed fee for the work — $1,500–$15,000+ depending on depth. You approve the scope before any work begins, so there are no surprises and no open-ended hourly billing.
Clear Opening Balance Equity correctly
We zero out Opening Balance Equity to the right accounts — reclassifying its balance to retained earnings, owner equity, or wherever it genuinely belongs — without distorting the equity section. This is the foundational fix; until it’s done correctly, the balance sheet can’t be trusted.
Rebuild and consolidate the chart of accounts
We correct account types, merge duplicates, and reshape the chart of accounts into one clean structure that maps to how the business actually reports — so accounts land in the right section of every report from then on, and the file is readable for you and your CPA.
Reconcile every balance-sheet account
We reconcile cash, loans, receivables, payables, and the rest of the balance sheet back to reality — clearing paid-off loans, resolving negative or stale balances, and tying each account to supporting documentation so the balance sheet reflects the real financial position.
Fix item and account mappings
We correct how products, services, and items map to their income, inventory, and cost accounts, so sales and costs post where they should on every transaction going forward — closing the structural leak that quietly miscategorizes the books.
Verify the reports tie, then hand off CPA-ready
Finally we confirm the balance sheet balances and the profit-and-loss ties out, so the reports are internally consistent and the file is CPA-ready. We fix the structure; your CPA confirms the tax impact and files — because we don’t file taxes.
Balance sheet won’t balance, or Opening Balance Equity has a balance?
A Certified ProAdvisor reviews the file free, then rebuilds the structure so the reports tie — a structural cleanup is a written fixed-fee scope, $1,500–$15,000+ depending on depth. We fix the structure; your CPA confirms the tax impact. Independent firm.
Three signs it’s structural, not transactional.
Reports never look right
You’ve coded transactions carefully and the reports still don’t make sense — numbers that should match don’t, totals feel off, the profit-and-loss tells a story you know isn’t true. When the data is reasonable but the reports aren’t, the problem is the structure the reports are built on.
The balance sheet won’t balance
A balance sheet that doesn’t balance, or shows impossible figures like negative cash, is a structural symptom — not a data-entry slip. It means the file’s framework (equity, account types, or reconciliation) is broken at the foundation, and no amount of re-coding transactions will square it.
Opening Balance Equity has a balance
Open the balance sheet and look for an Opening Balance Equity account with a balance still in it. That account is meant to be cleared to zero during setup; a lingering balance is a near-certain sign the file was never properly finished — the clearest single signal it’s structural.
A Certified ProAdvisor rebuilds the structure so the reports finally tie.
Re-coding transactions is the visible part of a cleanup; rebuilding a broken structure is the part that actually makes the numbers trustworthy. The work is clearing Opening Balance Equity to the right accounts without distorting equity, consolidating a sprawling chart of accounts down to one clean structure, reconciling every balance-sheet account — loans, cash, receivables, payables — back to reality, fixing item and product mappings so they post where they should, and then verifying that the balance sheet and profit-and-loss tie before the file is called CPA-ready. A Certified QuickBooks ProAdvisor with active Online and Desktop certifications does that against a written scope. Independent firm — not Intuit, and not Intuit’s software support; we fix the structure, and your CPA confirms the tax impact because we don’t file taxes.
Free
file review first — we look at the structure before we scope
$1,500–$15,000+
written fixed-fee structural cleanup, by depth
Independent
Certified ProAdvisor firm — not Intuit; we don’t file taxes
What people ask about structural issues.
Is this Intuit’s official QuickBooks support?
What does it mean when QuickBooks has “structural” issues?
What’s the difference between structural issues and miscategorized transactions?
Why is Opening Balance Equity showing a balance?
How do you fix a broken file structure?
Do you handle the tax impact of fixing the structure?
How much does it cost to fix structural issues?
Can you guarantee the reports will balance after?
Reports never look right, or the balance sheet won’t balance?
If the structure is wrong, get the file reviewed.
When the books never tie no matter how transactions are coded, the problem is in the file’s structure — not the data entry. Start with a free file review; from there a structural cleanup is a written fixed-fee scope, $1,500–$15,000+ depending on depth. We fix the structure; your CPA confirms the tax impact. Independent ProAdvisor firm, written scope before any work begins.