Trial Balance - Ability to run for a date range – Share and support customer ideas for Xero

Trial Balance - Ability to run for a date range

The ability to run a date range in a Trial Balance report.

Purpose: Having more flexibility when running the report by having the date range function.

TB dates.PNG 36 KB

82 votes

AdminXero Team (Admin, Xero) shared this idea · 09 January, 2013 · Report… · Admin →

In discovery ·

AdminKelly Munro (Community Manager, Xero) responded · 13 February, 2026

Hi team, while we released the ability to run the Trial balance for a date range to our US customers last year, we appreciate there's quite a bit of appetite for this in other regions and have re-opened the idea so we can engage with you all and consider whether this feature can be expanded.

We'd love to get more insights of the needs in running this report for a date range for customers based in regions outside US.

If you'd be willing to share they will be running research across the next 2 weeks - please book a video call at a time that works for you through the link here. 💬

Thanks for your engagement and I'll keep you updated of outcomes in this idea.

Show previous admin responses (3)

Completed ·

AdminKelly Munro (Community Manager, Xero) responded · 25 June, 2025

Hi everyone, while this idea was shifted to delivered sometime ago, we wanted to come back to share updates.

Recently, we released an update to the Trial Balance report for US organisations. Understanding the needs of our customers in this region we know being able to set a date range in the Trial Balance report was still highly important and this is now possible in Xero.

Right now, this change is only available to users on the US version of Xero. Our product teams are monitoring usage of this feature and will consider expansion to other regions longer term.

In the meantime, for organisations outside the US the previous options of the General Ledger Summary and Detail reports are the best method for getting what you need here. Thanks

Completed ·

AdminKelly Munro (Community Manager, Xero) responded · 08 May, 2023

Hi team, we’re grateful for your contributions and support in the ability to run the Trial Balance report for a date range. In the last few months we released our new version of Xero’s General Ledger report which can solve the underlying needs of what’s being asked here.

With the General ( https://central.xero.com/s/article/General-Ledger-report ) Ledger Summary ( https://central.xero.com/s/article/General-Ledger-report ) and Detail reports ( https://central.xero.com/s/article/General-Ledger-Detail-report ) you’ll be able to get a view of all accounts with a balance. Mentioned by a few in comments there’s the ability to include or exclude opening and closing balances from these reports.

Most fundamentally asked here – these reports can both be run across a common date range or a custom date range for extended periods.

- Worth noting in difference to the Trial Balance YTD column, when running the new GL reports across a change of FY date range will show Net movement in the period and does not capture roll-over journals

Understanding, some of you may want to return or run this styled report often, once you’ve set up as needed, save it as a custom report ( https://central.xero.com/s/article/Create-reusable-custom-report-layouts ) where you can rename and access anytime in the future.

submitted ·

Rudi Moritz responded · 28 March, 2022

An error occurred while saving the comment

Klaas van Dyk commented · 27 July, 2022 02:12 · Report

Hi There: It would be great and very usefull if i could choose my own "from and to" date when producing a trial balance and if i can ad last year if needed.

Submitting...
Scott Coggill commented · 04 July, 2022 09:34 · Report

It would be able to run a trial balance for more than 12 months. This will be useful for the first year of trading were it is common for it to be greater than 12 months or when it has been extended with Companies House.

Submitting...
Pete Collins commented · 27 June, 2022 07:13 · Report

Really useful and time saving

Submitting...
Amina Zhaborova commented · 09 June, 2022 22:29 · Report

saves a lot of time

Submitting...
Janette Telfer commented · 02 June, 2022 20:02 · Report

The reason that this is very important is because when Accountants pick up my figures in Xero and then carry out the year end transactions e.g. depreciation within their own systems then my figures no longer match the final accounts produced. This then means that the next years figures aren't correct as the opening balances carried forward are wrong. If the Trial Balance could be produced with no opening balances included then the Accountant could simply just take the actual transactions for that year and add them into their system. I know Sage has/used to have this facility.

Submitting...
Muhammad Fahad Parvaiz commented · 26 May, 2022 03:42 · Report

Very crucial feature, required by client

Submitting...
Jamie Fowler commented · 19 May, 2022 20:06 · Report

This is a critical feature which needs to be introduced. Especially for shortened or lengthened accounting periods.

Submitting...
Julia Devishkova commented · 19 May, 2022 04:30 · Report

Auditors sometimes ask to generate a TB for a certain period which is different from Xero options - for example for 15 months!

Submitting...
Elmie Jordaan commented · 14 May, 2022 17:59 · Report

This is a basic and everyday usage report. Please give this some attention. If still on the to do list since 2013 then I do think something needs to be done.
A lot of time is wasted having to calculations because this report is not available on custom dates and movement only.

Submitting...
Nelleke Ferreira commented · 25 April, 2022 22:43 · Report

I cant believe this is NOT an option - surely not a difficult feature to build, yet critical for users. I also have the instance where the financial year changed - and I need to report on 15months

Submitting...
Jigna Dave commented · 06 April, 2022 21:53 · Report

This is a really important feature that's missing from Xero. I have a company which has extended it's year end and I need to run a TB for the new extended period but Xero doesn't have that functionality. I know a quick Excel sum will resolve the issue but not when Xero integrates in to an accounts production software. So now I'm left manually working out the extended TB in Excel and manually uploading the TB in to my accounts production software. This to me is time wasted and lacks efficiency. Could this feature be given priority over other new features considering how important the role of a TB is. Thanks

Submitting...