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
  • Paul Sheehan commented  ·   ·  Report

    As the idea for this original request is now closed I would like to repost. The trial balance is an important part of the accounting process. It is a different report than a general ledger report and takes more work to produce. It would not be a difficult process for Xero to be able to add in the date range selector tool. Given that you have also taken away the ability to provide an exempt report layout as well, I must question why you are downgrading features that accountants use as part of their practice. Regards Lisa.

  • Jonathan Clayton commented  ·   ·  Report

    There is a decent enough work-around if you're only after movements for a period (and not comparatives/YTD, in which case I'd point you in the direction of the new standard TB report Template)

    1) Reports > Account Transactions (New version).
    2) Under "Accounts" select "All"
    3) Under "Grouping/Summarising", select "Summarise by....Account Code & Name)
    4) Under "More", de-select "Show opening and closing balances/Asset, liability & equity"
    5) Under "Columns" de-select all apart from "Debit" and "Credit"
    6) Click "Update" for Great Success!!

    P.S. this also works when you want a period TB for any non-standard date ranges. (eg. if a merger/acquisition occurred part-way through the year and you want to examine pre/post figures).

  • Bruna Wolfenden commented  ·   ·  Report

    Cannot believe it has been we are still having the discussion. Why has this not been addressed by zero.

  • eCloud Experts commented  ·   ·  Report

    Does anyone know how to resolve the issues? I have a client whose accounting year-end date changed from April to December. When I run the reports in Xero, it gives me the figures for the last 12 months however I only need figures for the last 9 months.

  • Anne-Marie McGlashan commented  ·   ·  Report

    The old reports showed the column for the month only which was useful and has been omitted from the new reports. Frustrating as I used the month only option lots to get a sense check. I agree with many of the comments already posted that a date range would be extremely useful.

  • Janette Telfer commented  ·   ·  Report

    It is not just needing a flexible date range. It is needing to produce a TB with no opening figures included (a transactional TB) as very few accountants do journals in Xero which leaves Xero not in sync with my clients accounts.

  • Brad Reynolds commented  ·   ·  Report

    Once again, Xero is unable to provide what is a basic BASIC thing in any other accounting package that you would care to name.
    I can prepare a P&L for any period I need or, similarly, a balance sheet but a basic report like a trial balance that is then used to create these reports? No, Xero can't handle it...too hard. More important things to worry about like the font of the drop down tab headings.
    I received a "personal" note from the new CEO today. She seems keen to help - maybe you could get her to give the "developers" a hand because they seem to be stuggling with the simple stuff.

  • Bruna Wolfenden commented  ·   ·  Report

    Don't understand from an accounting point of view why this isn't a standard report.

    MYOB has it standard? Finding the reports in Zero frustrating.

  • Monja van Zyl commented  ·   ·  Report

    We really need to have this where client's change year ends as it is difficult to default on the current year end period.

  • Lidia Cymerman commented  ·   ·  Report

    This has been a feature in the past as we had a custom report created in the past 2 years with custom data range but it looks like Xero has dropped this feature and you cannot copy the old report to the new company. we have a longer accounting period for the first year of trading and it will involve a lot of manual work to set upmonthly report that was previously run via just one update click

  • Pujan Tamrakar commented  ·   ·  Report

    This is very helpful, almost integral in reporting for some clients.

  • Vaughan Everest commented  ·   ·  Report

    I have viewed the new trial but feel it lacks the reporting ability of the old one.
    Specfically the date, its not from, to. This is useful when reconciling GST and you can have the trial balance for the GST period. You are only dealing with the transactions for that GST period.
    Next is the month to date, very useful for certain clients. If the from, to date can be included it would get around this

  • Peter Miles commented  ·   ·  Report

    For the Balance Sheet accounts there is obviously no change. For the P&L, just run it to cover the number of months you need. That should get what you need ?

  • Jack Latham commented  ·   ·  Report

    Very useful for practices who intergrate their xero TB directly to their compliance software (tax calc or IRIS for example), when preparing either the initial period of trading or an extended accounting period.

  • Julie Watkin commented  ·   ·  Report

    Please can we have the ability to enter a date range when running a trial balance

  • Diane Midollo commented  ·   ·  Report

    To add a column at the far left that would be beginning account balances and a column to the far right that would be the ending balances for the period being run.

  • Gill Brand commented  ·   ·  Report

    Useful for clients in their first year who have a longer than 12 month period

  • Klaas van Dyk commented  ·   ·  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.

  • Scott Coggill commented  ·   ·  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.

← Previous 1