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

Community

New Connector: Quickbooks Online (reporting endpoints)

Not planned
Zach Brak User

I would like to petition that Fivetran reevaluate its stance on providing standard QuickBooks reports.

Currently - the only way Fivetran supports standard reports (profit & loss, balance sheet, cash flow) - is through an 'opinionated' transformation model. I have seen multiple reports and posts that this transformation poses challenges for people either:

- They do not run their own dbt environment to make the necessary adjustments in the model.

- Even with the adjustments - the model is reporting wildly inaccurate numbers (my case)

 

Intuit has made standard reporting APIs much more available than they used to. Accessibility to the following is straightforward:

- Profit & Loss API Documentation

- Balance Sheet API Documentation

- Cash Flow API Documentation

My evaluation the only thing on the market that comes close is Stitchdata profit_and_loss connection. No one else seems to even touch cash flow or balance sheet. Current solution I am going through 3rd party custom exports - they're looking to charge me ~$5k-$10k annual for this.

 

 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Sandeep Preetam Saila Fivetranner

    Dear Zach,

    I hope this message finds you well.

    I sincerely apologize for the delay in addressing your inquiry, and I appreciate your interest in our QuickBooks connector.

    Regrettably, we are unable to support the ingestion of reports from QuickBooks API, as it aligns with our product principles to focus solely on ingesting raw data from our designated sources. As you rightly noted, the recommended course of action is to utilize our QuickBooks Quickstart Data Model. However, it appears that this solution may not fully meet your requirements.

    In light of this, I recommend exploring the option of creating a custom connector. Our solution service team is available to collaborate with you on developing a connector tailored to pull the necessary reports from the required endpoints. This approach can be a more targeted and personalized solution to align with your specific needs.

    If you have any further questions or require additional assistance, please feel free to reach out. We are committed to ensuring your experience with our products is seamless and tailored to your business needs.

    Thank you for your understanding.

    Best Regards,
    Sandeep