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
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