Skip to main content

Adjusting Inventory Balances

Learn how to adjust an items balance on hand. This can be from an item expiring to monthly inventory counts.

Angel Horowitz avatar
Written by Angel Horowitz
Updated over 2 weeks ago

📝 Overview

If you track inventory by lot number, start by verifying that each individual purchase balance is accurate. After completing a physical count, navigate to the inventory item and adjust the purchase balances so they align with each lot number. If you don’t track lot numbers, you can make a single adjustment to the item’s Current Balance instead. The steps below explain how to complete both methods.


✍️ How to Record an Adjustment on a Purchase (Specific to Lot Number)

It’s important to record adjustments at the purchase (lot number) level to ensure the correct quantities are deducted from the specific lot. When an adjustment is made on a purchase, it also automatically adjusts the item's Overall Balance.

Click the arrow to learn how to make purchase adjustments

  1. Click on Inventory

  2. Search for the applicable inventory item

  3. Click on Purchases and select View Purchases

  4. Click on the gear icon for the purchase you wish to adjust, and select Adjust Balance

  5. Complete the form that appears, and click Save

💡 Once lot number balances are accurate, the next step is to adjust the top level balance to equal the sum of the purchase balances, or to just adjust the balance to match what is on hand if there are no purchases recorded.


🌎 How to Record an Overall Adjustment

After adjusting the purchase balances, you may need to make an overall balance adjustment. Add up the purchase quantities, and if the total doesn’t match the item’s Current Balance, perform an overall adjustment to correct it.

Click the arrow to learn how to do an overall adjustment

  1. Click on Inventory

  2. Search for the applicable inventory item

  3. Click on Adjustments and select New Adjustment

  4. Complete the form that appears, and click Save

💡 An adjustment records the actual balance on hand. The system automatically deducts from the items balance, based on the purchases entered (if purchase history exists). The configuration Inventory Shelf Management in Configurations of Settings is how you set the way you need to system to pull out stock, based on the expiration date.


❓Frequently Asked Questions (FAQs)

Find answers to common questions or additional details that may not be covered in the main instructions.

Click the arrow to view frequently asked questions

Why is it important to adjust at the purchase level first?

Click the arrow to see the answer

This helps maintain accurate inventory tracking. For example, if you lose five tablets from a bottle, first adjust the specific purchase (lot number). When the purchase balance is updated, the overall balance automatically adjusts as well.

When would I do an adjustment from the adjustments tab vs the purchase tab?

Click the arrow to see the answer

Once you’ve verified that the purchase balances are correct but they don’t match the overall balance, create a new adjustment from the Adjustments tab.

Did this answer your question?