We are construction company and has created projects accounts in assets. To control project expenses we have also created special accounts which are linked to projects. We usually give advances to our staff to incur expenditures on these projects, who are mostly supervisors who control cash on different project.
Supervisors at a time may be controlling multiple projects and we have created account for each supervisor in current asset for the sum given to them. Once we give advance to them, we debit supervisor and credit bank. Then supervisor spend money on different project and we record them project wise expense through special account. For example Rs. 5,000 fuel expense on project 1.
We want report of supervisor wise spending on different project. For example we have advanced Rs. 500,000 to supervisor A, who is in-charge of project 1, 2 and 3. Is it possible to get report of Rs. 500,000 that how the supervisor spent money advanced to him and on which project?
Currently we can able to generate report on total project cost through GL transaction Summary and the same for supervisors as whole, not a project wise. The ledger report of one of the supervisors is enclosed. We require the enclosed report project wise.