Discussion: View Thread

OH Allocation in Sage 300 CRE

  • 1.  OH Allocation in Sage 300 CRE

    Posted 02-05-2015 10:14
    This message has been cross posted to the following Discussions: General Inquiries and DallasFt. Worth, TX .
    -------------------------------------------

    I have a highway contractor client that is having the following problem using Sage 300 CRE for OH allocation.  They are using HeavyBid as their estimating software.

    "We are using SAGE 300 CRE version 13.1 and would like to automate our monthly overhead allocation.  We are looking for a solution that will be part of our month end close process that allocates certain overhead accounts to job cost.  As an example, if we were allocating $100k from overhead to job cost we would spread the $100k to jobs on a percentage basis of total job cost for the month.  Does anyone know of a way to do this in the SAGE software?"

    Can anyone provide any feedback to solve this issue?



    -------------------------------------------
    Paul Morris, CPA Accountancy
    Audit Manager
    PriceKubecka, PLLC
    Addison TX
    (972) 888-0950
    -------------------------------------------


  • 2.  RE: OH Allocation in Sage 300 CRE

    Posted 02-06-2015 04:49
    Paul,

    If your client has Office Connector, you can integrate an Excel spreadsheet with Sage 300 CRE Job Cost to accomplish the allocation.  You can use Office Connector to populate the spreadsheet with open jobs, costs for the month and the balances of the overhead accounts.  Office Connector Import can be used to automate the import of the allocation as direct cost entries.

    An alternative would be to use a custom Crystal Report to perform the allocation, which can be exported as a comma-delimited file and easily imported as direct cost entries.

    We are Sage 300 CRE consultants in DFW and can assist with the process, if desired.

    Tom

    -------------------------------------------
    Thomas Kline CPA
    President
    The Totally Great Companies, LLC
    Dallas TX
    (972) 695-4200
    -------------------------------------------