Master Comp - Reporting Organization Identifier Field

I think a helpful feature for the master compensation tool would be a new column that indicates that a person is paid by a related organization.

I have several people that appear on multiple returns, but they are only compensated by one entity. When entering this into the master compensation section either manually or through an import, this is can be addressed by entering the compensation for the entity that should report it and leaving the compensation blank for the organizations that would be reporting it as paid by a related org.

Currently, I am using a worksheet with formulas that automatically pulls compensation based on the employee ID number. On my worksheet, I have it set to pull the compensation for a person only if I have designated them as “related” in the vendor ID field (understanding this is not the intended use of this field). If a person has the “related” designation, the formula just puts $0 for all comp on that line. This works well until I need to export the master compensation from c-trac for any reason. When exporting from the master compensation tool on the website, all instances of the person now have “related” in the vendor ID field and it becomes difficult to remember or determine which entity paid the compensation and which ones are just reporting it as paid by related org.

Put simply, I think a new column in the master comp tool tiled “Paid by Related” would be helpful when manipulating the import/export files from the master comp tool.