Shared business expenses

I have a business where I share expenses with others. Is there a way to automate a process where when a transaction was loaded to the google sheet, a split automatically occurs based on autocat rules? I would like to have a more current understanding of my expenses as they occur, rather than settling up on a quarterly basis (which is what I do now when they cut me a check).

Basically, I pay for these expenses and others reimburse me quarterly. I want more up to date info during the quarter as expenses occur based on only my true expense (not the portion that would be reimbursed by others).

I hope these makes sense :-).


Please read this first and then let me know if you have any questions.