AP Transaction Clearing Account Subledger

(0) Share

Report

Posted on by Community Member

I'm wondering if there is an existing report that could be used to reconcile the balance in the AP clearing account. This is the GL where purchase order lines are "received" into (accrued) when the physical item arrives at our facility and then "reversed" out of so that the invoice can be posted into the accounts payable GL. I need to reconcile this balance but am unable to find a report that details the activity.

If we have to write a custom report for this, then theoretically it's just a listing of all items "received" to date netted against all items "invoiced" to date - except we don't run all invoices through a purchase order, so some invoices don't actually affect this GL. Also we'd need a way to match up (and remove from the report) the invoice transactions with their corresponding receiving transaction so that the report only details items currently affecting this GL balance.

Anyone know if this report already exists??

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not aware of a standard report for reconciling this account. What might help you with your development is the Standard GL Journal function "select bridged transactions" that holds all the transactions posted on the clearing accounts used.

Hope it helps,

Ludwig

Was this reply helpful? Yes No