Home / Bookkeepers and accountants
For bookkeepers, fractional controllers and small accounting firms on QuickBooks Online

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.

Try it on sample books → No signup, no QuickBooks login, nothing to install.

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

How it works for a bookkeeper

  1. Connect. Connect QuickBooks Online with the client's authorization, or upload an export to start. Connectors are included on Plus, Pro and Max.
  2. 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.
  3. 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.
  4. Deliver. A client workbook table, a month-end report with live figures, a review deck with editable charts.
  5. 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.

MetricName in QuirizThe assumption behind it
RevenueRevenueIncome accounts by month, on the company's QuickBooks report basis, accrual or cash.
Gross profit and marginGross profit, Gross marginRevenue minus cost of goods sold. Margin is gross profit divided by revenue.
Operating expensesOperating expensesExpense accounts by month. Not cost of goods sold, and not other expenses.
Net income and marginNet income, Net marginEvery income and expense account by month: QuickBooks' net income, divided by revenue for the margin.
Cash balanceCash balanceBank accounts at the newest month-end. A point in time, so month-ends are never added together.
ReceivablesOpen receivables, Overdue receivablesFrom the A/R aging detail, as of today. Overdue means past its due date.
PayablesOpen payablesFrom 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.

LineBudgetActualVarianceVariance %
Revenue: project work12,00015,500+3,500+29.2%
Contractors9,00010,200+1,200+13.3%
Marketing8,0009,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.

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.

AskWhat comes back
Profit and loss by month, income and expenses by accountOne row per account per month. No subtotal rows to double-count.
Net income, gross margin and net margin by month this fiscal yearOne row per month, on the same definitions every client sheet uses.
Open invoices past due by customer, oldest firstThe 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 yearFrom the general ledger, one row per customer or vendor.
Cash balance by monthBank balances at each month-end, never summed across months.

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

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

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

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.

Ask the sample books → Then connect QuickBooks, or try your own export and check the P&L against the report you sent last month.

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

Questions

How do I get QuickBooks data into Excel without rebuilding the client workbook every month?
Connect QuickBooks Online once and ask for the table instead of exporting the report. In Excel, =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.
Can AI produce a budget vs actual report from QuickBooks?
Yes, for the figures. Keep the budget in a spreadsheet and share it with Quiriz, then ask for the variance by account against the QuickBooks profit and loss, with a threshold such as lines over $1,000 and 10%. Quiriz returns the lines and the amounts. It cannot know why a line moved, so the cause in the commentary stays yours.
Will Quiriz change anything in the books?
No. The QuickBooks connection is read-only. Quiriz reads the reports and lists, never posts or edits an entry, and does not replace the books. Data refreshes once a day.
Which QuickBooks data does it read?
Five datasets: Profit and loss and Balance sheet by month, the general ledger, open invoices (the A/R aging detail) and open bills (the A/P aging detail). The profit and loss and balance sheet follow the report basis, accrual or cash, that the company already uses in QuickBooks. History covers the current fiscal year and the two before it.
Can I ask Claude or ChatGPT about QuickBooks instead?
You can paste an export, or run an open-source QuickBooks MCP server, which needs an Intuit developer app, OAuth and a local install. Either works for one question. For a monthly client pack the problem is getting the same answer next month: Quiriz stores each definition, such as Net income or Overdue receivables, once, and every report, add-in and Slack thread uses it.
Does Quiriz write the variance commentary?
It supplies the figures, and in Word it keeps the figures inside your sentences live, so a corrected number updates the sentence that quotes it. The cause of a variance is a fact about the client's business. Quiriz can show that marketing ran over and by how much, not whether the campaign was extended on purpose.
Can I use it for several clients?
Each Quiriz company connects one QuickBooks account, so each client whose books you connect is its own company. Several companies under one login, with a Clients portfolio view, is on Max only.
Does my staff need a license to see the numbers?
No. Team members use the admin's keys in the add-ins and the admin's Slack binding, so there is no per-seat fee for people who only ask questions. Plus allows 5 add-in keys, Pro 10 and Max unlimited.
Where does the client data go?
Your files stay yours, and we do not train on your data. The QuickBooks connection is read-only. The privacy policy has the detail.