Thanks AJD,
Great to get some other input on this. I appreciate the concrete example which was very similar to what I’d already tried.
Unfortunately, due to my use of the supplier/customer based invoicing feature (which works through the A/P and A/R accounts as an intermediary account), the cash transactions are grouped against A/P and A/R accounts and not the expense and income accounts that the invoices refer to.
As an example, I’ve created a test company with the only transactions being that of my previous example. One invoice generated on 01/01/2019, and one payment against that invoice on 01/01/2020.
Here is a custom report with the fields as noted, grouped by account:
You can see how no single line contains both the cash transaction date (01/01/2020), and the appropriate account (Accounting Fees).
Further, I have not identified any report column I can include in the report that would enable them to be tied together.
[Aside: I am confused as to why Manager double-transacted on 01/01/2020 though… there is only one receipt in the entire file.]