mdiah said:

I'm trying to generate a list of my quarterly report to pay my tax AND I want it to list it by sales agent so I can also pay my sales reps their commission at the same time

I am going to assume you mean sales tax reporting on a quarterly basis.  The reports required for sales tax reporting and commissions for sales reps are different, so I would not attempt to combine them.

For sales on your sales tax remittance, you need the income statement to show the total revenue for the period on the Reports, Financials menu.  I also print the balance sheet for the end of the period and the general ledger report for the sales tax accounts before I post the remittance.

For sales rep sales, assuming you are using the Salesperson field on the invoices, you need the Sales By Salesperson report on the Reports, Receivables menu.  This report will not record any revenue when you do not record a sales person or if you record revenue in a different module than sales, so it is not useful for the sales tax record of total revenue for the period.

To do them both on the same report would require custom reporting outside the program.  The general ledger report will show you the information you requested above but will not show you the sales person unless you post each sales persons sales to a different sales general ledger account (which some people do but most will not).

I want the Report to come out looking like something like this