Billing software with inventory: what to check so stock and accounts agree

Short answer: billing software with inventory should reduce stock when you sell, increase it when you buy, handle returns in both directions, value stock consistently and tell you why a number changed. The key design check is whether every change to stock is recorded as a movement that you can trace, rather than a total someone can overwrite.

Why do stock and billing drift apart?

The common cause is that billing and stock are two separate things that someone has to keep in sync by hand. A sale is entered but stock is not reduced. A purchase is received but not recorded. A return is refunded as money without putting the item back. Over months the system says you have 40 units and the shelf has 31.

What features keep them aligned?

• Every document moves stock automatically: sales invoice out, purchase bill in, credit note in, debit note out, adjustment, transfer.
• A movement ledger: each change is a record with who, when, why and quantity. Totals are derived from it. That is the model I use in Rechvix, described in stock balances belong in application code.
• Transactions: the invoice, the stock movement and the accounting entries are saved together or not at all. Otherwise a crash halfway leaves them disagreeing.
• Locking: two cashiers selling the last unit at the same time must not both succeed.
• Stock count and adjustment with a reason code and approval.

Which valuation method do you need?

• Weighted average cost: each receipt updates the average cost. Simple and common.
• FIFO: the oldest stock is assumed sold first. More accurate for items with price swings or expiry.
• Standard cost: a fixed cost reviewed periodically, used in manufacturing.

Valuation determines your cost of goods sold and therefore profit. Ask which methods the product supports, and whether you can see the valuation by date.

What about batches, serial numbers and expiry?

If you sell medicine, food, cosmetics or electronics, quantity alone is not enough. Batches with expiry dates let you sell the oldest first and withdraw a recalled lot. Serial numbers track individual items for warranty. Pharmacies in particular need this, as in the KinetiRx case study.

Other things to check

• Multiple warehouses or shops and transfers between them, in transit.
• Units of measure with conversions, like boxes and pieces.
• Variants such as size and colour.
• Negative stock: can the system sell what it does not think it has? You may want it allowed with a warning, because receipts are often entered late.
• Reorder levels and low-stock reports.
• Bundles and kits.
• Barcode support for scanning at billing and at stock count.

How do you test for mismatches?

• Load ten products with opening stock. Make sales, purchases, returns and a transfer. Do a stock count and compare with the system.
• Cancel an invoice and confirm stock returns.
• Edit a purchase price after sales and see how valuation changes.
• Sell the last unit from two screens at once.
• Ask for the movement history of one product and check it tells a complete story.
• Check that the accounting stock value in the balance sheet equals the stock valuation report.

The last check is the one that proves billing, inventory and accounts are really connected. If the product cannot show you that the two numbers match, treat it as three separate tools with one login.