You’re offline. This is a read only version of the page.
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)
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
Share
Report
All responses (
Answers (
4
