cancel
Showing results for 
Search instead for 
Did you mean: 
Mr_wright4
Level 1

Bank transactions report by customers

I own a real estate & construction company. We own 40+ rental properties plus we also build residential & commercial projects. I am trying to find out a way to run a report that shows all bank transactions grouped by the customer each month including any mortgage or financing cost. If I run the profit & loss report then sort by customer, it does not seem to including any of the monthly payments. Is this possible, if not is there a similar site that provides these types or reports?

1 Comment 1
MorganB
Content Leader

Bank transactions report by customers

Hi there, Mr_wright4.

 

Thanks for posting your question here in the Community. I want to make sure you're able to run the report you need in QuickBooks Online.

 

After reading over the details, I recommend trying the Profit and Loss by Month Report. This report will provide a breakdown of transactions for each month and you can then take it one step further by filtering for customers. Here's how:

 

1. After running the Profit and Loss by Month report, click the Customize button in the top right corner.

2. Scroll down to the Filter section and check the box for Customer.

3. You can select all of your customers or just a few.

4. Select Run report when you're finished.

 

The following article provides additional info about customizing reports in QuickBooks Online

 

With these steps you'll be able to view a report containing month-by-month transactions for each of your customers. Please feel free to reach back out if you have any other questions.

Need to get in touch?

Contact us