PDF document
- 1 -

Enlarge image
                                 RECORD LAYOUT AND DESCRIPTION
                                       LOTUS 1-2-3 SPREADSHEET

  Enter all information in UPPER CASE only.

  Do not use column headings.

  Use Row 1 for the ‘A’ record.

  Use Row 2 for the first ‘D’ record.

  Use the row immediately after the last ‘D’ record for the ‘T’ record.

  Do not leave any rows blank.

  Save file as ‘EXCEL Worksheet’. 

  All diskettes must contain the 8 character entry NJ1080DR as the file name.  The New Jersey Division of Taxation will reject
    and return unprocessed any diskette not properly identified internally by NJ1080DR.  A diskette must not contain any file or
    data set other than NJ1080DR.

                                             “A”  RECORD

Column Field Title                           Column                      Description and Remarks
                                             Width

  A    Record Type                           2      Required.  Enter “A”

  B    Return Year                           5      Required.  Enter return year for Form NJ-1080-C.  For 2000,
                                                    enter “2000”.

  C    Federal EIN                           13     Required.  Enter the entity’s Federal EIN as it appears on
                                                    Form NJ-1080-C.  If the Federal EIN as it appears on Form
                                                    NJ-1080-C is nine digits in length, enter three zeros in the
                                                    three positions after the ninth digit of the EIN.  Do not enter
                                                    dashes.  Left justify the Federal EIN.

  D    Filler                                2      Enter blanks.

  E    Filler                                10     Enter blanks.

  F    Filler                                21     Enter blanks.

  G    Filler                                16     Enter blanks.

  H    Composite Name                        36     Required.  Enter the entity’s name as it appears on Form NJ-
                                                    1080-C.  Left justify and fill with blanks.

  I    Composite Trade Name                  36     Enter the entity’s trade name, if applicable, as it appears of
                                                    Form NJ-1080-C.  Left justify and fill with blanks.

  J    Composite Street Address              36     Required.  Enter the entity’s street address as it appears on
                                                    Form NJ-1080-C.  Left justify and fill with blanks.

  K    Composite City                        26     Required.  Enter the entity’s city as it appears on Form NJ-
                                                    1080-C.  Left Justify and fill with blanks.



- 2 -

Enlarge image
                   RECORD LAYOUT AND DESCRIPTION
                          LOTUS 1-2-3 SPREADSHEET
                              “A”  RECORD (Continued)

Column Field Title                 Column                  Description and Remarks
                                   Width

L      Composite State             3      Required.  Enter the entity’s state abbreviation as it appears
                                          on Form NJ-1080-C.  Left justify the state code.

M      Composite Zip Code          10     Enter the entity’s nine digit zip code if known.  If the four
                                          digit extension is not known, enter the five digit zip code
                                          followed by four zeroes.  Do not enter a dash in this field.
                                          Left justify the zip code.

N      Filler                      12     Enter blanks.

O      Filler                      12     Enter blanks.

P      Filler                      8      Enter blanks.

Q      X                           2      Required.  Enter “X”

                                   “D” RECORD

A      Record Type                 2      Required.  Enter “D”

B      Return Year                 5      Required.  Enter return year for Form NJ-1080-C.  Must be
                                          the same year entered in Record “A”.

C      Composite Federal EIN       13     Required.   Enter the entity’s Federal EIN as it appears on the
                                          “A” record.

D      Participant/Non-participant 2      Required.  Enter a “1” (one) for a participant with total
       Indicator                          income less than $250,000, or “2” (two) for a participant
                                          with income greater than or equal to $250,000, or a “3”
                                          (three) for a nonparticipant.

E      Social Security Number      10     Enter the participant’s social security number or the social
                                          security number/EIN of the nonparticipant.  Left justify the
                                          social security number.  Do not enter dashes.

F      Last Name                   21     Required.  Enter last name of participant/ nonparticipant.
                                          Left justify and fill with blanks.  If nonparticipant is not an
                                          individual, enter the name of the entity.

G      First Name                  16     Required.  Enter first name of participant/ nonparticipant.
                                          Left justify and fill with blanks.

H      Filler                      36     Enter blanks.

I      Filler                      36     Enter blanks.

J      Street Address              36     Enter the participant’s/nonparticipant’s street address.  Left
                                          justify and fill with blanks.

K      City                        26     Enter the participant’s/nonparticipant’s city.  Left justify and
                                          fill with blanks.



- 3 -

Enlarge image
                   RECORD LAYOUT AND DESCRIPTION
                      LOTUS 1-2-3 SPREADSHEET

                             “D”  RECORD (Continued)

Column Field Title           Column                 Description and Remarks
                             Width

L      State                 3      Enter the participant’s/nonparticipant’s state abbreviation.
                                    Left justify the state code.

M      Zip Code              10     Enter the participant’s/nonparticipant’s nine digit zip code.  If
                                    the four digit extension is unknown, enter the five digit zip
                                    code followed by four zeros.  Left justify the zip code.

N      Taxable Income        12     Enter the participant’s taxable income for New Jersey Gross
                                    Income Tax purposes.  If a nonparticipant (position 18 = “3”)
                                    fill with zeros.

                                    NOTE:  All money amounts must be right justified and
                                    contain a maximum of only 11 characters.  The right-
                                    most two positions represent cents in the money amount
                                    fields.  Do not enter dollar signs, commas, decimal points
                                    or negative amounts.  Positive amounts are indicated by
                                    placing a “+” (plus) in the left-most position of the money
                                    amount.  Each money amount field must contain 10
                                    numeric characters.  Unused positions must be filled with
                                    zeros.  (Example:  $2,457.96 is entered as ‘+0000245796’).

O      NJ Income Tax         12     Enter the participant’s New Jersey Income Tax.  If a
                                    nonparticipant (position 18 = “3”) fill with zeros.  See note
                                    above.

P      Filler                8      Enter blanks.

Q      X                     2      Required.  Enter “X”

                             “T” RECORD

A      Record Type           2      Required.  Enter “T”

B      Return Year           5      Required.  Enter return year for Form NJ-1080-C.  Must be
                                    the same year entered in Record “A”.

C      Composite Federal EIN 13     Required.  Enter the entity’s Federal EIN as it appears on the
                                    “A” record.

D      Filler                2      Enter blanks.

E      Filler                10     Enter blanks.

F      Filler                21     Enter blanks.

G      Filler                16     Enter blanks.

H      Filler                36     Enter blanks.



- 4 -

Enlarge image
                   RECORD LAYOUT AND DESCRIPTION
                        LOTUS 1-2-3 SPREADSHEET

                        “T”  RECORD (Continued)

Column Field Title                Column              Description and Remarks
                                  Width

I      Filler                     36     Enter blanks.

J      Filler                     36     Enter blanks.

K      Filler                     26     Enter blanks.

L      Filler                     3      Enter blanks.

M      Filler                     10     Enter blanks.

N      Filler                     12     Enter blanks.

O      Filler                     12     Enter blanks.

P      Number of                  8      Required.  Enter the number of “D” records reported for the
       Participant/Nonparticipant        preceding “A” record.  Right justify and zero fill.  Enter a 
       Records Reported                  total of only 7 characters.

Q      X                          2      Required.  Enter “X”.






PDF file checksum: 3191295558

(Plugin #1/9.12/13.0)