Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

QuickBooks Desktop Sales Report by Sale Date not Date Paid

I 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
Best answer June 19, 2020

Best Answers
QuickBooks Team

QuickBooks Desktop Sales Report by Sale Date not Date Paid

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.

View solution in original post

1 Comment
QuickBooks Team

QuickBooks Desktop Sales Report by Sale Date not Date Paid

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.

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us