Skip to content
← Xero Developer Ideas

Settings and activity

2 results 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

    4 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  · 

  2. Query exchange rate through the API

    26 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

    6 comments  ·  Accounting API » New Endpoints / APIs  ·  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
    declined  ·  AdminKelly (Admin, Xero Developer Centre) responded

    Our agreements with our FX provider prevent us from offering a general API endpoint for historical exchange rates.

    However, you can access the precise rate used for any transaction directly. When you retrieve a multicurrency invoice, the CurrencyRate field contains the exact rate that was applied, ensuring you can match your financial reports exactly.

    Will Ferguson supported this idea  ·