- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage your account
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.
- Go to Business overview and then select Reports, or go to Reports.
- Type Transaction Detail by Account in the Search bar, then click it.
- Select Switch to classic view.
- Click Customise.
- Enter the correct Report period.
- Under Filter, choose Deposit in the Transaction Type drop-down menu.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage your account
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage your account
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:
- Click on the Reports tab.
- On the search bar, type in Transaction list by Customer.
- Set a Report period, and also click Customise if you wanted to add Rows/Columns and Filters.
- 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.