DCs and NDCs on W/S

The following is the way the worksheet works:

INVOICE VALUE SHOWN - The total at the bottom of the invoice.

DC'S INCLUDED - Dutiable charges that are included in the INVOICE VALUE as separate line items on the invoice. They are not included in the individual lines of the invoice. (eg PACKING shown as a total amount.) The individual lines entered on the worksheet should add up to the INVOICE VALUE SHOWN less this amount. This amount is then prorated across all items on the invoice at CALC to determine the entered value on each line.

DC'S NOT INCLUDED - These are charges not included in the INVOICE VALUE SHOWN. (eg PACKING shown as a total value below the invoice total.) The individual lines entered on the worksheet should add up to the INVOICE VALUE SHOWN. These amounts however are prorated across all items on the invoice at CALC to determine the entered value on each line.

NDC'S (to be) PRORATED - These are amounts that are included in the the INVOICE VALUE SHOWN that are not dutiable. (eg Freight given as a total included in the INVOICE VALUE but not listed separately.) The individual lines entered on the worksheet should add up to the INVOICE VALUE SHOWN. These amounts however are prorated out of all items on the invoice at CALC to determine the entered value on each line.

NDC'S NOT (to be) PRORATED - There are amounts that are included in the INVOICE VALUE SHOWN as a separate line item. (eg Freight included as a separate line item and included in the invoice total.) The individual lines entered on the worksheet should add up to the INVOICE VALUE SHOWN less this amount.

Example 1 DCS INCLUDED

ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
PACKING		  500.00	DCS INCLUDED
		--------
		10500.00	INVOICE VALUE SHOWN

Example 2 DCS NOT INCLUDED
ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
		--------
		10000.00	INVOICE VALUE SHOWN
PACKING		  500.00	DCS NOT INCLUDED

Example 3 NDCS PRORATED
ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
		--------	
		10000.00	INVOICE VALUE SHOWN
This amount includes Freight
Charges of $500.00		NDCS PRORATED

Example 4 NDCS NOT PRORATED
ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
FREIGHT		  500.00	NDCS NOT PRORATED
		--------
		10500.00	INVOICE VALUE SHOWN


Discount Before Proration
ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
Less Discount	 1000.00	(10 %) Discount Before 
Packing		  500.00	DCS INCLUDED
		--------
		 9500.00	INVOICE VALUE SHOWN


Discount After Proration
ITEM 1		10000.00	LINE 1 (BOTTOM OF W/S)
Packing		  500.00	DCS INCLUDED
Less Discount	 1050.00	(10 %) Discount After
		--------	
		 9450.00	INVOICE VALUE SHOWN