Year to Date Profit and Loss Statement Generator: YTD P&L, Year to Date Balance Sheet and Cash Flow From One Export

What period a year to date profit and loss statement covers, and where people get it wrong

Year to date means from the first day of the current fiscal year through a close date you choose. For a calendar-year business asking in September, that is 1 January through 31 August. The two ends of that range are where the mistakes happen. On the front end, a business with a June fiscal year end has a YTD period that starts on 1 July, not 1 January, and every lender template that says "January to present" will quietly produce the wrong number for it. On the back end, "through today" is almost never what you want. Pick the last day of a closed month instead, because a period that stops mid-month picks up a full month of payroll accrual against a partial month of revenue and makes the business look worse than it is.

The other thing that trips people up is the balance sheet that has to come with it. A YTD profit and loss statement covers a range; a balance sheet is a single instant. When someone asks for both, they want the balance sheet as at the same close date the P&L runs through, not as at year end, and the net income on the P&L should agree with the movement in retained earnings plus any distributions on that balance sheet. That check is the whole reason underwriters ask for the pair rather than the P&L alone. Our balance sheet generator produces the matching statement at the same date, and if you want the full three-statement pack, the financial report generator runs all of them from the same export.

One more period question worth settling before you build anything: are you reporting on a cash basis or an accrual basis, and is that the same basis your last tax return used? A cash-basis YTD P&L on a business whose tax return was filed on accrual will not reconcile to anything, and the person reviewing it will notice. Fix the basis once, note it on the face of the statement, and use the same one every time you refresh the report. The switch usually lives in the report customization screen of whatever system holds your books.

Why lenders ask for a YTD profit and loss statement: the 120 day rule

Most requests for a year to date P&L come from mortgage underwriting, and there is a specific rule behind them. Fannie Mae's selling guide section on analyzing profit and loss statements states that a year to date profit and loss statement is not required for most businesses, but that if the borrower's loan application is dated more than 120 days after the end of the business's tax year, the lender may choose to require one if it believes the document is needed to support its determination of the stability or continuance of the borrower's income. That is why the requests cluster from late spring onward: a calendar-year business crosses the 120 day mark at the start of May, and from then until the next return is filed, the YTD P&L is the only current evidence a lender has.

The same guide is explicit that the statement may be audited or unaudited. That surprises people who assume a CPA has to attest to it. What the lender is doing is not auditing your business, it is checking that the current year is broadly consistent with the tax return it is already using to qualify you. If your YTD numbers annualize to something close to the return, the file moves. If they annualize to half of it, expect questions, and expect to be asked for business bank statements to corroborate. That is the practical reason to produce the statement from your actual ledger rather than typing figures into a template: a template can be made to say anything, and a report generated from the books can be traced back to transactions when someone asks.

Mortgages are not the only requester. SBA and conventional business lenders ask for interim statements on the same logic, buyers in a small acquisition ask for a stub period so they can compare it against the same months last year, and franchisors, landlords and bonding agents all ask for something similar under different names. The document is the same each time; only the close date and the supporting schedules change. For loan files specifically, our financial statements for a business loan page covers the full pack a commercial lender expects, and interim financial statements covers the quarterly and stub-period version of the same job.

How to produce a year to date P&L from QuickBooks, Xero or a trial balance

If your books are in QuickBooks Online, the report you want is called Profit and Loss, not income statement, and the fastest route is to set the date range to a custom range starting on the first day of your fiscal year and ending on your chosen close date. Do not rely on the built-in "This Year to Date" preset without checking it, because it ends today rather than at a month end and it reads the fiscal year from a setting most files were never configured with. Set the accounting method deliberately in the same customization panel. Then export to Excel. The step by step for the QuickBooks-specific version is on QuickBooks profit and loss statement, and the QuickBooks balance sheet that has to accompany it is on QuickBooks balance sheet.

If you are working from a trial balance instead, which is what most bookkeepers and firms actually hand over, the YTD figures are already sitting in it: revenue and expense accounts on a trial balance carry the year to date movement by definition, because those accounts were zeroed at the last year end close. Balance sheet accounts on the same trial balance carry the position at the trial balance date. So one properly dated trial balance contains everything a YTD P&L and a matching balance sheet need. That is the cleanest input we take, and the route is covered on trial balance to financial statements. If you have the full transaction detail instead, general ledger to financial statements takes that.

What none of those exports give you is a presented statement. A QuickBooks export is a report layout with merged cells, indent levels expressed as blank columns and subtotal rows that are formulas rather than data. A trial balance is a flat list of account names and balances with no idea which line belongs on which statement. The work between that file and something you can send to an underwriter is mapping every account to a statement line, footing the groups, ruling the subtotals, adding the comparative column if one was asked for, and putting a header on it that states the entity, the period covered and the basis of accounting. That is the part AIStatements does, and it is why a YTD pack that used to take a bookkeeper an afternoon in Excel takes about a minute here.

Signed and dated by the preparer: what that phrase on a lender checklist means

Plenty of lender document checklists ask for a "year to date profit and loss statement signed and dated by the preparer", and it is worth being clear about what that does and does not mean. It does not mean the statement has to be audited, reviewed or compiled by a CPA under professional standards. It means the person who put the numbers together has to put their name and the date on the face of the document, so the file has an identifiable author and a known preparation date rather than an anonymous spreadsheet. If the business owner prepared it, the owner signs it. If a bookkeeper or a firm prepared it, they sign it.

Where this becomes a professional question rather than a clerical one is when a CPA firm prepares the statement for a client. Putting a firm name on financial statements that will be given to a third party generally means the firm is performing an engagement under the AICPA standards for preparation, compilation or review, and each of those carries its own report language and independence considerations. Firms handling this at volume run it through engagement software rather than Word, and that workflow is on financial statement compilation software and financial statement drafting software. If you are the owner rather than the accountant, none of that applies to you and a signature and a date are enough.

Two practical points that save a round trip with the underwriter. Date the signature after the close date of the period, not before, because a statement covering January through August that was signed in July is going straight back to you. And state the basis of accounting on the statement itself, in a line under the heading, so nobody has to ask. Both of those are on the output AIStatements produces by default, along with the entity name and the exact period covered, because the most common reason a YTD statement gets rejected is not a wrong number, it is a missing label.

The checks that decide whether a YTD statement survives review

Underwriters, buyers and partners all run more or less the same three tests on an interim statement, and knowing them is the difference between one submission and four. The first is annualization: they take your YTD net income, scale it to twelve months, and compare it against the last filed return. Seasonal businesses fail this test unfairly, which is why a seasonal business should send a comparative column showing the same months of the prior year alongside the current period. That single extra column answers the question before it is asked. The second is the tie between the P&L and the balance sheet at the same date, described above. The third is a sanity check against bank activity, which is why business bank statements are so often requested in the same breath.

Then there are the errors that are entirely within your control and are the usual cause of a statement that does not tie. Revenue and expense accounts that were never closed out at the last year end will make a YTD P&L include prior-year activity, which inflates everything and is invisible unless you check the opening balances. Undeposited funds sitting stale will overstate cash and often revenue; the ordered fix is in our note on undeposited funds in QuickBooks. Loan payments posted entirely to principal understate interest expense for the period. Depreciation that has not been booked for the stub period overstates profit, and this one is nearly universal on interim statements because depreciation is usually a year end journal. A YTD statement with no depreciation line on a business that owns equipment is a red flag to anyone who reads statements for a living.

AIStatements runs the mechanical checks before it shows you anything: total debits against total credits on the export, and net income from the income statement against the movement in equity on the balance sheet at the same date. When they disagree it reports the difference and the likely cause rather than plugging it, because a plug hides a bookkeeping problem instead of fixing one. If you would rather work through the close before producing the statement, the month-end close checklist sets out the order, and general ledger reconciliation covers tying the subledgers back to the ledger.

Who produces year to date statements, and what AIStatements adds

Three groups produce these constantly. Self-employed people and small business owners mid-application for a mortgage, a business loan, a lease or a line of credit, who need one document, need it to look professional, and do not want to learn statement formatting to get it. Bookkeepers and CPA firms fielding the same request from several clients between May and October, who need each one to come out in a consistent house format rather than as three different QuickBooks printouts. And owners preparing to sell, who need a stub period against the same months last year so a buyer can see the trend rather than a single annual figure. The self-employed version of this job has its own page at profit and loss statement for self employed, and the sale version at financial statements for selling a business.

What we add is the layer between the export and the deliverable. Upload a QuickBooks, Xero or trial balance export, or connect QuickBooks directly, choose the close date, and AIStatements maps every account to a statement line, foots the groups, builds the ruled subtotals, produces a year to date income statement with a matching balance sheet and cash flow statement, verifies that the three agree, and returns a PDF for the recipient and an XLSX for anyone who wants to trace a figure back. Add a prior-year comparative column and it runs the same period last year beside it. The figures stay deterministic because they are computed from your ledger; the AI writes only the narrative, and it cites the numbers it describes. See it on sample data in the tool above before you upload anything real, or start from the profit and loss generator.

Two honest boundaries. We are a reporting layer, not a bookkeeping system: if the underlying books are wrong, a faster statement is a faster wrong statement, and the checks above will usually tell you so. And AIStatements is software that formats and analyzes data you already have. It is not accounting, audit or tax advice, it is not a CPA, and it does not certify GAAP compliance or perform an engagement under AICPA standards, so have a licensed professional review anything you file or hand to a lender. Firms doing this across a client roster should start at financial reporting software for accounting firms.

Common questions