Check stock with the Product Register
See opening, inward, outward and closing stock for every product, in quantity and value, and open the transactions behind any figure.
The Product Register is your stock report. For each product it shows the stock at the start of a period, what came in, what went out, and what is left at the end. Every figure is shown as a quantity and as a value.
Before you start
- Create your products and enter their opening stock.
- Stock moves only when you save a purchase, sales invoice, credit note, debit note, delivery challan or stock journal.
- The Godown: filter appears only when location-wise stock or Manufacturing is switched on. The Item type: filter appears only when Manufacturing is switched on. See Configuration.
Steps
- Open Registers > Product Register.
- The report opens for your current financial year. The four cards at the top show the totals for Opening, Inward, Outward and Closing.
- Click the Filters icon at the top right to change the period or pick one product.
- Change From and To to the dates you want. The report updates by itself.
- In Product, pick one product, or leave it empty to see All products.
- Type in Search product... to find a product by name. This box shows only when the list has more than five products.
- Click the Refresh icon to load the latest figures.
- Click a product name to see its transactions.
Read the report
Each product has four pairs of columns, each with Qty and Value.
- Opening is the stock on the day before From.
- Inward is everything that came in during the period: purchases, sales returns, opening stock entries and stock journal receipts.
- Outward is everything that went out: sales, purchase returns, challans and stock journal issues.
- Closing is Opening plus Inward minus Outward, as on the To date.
- The TOTAL row at the bottom adds up all products shown.
- A closing quantity in green means stock is in hand. Red means the stock has gone below zero. Grey means zero.
Stock is valued on FIFO (first in, first out). The Closing value is the same stock value used in the Balance Sheet and Profit & Loss. The Outward value is the cost of the goods that went out, not the selling price.
On a phone, each product is a card. Tap the arrow on the card to show its opening, inward, outward and closing figures. Tap the name to see its transactions.
See the transactions of one product
- Click the product name. The Product Transactions panel opens on the right.
- The chips at the top show Opening, In, Out and Closing for the period.
- Each row shows the Date, whether it is Inward or Outward, the party, the document type and number, Qty, Rate, Taxable Val. and the running Balance.
- Click the open icon at the end of a row to go to that document. A sale opens the invoice. A purchase opens the purchase for editing. Opening stock and stock journal rows open the stock journal. Credit notes, debit notes and challans open their list.
- Click Excel to download the transactions as an Excel file.
- Click Print / PDF to open a print view. Choose Save as PDF in the print window to keep a PDF.
- Click the close icon to go back to the register.
If there are no movements in the period, the panel says No transactions in this period. The opening figure is still carried forward from earlier periods.
See stock at one godown
This needs location-wise stock to be switched on.
- Click the Filters icon.
- Next to Godown:, click a godown name. Click All locations to see the whole business again.
- Click Unassigned to see stock movements that were saved without a godown.
When a godown is picked, the quantities are for that godown only. The value is the godown's quantity at the product's average cost for the whole business. Arthlekha costs stock FIFO for the business as a whole, not per godown. So the godown values add up to the business total, but one godown's value is not a Balance Sheet figure.
See raw materials and finished goods separately
When Manufacturing is switched on, the register is grouped into Raw material, Finished goods and Trading, each with its own Subtotal row. Click a chip next to Item type: to show only one group. Click All to see every group.
Common problems
- No data for selected period. — no product has opening stock or any movement in these dates. Check From and To, and clear the Product filter.
- Closing quantity is red (below zero) — more was sold or issued than was in stock. Check that the purchase or opening stock was entered, and with the right date. A purchase dated after the sale does not cover it.
- A product is missing from the list — a product appears only if it has opening stock or a movement up to the To date.
- Value looks too high or too low — check the rate on the opening stock entry and on purchases. Open the product's transactions to see the Rate of each entry.
- Pop-up blocked — allow pop-ups to print. — your browser stopped the print window. Allow pop-ups for Arthlekha and click Print / PDF again.