Skip to main content
June 7, 2024
Question

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

  • June 7, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 7, 2024

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!