QuickBooks Business Planner Profit & Loss Reports: What Each Line Means

QuickBooks users who rely on the Business Planner to forecast and model their company finances sometimes find that the generated Profit & Loss report does not behave quite like the standard income statement they are accustomed to inside the main accounting software. The report pulls figures from the underlying company data, but the way it groups, amortizes, and rounds those numbers can produce subtotals that look slightly off. Here is a breakdown of what the Business Planner is actually doing behind each line item.

Rounding and Display Quirks

The first thing to understand is that the Business Planner applies rounding based on available display space. Figures may be rounded to the nearest dollar or to the nearest cent. Because of this, the totals and subtotals shown on the report may not perfectly match the sum of the individual line items displayed above them. This is a presentation constraint, not a data-integrity problem — the underlying calculations use the full, unrounded values.

Income and Cost of Goods Sold

The top of the report follows a familiar structure. Income represents the revenue generated from selling products and services to customers, pulled from the Income section of the planner.

Directly below that is Less COGS (cost of goods sold), which captures the costs tied directly to the sale of those products or services. The planner breaks COGS into three components:

• Material: The raw material cost of the goods or services being sold.
• Labor: The additional labor costs incurred at the point of sale.
• Other: Any product or service costs not classified as material or labor.

Gross profit is then calculated simply as income minus cost of goods sold.

Operating Expenses and Non-Cash Adjustments

Below gross profit, the report lists operating expenses — the overhead required to run the business, excluding COGS. These values come from the Expenses section of the planner.

Several line items here deserve attention because the Business Planner applies its own amortization and depreciation logic rather than simply mirroring the QuickBooks chart of accounts:

Bad debt is calculated as a percentage of credit sales, based on a rate specified in the Company section of the planner.

Amortization covers start-up costs expensed each month. Other asset account balances imported from QuickBooks are amortized according to the amounts entered for Years 1, 2, and 3. Any newly introduced start-up costs entered through the Interview section are expensed evenly over a five-year period. One important exception: deposit balances are not amortized.

Depreciation handles fixed assets. Assets imported from QuickBooks data are depreciated based on the Year 1, 2, and 3 amounts entered by the user. Newly acquired fixed assets entered through the Interview section are depreciated on a straight-line basis, with useful life determined by the asset category assigned during setup.

Total operating expenses is the sum of all the above, and operating income equals gross profit minus those total operating expenses.

Interest, Taxes, and Net Income

The final section accounts for financing and tax obligations:

Interest expense reflects the cost of borrowing — specifically, the interest portion of scheduled loan payments.

Net income before taxes represents the amount by which gross profit exceeds total expenses before estimated taxes are applied. This line and the one below it apply only to C corporations.

Estimated taxes capture the portion of net income expected to go toward federal and state tax obligations, again for C corporations only.

Finally, net income is calculated differently depending on business type. For C corporations, it equals operating income minus interest expense and estimated taxes. For all other business structures, it is simply operating income minus interest expense.

Why It Matters

Understanding these distinctions is important when the Business Planner forecast is used for loan applications, investor presentations, or internal budgeting. The amortization and depreciation schedules in particular can diverge significantly from what appears on the standard QuickBooks financial statements, since the planner applies its own timelines to imported balances rather than reading existing accumulated depreciation or amortization schedules directly.

For users who need to reconcile differences between their standard financial reports and the Business Planner output, the key is to trace each imported balance back to the Year 1, 2, and 3 assumptions entered in the planner — that is where the divergence typically originates.