I believe you can do this in two steps:  1) create an P&L report (under Income & Expense report menu) first for each customer by selecting relevant accounts and save the reports; 2) create a Multicolumn report by adding the individual customer reports from step 1 to this one (not sure what the limitations of how many columns you can make).

-- ND

On 7/27/26 11:13 PM, Neil Aggarwal wrote:
Hello all:



I am running a small mortgage company.



When a customer makes a payment, it may contain these items:

1. Interest

2. Principal

3. Escrow
4. Late fees

5. Reimbursement for attorney fees

6. Reimbursement bank charges

Etc.



I created a simple sample and recorded two payments from
fictitious customers.  Each payment had late fees, interest, and principal.



Here is the account listing:



At the end of the year, I will need a report which shows the breakout of
the payment
items total per customer.



For example, I need a table which looks like this:



                                              Customer 1         Customer 2

Interest Income                $                            $

Late Fees Collected          $                            $

Principal paid                    $                            $

Escrow Collected              $                            $



Is there a report which will give me this?



The Customer Summary gives me only the total paid by each customer, not the
breakout.



Thank you,

   Neil



--

Neil Aggarwal, (972) 834-1565, https://propfinancing.com

We offer 30 year loans on single family houses!


_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to