Applying Landing Costs (Freight, Customs, duty etc) to Inventory costs
Patrick_10195009
Member Posts: 10 ✭
I am new to using inventory on Reckon Hosted and would like to know how to have the costs/expenses for shipping my products from overseas to here, applied to the cost of my product.
We import in UKP from Supplier A and the landing costs are charged in AUD from Supplier B. I see there is an "Expenses Tab" but that doesn't seem to be applied to the cost of the product when i receipt the inventory.
Any help would be appreciated. Thanks in advance
We import in UKP from Supplier A and the landing costs are charged in AUD from Supplier B. I see there is an "Expenses Tab" but that doesn't seem to be applied to the cost of the product when i receipt the inventory.
Any help would be appreciated. Thanks in advance
0
Comments
-
Hi Patrick
Although this can’t be done specifically per Product/Item, if you make all the Landing Cost accounts “Cost of Goods Sold”-type accounts (instead of “Expense”), this will reflect on your P&L.
eg
Income (incl Products)
LESS
COGS (incl Landing Costs)
= Gross Profit
LESS
Expenses
= Net Income
Shaz Hughes Dip(Fin) ACQ NSW, MICB
Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)
Accounted 4 Bookkeeping Services
Ballajura, WA
0422 886 003
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
At the moment we only have a limited number of overseas suppliers that I would like to add "landing costs" to the value of the product, I have figured out a work around.
I have created a new supplier "Supplier A Stock Receipts" that is set up in the local currency that I will create a Purchase order for the products at the calculated "landed cost" per item (calculated separately). The total of the receipt will be the total value of all costs involved with getting the stock to our warehouse (Supplier A (product Costs) + Suppler B (Duty, freight etc)) and will therefore have the value of the stock at the correct full cost.
I then process the Supplier Invoice for Both Supplier A and B to what I have called Creditors Clearing. This then allow me to make the required correct payments for these Suppliers.
I then process a payment on Supplier A Stock Receipts to that same clearing account that will then match the totals that are the invoices for Supplier A+B.
If we end up with a lot more suppliers that need to be managed this way it could become messy, but for now it is only 1 so it should be OK.
0 -
Hello Patrck
Kevin is correct .You need to work out this separately then add this to your cost and add the margin to get your SP.
However, if you wish to automate this and have a tool utility we could look into this.
Chandra
0407068942
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community