Historical inventory balance reporting is used to create snapshots of the inventory balance at a particular time. A user can perform an inventory reconciliation at an accounting month end by comparing the trial balance value to the historical inventory detail for the particular month desired. 

To create historical inventory balances for a month end, perform the following steps:
  1. Navigate to the Inventory Balance Tab.
  2. Create a list view of the balances your would like to create historical values for. Select the balances list view.
  3. Click the "Create Inventory History" button and select the date you would like to create balances for.
  4. See the related inventory history record on the inventory balance or run a report on the inventory history records for the day you would like.
Reconcile Inventory Balances to the General Ledger
To reconcile inventory balances to the general ledger. Perform these steps: 
1. Create historical inventory balances for the last day of the accounting period to be reconciled.
2. Compare quantity available times unit cost to the value recorded in the general ledger.
3. Book a journal entry to the inventory GL account for any differences in value.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

5 Comments

  • 0
    Avatar
    Rebecca Ralls

    Feature Request: Automatic Creation of Inventory Balance History Records on Period close: https://accountingseed.zendesk.com/hc/en-us/community/posts/115001183887-Automatic-Inventory-History-Records-on-Period-Close

  • 0
    Avatar
    Jeanae Remala

    We have noticed that we are unable to make positive inventory adjustments for a product that has a Zero quantity on it.  Sometimes when doing a fiscal count, an inventory item is found that maybe was written off or miscounted in the past, now taking the quantity value from 0 to 1.  I do understand that your shouldn't be able to make negative inventory adjustments to zero balance products, but positive adjustments are needed.

  • 0
    Avatar
    Ryan Faulkingham

    Hi Jeanae,

    Try taking a look at this article about inventory adjustments and let me know if you have any other questions. Please direct these questions to our support desk.

    https://accountingseed.zendesk.com/hc/en-us/articles/217469477-Inventory-Adjustments

  • 0
    Avatar
    Rebecca Ralls

    Issue: The formula field on inventory balance history records that calculates available quantity as of the date of the IBHistory records is set to 2 decimal places - but inventory is stored at 6 decimal places, and indeed, all the fields on the IBHistory record are also stored at 6 decimal places.  It seems like the standard field on this object should also be set to 6 decimal places, and if some customer needs it set to 2 instead they could add a custom formula field to limit it.

  • 0
    Avatar
    Ryan Faulkingham

    Hi Rebecca, thank you for the insight on this. I will submit a ticket to our product improvement team. 

Please sign in to leave a comment.