AdoxERP Logo

Using reports

Run, filter, and export every Sales, Purchase, Inventory, and Accounts report in Web Admin.

Reports live under Reports in the left menu, grouped as Sales, Purchases, Inventory, and Accounts. Which reports you see depends on your role and company settings.


How to run a report

  1. Open Reports and choose a report
  2. Set filters — typically date range, location, branch, and (where relevant) customer, supplier, product, or user
  3. Apply or submit the filters to load results
  4. Export to Excel or PDF when the toolbar offers it
ℹ️

Many reports stay empty until you apply dates and click submit. Choose the same branch you used for the transactions you want to see.


Sales reports

ReportWhereUse it for
Sales SummaryReports > Sales > Sales SummaryPeriod sales totals
Sale DetailsReports > Sales > Sale DetailsLine-level sale transactions
Transactions ExportReports > Sales > Transactions ExportExporting sale transactions
Invoice TransactionReports > Sales > Invoice TransactionInvoice-level listing
Category SalesReports > Sales > Category SalesSales by product category
Payment SummaryReports > Sales > Payment SummaryPayments collected
Payment Method ReportReports > Sales > Payment Method ReportBreakdown by payment method
Sales Summary ReportReports > Sales > Sales Summary ReportAdditional sales summary view
Sales Type SummaryReports > Sales > Sales Type SummaryTotals by sales type
Tips ReportReports > Sales > Tips ReportTips (typically POS)
Cancel Order ReportReports > Sales > Cancel Order ReportCancelled orders
Complimentary ReportReports > Sales > Complimentary ReportComplimentary items
Delivery Note ReportReports > Sales > Delivery Note ReportDelivery notes
Product Wise SalesReports > Sales > Product Wise SalesSales by product
Item Wise SalesReports > Sales > Item Wise SalesSales by item
Sales Person SummaryReports > Sales > Sales Person SummaryTotals by salesperson
Sales Order DO PendingReports > Sales > Sales Order DO PendingOrders still waiting for delivery
Sales Person Commission DetailsReports > Sales > Sales Person Commission DetailsCommission by salesperson
Void Summary ReportReports > Sales > Void Summary ReportVoided sales
Target Vs SalesReports > Sales > Target Vs SalesTargets compared with actual sales
Sales ForecastReports > Sales > Sales ForecastForward-looking sales
Hourly SalesReports > Sales > Hourly SalesSales by hour of day
Sales Order ReportReports > Sales > Sales Order ReportSale order listing
Day Summary ReportReports > Sales > Day Summary ReportDay-wise sales summary

Purchase reports

ReportWhereUse it for
Purchase SummaryReports > Purchases > Purchase SummaryPeriod purchase totals
Purchase DetailsReports > Purchases > Purchase DetailsLine-level purchases
Purchases ReportReports > Purchases > Purchases ReportPurchase listing
Purchase Order ReportReports > Purchases > Purchase Order ReportPurchase orders
Purchase Order DetailsReports > Purchases > Purchase Order DetailsPO line detail
GRN ReportReports > Purchases > GRN ReportGoods received
Stock ForecastReports > Purchases > Stock ForecastExpected stock from purchasing

Inventory reports

ReportWhereUse it for
Item Wise Stock ReportReports > Inventory > Item Wise Stock ReportOn-hand stock by item
Periodic Stock ReportReports > Inventory > Periodic Stock ReportStock over a period
Stock Movement ReportReports > Inventory > Stock Movement ReportIn and out movements
Item History ReportReports > Inventory > Item History ReportHistory for an item
Item History With ProductReports > Inventory > Item History With ProductHistory including product detail
Brand Wise Stock MovementReports > Inventory > Brand Wise Stock MovementMovement by brand
Customer Wise Stock ReportReports > Inventory > Customer Wise Stock ReportStock related to customers
Stock Details Expiry DateReports > Inventory > Stock Details Expiry DateStock approaching expiry
Inventory Transfer ReportReports > Inventory > Inventory Transfer ReportStock transfers
Stock Adjustment Type ReportReports > Inventory > Stock Adjustment Type ReportStock adjustments
Item Wise Stock MovementReports > Inventory > Item Wise Stock MovementMovement by item
Stock Summary ReportReports > Inventory > Stock Summary ReportStock totals
Delivery Note ReportReports > Inventory > Delivery Note ReportDelivery notes from an inventory view

Live on-hand quantities are also on Products > Product Stock. See Viewing product stock.


Accounts reports

ReportWhereUse it for
Profit & LossReports > Accounts > Profit & LossIncome and expenses for a period
General LedgerReports > Accounts > General LedgerAccount-wise ledger
Trial BalanceReports > Accounts > Trial BalanceDebit/credit totals by account
Balance SheetReports > Accounts > Balance SheetAssets, liabilities, and equity
Account PayableReports > Accounts > Account PayableAmounts owed to suppliers
Account ReceivableReports > Accounts > Account ReceivableAmounts owed by customers
Statement of AccountReports > Accounts > Statement of AccountStatement for a customer or supplier
Day BookReports > Accounts > Day BookDaily accounting activity
Day Book DetailedReports > Accounts > Day Book DetailedLine-level day book
Cash in HandReports > Accounts > Cash in HandCash balances
Cash at BankReports > Accounts > Cash at BankBank balances

What to do next