fbpx

Home Inventory Value and Small Asset Tracker Spreadsheet

Easily track your household inventory and other small assets and include their value in your total net worth.

Easily track the cost and potential resale value of your household inventory and other small assets and include their value in your total net worth.

From Tiller Community member and spreadsheet builder @jpfieber:

I often resell items when I no longer need them, or have upgraded to a better version. Because of this, I tend to see the embedded value in some of my assets, and I’d like to be able to track that value as part of my Net Worth.

After all, I could sell many of my assets, converting them to cash, which would then clearly be part of my Net Worth.

Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
I first added a manual account called ‘Small Assets’ (I have separate manual accounts for large assets like ‘Home’ and vehicles). I

I then added a column to my Transactions worksheet, and named it ‘Value’. For any transaction that reflects something I’d consider a sellable asset, I add what I think I could sell it for.

For example, I recently purchased a freezer. For the credit card transaction, in the Value column, I put $500.00, assuming I should be able to get at least that much back selling it used.

This is obviously something that needs to be revisited periodically, as the value is likely to decrease or increase over time, depending on the asset.

Some assets values would also need to be removed once the asset was sold.

With all the values established, you could just select the column and see what the ‘sum’ of the value, but I realized my transactions are only reflecting some of my assets.

I have many other ‘small assets’ that I don’t want to have to create manual accounts for to track. To solve this, I created a ‘Small Assets’ sheet with two sections.

In the ‘Manually Entered Assets’ section, I enter the information for any assets that don’t appear in my transactions, either because they were purchased before my transactions were started, or maybe they don’t have a transaction (created a new asset from scratch, etc).

I then have a ‘Combined Assets’ section that uses a query to look both at the Manually Entered Assets, and any transactions with an assigned Value in the Transactions sheet. It combines these into one list, and displays the total ‘Cost’ of all the assets, as well as the total ‘Value’ of the assets.

You can periodically update your ‘Small Assets’ manual account with the current value displayed in your ‘Small Assets’ sheet, and that value will be displayed on your Balances sheet, and will be reflected in your Net Worth!

Learn more about this Tiller Community Solution here in the Tiller Community!

Tiller Community Solutions FAQ

Is this template free?

This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

What is Tiller?

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically tracks your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

What is the Tiller Community Solutions Add-on?

The Tiller Community Solutions add-on for Google Sheets is an easy way to install dozens of free, prebuilt sheets for tracking your budgets, debt payoff goals, net worth, savings, and more. It also includes several helpful spreadsheet utilities and CSV importers.

Does this template have any dependencies or special requirements?

This template for Google Sheets works best when installed in Tiller’s Foundation Template.

Have questions about this template?

Visit the Tiller Community with any questions about this template.

Tiller Community Solutions

Browse free budgeting and personal finance templates made by the Tiller Community for spreadsheets powered by Tiller Money Feeds