Home›Learn›QuickBooks

How to calculate QuickBooks net income by month

What accounts are included, the formula, and how to query it from QBO data

Definition

What it is

Net income in QuickBooks Online is total revenue (income accounts) minus total expenses (expense accounts) for a given period. It is the bottom-line profitability figure — equivalent to net profit — and is the primary output of the Profit and Loss (P&L) report. In QBO, income is recorded through invoices and sales receipts; expenses are recorded through bills, expenses, and journal entries against expense accounts.

Formula

Net Income Formula

Formula

Net Income = Total Revenue (Income Accounts) − Total Expenses (Expense Accounts)

In QBO data, income account entries have a positive amount in the income table; expense entries have a positive amount in the expense table. For SQL calculation: SUM invoice line amounts WHERE account type = 'Income' minus SUM expense amounts WHERE account type = 'Expense', grouped by month and year.

Business impact

Why it matters

Monthly net income trend is the most important financial health indicator for any business. A business can show strong revenue growth while net income declines — a warning sign of rising costs outpacing revenue. Tracking net income monthly, with year-over-year comparison, catches this early. For eCommerce sellers who also use Amazon or Shopify, comparing QBO net income against eCommerce revenue helps identify whether operational costs are scaling appropriately with sales growth.

The challenge

How most teams track this today

QBO's built-in P&L report shows net income but does not easily export to a format suitable for trend analysis or custom segmentation. Running month-over-month P&L comparisons in QBO requires manually adjusting date filters and copy-pasting results. Most finance teams export to Excel and build their own trend tables.

Run it on your data

Calculate this automatically with Taptic Data

Connect your QuickBooks Online account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for QuickBooks net income by month →Connect QuickBooks Online →Try Free — $29.99/mo

FAQ

Common questions

What is the difference between net income and gross profit in QuickBooks?

Gross profit is revenue minus cost of goods sold (COGS) only. Net income subtracts all operating expenses — payroll, rent, software, marketing, and other overhead — from gross profit. QBO's P&L report shows both: gross profit in the upper section, net income at the bottom after all expenses.

Why does my QBO net income differ from my bank balance?

Net income is an accrual-basis figure — it includes revenue from unpaid invoices and expenses from unpaid bills. Your bank balance is cash-basis. A business with $50,000 in unpaid invoices (income recognised but cash not received) will show higher net income than available cash. This gap is measured by accounts receivable.

Can I break down QBO net income by customer or product in Taptic?

Yes. Taptic imports QBO invoice line items with customer and item references. You can query net income contribution by customer (revenue from that customer minus any directly attributable expenses) or by product/service line item. This is not available in QBO's standard P&L report.

How does Taptic import QuickBooks data?

Taptic connects to QuickBooks Online via the QBO API and imports 8 tables: invoices, invoice line items, customers, vendors, bills, payments, expenses, and chart of accounts. The net income query joins invoice and expense tables using account type classifications from the chart of accounts.

Analytics hub

All QuickBooks queries, use cases, and SQL examples in one place.

QuickBooks Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect QuickBooks Online to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo