Shipping Costs in Purchase Orders

chopwoodchopwood Member Posts: 2
edited April 23 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 VanessaD on

18 comments

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 714 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.

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 714 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: 1

    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: 14

    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: 14

    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: 10

    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: 14
    edited July 30

    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: 13

    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: 14

    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: 14

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

  • CCFS_ZachCCFS_Zach Member Posts: 25

    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.

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 714 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: 3

    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?

Sign In or Register to comment.