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)

 

4 Comments
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.

 

 

 

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