Profit and Loss detail in Xero: how to see the transactions behind any line

Short answer: Xero does not have a “Profit and Loss Detail” report that lists every transaction under each line, the way some other accounting software does. Owners and bookkeepers have asked for one on Xero’s product ideas forum for years. You get the same answer in two ways. For one line, click the amount on the Profit and Loss and Xero opens the transactions behind it in the Account Transactions report, for the same account and dates. For a whole Profit and Loss at once, run Account Transactions yourself, pick the income and expense accounts, set the dates, add the Contact column and export it. Then a jump in a cost line takes about two minutes to explain, as the example below shows.

Menu names move between Xero releases; if a label below does not match your screen, search Xero Central for “Account Transactions report”.

Two ways to see what makes up a line

You want to know	Do this	What you get
Why one line looks wrong this month	On the Profit and Loss, click the amount	Account Transactions for that account and period: date, contact, description, reference, amount
Everything behind the whole Profit and Loss	Reports > Account Transactions, select the income and expense accounts, set the dates	Every transaction, grouped by account, with a total per account that matches the Profit and Loss
What you spent with one supplier across accounts	Account Transactions for all expense accounts, with the Contact column, then sort or filter by contact in the export	The supplier’s lines, whichever account they were coded to
A line that is “about the same” but feels high	Run the same report for this month and the same month last year	The new or bigger items that the total hides

The totals in Account Transactions should match the Profit and Loss for the same accounts, dates and basis (accrual or cash). If they do not, check the dates first, then whether one report is on cash and the other on accrual.

A worked example: repairs that tripled

A café’s September Profit and Loss shows Repairs and Maintenance at $3,180, against $640 in August. The owner clicks $3,180 and Xero lists the five transactions behind it:

Date	Contact	Description	Amount
3 Sep	City Plumbing	Blocked drain call-out	$280
9 Sep	Bean Tech Services	Coffee machine six-monthly service	$460
14 Sep	Harvey Norman	Dishwasher, commercial	$1,450
18 Sep	CoolServ Refrigeration	Fridge compressor repair	$650
26 Sep	Gas Pro	Gas fitter, oven safety check	$340
		Total	$3,180

The jump is $2,540. Reading the list explains it:

• $1,450 is a purchase, not a repair. A new dishwasher is equipment that lasts years. It usually belongs in a fixed asset account (with depreciation, or an instant asset write-off if your accountant uses one), not in Repairs. Moved, September’s repairs fall to $1,730.
• $650 is a one-off. The compressor repair is real, but it should not happen every month.
• The remaining $440 is the gap between what is left ($1,080: the drain call-out, the machine service and the gas check) and August’s $640. The service and the gas check come round every six or twelve months, so this month carries both.

So the underlying month is $1,080, not $3,180: still above August, for reasons the owner can name, and nothing that needs cutting. Without the detail, the Profit and Loss alone would have suggested repairs had tripled. The same check catches a bill entered twice, an annual bill landing in one month, a personal purchase on the business card, or a cost coded to the wrong account. Why did my profit drop? walks through the rest of that routine.

How to run Account Transactions for a whole Profit and Loss

1. Go to Reports and open Account Transactions (search the report list if it is not on the first screen).
2. Under accounts, select the income and expense accounts you want. For a full Profit and Loss, pick every revenue, direct cost and expense account; leave out bank, asset and liability accounts.
3. Set the date range to match the Profit and Loss you are checking, for example 1 to 30 September.
4. Add the columns you need. Contact and Reference are the useful extras; Source tells you whether a line came from a bill, a spend money transaction, a journal or payroll.
5. Run it, check that each account’s total matches the Profit and Loss, then Export to Excel or Google Sheets. In the spreadsheet you can sort by amount to see the largest items, or filter by contact.
6. If you check the same accounts every month, save it as a custom report so the account list and columns are kept. Xero custom reports covers saving and sharing reports.

Journals are worth a second look. A line with Source “Manual Journal” was typed in by your bookkeeper or accountant, often for depreciation, accruals or corrections. Those are normal, but if one moved a lot of money, ask what it was for.

What to look for in the detail

• The biggest five items in each line that moved. Most jumps come from one or two transactions.
• Anything that lasts longer than a year (equipment, tools, a laptop) sitting in an expense line, like the dishwasher above.
• Annual or quarterly bills (insurance, software, registrations) landing in one month. The cost is real, but it is not a monthly run rate.
• The same amount twice from the same contact on nearby dates: often a bill and a spend money transaction for the same payment.
• Contacts you do not recognise. Usually a supplier trading under another name, but worth knowing.
• Credits in an expense line (refunds, rebates), which make a cost look lower than usual.
• Unrealised Currency Gains or Bank Revaluations that moved. They come from exchange rates on open foreign currency invoices, bills and bank accounts, not from anything you entered, so there may be no transactions to click into (unrealised currency gains in Xero).

If you want to see which lines moved before drilling in, Xero Profit and Loss by month puts the months side by side, and a common-size Profit and Loss shows each line as a share of sales.

Common questions

Does Xero have a Profit and Loss Detail report? No. Xero’s Profit and Loss shows totals by account. To see the transactions behind a line, click its amount, which opens the Account Transactions report for that account and period, or run Account Transactions for all income and expense accounts.

How do I see the transactions behind a Profit and Loss line in Xero? Click the amount on the line. Xero opens Account Transactions for that account and the report’s dates, listing each transaction with its date, contact, description and amount.

How do I export the Profit and Loss with every transaction? Run Account Transactions, select all income and expense accounts and the same dates as the Profit and Loss, add the Contact column, then export to Excel or Google Sheets. Each account’s total should match the Profit and Loss.

Why doesn’t Account Transactions match my Profit and Loss? Usually different dates, a different set of accounts, or one report on cash basis and the other on accrual. Line them up and the totals agree.

How do I see everything I spent with one supplier in Xero? Run Account Transactions for all expense accounts with the Contact column, then filter the export by that contact. That catches the supplier’s costs even when they were coded to more than one account.

What does “Manual Journal” mean in Account Transactions? The line was entered as a journal rather than from a bill, invoice or bank transaction, usually by a bookkeeper or accountant for depreciation, accruals or corrections. Ask them if a large one surprises you.

Know which line moved before you go looking

Drilling into Xero answers “why” once you know which line to look at. ReportPilot reads your Xero figures and emails you every Monday in plain English: how last month’s sales and profit compared, which income or cost line drove the change, and any cost line running well above its usual level. Then you know which amount to click. It does not recode or change anything in Xero: it asks for read-only access, and there is a 14-day free trial with no card.