Negative balances and backdated documents in local 1C

A warehouse cannot hold a negative quantity: nobody has minus 40 bolts on the shelf. When 1C shows one, the book is telling you that documents were posted in a different order from the one in which things happened. It pays to understand the signs before comparing a count with the book, because a negative line can produce a surplus or a shortage that does not exist in the warehouse.

How a negative balance arises

• Issue before receipt: the goods have already gone to production or a customer, but the receipt that brought them in has not been posted. Typical reasons are an invoice that has not arrived, a busy accountant or an unsigned document.
• Wrong item or unit: goods received under one code and issued under another, or received in boxes and issued in pieces.
• Issues with no document: goods taken without paperwork or paid for directly on site.
• Backdated documents: a document is entered today but carries a date in the past. It changes the balances on earlier dates, including dates that have already been reported.

For illustration, an item arrives on 3 March, 100 pieces, but the receipt is posted on 10 March. An issue of 40 on 5 March was posted on time. From 5 to 10 March the book shows -40. A count on 8 March finds 60 pieces on the shelf. The book says -40, so the difference looks like a surplus of 100. Once the receipt is posted, the book shows 60 and the difference disappears.

Reading the signs

Export a balance report by date and look for these:

• Items with a negative balance on the count date, and items that were negative at some point in recent months even if they are positive now.
• In a document list sorted by time of entry rather than by document date, documents entered long after their date.
• Receipts entered just after the cut-off but dated before it.
• Items with goods on the shelf but a zero balance, and items with a large balance but an empty shelf. These are the mirror image of negatives and usually have the same cause.

If many negatives disappear as soon as the receipt is posted, the problem is posting order; items that stay negative for long need a separate investigation. If your configuration records the time of entry or a change history, use it. If not, ask the accountant to show who posted what and when.

Clean up before comparing

1. Export the book balance as of the cut-off and keep the file with its time of export.
2. The accountant does the posting; the counting team receives the list. Ask for pending documents that belong before the cut-off to be posted with their true dates, and keep a list of them. Do not invent receipts just to remove a negative.
3. Trace each remaining negative to its cause: a missing receipt, a code or unit error, or an issue with no document.
4. Keep two columns: the book as exported and the book after clean-up. The count is compared with the second, but the first stays as a reference, so that anyone can later trace which figure changed and how.
5. Agree that no backdated documents are entered for the counted period without notice. Periods that are already closed stay closed.
6. Negatives that remain after the clean-up are marked separately from the count result and handled apart from the variance list until their cause is confirmed.

Do not "adjust to zero"

Entering an adjusting receipt to turn -40 into 0 hides the real cause. When the genuine receipt is posted later, stock becomes 40 too high and a new false surplus appears. Make this clear to whoever keeps the records.

Summary

A negative balance is a problem of posting order, not of the warehouse. Clean the book first, compare afterwards, and the count reads correctly. Smart Inventory matches count results with data exported from 1C or Excel item by item and sorts differences by cause: entry errors, timing gaps and genuine shortages.