Should the IWR Report for a material expense account tie out to the trial balance for the same year and period?

Not sure if I am making up a problem or if there actually is a problem.

I am trying to see which jobs impacted the debits and credits for a material expense account and when I run the inventory wip reconciliation report, the debits and credits for that account do not add up to the debits and credits posted to the account for that same year and period.

Am I going about this the right way or…?

I do not think you would be able to reconcile that way as Accounting can do manual postings or change the GL account on payment. You would only be able to reconcile that way if the GL account was somehow restricted to only accept postings from a job.

Right, but then wouldn’t you see a posting in the journal detail?

All I am seeing is periodic postings on the journal detail for the account I am looking at…

I see what was happening. Major facepalm…

Periodic postings post the ending debit or credit result whereas the IWR report posts all debits and credits.

-Utah