Xero trial balance: how to run it, read it and check it

Short answer: the Trial Balance in Xero lists every account in your chart of accounts with its balance on one date, debits in one column and credits in the other, and the two totals are always equal. Run it from Xero’s reports (search for “Trial Balance”), pick the date, usually a month end or your year end, and update. Equal totals do not mean the books are right: Xero will not save an entry that does not balance, so the totals agree even when something is coded to the wrong account, missing or posted twice. The trial balance is useful because it shows every account on one page, so you can check each balance against something outside Xero: the bank statement, your last GST or VAT return, the lender’s loan statement, the fixed asset register. That is how accountants use it at year end, and it takes about 15 minutes for a small business.

How to run the Trial Balance in Xero

1. Open the report. Go to Xero’s reports (Accounting > Reports, or Reporting in the newer menu) and search for Trial Balance.
2. Pick the date. The report is “as at” one date. Use the last day of a month, or the last day of your financial year for year-end accounts.
3. Choose the columns. Depending on your version, Xero shows a Debit and Credit pair and a year-to-date (YTD) Debit and Credit pair, and the Columns menu can add the month’s movement. For checking balances, read the year-to-date figures.
4. Click any amount to see the transactions behind it (Account Transactions). This is how you find what makes up a balance that looks wrong.
5. Export to PDF, Excel or Google Sheets if your accountant asks for it.

Xero changes report menus and labels from time to time, so the names in your file may differ slightly by edition and region.

What the figures mean

The report has two halves, though Xero lists them in one table:

• Balance Sheet accounts (bank, customers who owe you, equipment, suppliers you owe, GST or VAT, loans, capital, retained earnings) show the balance on the date. These carry on from year to year.
• Profit and Loss accounts (sales and every cost) show the total since the start of the financial year. They start again from zero each year, and Xero moves the year’s profit into Retained Earnings without a closing journal.

Which side a balance sits on tells you what it is. Things the business owns and costs are normally debits. Things it owes, its capital and its sales are normally credits:

Account	Normal side	If it is on the other side
Bank	Debit (money in the account)	Overdrawn, or payments entered that the bank never made
Accounts Receivable (customers who owe you)	Debit	A customer paid twice, or a credit note was never matched to an invoice
Accounts Payable (suppliers you owe)	Credit	A bill was paid twice, or a payment was made with no bill entered
GST or VAT	Credit (you owe the tax office)	A refund is due, which is normal after a quarter of large purchases
Loans	Credit	Repayments coded to the loan with no loan ever entered
Sales	Credit	A refund or a credit note bigger than the period’s sales, worth a look
Expense accounts	Debit	A refund from a supplier, or a reversed entry with no original

A balance on the wrong side is not always an error, but it is always worth one click to see why.

A worked example: totals agree, profit is wrong

A plumbing company in Bristol, VAT registered, financial year ending 31 March. The owner runs the Trial Balance at 31 March 2026 before sending the year to the accountant. Year-to-date figures:

Account	Debit	Credit
Business bank account	30,450
Accounts Receivable	30,600
Van (cost)	32,000
Van accumulated depreciation		6,400
Suspense	1,280
Director’s loan account	3,150
Accounts Payable		8,940
VAT		6,720
PAYE payable		2,180
Van loan		19,860
Share capital		100
Retained earnings		28,500
Sales		190,700
Materials	61,800
Subcontractors	24,500
Wages and salaries	58,000
Rent	9,600
Motor vehicle expenses	7,450
Insurance	2,350
Accountancy	1,800
Bank fees	420
Total	263,400	263,400

The totals agree, as they always will in Xero. Sales of 190,700 less costs of 165,920 give a profit for the year of 24,780. The owner then checks each balance against something outside Xero:

Check	Xero says	Outside Xero	What it means
Bank	30,450	Statement on 31 March: 31,170	A customer’s 720 payment on 31 March is not reconciled. Reconciling it moves 720 from Accounts Receivable to the bank. Profit does not change.
VAT	6,720 owed	January to March return: 6,720	Agrees.
Van loan	19,860	Lender’s statement: 21,300	Every repayment was coded to the loan, including the interest in it. A journal moves 1,440 to interest expense. Profit falls 1,440.
Van depreciation	6,400 (last year’s)	The van cost 32,000 and is written off at 20% a year	This year’s 6,400 was never posted. Profit falls 6,400.
Suspense	1,280	Should be zero	A card payment nobody coded. It was a laptop, so it moves to equipment. Profit does not change.
Director’s loan account	3,150 debit		The director has taken out 3,150 more than they put in. In the UK an overdrawn director’s loan at the year end can mean extra tax for the company, so flag it to the accountant now (director’s loan account explains the rules).

After the fixes, profit for the year is 24,780 − 1,440 − 6,400 = 16,940. The first figure was 7,840 too high, about 46% more than the real profit, and the Trial Balance totals agreed the whole time. At the UK small profits rate of 19%, that is the difference between setting aside about 4,710 for corporation tax and about 3,220.

None of the problems showed up as an imbalance. All of them showed up as a balance that did not match the world outside Xero.

The checks to run every time

Most of the value is in the same handful of comparisons:

1. Every bank and card account agrees to the statement balance on the same date. If not, finish reconciling first and read the outstanding items on the bank reconciliation report; the bank balance guide covers why the two differ.
2. GST or VAT agrees to your last return, plus the tax on the period since.
3. Loans and finance agree to the lender’s statement. If Xero is lower, interest has probably been coded to the loan.
4. Equipment and vehicles agree to the fixed asset register, with depreciation run to the date.
5. Payroll liabilities (PAYE, super, KiwiSaver, pension) equal what was paid to the tax office or fund just after the date.
6. Suspense, clearing and Historical Adjustment accounts are zero. Historical Adjustment is where Xero puts any difference in opening balances from a conversion, so a balance there means the opening figures were never finished (how to clear it). The suspense account guide shows how to clear Suspense line by line.
7. Customers and suppliers agree to the aged reports at the same date, with nothing on the wrong side; the aged debtors and creditors guide shows how to read them.
8. Director’s or owner’s loan and drawings look like what you remember taking out.

These are the same checks as the year-end accounts guide, and the balance sheet guide explains each of these accounts in plain English.

Trial balance vs balance sheet vs profit and loss

The Trial Balance holds the same numbers as the other two reports, just laid out differently:

Report	What it shows	Who uses it
Trial Balance	Every account, debits and credits, on one date	Accountants and bookkeepers, to check the books before reporting
Balance Sheet	Balance Sheet accounts only, grouped and totalled: what the business owns and owes	Owners, lenders and buyers
Profit and Loss	Profit and Loss accounts only, for a period: sales, costs and profit	Owners, mainly

If you only read one report as an owner, read the Profit and Loss. The Trial Balance is the one to run before you trust it.

Common questions

How do I find the Trial Balance in Xero? Open Xero’s reports (Accounting > Reports, or Reporting in the newer menu) and search for Trial Balance. Choose the date, update, and click any figure to see the transactions behind it. You can export it to PDF, Excel or Google Sheets.

Why does my Xero Trial Balance always balance? Xero will not save a transaction whose debits and credits differ, so the totals always agree. That proves only that each entry balanced, not that it went to the right account, at the right amount, in the right period. Check each balance against an outside source instead.

What errors does a trial balance not find? A transaction coded to the wrong account, one that was never entered, one entered twice, the wrong amount on both sides, and an entry in the wrong period. In the worked example above, profit was 7,840 too high and the totals still agreed.

What is the Historical Adjustment account in a Xero trial balance? It is where Xero puts the difference when opening balances entered at conversion do not balance. It should be zero once the conversion balances are complete. A balance there usually means the opening figures from your old system or last year’s accounts were never finished.

Should a trial balance be run monthly? A quick look each month end catches problems while they are small, especially a balance in suspense or a bank account that does not agree to the statement. A full check is worth doing at every quarter end before a GST or VAT return (BAS in Xero, VAT return in Xero, GST return in Xero (NZ)), and at the year end before the accountant starts.

Is the trial balance the same as the balance sheet? No. The Trial Balance lists every account, including sales and costs, with its debit or credit balance. The Balance Sheet shows only what the business owns and owes, grouped and totalled, with this year’s profit in one line.

See the numbers that matter without running reports

The Trial Balance is a checking tool, not something an owner should need every week. ReportPilot reads your Xero figures and sends a short plain-English email every Monday: cash in the bank and how it has moved, how sales and net profit compare with last month, who owes you and how much is overdue, and bills due soon. Its dashboard shows 24 months of sales, profit, cash and money owed to you by month. It asks Xero for read-only access, so it can read your accounts but never change them, and there is a 14-day free trial with no card.