Asking questions

The read tools answer the questions posting needs: what’s this account called, which invoices are open, what bills were entered in March. Two more paths cover everything else — QuickBooks’ own reports, and SQL against a local copy of the file.

​

Running a report

Anything a client would recognise as a statement — a profit and loss, a balance sheet, a trial balance, an A/R aging, job profitability — is one request: “Run a P&L for the first quarter, compared to last year.” The agent calls qb_report, which runs QuickBooks’ own report engine against the open file. The answer uses the file’s account hierarchy, its item-to-account mappings, its accrual-or-cash basis, and its fiscal calendar, so the numbers are the ones the client sees on their screen. Ask what reports are available and the agent fetches the catalogue.

​

Questions no report covers

“Which vendors did we spend more with this year than last” or “margin by class by quarter” need joins and totals, and QuickBooks has no query language to express them. For those, Zeno keeps a local copy of your company file — synced with qb_sync_mirror, queried with SQL the agent writes from a plain-language question. Your first questions walks it end to end: syncing a client, asking, and spanning every synced client in one query with QuickBooks closed. The rest of this page is what to know once you’re relying on the answers. The sync reads the open company file, so a long date range takes minutes, and it waits its turn behind any batch that’s running. Querying needs no QuickBooks session at all.

​

What it can’t do to your books

The copy is a separate file, opened read-only. A query can’t write to it, can’t reach the company file, and can’t reach your run journal. The worst a wrong query does is return the wrong rows. Postings never go through this path. They go through plan and approve, against QuickBooks itself.

​

Checking how stale it is

Anything posted since the last sync is missing from the copy. “How fresh is the mirror?” That reports each table, its row count, when it was last filled, and what date range it covers. Sync again before relying on an answer that has to include this morning’s work.

​

Where the copy lives

%LOCALAPPDATA%\Zeno\qb-mcp\mirror\, one file per company, next to the run journal but separate from it. Deleting a file there is a complete reset. The next sync rebuilds it, and nothing else is affected — the run journal that records what you posted is a different file entirely. To rebuild rather than add to it — after restoring a backup, or a heavy cleanup in QuickBooks — ask for a rebuild and the old copy is dropped first.

​

Money is stored in cents

Every amount in the mirror is an integer number of cents, and the agent converts to dollars at the end of a calculation rather than the start. A hundred ten-cent amounts summed as decimals give 9.99999999999998. A total that’s nearly right is worse than one that’s obviously wrong, because it survives review — so the mirror never holds a fractional amount.