Hi there, CB0.
I'll provide steps on how to run a report that summarizes the product sales by the date they were sold. Then, provide you with information on how the sales reports run depending on the Report basis.
When you run the Sales report, I suggest choosing the Accrual as a Report basis. This way, you'll be able to see the sales by date they were sold. That being said, it will also show the time when you entered a transaction.
Yes, it could be the reason the report shows the date paid when you running as a cash basis business. This is because the Cash method only pulls up paid transactions on financial reports while Accrual reflects completed and pending transactions.
Then, I recommend consulting an accountant. This way, you can check if you can create an accrual report if you're handling a cash basis business.
You can check this article to see the difference between Cash and Accrual basis and how to set them as preferences in QuickBooks Desktop: Differentiate Cash and Accrual basis.
Please refer to these articles on how you can personalize your reports to show the specific data and to view different reports that cater to your business needs:
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.