Computing Depreciation by Hand When Fixed Asset Manager Updates Stop
When Desktop discontinuation cuts off Fixed Asset Manager's depreciation tables, your schedules and journal entries can still stay accurate.
Fixed Asset Manager ships with the accountant editions of QuickBooks Desktop. It computes book and tax depreciation and can push the result into your company file. Its depreciation tables, however, arrive as a connected service. When Intuit discontinues a version, the connected services end and the table feed stops. The annual depreciation cycle then becomes yours to run. With preparation, that handoff is entirely manageable.
Does Fixed Asset Manager stop calculating, or just stop updating?
The application keeps opening and keeps calculating. What stops is the supply of current-year figures: the expensing limit under Section 179, the annual vehicle depreciation caps, and the bonus depreciation percentage. Straight-line book depreciation does not depend on those numbers. Neither do the recovery-year percentages, which are fixed by method and class life. Existing assets with established methods therefore continue to compute correctly in the software. New assets placed in service after the final table update are where stale numbers bite. Anything that reflects current-year limits, including exports to tax software, degrades from that point on.
Prepare before the last update arrives
Do this work while the service still answers. Export every schedule, summary and detail, to PDF and to Excel. Export the depreciation forecast and the disposition reports for open years as well. Note for each asset the method, convention, recovery period, in-service date, cost, and accumulated depreciation to date. Fixed Asset Manager stores its schedules in its own data files on the workstation, separate from the company file. Copy those files into the same rotation as the .qbb backups. Keep the installer and the licence details with the archive so a reinstall remains possible later.
How do you compute depreciation without the tables?
A spreadsheet replaces the calculation engine, and it needs only modest structure. One row per asset; columns for description, in-service date, cost, method, convention, life, accumulated depreciation through the prior period, current expense, and net book value.
For straight line, divide cost less salvage by the life, then prorate for the convention: half-year, mid-quarter, or mid-month for real property. For MACRS assets, carry the percentage for the current recovery year across from the table already in force and multiply by cost. The amounts that change each year are the expensing limit, the vehicle caps, and the bonus percentage. Our engineers suggest a note column recording the source of each figure, so any reviewer can trace it.
Posting the journal entries in Desktop
Keep the ledger summary-level and the workpaper detailed. Set up one depreciation expense account, with sub-accounts by class if you report that way, and one accumulated depreciation sub-account under each fixed asset account. Each period, make one general journal entry: debit depreciation expense by class, credit the matching accumulated accounts, and date it at the period end. Put the schedule reference in the memo.
Memorize the entry and set it to recur monthly. Automatic posting needs the company file open on the due date, so the reminder option is the safer default. The detail behind each entry lives in the spreadsheet, not in the register. For how these entries fit a wider close routine, see the month-end close and working paper guides at Ledger Clinic.
Can prior-year schedules stay readable?
Yes, and the exports are the safety net. Schedules for closed years do not need new tables to open. The real risk is environmental: an operating system upgrade, a dead workstation, or a reinstall that fails on newer hardware. The PDF exports made before the cutoff are the durable copies and open anywhere. Keep at least one machine, physical or virtual, that runs the version and opens the archived data. Test it after any operating system change, before you need it under pressure.
Tie the schedule to the ledger every quarter
Each quarter, and again at year end, reconcile every accumulated depreciation balance to the spreadsheet total. Cost minus accumulated should equal net book value on both the balance sheet and the workpaper. Investigate differences immediately; most are timing, a missed recurring entry, or an asset added without a row. One exception matters. If balances disagree only in the chart of accounts view while reports stay correct, that points to list damage inside the company file rather than a depreciation error. Run Verify and Rebuild, and treat a persistent mismatch as a file repair item rather than a bookkeeping one.