Hi there, BenTam.


QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.


You can run the Transaction List by Customer report to get the invoice numbers.


Here's how:

  1. Click Reports at the top.
  2. Select Customers & Receivables, and then choose Transaction List by Customer.
  3. On the Num column, you'll see all of the invoice numbers. You can open each transaction to see the payment numbers.
  4. To add or remove filters on the report, just click the Customize Report button in the upper left-hand corner.

You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.


You can always get back to me if you need anything else. Thanks for dropping by.

View solution in original post