User Tools

Site Tools


reports_-_inventory

Inventory Reports

  • This report is for quantity, not value. Qty in stock, qty sold, and so on are reported on. It does not give dollars sold
  • There are many filtering options and other report options that come into place. It is quite customizable

Florida Department of Revenue Report

Tobacco retailers in Florida are required to submit an “information report” to the State of Florida containing the following:

  • Seller’s Name
  • Seller’s license # - Right justified
  • Retailer’s name
  • Retailers’ beverage license # – Right justified
  • Retailer’s address, street, city, state, zip
  • Item type, cigarettes, cigars, tobacco, beer, wine, spirits, or any combo of these items
  • Net monthly sales total in dollars

This will apply to every business who sells into Florida who does not collect sales tax. It is to ensure that purchasers of product are properly claiming tax. This is State mandated and they will apparently lose their license if the report is not submitted in it’s entirety.

For the Florida Department of Revenue report we used the purchase filter feature of the Design customer report. We needed the following fields, the Windward field follows afer the dash:

License # - Info field (may depend on where customer keeps it though) Retailer Name - Name Address - Address 1 City - City State - Prov, State Zipcode - Postal/Zip Sales Month - Needs to be manually typed in, copied and pasted (potential solution would be to put this into a free form field which would automatically populate this Monthly Net Sales - Use the Total $ (Purchase Filter) - Add 13 of these, one for each month and one for annual Rename the heading Go to the purchase filter tab Change Purchase Filter name Change Purchase Total to Greater than or equal to .01 Update Purchased Dates Update Purchased Categories Go back to Columns tab, click on each purchase filter, then choose the appropriate Purchase filter View, and export to Excel. Customer may need to massage the data a bit.

Multicat Report

Inventory Value Report

The inventory value report allows you to get the total, and broken out details of the value of your inventory. This is the recommended report for reporting on your inventory sub-ledger. This value should correspond to the value of your Inventory GL account (1200) if you are following the best practice methods.

How This Report Works

This report takes the First In First Out (FIFO) stock lines for each part in your system and adds up the value to calculate the value of your inventory. You can view categories with a total, or you can view detail to see the value of each inventory item within the report.

When Can The Inventory Value Report Be Used

  • This report is a relatively easy way to review the breakdown of the values of your inventory.
  • It is used at year end before and after you count your inventory.
  • It is used on a regular basis to help you reconcile your inventory.

Back Dated Inventory Value

  • This report performs a guesstimate of what the inventory value is at a previous date.
  • This report does not take into account all scenarios so it is not always correct.
  • This report should not be used for financial purposes due to its inaccuracy
  • This report does not contain details on the adjustments that make it up.
  • Note: This report was made for a customer who wanted the back dated inventory value report calculated in a particular way, and even though additional scenarios have been included, it is by no means complete.
  • In order to move forward with issues of accuracy I believe that we would have to be able to produce a report where we can drill down into the details of the changes including date/time and transaction the change occurred on.

Open To Buy Report

  • This report shows inventory value information for a category and the associated GL information for budgets from the associated GL accounts.

Back order report

  • The back order report shows information about inventory back ordered on invoices for your customers
reports_-_inventory.txt · Last modified: 2021/08/02 06:34 (3 years ago) by anemenzo