Skip to main content
M
Mr_wright4
March 25, 2024
Question

Bank transactions report by customers

  • March 25, 2024
  • 1 reply
  • 0 views

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 reply

MorganB
MorganB
March 25, 2024

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.

Terms & ConditionsAccessibility statement