Managing Fixed Assets and Depreciation in QuickBooks Online Advanced

QuickBooks Online Advanced users looking to track equipment, vehicles, and other long-term assets have a built-in tool designed to manage the entire depreciation lifecycle. The Fixed Assets app, accessible through the All Apps menu under the Accounting section, allows businesses to add assets individually or in bulk, automate depreciation calculations, and review the resulting journal entries without relying on external spreadsheets.

Adding a Single Fixed Asset

To get started, users navigate to the Fixed Assets tab and select the option to add a new asset. The setup requires several key pieces of information. Users must provide an asset name, the purchase price, the estimated useful life of the asset, and the depreciation start date. Users must also assign the appropriate accounts, specifically the asset account, the depreciation expense account, and the accumulated depreciation account.

A critical feature of this setup is the handling of assets that have already begun depreciating before being entered into QuickBooks. Users can manually input the existing accumulated depreciation amount. Alternatively, they can check a box to allow the app to auto-generate the accumulated depreciation based on the parameters entered. It is vital to ensure that whatever amount the system calculates matches any manual ledger entries already recorded for the asset. Once all parameters are set, users can prompt the app to calculate the depreciation schedule and save the asset.

Bulk Imports and Auto-Generated Drafts

For businesses needing to add several assets simultaneously, the app provides a multiple-asset entry grid. Users can select fields on a blank line to begin a new entry, manually typing in the purchase date and accumulated depreciation amounts. The grid format also allows users to copy data directly from an existing spreadsheet, streamlining the data entry process. When saved, the app imports all the listed assets to the main Fixed Assets page.

The application also integrates with expense tracking. When an expense is recorded for a purchase, the system can automatically create a fixed asset draft. These drafts appear on the Fixed Assets page marked with “Draft (Auto)” in the status column. Users can review these drafts, verify the details extracted from the expense transaction, adjust the depreciation method or accounts as needed, and save the record to activate the asset.

Depreciation Schedules and Reporting

Once an asset is saved, the app immediately generates a depreciation schedule. Users can view the entire lifecycle of the asset, expanding the schedule by year and drilling down into specific months to see the posted transactions. The system follows a standard convention where depreciation begins on the first day of the same month if the depreciation start date falls in the first half of that month.

Users also have options to manage the end of an asset’s lifecycle. The app includes features to dispose of or delete fixed assets, ensuring that the ledger accurately reflects assets that are no longer in use. Additionally, users can run fixed asset reports to gain a broader view of their overall asset portfolio and depreciation status.

A Note on Calculations and Prior Depreciation

Setting up assets with prior depreciation requires careful attention to detail. When a user enters an accumulated depreciation amount for an existing asset, the QuickBooks application uses that specific figure as the baseline to calculate all future depreciation schedules. If the manually entered accumulated depreciation does not perfectly match the actual historical ledger entries, the automated journal entries moving forward will carry that discrepancy. Ensuring these numbers align before finalizing the asset setup is the most reliable way to maintain accurate books.