Managing Hospital Equipment in a Spreadsheet Is a Compliance Risk
The audit request is straightforward. Your external auditors need a full schedule of depreciable assets: acquisition dates, cost basis, accumulated depreciation, and current book value for every piece of major equipment at every location.
If your fixed asset records live in a spreadsheet, this request starts a process that should take minutes but takes days. Someone has to find the spreadsheet. Verify that it is current. Check whether the equipment that moved from the hospital to the clinic last quarter was updated. Confirm that the disposal from six months ago was recorded. Track down the original invoice for the MRI scanner that was capitalized before the last person in that role left.
This is the moment most Controllers realize the spreadsheet is not just inconvenient. It is a liability.
Why Hospital Fixed Assets Break in Spreadsheets
Fixed asset tracking is straightforward in concept: record what you own, calculate depreciation, and report the current book value. In practice, it is a process that depends on consistent execution across time, staff changes, and organizational complexity. Spreadsheets fail at all three.
Here is where the gaps open up:
- Asset acquisitions are not recorded consistently. When equipment is purchased, someone needs to decide whether to capitalize or expense it, determine the useful life and salvage value, and enter the asset into the tracking system. In a spreadsheet-based process, this step depends on whoever is responsible at the time knowing to do it, doing it correctly, and doing it in a way that is consistent with how it was done before. When that person leaves, the institutional knowledge leaves with them.
- Depreciation calculations accumulate errors over time. Spreadsheet-based depreciation models require someone to update them every month or every year. A formula error introduced during a staff transition can go undetected through multiple close cycles before an auditor catches it. And when it is caught, restating prior periods becomes its own project.
- Asset transfers and disposals are not tracked reliably. When equipment moves between locations, retires, or is sold, the spreadsheet needs to be updated: manually, by someone who knows to do it, in real time. In a multi-location health system, equipment moves frequently. Disposals trigger gain or loss calculations and journal entries. If the spreadsheet is not current, your GL is not current either.
- Documentation is inconsistent. Auditors want more than a number. They want supporting documentation: the original invoice, the capitalization decision, the depreciation schedule, and evidence that the asset still exists. In a spreadsheet-based system, that documentation lives in separate files, folders, email chains, and potentially physical filing cabinets. Assembling it under audit is a research project, not a lookup.
- Multi-location complexity multiplies the risk. A single-entity organization with fifty assets can manage a spreadsheet with care. A health system with a hospital, two clinics, an ASC, and a foundation, each with its own equipment, its own depreciation schedules, and its own GL, cannot. The spreadsheet approach that worked for one location does not scale across five.
How Intacct Changes the Fixed Asset Lifecycle
Sage Intacct’s fixed asset management module handles the entire lifecycle from acquisition to disposal automatically, not as a separate system, but as an integrated part of the same GL your accounting team already uses.
The practical difference is direct:
| Spreadsheet-Based Tracking | Sage Intacct Fixed Assets | |
|---|---|---|
|
Depreciation calculation
|
Manual, formula-dependent
|
Automatic, GAAP-compliant methods
|
|
Asset disposal
|
Manual entry, manual journal entry
|
Automatic gain/loss and disposal J/E
|
|
Multi-location tracking
|
Separate rows or tabs, manually maintained
|
Dimensional tagging by location, department, project |
|
Subledger-to-GL reconciliation
|
Manual, time-consuming, error-prone
|
Seamless: Fixed Asset is a GL dimension
|
|
Audit trail
|
Whoever updated the file last
|
Complete, timestamped record of every change
|
|
Multi-entity support
|
One spreadsheet per entity, usually
|
Multi-currency, multi-location in one system
|
|
Prior period adjustments
|
Manual rebuild, high error risk
|
Drill-down from GL directly to asset dimension
|
The most operationally significant difference is depreciation posting. At month-end, Sage Intacct calculates and posts depreciation to the GL without a journal entry from your team. When an asset is disposed, the gain or loss and the disposal journal entries are generated automatically. When an auditor requests the subledger-to-GL reconciliation, it is already complete. Fixed Asset is a GL dimension in Intacct, so the subledger and the GL are always in sync.
Sage’s fixed asset module also supports an unlimited number of depreciation books. That means you can maintain one set of records for GAAP financial reporting, a separate set for tax purposes, and meet the requirements of multiple tax jurisdictions, all from a single asset record. Your team maintains the asset once; the system calculates the correct depreciation for each book.
The documented close cycle impact is substantial. Organizations implementing Sage Intacct fixed asset management can reduce monthly close time related to fixed assets by as much as 90%.
What the Difference Looks Like at Year-End
Consider a hospital network with three locations: a main campus, a specialty clinic, and a recently acquired ASC. The organization owns approximately 400 depreciable assets across all three locations, imaging equipment, surgical equipment, IT infrastructure, vehicles, and facility improvements.
Currently, the Controller maintains a master fixed asset spreadsheet that was built by someone who left two years ago. Monthly depreciation is calculated by updating formulas in the spreadsheet and copying totals into a journal entry template. Asset additions happen when someone remembers to add them. Disposals are recorded inconsistently. At year-end, the external auditors request the fixed asset schedule every year and spend two days reconciling it to the GL because the numbers do not agree on the first pass.
With Sage Intacct fixed assets in place, each asset is created in the system at acquisition, with its classification, cost basis, useful life, depreciation method, and location tag. Every month, Intacct calculates and posts depreciation automatically. When a piece of equipment is retired or sold, the Controller processes the disposal in Intacct, and the system generates the gain or loss and the corresponding journal entries automatically.
At year-end, the external auditors pull the fixed asset schedule directly from Intacct. It reconciles to the GL because they are the same system. The audit fieldwork that used to take two days takes a few hours.
When Your Fixed Asset Records Have Already Become a Liability
These are the signals that your current approach is already creating risk:
- Your fixed asset spreadsheet has not been reconciled to the GL since the last audit
You are not certain all asset acquisitions in the past 12 months have been recorded
Asset disposals from prior periods have not generated the corresponding gain or loss journal entries
Equipment that moved between locations has not been updated in your tracking records
Month-end depreciation requires a manual journal entry built from spreadsheet formulas
Your external auditors have flagged fixed assets as a point of emphasis or identified a finding in a prior year
If your team relates to more than one of these, the question is not whether the process needs to change. It is whether you want to find the problem on your own terms, or when your auditors find it first.
Frequently Asked Questions
What depreciation methods does Sage Intacct support? Sage Intacct supports straight line, 150% declining balance, 200% declining balance or custom declining balance depreciation methods on a full month, half year, full year or daily convention. You can assign different methods to different asset classifications and maintain multiple depreciation books from a single asset record, one for financial reporting, one for tax purposes, or both.
How does Intacct handle assets that exist across multiple entities? Assets can be created at the company or entity level. Intacct’s multi-location, multi-currency architecture means you can manage the full asset register for all of your entities from a single system, with entity-level reporting and a consolidated view available from the same platform. There is no separate spreadsheet per entity.
What happens when an asset is transferred between locations or partially disposed of? Sage Intacct supports partial disposals and asset transfers between entities or locations. The system generates the appropriate journal entries automatically. Transfers are logged with a complete audit trail, so your records reflect where each asset is at any point in time.
How does Sage Intacct support Medicare cost reporting for fixed assets? Intacct maintains the acquisition date, cost basis, useful life, accumulated depreciation, and book value for every depreciable asset. These records can be exported in formats compatible with your cost reporting process. The accuracy of the underlying records is what matters for CMS compliance, and automated tracking eliminates the manual errors that create cost report discrepancies.
How long does it take to migrate existing asset records into Sage Intacct? The setup is designed for quick deployment. Existing asset records are imported from your spreadsheet, depreciation is calculated to bring balances current, and your classification and GL account mappings are configured. DSD consultants manage this process as part of implementation, with the goal of going live without disrupting the close cycle.
Talk to a DSD Consultant
The fixed asset schedule your auditors request at year-end should take minutes to produce, not days. DSD Business Systems implements Sage Intacct’s fixed asset module at hospitals and health systems where manual tracking has already created audit exposure.
If your depreciation records live in a spreadsheet and you are not certain it reconciles to the GL, that conversation is worth having before your next audit cycle starts.
Douglas Luchansky
Director, Client Transformation
