Xero Year End Checklist for CT600
Closing your financial year in Xero is the foundation for a smooth corporation tax return. The figures on your CT600 come directly from your accounting records — so the more complete and accurate your Xero data, the simpler your filing will be.
This checklist covers everything you need to do in Xero at year end, from confirming your accounting period to exporting your trial balance for import into your company tax return.
1. Confirm Your Accounting Period Dates
Before anything else, confirm that Xero has the correct accounting period:
- Go to Settings → General Settings → Financial Settings
- Check the Year End Date matches your company's registered accounting period at Companies House
- If you have changed your accounting period, update this in Xero to match
2. Reconcile All Bank Accounts
All bank accounts must be fully reconciled to your year end date. Unreconciled transactions will make your balance sheet inaccurate — and that means your CT600 figures will be wrong.
To check reconciliation status in Xero:
- Go to Accounting → Bank Accounts
- Click each account name to open the statement view
- Check the reconciled balance matches your actual bank statement balance at year end
- Reconcile any outstanding items
Key accounts to reconcile:
- Business current and savings accounts
- Director's loan account
- PAYE and National Insurance payments
- VAT payments and reclaims
- Any credit card or loan accounts
3. Review Your Profit and Loss
Run a Profit and Loss report for your full accounting period and check for anomalies:
- Go to Accounting → Reports → Profit and Loss
- Set the date range to your full accounting period
- Review each category for unusual balances
- Revenue: Does the total match your invoices and bank receipts?
- Cost of Sales: Are direct costs categorised separately from overheads?
- Director's salary: Has it been entered through payroll and posted as a wage expense?
- Depreciation: Has your accountant posted the year-end depreciation journals?
- Accruals and prepayments: Have year-end adjustments been posted?
4. Review Your Balance Sheet
Your balance sheet must balance — total assets must equal total liabilities plus equity. To check:
- Go to Accounting → Reports → Balance Sheet
- Set the date to your year end date
- Confirm the report shows a balanced position
| Section | What to Check |
|---|---|
| Fixed assets | Matches your asset register after depreciation |
| Trade debtors | Matches outstanding sales invoices |
| Trade creditors | Matches unpaid supplier bills |
| Corporation tax payable | Prior year's tax paid and reconciled? |
| Director's loan | Balance correct and supported by records? |
| Retained earnings | Prior year profit correctly carried forward? |
5. Post Year-End Journals
Some year-end adjustments are not entered automatically. Depending on your business, you may need to post manual journals for:
- Depreciation — if you are not using Xero's fixed asset register
- Accrued income — revenue earned but not yet invoiced
- Accrued expenses — costs incurred but not yet billed (for example, accountancy fees for the year just ended)
- Prepayments — costs paid in advance that relate to the next period
- Closing stock — if your business holds inventory
6. Lock the Accounting Period
Once all entries and journals are complete, lock the period in Xero to prevent accidental changes:
- Go to Settings → General Settings → Financial Settings
- Under Lock Dates, set the Lock Date to your year end date
- Save
7. Export Your Trial Balance
Your trial balance is the key report for populating your CT600. It lists every account in your chart of accounts with its closing debit or credit balance at year end.
To export your trial balance from Xero:
- Go to Accounting in the top menu
- Select Reports → All Reports
- Find Trial Balance under the Accounting section
- Set the date to your year end date and click Update
- Click the Export button at the top of the report
- Choose Excel or CSV format
For guidance on how Xero's account codes map to the boxes on your CT600, see our Xero account mapping guide.
8. Import Into TinyTax
Once you have your trial balance, import it into TinyTax to populate your company tax return automatically:
- Open TinyTax and start or continue your CT600 for the period
- Click the Import Trial Balance button in the Profit and Loss or Balance Sheet section
- Select Xero as your accounting software
- Upload the CSV or Excel file you exported
- Review the automatic field mapping and adjust any items that need reclassifying
- Confirm the import — TinyTax populates the relevant fields
9. Gather Supporting Documents
Before completing your CT600, gather any additional information you will need:
- Your company's Unique Taxpayer Reference (UTR) from HMRC
- Details of any capital allowances to claim (Annual Investment Allowance, Writing Down Allowance)
- Details of any director's loans outstanding or written off
- R&D expenditure records if claiming Research and Development tax relief
- Confirmation of any loss relief to carry back or forward
Summary
A clean Xero year end involves confirming your period dates, reconciling all accounts, reviewing your Profit and Loss and Balance Sheet, posting year-end journals, locking the period, and exporting your trial balance. Completing these steps before you start your CT600 means fewer corrections and a much smoother filing experience.
Once your Xero data is accurate and locked, your trial balance gives you everything you need to complete your company tax return with confidence.