Skip to main content

Washington State Tax Reporting

Distributor guide to Washington state tax reports in Encompass: beer, wine and spirits purchase and tax credit forms (LIQ755, LIQ779, LIQ161) and their data sources. Needs state tax codes set; v24.11+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 24.11

Pre-Conditions

Important Configurations:
​
​

State Tax Codes
​
​
​

Options that can be set are:

  • Cider
    ​
    ​

  • Non-Fortified Wine
    ​
    ​

  • Fortified Wine
    ​
    ​

  • Beer - Low Rate
    ​
    ​

  • Beer - High Rate
    ​
    ​

  • Spirits

Steps

1. Select Location(s)
​
2. Select Date Range
​
3. Select Report Type
​
4. Create Report

Fields And Definitions

Form LIQ755 and LIQ755A: Beer & Wine Purchases

  • Purchase Data = Purchase.ReceiveDate within Start/End Date filters and Vendor.VendorType <> Distributor or Transfer
    ​
    ​

  • Licensed Trade Name = TaxEntities.TaxEntity
    ​
    ​

  • Location Address = Locations.Address
    ​
    ​

  • Supplier's WSLCB License No = Suppliers.LicenseNumber
    ​
    ​

  • Supplier Name = Suppliers.Supplier
    ​
    ​

  • City or Country = Vendor.City or Vendor.Country if <> United States of America

Form LIQ779 and LIQ779A: Beer & Wine Tax Credits

  • Invoice Data = InvoiceTransHist.Date within Start/End Date filters
    ​
    ​

  • Licensed Trade Name = TaxEntities.TaxEntity
    ​
    ​

  • Location Address = Locations.Address
    ​
    ​

  • Supplier's WSLCB License No = Suppliers.LicenseNumber
    ​
    ​

  • Supplier Name = Suppliers.Supplier
    ​
    ​

  • City or Country = Vendor.City or Vendor.Country if <> United States of America
    ​
    ​

  • Total liters/barrels sold to Military = Customers.CustomerType.IsMilitary = 1, True
    ​
    ​

  • Total liters/barrels exported from state = Customers.State <> WA
    ​
    ​

  • Total liters/barrels claimed for freight damage and destruction are not automatically populated. These values need to be inputted by the user offline based on claims approved by the state.

Form LIQ161: Spirits Purchases
​
​

Part 1:

  • Purchase Data = Purchase.ReceiveDate within Start/End Date filters and Vendor.VendorType <> Distributor or Transfer
    ​
    ​

  • Licensed Trade Name = TaxEntities.TaxEntity
    ​
    ​

  • Location Address = Locations.Address
    ​
    ​

  • Supplier's WSLCB License No = Suppliers.LicenseNumber
    ​
    ​

  • Supplier Name = Suppliers.Supplier
    ​
    ​

  • City or Country = Vendor.City or Vendor.Country if <> United States of America


​
Part 2:

  • Invoice Data = InvoiceTransHist.Date within Start/End Date filters and Customer.CustomerAccountType = Sale
    ​
    ​

  • Sales to On Premise Retailers = Customers.OnPremise = On Premise
    ​
    ​

  • Sales to Off Premise Retailers = Customers.OnPremise = Off Premise
    ​
    ​

  • Sales to Washington Distributors = Customers.CustomerType.TradeChannel = 43, Sub-distributors
    ​
    ​

  • Sales exported from Washington = Customers.State <> WA

Did this answer your question?