Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

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.

71 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminXero Team (Admin, Xero) shared this idea  ·   ·  Report…  ·  Admin →
delivered  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

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 Ledger Summary and Detail reports 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 where you can rename and access anytime in the future.

Show previous admin responses (1)
Comments are closed An error occurred while saving the comment
  • Janette Telfer commented  ·   ·  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.

  • Jamie Fowler commented  ·   ·  Report

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

  • Julia Devishkova commented  ·   ·  Report

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

  • Elmie Jordaan commented  ·   ·  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.

  • Nelleke Ferreira commented  ·   ·  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

  • Jigna Dave commented  ·   ·  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

2 Next →