QuickBooks Fixed Asset Cleanup: Fix Accumulated Depreciation
No account needed for your first conversions. We never store your bank login.
Short answer: most QuickBooks files do not have a depreciation engine at all. Fixed Asset Manager ships only with QuickBooks Desktop Premier Accountant, Enterprise and Enterprise Accountant, and the fixed assets module in QuickBooks Online is limited to Advanced. On every other version the depreciation schedule necessarily lives outside QuickBooks, and the file only ever receives the journal entry. Almost every broken fixed asset account traces back to that one structural fact.
The symptom that brings people here is usually a balance sheet where accumulated depreciation is larger than the assets it depreciates, or a fixed asset total that does not resemble anything the business actually owns. Neither is a QuickBooks bug. They are what happens when depreciation gets posted from memory for a few years, or when the person who kept the schedule left.
What is actually wrong with your fixed asset accounts
Before touching anything, run a Balance Sheet and expand the fixed asset section, then run a QuickReport on each fixed asset and accumulated depreciation account. You are looking for five specific patterns, and the fix is different for each one.
| Symptom | Usual cause | Fix |
|---|---|---|
| Accumulated depreciation exceeds the asset cost | Depreciation kept posting after the asset was fully depreciated, or a disposal was never recorded | Debit accumulated depreciation and credit depreciation expense back to the correct cumulative figure, then stop the recurring entry |
| One catch-all Fixed Assets account holding vehicles, equipment and furniture | Assets were coded to whatever account existed | Split into asset classes with a paired accumulated depreciation subaccount under each |
| Assets on the books that were sold or scrapped years ago | Disposal was recorded as a deposit to income, or not at all | Remove cost and accumulated depreciation together and book the gain or loss |
| A large equipment purchase sitting in Repairs or Supplies expense | The bank feed or a card import categorized it as an expense | Reclass to the asset account and start depreciating from the in-service date |
| Book depreciation equals the tax return exactly, every year | Someone posted the tax depreciation figure as the book entry | Usually acceptable for a small business, but confirm with the preparer before assuming it is intentional |
The fourth row is the one that quietly does the most damage, because it understates assets and overstates expenses at the same time. A card feed has no way to know that a nine thousand dollar charge at an equipment dealer is a capital purchase, so it applies whatever rule matched last time. If you are reconstructing a year of this, it helps to have the underlying purchase documents somewhere searchable rather than working from the bank description alone, and it is the same evidence a lender or a valuation of the business will ask for later.
How do I fix accumulated depreciation in QuickBooks?
You fix it with a correcting journal entry in an open period, never by editing prior-year entries. Work out what accumulated depreciation should be as of the last closed year end, compare it to what QuickBooks shows, and post the difference. If QuickBooks is too high, debit Accumulated Depreciation and credit Depreciation Expense. If it is too low, do the reverse.
- Rebuild the schedule outside QuickBooks first. Get the depreciation schedule from the most recent tax return, or build one in a spreadsheet with cost, in-service date, method, life and accumulated depreciation per asset. This is the source of truth, and QuickBooks is only going to hold the totals.
- Reconcile asset by asset, not in total. Match each asset on the schedule to the cost sitting in QuickBooks. Assets that exist in the file but not on the schedule are usually disposals nobody recorded; assets on the schedule but not in the file are usually purchases that got expensed.
- Reclass any capital purchases that were expensed. Open the original transaction and change the account from the expense account to the correct fixed asset account. If the period is closed, leave the original alone and post a journal entry in the current period instead, debiting the asset account and crediting the expense account.
- Remove disposed assets properly. Credit the asset account for the full original cost, debit accumulated depreciation for everything taken on that asset, debit the cash or receivable for any proceeds, and put the difference to a gain or loss on disposal account. Do not just delete the asset, and do not record the sale as ordinary income.
- Post one correcting entry for the accumulated depreciation difference. Date it in the current open period, use the totals from your rebuilt schedule, and write a memo explaining what it corrects. One entry per asset class is easier to defend later than a single lump sum.
- Restructure the accounts so this cannot recur. Give each asset class its own fixed asset account with an accumulated depreciation subaccount directly beneath it, so the balance sheet shows cost, accumulated depreciation and net book value for each class without a separate report.
- Set the recurring depreciation entry and a review date. Book depreciation monthly or quarterly from the schedule, and reconcile the QuickBooks accumulated depreciation balance back to the schedule at least once a quarter so a drift of a few hundred dollars never becomes a drift of several years.
Why is my accumulated depreciation higher than my fixed assets?
Because depreciation kept running on assets that were already fully depreciated or already gone. A recurring monthly entry does not know when an asset reaches the end of its life, so it keeps posting until somebody stops it. Add a few disposals that were never removed from the books, and accumulated depreciation climbs past the cost of the assets still on hand.
An asset should stop depreciating when accumulated depreciation equals cost less salvage value, and it should leave the balance sheet entirely when it is sold or scrapped. The correcting entry is straightforward once you have a real schedule to compare against, but building that schedule is the actual work. There is no way to shortcut it from inside QuickBooks on a version without Fixed Asset Manager, because the file never held the per-asset detail in the first place.
Does QuickBooks calculate depreciation automatically?
Only in specific products. QuickBooks Online Advanced and Intuit Enterprise Suite include a fixed assets feature that automates acquisition, depreciation and disposal. On QuickBooks Desktop, Fixed Asset Manager computes depreciation and can post the journal entry back to the company file, but it is included only with Premier Accountant, Enterprise and Enterprise Accountant.
QuickBooks Desktop Pro and Premier have a Fixed Asset Item List, which is a place to record what you own and what it cost. It does not calculate depreciation. That distinction catches people out regularly, because the list looks like an asset module until you go looking for the depreciation numbers and find they were never there. QuickBooks Online Simple Start, Essentials and Plus have no fixed asset module at all.
Should book depreciation match the tax return?
Not necessarily, and for many businesses it should not. Section 179 and bonus depreciation let you deduct far more in the first year for tax purposes than straight line depreciation would give you for the books, so the two schedules diverge and the difference is a book to tax adjustment. A business that reports to a bank, an investor or a buyer generally wants book depreciation to reflect how the asset is actually used up.
That said, plenty of small businesses deliberately keep one schedule and post the tax figure to the books, which keeps the return and the financials consistent and saves the cost of maintaining two sets of numbers. Neither approach is wrong. What is wrong is not knowing which one your file is doing, because that is how a preparer ends up depreciating the same asset twice.
How do I record the sale of a fixed asset in QuickBooks?
Remove the cost and the accumulated depreciation in the same entry and let the difference fall to gain or loss. Credit the fixed asset account for the original cost, debit Accumulated Depreciation for everything taken on that asset, debit the bank account for the proceeds, and post the balancing figure to a Gain or Loss on Disposal of Assets account.
The common error is recording the sale proceeds as a deposit to sales income. That overstates revenue, leaves the asset and its accumulated depreciation sitting on the balance sheet forever, and hides the real gain or loss. If the asset was traded in rather than sold, the trade-in allowance takes the place of cash proceeds and the new asset goes on the books at its own cost.
What if the fixed asset error is in a closed period?
Leave the closed period alone and correct it in the current one. Post a single journal entry dated in an open period that moves the balances to where they should be, with a memo naming the years it corrects. Prior-year financial statements and the filed tax return stay as reported, which is what your preparer and any lender who already received those statements will expect.
Tell the tax preparer what you did, because a correction that moves accumulated depreciation also moves net book value, and that flows into the depreciation schedule they maintain for the return. A cleanup that is invisible to the preparer produces a return that disagrees with the books next spring.
Frequently asked questions
What account type should a fixed asset use in QuickBooks?
Use the Fixed Assets account type for the asset itself, with a matching Accumulated Depreciation subaccount underneath it, also a fixed asset type, carrying a credit balance. Depreciation Expense is an Expense type account. Setting accumulated depreciation up as a subaccount rather than a separate top-level account is what makes the balance sheet show net book value per asset class without a custom report.
What is the minimum amount before something has to be capitalized?
There is no single figure in the tax code, so businesses set a capitalization policy and apply it consistently. The IRS de minimis safe harbor election lets many taxpayers expense items below a stated per-item threshold, and a written policy in place at the start of the year is part of qualifying. Pick a threshold with your preparer, write it down, and apply it to every purchase rather than deciding case by case.
How often should I reconcile fixed assets?
Quarterly is enough for most businesses, and it should be part of the same routine as the rest of the close. Compare the QuickBooks balance in each fixed asset and accumulated depreciation account to the schedule, confirm that nothing was disposed of without an entry, and check that no capital purchases landed in an expense account during the quarter. Catching a miscoded purchase in the quarter it happened takes minutes; catching it three years later takes a day.
Can I import a fixed asset schedule into QuickBooks?
You can import the fixed asset item list into QuickBooks Desktop, but the depreciation history is not a list, it is a series of journal entries, so it has to be posted as such. In practice most cleanups load the opening cost and accumulated depreciation balances with one dated journal entry per asset class and keep the per-asset detail in the schedule.
Fixed assets are usually the last thing a cleanup touches, after the bank accounts agree. If a stretch of bank activity never made it into the file, start there instead, because a missing month of transactions hides the equipment purchases you are trying to find. The comparison of the best CSV to QBO converter tools covers the options for getting those months in, and the month end close checklist shows where the fixed asset review fits in the wider routine. For related cleanups, see the balance sheet out of balance walkthrough, the loan balance that does not match the lender guide, which is the liability-side twin of this job, and the retained earnings correction guide, since a fixed asset fix in a prior year usually lands there.