Tracking treasure and its distribution has always been a bit of a pain. How much loot has been lost because it got tossed in a bag “for distribution later” and then forgotten?
For our Jade Regent campaign, I got tired of it (and of how much time we spent on doing distributions) so I came up with this Excel spreadsheet format. Warning: It has all our treasure in it, so there’s spoilers for the first two chapters of the Jade Regent Adventure Path.
We keep the spreadsheet on a common Dropbox so all of us can get to it at the game and at home. Whenever we get stuff it immediately goes onto the Party Treasure tab. We note where it’s from so that when we ask our DM two sessions later about identifying or pricing “that toad statue” we can help him figure out where the heck it came from.
Once we pause and do a distribution, all distributed items go to the Distributed Treasure tab. Some of our players aren’t real sharp about writing things down, which is fine if it’s just them sucking due to not keeping their stuff straight but some items are plot related. Also sometimes we have to do distributions when someone’s not there, so this way they know what stuff we gave them last session.
Then there’s a separate Coinage tab for raw cash with a running total of “party funds” and once it gets high enough we dole out shares.
Since this is Jade Regent our caravan has a separate economy of its own, and we track that on the Caravan tab.
We’ve found it very helpful. I don’t like clotting up the session summaries with loot lists (though I’m having trouble breaking Bruce of doing so) and too often it’s one guy who writes it all down in pencil and then loses the list between sessions. Welcome to TECHNOLOGY! Feel free and download it and use it yourself, just tell them Geek Related sent you!
That’s very helpful! I’ve been running Jade Regent for my players for a while now and don’t have anything so elaborate for loot yet, since they’ve been tracking it. This should be very useful for them.
If you’re interested, I have a more GM-specific excel sheet for tracking the Caravan stats, Relationships, etc. It’s available here if you’d like to check it out: http://karuikage.net/dnd/prpg/JadeRegent.xlsx
Looks very helpful, thanks!