How to make inventory reports

No more endless work to make stock reports in Excel. Apicbase lets you generate very detailed stock reports by the click of a button. Learn more about it in this support article.

To generate a stock report, click on the "Stock" button in the "Inventory" module. Select the outlet you want to generate a stock report for.

In Apicbase you can make three types of stock reports. Select the "Reports" button and you get a dropdown with the options:

1. Current state: a report of the current state of your stock will be downloaded. There are no stock changes shown in this report. This report shows per stock item:
   1. Stock item name
   2. Accounting category
   3. Supplier Article Number
   4. Current stock (qty): quantity
   5. Current stock (value)
   6. Par
   7. Difference with Par
   8. Minimum Stock
   9. Difference with minimum Stock
2. Over a period: between two dates.
   
   1. A popup will appear where you can select the two dates for the report.
   2. Press "Export" and the report will be generated in the "Exports" section of Apicbase.

1. 1. A popup will appear where you can select the two counts for the report.
   2. Press "Generate report" and the report will be generated in the reports section of Apicbase.

The reports 'over a period' or 'between two counts' contain the following information:

• Summary tab shows per accounting category:
  • Opening stock value
  • Closing stock value
  • Stock value variance
• Stock Report tab shows per stock item:
  
  • The accounting category
  • Opening stock
  • Closing stock
  • Stock difference
  • Opening stock value
  • Closing stock value
  • Stock value difference
• The detailed Stock Report tab shows per stock item:
  • Opening stock
  • Every action that increases stock
    • Ordered
    • Created in (sub recipe that was created and put in stock)
    • Moved in (stock item transferred from another outlet)
    • Sold
    • Uncontrolled gain (count): Gain by counting stock
  • Every action that decreases stock
    • Created Out (stock items used to create a sub recipe in stock)
    • Moved Out (stock items transferred to another outlet)
    • Shipped Out (internal order)
    • Wasted (Items that were registered as waste in the inventory module)
    • Uncontrolled Stock Count (Waste by doing a stock count)
    • Closing Stock
• The detailed Stock Value Report tab shows the same columns as the last, but for the stock value.
  • The accounting category
    • Opening Stock Value
    • Ordered
    • Created In (sub recipe that was created and put in stock)
    • Moved In (stock item transferred from another outlet)
    • Sold
    • Created Out (stock items used to create a sub recipe in stock)
    • Moved Out (stock items transferred to another outlet)
    • Shipped Out (internal order of the stock)
    • Wasted (Items that were registered as waste in the inventory module)
    • Uncontrolled Stock Count (Waste by doing a stock count)
    • Closing Stock Value