Inventory Adjustments

Inventory Adjustments

Inventory Adjustments

Sometimes it is necessary to adjust the quantities on hand or cost of an item.   Breakage, theft, loss or miscounting can cause the true quantity on hand to differ from what CustomBooks™ reports.  Adjusting inventory counts is a necessary part of doing business in a product company. We’ve made it easy with our Inventory Adjustments document.

Creating a Single Inventory Adjustments

Idea
  1. Navigate to Inventory → Inventory Adjustments.
  2. Click Create → Single Item.
  3. Change the date if necessary.
  4. Enter a number for the adjustment or allow the system to enter it for you. This auto numbering sequence may be changed by going to Admin Panel → Auto Numbering.
  5. Enter the item code to adjust. Once entered, the system will pre-fill the Cost of Goods Sold Account from the Item Card. This may be changed if necessary.
  6. Enter or change the location of the item you are adjusting.
  7. Enter Project and Class if necessary.
  8. Enter a quantity in either the Adjustment or New Quantity field. If you are entering the adjustment number for the item, use the Adjustment field. If entering a new inventory total for the item, use the New Quantity field. You may use a negative number in the adjustment field if you need to decrease the new total.
  9. Click Save to Save the Adjustment.
Creating a Single-item Inventory Adjustment

For a step-by-step walkthrough, check out the video below.
​
​
Idea
Note:  Click the overall quantities and valuation by item link to view inventory across all locations.

Multi-Item Inventory Adjustments

You can also create inventory adjustments for multiple items at the same location with the same date/account by using the multi-item inventory adjustment. This form allows you to add multiple items in rows.

Creating a Multi-item Inventory Adjustment

    Need help applying this to your business?

    See how CustomBooks™ can support your accounting and inventory workflow

    If you are evaluating CustomBooks™ or want help setting up workflows for your business, explore the product or schedule a conversation with our team.

    Already using CustomBooks™? Explore the Knowledge Base or contact support for product help.



      • Related Articles

      • Troubleshooting Inventory

        CustomBooks™ has a strict inventory control system meaning that if you don't have something in inventory, you cannot sell it. It's important to understand how the inventory system works in order to avoid situations that result in "Insufficient ...

      • Inventory Overview

        Inventory Anytime, anywhere inventory management in the cloud. Our advanced inventory system is capable of tracking multiple warehouses and comes complete with classes, projects, and user-defined, hierarchical location tracking that doesn’t stop at ...

      • Lots Adjustments

        In CustomBooks™, Lots Adjustments are used to correct or update the quantity, cost, or lot assignment of lot-tracked inventory items. This ensures accurate inventory tracking, compliance, and valuation. Viewing the List of Lots Adjustments To view ...

      • Inventory Layers; FIFO Costing Method and How to Resolve Out of Order Layers

        Inventory Layers in CustomBooks™ Overview In CustomBooks™, inventory layers are used to track the quantity and cost of items over time. These layers play a critical role in inventory valuation and sales postings, particularly when using the FIFO ...

      • How does CustomBooks™ help me manage my inventory?

        Where do we start? CustomBooks™ offers comprehensive TRUE inventory management capabilities, enabling users to remotely track inventory levels, orders, sales, returns, and deliveries at all times. This helps businesses streamline operations ...