# Landed Cost - Multiple Vendors

**URL:** <https://forum.manager.io/t/landed-cost-multiple-vendors/10646>\
**Category:** Uncategorized\
**Created:** [July 17, 2017, 4:22am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646 "2017-07-17T04:22:40Z")\
**Posts on this page:** 11\
**Page:** 2

<div class="post-metadata">

**Author:** ![siyab](https://avatars.discourse-cdn.com/v4/letter/s/b4bc9f/32.png) [@siyab](https://forum.manager.io/u/siyab)\
**Post date:** [July 20, 2017, 3:40am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/21 "2017-07-20T03:40:55Z")

</div>

> [@dcVest](#):
>
> And here is a purchase invoice as I suggested siyab make it. Notice there is no base currency so no “AED” all over the place, no exchange rates need to be entered into Manager, the Suppliers are not set to a currency, and the amounts on the purchase invoice are the same as would appear on the bank statement. This purchase invoice produces the same Inventory Item cost as the above, but is easier to do and understand. I think this is a preferable way.

Though it is a good alternative way (I did not use the word “workaround”) of doing the entry. But don’t you think its rather easier to convert 1 or 2 local expenses to USD rather than converting 25+ items value to AED? The example you gave is of a Purchase Invoice with just 1 item.

---

<div class="post-metadata">

**Author:** ![dcVest](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@dcVest](https://forum.manager.io/u/dcVest)\
**Post date:** [July 20, 2017, 4:39am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/22 "2017-07-20T04:39:07Z")

</div>

Good point!

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 20, 2017, 6:11am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/23 "2017-07-20T06:11:35Z")

</div>

> [@dcVest](#):
>
> It would be interesting to debate and clarify some points that you made, but those are more about accounting than using Manager

More then happy to have that debate via private message.

> [@dcVest](#):
>
> The topic has been badly diverted

Generally the topic has remained on subject, the processes and options available within Manager to handle particular importing situations with their pros & cons.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [July 23, 2017, 7:24am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/24 "2017-07-23T07:24:44Z")

</div>

I have read some of the comments and I agree with @Tut’s original method. This is because it very simple and a user doesn’t need to know so much accounting to use it.

No one said financial reporting is easy. If there are separate source documents for the purchases and delivery services accumulating to the total purchase cost of inventories, I would prefer entering each separately in invoices for (payables) and in spend money for services already paid (eg. Bank charges) and direct all those to the cost of the inventory. This keeps my accounts very neat and no need to create extra account in COA as suggested by @Brucanna.

I repeat no one said financial accounting is going to be easy. Often short cuts in book keeping end up being long cuts when you have to explain things to auditors or new people in the team.

Keep things simple as the software encourages.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 23, 2017, 12:42pm UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/25 "2017-07-23T12:42:03Z")

</div>

> [@Abeiku](#):
>
> If there are separate source documents for the purchases and delivery services accumulating to the total purchase cost of inventories,

And if these sources documents are in a multiple of currencies how do you convert them so that they become included (converted) into the total purchase cost of inventories.

Purchase Invoice 1 : Supplier in Euros with entry of 25 Inventory Items  
Purchase Invoice 2 : Shipping in USD with entry of 1 item  
Purchase Invoice 3 : Freight Forwarder in Base Currency covering customs duties, clearance fees and local courier, with entry of 3 items.

With the clearing account, you post both Purchase Invoice 2 & 3 to the clearing account, get a single total in the base currency, convert it to Euros and add it the suppliers purchase invoice as Freight-in where Manager will automatically re-distribute it over the 25 items and with an equalising contra entry to the clearing account.

Without the clearing account you would have to take Purchase Invoice 2, and convert it from a being a single entry item into 25 entry items but only after first manually entering those 25 items into spreadsheet where a mathematical formula is applied so that the original single entry value can be pro rata re-distributed over the 25 items

Then you need to repeat this entire process again for Purchase Invoice 3 plus again if there is others.

Any Importer will tell you that processing 3 purchase invoices as originals in their respective currencies plus doing one conversion and one purchase invoice edit can’t get it any simpler.

Compared to firstly duplicating the 25 items into a spreadsheet, applying formulas and then entering that duplication back for each imported related purchase invoice.

Or “Keep things simple as the software encourages” by only doing 31 accounting entries compared to doing 25 spreadsheet entries plus 75 accounting entries. Less entries ='s less opportunities for errors.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [July 23, 2017, 1:59pm UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/26 "2017-07-23T13:59:43Z")

</div>

@Brucanna I would still avoid your method. Because I want my purchase invoices to show details and totals exactly as the purchase invoices received from vendors.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 23, 2017, 9:14pm UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/27 "2017-07-23T21:14:06Z")

</div>

> [@Abeiku](#):
>
> I want my purchase invoices to show details and totals exactly as the purchase invoices received from vendors.

You are misunderstanding, that is exactly what (my) method does - it keeps the “purchase invoices as originals in their respective currencies”

The alternative which you were supporting requires you to convert the original, say the shipping purchase invoice with a single entry into a multi entry to suit the suppliers purchase invoice.

Quotes from the alternative  
“There is another way to accomplish the same goal with the manual approach”  
----- why do a manual approach when Manager does it automatically - how is that simpler.

“Then enter a purchase invoice for the shipping supplier with a line item for each inventory item”  
----- entering for each inventory item instead of the actual shipping item is not keeping it original

“But there is no doubt your method is a slick **approach that could simplify things** when freight-in (assuming that includes brokerage, handling, customs clearing, and a wide range of other charges) is complex”

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [July 24, 2017, 10:01am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/28 "2017-07-24T10:01:22Z")

</div>

@Brucanna Maybe i have to look into it all again

---

<div class="post-metadata">

**Author:** ![DSM\_Enterprise](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/dsm_enterprise/32/27906_2.png) [@DSM\_Enterprise](https://forum.manager.io/u/DSM_Enterprise)\
**Post date:** [February 10, 2018, 9:32am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/29 "2018-02-10T09:32:17Z")

</div>

Guys your long text could be easier to read in screenshots or picture. Is the issue solved yet? Is the freight-in contra account valid?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [February 10, 2018, 10:50am UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/30 "2018-02-10T10:50:10Z")

</div>

> [@DSM\_Enterprise](#):
>
> Is the freight-in contra account valid?

Yes

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:21pm UTC](https://forum.manager.io/t/landed-cost-multiple-vendors/10646/31 "2023-01-18T15:21:47Z")

</div>

Closed on January 18, 2023, 3:21pm UTC



[Previous page](https://forum.manager.io/t/landed-cost-multiple-vendors/10646.md?page=1)
