The QuickBooks Online Reports API has arrived!

Comments

19 responses to “The QuickBooks Online Reports API has arrived!”

1. 

   Karl Irvin

   March 26, 2014

   Is the reponse JSON only or is XML available?

   Reply
2. 

   yelena gartsman

   March 27, 2014

   Hi Karl,

   The response is JSON only.

   Reply
3. 

   john schires

   March 27, 2014

   Will CustomerBalanceDetails report be added to the API?

   Reply
4. 

   Karl Irvin

   March 27, 2014

   On a forum post, I saw the following

   Reports will be supported in the .NET SDK in the next release on April 4th, 2014 (next Friday).

   Reply
5. 

   David

   March 29, 2014

   @John – Yes, we do plan on adding the Customer Balance Detail report to the API. We are still working through the release time frames for additional reports. Stay tuned!

   Reply
6. 

   Peter Rosser

   March 31, 2014

   It’s nice to see the API coming along. Kudos to your team for their delivery!

   My two questions are:

   1. I notice that a report that we rely on from QBD, ARAgingDetail, is not present (but ARAgingSummary (“AgedReceivables”) is). As a result, I have to make many more queries to construct the same data. Instead of one report, I must pull 2 Invoice queries and a Payments query, then back out future (to the date in question) payments from the Balance of each invoice. This seems brittle and heavy compared to the QBD way. Any chance we can get the ARAgingDetail report?

   2. Any plans to make the reports more analysis-friendly? The schema seems borrowed in some aspects, especially with tree-structured reports like BalanceSheet and IncomeStatement. A JSON-first approach to the data structure would certainly be welcomed.

   Reply
7. 

   Amit Arya

   April 2, 2014

   @Peter – Its great to know that you are finding QBO Reports API useful.
   We plan on adding the AR Aging Detail report to the API. We are still working through the release time frames for additional reports.
   It would be helpful if you can clarify/elaborate on following comments:
   – Making reports more analysis friendly
   – JSON first approach to data structure

   Reply
8. 

   pramod hb

   April 15, 2014

   I am looking for the reconciliation and balance sheet detail reports. Will it be made available in the near future?

   Regards
   Pramod

   Reply
9. 

   Jarred Keneally

   April 17, 2014

   The .Net and Java SDKs have been updated to support the new report APIs as well. https://developer.intuit.com/docs/0025_quickbooksapi/0055_devkits

   Reply
10. 

    pramod hb

    April 18, 2014

    Hi Jarred Keneally,

    The class reference http://developer-static.intuit.com/SDKDocs/QBV3Doc/IPPDotNetDevKitV3/ is not updated with ReportService.

    Second, I am looking for a way to get the transaction wise balance sheet. We have a GeneralDetailReportQuery request in QBXML SDK which used to fetch us each and every transaction of a particular account. I was interested in the Clear Status of each transaction. The Clear flag we see when a transaction is reconciled.

    Is there a way to get a Balance Sheet Detail Report? I see a class called “BalanceSheetDetail” and “BalanceSheetSummary” in the API. How do we use that?

    Reply
11. 

    gnagendrareddy

    April 29, 2014

    Is the reports available in php sdk. i’m looking for profit and loss report right now

    Reply
    1. 

       David

       May 1, 2014

       @gnagendrareddy – The PHP SDK doesn’t support JSON, so it doesn’t support reports. It is something we are looking into.
       -david

       Reply
12. 

    Rich Simpson

    May 15, 2014

    Is there a plan or schedule for more reports…I desperately need P

    Reply
    1. 

       David

       May 16, 2014

       @Rich
       Yes, more reports will be added to the API. Are there specific reports you need API access too?
       -david

       Reply
13. 

    Rich Simpson

    May 19, 2014

    Yes, I NEED P

    Reply
14. 

    Rich Simpson

    May 19, 2014

    Funny, I keep posting P and L using the amp and it truncates it….YES, I NEED P and L
    desperately

    Reply
15. 

    Rich Simpson

    May 19, 2014

    P and L DETAIL that is

    Reply
16. 

    Enoch

    May 16, 2017

    Does anyone by chance know how to access QBO reports in Microsoft Power BI? I’m invoking the function, that QBO has provided automatically after connecting to QBO successfully using their BETA Connection, but when I add the url fragment of the report (ex: https://qbo.intuit.com/app/reportv2?mem_rpt_id=590), it says I’m not authorized.. I have the highest clearance allowed in QBO but for some reason I’m not able to connect to the report.. Is this possibly because it’s not part of the listed reports via API? If there is a better place to ask about this, please let me know.

    Thank you,

    Reply
    1. 

       Lisa Rathjens

       May 18, 2017

       Hi Enoch, I recommend you post your question in the support forums for Power BI here http://support.powerbi.com# or in our developer forums here https://help.developer.intuit.com/s/ Good luck!

       Reply