QuickBooks Loan Manager's "What If" Scenarios: A Practical Walkthrough

QuickBooks Desktop has long shipped with a built-in Loan Manager that handles amortization schedules and payment tracking, but a recurring question in the community makes it clear that not everyone realizes the same window also functions as a planning tool. Users routinely ask how to model hypothetical changes — a different interest rate, a higher payment, a full refinance — without disturbing the live loan record already sitting in their company file. The feature exists, and the accepted answer walks through each available scenario in turn.

Where to Find It

The tool lives under the Banking menu. Selecting Loan Manager opens the primary loan dashboard, and from there a button labeled What If Scenarios opens the planning window. Everything done inside this window is strictly exploratory — nothing written here touches the actual loan or any other part of the company file. That separation is the entire point: users can experiment freely and discard the results.

The Five Available Scenarios

Once the What If window is open, QuickBooks presents a dropdown of scenario types. Each one recalculates key figures — payment amount, maturity date, total payments, total interest, and any balloon payment — based on the hypothetical inputs the user enters.

Changing the Payment Amount

Users who want to see what happens if they pay more (or less) each period select the loan in question, enter a new payment figure in the New Loan column, and click Calculate. QuickBooks returns the revised maturity date along with updated totals for payments, interest, and balloon amounts. This is the scenario to use when weighing an accelerated payoff against keeping cash on hand.

Changing the Interest Rate

This scenario answers the question every borrower asks when market rates move: what would a different rate mean for the monthly payment? The user selects the loan, enters a hypothetical rate, and clicks Calculate. The output focuses on the new payment amount and the long-term interest total, which makes it useful for deciding whether refinancing to a lower rate is worth the closing costs.

Modeling an Entirely New Loan

For users considering a fresh borrowing arrangement rather than a modification of an existing one, the “How much will I pay with a new loan?” option accepts full loan details — principal, rate, term — in the New Loan column. Clicking Calculate produces the standard set of outputs: payment amount, total payments, total interest, and balloon payment if applicable.

Refinancing an Existing Loan

The refinance scenario pre-populates the Amount Borrowed field with the remaining balance on the selected loan, since that figure represents what the user would typically refinance. Anyone looking to roll in additional borrowing can simply overwrite that amount with the larger figure they have in mind. The accepted answer notes one practical wrinkle: if the origination date for the new loan is not yet known, the user should enter an estimated date so the calculation can proceed. The exact date can be refined later.

Comparing Two New Loans Side by Side

Perhaps the most useful scenario for anyone shopping lenders, this option provides two input columns — New Loan #1 and New Loan #2 — so users can enter the terms for competing offers and calculate each one in turn. If a payment amount is unknown, QuickBooks computes it automatically from the other inputs. The side-by-side comparison makes it easy to see which offer costs less over the life of the loan.

A Critical Limitation: Nothing Persists

The accepted answer includes a note that every user should read before relying on this tool for decision-making. The moment the What If Scenarios window is closed — or even when switching from one scenario type to another — every value entered is deleted. There is no draft mode, no saved-state mechanism, nothing carried forward. Users who need the calculated results for a meeting, a lender conversation, or their own records must click Print before navigating away. Once the window closes, the work is gone.

One Additional Quirk

If the loan selected in the list has a zero balance, QuickBooks trims the available scenarios down to just two: the new-loan calculation and the two-loan comparison. The payment-amount, interest-rate, and refinance options disappear from the dropdown entirely, since there is nothing left on a paid-off loan to modify. Users who find those options greyed out or missing should confirm that the loan they have highlighted still carries a balance.

For broader help with QuickBooks Desktop tools and workflows, our QuickBooks knowledge base covers common questions and troubleshooting scenarios.