Hello Linda,

Have you clicked on "Help" in the Job Cost application? Search for "import estimates" and you'll find the required file structure and layout, what you're referring to as a "template." 

You can also go to the Sage Knowledgebase and search for Solution ID: 24298 "Is there an example/template of Job Cost's Import Estimate?"  There are two attached files for download in that Solution ID.

Art Minds
Independent Senior Consultant
Pasadena CA

Thanks Art.  I got those but still not understanding.  What are the "P" and "C" for?  Also, what is the "JCE" file?  I cannot open that one.  I need to see the initial setup of the Excel file and what each column is for.  Also, need to see how headers are entered.  I have 19 floors and with each floor, I have 15 cost codes with estimate dollars for all and some also have estimated hours (units).  Any ideas??

Hi Linda,

Your questions are answered in the Knowledgebase Article: P = Cost Code (Phase) (if the cost code is not already set up; C = Cost Code estimate amount.  A link to the Sage Knowledgebase is below, in the footer of this web page. The JCE file is the required naming convention for the Job Cost Estimate import file. 

Art Minds
Independent Senior Consultant
Pasadena CA

Thank you, thank you!!  Taking a look at that now.  I appreciate your help.  Hopefully I will figure this out, if not, I'll be back :-).

Thank you, thank you!!  Taking a look at that now.  I appreciate your help.  Hopefully I will figure this out, if not, I'll be back :-).

Hi Linda R, if the above suggested answer helped, please do mark it as verified  (by clicking the "more" button) for the benefit of others in this forum :). Thank you!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey