Custom Report - general ledger with line items

1

I’ve been trying to do this for a while now and getting nowhere - would really appreciate some help!

I’m trying to create a custom report that lists every single line item of the Cash Account transactions, and also shows the second account to which each line item connects. I just can’t seem to get that second account to show up. This is what I’m looking for:

Cash Account

Reference | Account | Description | Debit | Credit

Seems simple. Maybe I’m missing something here. Would really appreciate some help :slight_smile:

2

Here’s a start - try these parameters

image
image1138×741 96.8 KB

3

Thank you. I’ve just realised I’m using an outdated version of Manager, so thanks for your screenshot pointing me towards that!

However, this still doesn’t show the account the second account I’m looking for. To be clear I’m hoping to be able to show whether the transaction affects the cash or bank account, and then the expense or income account that it posts to.

4

The debit and credit transaction entries are two separate entries.

So you will need both and then sort and group by whatever reference you can