27
Home/Modules/Reports & Analytics
Module — Analytics

Reports & Analytics

An ERP earns its keep in the review meeting. ambar 27 ships the cuts a textile business actually argues about — sales by design and by floor, stock age by supplier, margin after value addition, incentive by salesperson — so nobody has to build them in Excel the night before.

200+Report views across every module
30+Dimensions to slice sales by, from design to price band
SeparateReport access controlled independently of transaction rights
ExportableExcel and PDF from any report, plus scheduled auto-reporting

Sales, sliced every way a buyer thinks

Buying decisions in textile are made on dimensions generic ERPs do not carry. Which weave is turning? Which price band is dead? Which floor sells bridal and which sells daily wear? Every one of those is a built-in report, not a custom request.

  • By category, main category, sub category and detailed category
  • By design, image, size, whitetag and price range
  • By counter, floor, salesperson, user and warehouse
  • By customer, supplier, credit invoice and discount
  • By day, month, year, month-on-month and monthly trend
  • B2B sales, discount sales and voided sales as separate registers
Sales dimensions30+ cuts
By CategoryBy Main CategoryBy Detailed CategoryBy DesignBy ImageBy SizeBy WhitetagBy Price RangeBy CounterBy FloorBy SalespersonBy UsersBy WarehouseBy CustomerBy SupplierBy Credit InvoiceBy DiscountBy DayBy MonthBy YearBy InvoiceBy ItemsMonth-on-MonthMonthly Trend

Stock, margin and the truth about buying

Stock age tells you what your money is sitting in. Purchase-vs-sale tells you whether a supplier is worth the terms. Value-addition-vs-sales tells you whether the karigar work is paying for itself. These are the reports that change next season’s order.

  • Stock by category, supplier, warehouse, whitetag and image
  • Stock age analysis and stock conflict exceptions
  • Margin by design, category and supplier
  • Purchase-vs-sale and purchase by HSN
  • Value addition vs sales, overall and per supplier
  • Supplier performance, supplier statements and returns by image

Finance, compliance and people

The reports the accounts team, the CA and the owner each need — sitting behind their own access control, so the right person sees the right numbers and only those.

  • Daybook, multi-daybook, ageing and outstanding
  • Cashier summary, counter settlements and bank reconciliation status
  • GSTR-1, 3B summary, 2A register and 2B reconciliation
  • HSN registers for sale, sale return, purchase and purchase return
  • TDS deductee and payer statements, threshold tracker and utilisation
  • Attendance summary, payroll summary, PF/ESI register and incentive statements
Report familiesAccess-controlled
SalesStockPurchaseSupplierCustomerSalespersonsAdvancesAgeingBank StatementCashierCounter SettlementsDaybookDesignExpensesGSTGSTR1GSTR2AGSTR2BGSTR3BHRIncomeStocktakingTDSTDS ReceivableZari TestsAccess

Access control and scheduled delivery

Report access is a separate permission set from transaction rights, so a floor manager can see their floor’s sales without seeing margin, and an accountant can see the ledger without seeing payroll. Auto-reporting then pushes the agreed figures out on a schedule.

  • Report access configured per role, independent of module permissions
  • Channel scoping so branch users see only their branch’s figures
  • Report enquiry for ad-hoc filtered lookups
  • Excel and PDF export from any report view
  • Auto-reporting on a schedule, delivered without anyone running it
  • Report-access register showing exactly who can see what
DeliveryScreens
Report AccessReport EnquiryAuto ReportingExcel exportPDF exportChannel scopingBranch ReportsMulti Daybook
Everything in this module

The complete screen list.

Nothing here is a roadmap item. Every screen below ships in the product and is controlled by the same role permissions.

Sales

By CategoryBy DesignBy ImageBy SizeBy Price RangeBy CounterBy FloorBy SalespersonBy CustomerBy SupplierBy DiscountBy DayBy MonthBy YearMonth-on-MonthMonthly TrendSales By InvoiceDiscount SalesVoided Sales

Stock

Stock By CategoryStock By SupplierStock AgeStock ConflictBy WarehouseBy WhitetagBy ImageInventory LogStock TakingMargin

Purchase

Purchase v SalePurchase By HSNPurchase Returns By HSNSupplier PerformanceSupplier StatementSupplier — Report

Returns

Return RateReturned ItemsUnreturned ItemsReturns By ImageSale Returns By HSN

Finance

DaybookMulti DaybookAgeingAging ReportOutstandingAdvance OutstandingBank StatementCashier SummaryCounter SettlementsBranch Reports

GST & TDS

GSTR1 ReportGSTR-3B SummaryGSTR2A Purchase RegisterGSTR2B ReconciliationGST Trading SummaryQuarterly SummarySale By HSNDeductee StatementPayer StatementThreshold TrackerUtilisation

Customers

Customer Churn Risk ReportCustomer Growth RateCustomer Purchase FrequencyTop Customers by RevenueInactive CustomerCustomer Statement

People

Attendance SummaryPayroll SummaryPF / ESI RegisterEmployees ReportIncentive ReportIncentive StatementEmployee Ledger

Value addition

VS SalesVS Sales by SupplierValue Addition registerZari TestsZari Test Details

Access

Report AccessReport EnquiryAuto Reporting
Questions

Reports & Analytics, specifically

Can we build our own reports?

The library covers the standard cuts, and report enquiry handles ad-hoc filtered lookups. For anything genuinely bespoke to your business, new reports are added as part of the implementation or support engagement.

Can a floor manager see margin?

Only if you grant it. Report access is a separate permission layer, so sales visibility and margin visibility are independent decisions.

Do reports slow down when data grows?

Reports read from indexed tables and are paginated. Performance indexes are part of the schema migrations, and heavy MIS reports are period-scoped rather than unbounded.

Can reports be scheduled?

Yes. Auto-reporting sends configured reports on a schedule, so owners receive the daily and monthly figures without logging in to pull them.


Tell us the report you rebuild every month.

A 45-minute working session on your store data — your categories, your GST profile, your counters. No slideware.