# How to Export Invoices from QuickBooks to Excel — Kept Refreshable

You need your invoices out of QuickBooks Online — to analyze what's outstanding, reconcile against a payment system, or report on billing by customer. QuickBooks can export an invoice list or report to Excel, but it's a fixed snapshot: the moment a new invoice is raised or a payment lands, the file is out of date.

## Why this happens in QuickBooks

QuickBooks Online exports invoices as a static Excel file — a report for the period you chose, with no link back to your books. There's no live feed of invoice data into a spreadsheet, so ongoing A/R analysis means re-running and re-exporting the report each time.

Retriever pulls your invoice data into Google Sheets as live data — customer, date, due date, amount, balance, and status — and keeps it refreshing on a schedule. Sheets downloads to Excel whenever you need a file.

## How to solve it

### 1. Connect QuickBooks to Google Sheets

Authorize your QuickBooks Online company in Retriever — read-only, any plan.

### 2. Pull your invoices

Bring the invoice list or an A/R report into a sheet: customer, invoice number, date, due date, amount, balance, and status, all as columns.

### 3. Analyze or reconcile

Filter to what's open, total by customer, flag overdue invoices, or tie amounts out against a payment processor — the raw data is yours to slice.

### 4. Refresh on a schedule (and download to Excel anytime)

Scheduled refreshes pull new invoices and payments in automatically; File → Download → Microsoft Excel gives you a file whenever someone needs one.

## FAQ

### How do I export invoices from QuickBooks to Excel?

QuickBooks Online can export an invoice list or report to Excel, but it's a static file. Retriever pulls your invoice data into Google Sheets as live data that refreshes on a schedule — and Sheets downloads to Excel whenever you need a file.

### Can I export all unpaid or overdue invoices?

Yes — pull the invoice data into Sheets and filter by status or balance to isolate open or overdue invoices, then refresh to keep the view current.

### Will new invoices and payments update automatically?

Yes — a scheduled refresh brings newly raised invoices and applied payments into the same sheet, so you never re-export to see the latest A/R.