WIP Contract Schedules

SUGGESTED

I am curious how Sage 300 users calculate gross profit for financial reporting on a monthly basis and what they use to tie it back to the jobs. 

  • 0
    SUGGESTED

    There are some canned WIP reports in JC.  You can use a custom WIP report that ties to GL -or Event1 has and Excel WIP available as well.  

    You have the the ability in JC/PJ to do Cost @ Complete /Cost to Complete AJE's to get Gross Profit.  ou can use WIP as on a specific date and Misc Worksheets to enter AJE's.  

  • 0 in reply to Bill Kormoski

    I first used the canned WIP as of a specific date report to make the over/under billing entries, but then made some modifications to it.  I first changes the estimate and contract to not be impacted by the cutoff date. Then I changed the % complete column to reflect the amount entered in job cost through Misc Worksheets based on revised field estimates, then changed the billed to date to be total billed including retention, and added a column for revenue earned. I think I now have a pretty good contract schedule for job to date and profit projections at completion.

    What I am looking for is when I run a monthly and YTD financial statement, is a schedule job by job that will tie back to the earned revenue and gross profit on that monthly and YTD income statement.  This is so that if the gross profit percentage on the financial statement is abnormal, then I can go to the jobs and see what is causing that.

    Does this question make sense?

  • 0 in reply to pat31756
    SUGGESTED

    Another option customers have used either as a canned standard report or with slight modifications is the JC Profit as of date Report, found in JC Reports, Cost Control, Profit as of date. Projected Profit is calculated as Revised Contract Amount minus Cost at Completion Amount. Of course, what defines this for Company A versus your Company can be different, but the report can be modified to meet your reporting needs.