How to Export Your Check Register from QuickBooks — Into a Live Spreadsheet

The problem

You need your check register out of QuickBooks Online — to review spending, reconcile against a bank statement, or track what cleared and what didn't. QuickBooks shows the register on screen and can export a report to Excel, but it's a one-time file that's stale as soon as the next transaction posts.

Why QuickBooks can't do it

The QuickBooks Online check register is built for on-screen review; exporting it produces a static Excel snapshot for the account and period you chose. There's no live connection into a spreadsheet, so ongoing review means re-exporting the register every time.

Do it in Google Sheets with Retriever

Retriever pulls your check register and expense detail into Google Sheets as live data — date, payee, account, amount, and cleared status — and keeps it refreshing on a schedule.

1. Connect QuickBooks to Google Sheets

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

2. Pull the check register

   Bring the register or a transaction detail report for the bank account into a sheet: date, check/ref number, payee, account, amount, and cleared status, all as columns.

3. Reconcile and analyze

   Filter by payee or account, total spending, or tie the register out against a bank statement — the detail is real data you can sort and pivot.

4. Refresh on a schedule

   Scheduled refreshes pull new checks and payments in automatically, so the register stays current without re-exporting.

See also

Frequently asked questions