About the Small Asset and Home Inventory Tracker
The Small Asset Tracker gives you a dedicated place to log the items you own that hold real-world value (electronics, appliances, furniture, tools) and track both what you paid and what you could realistically sell them for today. That estimated resale value feeds directly into your Tiller net worth calculation, so your balance sheet reflects what you actually own, not just what’s in your bank accounts.
The template works two ways: transactions with a resale value added in the Value column on your Transactions sheet are pulled in automatically, and a separate Manually Entered Assets section lets you add items you owned before joining Tiller, received as gifts, or built yourself. Both are combined into a single view that shows the total cost and total current value across all tracked assets.
Built by Tiller Community member @jpfieber for Google Sheets.
Best for: Anyone who owns resellable assets and wants a more complete picture of their net worth beyond cash and investment accounts.
Support & Documentation
Install the Small Asset Tracker through the Tiller Community Solutions add-on. Search for “Small Asset Tracker” in the Explore tab.
For setup instructions and community discussion, visit the Small Asset Tracker thread in the Tiller Community.
If you run into an issue, search the community first and if your question hasn’t been answered, post it in the Get Help > Spreadsheet Templates category.
Another awesome idea from you. Good stuff man!
Thanks for the post. Regarding normal transaction cataloging, would the purchase of a Small Asset, such as a Rolex be considered an Investment “Transfer” Category or something different? Knowing a Rolex retains its value, I wouldn’t consider it a standard purchase but rather an investment.
I would think another way of thinking about it would be to create an account for it. You’d make the purchase transaction a transfer, and then manually update the account with the value. You could periodically update the manual account with any changes in the value. This is really what the Small Asset Tracker does, but with fewer accounts, but for something like this, it might make sense to have an account for it.
OK but at the core the transaction could be logged as “transfer”?
Yea, it could be a transfer to whatever account the rolex is a part of.