I need someone to produce a spreadsheet to manage the following problem for us through providing a spreadsheet.
"We are 3 people with 3 different bank accounts, we have decided to share the expenses and profits between us 30%, 35% and 35%. So what we need is an excel where we can enter the expense individually from each person and who paid from their account and then it would automatically divide the expense. We would like it to divide the profits as proportionally as well. Also, as example of complication is that when a person pays for an expense say $100, he is only responsible for $30, he needs $70 from the total profit and then the remaining profit is divided proportionally. I hope this makes sense. Thank you,
36 freelancers are bidding on average $95 for this job
Hi there, I am a qualified accountant (CPA equivalent) with ~10 years experience in financial statement analysis. I can create the required excel. Look forward to hear back from you. Thanks, RRC