JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I'm not sure how would you like for your report to show in an Excel file. But you can create Excel Reports here in JotForm.
If you want to include those fields in your report. You need to include it in your form first as a field and not just a Text.
Say, for example:
You don't have a Date and Vendor fields on your form as what I have checked. You can add them and just set those fields to "Read-only" under their Properties so they cannot be changed.
Items are shown in your Matrix, however, for Quantity, I believe that needs to be computed. Can you explain how you would like for this to show?
Separate report for distribution by class/name/item. I am not sure I understand this clearly, can you further explain this part in details so we can better assist you?
You can generate Excel reports base on submissions under MyForms page.
Then, on Submissions page
You can also create one from the Reports tool
You will then be given a link that when you visit, your excel report will be downloaded.
I hope this helps. Let us know if you need any further assistance. Thank you.