[GNC] Need income and expense report for all customers with account breakout

Jediator jediator at artemisspace.com
Tue Jul 28 09:48:38 EDT 2026


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
> gnucash-user at gnucash.org
> 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.



More information about the gnucash-user mailing list