Minimum Version Required: 24.11
Steps
Steps To Create Report
Select Location(s) and Date Range
Click Comptroller Report Excel
Click on the link that appears at the bottom of the page to download the file
Fields And Definitions
Beginning Inventory - Inventory on start date
Total Gallons Received - Number of products received within the selected date range
Total Gallons Available - Beginning Inventory values and Total Gallons Received values
Adjustments to Taxable Transaction - Invoice transactions that were processed for inventory adjustment
Military Sales - The number of sales on verified invoices for customers types with military = true and invoice date is within the selected date range
Ending Inventory - Inventory on end date
Total Taxable Gallons - Number of total gallons on invoice transactions that are verified
Tax Due - Tax Amount based on verified invoices within the selected date range
Net Tax Due - Tax Amount after adjusting Discounts from the Tax Due
Total Due - Sum of Net Tax Due, Penalties and Interest