Account Combination map from general ledger

Hi Everyone,

Can anyone help me to get some sort of account pairing analysis from the generic nominal ledger. For example given below very simplified ledger:

To get a matrix like below:

Hey @umidjon,

I understand the general idea what you want to achieve but do not understand the system behind it (I missed the accounting class or maybe forgot most of it), but how you calculate the pairs within the matrix? Is the journal ID relevant here?

Best regards

1 Like

Hi @laaaarsi . Yes, Journal ID should be the unique reference to identify account combinations/pairs. If we ignore the amounts then using Journal ID as common identifier the second table would look like: