Page tree
Skip to end of metadata
Go to start of metadata

Table of contents

Starting ICS Import Declaration

To start ICS Import Declaration, from ICS menu select item N400

    +---------------------------------------------------------+
    |  +---------------------------------------------------------+
    +--|  N000 Customs*   ICS                                    |
    |  +---------------------------------------------------------+
    |  |  1-N100-Customs*   ICS Export                           |
    |  |  2-N200-Customs*   ICS Import Air                       |
    |  |  3-N300-Customs*   ICS Import Sea                       |
    |  |> 4-N400-Customs*   ICS Import Declaration               |
    |  |  5-N500-Customs*   ICS Maintenance                      |
    |  +--------------------------RSISYD/3o rspar-no:02 user:RSI-+
    |  8-M000-Customs*   Customs Services                     |
    |  9-N000-Customs*   ICS                                  |
    | 10-Y000-Admin  *   System Maintenance                   |
    +--------------------------RSISYD/3o rspar-no:02 user:RSI-+

Full Import Declaration

To start Full Import Declaration, from ICS menu select item N401

    +---------------------------------------------------------+
    |  +---------------------------------------------------------+
    +--|  +---------------------------------------------------------+
    |  +--|  N400 PROCUST    * ICS Import Declaration               |
    |  |  +---------------------------------------------------------+
    |  |  |> 1|N401|PROCUST    * ICS Declaration Lodgement          |
    |  |  |  2|N402|PROCUST    * ICS Self Assessed Clearance        |
    |  |  |  3|N403|PROCUST    * ICS Supplier Profile               |
    |  |  |  4|N404|PROCUST    * ICS Importer Profile               |
    |  +--|  5|N405|PROCUST    * ICS Tariff Master Codes            |
    |  8|J|  6|N406|PROCUST    * ICS Product Description            |
    |  9|K|  7|N407|PROCUST    * ICS Currency Exchange              |
    | 10|L+---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+
    | 11|N000|PROCUST    * ICS Customs Module                 |
    +---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+

Lodge import declaration

Pre-lodge import declaration

Amend import declaration

Withdraw import declaration

Pay import declaration as part of declaration lodgement

Pay import declaration using Payment Approval message

Receive Payment Receipt

Print import declaration document

View Customs Message Advice

Customs Message Advices are advices sent in response to an import declaration lodgement and pertaining to a particular tariff line. The advices contain information about additional Customs requirements, such as import permits, instruments, quarantine clearance, etc. Some message advices contain information about tariff classification, such as expiry date.

Since version 2.10 of Import Declaration program, ICIDMNT, user receives automatic notification about new message advices, when they exit the program:

                    +--------------------------------------+                    
                    |    You have 1 new message advice     |                    
                    | >VIEW NOW  <(VIEW LATER)(DON'T ASK ) |                    
                    +--------------------------------------+
  • Select option VIEW NOW to display message advice.
  • Select option VIEW LATER to display message advice next time, you exit the program.
  • Select option DON'T ASK to turn off automatic notification of this message.

To view existing message advice any time:

Self Assessed Clearance

Imported goods with a value that does not exceed prescribed amount (currently $1000) can be cleared using a Self Assessed Clearance Declaration (SAC). The owner of the goods (or someone acting on their behalf) is required to make the following statements:

  • Whether the value of the goods does not exceed $1000 (or other prescribed amount).
  • Whether the goods are subject to quarantine.
  • Whether the goods are subject to any prohibition or restriction.
  • Whether there are alcohol or tobacco products in the shipment.

SAC Declaration may be communicated to Customs in two ways:

  • Cargo Reported SAC Declaration
    The Cargo Reporter can submit a SAC Declaration on behalf of the importer by ticking a SAC Declaration indicator on the Air Cargo Report. By ticking this field the reporter submitting the Cargo Report is nominating that the goods meet all the SAC criteria. SACs submitted with a Cargo Report are processed through Import Cargo Reporting (ICR). This method is explained in respective section of user guide to ICS Import Air or ICS Import Sea.
  • Separately - Lodged SAC Declarations
    A Customs Broker, Importer or other authorised EDI user can complete and submit a SAC on behalf of an importer as an EDI message. SAC Declaration submitted as a separate document is edit and validated through ICS Import Declarations. This method is explained in this paragraph.


Detailed Self Assessed Clearance (DSAC) Declaration
DSAC Declaration is a more detailed version of a Self Assessed Clearance Declaration. It is required when the goods being imported meet the low value criteria i.e. have a value that does not exceed the entry threshold (currently $1000), but duty and tax are payable. Currently this is only the case if the goods are alcohol or tobacco products. DSAC Declaration may only be communicated to Customs as a separate DSAC Declaration document. There is no provision for DSAC Declarations to be submitted to Customs as part of a Cargo Report.

SAC formats
There are two document formats available for submitting separately lodged SAC and DSAC Declaration, the short form and long form options:

  1. Long Form SAC
  2. Short Form SAC

Self Assessed Clearance (Long Form)

The long form SAC is essentially a full import declaration that includes the self assessed clearance lodgement declaration. The long form SAC differs from the short form SAC in the following ways:

  • It is expected that the long form is primarily used for detailed self assessed clearance declarations.
  • The input data required is the same as for the full import declaration.
  • The full import declaration edit and validation rules apply.
  • Customs calculates duty and GST on alcohol and tobacco products only.
  • Cost recovery charges are levied at the SAC declaration rate.

The long form SAC is processed in almost all respects in the same way as a full import declaration, although some calculation processing is determined by the answers to the SAC Lodgement Questions about:

  • community protection concerns
  • alcohol and tobacco products
  • AQIS concerns

To start Long Form SAC, from ICS menu select item N401

    +---------------------------------------------------------+
    |  +---------------------------------------------------------+
    +--|  +---------------------------------------------------------+
    |  +--|  N400 PROCUST    * ICS Import Declaration               |
    |  |  +---------------------------------------------------------+
    |  |  |> 1|N401|PROCUST    * ICS Declaration Lodgement          |
    |  |  |  2|N402|PROCUST    * ICS Self Assessed Clearance        |
    |  |  |  3|N403|PROCUST    * ICS Supplier Profile               |
    |  |  |  4|N404|PROCUST    * ICS Importer Profile               |
    |  +--|  5|N405|PROCUST    * ICS Tariff Master Codes            |
    |  8|J|  6|N406|PROCUST    * ICS Product Description            |
    |  9|K|  7|N407|PROCUST    * ICS Currency Exchange              |
    | 10|L+---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+
    | 11|N000|PROCUST    * ICS Customs Module                 |
    +---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+

Self Assessed Clearance (Short Form)

The short form SAC is specifically intended for self assessed clearances and requires a minimum amount of information to be supplied. The short form SAC differs from the long form SAC in the following ways:

  • Fewer input fields
  • Importers are not required to be registered as Clients in ACS, unless they are submitting the SAC on their own behalf.
  • Tariff and valuation information is only required when alcohol and tobacco has been declared.
  • Where the Community Protection concerns question or the Quarantine concerns question is answered YES a Reason for Referral is required and the SAC is routed to the appropriate Customs or AQIS evaluation workgroup, or directly to AQIS systems as directed by the profile.

The information required on a short form SAC is determined by the responses to the SAC Lodgement Questions:

  • Minimum Information - when the goods being imported meet the specified low-value criteria, have no Community Protection or Quarantine concerns and do not contain alcohol or tobacco products, only minimal data is required to describe the goods and allow matching to the Cargo Report.
  • Community Protection and Quarantine Concerns - when the low-value goods do not contain alcohol or tobacco products but have Community Protection or Quarantine concerns, extra information must be provided for risk assessment purposes. As well as a goods description and cargo matching data, the following is also required:
    • Tariff classification
    • Quantity
    • Value
    • Transport and insurance costs
    • Value of the remainder of the consignment (to apportion T&I).

To start Short Form SAC, from ICS menu select item N402

    +---------------------------------------------------------+
    |  +---------------------------------------------------------+
    +--|  +---------------------------------------------------------+
    |  +--|  N400 PROCUST    * ICS Import Declaration               |
    |  |  +---------------------------------------------------------+
    |  |  |  1|N401|PROCUST    * ICS Declaration Lodgement          |
    |  |  |> 2|N402|PROCUST    * ICS Self Assessed Clearance        |
    |  |  |  3|N403|PROCUST    * ICS Supplier Profile               |
    |  |  |  4|N404|PROCUST    * ICS Importer Profile               |
    |  +--|  5|N405|PROCUST    * ICS Tariff Master Codes            |
    |  8|J|  6|N406|PROCUST    * ICS Product Description            |
    |  9|K|  7|N407|PROCUST    * ICS Currency Exchange              |
    | 10|L+---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+
    | 11|N000|PROCUST    * ICS Customs Module                 |
    +---------------------RSISYD/3B rspar-no:02 user:RSI-TEST-+

Create Self Assessed Clearance document

To create SAC Declaration, enter screen SAC Query. In field Shipment type in shipment number and press PageDn to leave other fields empty. If you don't know shipment number you can search for an existing shipment in air import using F2 LookAir or sea import using F3 LookSea.

Select Yes to confirm that you want to create SAC declaration for this shipment or No to cancel.

                    +--------------------------------------+-+
                    | Create SAC for shipment 9999999999 ?   |
                    |         >Yes     <(No      )          ++
                    +-------------------------------------- o

Enter screen SAC Declaration Header. Fill in missing fields in header section. Check fields brought over from import registration program and correct if necessary.

When you enter data through the fields Importer and Delivery, these fields expand into dedicated screens containing detailed information.

Entering importer details:
Unlike in full import declaration, in SAC importer is identified using Importer ABN or Id (and optionally CAC) or Importer Name. You must choose one and only one of these references. If you choose Importer ABN or Importer Id you can leave the remaining fields empty.

Entering delivery details:
If delivery details are different from importer details, you need to key them in. If delivery details are the same what importer details, edit field Delivery Name and select option F3 AsImp.

Select F7 AddInfo to enter screen SAC Declaration Header Additional Information and fill in additional fields there. This screen contains mostly fields used in detailed SAC.

If you lodge detailed SAC you must create at least one tariff line containing details of the goods being imported. To do this, select F4 Tariffs and enter information in SAC Declaration Tariff Line.

Select F10 Exit to save information and quit SAC declaration program. Your SAC declaration is now ready for sending.

Search and open existing SAC document

Lodge SAC

Lodge and pay SAC

Amend SAC

Withdraw SAC

Pay SAC after successful lodgement

View Payment Receipt for SAC

Print SAC

Answering Lodgement Questions

In order to obtain import declaration clearance, a broker must answer all lodgement questions when submitting declaration to Customs. There are several types of lodgement questions. All questions are asked in the order of their identifiers, i.e. question id=1 is asked first, question id=2 is asked next and so on. The only exception to this rule is the goods delivered question (id=14) which is always asked first, if applicable. Lodgement questions are not asked if Pre-lodgement Indicator is set to Y.

Answering declaration questions.

Declaration question is a lodgement question which must be answered YES or declaration will be rejected by Customs. Declaration question is indicated by Lodgement Question Indicator set to N. One of the most common declaration question is question id=1, shown below:

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| LODGEMENT                      Id:     1N Type: GLQ              Permit:     |
|                                                                              |
| I ACKNOWLEDGE THE SIGNATURE OF AN OWNER/AUTHORISED AGENT (CUSTOMS BROKER     |
| ) MUST BE APPLIED TO THIS ELECTRONIC COMMUNICATION IN ACCORDANCE WITH TH     |
| E REQUIREMENTS DETERMINED UNDER THE CUSTOMS ACT.                             |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+

Answering N to this type of question generates following warning:

             ----------------------------------------+-+          |
             | Answering "No" will reject declaration. Continue?    |
             |                >No      <(Yes     )                 ++
             +---------------------------------------------------- o
  • Select No to re-enter answer.
  • Select Yes to lodge declaration without quoting this question. This will cause declaration to be rejected.

Answering General Lodgement Questions

General Lodgement Question is indicated by Lodgement Question Type set to GLQ. This type of question does not apply to the goods being imported. It must be answered Y or N.

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| AQIS FCL BARRIER QUESTION      Id:     7Y Type: GLQ        N     Permit:     |
|                                                                              |
| DO ALL FCL/X CONTAINERS ON THIS DECLARATION MEET AQIS NON-COMMODITY REQU     |
| IREMENTS AND ARE THEY ALL DESIGNATED TO BE UNPACKED IN A METROPOLITAN PO     |
| STCODE OR INSIDE THE BOUNDARY OF AN APPROVED AQIS PORT?                      |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+

Answering Community Protection Questions

Community Protection Question relates to the goods being imported. It is indicated by Lodgement Question Type set to CPQ. This type of question is displayed together with fields Tariff Line, Tariff Classification, Tariff Statistical Code and Goods Description as entered in Import Declaration Tariff Line. This type of question must be answered Y or N.

+------------------------------------------------------------------------------+
| Line    3     Tariff: 48192000 / 10                                          |
| CARTONS,BOXES,CASES OF PAPER,PAPERBOARD                                      |
| AQIS QUARANTINE CP QUESTION    Id:   139Y Type: CPQ        Y     Permit: N   |
|                                                                              |
| QUARANTINE: DO THE GOODS CONTAIN ANY SAND OR SOIL?                           |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+

Supplying Permit in addition to CP question

Some Community Protection Questions require permit. This requirement is indicated by Permit Application Indicator set to Y. Sometimes permit requirement depends on the type of the answer given. Read question carefully before deciding if permit should be entered.

+------------------------------------------------------------------------------+
| Line    1     Tariff: 84195090 / 35                                          |
| HEAT EXCH. UNIT,INCLUDING NON RERIG. COOLERS                                 |
| OZONE DEPLETING                Id:   325Y Type: CPQ        Y     Permit: Y   |
|                                                                              |
| ARE THE GOODS FITTED WITH, OR USE AND CONTAIN, OR HAVE INSTALLED AN AIR      |
| CONDITIONER OR REFRIGERATION SYSTEM/UNIT THAT OPERATES ON HFC, HCFC OR C     |
| FC? IF YES, ENTER LICENCE NUMBER.                                            |
|                                                                              |
|                                                                              |
| Please answer yes or no: Y   LICENCE     L1756                               |
+------------------------------------------------------------------------------+

For example, if you answer N to the question above, you do not need to enter permit number.
If you answer Y, but do not enter the permit number, following warning appears:

                 +--------------------------------------------+-+
                 | CP Id=  318 may require permit. Continue?    |
                 |            >Yes     <(No      )             ++
                 +-------------------------------------------- o
  • Select Yes to lodge declaration without the permit number.
  • Select No to enter the permit number or change the answer type.

Answering SAC questions

SAC questions are the lodgement questions with quarantine or community protection concerns, asked when lodging Self Assessed Clearance.
These questions must be answered Y or N.

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| SAC ALCOHOL AND TOBACCO PRODUC Id:    18Y Type: GLQ        Y     Permit:     |
|                                                                              |
| ARE THE GOODS ALCOHOL OR TOBACCO PRODUCTS?                                   |
|                                                                              |
|                                                                              |
| Please answer yes or no: N                                                   |
+------------------------------------------------------------------------------+

If SAC question is answered Y, it must be complemented with a referral reason description to provide further details regarding the response to the question.

       +-----------------------------------------------------------------+
       | REASON                                                          |
       | Line   18   Page 1 of 1                                         |
       |                                                                 |
       | THE GOODS ARE NOT INTENDED FOR HOME CONSUMPTION ONLY THE PROPER |
       | TY OF THE CABIN CREW THAT HAD TO BE DELIVERED SEPARATELY.       |
       |                                                                 |
       |                                                                 |
       +-----------------------------------------------------------------+

Answering SAC Low Value question

SAC low value question is the lodgement question id=3. This question is asked when the total value of goods being imported does not exceed the threshold set by Customs (currently 1000 AUD). User must answer this question Y or declaration will be rejected.

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| SAC LOW VALUE                  Id:     3N Type: GLQ              Permit:     |
|                                                                              |
| I DECLARE THAT THE VALUE OF THE GOODS DOES NOT EXCEED AUD $1000              |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+

Anwsering Goods Delivered question

Goods Delivered question is the lodgement question id=14. This question is asked when:

  • Declaration lodgement is to be amended or withdrawn and;
  • Payment receipt exists or broker confirms that the initial payment has been made
    Answer to this question is stored as Goods Delivered Indicator. It is used to determine if AQIS concern questions apply to the declaration.

If payment receipt does not exist, broker must confirm whether the initial payment has been made:

                       +--------------------------------+-+
                       | Has initial payment been made?   |
                       |      >No      <(Yes     )       ++
                       +-------------------------------- o
  • Answer Yes if initial payment has been made.
  • Answer No if initial payment has NOT been made.

If payment receipt does exist or broker confirms that the initial payment has been made, question id=14 is asked:

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| GOODS DELIVERED                Id:    14Y Type: GLQ        Y     Permit:     |
|                                                                              |
| HAVE THE GOODS BEEN DELIVERED INTO HOME CONSUMPTION (N10 OR N30) OR INTO     |
|  A S79 WAREHOUSE (N20)?                                                      |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+
  • Answer Y if the goods have been delivered. This will set goods delivered indicator as Y.
  • Answer N if the goods have NOT been delivered. This will set goods delivered indicator as N.
  • Select F10[Exit] to ignore this question. This will clear goods delivered indicator.

Answering LCT and WET question.

LCT/WET question is the lodgement question id=5. This question is asked when at least one tariff line has:

LCT/WET question is of confirmation type and must be answered Yes or the declaration will be rejected.

+------------------------------------------------------------------------------+
| Line    0     Tariff:          /                                             |
|                                                                              |
| WET QUOTE LCT QUOTE            Id:     5N Type: GLQ              Permit:     |
|                                                                              |
| I HAVE QUOTED MY ABN FOR IMPORT DECLARATION LINES WHERE I HAVE INDICATED     |
|  MY INTENTION TO DO SO FOR LUXURY CAR TAX AND/OR WINE EQUALISATION TAX P     |
| URPOSES.                                                                     |
|                                                                              |
|                                                                              |
| Please answer yes or no:                                                     |
+------------------------------------------------------------------------------+
  • Answer Y if you have quoted ABN for the tariff lines with LCT/WET tax quote indicator.
  • Answer N if you have NOT quoted ABN for the tariff lines with LCT/WET tax quote indicator. This will cause the declaration to be rejected by the Customs.

Confirming answer to lodgement questions.

After last lodgement question has been answered, you need to confirm if you wish to lodge declaration:

                            +----------------------+-+
                            |  Lodge declaration?    |
                            | >Yes     <(No      )  ++
                            +---------------------- o
  • Select Yes to lodge declaration
  • Select No to discard all answers provided and abort the lodgement process. No message will be sent to Customs and you will need to lodge declaration later on.

The process of answering lodgement questions can be aborted at any point by selecting option F10 Exit. If this option is selected following confirmation message will appear:

                         +----------------------------+-+
                         | Abort lodging declaration?   |
                         |    >Yes     <(No      )     ++
                         +---------------------------- o
  • Select Yes to quit declaration lodgement.
  • Select No to return to the last lodgement question.

Landed Cost

Calculating landed cost

In order to calculate landed cost, you need to:

  1. Enter characteristics of goods being imported using Invoice/Product screen screen. This condition is necessary, because landed cost is calculated for commercial invoice lines rather then tariff lines required by Customs.
  2. Obtain Customs status CLEAR or PROCESSING. This condition is required to extract duty and tax information from import declaration response.

If the above conditions are met you should be able to calculate landed cost and file report in few simple steps:

  1. Enter Import Declaration List, highlight shipment for which to calculate landed cost and select F8 LanCost.
  2. Confirm that you wish to create a report for the selected shipment.
                     +--------------------------------------------+-+
                     | Create LC report for shipment 1201501340?    |
                     |            >Yes     <(No      )             ++
                     +-------------------------------------------- o
    
  3. If a report already exists, select Yes if you wish to create a new report or No to continue with the old one. Selecting Yes copies most recent data available and is recommended:
                       +----------------------------------------+-+
                       | Update report for shipment 1201501350?   |
                       |     >Yes     <(No      )(Cancel  )      ++
                       +---------------------------------------- o
    
  4. Select F2 Modify to change value of header fields such as Duty Factor or Caclulation Method.
  5. Select F6 Calc to calculate landed cost.
                               +------------------------+
                               | Calculation completed  |
                               |       >Continue<       |
                               +------------------------+
    
  6. Select F9 Report to create a report.
                           +--------------------------------+
                           |         Send report to         |
                           | >FILE    <(E-MAIL  )(ABORT   ) |
                           +--------------------------------+
    
  7. Select option FILE to save report in landed cost directory. Select option E-MAIL to save report in landed cost directory and e-mail it as an attachment to a nominated address (by default this is the address of person who created the report):
         +-Enter email address------------------------------------------+
         | info@au.riege.com                                            |
         +--------------------------------------------------------------+
    

    Location of Landed Cost Report

    {The directory in which landed cost report is saved can be changed by editing parameter LRN 85/109.

    Format of E-Mail Attachment

    If report is created on a UNIX-like system, e-mail attachment file is automatically converted into DOS/Windows system.

Importing Landed Cost file into MS Excel Workbook

  1. Install RSI macro program and template
    1. Obtain MS Excel workbook with macro program, RSI_LC.xls and copy it in the directory where LC reports are to be created.
    2. Change permission to access the macro program to read only
    3. Obtain MS Excel workbook template, RSI_LCTEMP.xlt and copy it into the LC directory.
  2. Send CSV file to an e-mail account
    1. Login to Procars, open ICS Import Declaration Lodgement List, select shipment and F8[LanCost]
    2. In Landed Cost Header, select F6[Calc] to calculate landed cost.
    3. Select F9[Report], [E-MAIL] and enter e-mail address to which send landed cost report.
    4. Check e-mail account to which report was sent and save e-mail attachmnet in landed cost directory.
  3. Import CSV file into MS Excel workbook
    1. Start MS Excel and load workbook RSI_LC.xls. If you get a message about the workbook containing macros, select option Enable Macros. This will enable macros contained in RSI_LC.xls only. You can avoid this message by enabling macros permanently, but this is not recommended.
    2. From the main menu, select [Add-Ins], [Import LC Report]. The report will be created out of the template stored in selected location and saved as a separate workbook, in the landed cost directory. The workbook is named after the shipment number. For instance if shipment number is 0860607303, report is saved in workboook LC_0860607303.xls.
    3. To use more than one template, create sub-directory under landed cost directory and place template workbook there, e.g.:
      C:\Landed Cost\RSI_LC.xls (location of macro program)
      C:\Landed Cost\RSI_LCTEMP.xlt (location of default template)
      C:\Landed Cost\Customer X\RSI_LCTEMP.xlt (location of template for customer X)
      C:\Landed Cost\Customer Y\RSI_LCTEMP.xlt (location of template for customer Y)

Alternative location of the macro tool

In old version of Excel, the macro tool "Import LC Report" may be located under menu item "Data". In case of doubt, check both options.

Modifying format and style of Landed Cost Workbook

The resulting format and style of landed cost report is determined by a MS workbook template. The default template is supplied by RSI. By changing template file, user can change the appearance of landed cost report workbook. For example user can change field labels, re-size rows and columns, re-format individual cells, enter customs formulas and add own charts. It is also possible to create more than one template and produce customary workbooks for individual landed cost recipients.

There are however few restrictions which must be placed for import function to produce correct results:

  1. Data is inserted into rows, columns and cells with pre-defined names only.
  2. Names must not be re-defined.
  3. Header data is inserted in worksheet 1 named "Header", cell names listed in table Cell Names Header below.
  4. Line data is inserted in worksheet 2 named "Lines", column names listed in table Column Names Line.
  5. Each line is inserted in the rows named in table Row Names Line.
  6. If a name is removed no corresponding data is copied.
  7. Although it is possible to add and rename worksheets, worksheets 1 and 2 must retain their original names.
  8. For information on how to apply name to a cell or row, refer to MS Excel help.


Cell Names for Header Record

#Pos

Name

Description

#1

hShipment

Shipment number

#2

-

Filler (always single space)

#3

-

Header tag (letter H)

#4

-

Filler

#5

hUserId

Procars user id

#6

hCalcStatus

Calculation status

#7

hAttention

Name of the person to deal with the report

#8

hPreparedBy

Name of the person who prepared the report

#9

hXrateCustoms

Exchange rate (Customs)

#10

hXrateUsed

Exchange rate (actually used)

#11

hReference

Job reference no (as #1)

#12

hVesselName

Vessel name

#13

hDestName

Destination name

#14

hCurrency

Foreign currency

#15

hPrice

Total price in foreign currency

#16

hPriceAUD

Total price in AUD

#17

hCustomsValue

Customs value

#18

hDuty

Duty charged

#19

hGST

Total GST

#20

hDutyFactor

Duty factor

#21

hWeight

Weight

#22

hOwnerName

Goods owner or LC client

#23

hOwnerId

Goods owner id

#24

hInvoiceNo

Invoice no

#25

hSupplierName

Goods supplier (default)

#26

hAgencyFee

Agency fee in AUD

#27

hFeeType1

Other fee type 1

#28

hFeeAmount1

Other fee amount 1

#29

hFeeType2

Other fee type 2

#30

hFeeAmount2

Other fee amount 2

#31

hFeeType3

Other fee type 3

#32

hFeeAmount3

Other fee amount 3

#33

hFeeType4

Other fee type 4

#34

hFeeAmount4

Other fee amount 4

#35

hFeeType5

Other fee type 5

#36

hFeeAmount5

Other fee amount 5

#37

hFeeType6

Other fee type 6

#38

hFeeAmount6

Other fee amount 6

#39

hFeeType7

Other fee type 7

#40

hFeeAmount7

Other fee amount 7

#41

hFreight

Total freight in AUD

#42

hLanded

Total landed in AUD

#43

hCalcMethod

Caclulation method: VAL, CBM or WGT

#44

hVolume

Total volume in CBM

#45

hDiscount

Discount percentage

#46

hTAI

Transport and insurance

#47

hGSTFlag

GST flag (inclusive or exclusive)


Row Names for Line Record

##Pos

Name

Description

-

rInvoiceLine

Row to insert next invoice line


Column Names for Line Record

##Pos

Name

Description

##1

lShipment

Shipment number

##2

-

Filler

##3

-

Line tag (letter L)

##4

lNumber

Invoice line no

##5

lQuantity

Quantity

##6

lProductId

Commodity/Product id

##7

lUnitPrice

Unit price in foreign currency

##8

lPrice

Line price in foreign currency

##9

lPriceAUD

Line price in AUD

##10

lDiscount

Discount in AUD

##11

lCustomsValue

Value for duty in foreign currency

##12

lDuty

Duty amount in foreign currency

##13

lFreight

Freight amount in AUD

##14

lGST

GST amount in AUD

##15

lAdjustment

Adjustment in AUD

##16

lDiscountFlag

Discount/other flag

##17

lDutyPercent

Duty percentage

##18

lTaxPercent

Tax percentage

##19

lTMC

Tariff master code

##20

lVolume

Volume in cbm

##21

lWeight

Weight

##22

lLanded

Landed amount in AUD

##23

lCost

Cost amount in AUD

##24

lUnitCostAUD

Unit cost in AUD

##25

lUnitCost

Unit cost in foreign currency

##26

lTAI

Transport and insurance fee

Column Names for Line Record (available in Landed Cost version 1.15 or later)

##Pos

Name

Description

##27

lSupplierId

Supplier Id

##28

lSupplierName

Supplier Name

Importer Profile

Adding new importer

Searching for an existing importer

Supplier Profile

Adding new supplier

Searching for an existing supplier

Tariff Master Codes

What is Tariff Master Code?

Tariff Master Code or TMC (also referred to as TLF) is a code allowing grouping related tariff classifications and statistical codes, applicable to the goods being entered. TMC consists of 4-digit number and a check letter, e.g. 0571N. There can be maximum of 9999 codes, from 0001K to 9999N.

The main purpose of TMC is to:

  • Simplify user input. It is easier to memorise and type in 5 character string than 10 character tariff classification and statistical code. The check letter assures the integrity of TMC and reduces chance of typing error.
  • Define number of tariff properties such as description of the goods associated with the tariff or instrument number to obtain a concessional rate of duty. When a TMC is used its properties are copied into import declaration tariff line, saving user time to input data and minimising chance of error.
  • Create customised tariff system, largely independent from the tariff system required by ACS.
  • Allow linking product (commodity) being imported to tariff classification in simple and comprehensive way.
  • Reflect tariff characteristics against products in form of customary reports.

There is however significant effort required to create a large TMC system from scratch and then some small overhead in order to keep it up to date, in particular:

In general, TMC are a long term investment reducing time in lodging large volume of import declarations. But on a small system, benefits of TMC may not outweight the cost to maintain it.

Creating Tariff Master Code

Creating TMC is a simple procedure:

  1. From Import Declaration Menu, select item N405 to start Tariff Master Code Maintenance program:
        +---------------------------------------------------------+
        |  +---------------------------------------------------------+
        +--|  +---------------------------------------------------------+
        |  +--|  N400 PROCUST    * ICS Import Declaration               |
        |  |  +---------------------------------------------------------+
        |  |  |  1|N401|PROCUST    * ICS Declaration Lodgement          |
        |  |  |  2|N402|PROCUST    * ICS Self Assessed Clearance        |
        |  |  |  3|N403|PROCUST    * ICS Supplier Profile               |
        |  |  |  4|N404|PROCUST    * ICS Importer Profile               |
        |  +--|> 5|N405|PROCUST    * ICS Tariff Master Codes            |
        |  8|M|  6|N406|PROCUST    * ICS Product Description            |
        |  9|N|  7|N407|PROCUST    * ICS Currency Exchange              |
        | 10|Y+--------------------------RSISYD/4a rspar-no:02 user:RSI-+
        +--------------------------RSISYD/4a rspar-no:02 user:RSI-+
    
  2. In Tariff Master Code Maintenance screen, enter Tariff Master Code you wish to create (including the check letter) and select Yes to confirm.
                               +------------------------+-+
                               | TMC not found. Create?   |
                               |  >No      <(Yes     )   ++
                               +------------------------ o
    
  3. Alternatively select function F5 New to allocate next available TMC. The second method is recommended to assure continuity of TMC.
  4. Enter Tariff Classification Number and Statistical Code. Both numbers must exist in latest copy of reference file (Statistical Classification Period Snapshot).
  5. Enter TMC properites. All properties (with the exception of Duty Rate) are used when referring to this TMC in import declaration lodgement.
  6. Repeat above steps to create another TMC or select F10 Exit to quit Tariff Master Code program and return to Import Declaration menu.

Searching existing Tariff Master Code

To search one or more existing TMC:

  1. Enter Tariff Master Code Maintenance screen, edit field Tariff Master Code and select F2 Search
  2. In TMC Query screen enter search criteria: TMC Description (matching any part of it) and/or Tariff Classification (matching most left digits).
  3. Select F9 Take or Enter to choose highlighted TMC or F2 Search to search again.

Modifying existing Tariff Master Code

  1. Enter Tariff Master Code Maintenance screen and enter Tariff Master Code or select F2 Search to search for one.
  2. Edit remaining fields and select F10 Exit to save changes.

Deleting Tariff Master Code

Current implementation of TMC does not allow to delete existing TMC.

Product Description

Overview

Product description is a file storing products (commodities) being imported. Products are categorised as for general imports or particular importer (owner) and coming from particular supplier. Product file contains TMC to specify tariff classification used as well as number of other properties, such as Country of Goods Origin.

Product description file is most useful on a system where large volume of import declarations are based on a commercial invoice, with products listed by their number or name. The file simplifies input of tariff lines, but this advantage must be weighted against the overhead incurred by the file maintenance.

Adding commodity to the commodity file.

To add a commodity, follow the procedure below:

  1. From Import Declaration Menu, select item N406 to start Product Description Maintenance program:
        +---------------------------------------------------------+
        |  +---------------------------------------------------------+
        +--|  +---------------------------------------------------------+
        |  +--|  N400 PROCUST    * ICS Import Declaration               |
        |  |  +---------------------------------------------------------+
        |  |  |  1|N401|PROCUST    * ICS Declaration Lodgement          |
        |  |  |  2|N402|PROCUST    * ICS Self Assessed Clearance        |
        |  |  |  3|N403|PROCUST    * ICS Supplier Profile               |
        |  |  |  4|N404|PROCUST    * ICS Importer Profile               |
        |  +--|  5|N405|PROCUST    * ICS Tariff Master Codes            |
        |  8|M|> 6|N406|PROCUST    * ICS Product Description            |
        |  9|N|  7|N407|PROCUST    * ICS Currency Exchange              |
        | 10|Y+--------------------------RSISYD/4a rspar-no:02 user:RSI-+
        +--------------------------RSISYD/4a rspar-no:02 user:RSI-+
    
  2. In Product Description Maintenance screen, enter commodity Owner Address Number. If the commodity is to be shared by all importers, leave the number blank.
  3. Enter Supplier Address Number. If the commodity is to be shared by all suppliers, leave the number blank.
  4. Enter Commodity Identifier and select Yes to confirm that you wish to create the new commodity:
                          +----------------------------------+-+
                          | Commodity doesn't exist. Create?   |
                          |       >Yes     <(No      )        ++
                          +---------------------------------- o
    
  5. Enter Tariff Master Code (TMC) that describes the new commodity.
  6. Check that the TMC selected is linked to correct Tariff Classification and Statistical Code. If not, you need to select another TMC.
  7. Check Commodity Description and Quantity Unit. These fields default to the values pulled from the record of the selected TMC, but can be overwritten if necessary.
  8. Optionally, enter or modify the remaining fields.
  9. Select F10 Exit to save the new commodity and return to the Import Declaration Menu or repeat the above steps to add another commodity.

Searching existing commodity

To search one or more existing commodities:

  1. Enter Product Description Maintenance screen, edit field Commodity and select F2 Search.
  2. In Product Description Query screen enter one or more of the following search criteria:
  3. Select F9 Take or Enter to bring over highlighted commodity or F2 Search to search again.

Modifying properies of existing commodity

  1. Enter Product Description Maintenance screen and input Commodity Owner, Commodity Supplier and Commodity Id or search for commodity.
  2. Edit remaining fields and select F10 Exit to save changes.

Selecting quantity unit.

When selecting Quantity Unit, following rules apply:

  • If a commodity is created or existing commodity is linked to a new Tariff Master Code, quantity unit is pulled from Tariff Master Code file.
  • Quantity unit must exist in Customs reference file. If it is not in the file, user is prompted to re-enter it:
                          +----------------------------------+
                          | Code "XX" not in file. Re-enter  |
                          |            >Continue<            |
                          +----------------------------------+
    
  • To see list of units available, use function F2 Search:
    ICFCLOOK  (RSISYD) ICS Reference Code Query
    +------------------------------------------------------------------------------+
    | Name/Description                                                  Code       |
    > BILLET                                                            B5         |
    | BARREL                                                            BA         |
    | BASIC CARTON                                                      BC         |
    | BAG                                                               BG         |
    | BALE                                                              BL         |
    | BULK                                                              BN         |
    | BOTTLE                                                            BO         |
    | BULK TANK                                                         BT         |
    | BOX                                                               BX         |
    | CUBIC DECIMETRE                                                   C8         |
    | CAN                                                               CA         |
    | CUBIC CENTIMETRE                                                  CC         |
    | CUBIC FOOT                                                        CF         |
    |------------------------------------------------------------------------------|
    | B5                       Valid From: 01.01.1901      Valid Until: OPEN       |
    | WAREHOUSE                                                                    |
    |                                                                              |
    +------------------------------------------------------------------------------+
    1Help 2Search 3Refine 4       5       6       7       8       9Take   10Exit
    
  • To narrow down search criteria, select F2 Search again. To see related units, use field "Code Description". For example, to see list of units used to measure length, enter LENGTH into "Code Description" and leave other fields empty:
    ICFCLOOK  (RSISYD) ICS Reference Code Query
    +------------------------------------------------------------------------------+
    |        Type: QUANTITY UNIT                                                   |
    | Description: LENGTH                                                          |
    |        Name:                                                                 |
    |        Code:                                                                 |
    |                                                                              |
    +------------------------------------------------------------------------------+
     code description line 1                                                     @4
    1Help 2       3       4       5       6       7       8       9       10Exit
    
  • Select F9 Take or Enter to use highlighted unit or F10 Exit to abort selection:
    ICFCLOOK  (RSISYD) ICS Reference Code Query
    +------------------------------------------------------------------------------+
    | Name/Description                                                  Code       |
    > CENTIMETRE                                                        CM         |
    | DECAMETRE                                                         DK         |
    | DECIMETRE                                                         DM         |
    | FOOT                                                              FT         |
    | HECTOMETRE                                                        HM         |
    | INCH                                                              IN         |
    | KILOMETRE                                                         KM         |
    | METRE                                                             M          |
    | MILLIMETRE                                                        MM         |
    | YARD                                                              YD         |
    |                                                                              |
    |------------------------------------------------------------------------------|
    | CM                       Valid From: 01.01.1901      Valid Until: OPEN       |
    | LENGTH                                                                       |
    |                                                                              |
    +------------------------------------------------------------------------------+
    1Help 2Search 3Refine 4       5       6       7       8       9Take   10Exit
    
  • If quantity unit is not supported by the tariff classification, user is asked to accept it:
     
              +----------------------------------------------------------+-+
              | Unit "KG" not supported by tariff "21069090/43". Accept?   |
              |                   >Yes     <(No      )                    ++
              +---------------------------------------------------------- o
    
  • Note that if user does not enter quantity unit, it is indicated by the pair of empty double quotes:
               +--------------------------------------------------------+-+
               | Unit "" not supported by tariff "03031100/43". Accept?   |
               |                  >Yes     <(No      )                   ++
               +-------------------------------------------------------- o
    
  • If user answers "Yes", the unit is accepted. However, the same question is asked next time unit is updated.
  • If user answers "No", another question is asked whether to use the unit indicated by the tariff:
                         +------------------------------------+-+
                         | Use unit "KG" supported by tariff?   |
                         |        >Yes     <(No      )         ++
                         +------------------------------------ o
    
  • If user answers "Yes", the unit supported by the tariff is selected, e.g. "KG" in this example.
  • If user answers "No", they must select another unit.
  • Some tariffs do not require quantity unit and quantity must not be input on the declaration line quoting such tariffs. The fact that the tariff does not require unit is indicated again by the pair of empty double quotes:
                          +----------------------------------+-+
                          | Use unit "" supported by tariff?   |
                          |       >Yes     <(No      )        ++
                          +---------------------------------- o
    

Deleting existing commodity

  1. Select commodity using method search.
  2. Go to the field "Owner" (first field in the screen).
  3. Select option F6 Delete.
  4. Answer Yes to confirm that you wish to delete selected commodity.
                              +--------------------------+-+
                              | Delete TEST COMMODITY 1?   |
                              |   >No      <(Yes     )    ++
                              +-------------------------- o
    

Generating Commodity Report

See page Generating Commodity Report

Currency Exchange