Point of sale integration
Turn merchant locations, payments, orders, items, and customer data into 51 governed metrics for dashboards, agent answers, and cross-channel reporting.
What you can do with Square in Maven
Maven models Square into 51 governed metrics from the semantic layer. Track Sales Gross Revenue, Sales Net Revenue, Sales Units, Sales Discount and Sales Tax, break results down by Pos Name, Cashier Name, Store or location and Product, and report Square alongside Google Analytics 4, Google Ads and Facebook Ads without rebuilding exports or metric logic for every report.
What you can measure
Maven keeps Square numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Gross revenue from POS sales line items
Net revenue after tax from POS sales line items
Units sold across POS sales line items
Discount amount on POS sales line items
Tax collected on POS sales line items
POS receipt count by store and date
Units sold through POS receipts by store and date
Gross POS revenue including tax at store-day grain
Net POS revenue after tax and discounts at store-day grain
Discount amount applied across POS receipt line items at store-day grain
Average gross revenue per transaction
Tender amount applied to the receipt (additive)
System-expected amount for this payment method at close (additive)
Counted / actual amount entered at close (additive)
counted_amount - expected_amount, signed: negative = short, positive = over (additive)
Receipts rung by the cashier in the close (additive)
Receipt amount rung by the cashier in the close (additive)
Voided receipts in the close (additive)
Voided receipt amount in the close (additive)
Cancelled receipts in the close (additive)
Cancelled receipt amount in the close (additive)
Cancelled line items in the close (additive)
Cancelled line item amount in the close (additive)
Return transactions in the close (additive)
Returned amount in the close (additive)
Provider order total before reconciliation adjustments.
Net order amount due according to the provider.
Tip amount recorded on the order.
Order total amount excluding explicit Square tip total when available
Order expected payment amount including Square tip total
Sum of linked payments with approved or completed payment status
successful_payment_amount - expected_payment_with_tip_amount
Number of payment rows linked to the order/reconciliation id
Sum of all linked payment amounts regardless of status.
Tip amount represented by linked payments.
Units in stock; only valid within a single snapshot date
Inventory valued at cost; only valid within a single snapshot date
Inventory valued at retail; only valid within a single snapshot date
Units received via inbound stock deliveries
Cost of inbound stock deliveries
Signed net stock change across deliveries adjustments and transfers
System-expected on-hand units at count time (additive)
Physically counted units (additive)
counted_units - nominal_units, signed: negative = missing stock (additive)
variance_units valued at average purchase price (additive)
Units ordered on this PO line (additive)
Units actually received (additive)
quantity_ordered * item_price — total order value for this line (additive)
Questions you can ask
Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.
What was gross POS revenue by store over the last 30 days?
Plot weekly retail sales over time
Show POS discounts by store
Which POS products drove the most gross sales?
Show stock movements by movement type
Show purchase order received units by delivery date
Show orders with missing or mismatched payments
Show cash over/short by payment method
Report templates
Use Square reporting templates to see what needs attention, what can be trusted, and which optional fields need cleanup before the next review.
Prioritize stockout risk, reorder review, transfers, and supporting sales/stock evidence across retail locations.
Operational recommendations require product mappings, current inventory, velocity history, and explicit thresholds or transfer/supplier evidence.
Connect product and location sales with current inventory context to identify conversion, markdown, and replenishment review opportunities.
Sell-through and action statuses require product-level sales joined to a current inventory snapshot; margin requires governed cost data.
Reconcile recorded sales, tenders, refunds, discounts, taxes, and register/location exceptions into an auditable review queue.
Register, cashier, payment, tax, refund, and closeout detail appears only when the connected POS exposes those governed records.
How it works
No SQL, no warehouse setup, no data engineer. Connect the source, then Maven models the fields needed for the first trusted workflow.
Authorize or configure Maven from the Data Sources screen, then pick the account and workspace to sync.
Maven pulls your Square data (5 objects) and models it into governed, conformed tables, no SQL, warehouse, or pipeline setup required.
Ask questions in natural language with the Maven agent, drop the metrics into dashboards, set alerts on what matters, and schedule deliveries to your team.
What Maven syncs from Square
Works well with
FAQ
Maven exposes 51 governed Square metrics, including Sales Gross Revenue, Sales Net Revenue, Sales Units, Sales Discount, Sales Tax and POS Transactions, each defined once so it means the same thing in every report.
You can break Square metrics down by Pos Name, Cashier Name, Store or location, Product, Commodity group, Sector, Control Event Type and Z Count, and more.
Yes. Square reports alongside sources like Google Analytics 4, Google Ads, Facebook Ads and Shopify. Maven models every source into one governed layer, so you can blend them in a single dashboard, report, or question.
Maven syncs payments, orders, catalog items, variations, and categories, inventory counts and inventory changes from Square.
Maven keeps Square data on scheduled refreshes after the source is connected, with sync status visible in the workspace before reports are shared.
Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.
Bring one recurring report, disputed metric, or client workflow. We'll show where the time goes, what can be trusted now, and how Maven would improve it.
We'll review the workflow behind one client report
You'll see what Maven can own across data, QA, and delivery
No pitch deck. No pressure. 20 minutes.
