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.
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.
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
The trend, the margins and the starting point for every EBITDA adjustment.
Seasonality, the trailing-12 figure and whether the last few months support the asking price.
Monthly working capital for the peg, plus debt and owner balances that come out at closing.
Where add-backs get proven or rejected, one transaction at a time.
Ties the P&L and balance sheet together and anchors the QoE workpapers.
Which receivables will actually be collected, and how concentrated they are.
Stretched payables make cash look better than it is and shift the working capital math.
Customer concentration, and whether the top accounts are growing or leaving.
| Deal | Report | Period | Basis | Columns | Why it matters |
|---|---|---|---|---|---|
| Acquisition | Profit and Loss | Last 3 fiscal years + year to date | Accrual | By year | The trend, the margins and the starting point for every EBITDA adjustment. |
| Acquisition | Profit and Loss | Trailing 24 months | Accrual | By month | Seasonality, the trailing-12 figure and whether the last few months support the asking price. |
| Acquisition | Balance Sheet | Each fiscal year end + latest month end | Accrual | By month for the last 12 | Monthly working capital for the peg, plus debt and owner balances that come out at closing. |
| Acquisition | General Ledger | Trailing 12 months + last fiscal year | Accrual | Transaction detail | Where add-backs get proven or rejected, one transaction at a time. |
| Acquisition | Trial Balance | Each fiscal year end + latest month end | Accrual | Single period | Ties the P&L and balance sheet together and anchors the QoE workpapers. |
| Acquisition | A/R Aging Detail | As of latest month end | n/a | Invoice detail | Which receivables will actually be collected, and how concentrated they are. |
| Acquisition | A/P Aging Detail | As of latest month end | n/a | Bill detail | Stretched payables make cash look better than it is and shift the working capital math. |
| Acquisition | Sales by Customer Summary | Last 3 fiscal years + trailing 12 | Accrual | By year | Customer concentration, and whether the top accounts are growing or leaving. |
| SBA acquisition loan | Profit and Loss | Last 3 fiscal years | Same basis as the tax returns | By year | The lender reconciles these to the seller's tax returns and IRS transcripts, so the basis has to match the return. |
| SBA acquisition loan | Profit and Loss | Year to date + same period last year | Same basis as the tax returns | Compare to previous year | Interim results the lender can compare to last year. SBA rules want interim financials no older than 120 days. |
| SBA acquisition loan | Balance Sheet | Each fiscal year end + interim date | Same basis as the tax returns | Single period | Debt to be paid off, owner balances, and what the buyer is actually acquiring. |
| SBA acquisition loan | General Ledger | Trailing 12 months + last 2 fiscal years | Accrual | Transaction detail | On purchases of $3M or more, the required QoE and its cash proof are built from this detail. |
| SBA acquisition loan | A/R Aging Summary | As of interim date | n/a | Aging buckets | Collectability of the receivables that support working capital after closing. |
| SBA acquisition loan | A/P Aging Summary | As of interim date | n/a | Aging buckets | Payables the buyer inherits or the seller must clear at closing. |
| Line of credit renewal | A/R Aging Detail | Month end, every month | n/a | Invoice detail | The borrowing base: what's over 90 days and which customers exceed concentration limits. |
| Line of credit renewal | Inventory Valuation Summary | Month end, every month | n/a | Single period | Eligible inventory for the borrowing base. Available on QuickBooks Online Plus and Advanced. |
| Line of credit renewal | A/P Aging Summary | Month end | n/a | Aging buckets | Past-due payables can signal a cash squeeze before the covenants do. |
| Line of credit renewal | Balance Sheet | Quarter end | Accrual | Compare to previous year | Current ratio, leverage and tangible net worth covenants. |
| Line of credit renewal | Profit and Loss | Year to date + same period last year | Accrual | Compare to previous year | Debt service coverage and whether performance supports the renewal. |
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.
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.
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.
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.
Fix each problem and watch the same Profit and Loss turn into something an analyst can work with. Amounts in $K.
| Jan–Dec 2025 | Total |
|---|---|
| Revenue | 2,310 |
| Total expenses | 2,058 |
| Net income | 252 |
| Sent back | Ready to use | Why it matters |
|---|---|---|
| Sent as a PDF | Exported to Excel | A PDF has to be retyped before anyone can analyze it. |
| Cash basis | Accrual basis | Cash basis moves revenue to when it's collected, so margins and trends shift month to month. |
| Rows collapsed | Every account expanded | A collapsed report shows one expense total, hiding the accounts where add-backs live. |
| One total column | Columns by month or quarter | Without periods you can't see seasonality or build a trailing-12 figure. |
| No comparison period | Prior year alongside | A single year can't show whether the business is growing or shrinking. |
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 FreeWalk from reported to adjusted EBITDA, see which add-backs survive a quality of earnings review, and what each one is worth at the deal multiple.
Read articleDemystify net working capital calculations, adjustments, and their impact on deal valuations and closing mechanics.
Read articleCalculate the debt service coverage ratio for an acquisition loan, see the largest loan the cash flow supports, and learn what lenders adjust before they trust the number.
Read article