Hoping for some guidance. I am not an accountant so take pity. Much thanks to any advice for helping a newbie. My AP clerk is running the Purchase Accrual By Period on the Purchase Accrual Account. She is also running the Account Details for the Purchase Accrual Account. If they are run over the same period lest say June of 2023, would the accounts tie out and balance or is there always going to be a variance. They have said in the past these tied/balanced but lately it its been off some periods more than others. So should they balance/tie out? If not, why wouldn’t they balance
Solved
Account Details For Purchase Accrual Account Does Not Balance to Purchase Accrual Balance by Period
Best answer by Laura02
Hello,
- Please run the Purchase Accrual Summary report in Purchasing module for all accounts. It’s possible that more than one Purchase Accrual account has been entered on the GL Accounts tab of Vendors and used to post the purchase accruals.
- Look at the activity in all of the Purchase Accrual Accounts in the GL Trial Balance report, to see whether activity on the Purchase Accrual Summary matches the Debits and Credits in the GL Trial Balance for a given period (as you described).
- Check the Release Batches screens in PO, AP, and IN modules to make sure every batch that updated PO, AP, and IN has been posted to the GL.
- Check GL Post Transactions Process to make sure every batch from AP and IN modules has been posted to GL.
- Use Account Details screen in Finance/GL module to make sure All transactions posted to your PO Accrual account originated in either PO, AP or IN. Click the Module column to filter: there should be no GL entries in PO Accruals account.
Please let us know what you find, and post some screen shots, please. We’ll help further based on what you find. Thank you!
Laura
+19Hello,
- Please run the Purchase Accrual Summary report in Purchasing module for all accounts. It’s possible that more than one Purchase Accrual account has been entered on the GL Accounts tab of Vendors and used to post the purchase accruals.
- Look at the activity in all of the Purchase Accrual Accounts in the GL Trial Balance report, to see whether activity on the Purchase Accrual Summary matches the Debits and Credits in the GL Trial Balance for a given period (as you described).
- Check the Release Batches screens in PO, AP, and IN modules to make sure every batch that updated PO, AP, and IN has been posted to the GL.
- Check GL Post Transactions Process to make sure every batch from AP and IN modules has been posted to GL.
- Use Account Details screen in Finance/GL module to make sure All transactions posted to your PO Accrual account originated in either PO, AP or IN. Click the Module column to filter: there should be no GL entries in PO Accruals account.
Please let us know what you find, and post some screen shots, please. We’ll help further based on what you find. Thank you!
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
By default The Purchase Accrual Balance by Period includes every single PO receipt that was an unbilled amount. In our system we have some PO Receipts that were never billed.
By default the same account in Account Details only shows the PO Receipts with a transaction date inside the period you are searching for.
In short I don’t think they’ll show the same balance. The former will show lots more.
thanks all there was no way to tell what caused the problem… our VAR showed us how to fix but we cant provide our data to Acumatica so researching more is not possible it why I think we are one of a very few that host our own Acumatica instance
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.