Here is GJ with projects, with each project allocated as a percentage

Note the number 2 for the number of projects to be allocated

07-30-15,"1035-9315","S111-04"

50100,133.75,"this is the first project",2

"Basement Renovation",40.00

"Sales Office",60.00

40200,-97.50

40800,-27.50

26200,-8.75

07-30-15,"1034-9315","S33111-04"

50100,234.75,"this is the second project",2

"Basement Renovation",42.00

"Courthouse",38.00

40200,-97.50

40800,-27.50

26200,-109.75

07-30-15,"1034-9315","SS44111-04"

50100,134.75,"this is the third project",2

"Basement Renovation",50.00

"Courthouse",50.00

40200,-197.50

40800,-127.50

26200,-9.75

07-30-15,"1034-9315","Luncheon"

50100,134.75,"this is the forth project",2

"Basement Renovation",50.00

"Courthouse",50.00

40200,-97.50

40800,-27.50

26200,-9.75

07-25-15,"1034-9315","GasExpense"

50100,334.75,"last line for project",2

"Basement Renovation",60.00

"Sales Office",40.00

40200,-97.50

40800,-227.50

26200,-9.75

GJ thanks for the reply.   I am having some difficulty interpreting the lines of code in your response.  For example, in line 2, what does 50100 represent, GL number?   Also "This is the first project" ?

In line 3 is "Basement Renovation" the project?

What version of Sage do you run?  I have Sage 50 Premium and they are restricted to four digit G/L #'s.

Thanks so much for your help,

JBEEZ

It will make more sense if you open the sample comapny that these entries were modelled on.  Yes Basement Renovation is a Project name and you can extend account numbers to 8 digits in Premium and higher but I can't remember if the Premium sample file uses 5 digits or not.  If not, then just modify then entry GWG used and reduce the account number to 4 digits by removing the last zero.  eg. 50100 is 5010 and 40200 is 4020.

This entry works in pretty much any version after 2006 or 2007.  I can't remember when projects were added to the journal entry import.

How do I access the sample data?

Look at my txt file.  

10-11-14,PayrollTEST

5420,500.00,"this is the first project",2

"AB1208-02",250.00

"AB1400",200.00

5430,150.00,

5463,600.00,

5464,3060.00,

1060,-4010.00,

2180,2000.00,

2180,-2000.00,

2185,1000.00,

2185,-1000.00,

2190,500.00,

2190,-500.00,

2210,-300.00,

5420 is the expense account in which I am trying to allocate costs amongst two job sites, ab1208-01 and ab1400

I am getting the following error upon export.

Import started...

Reading transactions...

Reading transaction PayrollTEST.

Import Error:  The total percentage of all Job Site allocation lines cannot exceed 100% or be less than 0% in line 2.

Not sure why it is giving me this error.....

Thoughts?

JBEEZ said:

How do I access the sample data?

Open the program and on the open company dialog select the sample company as in the image below.  If you don't see this dialog, open your company file and then select View, Select Company Window At Startup.  Then reopen the program.  Or you can search for the file universl.sai on your system and find it deep under c:\users\public.... and open it from there.

JBEEZ said:

"AB1208-02",250.00

"AB1400",200.00

Import Error:  The total percentage of all Job Site allocation lines cannot exceed 100% or be less than 0% in line 2.

I suppose it might be too obvious but both 250 and 200 are larger than 100.  As GwG stated, it allocates by percentage and percentage only.

Richard:

Thanks for your help.   I didn't realize it allocates by % so that solved the problem. When I put the %'s in it worked slick.

Thanks again,

John