Invoiced to BigQuery

This page provides you with instructions on how to extract data from Invoiced and load it into Google BigQuery. (If this manual process sounds onerous, check out Stitch, which can do all the heavy lifting for you in just a few clicks.)

What is Invoiced?

Invoiced provides accounts receivable automation software that helps companies get paid faster, waste less time on collections, and provide a better customer experience. It automates billing tasks like sending out invoices, following up with late-paying customers, and reconciling incoming invoice payments. It also help businesses handle recurring billing and payment plans.

What is Google BigQuery?


Getting data out of Invoiced

Invoiced provides an API that lets developers get at customer, payment, invoicing, and other information stored in the platform. For example, to get information about a particular invoice, you would call GET /invoices/:{id}.

Sample Invoiced data


  "id": 46225,
  "object": "invoice",
  "customer": 15444,
  "name": null,
  "currency": "usd",
  "draft": false,
  "closed": false,
  "paid": false,
  "status": "not_sent",
  "autopay": false,
  "attempt_count": 0,
  "next_payment_attempt": null,
  "subscription": null,
  "number": "INV-0016",
  "date": 1416290400,
  "due_date": 1417500000,
  "payment_terms": "NET 14",
  "items": [
      "id": 7,
      "object": "line_item",
      "catalog_item": null,
      "type": "product",
      "name": "Copy Paper, Case",
      "description": null,
      "quantity": 1,
      "unit_cost": 45,
      "amount": 45,
      "discountable": true,
      "discounts": [],
      "taxable": true,
      "taxes": [],
      "metadata": {}
      "id": 8,
      "object": "line_item",
      "catalog_item": "delivery",
      "type": "service",
      "name": "Delivery",
      "description": null,
      "quantity": 1,
      "unit_cost": 10,
      "amount": 10,
      "discountable": true,
      "discounts": [],
      "taxable": true,
      "taxes": [],
      "metadata": {}
  "notes": null,
  "subtotal": 55,
  "discounts": [],
  "taxes": [
      "id": 20554,
      "object": "tax",
      "amount": 3.85,
      "tax_rate": null
  "total": 51.15,
  "balance": 51.15,
  "url": "",
  "payment_url": "",
  "pdf_url": "",
  "created_at": 1415229884,
  "metadata": {}

Preparing Invoiced data



Loading data into Google BigQuery


Keeping Invoiced data up to date



Other data warehouse options


Easier and faster alternatives


Thankfully, products like Stitch were built to move data from Invoiced to Google BigQuery automatically. With just a few clicks, Stitch starts extracting your Invoiced data via the API, structuring it in a way that's optimized for analysis, and inserting that data into your Google BigQuery data warehouse.