If you run QuickBooks Desktop Enterprise, you already own a fixed asset tool. Fixed Asset Manager ships with the product, calculates depreciation, and can post a journal entry back to the company file. So the question is not "do I have something" but "is what I have enough." If you opened it once and kept the spreadsheet, this article is for you.
This article lays out what Fixed Asset Manager does according to Intuit's own documentation, what it does not do, and how the realistic alternatives compare. The tool was built for a specific job (an accountant preparing a year-end depreciation schedule for a tax return) and it does that job. A controller closing the books every month has a different job.
What Fixed Asset Manager is, in Intuit's words
Intuit describes Fixed Asset Manager as "a feature available in QuickBooks Desktop that computes depreciation of fixed assets based on the standards published by IRS," and notes that it "is only available in QuickBooks Desktop Premier Accountant, Enterprise, and Enterprise Accountant" (Understand terminology for the Fixed Asset Manager). On Enterprise you have it; on Pro or Premier (non-Accountant) you do not.
The same page lists the depreciation methods it supports (straight-line, declining balance at 150 and 200 percent, and MACRS) and a long set of predefined reports: depreciation schedules by general ledger account and by user-defined field, lead schedules by category, location and tax form, monthly general ledger account summaries, AMT and ACE adjustment calculations, and a projection report. For the tax preparer that is a genuinely useful set.
Intuit's setup guide explains the architecture. Fixed Asset Manager and QuickBooks Desktop "have different data files." Fixed Asset Manager can carry up to six bases per asset (Federal, Book, AMT, ACE, State, Other), and when you post a journal entry you pick which basis to post from (Use Fixed Asset Manager in QuickBooks Desktop). It can import assets from a CSV file and export to ProSeries for Form 4562. So why does the spreadsheet survive?
What the documentation tells you it does not do
Read the same pages as a controller rather than a tax preparer and a pattern appears.
It is built around a tax year, not a monthly close. The setup guide says that "unlike QuickBooks Desktop, FAM calculations and reports are based on a defined period" and that "at the end of this date period, users should follow the year-end procedures." The usage guide notes that "QuickBooks Desktop is based on Calendar year while Fixed Asset Manager and ProSeries are based on Tax year," which is why a given Desktop release pairs with the prior year's Fixed Asset Manager. The documentation describes year-end procedures and an annual period. It does not describe locking a closed month, a sequential monthly close, or an append-only audit trail of who changed what. If your auditor asks how you know the March entry matches the register as it stood in March, the documentation gives you nothing to point at.
It lives on one Windows machine, in one file. Intuit's guide to moving the data describes the constraint. The client file sits in a folder under C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\FAMxx, where "xx" changes with each QuickBooks version. To move it to another computer, "you'll need to use a flash drive." If you skipped a version when upgrading, you rename file extensions by hand. QuickBooks Desktop itself requires Windows installed natively (system requirements), so the register is reachable only from that machine. There is no browser view for the outsourced controller, the auditor, or the owner.
It does not come with you to QuickBooks Online. Intuit's article on what transfers from QuickBooks Desktop to QuickBooks Online is a specific list of what moves and does not move. Fixed Asset Manager data is not among the things listed as moving, which follows from the architecture: it is a separate data file, not part of the company file the migration reads. The same article states that the Desktop audit trail does not move either. Fixed asset items (the Desktop list) map to the fixed asset feature in QuickBooks Online Advanced, but the depreciation history, methods and multi-basis detail held in Fixed Asset Manager have no landing place. If a move to Online is on your horizon, every year you accumulate in Fixed Asset Manager is a year you will re-key or reconstruct.
It has no notion of construction in progress, partial disposals or impairments as workflows. The terminology page defines disposal as "removing an asset from the company either by theft, selling, or throwing it away." Nothing in the documentation describes capitalizing project costs into an in-service asset, disposing of part of an asset, or writing an asset down.
What a Desktop Enterprise controller actually needs
Write down the job. At Sample Company, a 60-person manufacturer on QuickBooks Desktop Enterprise with about 250 assets, the fixed asset part of the monthly close looks like this:
- Add the month's capital purchases with cost, in-service date, useful life, method and account.
- Move any completed projects out of construction in progress and start depreciating them.
- Record disposals and transfers between departments or locations.
- Run depreciation for the month, on the book basis, and post one journal entry to QuickBooks.
- Tie the register to the general ledger.
- Lock the month so nobody's later edit changes what was reported.
- Once a year, hand the tax preparer a tax-basis schedule (MACRS, Section 179, bonus) that reconciles to the same asset list.
Steps 4 and 7 are calculations, and Fixed Asset Manager does calculations well. Steps 1 through 3, 5 and 6 are controls, and there the tool is silent. Judge any alternative on the controls first; the arithmetic is the easy part.
A worked example of why one schedule is not enough
Sample Company buys a CNC machine on 15 January for $48,000, eight-year book life, no salvage, straight-line. Book depreciation is $48,000 divided by 8, or $6,000 a year, so $500 a month. That $500 is the monthly journal entry.
For tax, the same machine is seven-year MACRS property under the General Depreciation System with the half-year convention. Using the IRS table in Publication 946, year one is 14.29 percent of $48,000, or $6,859.20. The book-to-tax difference in year one is $6,859.20 less $6,000, or $859.20 (before any Section 179 election or bonus depreciation, which depend on the taxpayer; confirm with your tax preparer).
Every serious option has to carry both numbers for the same asset without one overwriting the other. A single-column spreadsheet cannot. Fixed Asset Manager can (that is what its Federal and Book bases are for). The question for the alternatives is whether they do it and add the controls.
The realistic options, compared
| Option | Book and tax bases | Monthly close with locked periods | Audit trail | Multi-user, browser access | Posts to QuickBooks Desktop | Survives a move to Online |
|---|---|---|---|---|---|---|
| Spreadsheet | Only if you build and maintain both | No (a cell is a cell) | No | Shared file, no controls | Manual journal entry | Yes, it is a file |
| Fixed Asset Manager | Yes, up to six bases | Annual period, year-end procedures | Not described in Intuit's documentation | Single Windows install, one file | Yes, from a chosen basis | Not listed among the data that transfers |
| Desktop fixed asset software | Typically yes | Varies by product; check the vendor's documentation | Varies | Installed on a workstation or server | Usually by export file | The register stays with the vendor's product |
| Cloud fixed asset register | Typically yes | Varies; check the vendor's documentation | Varies | Yes | Uncommon; check each vendor's integrations page | Yes, the register is outside the ledger |
Two notes on the table. The desktop and cloud rows describe categories, not particular products; when you evaluate a specific vendor, read that vendor's own documentation for each cell. And "posts to QuickBooks Desktop" is the column that separates the field. Outside applications reach QuickBooks Desktop through Intuit's QuickBooks Web Connector, an application installed alongside Desktop; check each vendor's integrations page for it specifically, because a listing for QuickBooks usually means QuickBooks Online.
The spreadsheet is free, flexible, and exactly as good as the one person who understands it. It fails on locking, on the audit trail, and on the day that person leaves.
Fixed Asset Manager is the right answer if the only consumer of the register is the tax return, one person maintains it, and you plan to stay on Desktop Enterprise indefinitely. It costs nothing extra.
Desktop fixed asset software is the traditional step up: multi-basis, more reports, an installed application. It typically inherits the single-machine, one-file characteristics you were trying to escape, and connects to QuickBooks by a file you export and import.
A cloud fixed asset register solves access and multi-user and, depending on the product, adds real close controls. The catch for a Desktop shop is that a cloud register whose integration list stops at QuickBooks Online leaves you keying the monthly entry by hand.
Where a Desktop-connected cloud register fits
If you land on "cloud register, but it must talk to Desktop," Steda is one option built for that gap: it works with QuickBooks Desktop including Enterprise through the QuickBooks Web Connector, imports the existing register from a spreadsheet or CSV so you are not re-keying 250 assets, keeps book and tax bases side by side, posts the monthly depreciation journal entry back to Desktop, and adds the controls the Fixed Asset Manager documentation does not mention: locked, sequential monthly periods and an append-only audit trail. It is a register, not a general ledger; QuickBooks stays your books.
Whatever you choose, apply the same test: find the vendor's page that describes period locking and the page that describes the QuickBooks Desktop connection. If either page does not exist, assume the feature does not either.
A practical way to decide
Ask three questions.
- Who needs to see the register besides the person who maintains it? If the answer includes an auditor, an outsourced controller, or an owner on a different machine, a single Windows file is a constraint.
- Do you close monthly, and does anyone check that the depreciation entry ties to the register as of that month? If yes, you need locked periods and a record of changes, described in the documentation of whatever you pick.
- Is QuickBooks Online a possibility in the next five years? If it is, keep the register somewhere the migration will not leave behind, and make sure it can post to Desktop today and to Online later.
If all three answers point at Fixed Asset Manager or the spreadsheet, keep them. If they point away, you know what to look for and where to verify it.