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

[Jediator]

A/R only tracks customer invoices with income accounts, not expense 
bills, whose transactions would appear on A/P instead.  You might be 
able to add an expense split on an invoice, but without some 
transaction-level remarks for filtering, you still can't itemize income 
and expense at the detailed level.  Again, unlike QB or other tools, GC 
doesn't have the mechanism to track customers/vendors at the transaction 
level, only at the invoice and bill level.

If you want your report to list customers vertically instead of 
horizontally as you initially thought, you may want to enter customer id 
or info in a user-configurable field in a transaction (e.g., number, 
memo, notes, or description) and use filtering/sorting to group 
customers.  For instance, use the number field in a transaction to 
indicate customer name/ID, and select number as the 1st level sorting 
and account as the second level sorting in transaction reports 
(essentially doing a group-by on customers followed by accounts in a 
database search on transactions).  This should work fine as long as you 
keep your naming convention consistent, and there is no need to create 
time-consuming invoices or bills to track customers/vendors...

On 7/29/26 11:03 PM, Neil Aggarwal wrote:
>> That *should* get you a report that summarizes the A/R transactions,
> aggregated
>
>> by Customer first, then each line-item detail linked account as a total
> for the
>
>> period under them
>
>
> I think I followed your steps and this is the report I get back:
>
>
>
>
>
> I am not seeing the breakout of the late fees, interest, principal,
> and escrow collected.
>
>
>
> Did I miss something?
>
>
>
> 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.