Freight-in on separate invoice

Continuing the discussion from Allocating freight-in to the cost of inventory items when purchasing:

Hi @lubos, I can’t see the new guide anywhere - do you have any tips on dealing with this issue please? I import goods to Australia and pay customs and agent fees well after I have paid my supplier.

Thanks

Read the below topic - then ask about any specific steps you need details on

1 Like

Thanks @Brucanna

So am I correct in assuming I should be entering the “duty, gst, handling charges” as an item on my original suppliers purchase invoice - with a reversal to keep the number the same? ie $1200 as freight-in, and -$1200 to a “freight clearance liability account”. Then my purchase invoices for “duty, gst, handling charges” all post to the “freight liability account”?

Thanks

1 Like

Yes except for the GST, as that charge is not a Freight In and doesn’t make any adjustment to the inventory values, so the GST take up can just remain as part of the “customs invoice”.

Just be mindful that if your Freight-in’s are in your Base Currency 1200 and the Suppliers Purchase Invoice is in another currency, then convert the 1200 using the same exchange rate as the Purchase Invoice and there maybe some rounding differential to write off.

1 Like

OK, thank you - I’ve got it working now.

Hi @lubos
I think eventually, Manager will have to be able to allow payments to be made from different accounts on the same Purchase Invoice, or allow users to resource multiple invoices to create a report. ( Like a " Combine Multiple Invoices " option )

For example, one can have a single shipment coming in from the Supplier, with different Inventory Items in that shipment. And, this shipment will be handled by a Freight Agent who is completely separate from the Supplier, yet, we all want to include the cost of freight on the items and have it shared across all the items to allow us to easily calculate the profit margin after sales, while still being able to have separate Purchase Invoices for each Supplier within the main Purchase Invoice, sort of like mini Purchase Invoices, for each supplier.
I suggest the following solutions.

  1. Why not have a sort of " Shipping Draft" section that will allow users to merge all the resources that went into delivering a shipment. This " Shipping Draft " section can be linked directly to the Inventory Profit Margin Report section allow users to generate reports. Meanwhile, the Purchase Invoice section stays intact.

  2. On the Inventory Profit Margin Report section, you can allow users to combine information form a set of Purchase Invoices to generate a report. This way, users can add a Suppliers’ Invoice + a Shipping/Freight Invoice = Cost of Goods, and so on.

  3. Next to the Inventory Items on the Purchase Invoice while in " Edit " mode, could be a menu that allows the user to select the Supplier of the individual item, this will allow Manager to be able to generate multiple invoices from one purchase invoice.

One of the foreseeable downfalls of all of these options is that they will rely heavily on the accuracy of the Exchange Rate module thats built into Manager in the event that for example the Supplier and the Freight Service operate on different currencies.