taxable cigarette wholesale dealer’s report...match exactly what is printed on the invoice. this...
TRANSCRIPT
TAXABLE CIGARETTE WHOLESALE DEALER’S REPORT
(Taxable CWD)
Log into EDS using your Email Address/User Id and Password.
If you have forgotten your password, click on the Forgot Password? link.
Logging into EDS
Choose the license that you are filing the report for from the drop down menu . If you are using the FTP bulk upload process then you can click on the Upload to FTP Server link . If you are entering the detail manually or uploading only Transaction Data, click the correct report link under File a New report
Filing a New Report
Upload to FTP Server
The FTP Bulk Upload process to file your reports is detailed here. If you are using this method and click on the Upload to FTP Server link you will see this
screen. From here you would click Browse and choose the file that you wish to upload. This is one optional method for filing reports and is complete at this
step. If you are Manually entering data or uploading Transaction Data See the rest of the Tutorial below.
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.
Filling out the General Information Tab
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 *.
Select the Load Prior Balance button in order pull the balance on hand from the prior month report.
Stamps/Coupons
Any data entered throughout Stamp Purchases, Stamp Usage, Credits or Indian Coupons will automatically carry forward to the Summary sub-tab.
Stamps/Coupons
Report Detail
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 here.
Assistance can also be provided through the EDS support mailbox.
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.
Report Detail Overview
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.
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, “Enter a Valid License Number Required”
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 here.
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.
Invoice Information The invoice date and invoice number must
match exactly what is printed on the invoice.
This is for any invoice for product you receive or selling and invoicing to another
licensee. No other data should be used in these fields.
Inline Sorting of Detail
To help with finding detail that has already been entered EDS offers sorting by certain fields. Any column with a darker labeled header
may be clicked on and the data will be sorted in ascending or descending order by that field.
Changing and Deleting Entries
An entry can be changed or deleted using the radio buttons at the far right of each entry.
Changing an Entry
Click on the Icon to change an Entry. You can change any of the fields shown in white.
When complete click on the Icon to save changes. You will see a notice that the transaction was added successfully.
If You did not need to make a change click the Icon to cancel.
Upload Multiple Transactions
EDS now allows for the upload of multiple transactions as long as they are formatted in the correct way. To begin click the Upload Multiple Transactions button.
To begin formatting your Transactions correctly, first download the template.
The Template is in .csv format. Manipulate your data in Spreadsheet form to fit the labeled columns correctly
For Transaction Type, Pack Size ID and Stamp Type ID codes you will need to Download Lookup Legend.
The lookup legend shows what all the transaction codes are that need to be used to format any type of report.
There are two links to download for the complete Business Entities listings here under Add DBPR Business Entities.
When your file has been formatted and saved click the Browse button to find the file.
Choose your file and click Upload.
The dialog box will show if records are accepted as valid. Valid records may be added but if there are any invalid records you may want to correct them and upload again before adding. Any transactions added will be duplicated if added again.
If records are rejected the dialog box will show which ones with the reasons why so that it may be corrected and uploaded again.
Any accepted uploads will show in the Transaction Detail. You can enter the detail that was not accepted manually or correct the indicated errors
in the file and upload again. It is necessary to remove the correct records from the file before
uploading a new file that corrects the previous errors. EDS will duplicate transactions if they are uploaded multiple times.
Tip: Save your upload templates and use them to help with filling in subsequent
reports.
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.
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.
Detail for County Sales & Returns
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. Click the Load Actual Inventory Button to fill Beginning Balance Field with the previous months reported ending inventory.
Detail for 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.
Deleting a Record from Off-Premise Storage
The Pack Summary calculates Book Balance based upon the detail entered throughout the report. The ABT or Certified Inventory fields is the audited inventory amount. Click the Load Prior Inventory button to fill the Balance on Hand with the previous month’s Ending Inventory. 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.
Pack Summary
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.
Review & Confirm
After submitting, a confirmation page should appear. If you do not receive this confirmation page, contact EDS Support.
Contact EDS Support for technical questions or to report a problem. If you need assistance filling out a report, contact your district office.
Technical Support