Topic: New Project - GL
One of the partners (Partner A) of our company is investing in a new project - Let's call it HOSPITAL. This project has 3 other investors, all equal partners. Since all the purchases/investments are being done by our partner, Partner A has asked everyone to send the money to our account and then we will make the necessary payments on behalf of the HOSPITAL.
Since I do not want these investments/expenses to come into my PL, I am making a new account HOSPITAL under Current Liability. Now when one of the 3 partners brought in money:
HOSPITAL Credit (with Memo as the name of the person investment)
BANK Debit
When we make a payment to suppliers for this project:
HOSPITAL Debit (with Memo as the name of the person investment)
BANK Credit
The balance of this account is the investment brought in by Partner A. Now the problem is tracking the investments made by different partners as I have to go through the Memo and update an external excel sheet.
Is there an easy way to do this, like a sub-account or group with all Partners. So I can account all investments under their name, but all expenses will be accounted to the parent account HOSPITAL. This way the HOSPITAL account will always be balanced.
I dont know if I am doing it right. Any help would be appreciated.