QuickBooks logo

Billing & revenue integration

QuickBooks reporting & revenue

Turn invoicing, payments, expenses, and cash flow analytics into 122 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with QuickBooks in Maven

Maven models QuickBooks into 122 governed metrics from the semantic layer. Track Bill Count, Billed Amount, Canonical Invoiced Amount, Document Amount and Document Amount Delta, break results down by Account, Direction, Document Type and Document Source, and report QuickBooks alongside HubSpot CRM, Shopify and Google Analytics 4 without rebuilding exports or metric logic for every report.

What you can measure

122 QuickBooks metrics you can use consistently

Maven keeps QuickBooks numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

Bill Count

Count of current QuickBooks accounts-payable bills

Billed Amount

Total amount on current QuickBooks accounts-payable bills

Canonical Invoiced Amount

Invoice amount on source-of-truth (canonical) invoice rows

Document Amount

Total amount on finance documents. Filter by direction (AR/AP) and document_source.

Document Amount Delta

Source invoice amount minus matched QuickBooks amount. Canonical measure; filter by document_source / line_source / direction for one source.

Document Balance

Amount still outstanding on finance documents. Filter by direction (AR/AP).

Document Collected Amount

Amount collected against finance documents (ServiceTitan invoices, NetSuite transactions).

Document Count

Number of finance documents. Filter by direction and document_type.

Document Discount

Discount on finance documents (ServiceTitan invoices).

Show all 122 metrics

Document Match Confidence

. Canonical measure; filter by document_source / line_source / direction for one source.

Document Matched Amount

. Canonical measure; filter by document_source / line_source / direction for one source.

Document Matched Balance

. Canonical measure; filter by document_source / line_source / direction for one source.

Document Outstanding Delta

. Canonical measure; filter by document_source / line_source / direction for one source.

Document Record Count

Invoice rows including inactive records. Canonical measure; filter by document_source / line_source / direction for one source.

Document Row Count

Rows on the merged AR/AP documents surface. Canonical measure; filter by document_source / direction for one source.

Document Subtotal

Document subtotal before tax and discount (ServiceTitan invoices).

Document Tax Amount

Tax charged on finance documents.

Field Service Collected Revenue

Active invoice total less current outstanding balance

Active Field Service Invoices

Active field-service invoices

Invoice Discount

Active invoice discounts

Invoice Records

Invoice rows including inactive records

Invoice Subtotal

Active invoice subtotal before tax and discounts

Invoice Tax

Active invoice sales tax

Field Service Invoice Total

Active invoice total in business-unit currency

Field Service Outstanding Balance

Outstanding active invoice balance

Finance Txn Amount Remaining

Amount remaining on NetSuite transactions

Invoice Tax

Tax charged on issued invoices

Invoiced Amount

Total invoice amount issued across connected invoicing platforms

Match Confidence

Sum of invoice reconciliation match confidence (QuickBooks to Harvest twins)

Matched Quickbooks Amount

Amount of the matched QuickBooks twin invoice

Matched Quickbooks Due Amount

Outstanding balance of the matched QuickBooks twin invoice

Netsuite Amount Paid

Amount paid on NetSuite transactions

Netsuite Total Amount

Total amount of NetSuite transactions

Opex Amount

Operating expenses / purchases from connected finance platforms

Outstanding Amount

Outstanding invoice balance still owed

Outstanding Payables

Outstanding balance on current QuickBooks accounts-payable bills

Reconciliation Amount Delta

Source invoice amount minus matched QuickBooks amount

Recon Due Amount

Outstanding balance on reconciled source invoices

Recon Outstanding Delta

Source invoice balance less the matched QuickBooks balance

Recon Tax Amount

Tax on reconciled source invoices

Amount Applied

Payment amount applied to linked invoices

Cash Collected

QuickBooks-canonical cash collected from payments (payments union is QB-first)

Payment Amount

Gross payment amount. Filter by direction: in is cash received from customers, out is cash paid to vendors.

Payment Application Count

Number of payment-to-document applications.

Payment Applied Amount

Amount of payments applied to invoices (direction in) or bills (direction out).

Payment Count

Number of payments.

Payment Net Amount

Payment amount net of fees and refunds.

Payment Refunded Amount

Amount refunded on payments.

Finance Payment Row Count

Rows on the merged payments surface (payment and application rows). Canonical measure; filter by direction and payment_row_type.

Payment Net Amount

Successful payment amount less refunds

Payment Refunded Amount

Refunded amount on payment headers

Vendor Payment Amount

Cash paid to vendors on QuickBooks bill-payment headers

Vendor Payment Applied Amount

Bill-payment amount allocated to linked QuickBooks bills

Vendor Payment Count

Count of current QuickBooks bill payments

P&L Account Amount

Natural-sign P&L amount per account (as posted)

P&L Cost of Goods Sold

Cost of goods sold accounts by entity/account/month

P&L Operating Expenses

Operating expense accounts by entity/account/month

P&L Income

Income-statement revenue (Income accounts) by entity/account/month

P&L Net Income

Signed net income impact (income positive; COGS/expense negative)

P&L Other Expenses

Other expense accounts by entity/account/month

P&L Other Income

Other income accounts by entity/account/month

QBO Reported P&L Amount

QuickBooks ProfitAndLoss reported amount per account/month

P&L Reconciliation Delta

Reconstructed minus reported P&L amount (should be ~0)

P&L Recon Reconstructed

Reconstructed P&L amount (from GL detail) for reconciliation

P&L Recon Reported

QuickBooks reported P&L amount for reconciliation

Retail Reconciliation Accounting Income

QuickBooks accrual-basis Income-account revenue for the reconciliation month

Retail Reconciliation Accounting Journal Entry Income

QuickBooks accrual-basis Income-account postings made by journal entry (reclasses, true-ups, year-end adjustments) in the reconciliation month; included in retail_recon_accounting_income

Retail Reconciliation POS Gross Revenue

Non-cancelled KORONA POS gross revenue including tax in the reconciliation month (the pos_daily_sales pos_gross_revenue definition)

Retail Reconciliation POS Net Revenue

Non-cancelled KORONA POS net revenue before tax in the reconciliation month (the pos_daily_sales pos_net_revenue definition); the tax-inclusive figure is retail_recon_pos_gross_revenue

Retail Reconciliation POS Transactions

Distinct non-cancelled KORONA POS transactions represented

Retail Reconciliation Revenue Delta

POS net revenue minus QuickBooks accrual-basis Income-account revenue; NULL for months whose accounting scope is unscoped (more than one QuickBooks company connected without a POS mapping)

Retail Reconciliation Revenue Delta Rate

POS-to-accounting revenue variance divided by accounting income

Accounting Journal Entry Income

QuickBooks accrual-basis Income-account postings made by journal entry (reclasses, true-ups, year-end adjustments) in the reconciliation month; included in retail_recon_accounting_income

POS-to-Accounting Revenue Delta

POS net revenue minus QuickBooks accrual-basis Income-account revenue; NULL for months whose accounting scope is unscoped (more than one QuickBooks company connected without a POS mapping)

POS-to-Accounting Revenue Delta Rate

POS-to-accounting revenue variance divided by accounting income

AR Balance

Open accounts receivable balance in aging buckets

AR Invoice Count

Count of open invoices in AR aging

Days Past Due

Cashflow Cash Collected

QuickBooks-canonical cash collected component for cashflow reporting

Cashflow Ending AR

As-of-today open AR snapshot on the cashflow date grain (non-zero on as_of_date only)

Cashflow Invoiced Amount

Invoice amounts issued for cashflow reporting

Workspace Cash Collected

Monthly QuickBooks-canonical cash collected for workspace profitability

Workspace Delivery Billable Amount

Monthly delivery billable amount from time tracking

Workspace Delivery Cost Amount

Monthly delivery cost from time tracking

Workspace Ending AR

As-of-today open AR snapshot attributed to the current month only (not historical month-end AR)

Workspace Opex Amount

Monthly operating expenses for workspace profitability

Workspace Profitability Billable Hours

Workspace Profitability Hours Logged

Workspace Revenue Issued

Monthly canonical invoice revenue for workspace profitability

Bill Line Amount

Amount on current QuickBooks bill item/account lines

Bill Line Count

Count of current QuickBooks bill item/account lines

Bill Line Quantity

Quantity on current QuickBooks item-based bill lines

Billing Line Chargeback Amount

Approved chargebacks allocated to billing lines

Billing Line Chargeback Reversal Amount

Approved chargeback reversals allocated to billing lines

Billing Line Credit Amount

Approved credits allocated to billing lines

Billing Line Discount

Discount allocated to billing transaction lines

Billing Line Net Total

Billing line total less approved refunds credits and chargebacks plus reversals

Billing Line Refund Amount

Approved refunds allocated to billing lines

Billing Line Subtotal

Billing line subtotal before discount and tax

Billing Line Tax

Tax allocated to billing transaction lines

Billing Line Total

Billing line total after discount and tax before adjustments

Billing Transaction Item Count

Calculated Paddle transaction line count

Billing Transaction Quantity

Quantity sold on calculated Paddle transaction lines

Document Line Amount

Line amount across invoice, bill and billing transaction lines. Filter by direction (AR/AP) and line_source.

Document Line Chargeback Amount

Approved chargebacks allocated to billing lines. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Chargeback Reversal Amount

Approved chargeback reversals allocated to billing lines. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Count

Number of finance document lines.

Document Line Credit Amount

Approved credits allocated to billing lines. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Discount

Discount on finance document lines.

Document Line Net Total

Billing line total less approved refunds credits and chargebacks plus reversals. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Quantity

Quantity on finance document lines.

Document Line Refund Amount

Approved refunds allocated to billing lines. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Row Count

Rows on the merged document-lines surface. Canonical measure; filter by line_source for one source.

Document Line Subtotal

Billing line subtotal before discount and tax. Canonical measure; filter by document_source / line_source / direction for one source.

Document Line Tax

Tax on finance document lines.

Invoice Line Amount

Revenue amount on current QuickBooks sales-item invoice lines

Invoice Line Count

Count of current QuickBooks sales-item invoice lines

Invoice Line Discount

Discounts allocated to current invoice lines

Invoice Line Quantity

Quantity sold on current QuickBooks sales-item invoice lines

Invoice Line Tax

Tax allocated to current invoice lines

GL Amount

General-ledger posting-line natural amount

GL Net Income Impact

Signed net-income impact of GL posting lines

Questions you can ask

Just ask Maven about QuickBooks

Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.

Show Harvest outstanding invoices by client

Report templates

QuickBooks reports for the next client review

Use QuickBooks reporting templates to see what needs attention, what can be trusted, and which optional fields need cleanup before the next review.

Maven report template

Profit & Loss Report

Build an accountant-grounded monthly and year-to-date P&L with entity comparisons, closed-period trends, and reconciliation controls.

Profit & lossQuickBooksFinancial controls

Requires governed QuickBooks reported P&L, reconstructed monthly P&L, and reconciliation data. POS-to-accounting revenue reconciliation appears only when a compatible governed POS source is also available.

Connection and sync

What Maven pulls from QuickBooks

You connect QuickBooks by signing in to it and approving access, so nobody shares a password. The first QuickBooks sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Invoices

Invoices — amounts, dates, customer refs.

Fields: doc number, customer name, email status, print status, txn date, due date, total amount, balance, status, currency, and 2 more

Payments

Payments received (one row per payment; allocations live in payment_links).

Fields: customer name, txn date, total amount, payment method, currency, created at, updated at

Payment links

Payment→invoice LinkedTxn allocations (payment TotalAmt stays on payments table).

Fields: line index, linked txn index, linked txn type, amount, payment updated at

Expenses

Purchases and expenses.

Fields: vendor name, txn date, total amount, payment type, account name, currency, created at, updated at

Invoice lines

Versioned sales-item lines at invoice × line index grain.

Fields: line index, detail type, description, amount, quantity, unit price, item name, service date, class name, tax code, and 1 more

Customers

Active and inactive customer hierarchy, lifecycle, balance, and geography.

Fields: display name, company name, given name, family name, email, phone, is sub customer, is active, balance, open balance with jobs, and 11 more

Vendors

Active and inactive vendor identity, terms, balance, and geography.

Fields: display name, company name, given name, family name, email, phone, term name, is 1099 vendor, is active, balance, and 7 more

Items

Active and inactive product/service catalog with hierarchy and inventory economics.

Fields: name, description, purchase description, sku, item type, is active, is taxable, unit price, purchase cost, quantity on hand, and 6 more

Bills

Accounts-payable bill headers with vendor, due date, balance, and terms.

Fields: doc number, vendor name, txn date, due date, total amount, balance, status, currency, ap account name, sales term name, and 3 more

Bill lines

Versioned bill item/account lines at bill × line index grain.

Fields: line index, detail type, description, amount, quantity, unit price, item name, account name, customer name, class name, and 4 more

Bill payments

Bill payment headers at one row per payment.

Fields: doc number, vendor name, txn date, total amount, payment type, payment account name, currency, created at, updated at

Bill payment links

Bill-payment allocations at payment × bill link grain.

Fields: line index, linked txn index, linked txn type, amount, bill payment updated at

Deletions

Change Data Capture tombstones retained separately from last-known entity rows.

Fields: entity type, deleted at

Company info

Fields: company name, legal name, country, fiscal year start month, home currency

Preferences

Company preferences — class/department tracking + multicurrency flags.

Fields: class tracking, department tracking, department terminology, multicurrency enabled

Accounts

Chart of accounts — the P&L account-type classifier + hierarchy.

Fields: account number, name, fully qualified name, account type, account sub type, classification, is active, currency, created at, updated at

Classes

QBO Classes — a candidate business-entity axis.

Fields: name, fully qualified name, is active, created at, updated at

Departments

QBO Departments/Locations — a candidate business-entity axis.

Fields: name, fully qualified name, is active, created at, updated at

Journal entries

Journal entry headers (adjustment lineage; not summed into P&L).

Fields: doc number, txn date, is adjustment, private note, total amount, currency, created at, updated at

Journal entry lines

Journal entry lines.

Fields: line index, description, amount, posting type, account name, class name, department name, entity type, entity name, journal entry updated at

Profit and loss

QBO ProfitAndLoss summary (per account × month/class column); account_id=realm_id scopes the date-window MERGE.

Fields: report basis, entity axis, period start, period end, column title, section path, row type, ledger account name, amount, currency

Profit and loss detail

QBO ProfitAndLossDetail (one row per posting transaction line); account_id=realm_id scopes the date-window MERGE.

Fields: report basis, txn date, transaction type, doc number, counterparty name, class name, department name, memo, split account, ledger account name, and 3 more

How it works

Connect QuickBooks to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

Connect QuickBooks

In the client’s workspace, open Sources, add QuickBooks and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.

Step 2

Maven syncs and models the data

Maven pulls the client’s QuickBooks data (12 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.

Works well with

Report QuickBooks alongside the rest of your stack

FAQ

QuickBooks reporting questions

What QuickBooks metrics can I report on in Maven?

Maven exposes 122 governed QuickBooks metrics, including Bill Count, Billed Amount, Canonical Invoiced Amount, Document Amount, Document Amount Delta and Document Balance — each defined once so it means the same thing in every report.

What can I break QuickBooks performance down by?

You can break QuickBooks metrics down by Account, Direction, Document Type, Document Source, Document Number, Due date, Status and Counterparty Role, and more.

Can I combine QuickBooks with other data sources?

Yes. QuickBooks sits in the same client workspace as sources like HubSpot, Shopify, Google Analytics 4 and Google Ads, so one report or question can use them together.

What QuickBooks data does Maven sync?

Maven syncs invoices, payments, payment-to-invoice applications, expenses, active and inactive customers and active and inactive vendors, and more from QuickBooks.

How often does QuickBooks data sync to Maven?

Maven refreshes QuickBooks on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.

Is my QuickBooks data secure with Maven?

Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.