18 supported systems. For each one — the exact export to run, where to find it, and what BI Now! builds from it.
Finance & Accounting
QuickBooks Online
Transaction List
P&L
Customer Balance Detail
How to export
- 1Go to Reports in the left menu
- 2Search for "Transaction List by Date" (or "Profit & Loss" / "Customer Balance Detail")
- 3Set your date range (12 months recommended)
- 4Click Export → Export to CSV
What BI Now! builds
- Cash Flow
- Revenue Concentration
- P&L Breakdown
P&L exports are semi-structured — BI Now! flattens them automatically but review the segment mapping before presenting results.
Finance & Accounting
Xero
Bank Statement
Invoice Export
Aged Receivables
How to export
- 1For bank data: Accounting → Bank Accounts → select account → Export
- 2For invoices: Accounts → Sales → select invoices → Export to CSV
- 3For aged receivables: Accounting → Reports → Aged Receivables → Export
What BI Now! builds
- Cash Flow
- Revenue Concentration
- Outstanding Receivables
Date format varies by regional settings — BI Now! handles both DD/MM/YYYY and MM/DD/YYYY automatically.
Finance & Accounting
Sage (50, 200, Business Cloud)
Transaction Export
Aged Debtors Report
How to export
- 1Go to Transactions or Reports
- 2Filter by date range
- 3Click Export → CSV/Excel → save as CSV
What BI Now! builds
Works with Sage 50, Sage 200, and Sage Business Cloud. Column names vary slightly — BI Now! normalises automatically.
Finance & Accounting
FreeAgent
Invoice Export
Bank Transaction Export
How to export
- 1For invoices: Sales → Invoices → select all → Export as CSV
- 2For bank data: Banking → select account → Export transactions → CSV
What BI Now! builds
- Cash Flow
- Revenue by Client
Finance & Accounting
Wave
Transaction Export
Invoice Export
How to export
- 1For transactions: Accounting → Transactions → select all → Export (top right)
- 2For invoices: Sales → Invoices → Export
What BI Now! builds
- Cash Flow
- Revenue by Customer
Finance & Accounting
FreshBooks
Invoice Export
Expense Export
How to export
- 1Go to Invoices (or Expenses)
- 2Select all records
- 3Click Export → Download CSV
What BI Now! builds
- Cash Flow
- Revenue by Client
Outstanding invoice balances are automatically flagged in the output.
Finance & Accounting
Zoho Books
Invoice Export
Bank Transaction Export
How to export
- 1For invoices: Sales → Invoices → Export (top right) → CSV
- 2For bank data: Banking → select account → Transactions → Export
What BI Now! builds
- Cash Flow
- Revenue by Customer
Multi-currency exports are detected and flagged — amounts are aggregated without conversion.
CRM & Sales
HubSpot
Deals Export
Contacts Export
Tickets Export
How to export
- 1Go to CRM → Deals (or Contacts / Tickets)
- 2Click Actions → Export
- 3Select "Export current view" → CSV
What BI Now! builds
- Pipeline Health
- Acquisition by Source
- Customer Experience
Spend data is not available in standard contact exports — acquisition spend must be added manually.
CRM & Sales
Salesforce
Opportunities
Accounts
Cases
How to export
- 1Go to Reports → find or build an Opportunities / Accounts / Cases report
- 2Click the dropdown arrow → Export → Export Formatted → CSV
What BI Now! builds
- Pipeline Health
- Revenue by Account
CSAT score defaults to 80% — Salesforce Cases do not include CSAT by default. Export CSAT separately for accurate scores.
CRM & Sales
Zoho CRM
Deals Export
How to export
- 1Go to Deals module (list view)
- 2Select all records
- 3Click the Export icon (top right) → Export as CSV
What BI Now! builds
- Pipeline by Account
- Weighted Pipeline by Close Month
Pipeline totals (total and probability-weighted) are shown as summary notes in the output.
HR & Operations
BambooHR
Employee Data
Time-Off Report
How to export
- 1Go to Reports → select "Employee Data" or build a custom report
- 2Include: Name, Department, Hire Date, Employment Status
- 3Click Export → CSV
What BI Now! builds
- Headcount & Attrition by Department
Training hours are not available in standard BambooHR exports — this field defaults to zero.
HR & Operations
Zendesk
Tickets Export
CSAT Export
How to export
- 1Go to Reporting → Explore → select Tickets dataset
- 2Or: Admin → Reports → tick Export
- 3Export as CSV
What BI Now! builds
- Customer Experience (ticket volume, resolution rate, channel breakdown)
CSAT score defaults to 80% when no CSAT data is in the export — export CSAT separately from Explore for accurate scores.
eCommerce & Payments
Shopify
Orders Export
Customers Export
How to export
- 1For orders: Orders → Export → All Orders → CSV for Excel (or plain CSV)
- 2For customers: Customers → Export → All Customers → CSV
What BI Now! builds
- Revenue Cash Flow
- Customer LTV
- Repeat Purchase Rate
eCommerce & Payments
WooCommerce
Orders Export
How to export
- 1Install the free "WooCommerce Customer / Order / Coupon Export" plugin (or use built-in export in WooCommerce → Orders → Export)
- 2Export all orders with standard fields
- 3Save as CSV
What BI Now! builds
- Cash Flow
- Revenue by Customer
Multi-currency orders are detected and flagged — amounts are aggregated without conversion.
eCommerce & Payments
Stripe
Balance Transaction Export
How to export
- 1Go to Stripe Dashboard → Payments → Balance
- 2Click the export icon (top right)
- 3Select date range → Export → CSV
What BI Now! builds
- Cash Flow (Stripe revenue, net of fees)
Stripe amounts are sometimes in minor units (pence/cents) — BI Now! auto-detects and converts. Total fees processed are shown in output notes.
eCommerce & Payments
Square
Sales Transactions
How to export
- 1Go to Square Dashboard → Transactions
- 2Set date range
- 3Click Export → Download CSV
What BI Now! builds
- Cash Flow (Square sales revenue)
eCommerce & Payments
PayPal
Transaction Export (Activity Download)
How to export
- 1Go to PayPal → Activity → Statements & Reports
- 2Select Activity Download
- 3Set date range → CSV → Download
What BI Now! builds
- Cash Flow
- Revenue by Payer (top 20)
Multi-currency transactions are included but not converted. Internal transfers, withdrawals, and currency conversions are automatically excluded — only completed payments are counted.
eCommerce & Payments
Monzo Business
Transaction Export
How to export
- 1Open the Monzo Business app
- 2Go to Account → Transactions
- 3Tap Export → Download as CSV
What BI Now! builds