Accounts Matching - General Ledger

Hi Razan,

matching AP/AR ledger accounts can become difficult if you imagine that you might have multiple rates on an invoice and to extend the scenario have multiple payments on these rates. On top you might also have different scenarios for a matching if it comes to Invoices in currencies other than the accounting currency .

Your eqivalent to the matching of lines in these accounts is in my opinion the AP/AR open item list or the customer/supplier trial balance which shows you the open amount on the detail level that you need.

The first possibility that comes to my mind when the balances might be different  is using Q-Vouchers on these accounts.

Kind regards

Ralph

Hi, 

I believe the GL account matching is best described as a reconciliation tool.   That’s very different from any matching we would do in AR or AP where we match payments to invoices (AR) or PO / Cost Matching in the supplier invoice process.  

The GL account matching can be used for many different use cases, that have nothing in common with AP and AR.  

AR and AP process is performed in the sub ledger at the invoice level.   

The GL matching process is 100% optional, allowing users to use this process in many different ways.   

By having the two functions as separate processes offer greater controls over the reconciliation process. 

Best regards, 

Thomas

Hi Thomas,

Thank you very much for your detail explanation for my query.

Best Regards

Razan 

Hi Ralph,

Thank you very much for the explanation for my query.

Best Regards

Razan 

Hello,
what transaction can I use to see only the open (unmatched) items on a standard GL account?

Hi, @Frank Himpe 

I think you should query GL voucher rows for specific account where matching id field is null.

Hi, 

If that was me… I would look to the open ledger items report.  This is a time sensitive report where open invoices / similar (POA) can be reported and then values reconciled to GL.  

Thomas, I don’t see the ‘open ledger items report’ in the menu. Can you be more precise?

Hi, 

See this… 

If you want to see this in a screen, you can utilize the balance history functionality. Community has details on this (I had answered a question)