Issues:
1: old POs were being billed in full when the company made a deposit instead of using vendor prepayment. ( this process has changed now). But the old process increased our AP balance for some P.O ( we haven’t received the items so we don’t really have a liability ) . Some of those bills were then paid in full, but we haven’t received the items, so they are really prepaid inventory.
2: some of the payments were not made from a bill or P.O, but instead they just issue a “check”
3: some bills were created not from PO ( stand-alone bills
4: at some point in the past , the company is not keeping track of P.Os and not using them consistently. So there are POs that they are not sure have received in full yet or not.
Each month we have to manually calculate the amount that need to reclass from accrued purchases to increase prepaid inventory and reduce AP to actual, then reverse it on the 1st day of the next period.
Does anyone have any recommendation on how to get to the bottom of this? How can I go about gathering all payments made to these vendors ( stand-alone and P.O. related) , all POs, all item receipts that tied to the POs, all bills that tied to the POs to determine how much we really prepaid to which POs , what is really open , what we really owe vs what we really received.
Any guidance is appreciated. Even little baby steps , ideas , reports to create .. thank you.