TAXABLE CIGARETTE WHOLESALE DEALER’S REPORT (Taxable CWD)

Logging into EDS

Log into EDS using your Email Address/User Id and Password. If you have forgotten your password, click on the Forgot Password? link.

Filing a New Report

After logging into EDS with the username and password, the Home screen will load showing a link to file a new Taxable CWD report. Click on the link under File a New Report.

Filing out the General Information Tab

The General Information tab will auto populate based upon the information provided during the registration process. Red asterisks denote required fields. A Reporting Period month and year must be selected. A selection from the Amended? drop down box is also required, but defaults to “No”. Only if the report gets amended and resubmitted, should “Yes” be selected from the drop down box. Add the Report Submitted By name, which is the person who has verified the submitted the information. The Email Address is that of the person entering the report. The Filer Email address is optional.

Transaction Type Overview

Purchased In-State- A purchase from a licensed supplier located in Florida Purchased Out-of-State- A purchase from a supplier located outside of

Florida

Sales to Florida CWD- A sale to a licensed Florida cigarette distributor Sold out of State-A sale to an entity outside of Florida. A permit/license number is not required for this transaction type, but a specific name and address must be included Returns to Factory- Product returned to a manufacturer Return to Stock-The return of product sold to a licensed cigarette distributor Sales to Military-The sale of product to an entity that is part of a military base. These transactions are only recorded using the permit/license number for the applicable base name

Transaction Type Overview - continued

Cigarette Destruction- Product destroyed on site Sold to an Indian Reservation- A stamped product sold to an Indian reservation to be paid for with Indian coupons Other in, Other out-These should be used for any transaction that falls outside of the normal transaction types and only upon approval by your ABT district office.

Note: If you are having difficulty looking up or finding a permit/license number within EDS, please consult the webpage at the link below.

http://www.myfloridalicense.com/dbpr/abt/auditing/ABTLicensesandPermits.html

Assistance can also be provided through the EDS support mailbox.

[email protected]

Detail Fields

Complete all of the fields in the above detail tabs as appropriate based upon monthly transactions.

Helpful Hints

If you are keying in a large amount of data, save often.

This helps guard against data loss and is considered a “best practice”.

TIP: If you are going to pause the report activity for more than ten minutes, save the report and close out of EDS altogether.

To resume your report, log back in and open the report from the Saved Work link.

Saving a Report

Once these fields are satisfied, Save the report by navigating to the Cigarette Report Summary tab and selecting the Continue to Review & Confirm. From the Review & Confirm tab, select Save at the bottom. Once the report has been saved, EDS will close the report as confirmation of a successful save.

Accessing a Saved Report

There are several options to reopen a saved report by either selecting Home, My Reports or Search. If the Search option is used, click the drop down boxes for Search For, Month and Year. The Form Name is optional and not necessary if the other information is known. Click on the Search button at the bottom of the screen.

Any existing saved report will be found at the bottom of the screen. Select the correct link under View Report and continue entering transactions.

Stamps/Coupons

Stamps/Coupons

Start with the Stamps/Coupons tab and navigate through the various sub-tabs to record applicable monthly transactions. Required fields are identified with an * .

Any data entered throughout Stamp Purchases, Stamp Usage, Credit Vouchers or Indian Coupons will automatically carry forward to the Summary sub-tab.

Report Detail

License Filtering

Changes have been made within EDS.

The system now filters licenses to only allow those that should be associated with a specific reports. If submission of a different type of license or an expired license is attempted, EDS will reject it and return an error message,

“ No matching record found for this License Name!

”

For the Taxable Cigarette Wholesaler’s Report only the following license types will be allowed based upon the type of transaction: • Cigarette Manufacturers • Cigarette Distributors • Cigarette Importers • 4700006 (International) • 4700013 (Samples)

Transaction Filtering

After a license has been selected for a product transaction, the transaction type control will be changed to indicate which transactions are allowed for the license selected. The items in white and do not have an “x” are allowable transaction types. The items that have an “x” and are highlighted yellow indicate the transaction type is not allowed for the license selected. If the user selects an invalid transaction type, they will see the above validation error message.

This functionality is supported in modern browsers and will work in Chrome, Firefox, and Internet Explorer. However, Internet Explorer version 8 has been tested and works if the document mode is set to version 8. If the browser does not support the new changes, the new validation will not happen until the data is submitted to the web server.

All of these transactions require a Florida license/permit number with the exception of Sold Out of State, Other In, Other Out and Cigarette Destruction.

Report Detail Overview

In the Report Detail there is a drop down box for Transaction Type. Select the appropriate transaction and complete the required fields, designated by the asterisks. Add Transaction should then be selected. After each entry has been added, they will be listed individually. Under Product Transaction Summary, the entries will be summed up.

Note: Regarding pack size, 10’s are no longer allowed to be sold in Florida.

Using the Lookup Feature

There are two ways to search for licensees via the Lookup feature. If the license number is known, enter the number in the Florida License/Permit # field and select the Lookup button. If the name of the licensee is known, enter the entire name or enter the first part of the name followed by the % sign in the Name of Supplier/Purchaser field. Select Lookup. The % will start a wildcard search and provide a greater chance of finding the licensee.

No Results Using the Lookup Feature

If an invalid or unrecognized license number is entered, a red error message displays, “Invalid License # for this report!” or “No matching record found for this License Number!”.

A licensee’s name and/or their license number can be verified by navigating to the list of beverage distributors on the Division’s site.

http://www.myfloridalicense.com/dbpr/abt/auditing/ABTLicensesandPermits.html

If a user is planning on filing via file transfer protocol (FTP), instructions can be found at the following uniform resource locator (URL): http://www.myfloridalicense.com/dbpr/abt/eds/batch-upload-instructions.html

Multiple Lookup Results

In the event of multiple returns from using the Lookup feature, a popup window will appear with possible options based upon the search criteria. Select the appropriate row and the fields on the Detail tab will populate with the licensee’s information. The Valid Until column will only return a status of “Active” or an expired date value. An expired date in this column means that the actual license expired two months prior to that date and can no longer be used in EDS. If a transaction occurred within that two month time frame, contact EDS Support at [email protected]

.

The columns can now be sorted using the triangles in the column headers, but the default sort is by business name. The triangle of a sorted column will appear grey and only one column can be sorted at a time. An arrow pointing down shows a sort in descending order. A upward arrow represents an ascending order sort.

Multiple Lookup Results - Continued

Search Within Results allows the user to filter the search results locally. The filter functionality will hide rows that do not match the filter criteria. The filter will match across any column value. If the user does not see the needed license, select Cancel and contact the EDS Help Desk at

[email protected]

. Supply the name and address of the business if possible.

Entering Transactions

Once the required data have been entered, select the Add Transaction button. If all data have been entered correctly, then a message stating, “Successfully added transaction.” will be displayed. The quantities will be summed within the Product Transaction Summary at the bottom of the screen under the individually listed transactions. If data have been incorrectly entered into the fields at the top of the screen, Clear All will remove the information above that button. If all of the required fields have not been completed, EDS will flag those empty fields and block the transaction. These steps should be duplicated for any other type of transaction.

Deleting Entries

Once a transaction has been added, the information cannot be changed. The data must be deleted using the red radio button at the far right of each entry and the transaction will need to be re-entered correctly. After an entry has been deleted, EDS will display a message stating, “Successfully deleted a transaction”.

Do not forget to save your report often!

County Sales/Returns

Detail for County Sales & Returns

Use the drop down boxes to enter transaction data based upon monthly movement of stock. All fields are required (

*

) and will be listed in the Transaction Summary once each entry has been added.

Off-Premise Storage

Detail for Off-Premise Storage

The Off-Premise Storage tab is used to record any received/transferred product to and from a storage facility. Once the required fields are satisfied, record the transaction by clicking on the Add Received/Transfers button.

Deleting a Record from Off-Premise Storage

If a record from the Received/Transferred section is incorrect and needs to be deleted, only if the Summary data have not been entered can an individual Received/Transferred transaction be removed. If the Summary has been completed, then the Summary must be deleted before the transaction can be corrected. Only at that point should the Summary information be re-entered.

Pack Summary

The Pack Summary calculates Actual Inventory based upon the detail entered throughout the report. The fields in white are the only fields that can be edited manually and are organized in columns by pack size.

Once the Cigarette Report Summary is complete, click on the Continue to

Review & Confirm

button at the bottom of the page

Review & Confirm

The Review & Confirm page breaks down the report for review. At this stage, if the report is finished, click on the Save button and access the report again through EDS using Home, My Reports or Search. Once in the saved report, go to the

Review & Confirm

page and click on Submit.

After submitting, a confirmation page should appear.

If you do not receive this confirmation page, contact EDS Support.

[email protected]

Resources

You may research license/permit numbers from the Alcoholic Beverages and Tobacco’s webpage.

http://www.myfloridalicense.com/dbpr/abt/auditing/ABTLicensesandPermits.html

More information on filing electronically: http://www.myfloridalicense.com/dbpr/abt/eds/

Technical Support

[email protected]

Contact EDS Support for technical questions or to report a problem. If you need assistance filling out a report, contact your district office.