Division of Alcoholic Beverages and Tobacco Beer Manufacturer’s Monthly Report Logging Into EDS Log in with the user id and password provided through.

Download Report

Transcript Division of Alcoholic Beverages and Tobacco Beer Manufacturer’s Monthly Report Logging Into EDS Log in with the user id and password provided through.

Division of Alcoholic Beverages and Tobacco

Beer Manufacturer’s Monthly Report

Logging Into EDS

If a user has not registered, click on the New User? link.

If a user cannot remember password, click on Forgot Password?

Filing a New Report

Click on the link under File a New Report.

Differences from Paper Reporting

The Beer Manufacturer’s Monthly Report combines the three pages of the paper report. The mass data entered into the different tabs automatically calculate on the Computation of Tax screen.

Completing the General Information Tab

The General Information tab will auto populate with information provided during the registration process. A Reporting Period month and year must be selected. A selection from the Amended? pull down menu is also required. Only if the report gets amended, should “Yes” be selected from the drop down box. Add the Report Submitted By name, which is the person verifying the submitted information. Once completed, click on the Save button.

Detail Screens

Information needed:

• Transaction type • Florida license number or… • Name of supplier/purchaser • Invoice number • Invoice date • Quantity of product • Beer: Report per individual units(cans/bottles). Do not enter per case.

License Filtering

Changes have been made within EDS.

The system now filters licenses to only allow those that should be associated with a specific report. 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 Beer Manufacturer’s Report only the following license types will be allowed based upon the type of transaction: • Beer Manufacturers • Retailers (Package Stores) • Consumption on Premises (COPs) • 4700006 (International) • 4700007 (Out of State Military) • 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 are submitted to the web server.

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 be selected. After each entry has been added, they will be listed individually. Under Product Transaction Summary, the entries will be summed up.

Beer Manufacturer Report Changes

The Taxable Sales have been renamed Taxable Product. The row item Taxable Sales on the Summary Tab has been renamed Taxable Product as well.

New Transaction Types

There are now 3 new transaction types on the Report Detail:

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 don’t 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.

Adding a Transaction

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 beer transaction.” will be displayed. The transaction types and quantities will be summed within the Product Transaction Summary at the bottom of the screen under the individual 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 beverage transaction.

Deleting Entries

An entry cannot be changed; it can only be deleted using the red radio button at the far right of each entry. After an entry has been deleted, EDS will display a message stating that the deletion was successful.

Do not forget to save your report often!

Taxable Product

On the Taxable Product tab, enter the figures for any Taxable Consumption, Gifts to Employees, Shortage on Inbound Transfers, Transferred for Tasting and/or Less Returned from Tasting. EDS will automatically calculate and display the total taxable sales.

Summary

On the Summary tab enter applicable data into the white, editable fields. Select Save when done. EDS will display a message if the save was successful.

Computation of Tax

The data from the previous screens will automatically be calculated on the Computation of Tax tab. Any authorized credit and the associated amount should be entered in the white, editable fields. The total tax due will be displayed in the Net Amount fields. Select Save when done.

Saving Your Report

When the Save button is selected, EDS will display a red message stating the “Data has been saved successfully” (sic). If exiting the report do so only after you see this message!

Helpful Hints!

Save your report 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.

Accessing a Saved Report

Screen shot of home page showing Saved Work link. To access a saved report, select this link.

Review & Confirm

Verify that the information is accurate. Select Save and the click Submit Report.

Successful Submission

After Submit Report is selected, a confirmation message will display stating “You have successfully submitted the report.”

Accessing a Submitted Report

A submitted report can be accessed either through selecting the Home or My Reports link at the top of the screen.

Amending a Submitted Report

To amend a submitted report, open the link under Submitted Work. On the General Information tab, change the Amended? field to “Yes” and proceed to make the necessary report changes before saving again and then resubmitting.

Resources

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