By using this website, you agree to our Terms of Use (click here)
Has anyone created a report that will tie to the balance in the GL account for Accrued Purchases? Ostensibly, the Purchase Accrual Detail Report should match the GL account, but it never has for a customer who went live on 09/01/17.
Hi Karen,
It's been a while since I've looked at this, but one thing I remember causing a problem is Purchase Orders that are closed manually after they have been received but not invoiced. You might look into that.
I created an Excel report when I looked at this a while back, but, to be honest with you, I don't remember if it was fully working.
But you're welcome to take a look at it and see if it helps you. I made it based on the GL data and backing into the PO Data (the opposite of what the Purchase Accrual Detail Report does).
To use it, you'll need this Generic Inquiry:
And you'll need this Excel file which requires Excel 2016 to work:
Purchase-Clearing-Reconciliation.xlsx
Thank you, Tim. I'll work on this sometime this week and I'll definitely provide feedback.
Hi Tim,
We went live too Sept 1., and will probably have the same issue once we start to close September's book. You are right, that is one of reasons why the account would not reconcile, because the vendor invoice created in AP nets against the credit recorded through the purchase receipt. However, I don't have access to Generic Inquiry and will need more guidance on using this tool, but I'm sure it will save us a lot of time.
It's a difficult account to reconcile unfortunately. The easiest thing to do is to keep it reconciled moving forward. One idea is to drop the GL Trial Balance amount on a dashboard right next to the total from the Purchase Receipt Accrual Summary report total. Then make that dashboard your homepage so you can glance at the two numbers side-by-side and make sure they are the same every time you login to Acumatica.
Hi Tim,
Thank you for the note, but I don't have access to dashboard as yet either. However, I will follow up because I believe we should have this.
Ah, ya, likely you might want your partner to help you build the Dashboard widgets anyways. Sometimes though the hardest thing is knowing what you'd want to ask them for.
Don't mean to hijack this, but I stumbled on this after searching for Reconciling Purchase Accruals with Acumatica GL while trying to help another user. The Purchase Accruals Summary report in Acumatica can't be run at a specific period making it difficult to reconcile with month-end balances. I'm going to address this in a YouTube live stream tomorrow, link here:
Wish me luck 😊