n-How to Add an Asset in QuickBooks Online (and Stop Tracking Them in a Spreadsheet)
Go to Settings, then Chart of Accounts, then New, and choose Fixed Assets as the account type. Pick a detail type like Vehicles or Furniture & Fixtures, name the asset, and enter its original cost and purchase date. That creates the asset's account; you then categorize the actual purchase transaction to it instead of to an expense account. Here's the full process, and what it looks like once a spreadsheet isn't tracking your equipment list anymore.
The full walkthrough
1. Open Chart of Accounts. Click the gear icon, then Chart of Accounts under Your Company, then New in the top right.
2. Choose Fixed Assets as the account type. This tells QuickBooks the item belongs on the balance sheet as something the business owns long-term, not an expense that hits the P&L right away.
3. Pick a detail type. Vehicles, Buildings, Machinery & Equipment, Furniture & Fixtures, or Other Fixed Assets. This just controls where it groups on your balance sheet.
4. Name the account. Something specific enough to find later, "2024 Ford Transit" rather than just "Vehicle," especially once you've got more than one asset in the same category.
5. Enter the original cost and date. If you're setting this up for an asset you already own, enter what you paid and when you bought it. This establishes the starting balance; it doesn't post a transaction by itself.
6. Record the actual purchase against the new account. When you pay for the asset (expense, check, or bill), categorize that line to the fixed asset account you just created instead of an expense account. That's what actually puts the cost on your books as an asset.
7. Save. The asset now shows up on your balance sheet under fixed assets, separate from your day-to-day expenses.
Where asset tracking turns into its own side project
One asset account is nothing. The trouble starts once a business has a real fleet of equipment, vehicles, or furniture, and someone's maintaining a parallel spreadsheet with serial numbers, purchase dates, warranty info, and depreciation schedules because QuickBooks' own fixed asset accounts don't hold that level of detail on their own.
That spreadsheet drifts out of sync almost immediately. An asset gets sold or retired and the spreadsheet doesn't get updated the same day, or a new purchase gets entered in QuickBooks but not added to the tracking sheet, and now the two don't agree with each other or with what's actually in the building.
None of that syncing needs to be manual. If the asset data already lives somewhere, a procurement tool, a maintenance system, a fleet tracker, it can create and update the matching QuickBooks fixed asset record automatically instead of someone keeping two records lined up by hand.
What we've built on top of QuickBooks asset tracking
Purchase-to-asset automation
A new equipment or vehicle purchase in a procurement or fleet tool creates the matching fixed asset account in QuickBooks automatically, with the cost and date already filled in, instead of someone setting it up by hand after the fact.
Retirement sync
When an asset gets sold, scrapped, or retired in whatever system tracks that, QuickBooks gets updated the same day, so the balance sheet and the equipment list never quietly drift apart.
How many assets is someone tracking in a spreadsheet right now?
Tell us what that spreadsheet looks like and where the numbers actually come from, and we'll tell you if QuickBooks can stay in sync with it on its own.
Still keeping a separate spreadsheet of what the business owns?
Tell us what you're tracking outside QuickBooks and why it ended up there, and we'll tell you whether it can feed QuickBooks directly instead. And if assets aren't where the real manual work is, that's fine too, n-frames automates whatever's manual in a business, any tool, any process.
Let's talk