cancel
Showing results for 
Search instead for 
Did you mean: 
FMW
Level 3

Sales Receipts

Good  morning,

  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.

 

Thank you,

(QB desktop Premier 2019)

 

14 Comments 14
CharleneMae_F
QuickBooks Team

Sales Receipts

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.

  1. From the Sales by Customer Detail report, click Customize report.
  2. Under Display, add the Paid column.
  3. Choose Paid Date and amount under Display.
  4. Click on the Filters tab.
  5. On the Search Filters, type in Paid Status.
  6. Select Closed then click OK.

 

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:

  1. Go to the File menu.
  2. Select Utilities, and choose Verify Data.
  3. If QuickBooks detected an issue, select Rebuild Now. Some users recommended that rebuilding data thrice fixes data damage.
  4. Click OK when you get the message "Rebuild has completed."
  5. Once done, repeat steps 1 through 2 to verify your rebuilt date. 

 

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.​​​​​​​

FMW
Level 3

Sales Receipts

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?

 

 

 

 

 

 

 

Angelyn_T
QuickBooks Team

Sales Receipts

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.

 

  1. From the report's page, click on Create New WorkSheet from the Excel drop-down.
  2. Tap on in a new workbook.
  3. Hit Export.

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!

FMW
Level 3

Sales Receipts

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.

 

 

 

DLADCO
Level 1

Sales Receipts

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)

 

Thanks

 

 

LollyNino_C
QuickBooks Team

Sales Receipts

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. 

Deborah8050
Level 1

Sales Receipts

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. 

Adrian_A
Moderator

Sales Receipts

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:

 

  1. From the Customers menu, select Customer Center.
  2. Select the customer's name.
  3. Locate and click the invoice payment.
  4. Double-check the account.
  5. Click Save & Close.

 

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.

Deborah8050
Level 1

Sales Receipts

I am not talking about invoices, I'm talking about sales receipts, the documents we create for cash sales. 

JessT
QuickBooks Team

Sales Receipts

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.

 

  1. Click on Help and select Send Feedback Online.
  2. Choose Product Suggestion.
  3. In the Product Area, select Reports.
  4. Enter the details and click Submit Feedback.

 

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.

 

sales by rep detail.PNG

 

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.

Deborah8050
Level 1

Sales Receipts

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. 
Thank you,

Deborah 

SashaMC
Moderator

Sales Receipts

Hey Deborah8050,

 

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! 

Deborah8050
Level 1

Sales Receipts

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.

 

Thank you,

Deborah Bray

ReymondO
QuickBooks Team

Sales Receipts

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:

 

  1. Go to the Help icon and select QuickBooks Desktop Help.
  2. Click Contact Us.
  3. Write your concerns in the description box, then select Continue.
  4. Select which one of the support options you'd like to use.

 

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.

Need to get in touch?

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