You can easily pull up and customise the Transaction Detail by Account report. Doing so will help us view the list of all the total invoice payments on each bank account. However, it includes all the payments deposited. To identify if it's an invoice payment, you can check the Split column with Accounts Receivable.
Let me show you how:
Go to the Reports.
Find and open the Transaction Detail by Account report.
Set the correct date range.
Click the Customise button.
In the Row/Columns section, put a checkmark on Split.
On the Filter section, click the dropdown and mark the Payment on the Transaction Type.
Once done, hit the Run report.
For visual reference, please refer to the following screenshots.
Then set the report periodAll dates use the Group by field and select Month. This will help you to the right direction.
If you need further assistance in reports in QuickBooks Online. Let me know by leaving a comment below. Wishing you and your business continued success. Have a great day!
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.