Accrued Expenses Account Keeps Growing

I usually do not deal with the financial side of Epicor but giving this my best shot.

Our “Accrued Manufacturing Expense” GL account keeps growing since our go live date. It is not consistent, some months it decreases and some months it will increase. We have ended up with a credit value of over $200k until someone noticed. I have combed through the account and the only thing that goes in there are actual accrued expenses. At receipt of goods we get a debit value, when entering the invoice we get a credit. We have no unpaid invoices, and everything received has been paid. So somehow we have overstated our Accrued mfg expense?

Does anyone have any experience with this and how to figure out what exactly has happened?

It looks like you are referring to Good Received Not Invoiced/AP Clearing account. This account get credited during PO receipt and debited on invoice. Run Received Not Invoiced report under Accounts Payable -> Reports and check the value. Ideally report value should match with the GL account.

I have run that report and unfortunately they do not tie up. Balance sheet is still over 200k where the rec. not invoiced report states 13k.

Run the INV/WIP Recon report, for the GL acct in question, with the “Include Offset Accounts” option selected.

I’d set the date range to the beginning of time (when you went live).

At the end of the report you’ll see all the transactions that went to this GL acct, including the offsetting trans.

image

In my example (which is of a Test Company, and not since the beginning of time) , there are about $33K more credits than debits to our Accrued Receivings acct (which is poorly named)

edit

Then run the GL Acct report for that acct. You shouldn’t see anything other than “Periodic Posting Process” entries. (might have to do this several times to span multiple Fiscal Years

edit #2

I incorrectly stated that you won’t see anything other than “Periodic Posting Process” entries. That was incorrect. You should see all the AP Inv entries too.

In the GL report search for “GJ” (for General Journal) to find any manually entered entries (JE’s)

Write a BAQ on GLJrnDtl to get transaction details for that account and find from which module the transactions originates.