Skip to content
← Xero Developer Ideas

Settings and activity

1 result found

  1. Please update your Reporting APIs w/ option to get V2 [new] Balance Sheet and Profit & Loss including the default custom layout.

    29 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

    3 comments  ·  Accounting API » Reports  ·  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
    An error occurred while saving the comment
    Will Ferguson commented  · 

    Adding my max votes for this
    I have a custom Trial Balance Report
    2 columns Account , Account Code
    12 month comparison columns
    No Grouping or sumarisation

    Exported as Excel this is a nice flat file

    unfortuantely the API scope - accounting.reports.read
    does not appear to offer any way of retreiving this report

    The https://api.xero.com/api.xro/2.0/Reports/TrialBalance
    returns a fairly unreadable JSON that groups and sumarises and requires too much painful and flimsy logic to flatten into something useful

    Please can we have Reports flattened in the API

    Will Ferguson supported this idea  ·