Stop rebuilding the client workbook every month: the same figures in the sheet, the report and the client review
The close is not the slow part. The slow part is the export, the cleanup, the paste into last month's workbook, the variance commentary and a second pass to check the figures in it, for every client. Quiriz connects QuickBooks Online read-only, stores each definition once, and delivers the P&L table, budget vs actual, AR aging and the client deck from the same numbers. Next month is a refresh.
A client pack goes wrong in small ways: a subtotal row summed on top of its accounts, a figure in the commentary that no longer matches the table after a late invoice, a number pasted into an AI chat whose answer changes the next time you ask. Quiriz keeps the definition of Net income, Gross margin or Overdue receivables in one place and uses it everywhere you report.
What you get
- The monthly pack stops being rebuilt. The P&L, budget vs actual and AR aging tables are formulas. The client review deck is built once and refreshed with Refresh all next month. No export, no cleanup, no paste.
- The same figure in the workbook, the Word report and Slack. When QuickBooks connects, Quiriz adds its datasets and metric definitions to Company Context. The Excel cell, the Word sentence, the slide and the Slack thread all use them. An admin can edit a definition, and the daily refresh never overwrites an edit.
- Nothing in the books is ever changed. The connection is read-only. Quiriz reads the reports and lists, never posts or edits an entry, and does not replace the books.
- Commentary figures stay tied to the table. In Word, the figures in your sentences are live. When an actual changes after a late invoice, the sentence that quotes it changes with it.
- Your whole team on one subscription. Staff use the admin's keys in the add-ins and the admin's Slack binding. There is no per-seat fee for people who only ask questions.
How it works for a bookkeeper
- Connect. Connect QuickBooks Online with the client's authorization, or upload an export to start. Connectors are included on Plus, Pro and Max.
- Quiriz sets up the datasets and definitions. Profit and loss, Balance sheet, Ledger, Open invoices and Open bills arrive with the metrics below. You review them in Company Context and edit any that do not match the client's chart of accounts.
- Ask where you already work. A formula in Excel or Sheets, a live Figure in Word or Docs, a deck in PowerPoint or Slides, or a question in Slack.
- Deliver. A client workbook table, a month-end report with live figures, a review deck with editable charts.
- Keep it current. QuickBooks data refreshes once a day, and a scheduled data refresh keeps it so. Recalculate the sheet, refresh the report, or press Refresh all in the deck.
The books' numbers come pre-defined
These are the names Quiriz stores when QuickBooks connects. Each is a stored definition with its assumption written down. The full list is on the QuickBooks connector page.
| Metric | Name in Quiriz | The assumption behind it |
|---|---|---|
| Revenue | Revenue | Income accounts by month, on the company's QuickBooks report basis, accrual or cash. |
| Gross profit and margin | Gross profit, Gross margin | Revenue minus cost of goods sold. Margin is gross profit divided by revenue. |
| Operating expenses | Operating expenses | Expense accounts by month. Not cost of goods sold, and not other expenses. |
| Net income and margin | Net income, Net margin | Every income and expense account by month: QuickBooks' net income, divided by revenue for the margin. |
| Cash balance | Cash balance | Bank accounts at the newest month-end. A point in time, so month-ends are never added together. |
| Receivables | Open receivables, Overdue receivables | From the A/R aging detail, as of today. Overdue means past its due date. |
| Payables | Open payables | From the A/P aging detail, as of today. |
Quiriz also stores Cost of goods sold and Operating income. The basis column follows the company's own QuickBooks setting, so a cash-basis client and an accrual-basis client each match their own reports.
Budget vs actual, without the blank page
Keep the budget in a spreadsheet and share the file or folder with Quiriz once; a Google Sheet, a Google Drive folder and a OneDrive folder can sync on a schedule. Then ask for the variance by account against the QuickBooks profit and loss. The formula is the usual one: variance = actual minus budget, and for an expense a positive variance is unfavorable.
| Line | Budget | Actual | Variance | Variance % |
|---|---|---|---|---|
| Revenue: project work | 12,000 | 15,500 | +3,500 | +29.2% |
| Contractors | 9,000 | 10,200 | +1,200 | +13.3% |
| Marketing | 8,000 | 9,450 | +1,450 | +18.1% |
Illustrative figures for one month of a small services business, with the lines on budget left out. Sorted by dollars, the large lines lead. A 13% overrun on $9,000 is $1,200 of cash, which matters more than a 40% overrun on a $300 subscription. Revenue is $3,500 over and the two expense lines are $2,650 over, so these three lines net to $850 favorable.
- Excel:
=QUIRIZ.ASK("variance by account for last month, actual profit and loss against the budget, only lines over $1,000 and 10%", "table") - Google Sheets:
=QUIRIZ("net income and gross margin by month this fiscal year", "table"). The Google spelling has no dot.
The walk-through, including how to choose a materiality threshold and how to tell timing from a real change, is in Budget vs actual report: how to read it, calculate variance and write the commentary.
The client workbook, as a table you refresh
The export keeps its print layout, so the cleanup is always the same: delete the title rows, remove the subtotals, convert text to numbers. A connected table skips all of it. Each of these returns one tidy table that recalculates against the refreshed books.
| Ask | What comes back |
|---|---|
| Profit and loss by month, income and expenses by account | One row per account per month. No subtotal rows to double-count. |
| Net income, gross margin and net margin by month this fiscal year | One row per month, on the same definitions every client sheet uses. |
| Open invoices past due by customer, oldest first | The AR aging detail: who owes what and how late, so you chase in order of overdue amount. |
| Revenue by customer, and spend by vendor, this year | From the general ledger, one row per customer or vendor. |
| Cash balance by month | Bank balances at each month-end, never summed across months. |
- Excel:
=QUIRIZ.ASK("overdue receivables by customer, with days past due", "table") - Slack: bind a channel and ask "who owes us more than 60 days?" in a thread, with the chart. Slack is included from the Plus plan.
More on the export itself: QuickBooks export to Excel. On the reports: analyzing the P&L by month and the AR aging report.
The month-end report and the client review
- The report, in Word or Google Docs. In Word, put revenue, net income and overdue receivables into your sentences as live Figures and lock them so nobody types over a number. When the books change, refresh and the sentence follows. In Docs, type "open receivables by customer" where the table belongs and press Table.
- The client review deck, in PowerPoint or Google Slides. Make a deck (Beta) plans the slides first, so you edit titles and questions before it builds, and the charts are editable. Next month, Refresh all updates every figure and chart instead of rebuilding the deck.
Install: Excel, Word, PowerPoint, Sheets, Docs, Slides.
Make a deck: a prompt to try
Monthly client review
PowerPoint. Tick the client's QuickBooks Profit and loss, Balance sheet and Open invoices datasets.
"Monthly review for this client, last month against the same month last year. Revenue, gross margin, operating expenses and net income for both months, the five expense accounts that grew the most, net income by month this fiscal year, cash balance by month, and open and overdue receivables by customer. End with questions to ask the owner."
You get a plan of slide titles and questions to edit first. Then it builds roughly a summary slide, a table for the two months, a chart of net income by month, the accounts that grew, cash by month and receivables by customer, each with takeaways written from that slide's own figures. Save it once per client. Before each review, press Refresh all.
What it will not do
- Explain why a line moved. The cause of a variance is a fact about the client's business. Quiriz shows that marketing ran over and by how much. Whether the campaign was extended on purpose is yours to write.
- Post or change anything in QuickBooks. It reads. Reclassifying an entry, posting an adjustment or matching a bank feed still happens in QuickBooks. It does not replace the books.
- Reach back past the history it holds. Profit and loss and Balance sheet cover this fiscal year and the two before it. The general ledger starts later if the ledger line cap is reached, so check its earliest date before leaning on an old year.
- Pool several clients' books in one company. Each Quiriz company connects one QuickBooks account, so each client whose books you connect is its own company. Several companies under one login is on Max.
Also worth knowing: a custom grouping in the client workbook, such as your own roll-up of accounts, has to be written down once, in Company Context or in the sheet. Check the first month against your usual export, line by line, and confirm the report basis matches.
QuickBooks, Harvest and other sources
- QuickBooks Online: profit and loss and balance sheet by month, the general ledger, open invoices and open bills. Read-only, refreshed daily.
- Harvest: if you bill clients for time, hours, unbilled amounts, invoices and project budgets sit beside the books. Combining Harvest and QuickBooks covers the join.
- Anything else: upload Excel, CSV, PDF or images with tables, by upload, email or Slack. A OneDrive, Google Sheets or Google Drive folder can sync on a schedule once you share it with Quiriz. Messy Excel with headers not in row 1 is detected on import.
Metrics that span sources, such as a client's collected revenue against what Harvest billed, are ones you define yourself once in Company Context. They are not on the pre-defined list above. The connectors hub explains how.
Why the number holds still
Quiriz routes the question to a stored definition that compiles to SQL, so Net income means the same thing on the day you built the pack and the day the client asks about it. An admin approves a company's key questions, and their answers are cached, so the same question returns the same answer on every surface. If a definition stops compiling, for example after an account is renamed, admins are alerted. That is the difference between asking an AI about a pasted export, where the answer can change next month, and a figure that traces back to its rule. See also QuickBooks AI and QuickBooks MCP for the options compared.
Pricing
Free is $0 for 5 files. Connectors, Slack and scheduled reports start on Plus at $12 a month ($120 a year); Pro is $30 and Max is $60 a month. You pay for the workspace and the person who builds it, not per seat asking questions. Managing several client companies under one login is on Max. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- Budget vs actual report: variance, materiality and the commentary
- QuickBooks export to Excel: stop rebuilding the client workbook by hand
- QuickBooks profit and loss by month
- QuickBooks AR aging report: who owes you
- QuickBooks AI: ask your books questions
- QuickBooks MCP: three ways to ask Claude about your books
- Combining Harvest and QuickBooks exports
- Quiriz for agencies: every client's numbers, a deck per client
- All guides →
Questions
How do I get QuickBooks data into Excel without rebuilding the client workbook every month?
=QUIRIZ.ASK("profit and loss by month, income and expenses by account", "table") returns one row per account per month, with no title rows or subtotal lines to delete, and it recalculates against the refreshed books. Check the first month against your usual export, line by line, and confirm the report basis matches.