Party Accounts

[Wolfgar]

I have started an accounting system for the party. Each party member gets an account as well as the party as a whole. This tracks undistributed treasure. This only includes the treasure from the Mud Sorcerer's Tomb. We could add in the stuff in Barb-el-Shay at some point. A distribution indicates money has gone from one account to another. A withdrawal indicates that you have taken money out and it is now your responsibility to track. I would appreciate it if the DM updated the character sheets of those players who have made withdrawals (Bolo, Colby, Friedrich). You can make a contribution if you want to add money to your account. The bank is going to be whatever storage is available - qbox, ship, vault, etc. If valuables are destroyed or stolen they will deducted pro rata against all account balances. I am not sure how to handle the conversion rate for gems and jewelry.

Here is a link to the spreadsheet.

Here is the current state of the accounts.

Account	Starting Balance	Credit	Debit	Ending Balance
Party	0	183327.16	101025	82302.16
Azhbar	0	5000	2025	2975
Basmadoos	0	5000	2375	2625
Colby	0	7500	4000	3500
Dan	0	5000	0	5000
Friedrich	0	7500	5000	2500
Haddiq	0	5000	1000	4000
Ingrid	0	5000	1225	3775
Mamnoon	0	5000	0	5000
Mary	0	5000	675	4325
Paavo	0	7500	1750	5750
Trommer	0	7500	0	7500
Youssef	0	5000	3800	1200
Bolo	0	2000	2270	-270
Nordel	0	2000	5	1995

*Bolo is overdrawn because he has withdrawn everything from his account as well as had expenses for training and other things. I can zero this out if the DM deducts the 270 from his character sheet. The expenses will then be considered off book. Otherwise we'll just wait for the next distribution to sort things out.

Here are the individual transactions that went into this. I gave PC's a distribution of 7500gp and NPC's 5000gp. Training costs where split between the character and the party. I tried to determine party expenses versus individual expenses. Any of these number can be adjusted. This is just a starting point.

Account	Type	Credit	Debit	Description
Azhbar	D	5000		share from Mud Sorcerer's Tomb
Azhbar	E		50	purchase lodging in Pentadastion
Azhbar	E		700	Azhbar for new attack routine
Azhbar	E		275	Azhbar weapons training in the khopesh
Azhbar	E		1000	tithe
Basmadoos	D	5000		share from Mud Sorcerer's Tomb
Basmadoos	E		50	purchase lodging in Pentadastion
Basmadoos	E		1050	Basmadoos for new attack routine
Basmadoos	E		275	Basmadoos weapons training in the khopesh
Basmadoos	E		1000	tithe
Bolo	D	2000		for services rendered in Mud Sorcerer's Tomb
Bolo	E		15	purchase legal aid/scribe services
Bolo	E		5	purchase bone scroll tube
Bolo	E		250	Bolo bola training
Bolo	W		2000	withdrawal
Colby	D	7500		share from Mud Sorcerer's Tomb
Colby	E		2000	purchase 2 deep pocket robes
Colby	W		2000	withdrawal
Dan	D	5000		share from Mud Sorcerer's Tomb
Friedrich	D	7500		share from Mud Sorcerer's Tomb
Friedrich	W		5000	withdrawal
Haddiq	D	5000		share from Mud Sorcerer's Tomb
Haddiq	E		1000	tithe
Ingrid	D	5000		share from Mud Sorcerer's Tomb
Ingrid	E		1225	Ingrid for 4th level spells
Mamnoon	D	5000		share from Mud Sorcerer's Tomb
Mary	D	5000		share from Mud Sorcerer's Tomb
Mary	E		675	Mary for 5th level spells
Nordel	D	2000		for services rendered in Mud Sorcerer's Tomb
Nordel	E		5	purchase 5 flasks of oil
Paavo	D	7500		share from Mud Sorcerer's Tomb
Paavo	E		1000	tithe
Paavo	E		750	Paavo 1st level cleric spells
Trommer	D	7500		share from Mud Sorcerer's Tomb
Youssef	D	5000		share from Mud Sorcerer's Tomb
Youssef	E		750	purchase (2) bronze tablets
Youssef	E		350	Youssef for 4th level spells
Youssef	E		2700	Youssef for 5th level spells
Party	D		7500	distribution to Paavo
Party	D		5000	distribution to Dan
Party	D		5000	distribution to Youssef
Party	D		5000	distribution to Mamnoon
Party	D		5000	distribution to Ingrid
Party	D		7500	distribution to Colby
Party	D		5000	distribution to Haddiq
Party	D		5000	distribution to Azhbar
Party	D		5000	distribution to Basmadoos
Party	D		7500	distribution to Trommer
Party	D		7500	distribution to Friedrich
Party	D		5000	distribution to Mary
Party	D		2000	distribution to Bolo
Party	D		2000	distribution to Nordel
Party	E		5000	purchase 50 units of ink
Party	E		150	purchase large pavilion
Party	E		1500	purchase (2) spellbooks
Party	E		10000	purchase 100 more spell ink
Party	E		2500	purchase 25 pearls
Party	E		300	to Khaddil for services rendered
Party	E		350	Youssef for 4th level spells
Party	E		1225	Ingrid for 4th level spells
Party	E		1050	Basmadoos for new attack routine
Party	E		700	Azhbar for new attack routine
Party	E		2700	Youssef for 5th level spells
Party	E		250	Bolo bola training
Party	E		750	Paavo 1st level cleric spells
Party	E		275	Basmadoos weapons training in the khopesh
Party	E		275	Azhbar weapons training in the khopesh
Party	I	181177.16		treasure from Mud Sorcerer's Tomb
Party	I	150		sale of coffin
Party	I	2000		sale of 4 mud sorceror books

D=Distribution, W=Withdrawal, E=Expense, I=Income, C=Contribution

[Ginger]

Amazing work. This is great.

I assume dervishes tithe? They'll each contribute 1000 to the Church of the One God, unless they think it's too corrupt and urbanized, in which case they'll spend some of their time in the city looking for a more humble venue.

[venger]

This is good. Very good.

So good in fact, the cost of converting gems and jewelry is entirely recouped when the party manages to sell one of the antique sets of platinum jewelry for much more than they anticipated and thus doesn't need to be accounted for whatsoever.

[Wolfgar]

Thanks.

Should people post transactions (withdrawals, contributions, expense) here? Or would you rather they be posted in the other threads?

Either way I will try to add them to the spreadsheet as they occur. Unless the DM would rather manage this.

[venger]

Let's keep the transactions in their individual threads. I don't see that being a problem.

Though I don't have your facility with posting tables on the messageboard, I don't mind updating this on an spreadsheet and providing the link.

However when a cost is incurred we should definitely now indicate whether it is a party expense or a personal expense or both.

[Wolfgar]

I have added another column to the transactions table to indicate the type of transaction. This makes it easier to do some reporting.

Total Income	183327.16
Total Expenses	42150
Total Withdrawals	9000
Total Distributions made	74000
Total Distributions received	74000

The total expenses plus total withdrawals should be the amount deducted from the treasure inventory. The total distributions is there to make sure I didn't make a mistake (which it turns out I did make).

I'll email you my latest spreadsheet and you can update it going forward. If you want anything posted I am happy to convert it to a table.

[Bolo]

Awesome. Love it.

[venger]

132169 - total remaining
50067 - party accounts
82102 - party funds

Account | Ending Balance
Party |82102.16
Azhbar |2975
Basmadoos | 2625
Colby | 2500
Dan | 5000
Friedrich | 2500
Haddiq | 4000
Ingrid | 3775
Mamnoon | 5000
Mary | 4325
Paavo | 5750
Trommer | 8500
Youssef | 1200
Bolo | -270
Nordel | 1995
Haidar | 192

[Ginger]

Aug 30, 2013 10:58:32 GMT -5 Ginger said:

Amazing work. This is great.

I assume dervishes tithe? They'll each contribute 1000 to the Church of the One God, unless they think it's too corrupt and urbanized, in which case they'll spend some of their time in the city looking for a more humble venue.

I forgot to follow up on this on Sunday, but can we make a deduction for this?

[venger]

I believe it was already done from their shares.