Shipping Costs in Purchase Orders

chopwoodchopwood Member Posts: 2
edited April 2021 in Feedback

What is the purpose of the Shipping Cost field if it can not be reported upon? This has been an issue ever since we have been on Lightspeed. We really need to have a way to run a report on inbound freight / shipping .. OR have the shipping cost be added to the COG's. What is the purpose of the field if it can't be used for accounting purposes? Can this please be a priority feature as it would help all.


Post edited by VD_LS on
<1

39 comments

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 796 moderator

    Hey @chopwood ,


    Thank you for the feedback! Currently, the Shipping and Other(+/-) costs cannot be found in reports in retail. They only appear on the PO Ordered Totals under Costs or in the PO total at the top of the Purchase Order.


    I'll note it in the enhancement requests list made by customers!

    ———

    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • chopwoodchopwood Member Posts: 2

    Yes and it doesn't really make sense to have the field that doesn't get added to the COG's - freight is a factor in COGS and/or an other expense in accounting. Even thought it shows as a 'total' this does not currently get factored into the over all COG's / Profit Margin in lightspeed and it should. Sometimes freight significant in the cost and can change the margins enough to matter. I've made this request a number of times and hopefully we can get this to work out. Right now we have to track it separately to be updated on the accounting side.

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 796 moderator

    Hey @chopwood,


    Thank you so much for going into details!

    ———

    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • JmichaelJmichael Member Posts: 2

    I completely agree with this!

  • LeisureTimeLeisureTime Member Posts: 1

    I agree, Freight plays a major amount in regards to margin. There's a place to put Freight and Discounts, it needs to calculate in to the cost of goods. Or at least give the option for it to calculate.

  • lev_cyclistlev_cyclist Member Posts: 30

    Ever since we started using Lightspeed our purchaser and CFO have been really annoyed by this as well. As others have said on the accounting side shipping costs are part of the Cost of Goods and such should be distributed amongst the cost of the items in the PO.


    Right now we are having to pay someone to manually calculate that and modify each item's cost one at a time, an real abusrdity considering we are in 2021 working with a otherwise powerful tool!

  • Fuzzy_MelonFuzzy_Melon Member Posts: 15

    Oh my LORD I am close to killing myself trying to figure this out. My customer has inventory skewed and I was hoping to get to the P.O. freight-in and discount info in lightspeed so as to manually calculate a per recevied unit, and then apply to goods sold in that time frame. Lightspeed does not offer access to that information in any report or data dump.

    Let's also talk about how I would route that in Lightspeed: If I include discounts and freight-in into the "Asset Inventory" account, it will never be accurate because Lightspeed only sends the "ave cost" (no freight-in or discounts included) for CoGS sales transactions. If I separate freight-in and discounts into exclusive Quickbooks accounts, how do I balance them out with sales transactions?

    Please advise and take me from this ledge, and thank you in advance!

  • amatthamatth Member Posts: 11

    This software was not ready for release. These bugs are not bugs but incomplete software.

  • kellyfkellyf Member Posts: 12

    Agree! This is a big deal in terms of analyzing profit and correctly capturing the activity in our acctg software. We spend a lot of time doing manual calculations that should otherwise be extremely easy to generate via LS reporting.

    At a minimum, it would be incredibly helpful to AT LEAST update the data exports to include Shipping, Other and Discount that are captured in the PO.

  • Fuzzy_MelonFuzzy_Melon Member Posts: 15
    edited July 2021

    If freight, discounts and misc are routed to QuickBooks during P.O. receiving, and is then ignored for sales transactions CoGs, what is the lightspeed methodology for factoring in those costs into CoGS and accurately adjusting inventory valuation? Surely LightSpeed had a plan when the software was developed, so what is the LightSpeed playbook for adjusting inventory valuation with those costs? And no, having someone calculate and manually adjust each P.O. item cost with proportional shipping/discounts after receipt is not an option.


    Thank you.

  • brian_tdcmabrian_tdcma Member Posts: 16

    We also desperately hope Lightspeed to have this shipping cost matter fixed too. We often import products from oversea, and we really need to distribute shipping cost to these products.

  • Fuzzy_MelonFuzzy_Melon Member Posts: 15

    Hi,

    Checking in on this situation,

    Anyone care to share how they are applying shipping and discounts to CoGS and unit valuation?


    Thanks!

  • Fuzzy_MelonFuzzy_Melon Member Posts: 15

    Is this in LightSpeed backlog yet, or at least documented as a user story? Please advise, thank you.

  • CCFS_ZachCCFS_Zach Member Posts: 33 ✭

    I agree with this. 👍

  • DirtRoosterBicyclesDirtRoosterBicycles Member Posts: 1

    Okay, for real? why is the option there to put in what shipping was on a purchase order if it goes to nowheresville. This absolutely needs attention, yesterday, last year, come on Lightspeed.

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 796 moderator

    hey @Fuzzy_Melon

    Any enhancement, if they are being worked on, are often not mentioned to anyone that is customer-facing until it is either in closed/open Beta, or in General Availability. For this reason, we don't often get updates until then. @Fuzzy_Melon

    ———

    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • evergreenevergreen Member Posts: 4

    I'd like to echo the concern over including shipping and other (+/-) costs in the COG and margin reports. This is basic info any business needs. We are just starting our relationship with LS, but it could be a short one if we discover other software shortcomings like this.

  • TFloraTFlora Member Posts: 2

    We are new to Lightspeed and I am frustrated that the shipping and discount fields are not reportable nor adjust the cog. This is not something that should be a nice update, it is a necessity for proper reporting. I did not realize there was not a report showing these accumulations. A business cannot properly upkeep their books if these fields are of no use. Am I to understand that we need to manually calculate the cost of goods with shipping and discounts for our records to be accurate?

  • Fuzzy_MelonFuzzy_Melon Member Posts: 15

    Hi @VanessaD,


    Not a good best practices. Lightspeed may want to re-think their stakeholder engagement strategies and become a little more transparent on what's upcoming in releases. Many businesses consider pre-marketing an opportunity they can exploit.

    That said....Lightspeed can't even add the attributes to the P.O. data dump? I would think that they are in the same table...how hard can that be?

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 796 moderator

    Hey @Fuzzy_Melon


    I'll forward your feedback, thank you for taking the time.

    As mentioned, there are no information that we can provide at this time regarding these updates.

    ———

    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • RainflurryRainflurry Member Posts: 30
    edited November 2021


    Post edited by Rainflurry on
  • Uncle_MiltonUncle_Milton Member Posts: 84 ✭

    I will pile on here.... making the shipping reportable and averaging over the cost of goods for the PO would save time for sure.

  • RainflurryRainflurry Member Posts: 30
    edited November 2021

    Adding freight to an item's cost is a feature best left to your accounting system, not Lightspeed. Is there a POS system out there that has the option to handle landed cost? Most entry-level, and some mid-level, accounting systems don't even accommodate it.

    Post edited by Rainflurry on
  • masher242masher242 Member Posts: 5

    I would like to see the freight added to the COGS for across the items too. Freight is increasingly a major factor in an items cost!

  • RainflurryRainflurry Member Posts: 30
    edited November 2021

    Having freight allocated to items would throw off reports used for reorder budgets, open-to-buy, etc.

    If this is something you need, think about doing it in your accounting system like QuickBooks.

  • ekempekemp Member Posts: 10

    I would like to see the freight added to the COGS across the items too. Freight is increasingly a major factor in an items cost plus duties etc! When a container cost $22,000 those cost are split across those products and are added to our products cost of goods, so when sold we have a true COGS (cost of goods sold)! This is a must, or we have to run our own spread sheet spread the cost, change the vendor cost to our true landed cost (vendor cost + high shipping cost + plus duty (6% as high as 40% on some products) which are all cost of goods!!! so having this as a PO feature is a must have!!

  • SteveMartinSteveMartin Member Posts: 1

    I also need the freight costs added to the CoGS. Our previous POS system we were able to do this. And I was shocked that this feature is not available in LS (I have been waiting for over two years). Like many others that have posted, our freight costs can vary substantially (sometimes adding as much as 25% to the cost of an item) and it is impossible to really know what the margin for a brand or category is without knowing the freight. We don't want to add this cost in to each item manually (as doing this creates other issues). For those saying to just include freight in QB, that is fine for seeing total margin for fiscal reporting for the entire company. But as far as I know, it is useless for reporting and making buying decisions based on brand and/or category gross profit (or margin) performance. I am really hoping this basic feature is enabled soon, as I feel like, in a lot of ways, we are operating blind folded.

  • gregaricangregarican Member Posts: 955 

    While these fields might not be reportable via the Retail web client, they are accessible via the API --> https://developers.lightspeedhq.com/retail/endpoints/Order/. While this isn't an ideal out-of-the-box solution, if anyone is integrating with a third-party accounting system then the integration could access these fields.

  • Uncle_MiltonUncle_Milton Member Posts: 84 ✭

    API isnt helpful if you dont know how to use it or cant afford to pay for someone who does.... most retail stores need the tools at hand for a basic user

  • emacgeeemacgee Member Posts: 65 

    I'll chime in on this one as well. Having these values be reportable or automatically factored in as part of the COGS then that would be tremendously helpful.

Sign In or Register to comment.