What is the goal of your workflow? What problem does it solve, or how does it help you?
I often resell items I’ve purchased when I no longer need it, 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.
How did you come up with the idea for your workflow?
I previously released a template for doing this here. This is a cleaned up “Refreshed” version.
Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
On your Transactions sheet, click the header for your “Amount” column to select it, then right-click it and choose “Insert 1 Column Right”. Title the new column “Value”. Click the header for the “Value” column to select it, then click the ‘$’ button in the toolbar to format it as currency.
Find a couple transactions that are for items that will retain some value over time. In the “Value” column for each of those items, type the amount of money you think you could sell that item for (it’s current “value”) as a positive number.
Click the link to the template below and copy the sheet to your Foundation template. Right-click the sheet name and change it to “Small Assets”. In the “Combined Small Assets” list on that sheet, you should now see a list of the items you added a “Value” to, and you’ll see the total “Cost” and “Value” listed at the top. If you add a manual account in Tiller, and call it “Small Assets”, you can add this value to it, so your small assets will be included in your Net Worth!
This works great for anything new that you purchase and have a transaction for, but what about those items you got before you started with Tiller, or items you got as gifts or you built yourself? For those, notice on the top right corner of the Small Assets sheet a sideways heading that says “Add Manual Assets”, and points at a “+” above column “H”. Click the “+” and it will expand, showing you a “Manually Entered Assets” list. Add the info for any items you’d like to include in your Net Worth calculation. If there isn’t a “Cost” (eg. You got it as a gift), leave that blank. “Category” is also optional, and isn’t currently used for anything. You can even leave the date blank if you’re not sure, but including an estimate is probably a good idea so it sorts well with your other assets. As soon as you add an item, you should see it appear in the “Combined Small Assets” list. When you’re done, click the “-” above column “H” and that section will hide itself.
Anything else you’d like people to know?
Every now and then, as you purchase items and add a “Value” for them, you’ll need to manually update your “Small Assets” account to reflect the change in Value. You’ll also periodically want to review the list, removing a value from any items you no longer have, and changing the value for any items who’s value has increased or decreased (these changes happen in the “Value” column on the Transactions sheet).
Is it ok for others to copy, use, and modify your workflow?
Yes, and let me know of any problems or ideas for improvements!
If you said yes above, please make a copy of your workflow and share the copy’s URL:
You can now find this in the Tiller Community Solutions extension, it’s called “Small Asset Tracker”