Balancing Open PO Accruals to the GL Account - Everything Else https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/ Acumatica User Group Forums en-US Wed, 14 Oct 2026 11:53:22 +0000 wpForo 60 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-8667 Tue, 27 Apr 2021 04:04:08 +0000 Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-8667 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-8666 Mon, 26 Apr 2021 21:51:54 +0000 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:

https://www.youtube.com/watch?v=z38Qronmrr0

Wish me luck šŸ˜Š

]]> Everything Else Gabriel Michaud https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-8666 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-687 Tue, 28 Nov 2017 10:36:31 +0000 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.

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-687 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-686 Tue, 28 Nov 2017 09:48:24 +0000 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.

]]> Everything Else Danita Nixon https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-686 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-685 Tue, 28 Nov 2017 02:48:52 +0000 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.

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-685 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-683 Mon, 27 Nov 2017 17:12:26 +0000 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.

]]> Everything Else Danita Nixon https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-683 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-679 Mon, 27 Nov 2017 04:36:11 +0000 Thank you, Tim. I'll work on this sometime this week and I'll definitely provide feedback.

]]> Everything Else KarenO https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-679 RE: Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-678 Mon, 27 Nov 2017 02:50:12 +0000 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:

Right-click to Download

And you'll need this Excel file which requires Excel 2016 to work:

Purchase-Clearing-Reconciliation.xlsx

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-678 Balancing Open PO Accruals to the GL Account https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-677 Sun, 26 Nov 2017 06:22:49 +0000 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.Ā 

]]> Everything Else KarenO https://www.augforums.com/forums/everything-else/balancing-open-po-accruals-to-the-gl-account/#post-677