Minimum Version Required: 24.11
Pre-Conditions
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
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
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
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
Steps
Steps To Create Report
1. Select Report Type
2. Select Location
3. Select Start & End Date
4. Select State Tax Report Type
5. Click Create Excel
6. The Excel file will download when the report has finished
Fields And Definitions
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 or Gallons 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
Schedule A - Receipts or purchases, where vendors are set to excise tax exempt false, check with a purchase comparison report
Schedule B - Transfers In and Out on purchases, where vendors are set to excise tax exempt true, check with a purchase comparison report
Schedule C - Records invoices sent to other distributors, Customer Type has Trade Channel = Direct Distributor and is Excise Tax Exempt = True
Schedule D - Records invoices sent to customers with Customer Type is Military = True, check with a sales 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
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 using 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
Product Types Type Code - Liquor
Main Page - Set's the starting and ending inventory, totals the schedules and shows the calculated tax tax
Checking or reporting use distilled/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
Best Practices
Georgia State Contact
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