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
[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.
