PLATFORM

Reporting & Analytics

From pre-built reports to custom SQL analytics, get the insights you need to grow your business—without waiting for IT or buying expensive BI tools.

Request a Demo

Everything you need for business intelligence

No expensive BI tools required. Get instant insights from your operational data.

100+ Pre-Built Reports

Ready-to-use reports for operations, finance, inventory, and sales. No setup required.

Custom SQL Reports

Write your own SQL queries or use the visual builder. Full access to your data schema.

Parametrized Queries

Add dynamic filters to reports with date ranges, warehouses, channels, and more.

Export Anywhere

Export to CSV, Google Sheets, or connect to BigQuery for advanced analytics.

Real-Time Data

Reports run on live operational data. No delays, no batch processing, no stale data.

Share & Schedule

Schedule reports to run automatically and share via email or Slack notifications.

Reports for every team

Pre-built reports covering operations, finance, inventory, and revenue analytics.

Operations

  • Orders by Channel
  • Fulfillment Performance
  • Shipment Tracking
  • Returns Analysis
  • Warehouse Productivity

Financial

  • Income Statement
  • Balance Sheet
  • Cash Flow Statement
  • Accounts Receivable Aging
  • Accounts Payable Aging

Revenue

  • Revenue by Channel
  • Product Performance
  • Customer Cohort Analysis
  • Sales Trends
  • Discount Analysis

Inventory

  • Stock Levels by Location
  • Inventory Turnover
  • Dead Stock Analysis
  • Reorder Recommendations
  • Inventory Valuation
CUSTOM SQL REPORTING

Build reports exactly how you need them

Sometimes pre-built reports aren't enough. With custom SQL reporting, you have full access to your data schema to build exactly the report you need.

Full Schema Access

Write SQL queries against the entire Fulfil data model—orders, inventory, customers, products, financials, and more.

Dynamic Parameters

Use @parameter syntax to add filters that users can change when running the report.

Visual Query Builder

Not comfortable with SQL? Use the visual builder to create reports by clicking and dragging fields.

See Custom Reports in Action
revenue_by_channel.sql 
-- Revenue by Sales Channel with Date Filter

SELECT
    channel_name,
    COUNT(order_id) AS order_count,
    SUM(total_amount) AS total_revenue,
    AVG(total_amount) AS avg_order_value
FROM
    sales_orders
WHERE
    order_date BETWEEN @start_date AND @end_date
    AND state = 'confirmed'
GROUP BY
    channel_name
ORDER BY
    total_revenue DESC
Pro tip: Parameters like @start_date and @end_date become date pickers in the UI, making reports dynamic and reusable.
Fulfil
Fulfil ERP
Operational Database
BigQuery
Google BigQuery
Data Warehouse
Google Sheets
Google Sheets
Looker Studio
Looker Studio
Tableau
Tableau
DATA WAREHOUSE INTEGRATION

Need more? Connect to BigQuery

For advanced analytics, machine learning, or integration with your existing BI stack, Fulfil automatically syncs all your operational data to Google BigQuery.

  • Automatic ETL

    All data from Fulfil is automatically synced to BigQuery every hour.

  • Full Schema Access

    Query any table, join across datasets, or run complex analytics on years of historical data.

  • Use Any BI Tool

    Connect Looker Studio, Tableau, Power BI, or any tool that supports BigQuery.

Learn more about Data Warehouse

Frequently asked questions

Do I need a separate BI tool to use Fulfil reporting?

No! Fulfil includes comprehensive reporting out of the box with 100+ pre-built reports and custom SQL reporting. However, if you want to use your existing BI tools like Tableau or Looker Studio, you can connect them to your BigQuery data warehouse.

Can non-technical users create custom reports?

Yes! While SQL knowledge helps for complex queries, Fulfil includes a visual query builder that lets you create reports by selecting fields and filters through a point-and-click interface. Most common reports can be built without writing any SQL.

How do I share reports with my team?

Reports can be shared via direct links, exported to CSV or Google Sheets, or scheduled to run automatically and delivered via email or Slack. You can also embed reports in dashboards that update in real-time.

Are reports based on real-time data?

Yes! Reports in Fulfil run directly against your operational database, so they always show current data. There's no batch processing or delays. For historical analysis or complex joins, you can use the BigQuery data warehouse which syncs every hour.

Can I schedule reports to run automatically?

Absolutely! You can schedule any report to run daily, weekly, or monthly. Scheduled reports can be automatically emailed to your team or posted to Slack channels. This is perfect for executive summaries, weekly inventory reviews, or monthly financial reports.

What's the difference between Fulfil reports and BigQuery?

Fulfil's built-in reports are perfect for day-to-day operational reporting—fast, easy to use, and always up to date. BigQuery is better for advanced analytics like machine learning, multi-year trend analysis, or integrating Fulfil data with other business systems. Most customers use both: built-in reports for daily operations and BigQuery for strategic analysis.

Ready to get better insights into your business?

See how Fulfil's reporting can help you make data-driven decisions

Request a Demo