inter departmental billing

Hello.  Does anyone know the best way to bill between departments in Sage 100 Contractor?  we have one department that acts as a subcontractor to another department and needs to bill them to recognize the revenue for their work.

  • I had a similar issue with labour timecards for non-company employees.  As they weren't on my payroll, the hours weren't billed to the jobs, so project COGS was being recorded as an overhead expense.  My solution was to create a custom log report in the form of a journal entry that takes the hours/cost out of overhead expense and transfers it into the labour COGS account. 

    The log report gets exported to excel, save-as to change the format, then imported to accounting monthly (Quickbooks as an IIF file, which is essentially a CSV).  I assume sage has a similar function to import transactions from CSV or excel.