We use the job cost module, and the majority of our jobs are percentage of completion basis. We run all of our job-related items through the job cost module, including our wages and sub-contractor invoices. As some of the subcontractors do not have WCB coverage of their own, we are required to remit on their behalf. How do I get these figures from the modules now? Payroll is easy, as we use Paymate and can get a report from there. But it's the sub-contractor figures that are difficult to find.

Prior to running the Job Cost module, these invoices were entered in Payables and expended to a "subcontract labour" G/L account, so I was able to run a GL report to find the required amounts. Now that it goes through JC, it flows through to a WIP account and then to the expense account based on % complete or when the job closes. This doesn't work for the WCB remittance as they need to know 100% of what the invoice was. Also, once they hit the expense account only the Job number is listed--nowhere does the vendor code or name show up.

I have set up these subcontractors in their own report group and was able to print the report showing all the invoices charged, but these amounts contain the taxes and any materials that they may have charged to us (and I just need the labour portion). So then I had to back-track to the purchase order module or even to hard copy in order to find the correct amounts to report on our WCB remittance.

Has anyone else faced this or a similar situation when using the Job Cost module? Any insight on how to make this work better would be greatly appreciated.