Products & pricing

Stock costingNew

Choose moving average or FIFO for the whole company, and see what happens if you switch.

All guides

  1. Open Products / Services and click the Settings tab.
  2. Under Stock costing, choose Moving average or FIFO. Confirm the change. Cancel leaves the current method selected.
  3. Read more with an example, under the option, opens the worked dates for that method, for a sale below zero, and for switching.
  4. Allow negative stock on invoices is on the same Settings tab. When it is off, a sale that would take quantity below zero is refused. When it is on, the sale keeps a cost for the units that were not on the shelf. Read more with an example, under that tick box, shows both methods.
  5. Read the Switching note. Sales, credit notes, and returns already saved keep their cost. Only stock still on hand converts.
  6. Click Save settings. Saving the method that is already on does not convert stock.

Moving average

Each purchase is blended into the stock still on the shelf at that branch. A sale uses the average at that moment and keeps that cost. A purchase entered later does not change it. Selling does not change the average.

FIFO

Each purchase stays as its own batch. A sale takes the oldest batch first and keeps that cost. A purchase entered later does not change a sale already saved.

Negative stock

With Allow negative stock on invoices on, or the till Allow negative stock on for a till sale, quantity can go below zero. Moving average uses the current average for the whole sale, then blends the negative quantity into the next purchase. FIFO costs the extra units at the last available FIFO cost, and only stock above zero becomes a batch when you buy again. A sale already posted is not rewritten.

Document date

The document date sets the inventory journal date. The cost is worked out from the stock on hand when you post the bill. Previously posted sales are not recalculated. XZONO does not rebuild stock history from document dates.

Switching

  • Moving average to FIFO: stock still on hand becomes one batch per product per branch, at the current average. Later purchases are new batches.
  • FIFO to moving average: batches still open fold into one average.
  • Switching back to FIFO starts again from that one average. It does not bring back the earlier purchases.
  • It does not reconstruct the history. Only stock still on hand converts.

Voids and sales returns

  • Void reverses an invoice dated today. Stock comes back at the cost already saved on that invoice, and that cost of sales is reversed.
  • A sales return is a new document after the sale. It uses the cost captured on the original invoice. A credit note that puts stock back uses that same captured cost.

Cost of sales and stock value

Cost of sales is fixed when the sale is posted. Stock value is the stock still on hand, valued with the method currently in force. A later purchase, a method change, or a document dated earlier does not change a posted sale.