cancel
Showing results for 
Search instead for 
Did you mean: 
jenny-electrowel
Level 2

Looking for a report which shows bank transactions but each payment to have one line. If customer pays $2000 for 5 invoices, I only want to see that $2000 on the report.

I don't need it to list the individual amounts of all the invoices that one deposit is paying.
3 Comments 3
CharleneMaeF
QuickBooks Team

Looking for a report which shows bank transactions but each payment to have one line. If customer pays $2000 for 5 invoices, I only want to see that $2000 on the report.

We can pull up the Transaction Detail by Account report, jenny.

 

This way, we'll be able to view the deposits without seeing the individual amounts of all the invoice payments that are linked to them. I'll show you how.

 

  1. Go to Business overview and then select Reports, or go to Reports.
  2. Type Transaction Detail by Account in the Search bar, then click it.
  3. Select Switch to classic view.
  4. Click Customise.
  5. Enter the correct Report period.
  6. Under Filter, choose Deposit in the Transaction Type drop-down menu.
  7. Once done, click on Run report.

 

For more details about personalising your data, please see this article: Customise Reports in QuickBooks Online.

 

Moreover, you may want to consider memorising the report. Doing so helps you conveniently access the information in the future.

 

I'm here to help you if you need additional assistance running and customising reports in QuickBooks. Keep safe!

jenny-electrowel
Level 2

Looking for a report which shows bank transactions but each payment to have one line. If customer pays $2000 for 5 invoices, I only want to see that $2000 on the report.

Thankyou, when I generate the report i would like to see all sale receipts payments, invoice payments and deposits. It itemises the sales per line as is on the docket. Even though the customers receipt might have 6 line items, is it possible to just have one line total on the report for each transaction.

IntuitSheila
Level 8

Looking for a report which shows bank transactions but each payment to have one line. If customer pays $2000 for 5 invoices, I only want to see that $2000 on the report.

Thanks for getting back to us, jenny-electrowe!

 

I recommend running the Transaction List by Customer report to see invoices and payments for your customers. Here's how:

 

  1. Click on the Reports tab.
  2. On the search bar, type in Transaction list by Customer.
  3. Set a Report period, and also click Customise if you wanted to add Rows/Columns and Filters.
  4. Click on Run report.

Keep customising the report and save them by clicking on Save customisation.

 

Keep me posted if you have other QuickBooks concerns or questions. I'll get back to help you the best that I can.