Skip to main content
Solved

Month end inventory valuation reports to GL rec

  • May 26, 2022
  • 3 replies
  • 484 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
  • Pro II
  • 76 replies
  • May 27, 2022

Inventory Valuation Report?


bryanb39
Pro II
Forum|alt.badge.img+6
  • Pro II
  • 179 replies
  • 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
  • 871 replies
  • 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,