Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Xero- Pull reports for "Balance Sheet" and "Profit And Loss"

Answered
Pranjal User

Request
Xero's API allows for the pulling down of various report data.  The two we are interested in are Balance Sheet and Profit And Loss.

We use the data in analysis and it is very hard to recreate these numbers.  In some cases impossible because Fivetran uses some intelligent calculations regarding conversion rates.

 

Use Case:
1. If you have never tried to recreate accounting reports from raw data, I can tell you it’s a chore.  I’ve done it and getting an exact match is hard.  There are many times we want to pull these summary values for other reporting and  if they don’t match the official report, that’s a problem.

2. Xero does not allow multiple organizations in one Xero instance.  So if you maintain multiple companies, like we do, you have to combine these reports manually.  We use this report data to create combined reports across companies.

3. Xero has some really “smart” estimates in regards to foreign exchange currency.  There is no way to get those values other than these reports.

 

Additional Resources:
Balance Sheet API: https://developer.xero.com/documentation/api/reports#BalanceSheet
Profit and Loss API: https://developer.xero.com/documentation/api/reports#ProfitAndLoss

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Anna User

    Hi @..., thanks for the request! We don't currently have plans to introduce aggregated reports as part  of the connector schema, but we do have a Fivetran dbt package available for Xero, which should solve some of your needs. You can read more about the package here: https://github.com/fivetran/dbt_xero#models. The Balance Sheet and Profit and Loss calculations are both provided as part of these models.

    If you'd like Fivetran to execute these transformations for you, you can read about Fivetran's integration with dbt here: https://fivetran.com/docs/transformations/dbt.

     

  • Alex LEATHARD User

    It would be great if the [Xero API Reports endpoints](https://developer.xero.com/documentation/api/accounting/reports#reports) could be integrated with the Fivetran Xero connector.

    I agree, building these reports from the raw data can be painful, and not all the reports are supported by the Xero dbt package.