How can I track revenue by channel in my ERP?

Fulfil includes built-in revenue reports broken down by channel, product, sales person, region, and date. You can see exactly how much revenue is coming from Shopify, Amazon, wholesale, and every other channel without exporting data or building spreadsheets.

Can I see inventory levels across multiple warehouses and 3PLs?

Yes. Fulfil reports show inventory by warehouse and by location, so you can see stock levels across your own warehouses, 3PLs, and Amazon FBA locations in one view. You can also track inventory aging, reservations, valuation history, and adjustment summaries.

Does Fulfil support consolidated financial reporting for multi-company brands?

Yes. Fulfil includes consolidated income statement, balance sheet, cash flow statement, and inventory valuation reports for brands operating multiple legal entities. These consolidate data across all your companies into a single view.

How do I track supplier performance and purchasing costs?

Fulfil includes supplier performance reports, open purchase order tracking, inbound shipment value reports, three-way match reports (PO vs receipt vs invoice), landed cost breakdowns, and product cost history. These help you monitor supplier reliability and understand your true product costs.

Can I track fulfillment speed and shipping performance?

Yes. Fulfil includes cycle time reports (detail, summary, and stats), shipment tracking, items shipped reports, and over-assignment exception reports. You can also break down shipments by country, state, and user to identify bottlenecks.

Does Fulfil generate 1099 reports for US tax filing?

Yes. Fulfil includes a 1099 summary report that aggregates vendor payments for US tax compliance. You can generate this report at year-end without exporting data to a separate system.

How do I track returns and return reasons in my ERP?

Fulfil includes returns by product, returns by reason, and returns not received reports. These help you identify product quality issues, track return rates by SKU, and make sure returned inventory is properly accounted for.

Can I track production and manufacturing output?

Yes. Fulfil includes quantity produced summaries, production schedules, WIP (work in progress) balance reports, and inventory risk reports for manufacturable products. These give manufacturing teams visibility into production performance and upcoming material needs.

Platform

Reporting
& analytics.

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

See how it works

What's included

Everything you need for business intelligence.

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

01 / REPORTS

100+ pre-built reports.

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

02 / SQL

Custom SQL reports.

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

03 / FILTERS

Parametrized queries.

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

04 / EXPORT

Export anywhere.

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

05 / LIVE

Real-time data.

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

06 / SHARE

Share & schedule.

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

Coverage

Reports for every team.

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

Sales & Orders

Track every order

✓Orders by Month
✓Orders by Channel
✓Orders by Sales Person
✓Orders by Product
✓Orders by Template
✓Orders by Category
✓Orders by Region
✓Retention Cohorts
✓Price List Report

Revenue

Find what's working

✓Revenue by Date
✓Revenue by Product
✓Revenue by Sales Person
✓Revenue by Channel
✓Revenue by Region
✓Revenue by GL
✓Manual Revenue Transactions

Shipping & Fulfillment

Move product faster

✓Shipments by Country
✓Shipments by State/Region
✓Shipments by User
✓Items Waiting Assignment
✓Items Allocated/Assigned
✓Items Shipped
✓Cycle Time Detail, Summary & Stats
✓Shipment Summary & Detail
✓Shipment Tracking
✓Over Assignment Exceptions

Returns & Receiving

Close the loop

✓Returns by Product
✓Returns Not Received
✓Returns by Reason
✓Items Received
✓Open Supplier Shipments

Financial

Close the books

✓Income Statement
✓Income Statement by Class
✓Balance Sheet
✓Cash Flow Statement
✓Trial Balance
✓General Ledger
✓Account Transactions
✓Aged Balance Receivable
✓Aged Balance Payable
✓Tax Summary & Detail
✓1099 Summary
✓Currency Exposure
✓Unallocated Journal Entry Lines
✓Manual Inventory Adjustments
✓Budget Variance

Consolidated

Multi-company reporting

✓Consolidated Income Statement
✓Consolidated Balance Sheet
✓Consolidated Cash Flow Statement
✓Consolidated Inventory Valuation

Inventory

Know your stock

✓Inventory by Warehouse
✓Inventory by Location
✓Inventory Aging
✓Inventory Transactions
✓Inventory Reservations
✓Inventory Valuation History
✓Inventory Adjustment Summary
✓Next Available Date
✓Empty Locations
✓Inventory & Balance Sheet Reconciliation
✓Inventory Received Not Invoiced Reconciliation

Purchasing

Track what's coming in

✓Open Purchase Orders
✓Inbound Shipment Value
✓Supplier Performance
✓Three-Way Match
✓Landed Cost Breakdown
✓Product Cost Estimate
✓Product Cost History

Manufacturing

Monitor production

✓Quantity Produced Summary
✓Production Schedule
✓Inventory Risk for Manufacturable Products
✓WIP Balance

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

Query results (4 rows)

channel_name	order_count	total_revenue	avg_order_value
Shopify	2,847	$1,428,350.00	$501.72
Amazon	1,523	$876,240.00	$575.28
Wholesale	324	$642,180.00	$1,982.04
Retail Partners	156	$298,440.00	$1,912.56

Parameters like @start_date and @end_date become date pickers in the UI, so reports are dynamic and reusable. Drag the divider to adjust the view.

Fulfil ERP

Operational database

↓

Google BigQuery

Data warehouse

↓

Google Sheets

Looker Studio

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 →

FAQ

Common 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?

Yes. 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 for better insights
into your business?

See how Fulfil's reporting helps you make data-driven decisions.

See how it works

Operations

Financials

Platform

By Industry

By Challenge

Reporting
& analytics.