QuickBooks P&L to Google Sheets, automatically
By Figures · Updated June 10, 2026
The Profit and Loss is the report everyone asks for: owners before a decision, clients at month-end, you on a Monday morning. And for most of us, the place that report actually gets used is a Google Sheet, next to a budget, a forecast, or a chart. If you’re re-exporting it every week to keep that sheet honest, this is the guide for automating it.
The manual export routine, and why it doesn't stick
You know the loop: run the P&L in QuickBooks, export to Excel, import into Google Sheets, fix the formatting, repeat next week. It fails in three quiet ways. The numbers are stale by the time anyone reads them, because books change daily and exports don’t. Each re-import shifts the layout just enough to break the formulas and charts pointing at it. And the cleanup (merged headers, numbers that arrive as text) is a tax you pay on every single refresh.
Set up an automatic daily P&L sync
Figures pulls your P&L from QuickBooks Online and writes it into Google Sheets every morning, read-only. Setup is four decisions:
1. Connect QuickBooks and Google
Sign in with Google, then connect your QuickBooks company through Intuit’s official sign-in. It takes about a minute. The QuickBooks connection is read-only (Figures can never change anything in your books), and the Google permission covers only spreadsheets Figures creates or ones you pick. (The full step-by-step is in our connection guide.)
2. Choose how the P&L is laid out
Columns can summarize by month, quarter, or year, or collapse to a single total. Match how you report: monthly for operations, quarterly for a board. The period defaults to fiscal year-to-date, or set explicit start and end dates.
3. Pick the accounting basis
Accrual or cash: choose the basis you report on. The synced tab’s header states which basis it shows, so nobody has to guess. Need both? Add a second P&L sync; each gets its own tab.
4. Choose the destination and schedule
Send it to a new Google Sheet named after your company, or to any existing spreadsheet from your Drive. The default schedule is daily, in the 6:00–7:00 AM window in your time zone; weekly and manual-only are options too. The first sync runs right away and lands in a moment.
What lands in your sheet
The P&L arrives in its own tab, named “P&L ▸ Synced”. The first row is a small banner: when it last synced, the period it covers, the basis, and a note asking you not to edit that tab (Figures refreshes it; your formulas belong in your own tabs). Below that, the statement in the shape you know from QuickBooks: income, cost of goods sold, gross profit, expenses, and net, with a column per period and the same subtotals QuickBooks shows. Numbers land as numbers, ready for formulas. No text-to-number cleanup.
Build dashboards that survive the refresh
Treat the synced tab as your data layer and build everything else in your own tabs: summaries, charts, the client-facing dashboard. Each morning Figures rewrites its tab and touches nothing else, so your work persists across refreshes.
One practical tip: anchor your formulas to account names rather than fixed cell addresses (XLOOKUP or INDEX/MATCH on the account column). When a new account appears in the books, rows below it shift; a lookup keyed on “Gross Profit” keeps working, while ='P&L ▸ Synced'!B14 quietly starts reading the wrong row.
Reporting for more than one company
Bookkeeping firms rarely stop at one set of books. Connect each client’s QuickBooks company and give each its own synced P&L. Every company is a flat $10 per month with all reports included, and your dashboard shows each morning’s sync status across the whole portfolio.
Common questions
What period does the synced P&L cover?
Fiscal year-to-date by default, summarized by month. You can set explicit start and end dates instead, and summarize by month, quarter, year, or a single total.
What happens if a refresh fails?
Your sheet keeps showing the last good numbers; a failed refresh never wipes or half-writes a tab. Figures shows what went wrong and how to fix it, and if scheduled refreshes stay blocked, it emails you rather than letting the sheet go quietly stale.
Can it touch my QuickBooks data?
No. The connection is read-only by design: Figures runs reports and can never create, edit, or delete anything in your books. The details are on our security page.
Does it work with reports besides the P&L?
Yes, fifteen reports in all: Balance Sheet, Cash Flow, Trial Balance, General Ledger, P&L Detail, A/R and A/P Aging Summary, sales summaries, customer and vendor balances, Transaction List by Date, and Inventory Valuation, each in its own tab, all included in the same $10 per company.