Wave connector

Use your Wave data for reporting, automation and AI.

Data Panda brings your Wave data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Wave logo
About Wave

Free accounting and invoicing for microbusinesses in the US and Canada.

Wave is a cloud accounting platform built around free invoicing, estimates, double-entry books and receipt scanning for sole proprietors, freelancers and microbusinesses, with the active base concentrated in the US and Canada. The product is monetized through Wave Payments, the card and bank payment rail wired into every invoice, and Wave Payroll for US and Canadian employers. The accounting and invoicing modules stay free, which is why a long tail of side businesses, contractors and one-person shops live on it from day one.

In a warehouse, the Wave ledger sits next to the rest of a small operator's stack: the CRM that captured the lead, the Stripe or Wave Payments rail that settled the invoice, the Shopify or Etsy storefront that booked the sale, the bank feed that confirms the cash. Cash position, AR aging, payment-fee drag and product-versus-service margin become a live picture instead of a quarterly export the founder pulls before tax season.

What your Wave data is for

What you get once Wave is connected.

Microbusiness reporting

Cash position, AR aging and payment-fee drag on one view, refreshed daily.

  • Cash position from Wave bank balances and pending Wave Payments
  • AR aging per customer with average days-to-paid
  • Card and Amex fee drag per customer per month

Founder-stack automation

Let the CRM, payments and storefront post into Wave without re-keying.

  • HubSpot closed-won creating Wave customers and draft invoices
  • Stripe payouts reconciled per Wave invoice with fees split out
  • Slack alerts when an invoice crosses 30 days overdue

AI workflows

Use Wave history to score risk, classify expenses and forecast cash.

  • Late-payer scoring per customer across recurring and one-shot invoices
  • AI-assisted coding of receipts and supplier bills to the right account
  • Cash forecast on booked invoices, recurring patterns and Payroll runs

Custom apps on your data

Internal tools on Wave data for the founder, the bookkeeper and the partner.

  • Founder cash app with Wave AR, Stripe in-flight and bank balance
  • Customer-profitability app with revenue, fees and discounts per client
  • Sales-tax app with Wave entries reconciled to filings per period
Use cases

Use cases we deliver with Wave data.

A list of concrete reports, automations and AI features we have built on Wave data. Pick the one that matches your situation.

Cash positionBank balances plus pending Wave Payments, by account.
AR agingOpen invoices by bucket, per customer and per month.
Late-payer trendRolling DSO across recurring and one-shot invoices.
Payment-fee dragCard and Amex fees per customer, per channel, per month.
Customer profitabilityRevenue net of refunds, discounts and processing fees.
Product vs service mixRevenue split by item type and category in the chart of accounts.
Expense by categoryReceipts and bills posted to Wave, grouped per account.
Sales-tax owedTax collected and owed per period, reconciled to filings.
Payroll cash impactWave Payroll runs against bank cash, US and Canada.
Cash-flow forecastBooked invoices plus recurring patterns, thirteen-week view.
Real business questions

Answers you will finally get.

How much do card fees cost us per customer?

Wave Payments charges per transaction, with a higher rate on Amex, and the fees are deducted from each settlement. In the warehouse those fees are split out per invoice and per customer, so the founder sees which clients are quietly the most expensive to take card payment from, and where a bank-payment nudge would change the math.

Where is the cash really sitting today?

Bank balances and pending Wave Payments land next to each other in the warehouse. Cash position becomes a single number that updates daily, with the breakdown per account, per pending payout and per upcoming Wave Payroll run, so the founder is not opening three tabs to answer the question.

Which clients are quietly turning into late-payers?

Wave invoice and payment events feed a rolling DSO per customer. Clients drifting from a steady seven-day pattern to thirty-plus show up early in the warehouse, with the open balance and the trend line, so the dunning email or the friendly call is sent before it becomes a write-off conversation.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Cash position, AR aging and payment-fee drag on one view, with Wave invoices, Stripe settlements and bank cash on the same line. Tax season becomes a review, not a scramble through CSV exports.

For sales leaders

Per-customer payment history visible at the moment of the renewal or upsell. New scope is sold against what the customer really pays for, and at the card-fee cost they really carry, not against the original quote.

For operations

Receipt and supplier-bill data tied back to the right account in Wave. The founder or the bookkeeper sees where the spend is leaking, before it shows up as a thinner end-of-year P&L.

Ideas

What you can automate with Wave.

Pair with Stripe

Reconcile Stripe payouts to Wave invoices

Stripe payouts are matched to the Wave invoices they paid, with processing fees split out per charge and per currency. The founder sees net cash per invoice and per customer, not a weekly Stripe lump that has to be broken apart by hand at month end.

Pair with HubSpot

Turn HubSpot deals into Wave customers and invoices

Closed-won HubSpot deals create Wave customers with the right billing details, scope and tax setup, and prepare the first draft invoice. Sales sees Wave payment history on the HubSpot record before quoting net-30 to a customer who has been paying in 60 for a year.

Pair with Slack

Push Wave alerts into Slack for the founder

Invoices passing 30 days overdue, low cash positions and large incoming Wave Payments post into a Slack channel with the customer name and the open amount. The founder finds out the day it happens, not at the next bookkeeping check-in.

Pair with monday.com

Sync Wave invoice status to monday.com client boards

Each Wave invoice updates the matching client item on monday.com with status, due date and open balance. Account leads see what is sent, paid and overdue on their own board, without flipping into Wave to chase one number.

Pair with Mailchimp

Segment Mailchimp audiences on Wave payment behaviour

Wave customers are segmented in Mailchimp by paid vs overdue, by lifetime spend and by months since last invoice. Re-engagement and upsell campaigns target customers based on what they paid, not on a generic list.

Pair with Calendly

Trigger Wave invoices from Calendly bookings

A confirmed Calendly booking for a paid session creates the matching Wave customer and draft invoice with the right rate and tax. The freelancer or coach is not building invoices by hand the day after every consult.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Wave data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Wave to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Wave connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does the sync cover multiple Wave businesses on one account?

Yes. Each Wave business lands in its own schema, with a shared customer and chart-of-accounts dimension on top. Founders running more than one entity on Wave get per-entity reporting and a consolidated view at group level.

Are Wave Payments processing fees part of the data?

Yes. Wave Payments fees per charge come across with the invoice and the settlement, including the higher Amex rate. Card-fee drag per customer, per month and per channel can be reported in the warehouse without re-deriving the fee table by hand.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Wave setup and the systems around it. Together we pick the first thing worth building.