Skip to main content
Answer

Month end inventory valuation reports to GL rec

  • May 26, 2022
  • 3 replies
  • 496 views

Any ideas on where to look first to reconcile end of month inventory to GL balance?

Best answer by bryanb39

I like to pull up Account Details for the inventory accounts and filter to show the GL Module.  That’s usually how much it’s off.  If there are no GL Journal Entries and it somehow got out of balance, you may just have to recalculate the inventory value.

It should always stay in balance if no manual Journal Entries are created.  

But like RoyceLithgo said, the Inventory Valuation Report will give you the Subledger totals to see if they match the GL. 

3 replies

Forum|alt.badge.img+3

Inventory Valuation Report?


bryanb39
Pro II
Forum|alt.badge.img+6
  • Pro II
  • Answer
  • May 28, 2022

I like to pull up Account Details for the inventory accounts and filter to show the GL Module.  That’s usually how much it’s off.  If there are no GL Journal Entries and it somehow got out of balance, you may just have to recalculate the inventory value.

It should always stay in balance if no manual Journal Entries are created.  

But like RoyceLithgo said, the Inventory Valuation Report will give you the Subledger totals to see if they match the GL. 


Forum|alt.badge.img+12
  • Acumatica Support Team
  • May 30, 2022

Hi @kbedillion08 

Adding to the above, detailed reconciliation process has been explained on following help documentation page. 

Acumatica

Hope this helps,

Regards,