Lightspeed reporting & retail

Discounts

Discount amount applied across POS receipt line items at store-day grain

Avg Transaction Value

Average gross revenue per transaction

Pos Tender Amount

Tender amount applied to the receipt (additive)

Pos Cash Expected Amount

System-expected amount for this payment method at close (additive)

Pos Cash Counted Amount

Counted / actual amount entered at close (additive)

Pos Cash Variance Amount

counted_amount - expected_amount, signed: negative = short, positive = over (additive)

Pos Register Receipts

Receipts rung by the cashier in the close (additive)

Pos Register Receipts Amount

Receipt amount rung by the cashier in the close (additive)

Pos Voided Receipts

Voided receipts in the close (additive)

Pos Voided Amount

Voided receipt amount in the close (additive)

Pos Cancelled Receipts

Cancelled receipts in the close (additive)

Pos Cancelled Amount

Cancelled receipt amount in the close (additive)

Pos Cancelled Items

Cancelled line items in the close (additive)

Pos Cancelled Items Amount

Cancelled line item amount in the close (additive)

Pos Returns

Return transactions in the close (additive)

Pos Returns Amount

Returned amount in the close (additive)

Pos Payment Control Order Total Amount

Provider order total before reconciliation adjustments.

Pos Payment Control Net Amount Due

Net order amount due according to the provider.

Pos Payment Control Order Tip Amount

Tip amount recorded on the order.

Pos Payment Control Expected Payment Amount

Order total amount excluding explicit Square tip total when available

Pos Payment Control Expected Payment With Tip Amount

Order expected payment amount including Square tip total

Pos Payment Control Successful Payment Amount

Sum of linked payments with approved or completed payment status

Pos Payment Control Payment Delta Amount

successful_payment_amount - expected_payment_with_tip_amount

Pos Payment Control Payment Count

Number of payment rows linked to the order/reconciliation id

Pos Payment Control Total Payment Amount

Sum of all linked payment amounts regardless of status.

Pos Payment Control Payment Tip Amount

Tip amount represented by linked payments.

Inventory Units On Hand

Units in stock; only valid within a single snapshot date

Inventory Cost Value

Inventory valued at cost; only valid within a single snapshot date

Inventory Retail Value

Inventory valued at retail; only valid within a single snapshot date

Reorder Level

Max Level

Units On Order

Stock Units Received

Units received via inbound stock deliveries

Stock Purchase Cost

Cost of inbound stock deliveries

Net Stock Change

Signed net stock change across deliveries adjustments and transfers

Pos Count Nominal Units

System-expected on-hand units at count time (additive)

Pos Count Counted Units

Physically counted units (additive)

Pos Count Variance Units

counted_units - nominal_units, signed: negative = missing stock (additive)

Pos Count Variance Cost

variance_units valued at average purchase price (additive)

Pos Po Units Ordered

Units ordered on this PO line (additive)

Pos Po Units Received

Units actually received (additive)

Pos Po Order Value

quantity_ordered * item_price — total order value for this line (additive)