cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
aircrest-manx-ne
Level 1

How do I get monthly report of total invoice receipts into bank account ?

 
1 REPLY 1
LollyNino_C
QuickBooks Team

How do I get monthly report of total invoice receipts into bank account ?

Thanks for visiting here for today, aircrest.

 

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:

 

  1. Go to the Reports
  2. Find and open the Transaction Detail by Account report.
  3. Set the correct date range.
  4. Click the Customise button.
  5. In the Row/Columns section, put a checkmark on Split.
  6. On the Filter section, click the dropdown and mark the Payment on the Transaction Type.
  7. Once done, hit the Run report.

 

For visual reference, please refer to the following screenshots.

 

 

Then set the report period All dates use the Group by field and select Month. This will help you to the right direction.

 

 

For more details about personalizing reports, please see this article: Customise Reports in QuickBooks Online.

 

Additionally, I've included these articles that'll help learn more about running and memorising reports in QuickBooks:

 

 

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 to get in touch?

Contact us