Minimum Version Required: 25.02
Steps
How to run New Hampshire State Tax Reporting
1. Using Universal Search, navigate to the State Tax Report dashboard
2. Click the New Hampshire tile link
3. Follow the guide on the New Hampshire State Tax Report dashboard to see definitions, steps, and related tables
4. Create report by clicking the State Tax Report tab and then clicking the Excise Tax Excel button
5. Reports will directly download to the default download folder on your computer
Fields And Definitions
Column Definitions
On Hand First of Month - Inventory on the first day of the month
Returned from the Retailer - Number of products returned from retailer due to different reasons code
Purchased During Month - Number of purchases within the month
Total Available - On hand first of month + purchased during month + Returned from Retailer
On Hand End of Month - Inventory on the end of the month
Difference - Total Available - On Hand End of Month
Loss and Waste - Number of products that were not sold due to damage, out of date or adjustments.
Quantities to be Accounted For - Number of products that are loss and waste that should be regarded
Return from Retailer - Number of products returned from retailer due to different reasons code
Sales Outside of NH - Invoice transaction made outside of NH location
Total Deductions - Return from Retailer + Sales outside State of NH + Sales on which Additional Fee is exempt
Net Quantity on which Additional Fee is to be paid - Quantities to be Accounted for - Total Deductions
Gallon Content - Total number of gallons
Gallonage - Net quantity on which additional fee is to be paid x Gallon Content
Net Gallonage - Combined Totals - Gallonage Across
Total Additional Fee @.30 GAL - Net Gallonage x .30
Total Additional Fee Due plus Adjustment - Total Additional Fee Due @.30 + Adjusted Additional Fee