Reports and insights

Understand sales, stock, payment reconciliation and financial performance across your retail business.

See how store and online orders turn into fulfilled purchases, available stock and cash. Retail & E-commerce ERP connects sales and operational reports with local financial results, with the underlying records available when a team needs to investigate a difference.

Sales by Channel and Store

Posted invoice net revenue and independently approved credit reductions by entity/channel/store/product at a stated posting cutoff, joined to accepted PurchaseContexts without inventing customer identity. Show booked orders, fulfilled-unbilled and recognized revenue as distinct populations. Margin uses matched title-issue/return cost for the same scope; zero revenue or unknown cost gives unavailable percentage. Document currencies stay separate unless a disclosed retained functional conversion is used.

Sales & channels · View preview

Order Fulfillment

Each accepted SalesOrderLines base quantity and original promise versus live cancellation, actual handover/title, delivered, returned and billed allocations. On-time percentage uses eligible quantity completed by OriginalPromiseAt over quantity due in the stated cohort; open/late/cancelled scope is disclosed. Partial handovers determine full completion only when all uncancelled scope completes. Revised promises and repeated failed confirmations cannot inflate success.

Sales & channels · View preview

Stock Availability and Valuation

As-of posted movements and remaining layers by entity/SKU/warehouse/location/lot/serial; held, picked, unissued production staging and owned transit separate. Availability subtracts every active claim once. Issued material appears only in WIP; zero-stock assortments remain visible where configured. Reconcile stock/WIP once to the entity ledger, not a sum of current balance and historical deltas.

Inventory & fulfillment · View preview

Purchase Delivery Performance

Actual accepted ReceiptAcceptances against original PO promise and approved base quantity; display arrival timing, rejection/pending condition and supplier returns separately. An arrival is not an accepted receipt. Original promise and unique accepted units determine the denominator; missing history gives unavailable performance rather than perfect delivery.

Purchasing · View preview

Receipt and Bill Matching

Accepted tranche quantities and original GRNI versus active match claims, posted bills/credits, supplier returns and remaining obligations. Separate standard-versus-receipt variance from later bill-versus-receipt variance, tax and FX; neither variance is counted twice.

Purchasing · View preview

Production Cost and Variance

Released work quantity, unique terminal output, actual material/person-hours/machine-hours, signed WIP sources, standard output and separately recognized completion/scrap/remaining-close variance. Intermediate/rework operation throughput is not finished output. Productivity includes only independently accepted complete finite intervals; disclose excluded incomplete/zero-duration observations and timezones.

Production & kitting · View preview

Returns and Credits

Authorized versus actual physical return/disposition, original issue value, independently approved credit, reserved/actual refund and separately approved replacement by original purchase context. Physical and financial populations remain separate; a commercial credit is not proof of returned stock or cash. Refused/returned/accepted delivery overlap uses exact unit/scope union rather than adding duplicate quantities.

Inventory & fulfillment · View preview

Payment Reconciliation

Actual capture/cash receipt, customer unapplied/reserved/held balances, signed open processor asset/payable sources, fees/debits/recoveries, actual payouts/merchant bank debits, cash deposits and uncertainty by entity/account/currency. Intent/authorization contributes zero received money. Show gross positive and negative remaining clearing separately and their net; reconcile to clearing/suspense/bank controls with prior FX. Payout does not add customer collection or revenue a second time.

Payments & refunds · View preview

Receivables and Payables Aging

As-of posted remaining debits by entity/party/document currency/due-date bucket net exact live application/correction lineage. Unapplied cash, supplier prepayments and credit surplus remain separate, with purchase-context restrictions and functional carrying reconciliation. No silent cross-party/entity offset.

Payments & refunds · View preview

Local Financial Statements

Posted balanced JournalLines at each entity/period cutoff supply trial balance, income statement and balance-sheet mappings, including clearing/payable/suspense and stock/WIP reconciliations. Open/closed status and original versus correcting periods are explicit. No automatic consolidation, eliminations or unsupported common-currency group total.

Purchasing · View preview

Sales and customer orders

Sales by Channel and Store

Compare posted sales and credits by store, channel and product, with approved orders and outstanding fulfillment shown separately. Keep transaction currency and entity totals clear. An imported order or authorized card payment does not become recognized sales simply by arriving.

Explore Sales & channels

Sales Orders Awaiting ApprovalSalesOrders
Submitted
  • SO-33251 ACC-110
  • SO-30649 ACC-130
  • SO-51821 ACC-150
  • SO-45956 ACC-120
  • SO-40361 ACC-110
SO-33251
Account
ACC-110
Channel
CHN-3885
FulfillmentMode
StoreHandover
NetTotal
330
CreditReview
CR-20786

Approval waits for the sales manager.

Order Fulfillment

Follow approved quantities through picking, actual store handover, pickup or shipment, delivery results and billing. Partial work and remaining commitments stay visible. Returns preserve the original fulfillment history, and repeated delivery attempts cannot count the same accepted goods again.

Explore Sales & channels

Sales Orders Awaiting ApprovalSalesOrders
Submitted
  • SO-33251 ACC-110
  • SO-30649 ACC-130
  • SO-51821 ACC-150
  • SO-45956 ACC-120
  • SO-40361 ACC-110
SO-33251
Account
ACC-110
Channel
CHN-3885
FulfillmentMode
StoreHandover
NetTotal
330
CreditReview
CR-20786

Approval waits for the sales manager.

Returns and Credits

Compare requested and received returns, reviewed disposition, approved credits and actual refunds against the original purchase. Physical stock and financial outcomes remain separate. Follow replacement orders and their settlement differences without reopening the original shipment or sharing one shopper's entitlement with another.

Explore Inventory & fulfillment

Returns Awaiting DispositionReturnDispositions
StatusPreparedPendingApprovalApproved
Prepared
RD-76507RL-59108600 base quantity
RD-83070RL-77286140 base quantity
PendingApproval
RD-10658RL-66204260 base quantity
RD-15764RL-6588520 base quantity
Approved
RD-30709RL-38829560 base quantity
RD-81205RL-37096220 base quantity

Stock, supply and assembly

Stock Availability and Valuation

Review owned quantity and value by entity, product, location and required lot or serial at a retained cutoff. Distinguish available, held, reserved, picked, staged and transfer quantities. Material already issued into work in progress remains separate from stock; unaccepted supplier arrivals do not add owned inventory value.

Explore Inventory & fulfillment

Warehouse AvailabilityInventoryPositions
StatusActiveBlocked
Available
IP-10019PRD-4447490 on hand
IP-87194PRD-4849420 on hand
Held
IP-68131PRD-3750230 on hand
Picked
IP-38974PRD-6102880 on hand
Transit
IP-63472PRD-3847770 on hand
Production. Production is staged but not yet financially issued inventory
IP-11978PRD-2547810 on hand

Purchase Delivery Performance

Compare supplier commitments with actual arrivals, accepted quantities and outstanding supply. Preserve the original promise alongside reviewed changes, partial delivery and returns. A purchase draft or an unconfirmed expected arrival cannot count as received supply.

Explore Purchasing

Purchase Approval QueuePurchaseOrders
Submitted
  • PO-40235 VND-046 280 13 d
  • PO-85817 VND-217 740 8 d
  • PO-35140 VND-179 760 3 d
  • PO-21177 VND-197 780 4 d
  • PO-80452 VND-124 420 2 d
PO-40235
Supplier
VND-046
OrderDate
04 Sep
CurrentTotal
590
ApprovalBasis
280
Status
Submitted

Approval waits for the purchasing manager.

Receipt and Bill Matching

See which accepted receipt quantities have been billed and how supplier invoices reconcile with their original receipt accrual. Expose unused accepted quantities, disputed bill lines, credits and required exceptions. Matching an invoice does not add the same stock again.

Explore Purchasing

Purchase Approval QueuePurchaseOrders
Submitted
  • PO-40235 VND-046 280 13 d
  • PO-85817 VND-217 740 8 d
  • PO-35140 VND-179 760 3 d
  • PO-21177 VND-197 780 4 d
  • PO-80452 VND-124 420 2 d
PO-40235
Supplier
VND-046
OrderDate
04 Sep
CurrentTotal
590
ApprovalBasis
280
Status
Submitted

Approval waits for the purchasing manager.

Production Cost and Variance

Follow accepted kits or repacked output, actual materials and time, frozen output standards and the remaining job balance. Completion, scrap and close variances keep their own sources. Intermediate work and repeated rework passes do not multiply finished output or charge the same cost twice.

Explore Production & kitting

Production ScheduleWorkOrders
StatusPendingApprovalReleasedInProgressPartiallyCompletedPendingClose
09 Sep WRH-140 WO-20034, 09 Sep to 15 Sep, PendingApproval WO-50671, 12 Sep to 14 Sep, InProgress WO-71345, 16 Sep to 19 Sep, PartiallyCompleted WRH-130 WO-33448, 17 Sep to 26 Sep, Released WO-88250, 23 Sep to 27 Sep, PendingClose WRH-110 WO-62693, 12 Sep to 19 Sep, PendingApproval WO-20034WO-33448WO-50671WO-71345WO-88250WO-62693 today · 17 Sep
  • WRH-140: WO-20034, 09 Sep to 15 Sep, PendingApproval
  • WRH-130: WO-33448, 17 Sep to 26 Sep, Released
  • WRH-140: WO-50671, 12 Sep to 14 Sep, InProgress
  • WRH-140: WO-71345, 16 Sep to 19 Sep, PartiallyCompleted
  • WRH-130: WO-88250, 23 Sep to 27 Sep, PendingClose
  • WRH-110: WO-62693, 12 Sep to 19 Sep, PendingApproval

Payments and finance

Payment Reconciliation

Compare confirmed collections, unapplied amounts, customer allocations and refunds with processor clearing and actual bank evidence. Show gross captures, fees, payouts and debits separately. A refund after payout can leave a processor amount payable; it does not erase the original receipt or create negative customer spending credit. Keep unknown or disputed outcomes visible until resolved.

Explore Payments & refunds

Processor ReconciliationProcessorSettlements
StatusObservedMatchingPendingApprovalUncertainDisputed
Observed
PS-73867PA-110
PS-18682PA-140
Matching
PS-36733PA-110
PendingApproval
PS-90219PA-110
Uncertain
PS-91180PA-130
Disputed
PS-95968PA-130

Receivables and Payables Aging

Review open customer and supplier documents by entity, currency and due-date bucket, after actual allocations, credits and corrections at the report date. Keep unapplied cash, prepayments and surplus credits visible. Walk-in purchase balances remain isolated by transaction, and balances are not silently netted across companies or unrelated customers.

Explore Payments & refunds

Processor ReconciliationProcessorSettlements
StatusObservedMatchingPendingApprovalUncertainDisputed
Observed
PS-73867PA-110
PS-18682PA-140
Matching
PS-36733PA-110
PendingApproval
PS-90219PA-110
Uncertain
PS-91180PA-130
Disputed
PS-95968PA-130

Local Financial Statements

Produce each entity's trial balance, income statement and balance-sheet mappings from posted journal lines at the period cutoff. Reconcile inventory, work in progress, customer funds, processor clearing and other control accounts with their sources. Each company balances independently; group consolidation and eliminations require additional scope.

Explore Purchasing

Purchase Approval QueuePurchaseOrders
Submitted
  • PO-40235 VND-046 280 13 d
  • PO-85817 VND-217 740 8 d
  • PO-35140 VND-179 760 3 d
  • PO-21177 VND-197 780 4 d
  • PO-80452 VND-124 420 2 d
PO-40235
Supplier
VND-046
OrderDate
04 Sep
CurrentTotal
590
ApprovalBasis
280
Status
Submitted

Approval waits for the purchasing manager.

Using the reports

Reports, exports and assistant summaries follow the same entity, role and sensitive-field permissions as the underlying work. Access to order progress does not automatically expose margins, production rates or bank details.

Keep the report date, currency basis and included population visible when comparing results. Historical performance uses retained events and financial postings, rather than today’s status alone. The reporting definitions and representative reconciliations are verified during implementation.

ERP•AI workspace

Start now Retail & E-commerce ERP

Create your ERP.AI account and get started with Proto.

Start now Download agent

Customize Retail & E-commerce ERP. With Proto, your desktop AI agent.

Ask Proto to help you customize Retail & E-commerce ERP.

Customize
Retail & E-commerce ERP. Ask: “Adapt Sales & channels.” ProtoYour desktop AI agent
Download nowFree install · ~1 GB · AI usage extra