Negative product balances: causes and solutions

Negative stock balances are a state of goods in the accounting system when their quantity in stock is less than zero. This indicates a violation of accounting chronology or errors in product identification during operations.

When negative stock balances occur

This situation occurs when attempting to ship goods (sale, write-off, transfer) that are not available in the database as accessible stock at the time of the operation.

How to understand that there is a negative stock balance in accounting

• In the «Stock Status» form, the quantity of goods is displayed with a «minus» sign (for example, -5 pcs.).

• The program displays a warning: «Insufficient stock in warehouse» when processing a sale (if a strict prohibition on selling into negative stock is not enabled).

• Incorrect data in profit and cost price reports.

Why negative stock balances appear

1. Violation of document sequence: the goods were sold earlier than the «Goods Receipt Note» was entered.

2. Access settings: the option «Allow selling into negative stock» is enabled (Settings — Parameters — Accounting).

3. Misgrading: sale of one product instead of another due to similarity or a scanning error.

4. Adjustments to past periods: deletion or editing of goods receipt notes for which sales have already taken place.

How to correct negative stock balances

Method 1: Inventory sheet (Recommended)

Used to bring the program data into line with the actual stock on hand.

1. Go to Document — Inventory Sheet.

2. Create a sheet by adding products with a negative balance (use the «Only with negative quantity» filter).

3. Enter the actual quantity (if the product is physically unavailable — «0»).

4. Close the sheet. The system will automatically create an «Inventory Receipt» to cover the negative balance.

Method 2: Restore the receipt chronology

Used if the goods were actually received, but the goods receipt note was not entered.

1. Create a Goods Receipt Note.

2. Set the document date to precede the first sale «into negative stock».

3. Add the product and post the note.

Method 3: Correct misgrading

Used if a surplus of one item and a shortage of another are detected.

1. Create an inventory sheet by adding both products.

2. Enter the actual balances. The program will balance the warehouse through write-off and receipt acts.

How to verify that negative stock balances have been eliminated

Open Warehouse — Stock Status, apply the «Only with negative quantity» filter. The list should be empty.

How to prevent negative stock balances

1. Set a prohibition. Settings — Parameters — Accounting → «What to do if there is insufficient stock when selling» → Prohibit.

2. Follow the rule: first receipt into the program — then sale.

3. Regularly reconcile stock balances for problematic product groups.

4. In Warehouse — Stock Status, when you notice a discrepancy in stock balances, recalculate the product quantity using the “Recalculate quantity” button. This is especially relevant for databases with high товарообіг (grocery stores, household goods stores with small items, etc.).

 What is important to remember

Negative stock balances distort the financial result. After any correction of stock balances, be sure to perform: Analysis — Period — Cost price recalculation.