CAPITAL Office Business Software

Have a mental Block On Excise rate/formula.

Problem:

Thinners attracts Excise of 38 Cents a Litre. then GST is Added when Purchased in a 200 Litre Drum (you can by 200 Litres in 20 Litre Drums and No Excise)

When it is sold usually in a 20 Litre Drum NO Excise only GST
How do we set up to do this and be able to claim back the EXcise.

Assuming these items have different product codes, assign excise to one tax rate that also calculates GST, and create a second tax rate for GST, and do not assign any excise to that tax rate. Then assign the tax rate with the linked excise to the stock item that represents the 200 litre drum. Assign the tax rate without excise to the stock item representing the 20 litre drum.

If you are using the same product item code, but specifying a different unit of sale only when invoicing, then as there is no system in CAPITAL 7.4 to automatically change the tax rate based on the unit quantity sold, the operator will have to manually enter the correct tax rate against the item. If this isn't acceptable, a script would have to be written to check, validate and select the desired tax rate based on the unit of measure of the sale.