Customs Duties - How do we add them as additional costs with different rates for different items.

Hi all.

With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each item separately.

This means we cannot use prorate by weight, cost, etc. We could prorate manually but we often have over 400 lines on our receipts/PO's so this would be a hassle.

We currently prorate by costs, but this means items that should have lots of duty get less than they should added to them, and items with little or no duties end up with too much.

How do other importers handle this issue in Sage 300?

Thanks in advance

David

Parents
  • I worked in the shipping industry and I'm familiar with customs duty and import costs. Your clearing agents provide a costing worksheet that breaks down the costs per item, and its these costs you want to allocate to each imported item. The only way to truly allocate these to the Sage 300 items is by doing manual proration, but as you say this is a tedious process with a large number of items.
    I'm not aware of a program that will automate this for you, but that does not mean that one is not available.

    With that said, if you do receive an electronic copy of the costing worksheet from your clearing agents then an import process can be written to allocate the costs to the items based on manual proration.

  • in reply to Ettienne Schwagele Acumen

    We are looking into this again, and have another problem.  The pro-ration needs to be done when the items are received, as many times they are shipped out the same day.  We don't have the shipping costs/charges on that day.  I'm finding there is no pretty solution to any of this.

  • in reply to Joepcs

    We use a Tax Group made up of two Tax Authorities to calculate duty by inventory item on the PO receivers. One Authority is the duty itself and the other is an offset that gets expensed - they net to $0 but the duty gets added to the inventory items. There is the limitation of 10 Tax Classes so you only get to apply 10 rates (9 if you count nontaxable/$0 rate) but has worked for our client's needs. There's a little more to the setup but that's the general idea.

Reply
  • in reply to Joepcs

    We use a Tax Group made up of two Tax Authorities to calculate duty by inventory item on the PO receivers. One Authority is the duty itself and the other is an offset that gets expensed - they net to $0 but the duty gets added to the inventory items. There is the limitation of 10 Tax Classes so you only get to apply 10 rates (9 if you count nontaxable/$0 rate) but has worked for our client's needs. There's a little more to the setup but that's the general idea.

Children
No Data