Upon running my monthly sales reports (e.g., sales by customer detail) which includes invoices and sales receipts, I've customized the report to include the column "Paid"
My issue is that sales receipts are all showing as unpaid, although they have been at the time of sale, in full (that is why it's a sales receipt). How can I show that the payment has been processed and it is PAID.
(QB desktop Premier 2019)
I've got you covered, FMW.
Let's customize the Sales by Customer Detail report again to show the Paid status of your sales receipts. I'll guide you how.
If the status still shows unpaid, let's run the Verify and Rebuild tool to fix this. This tool helps resolve minor and common data issues in QuickBooks.
Before we proceed, secure a backup of your company file. Once done, follow these steps:
For more information about personalizing your reports, I suggest checking this article: Customize reports in QuickBooks Desktop.
Additionally, I've included an article that'll help you memorize your reports in QuickBooks. This ensures you're able to save the current customized settings for future use.
Please reach back to us if you have other concerns or questions about reports. Doing so helps us to further assist you.
Thank you for response. However, that does not help me with what I am accomplishing with the report.
B4 applying your solution, consisting of Invoices and Sales Receipts any invoices that are unpaid show up as such, which is correct. Again, the Sales Receipts appear as unpaid.
Upon applying your solution, the only "Paid" Sales Receipts are those which were voided and of course, zero out so those show as paid.
Applying a filter does not generate the report we need: ALL TRANSACTIONS (Invoices an Sales Receipts) paid (which would be all SRs) and invoices (which could be both paid and unpaid). Also, BTW, the Date Paid column is blank. I've had that issue and QB just doesn't seem to resolve it (in both vendor and customer reports).
So, any other suggestions?
Thank you for getting back to us here on the Community page, @FMW.
I also got the same result when running the report in QuickBooks Desktop. At this time, this is how QuickBooks works with vendor or customer reports. For the time being, I suggest disregarding the paid label for your sales receipts since they were paid during the actual sales.
As a workaround, you may export the report to Excel. From there, manually update the label and add the Paid Date details.
I'll be taking note of this matter, @FMW. This way, our engineers will know and be updated on the feature needed. To stay updated with the latest QuickBooks news and feature enhancements, I recommend visiting our blog site.
For additional tips about running and customizing reports in QuickBooks Desktop, I recommend opening this article: Understand reports.
If you have any other QuickBooks questions or feedback, please feel free to leave a comment below. I'll get back here as soon as I can to help you again. Have a great day!
Thank you for reply.
Please take up with engineers. If I have to export and complete data manually that is already stored in QB, then I must say Intuit QB is deficient.
Again, I appreciate your response, nevertheless. PLEASE PLEASE ask engineers to handle this.
Have a safe, happy 2021.
Can anyone advise if this is going to be looked at - have exactly the same issue. I need to pull a report for any sales receipts created that the credit card payment declined and so the status is showing 'Paid' (Payment Failed)
I appreciate you for jumping into this thread, @DLADCO.
Our Technical Support team can best help you with this issue with the sales receipt showing as paid when it isn't. This necessitates a thorough investigation to determine the reason and devise a solution. They have the tools necessary to look into your account in a secure manner and determine the root of the problem.
Please click this link to reach out to our support: Contact Payments or Point of Sale Support.
I'm looking forward to hearing this being resolved. Let me know if you have other QuickBooks questions and I'll be here to help. Wishing you a good one.
Sales receipts not showing paid is a huge problem for my company as well. We paid our sales reps bonuses once all their invoices for the period have been paid. So we have to pull reports for monthly and quarterly bonuses and it is a real problem when sales receipts which are paid at the time they are created are showing not paid. We cannot filter transaction type to eliminate them because then the amounts would not be included in the reps monthly and quarterly totals which bonuses are based on. I tried the rebuilt, but it did not correct the problem.
Please help, the owner of our company is not happy to receive bonus reports showing sales unpaid.
I appreciate you for running the verify and rebuild steps, Deborah8050.
I'm here to share details about recording sales receipts.
In QuickBooks, a sales receipt is used when your customer pays you on the spot for goods or services.
If you mean the invoices are not showing as paid, let's ensure that you've selected the correct accounts. Here's how:
Then, you can run the Transaction List by Customer to verify all the transactions.
For more information, you can also check out these articles for future reference:
Let me know how it goes in the comment section. I'm always here to help.
Thank you for clarifying, Deborah.
I see that the Unpaid status of sales receipts can cause a miscalculation. Personally, I prefer not to see a payment status for sales receipts since they are understood as paid at the time of sale. Please submit feedback about this from your QB company, so our engineers can consider creating changes in future updates.
I got a solution for you. You can pull up the Sales by Rep Detail or Sales by Customer Detail and set the Report basis to Cash. This setup will only count the sales receipts and paid invoices.
You can also check about customizing reports for your additional reference.
Let me know if you have other questions in mind. I'm just around to help.
Thank you for your response but I'm afraid it was not helpful. There is a difference between accrual based and cash based reports. The accrual based report shows me, for example, all the sales for the 1st quarter of the year. Our sales reps are paid bonuses on their quarterly sales, but only after all the invoices for that quarter have been paid. Thus I need the accrual based report for Q1 that shows the paid status of all the sales. A cash based report, on the other hand, will tell me what invoices were paid during the 1st quarter, but that will include sales from previous quarters so that report will not be helpful.
Please advise. Our company chose QuickBooks Enterprise Manufacturing edition over Oracle by my recommendation, and the President and Vice Presidents are not happy when we encounter an issue with being able to pull reports with data that is reliable, especially when they are sales reports and even more so when they impact payroll.
Thanks for chiming back in! I noticed the agent gave you some steps for a Cash Report. Following the exact instructions, you can select the Accrual basis instead for that report, as seen in the screenshot he shared. You also have the ability to adjust the date by using the drop-down button next to Dates.
Let me know if that helped! Don't hesitate to comment on the thread if that is not what you want. I will be more than happy to investigate this more. See you in a few!
Thank you for your response, but my original question was about an accrual based sales report that shows sales receipts as unpaid. The support tech advised me to switch to a cash based sales report and I took the time to explain why that will not solve my issue.
I repeat, my original question was why does my accrual based sales report show sales receipts as unpaid in the paid status?
Please review the thread of conversation and advise.
Thanks for getting back and giving us an update about the issue, @Deborah8050.
Since you're still getting the same result, I'd recommend reaching out to our QuickBooks Customer Support Team. They can review your sales report and conduct a further investigation to isolate the issue. This way, we can check why the sales receipts are showing as unpaid on your report.
Here's how to connect with them:
To ensure that we address your concerns on time, please check when our customer support is available.
I've also included an article that'll help you memorize your reports in QuickBooks. This way, you can save your current customized settings for future use.
Let me know if there's anything else I can help you with by dropping a comment below. Have a great rest of the day.