Archive of CFMA.org Forums > Tips, Tricks, & How To's > MAS200 Balancing JC sub ledger to General Ledger

Tue, 03/13/2012 - 3:51pm  
Ivy Schlegel

We are using MAS200 and I am having trouble finding a report(s) that will help with the reconciling of Job Cost to General Ledger.  Has anyone else had this problem and what did you do to solve it.

Thank you,

Ivy Schlegel

Thu, 03/15/2012 - 11:33am #1
Joe Uff

Ivy,

No matter what software you use it is a good practice to setup your category codes in the job cost to relate to the GL account. Remember that your GL cost accounts get closed out at the end of a reporting period whereas your JC codes stay open period to period. So for an example,if I were to reconcile my equipment (cat "E") I would run a job cost transaction report for period 1/1/2012 to 2/29/2012 sorting on the E category in my job Cost module and it should tie back to my GL account for equipment through my February close.

You may have to create your own report. Good Luck! I hope this helps you.

Joe Uff, Philadelphia Chapter

Wed, 03/14/2012 - 5:05pm #2
Mary Kay Predayna

We are a user of MAS90.  We use the Work in Process Report and some Crystal Reports developed for us by our MAS90 consultant.   In part it depends how you are tracking WIP in your general ledger.

Mary Kay Predayna