Flow for Lightspeed Retail is coming soon. Join early access
Flow · Reports & data feeds

Get POS data wherever you need it.

Select the fields you want as output columns, grouped by data type. Flow works out which POS records to fetch and join, applies filters across related data, then sends the finished report or feed wherever it needs to go.

Choose the columns you needRelated records joined for youEmail, Sheets, FTP or SFTP
Build once. Deliver automatically.

Up-to-date reports and feeds, without the repeat work.

Choose the fields, format and destination once. Flow fetches and joins the right data on schedule, then delivers an up-to-date report or feed automatically.

  • Stakeholders

    Custom email updates

    Send non-technical stakeholders a tailored subject and message, set the reply-to address, and optionally show Flow’s output in the email body while attaching the full data file.

  • Finance

    Finance reports and exports

    Send detailed or summarised transaction, tender and till records to an accountant or finance workflow. Ideal for automating end-of-month processes.

  • Inventory

    Inventory and supplier feeds

    Product, stock, supplier and category data in the format a partner system expects. Ideal when you need to provide up-to-date product and stock data to partners.

  • Marketing

    Marketing data feeds

    Deliver customer, purchase and product records to Klaviyo or another marketing tool. Enable powerful marketing and after-sales automation with marketing platforms.

  • Analysis

    Power BI, Tableau and AI inputs

    Use Flow to automatically send data to services like Google Sheets which can then be used as data sources for BI and AI tools for custom dashboards, reports and analysis.

  • Delivery

    Email, Sheets, FTP and SFTP delivery

    Send each output wherever it needs to go: by email, into Google Sheets or to any FTP or SFTP server. A dashboard download remains available whenever you need a manual copy.

See what you can build when Flow handles the data relationships.

Browse practical reports, feeds and alerts that combine the POS fields each job needs.

Explore Flow use cases →
Data types and relationships

Select the fields you need. Flow handles the relationships.

The field selector groups available fields by data type, making it easy to choose from sales, catalogue, stock, customer and operational data. Flow works out which records to fetch and join—and you can filter using any related field too.

Connected POS data types
Representative data types
  • Sales & payments

    Transactions
    • Sales
    • Line items
    • Payments & tenders
    • Returns & refunds
    • Taxes & promotions
    • Sales reports
  • Products & catalogue

    Products
    • Categories
    • Brands
    • Suppliers
    • Product types
    • Variants
    • Price books
    • Tags
  • Stock & fulfilment

    Stock levels
    • Inventory records
    • Stocktakes
    • Purchase orders
    • Consignments
    • Fulfilments
    • Serial numbers
  • People & operations

    Customers
    • Staff & users
    • Roles
    • Shifts & clocking
    • Locations & outlets
    • Tills & registers
    • Devices
    • Services
Select fields from any available data type. Exact availability varies by connected POS platform.
Relationship-aware POS data

Start with one data type. Use all connected fields.

Add customer, staff, location, product, category, supplier, stock or tax fields to a transaction export—or use them in a filter. Flow follows the relationships, fetches the right records and joins everything into one result.

What report or export do you need regularly?

If it involves selecting records, joining fields, cleaning a spreadsheet or forwarding a file, Flow could save your team time every time it runs.