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.

APICBASE STOCK REPORT

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

APICBASE STOCK REPORT 2

  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 "Reports" section of APICBASE.

APICBASE STOCK REPORT 3

3. Between two counts
    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.

APICBASE STOCK REPORT 5

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 variation
    • Opening stock value
    • Closing stock value
    • Stock value variation
  • 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)
      • 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)
      • Wasted: Items that were registered as waste in the inventory module
      • Uncontrolled waste (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.

ideaYou can find the "Exports" section of APICBASE by clicking the Schermafbeelding 2019-08-27 om 15.21.06 button and selecting "Exports". There you can find all the exports that have been made in your APICBASE library.