Negative balances in 1C: why they appear and how to clear them

When an item's balance in 1C falls below zero, the system either warns or, depending on its configuration, accepts it silently. Because there cannot be minus goods on a shelf, many managers read it as a "loss". But a negative balance more often shows that the document order was broken than that something is genuinely missing: the issue was posted first and the receipt later. Clearing negative balances before the count makes both the count result and the variance table meaningful.

Whether negative balances are allowed depends on a system setting, and changing it is an accounting and system decision; talk to whoever looks after 1C and to your accountant.

Why does a negative balance arise?

1. Document order: a sale or issue is posted before the purchase receipt. The goods were physically there; the record was completed afterwards.
2. Back-dating: a receipt is posted with a day later than the real one; the balance looks negative in the days between.
3. Wrong item: an issue is made under the code of a similar item; one goes down, the other goes up.
4. Unit error: kg on the receipt, metres on the issue; or cartons and m² mixed.
5. Receipt never posted: the goods entered the warehouse but the receipt was never written.
6. Genuine shortage: an issue without a record, damage or waste. This cause is left to last.

For goods issued during the negative period, costing may stay uncertain depending on the system's method, which is one reason accountants want negatives cleared before the period closes.

Finding and classifying

Export the item balance list from 1C to Excel and filter for those below zero. For each negative item pull the last ten or fifteen movements and find the first point of breakdown: with which document did the balance go negative, and with which did it recover? Also look for matching pairs; if one item shows −120 metres and a similar colour shows +120 metres, it is most likely a wrong item.

An illustrative case: on Monday a 200 m issue is posted for a fabric and the balance becomes −200. The purchase receipt of 500 m is posted on Wednesday, so the balance returns to +300. In fact the goods had arrived the previous Friday. If the receipt is re-dated to the real arrival, the negative period never occurs.

Example: 40 negative items

An illustrative pre-count list holds 40 negative items. After review the breakdown is:

• document order: 18;
• wrong item (6 pairs): 12;
• unit error: 6;
• duplicate record: 3;
• genuine shortage: 1.

18 + 12 + 6 + 3 + 1 = 40. Only one of the 40 negative lines might be a real shortage; the rest result from document and item-list arrangements. Producing this table before the count means ruling out 39 lines of false variance in advance.

How to clear them

• Document order: the document date is corrected to the real movement; touching a closed period is done on the accountant's decision.
• Wrong item: a reclassification document between items is posted.
• Unit error: the conversion on the item card is corrected and the faulty movement posted again.
• Duplicate record: put on the merge list.
• Genuine shortage: written into the variance table with its evidence and kept open until the cause is known.

The road to avoid is writing a fake receipt to bring the negative to zero. It inflates stock value and cost and deletes the source of the problem from the record; the problem comes back in another guise at the next count.

Keeping it up

Take a negative balance report once a week. New negatives usually close within a few days when the document order is fixed; those that do not point to a real problem. If the storekeeper and the accountant read the report together, "who made the mistake" turns into "why was the document posted late".

In short

Most negative balances close with document order; clearing them before the count lets the count concentrate on genuine shortages. StockSystem places the counted quantity next to the balance in 1C, Excel or your ERP, sorts differences into unposted slips, wrong items and genuine shortages, and prepares a correction list in your system's import layout.