intuit-api-quickbooks-pnl.json

{
  "Header": {
    "Time": "2022-09-14T12:20:17-07:00",
    "ReportName": "ProfitAndLoss",
    "ReportBasis": "Accrual",
    "StartPeriod": "2022-06-01",
    "EndPeriod": "2022-09-30",
    "SummarizeColumnsBy": "Total",
    "Currency": "USD",
    "Customer": "1",
    "Option": [
      {
        "Name": "AccountingStandard",
        "Value": "GAAP"
      },
      {
        "Name": "NoReportData",
        "Value": "false"
      }
    ]
  },
  "Columns": {
    "Column": [
      {
        "ColTitle": "",
        "ColType": "Account",
        "MetaData": [
          {
            "Name": "ColKey",
            "Value": "account"
          }
        ]
      },
      {
        "ColTitle": "Total",
        "ColType": "Money",
        "MetaData": [
          {
            "Name": "ColKey",
            "Value": "total"
          }
        ]
      }
    ]
  },
  "Rows": {
    "Row": [
      {
        "Header": {
          "ColData": [
            {
              "value": "Income"
            },
            {
              "value": ""
            }
          ]
        },
        "Rows": {
          "Row": [
            {
              "Header": {
                "ColData": [
                  {
                    "value": "Landscaping Services",
                    "id": "45"
                  },
                  {
                    "value": "220.00"
                  }
                ]
              },
              "Rows": {
                "Row": [
                  {
                    "Header": {
                      "ColData": [
                        {
                          "value": "Job Materials",
                          "id": "46"
                        },
                        {
                          "value": ""
                        }
                      ]
                    },
                    "Rows": {
                      "Row": [
                        {
                          "ColData": [
                            {
                              "value": "Fountains and Garden Lighting",
                              "id": "48"
                            },
                            {
                              "value": "275.00"
                            }
                          ],
                          "type": "Data"
                        },
                        {
                          "ColData": [
                            {
                              "value": "Plants and Soil",
                              "id": "49"
                            },
                            {
                              "value": "150.00"
                            }
                          ],
                          "type": "Data"
                        }
                      ]
                    },
                    "Summary": {
                      "ColData": [
                        {
                          "value": "Total Job Materials"
                        },
                        {
                          "value": "425.00"
                        }
                      ]
                    },
                    "type": "Section"
                  },
                  {
                    "Header": {
                      "ColData": [
                        {
                          "value": "Labor",
                          "id": "51"
                        },
                        {
                          "value": ""
                        }
                      ]
                    },
                    "Rows": {
                      "Row": [
                        {
                          "ColData": [
                            {
                              "value": "Maintenance and Repair",
                              "id": "53"
                            },
                            {
                              "value": "50.00"
                            }
                          ],
                          "type": "Data"
                        }
                      ]
                    },
                    "Summary": {
                      "ColData": [
                        {
                          "value": "Total Labor"
                        },
                        {
                          "value": "50.00"
                        }
                      ]
                    },
                    "type": "Section"
                  }
                ]
              },
              "Summary": {
                "ColData": [
                  {
                    "value": "Total Landscaping Services"
                  },
                  {
                    "value": "695.00"
                  }
                ]
              },
              "type": "Section"
            },
            {
              "ColData": [
                {
                  "value": "Pest Control Services",
                  "id": "54"
                },
                {
                  "value": "-65.00"
                }
              ],
              "type": "Data"
            }
          ]
        },
        "Summary": {
          "ColData": [
            {
              "value": "Total Income"
            },
            {
              "value": "630.00"
            }
          ]
        },
        "type": "Section",
        "group": "Income"
      },
      {
        "Summary": {
          "ColData": [
            {
              "value": "Gross Profit"
            },
            {
              "value": "630.00"
            }
          ]
        },
        "type": "Section",
        "group": "GrossProfit"
      },
      {
        "Header": {
          "ColData": [
            {
              "value": "Expenses"
            },
            {
              "value": ""
            }
          ]
        },
        "Summary": {
          "ColData": [
            {
              "value": "Total Expenses"
            },
            {
              "value": ""
            }
          ]
        },
        "type": "Section",
        "group": "Expenses"
      },
      {
        "Summary": {
          "ColData": [
            {
              "value": "Net Operating Income"
            },
            {
              "value": "630.00"
            }
          ]
        },
        "type": "Section",
        "group": "NetOperatingIncome"
      },
      {
        "Summary": {
          "ColData": [
            {
              "value": "Net Income"
            },
            {
              "value": "630.00"
            }
          ]
        },
        "type": "Section",
        "group": "NetIncome"
      }
    ]
  }
}

intuit-api-quickbooks-pnl.md

# Get Access Token and Realm ID from https://developer.intuit.com/v2/OAuth2Playground/RedirectUrl

INTUIT_BASE_URL=https://sandbox-quickbooks.api.intuit.com
INTUIT_ACCESS_TOKEN=xxxx
INTUIT_REALM_ID=4620816365242359160

curl "${INTUIT_BASE_URL}/v3/company/${INTUIT_REALM_ID}/reports/ProfitAndLoss?start_date=2022-06-01&end_date=2022-09-30&customer=1&minorversion=65" \
    -H "Accept: application/json" \
    -H "Authorization: Bearer ${INTUIT_ACCESS_TOKEN}" |
    jq