Year to date profit and loss statement: run it in Xero and read it properly

Short answer: a year to date (YTD) profit and loss statement shows your sales, costs and profit from the first day of your financial year to a recent date, usually the end of last month. In Xero, run Profit and Loss from the first day of the financial year to the last day of the latest whole month, then compare it with the same dates last year, never with last year’s full year. Do not multiply it up to twelve months either: in a seasonal business that can make a worse year look better. In the example below, a bike shop’s YTD sales are 5% up on last year but YTD profit is 16.6% down, and simply scaling nine months to twelve would have shown profit rising.

A YTD statement is one kind of interim profit and loss statement: any P&L for less than a full financial year, such as a quarter, a half year or the months so far. Lenders, landlords and Centrelink ask for them when the last annual accounts are old.

Where the year starts

“Year to date” means your financial year, not the calendar year, unless they are the same.

Where	Usual financial year	YTD at the end of March covers
Australia	1 July to 30 June	9 months (July to March)
New Zealand	1 April to 31 March	12 months (the full year)
UK company	Whatever its year end is (often 31 March or 31 December)	Depends on the year end
UK sole trader	Taxed on the tax year, 6 April to 5 April	Almost 12 months

Xero holds your financial year end under Settings › Organisation details (it may sit under Financial settings in your version). If someone asks for a “year to date P&L”, check which year they mean; a bank may want the calendar year, the tax office wants the tax year.

How to run it in Xero

1. Go to Reports and open Profit and Loss.
2. Set the start date to the first day of your financial year (for example 1 July 2026).
3. Set the end date to the last day of the latest whole month (for example 31 March 2027). A part month makes margins look odd, because some bills arrive at month end.
4. Under Compare with, choose the previous year, so the second column covers the same dates one year earlier. That is the fair comparison.
5. Check the basis (accrual or cash) and use the same one for both columns; see cash vs accrual reports in Xero.
6. Update, then Export to PDF or Excel if someone has asked for it.

Menu names move between Xero releases and differ by region. If a label does not match your screen, search Xero Central for “Profit and Loss compare periods”. For the months side by side instead of one total, see Profit and Loss by month in Xero.

Before sending a YTD statement to anyone, reconcile the bank accounts up to the end date and check nothing large is waiting to be coded, or the figures will move after you send them.

A worked example: a bike shop at the end of March

These are made-up figures for a small Melbourne bike shop with a July to June financial year. It is the end of March, nine months in, and the owner runs the YTD Profit and Loss with last year’s same nine months next to it. All amounts exclude GST.

	YTD this year, Jul to Mar ($)	Same 9 months last year ($)	Change
Sales	504,000	480,000	+5.0%
Cost of sales (bikes, parts)	312,480	288,000
Gross profit	191,520 (38%)	192,000 (40%)
Overheads (rent, wages, other)	144,000	135,000
Net profit	47,520	57,000	−16.6%

Sales are up, so it feels like a good year. Profit says otherwise, and the drop of $9,480 splits into three parts:

• More sales: +$9,600. The extra $24,000 of sales at last year’s 40% margin.
• Thinner margin: −$10,080. The shop kept 38 cents of every dollar instead of 40, on $504,000 of sales. Most of that was clearance discounting on last season’s bikes.
• Higher overheads: −$9,000. A part-time mechanic took overheads from $15,000 to $16,000 a month.

The same sum on a single month is in why did my profit drop, and the price increase calculator shows what getting the 2 points of margin back is worth.

Projecting the full year: do not just multiply by 12 ÷ 9

The tempting shortcut is to scale nine months up to twelve. For this shop that gives:

Method	Full-year sales	Full-year net profit	Against last year’s $60,000 profit
YTD × 12 ÷ 9	$672,000	$63,360	Looks up 5.6%
YTD + last year’s April to June, adjusted	$630,000	$47,400	Actually down 21%

The shortcut is wrong because April to June is the shop’s quiet winter. Last year those three months brought in $120,000 of sales and just $3,000 of profit; the first nine months earned 80% of the year’s sales. Treating every month as average assumes the winter will be as busy as summer.

The better projection takes the YTD actual and adds last year’s remaining months, adjusted for what has changed: April to June sales 5% higher ($126,000), at this year’s 38% margin ($47,880 of gross profit), less this year’s $48,000 of overheads, which is a $120 loss for the quarter. Full-year profit: $47,520 − $120 = $47,400, against $60,000 last year. That is the figure to plan tax, drawings and the bank conversation around. The profit and loss forecast guide builds this out month by month, and with a budget in Xero the budget vs actual report shows YTD against plan instead of against last year.

When someone asks you for one

• A lender or landlord. Send the YTD P&L with last year’s same period alongside, the dates and basis in the heading, and the last full year’s accounts. Say it is unaudited management figures. If the business is seasonal, add one line explaining it, so nobody multiplies it up for you.
• Centrelink. It usually wants a P&L for a set recent period rather than the whole year; see the Centrelink profit and loss statement guide.
• Self-employed and a mortgage. Lenders mostly lean on tax returns and want a YTD figure as well when the last return is old; the self-employed profit and loss statement guide lists what each one asks for.
• Quarterly or half-year. The same steps with a different start date. Compare each quarter with the same quarter last year.

To lay out your own figures in the same shape without Xero, the free profit and loss sheet works out gross and net profit and both margins as you type.

Common mistakes

• Comparing YTD with last year’s full year. Nine months against twelve always looks like a fall.
• Ending on today’s date. Half a month of sales with a full month of rent makes the latest month look bad. End on the last whole month.
• Using the calendar year by accident. If your year starts on 1 July, a January to March report is not year to date.
• Unreconciled months. Missing bank transactions or uncoded bills make YTD profit look better than it is, until they are coded.
• Mixing bases. Cash basis this year and accrual last year makes the change meaningless.

Common questions

What is a year to date profit and loss statement? It is a profit and loss statement covering the period from the first day of your financial year to a recent date, usually the end of the last whole month. It shows sales, costs and profit so far this year.

How do I run a YTD profit and loss in Xero? Open the Profit and Loss report, set the start date to the first day of your financial year and the end date to the last day of the latest whole month, then compare with the previous year so you see the same dates one year earlier. Update and export if you need to send it.

What is an interim profit and loss statement? Any profit and loss statement for less than a full financial year, such as a month, a quarter, a half year or the year so far. Lenders and landlords ask for one when the last annual accounts are out of date.

Should I compare YTD with last year’s full year? No. Compare it with the same months last year. Comparing part of a year with a whole year always looks like a fall, and comparing the same months also takes out most of the seasonality.

Can I multiply my YTD profit to estimate the full year? Only if every month is roughly the same. In a seasonal business it can badly overstate or understate the year. Add last year’s remaining months to this year’s actual instead, adjusted for what has changed, such as price, margin and new overheads.

Is a YTD profit and loss before or after tax? Usually before income tax. A sole trader’s tax is personal and never appears on the business P&L, and a company’s tax is normally posted at year end, so a YTD figure in Xero is almost always before tax.

Your year so far, every Monday

ReportPilot reads your Xero figures and sends a short plain-English email every Monday comparing the latest month with the month before and the same month last year, with sales, profit, cash and money owed to you, and flags gross margin when it moves by 3 percentage points or more. The dashboard keeps 24 months of those figures, so last year’s same months are always there to compare. It asks Xero for read-only access, and there is a 14-day free trial with no card.