Skip to main content
July 26, 2023
Question

I need to see a list of payments recieved from a customer and the invoice each one was reconsiled against

  • July 26, 2023
  • 1 reply
  • 0 views
I need to see a list of payments recieved from a customer and the invoice each one was reconciled against

1 reply

July 26, 2023

Hello, accounts-gateway. 

 

Thank you for contacting the Community. I am here to assist you with checking the payments received from a customer, and the invoice each one was reconciled in QuickBooks Online. To complete this task, we will generate two separate reports, the Transaction List by Customer and the Reconciliation Report. We can obtain the necessary data by customizing the Filter to invoice and payment in the transaction list report. Once we have both reports, we will export them and compare the data to ensure accuracy.  

 

Here's how to run the two different reports: 

 

  1. Click Reports, and in the search field, enter Transaction List by Customer.  
  2. Tap Customize, and under Filter, dropdown the Transactions Type and mark check the Invoice and Payment. 
  3. Under Customer, select the Customer you want to see the list of payments. 
  4. Once done, click Run Report.  

 

 

 

For the Reconciliation report, Here's how: 

 

  1. Click Reports, and in the search field, enter Reconciliation report. 
  2. Tap the View report. Then select the Account and Statement ending date

 

 

 

Once done, you can utilise the export feature, you can check this article for guidance on how to export them: Export your reports to Excel from QuickBooks Online.

 

If you require any further assistance, please don't hesitate to let us know. Have a great day!