Cleaning Up Fixed Assets and Depreciation in QBO Advanced

Fixed asset records decay quietly. An asset gets expensed twice, a disposal never gets recorded, and a few years later the accumulated depreciation account agrees with nothing. QuickBooks Online Advanced includes a fixed asset module that can rebuild the list and take over the monthly depreciation entry. The rebuild works well, but the order of operations decides whether it goes smoothly. Here is the sequence we would follow, and the checkpoints that keep it from going sideways.

Build the list before you open the module

Start outside QuickBooks. Pull every asset that is still in service, with its cost and its in-service date. Old expense entries, receipts, and prior depreciation schedules are the usual sources. Do not enter anything into the module yet. A clean spreadsheet first turns a multi-day job into an afternoon, because you can spot duplicates and cost errors before QuickBooks starts computing against them.

Skip the assets that no longer exist

Assets that were sold, scrapped, or fully written off years ago should generally stay off the rebuild list. Re-entering them recreates the noise you are trying to remove. Handle their old balances in the correcting entry instead. If a disposal was never recorded, this is the moment to surface it, because it will otherwise show up later as an unexplained gap.

How do you make depreciation catch up?

Enter each asset with its cost and in-service date. The module is designed to compute accumulated depreciation back to that date, so the ledger catches up without years of manual journal entries. Verify the behavior on one asset first. Compare its calculated total against the client’s existing schedule, and confirm the entry posts where you expect, before you enter the rest of the list.

One true-up entry closes the gap

The recalculated total will rarely match the old ledger to the penny, and that is fine. Post a single correcting journal entry to bring accumulated depreciation in line with the module’s figure, then stop hand-entering depreciation. A large gap deserves a second look before you post, because it lands in the current year, and for a nonprofit that means the board and funders will see it in the next statements.

Why does the cutoff date matter?

Aim to finish the setup and the true-up before the first of the next month. The module posts each monthly depreciation entry on its own schedule once the assets are in, and a clean month boundary means the first automatic entry is a normal one. Turn off any memorized or recurring depreciation entries the old process relied on. If the old entries and the new schedule overlap for even one month, depreciation gets posted twice.

Check the accounts behind the entries

Confirm which expense and accumulated depreciation accounts the module posts to, and make the true-up entry hit the same ones. Nonprofits usually allocate depreciation across programs or functions, so check whether each automatic entry needs a class or a split before you rely on it. A blank class column on twelve posted entries is a slow thing to fix.

Live with it for a couple of months

Tie the module’s schedule to the trial balance each month for the first two or three closings. The habit is cheap, and it catches mapping mistakes while they are still one entry deep. Keep an export of your asset spreadsheet and the true-up entry as the bridge between the old records and the new schedule. If the gap will not reconcile, our team rebuilds jumbled QuickBooks data regularly, and the culprit is almost always a disposal or a duplicate nobody recorded.