Why don't my MW Wines maps calculate tax correctly?

MW Wine Auctions Format

Why doesn't Lightyear calculate the correct tax on my bills from MW Wine Auctions?

This auctioneer splits GST values across two columns, one being the Hammer Price (unit cost)* and Premium Price (Supplier's Fee). Lightyear's 'mapper' (our tech we use to extract metadata) requires a unit's GST value to be in one column.


If you receive MW Wine bills, users need to:
  1. Adjust manually, the GST values** to account for this. Or...
  2. Even better, ask the supplier to add a 'Total GST' column to their documents in their Accounting System (generally a box gets ticked in 'settings' that adds this for all of their customers).
By all means introduce our success team at Lightyear at support@teamlightyear.cloud and we'll work with MV to deliver the best experience for the global Lightyear community.

*Note that GST appears to be optional on some 'Hammer' prices, but consistent on 'Premium' prices; be vigilant when balancing your bill.




      

    Check out our
    Product Blog Series
    to stay up to date

      • Related Articles

      • Fino Foods Format

        Why does Lightyear assign GST to items that do not attract GST on my Fino Foods bills? This supplier bill format is unique in that they only show 'Sales GST Free' items (in the 'Account' column), but display nothing for items that attract GST.  As ...

      • Paramount Liquor

        Paramount are able to generate invoices in two formats with a very different structure to the metadata within them. Click on the below to see an example of the good format. If you would like to receive the “good” format, you can email ...

      • Coca Cola Amatil formats

        Coca Cola Amatil are able to produce multiple formats for their bills. Some are more Lightyear friendly than others when it comes to being able to extract data from them. We will refer to these as the "good format" vs the "bad format". See images ...

      • PFD Food Services Formats

        PDF Food Services are able to produce multiple formats for their bills. Some are more Lightyear friendly than others when it comes to being able to extract data from them. We will refer to these as the "good format" vs the "bad format". See images ...

      • Bidfood Invoice Formats

        Bidfood are able to generate invoices in two formats with a very different structure to the metadata within them. On the first screenshot you can see what we call the “good” format in which the metadata is neatly structured in the relevant columns ...