I used to use a 10 to 1 weight to gold ratio. If it weighs 1 but is worth 10g I keep it., otherwise I get too bogged down, or have a fighter carrying 12 sets of armor which I don't like.
I use exactly this technique in Skyrim. Ten gold per pound or I don't keep it.
But there's no weight limit with the BG3 camp chest, so I loot literally everything. My husband and I just sold ~650 gold worth of rotten food that we'd amassed. Everything sells for at least 1gp, so I see everything as gold pieces lying around.
Yes we have enough gold that we don't need to do this.
I have a No Loot Left Behind policy.