Inventory Reports

Monitor stock levels, track movements, identify best sellers, and manage expiry dates with detailed inventory reports.

Help Center / Core Features / Inventory Reports

Overview

RapiNova Accounts includes multiple inventory reports, each designed for a specific purpose. All reports are accessible from Reports in the left sidebar menu. Every report can be filtered by date range, business location, and product category.

All inventory reports support CSV and Excel export. Look for the Export buttons at the top of each report table.

Stock Report

Shows current stock levels for all products across your business locations. This is your go-to report for knowing how much of each item you have right now.

How to Access

  1. Navigate to Reports > Stock Report.
  2. Optionally filter by Location or Category.
  3. View the current quantity for each product and variation.
ColumnDescription
SKUProduct stock-keeping unit code
ProductProduct name and variation (if applicable)
LocationBusiness location where stock is held
Unit PriceDefault selling price per unit
Current StockQuantity currently available
Total Unit SoldTotal quantity sold to date
Total Unit TransferredQuantity moved to other locations
Total Unit AdjustedQuantity adjusted (damaged, lost, etc.)

Stock Details

Shows the full movement history of stock -- every purchase, sale, transfer, and adjustment that changed a product's quantity. Use this to trace exactly when and why stock levels changed.

  1. Go to Reports > Stock Details.
  2. Select a product or view all products.
  3. Filter by date range and location to narrow results.
This report is ideal for investigating stock discrepancies -- compare physical counts against the recorded movements.

Stock Expiry Report

Lists products that are nearing or have passed their expiry date. Essential for food, pharmaceutical, and perishable goods businesses.

  1. Go to Reports > Stock Expiry Report.
  2. Products nearing expiry appear highlighted for quick identification.
  3. Take action: discount, return to supplier, or write off expired items.
Expiry tracking only works for products where you entered expiry dates during purchase. Make sure to record expiry dates when adding stock.

Stock Adjustment Report

Shows all stock adjustments made -- including damage, loss, and manual corrections. Each adjustment includes the reason, quantity, and who made the change.

ColumnDescription
DateWhen the adjustment was made
Reference NoUnique adjustment reference number
LocationWhich location was affected
Adjustment TypeNormal (increase/decrease) or Abnormal
Total AmountMonetary value of the adjusted stock
ReasonWhy the adjustment was made

Lot Report

Tracks stock by lot (batch) number. If you assign lot numbers during purchase, this report shows how much of each lot remains and where it is located.

Lot tracking is useful for recall management, quality control, and FIFO (First In, First Out) inventory methods.

Product Purchase Report

Shows purchase history for products -- how much of each product was purchased, from which supplier, and at what cost. Filter by date, supplier, location, or category.

ColumnDescription
ProductProduct name and variation
SupplierSupplier who provided the product
Quantity PurchasedNumber of units bought
Total Purchase CostTotal amount paid for the purchase

Product Sell Report

Shows the sales history of products -- how many units of each product were sold, to whom, and the revenue generated. Filter by date, customer, location, or category.

Combine the Product Sell Report with the Product Purchase Report to calculate per-product profit margins.

Common Filters

All inventory reports share a common set of filters at the top of the page.

FilterDescriptionAvailable In
Date RangeStart and end date for the report periodAll reports
Business LocationFilter to a specific store or warehouseAll reports
CategoryFilter by product categoryStock, Trending, Purchase, Sell
Sub-CategoryFurther narrow by sub-categoryStock, Trending
BrandFilter by product brandStock Report
SupplierFilter by supplierPurchase Report
CustomerFilter by customerSell Report
Need help setting up inventory reports? Contact us on WhatsApp at +92 320 111 7487.