# How to Export Journal Entries from QuickBooks — Into a Live Spreadsheet

You need your journal entries out of QuickBooks Online — to review adjustments, give your auditor the detail, reconcile against another system, or analyze activity by account. The native route is the Journal report or an Excel export, one download at a time, that's stale as soon as a new entry is posted.

## Why this happens in QuickBooks

QuickBooks Online will run a Journal report and export it to Excel, but that file is a fixed snapshot for the period you chose. There's no live feed of journal or general-ledger detail into a spreadsheet, so any ongoing review means re-running and re-exporting the report.

Retriever pulls your journal and general-ledger detail into Google Sheets as live data — the debits, credits, accounts, dates, and memos — and keeps it refreshing on a schedule.

## How to solve it

### 1. Connect QuickBooks to Google Sheets

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

### 2. Pull the journal or GL detail

Bring the Journal or General Ledger into a sheet for the period you need — date, entry number, account, debit, credit, name, and memo, all as columns.

### 3. Filter and analyze

Filter to a single account, a date range, or a type of entry; pivot by account; or tie the detail out against another system — the raw data is yours.

### 4. Refresh on a schedule

Scheduled refreshes pull new entries in automatically, so your working copy stays current without re-running the report.

## FAQ

### How do I export journal entries from QuickBooks Online?

QuickBooks can run a Journal report and export it to Excel as a static file. Retriever pulls the same journal and general-ledger detail into Google Sheets as live data that refreshes on a schedule.

### Can I export all journal entries for a date range?

Yes — set the period when you pull the Journal or General Ledger, and Retriever brings in every entry for that range, each field in its own column.

### Will new journal entries appear automatically?

Yes — a scheduled refresh pulls newly posted entries into the same sheet, so you never have to re-export to see the latest activity.