Locations Packages State Package Code - This must be set to match the state's reporting to show the correct types. This is used for the beer and liquor reports

Ex: Distributor Package = 2/12/12 then the state package code = 24 Count / 12 Ounces

Georgia State Package Codes:

24 Count / 12 Ounces

12 Count / 12 Ounces

1/2 BBL

1/8 BBL

24 Count / 16 Ounces

22 Count / 12 Ounces

1/4 BBL

1 BBL

12 Count / 750 ML

Misc Count / Misc Ounces

1/6 BBL

Locations Product Types State Tax Code - Controls what products for what locations go in which report

Must be set as one of these: WINEOVER14GA, WINEOVER14, WINE14GA, WINE14, NonAlc, DISTILLEDGA, DISTILLED, BEER PACKAGE, BEER KEG, ALCOHOLGA, ALCOHOL

Jurisdiction Code - The county code for the jurisdictions for the local tax

Customer Set-Up

For selling, add the distributor state license numbers as the Customer State License Number

Military - Trade Channel = Military On/Off Premise

Airline - Trade Channel = Airline / Transportation

Church - Trade Channel = Church

Adjustments - Trade Channel = Inventory Adjustment (Was custom code)

Other Distributors - Trade Channel = Direct Distributor or Sub Distributor

Vendor Set-Up

For buying, add the distributor state license numbers as the Vendor License Number (schedule A&B)

Transfer - where to/from locations are different and is transfer vendor type

Return - where to/from are same and (-) quantity

State Tax Inventory - Set based off the product type state package type

Beer/NonAlc

Locations Product Types State Tax Codes - BEER KEG, BEER PACKAGE, NonAlc (schedule G)

Main Page - Set's the starting and ending inventory, totals the schedules and shows the calculated tax

Checking or reporting useKeg Depletions orGallons Depletions report

Set the product types to reflect the locations product types state tax code to get the correct numbers

Set locations to pull only the locations needed

Keg depletions is totaled in cases and gallons depletions is totaled in gallons, will have to manually total non kegs

Receipts is schedule A, where vendors are set to excise tax exempt false

Transfers In and Out is schedule B, where vendors are set to excise tax exempt true

Schedule A & B - Records the purchases received with the state package code and vendors.

Checking or reporting usePurchase Comparison

Set the product types to reflect the locations product types state tax code to get the correct numbers

Set locations to pull only the locations needed

Excise tax exempt false is suppliers (Schedule A)

Excise tax exempt true is distributors (Schedule B)

Schedule E - Malt Beverage Sales to Dealers and Employees

Checking or reporting usingSales Comparison report

Set the product types to reflect the locations product types state tax code to get the correct numbers

Set locations to pull only the locations needed

Ensure that the trade channels filter is set to Direct Distributors or Sub-Distributors

Wine

Locations Product Types State Tax Codes - WINE14, WINE14GA, WINEOVER14, WINEOVER14GA

Main Page - Set's the starting and ending inventory, totals the schedules and shows the calculated tax tax

Checking or reporting useWine Depletions

Set the product types to reflect the locations product types state tax code to get the correct numbers

Set locations to pull only the locations needed

These are all calculated in liters

Alcohol

Locations Product Types State Tax Codes - DISTILLED, DISTILLEDGA, ALCOHOL, ALCOHOLGA

Main Page - Set's the starting and ending inventory, totals the schedules and shows the calculated tax tax

Checking or reporting useDistilled/Alcohol Depletions

Set the product types to reflect the locations product types state tax code to get the correct numbers

Set locations to pull only the locations needed

These are all calculated in liters

Timothy Coleman
Special Agent in Charge
Alcohol and Tobacco Division
Georgia Department of Revenue
1000 Towne Center Blvd, Bldg 900-A | Pooler, GA 31322
Phone: 912-748-4053 | Fax: 912-544-9419
dor.georgia.gov