[GNC] Need income and expense report for all customers with account breakout
Wm Tarr
wm at ilipsis.net
Tue Jul 28 11:51:11 EDT 2026
Are your customers just accounts or are they set up under
Business / Customer / New customer
If they are set up as Customers rather than accounts look under Reports
/ Business
Wm
On 2026-07-28 04:13, 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