All articles
    Financial Analysis
    8 min read••Vetting Vault Team

    Which QuickBooks Reports Does Due Diligence Need?

    The exact QuickBooks reports, periods and settings buyers and lenders ask for, why each one matters, and the export mistakes that send a request back.

    Most small and mid-sized businesses keep their books in QuickBooks, which means most diligence requests eventually become a list of QuickBooks reports. The request itself is where deals lose a week. Ask for “financials” and you get a one-page PDF of last year's profit and loss. Ask for the right reports, with the right settings, and the first delivery is something an analyst can actually use.

    This guide covers which QuickBooks reports due diligence needs for the three situations deal professionals run into most: a buyer evaluating an acquisition, a lender underwriting an SBA acquisition loan, and a bank renewing a line of credit. For each report it gives the period, the accounting basis and the column setting to request, and why the report earns its place on the list.

    Which QuickBooks reports due diligence needs

    The core set is the same for almost every deal: a profit and loss, a balance sheet, the general ledger behind them, a trial balance, and the receivables and payables agings. What changes from one deal to the next is the period, the basis and how much detail the reviewer needs. A buyer building a quality of earnings wants transaction detail and monthly trends. A lender renewing a line of credit wants the same few reports every month, as of month end, with as little interpretation as possible.

    Interactive · Typical requests, adjust to the deal
    What to ask a QuickBooks user for, by kind of deal

    Pick the deal. Each report comes with the period, basis and column setting to request, so the export is usable the first time.

    For: A buyer, or the QoE provider working for one

    1. Profit and LossLast 3 fiscal years + year to date
      AccrualBy year

      The trend, the margins and the starting point for every EBITDA adjustment.

    2. Profit and LossTrailing 24 months
      AccrualBy month

      Seasonality, the trailing-12 figure and whether the last few months support the asking price.

    3. Balance SheetEach fiscal year end + latest month end
      AccrualBy month for the last 12

      Monthly working capital for the peg, plus debt and owner balances that come out at closing.

    4. General LedgerTrailing 12 months + last fiscal year
      AccrualTransaction detail

      Where add-backs get proven or rejected, one transaction at a time.

    5. Trial BalanceEach fiscal year end + latest month end
      AccrualSingle period

      Ties the P&L and balance sheet together and anchors the QoE workpapers.

    6. A/R Aging DetailAs of latest month end
      Invoice detail

      Which receivables will actually be collected, and how concentrated they are.

    7. A/P Aging DetailAs of latest month end
      Bill detail

      Stretched payables make cash look better than it is and shift the working capital math.

    8. Sales by Customer SummaryLast 3 fiscal years + trailing 12
      AccrualBy year

      Customer concentration, and whether the top accounts are growing or leaving.

    Show as a table
    DealReportPeriodBasisColumnsWhy it matters
    AcquisitionProfit and LossLast 3 fiscal years + year to dateAccrualBy yearThe trend, the margins and the starting point for every EBITDA adjustment.
    AcquisitionProfit and LossTrailing 24 monthsAccrualBy monthSeasonality, the trailing-12 figure and whether the last few months support the asking price.
    AcquisitionBalance SheetEach fiscal year end + latest month endAccrualBy month for the last 12Monthly working capital for the peg, plus debt and owner balances that come out at closing.
    AcquisitionGeneral LedgerTrailing 12 months + last fiscal yearAccrualTransaction detailWhere add-backs get proven or rejected, one transaction at a time.
    AcquisitionTrial BalanceEach fiscal year end + latest month endAccrualSingle periodTies the P&L and balance sheet together and anchors the QoE workpapers.
    AcquisitionA/R Aging DetailAs of latest month endn/aInvoice detailWhich receivables will actually be collected, and how concentrated they are.
    AcquisitionA/P Aging DetailAs of latest month endn/aBill detailStretched payables make cash look better than it is and shift the working capital math.
    AcquisitionSales by Customer SummaryLast 3 fiscal years + trailing 12AccrualBy yearCustomer concentration, and whether the top accounts are growing or leaving.
    SBA acquisition loanProfit and LossLast 3 fiscal yearsSame basis as the tax returnsBy yearThe lender reconciles these to the seller's tax returns and IRS transcripts, so the basis has to match the return.
    SBA acquisition loanProfit and LossYear to date + same period last yearSame basis as the tax returnsCompare to previous yearInterim results the lender can compare to last year. SBA rules want interim financials no older than 120 days.
    SBA acquisition loanBalance SheetEach fiscal year end + interim dateSame basis as the tax returnsSingle periodDebt to be paid off, owner balances, and what the buyer is actually acquiring.
    SBA acquisition loanGeneral LedgerTrailing 12 months + last 2 fiscal yearsAccrualTransaction detailOn purchases of $3M or more, the required QoE and its cash proof are built from this detail.
    SBA acquisition loanA/R Aging SummaryAs of interim daten/aAging bucketsCollectability of the receivables that support working capital after closing.
    SBA acquisition loanA/P Aging SummaryAs of interim daten/aAging bucketsPayables the buyer inherits or the seller must clear at closing.
    Line of credit renewalA/R Aging DetailMonth end, every monthn/aInvoice detailThe borrowing base: what's over 90 days and which customers exceed concentration limits.
    Line of credit renewalInventory Valuation SummaryMonth end, every monthn/aSingle periodEligible inventory for the borrowing base. Available on QuickBooks Online Plus and Advanced.
    Line of credit renewalA/P Aging SummaryMonth endn/aAging bucketsPast-due payables can signal a cash squeeze before the covenants do.
    Line of credit renewalBalance SheetQuarter endAccrualCompare to previous yearCurrent ratio, leverage and tangible net worth covenants.
    Line of credit renewalProfit and LossYear to date + same period last yearAccrualCompare to previous yearDebt service coverage and whether performance supports the renewal.
    Report names are QuickBooks Online's. Lenders and buyers add their own items, and a request built around the deal's actual questions beats a generic list every time.

    Notice how much of the value sits in the settings rather than the report names. A Profit and Loss is three different documents depending on whether it covers fiscal years or trailing months, runs on cash or accrual, and shows one total column or twelve monthly ones. Spelling those settings out is the single biggest thing you can do to get usable reports on the first try.

    The reports, and what each one is for

    It helps to know what question each report answers, both to explain the request to a business owner who wonders why you need so much, and to recognize when a substitute won't do.

    Profit and Loss
    Revenue, costs and margins over a period. By year for the trend; by month for seasonality, run-rate and the trailing-12 figure that most valuations and coverage tests start from.
    Balance Sheet
    What the business owns and owes at a point in time. Monthly balance sheets drive the working capital peg; year-end balance sheets show debt, owner balances and anything that gets settled at closing.
    General Ledger
    Every transaction behind every account. It's where add-backs are proven or rejected and where a reviewer finds the personal expense coded as supplies.
    Trial Balance
    Every account's ending balance on one page. It ties the income statement to the balance sheet and is the backbone of most QoE workpapers.
    A/R and A/P Aging
    Who owes the business money, who the business owes, and for how long. Summary versions show the buckets; detail versions show the invoices behind them.
    Sales by Customer Summary
    Revenue by customer for the period. The fastest way to see customer concentration, and whether the largest accounts are growing or quietly shrinking.

    Cash basis or accrual basis?

    QuickBooks lets the person running a report switch between cash and accrual with one setting, and that switch can change the picture considerably. On a cash basis, revenue is recorded when the customer pays and expenses when the bill is paid. On an accrual basis, revenue lands when it's earned and expenses when they're incurred, regardless of when cash moves. A business that bills heavily in December looks very different on the two bases.

    Buyers generally want accrual, because it matches revenue and expenses to the period they belong to and makes month-to-month comparisons meaningful. Lenders often need the basis the tax returns were filed on as well, since they reconcile the financials to the returns and IRS transcripts. The safest request names the basis explicitly for every report, and asks for both when the deal needs both.

    Put the settings in the request, not just the report names
    “Profit and Loss, January 2023 through September 2026, accrual basis, columns by month, exported to Excel” gets a usable report. “P&L” gets whatever the default view happened to be.

    Common QuickBooks export mistakes

    The person exporting the reports is usually the owner, an office manager or a part-time bookkeeper, not someone who has supported a diligence process before. QuickBooks' defaults are built for running a business, not for analyzing one, so the same handful of problems shows up again and again. Each one sends the request back and costs a few days.

    Interactive · Illustrative example
    Five settings decide whether the export is usable

    Fix each problem and watch the same Profit and Loss turn into something an analyst can work with. Amounts in $K.

    ProfitandLoss_2025.pdfCash basis
    Jan–Dec 2025Total
    Revenue2,310
    Total expenses2,058
    Net income252
    PDF: every number has to be retyped
    Show as a table
    Sent backReady to useWhy it matters
    Sent as a PDFExported to ExcelA PDF has to be retyped before anyone can analyze it.
    Cash basisAccrual basisCash basis moves revenue to when it's collected, so margins and trends shift month to month.
    Rows collapsedEvery account expandedA collapsed report shows one expense total, hiding the accounts where add-backs live.
    One total columnColumns by month or quarterWithout periods you can't see seasonality or build a trailing-12 figure.
    No comparison periodPrior year alongsideA single year can't show whether the business is growing or shrinking.
    Put the settings in the request itself (basis, period, columns, format) and most of these never happen. The person exporting usually isn't an accountant, and QuickBooks' defaults aren't built for diligence.

    Two of these deserve extra attention. Collapsed rows are easy to miss because the totals still look right; the report simply rolls a dozen expense accounts into one line, and the owner's vehicle, meals and family payroll disappear into “operating expenses.” And a missing comparison period means the reviewer has to request a second report just to see whether this year is better or worse than last year, which is usually the first question anyone asks.

    Periods: fiscal years, trailing months and month ends

    Three kinds of period cover almost every request. Fiscal years give the long-run trend and tie to the tax returns. Trailing months (usually 12 or 24, ending at the latest closed month) show where the business is now, which matters more to a buyer than a fiscal year that ended nine months ago. And “as of” dates, normally a month end, apply to balance sheets and agings, which describe a moment rather than a period.

    The latest closed month matters. A month the bookkeeper hasn't reconciled yet will change, sometimes materially, so ask which month is closed and set the period end there. If the deal runs long, the same reports get rolled forward a month or a quarter at a time, which is far easier when the original request spelled out every setting.

    What QuickBooks reports can't tell you

    QuickBooks reports describe what the bookkeeping says, and diligence exists to test whether the bookkeeping is right. That's why the reports are always requested alongside documents that come from outside the books: tax returns, bank statements, loan statements and a debt schedule, payroll registers, customer contracts and leases.

    • Bank statements, to tie deposits to revenue and disbursements to expenses
    • Tax returns, to confirm the income the owner reported to the IRS
    • Loan statements, to confirm the debt the balance sheet shows
    • Payroll registers, to confirm headcount and owner compensation

    The comparison between those sources and the QuickBooks reports, often formalized as a proof of cash, is where most real findings come from. A clean set of QuickBooks reports is the starting point, not the conclusion.

    Making the request easy to answer

    A good request is specific and short. List each report with its period, basis, columns and format, say why the deal needs it in a sentence, and group the items so the owner can work through them in one sitting. Owners respond much faster to a clear checklist than to an email thread, and a checklist makes it obvious what's still missing a week later.

    Better still, skip the exports. With QuickBooks requests in Vetting Vault, you choose the core reports (profit and loss, balance sheet, general ledger, trial balance, cash flows and the aging summaries), the period and the basis once, and the owner sends each one straight from QuickBooks Online with one click, so it arrives with the settings you asked for.

    Frequently asked questions

    Which QuickBooks reports does a buyer need for due diligence?

    Start with the Profit and Loss and Balance Sheet for the last three fiscal years plus year to date, a monthly Profit and Loss for the trailing 24 months, the General Ledger for the trailing 12 months and the last fiscal year, a Trial Balance at each year end, A/R and A/P Aging Detail as of the latest month end, and Sales by Customer Summary. A quality of earnings provider will usually add to that list.

    Should diligence financials be on a cash or accrual basis?

    Accrual is the default for buyers because it matches revenue and expenses to the period they belong to. Lenders often also want reports on the basis the tax returns were filed, so the financials reconcile to the returns and IRS transcripts. When in doubt, ask for both and say which is which.

    Is a PDF export from QuickBooks good enough?

    Rarely. A PDF has to be retyped before anyone can analyze it, and it loses the structure of the report. Ask for Excel exports with every account expanded, the period and basis stated, and columns by month where the analysis needs trends.

    What isn't in QuickBooks that diligence still needs?

    Tax returns, bank statements, loan statements and a debt schedule, payroll registers, customer contracts and leases all live outside the books. QuickBooks reports tell you what the bookkeeping says; those documents are how you test it.

    Ask for these reports straight from QuickBooks

    In Vetting Vault, pick the reports, the period and the basis, and each becomes its own request. The business owner connects QuickBooks Online once and sends every report with one click, or uploads the equivalent if they'd rather. You see what's still open, and Deal AI reads what arrives and cites the file behind every figure.

    Get Started Free

    See how QuickBooks requests work.