Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Reporting - Set default date columns from oldest to most recent

    23 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

    11 comments  ·  For small businesses » Accounting features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    submitted  ·  AdminKelly Munro (Community Manager, Xero) responded

    You can re-order the columns of your report with the layout editor, Robbie. 🙂


    Once you've got the report set up as you like you can Save as Custom to easily access the report with this layout. 

    If you're like to make this the default layout there is also an option for this - see our help here & here

    An error occurred while saving the comment
    Fran Lozada commented  · 

    Ended up working around this by exporting to Google Sheets and creating an AppScript function.

    Change the start and end columns for your use case.

    You need to adjust the column numbers in the script to suit your needs.
    Also, ensure that a date-type header is present in Row 5.

    You can check the script at:
    https://github.com/Flozad/awesome-appscript/blob/main/UseCases/xero-sorting-reports.js

    Fran Lozada supported this idea  ·