My party and I had just finished part of a Pathfinder campaign and are converting over to D&D 5e. Previously we mostly just distributed all the loot between ourselves with the paladin carrying the majority of the heavy items (as he was the strongest). We mostly ignore armour and currency for encumbrance, and are very lenient with inventory. If any individual item would be extremely awkward to carry in real life we may consider ourselves encumbered.
We often forget about magical items we've picked up in the Pathfinder campaign, like rings of protection or cloaks of resistance. Sometimes we've forgotten they exist when a character dies and we bury them (despite our characters likely seeing it on the fallen character). We try to split useful items around, and sell everything else, but we've also lost track of notable items for the story-line when people are either missing from the session or are skimmed over from another person's character sheet. We'd try to have a few of each consumable we'd carry on each person in case we get caught in a pinch, but then we don't know exactly how many we have due to the lack of communication. But communication could be a whole nother issue.
This led to some issues with regards to knowing
- How much money we actually had, and
- Knowing what loot we had and how it could've been useful
The result was that at the end of this campaign we hadn't sold much, and our DM did a bunch of extra work to figure out everything we should've had, and currently do have, and we had a little scene with a merchant we had a... poor history with. We went from having about 10k gold pieces between the four of us to about 115k gold.
We decided to create the meta-role of treasurer (which I'll be primarily filling), but I'm looking for a good system to keep track of all the items. Here's what I've thought of so far, but I was wondering what other people do or what I'm missing.
I've created a Google Sheets page that has the following columns:
ID; Date Recieved; Item Name; Quantity; Brief description; Cost
Then one field for “Current Wealth (GP)” and one for “Current Wealth (Total)” which will be the estimated value if we sold all our loot at 50% value at a merchant.
What I'd like to ask is...
- What items should I be logging? Everything? Only loot/sellable items? Consumables?
- Would I log everything, including what other people have?
- If I was to keep the majority of the money for the group, should we try to keep a consistent nK gold on each character? Say 2000 for random purchases if we get split up?
As it's been discussed in the comments, I'm not looking for why to log items, but rather how people have done it previously. I'm relatively new to D&D, but I enjoy looking after data and making sure we're all ready to go before our next part of the journey. I just don't know how to make my spreadsheet effective, prior from testing it out. As you add things to a sheet, you loose data you would've otherwise had if it was built properly in the first place.
I don't believe this question should be put on hold because I believe that this sort of meta-role should have some best practices/methods and have objective pros/cons in every campaign.