Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI would like a sales report that summarizes product sales by the date they were sold not the date customers paid for them. We have customers that fall into the following categories: COD, Net 30 and still others that may take longer to pay. Because they vary in when they pay the Sales Report product counts are wrong. Payment posting status is set to either, but changing this has no effect on the report. Is there a way to set the sales report to be based on sale date not date paid? We are a cash basis business. Could this be what is causing the problem? If it is the problem, can I create a report that is accrual basis for a cash basis business?
Solved! Go to Solution.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.