getBalanceSheets API

The getBalanceSheets API provides access to public company financial balance sheets based on symbol.

All APIs

Contact Us to Get Access

Inputs

symbols required

A symbol or code that identifies a financial instrument. Multiple symbols separated by a comma may be used.

Type
list (A comma or semi-colon delimited string.) 
Example
IBM,AAPL,GOOG 

frequency required

The frequency of financial statement reporting, either Quarterly ("Quarter") or Annually ("Annual").

Type
enum (A type which includes a list of valid possible values.) 
Example
Quarter 

Valid Values:
Quarter, Annual

count optional

The number of Quarterly or Annual periods of financial statements to return.

Type
int (A numeric type defining a whole number. (example: 2)) 
Example
Default

rawData optional

Return raw data, otherwise sales, costs, expenses, tax, and income data is displayed in thousands.

Type
int (A numeric type defining a whole number. (example: 2)) 
Example

Outputs

Name / Requirement
Description
Type
symbol
always returned
A symbol or code that identifies a financial instrument.
string
A sequence of characters. (example: GOOG)
date
always returned
The date of the financial statement.
date
A date in the format of YYYY-MM-DD.
cash
always returned
Money that is immediately available to a company.
double
A numeric type defining a number with fractional parts. (example: 2.14)
marketableSec
always returned
Liquid securities that can be converted to cash.
double
A numeric type defining a number with fractional parts. (example: 2.14)
receivables
always returned
The amount of receivables due to a company.
double
A numeric type defining a number with fractional parts. (example: 2.14)
prepaidExpenses
always returned
A type of asset that arises on a balance sheet as a result of business making payments for goods and services to be received in the near future.
double
A numeric type defining a number with fractional parts. (example: 2.14)
inventories
always returned
The value of inventory on hand.
double
A numeric type defining a number with fractional parts. (example: 2.14)
deferredIncomeTax
always returned
Income tax that has been deferred.
double
A numeric type defining a number with fractional parts. (example: 2.14)
otherCurrentAssets
always returned
Miscellaneous current assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalCurrentAssets
always returned
The total amount of current assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
ppeNet
always returned
The net value of property, plant and equipment.
double
A numeric type defining a number with fractional parts. (example: 2.14)
equityOtherInvestments
always returned
The value of company equity and other investments.
double
A numeric type defining a number with fractional parts. (example: 2.14)
intangibles
always returned
The value of intangible assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
otherNonCurrentAssets
always returned
Miscellaneous non-current assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalNonCurrentAssets
always returned
The total amount of non-current assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalAssets
always returned
The sum of all assets.
double
A numeric type defining a number with fractional parts. (example: 2.14)
shorttermDebt
always returned
Debt due within one year.
double
A numeric type defining a number with fractional parts. (example: 2.14)
accountsPayable
always returned
The amount of payables outstanding.
double
A numeric type defining a number with fractional parts. (example: 2.14)
incomeTaxPayable
always returned
The amount of income tax outstanding.
double
A numeric type defining a number with fractional parts. (example: 2.14)
accruedExpenses
always returned
Expenses that have already been accrued.
double
A numeric type defining a number with fractional parts. (example: 2.14)
otherCurrentLiabilities
always returned
Miscellaneous current liabilities.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalCurrentLiabilities
always returned
The total amount of current liabilities.
double
A numeric type defining a number with fractional parts. (example: 2.14)
longTermDebt
always returned
Debt due in more than one-year.
double
A numeric type defining a number with fractional parts. (example: 2.14)
deferredLongRevenues
always returned
Revenue deferred for more than one-year.
double
A numeric type defining a number with fractional parts. (example: 2.14)
otherNonCurrentLiabilities
always returned
Miscellaneous non-current liabilities.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalNonCurrentLiabilities
always returned
The total amount of non-current liabilities.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalLiabilities
always returned
The sum of all liabilities.
double
A numeric type defining a number with fractional parts. (example: 2.14)
commonShares
always returned
The par or stated value of shares outstanding.
double
A numeric type defining a number with fractional parts. (example: 2.14)
retainedEarnings
always returned
Earnings retained by the company.
double
A numeric type defining a number with fractional parts. (example: 2.14)
otherEquity
always returned
Miscellaneous equity.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalShareholdersEquity
always returned
The total value of shareholder's equity.
double
A numeric type defining a number with fractional parts. (example: 2.14)
totalLiabilitiesAndEquity
always returned
The sum of total liabilties and shareholder's equity.
double
A numeric type defining a number with fractional parts. (example: 2.14)

Status Code Responses

200
OK
Success
400
Bad Request
The request was invalid, please see the message for more information.
500
Internal Server Error
Something is not working correctly, please contact support.


JSON

GET

GET https://ondemand.websol.barchart.com/getBalanceSheets.json?apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getBalanceSheets.json
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1

Response

{
    "status": {
        "code": 200,
        "message": "Success."
    },
    "results": [
        {
            "symbol": "IBM",
            "date": "2017-09-30",
            "cash": 10915000000,
            "marketableSec": 600000000,
            "receivables": 9076000000,
            "prepaidExpenses": 4389000000,
            "inventories": 1711000000,
            "deferredIncomeTax": 0,
            "otherCurrentAssets": 18051000000,
            "totalCurrentAssets": 44742000000,
            "ppeNet": 11057000000,
            "equityOtherInvestments": 4806000000,
            "intangibles": 40763000000,
            "otherNonCurrentAssets": 20269000000,
            "totalNonCurrentAssets": 76895000000,
            "totalAssets": 121636000000,
            "shorttermDebt": 4299000000,
            "accountsPayable": 5442000000,
            "incomeTaxPayable": 3038000000,
            "accruedExpenses": 0,
            "otherCurrentLiabilities": 8269000000,
            "totalCurrentLiabilities": 31697000000,
            "longTermDebt": 41327000000,
            "deferredLongRevenues": 10649000000,
            "otherNonCurrentLiabilities": 25277000000,
            "totalNonCurrentLiabilities": 70183000000,
            "totalLiabilities": 101879000000,
            "commonShares": 54395000000,
            "retainedEarnings": 155565000000,
            "otherEquity": -27391000000,
            "totalShareholdersEquity": 19757000000,
            "totalLiabilitiesAndEquity": 121636000000
        },
        {
            "symbol": "AAPL",
            "date": "2017-09-30",
            "cash": 20289000000,
            "marketableSec": 53892000000,
            "receivables": 35673000000,
            "prepaidExpenses": 0,
            "inventories": 4855000000,
            "deferredIncomeTax": 0,
            "otherCurrentAssets": 13936000000,
            "totalCurrentAssets": 128645000000,
            "ppeNet": 33783000000,
            "equityOtherInvestments": 194714000000,
            "intangibles": 8015000000,
            "otherNonCurrentAssets": 10162000000,
            "totalNonCurrentAssets": 246674000000,
            "totalAssets": 375319000000,
            "shorttermDebt": 18473000000,
            "accountsPayable": 49049000000,
            "incomeTaxPayable": 0,
            "accruedExpenses": 25744000000,
            "otherCurrentLiabilities": 0,
            "totalCurrentLiabilities": 100814000000,
            "longTermDebt": 97207000000,
            "deferredLongRevenues": 7548000000,
            "otherNonCurrentLiabilities": 40415000000,
            "totalNonCurrentLiabilities": 140458000000,
            "totalLiabilities": 241272000000,
            "commonShares": 35867000000,
            "retainedEarnings": 98330000000,
            "otherEquity": -150000000,
            "totalShareholdersEquity": 134047000000,
            "totalLiabilitiesAndEquity": 375319000000
        },
        {
            "symbol": "GOOG",
            "date": "2017-09-30",
            "cash": 10581000000,
            "marketableSec": 89562000000,
            "receivables": 15577000000,
            "prepaidExpenses": 0,
            "inventories": 765000000,
            "deferredIncomeTax": 0,
            "otherCurrentAssets": 2860000000,
            "totalCurrentAssets": 119345000000,
            "ppeNet": 40120000000,
            "equityOtherInvestments": 7269000000,
            "intangibles": 19614000000,
            "otherNonCurrentAssets": 3188000000,
            "totalNonCurrentAssets": 70191000000,
            "totalAssets": 189536000000,
            "shorttermDebt": 0,
            "accountsPayable": 2674000000,
            "incomeTaxPayable": 221000000,
            "accruedExpenses": 16529000000,
            "otherCurrentLiabilities": 0,
            "totalCurrentLiabilities": 20693000000,
            "longTermDebt": 3964000000,
            "deferredLongRevenues": 1269000000,
            "otherNonCurrentLiabilities": 7282000000,
            "totalNonCurrentLiabilities": 11743000000,
            "totalLiabilities": 32436000000,
            "commonShares": 694000,
            "retainedEarnings": 118237000000,
            "otherEquity": -745994000,
            "totalShareholdersEquity": 157100000000,
            "totalLiabilitiesAndEquity": 189536000000
        }
    ]
}

XML

GET

GET https://ondemand.websol.barchart.com/getBalanceSheets.xml?apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getBalanceSheets.xml
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1

Response


<?xml version="1.0" encoding="utf-8"?>
 <getBalanceSheets>
  <status>
   <code>200</code>
   <message>Success.</message>
  </status>
  <item>
   <symbol>IBM</symbol>
   <date>2017-09-30</date>
   <cash>10915000000</cash>
   <marketableSec>600000000</marketableSec>
   <receivables>9076000000</receivables>
   <prepaidExpenses>4389000000</prepaidExpenses>
   <inventories>1711000000</inventories>
   <deferredIncomeTax>0</deferredIncomeTax>
   <otherCurrentAssets>18051000000</otherCurrentAssets>
   <totalCurrentAssets>44742000000</totalCurrentAssets>
   <ppeNet>11057000000</ppeNet>
   <equityOtherInvestments>4806000000</equityOtherInvestments>
   <intangibles>40763000000</intangibles>
   <otherNonCurrentAssets>20269000000</otherNonCurrentAssets>
   <totalNonCurrentAssets>76895000000</totalNonCurrentAssets>
   <totalAssets>121636000000</totalAssets>
   <shorttermDebt>4299000000</shorttermDebt>
   <accountsPayable>5442000000</accountsPayable>
   <incomeTaxPayable>3038000000</incomeTaxPayable>
   <accruedExpenses>0</accruedExpenses>
   <otherCurrentLiabilities>8269000000</otherCurrentLiabilities>
   <totalCurrentLiabilities>31697000000</totalCurrentLiabilities>
   <longTermDebt>41327000000</longTermDebt>
   <deferredLongRevenues>10649000000</deferredLongRevenues>
   <otherNonCurrentLiabilities>25277000000</otherNonCurrentLiabilities>
   <totalNonCurrentLiabilities>70183000000</totalNonCurrentLiabilities>
   <totalLiabilities>101879000000</totalLiabilities>
   <commonShares>54395000000</commonShares>
   <retainedEarnings>155565000000</retainedEarnings>
   <otherEquity>-27391000000</otherEquity>
   <totalShareholdersEquity>19757000000</totalShareholdersEquity>
   <totalLiabilitiesAndEquity>121636000000</totalLiabilitiesAndEquity>
  </item>
  <item>
   <symbol>AAPL</symbol>
   <date>2017-09-30</date>
   <cash>20289000000</cash>
   <marketableSec>53892000000</marketableSec>
   <receivables>35673000000</receivables>
   <prepaidExpenses>0</prepaidExpenses>
   <inventories>4855000000</inventories>
   <deferredIncomeTax>0</deferredIncomeTax>
   <otherCurrentAssets>13936000000</otherCurrentAssets>
   <totalCurrentAssets>128645000000</totalCurrentAssets>
   <ppeNet>33783000000</ppeNet>
   <equityOtherInvestments>194714000000</equityOtherInvestments>
   <intangibles>8015000000</intangibles>
   <otherNonCurrentAssets>10162000000</otherNonCurrentAssets>
   <totalNonCurrentAssets>246674000000</totalNonCurrentAssets>
   <totalAssets>375319000000</totalAssets>
   <shorttermDebt>18473000000</shorttermDebt>
   <accountsPayable>49049000000</accountsPayable>
   <incomeTaxPayable>0</incomeTaxPayable>
   <accruedExpenses>25744000000</accruedExpenses>
   <otherCurrentLiabilities>0</otherCurrentLiabilities>
   <totalCurrentLiabilities>100814000000</totalCurrentLiabilities>
   <longTermDebt>97207000000</longTermDebt>
   <deferredLongRevenues>7548000000</deferredLongRevenues>
   <otherNonCurrentLiabilities>40415000000</otherNonCurrentLiabilities>
   <totalNonCurrentLiabilities>140458000000</totalNonCurrentLiabilities>
   <totalLiabilities>241272000000</totalLiabilities>
   <commonShares>35867000000</commonShares>
   <retainedEarnings>98330000000</retainedEarnings>
   <otherEquity>-150000000</otherEquity>
   <totalShareholdersEquity>134047000000</totalShareholdersEquity>
   <totalLiabilitiesAndEquity>375319000000</totalLiabilitiesAndEquity>
  </item>
  <item>
   <symbol>GOOG</symbol>
   <date>2017-09-30</date>
   <cash>10581000000</cash>
   <marketableSec>89562000000</marketableSec>
   <receivables>15577000000</receivables>
   <prepaidExpenses>0</prepaidExpenses>
   <inventories>765000000</inventories>
   <deferredIncomeTax>0</deferredIncomeTax>
   <otherCurrentAssets>2860000000</otherCurrentAssets>
   <totalCurrentAssets>119345000000</totalCurrentAssets>
   <ppeNet>40120000000</ppeNet>
   <equityOtherInvestments>7269000000</equityOtherInvestments>
   <intangibles>19614000000</intangibles>
   <otherNonCurrentAssets>3188000000</otherNonCurrentAssets>
   <totalNonCurrentAssets>70191000000</totalNonCurrentAssets>
   <totalAssets>189536000000</totalAssets>
   <shorttermDebt>0</shorttermDebt>
   <accountsPayable>2674000000</accountsPayable>
   <incomeTaxPayable>221000000</incomeTaxPayable>
   <accruedExpenses>16529000000</accruedExpenses>
   <otherCurrentLiabilities>0</otherCurrentLiabilities>
   <totalCurrentLiabilities>20693000000</totalCurrentLiabilities>
   <longTermDebt>3964000000</longTermDebt>
   <deferredLongRevenues>1269000000</deferredLongRevenues>
   <otherNonCurrentLiabilities>7282000000</otherNonCurrentLiabilities>
   <totalNonCurrentLiabilities>11743000000</totalNonCurrentLiabilities>
   <totalLiabilities>32436000000</totalLiabilities>
   <commonShares>694000</commonShares>
   <retainedEarnings>118237000000</retainedEarnings>
   <otherEquity>-745994000</otherEquity>
   <totalShareholdersEquity>157100000000</totalShareholdersEquity>
   <totalLiabilitiesAndEquity>189536000000</totalLiabilitiesAndEquity>
  </item>
 </getBalanceSheets>

CSV

GET

GET https://ondemand.websol.barchart.com/getBalanceSheets.csv?apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getBalanceSheets.csv
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=<YOUR API KEY>&symbols=IBM%2CAAPL%2CGOOG&frequency=Quarter&count=1&rawData=1

Response

symbol,date,cash,marketableSec,receivables,prepaidExpenses,inventories,deferredIncomeTax,otherCurrentAssets,totalCurrentAssets,ppeNet,equityOtherInvestments,intangibles,otherNonCurrentAssets,totalNonCurrentAssets,totalAssets,shorttermDebt,accountsPayable,incomeTaxPayable,accruedExpenses,otherCurrentLiabilities,totalCurrentLiabilities,longTermDebt,deferredLongRevenues,otherNonCurrentLiabilities,totalNonCurrentLiabilities,totalLiabilities,commonShares,retainedEarnings,otherEquity,totalShareholdersEquity,totalLiabilitiesAndEquity
"IBM","2017-09-30","10915000000","600000000","9076000000","4389000000","1711000000","0","18051000000","44742000000","11057000000","4806000000","40763000000","20269000000","76895000000","121636000000","4299000000","5442000000","3038000000","0","8269000000","31697000000","41327000000","10649000000","25277000000","70183000000","101879000000","54395000000","155565000000","-27391000000","19757000000","121636000000"
"AAPL","2017-09-30","20289000000","53892000000","35673000000","0","4855000000","0","13936000000","128645000000","33783000000","194714000000","8015000000","10162000000","246674000000","375319000000","18473000000","49049000000","0","25744000000","0","100814000000","97207000000","7548000000","40415000000","140458000000","241272000000","35867000000","98330000000","-150000000","134047000000","375319000000"
"GOOG","2017-09-30","10581000000","89562000000","15577000000","0","765000000","0","2860000000","119345000000","40120000000","7269000000","19614000000","3188000000","70191000000","189536000000","0","2674000000","221000000","16529000000","0","20693000000","3964000000","1269000000","7282000000","11743000000","32436000000","694000","118237000000","-745994000","157100000000","189536000000"


PHP

<?php

$ondemand = new SoapClient('https://ondemand.websol.barchart.com/service?wsdl');

$params = [
    'symbols' => 'IBM,AAPL,GOOG',
    'frequency' => 'Quarter',
    'count' => '1',
    'rawData' => '1',
];

$result = $ondemand->getBalanceSheets($params);
var_dump($result);

Classic ASP

Dim ondemand
Dim result

Set ondemand = Server.CreateObject("MSSOAP.SoapClient30")
ondemand.ClientProperty("ServerHTTPRequest") = True
ondemand.MSSoapInit("https://ondemand.websol.barchart.com/service?wsdl")

Set result = ondemand.getBalanceSheets("IBM,AAPL,GOOG", "Quarter", "1", "1")

Perl

use SOAP::Lite;
use SOAP::WSDL;

my $ondemand = SOAP::Lite
    -> service('https://ondemand.websol.barchart.com/service?wsdl');

my $result = $ondemand->getBalanceSheets('IBM,AAPL,GOOG', 'Quarter', '1', '1');

print $result;

Python

from suds.client import Client
ondemand = Client('https://ondemand.websol.barchart.com/service?wsdl')

result = client.service.getBalanceSheets('IBM,AAPL,GOOG', 'Quarter', '1', '1')

print result

Ruby

require 'savon'

ondemand = Savon.client(wsdl: 'https://ondemand.websol.barchart.com/service?wsdl')

response = ondemand.call(
    :getBalanceSheets,
    message: {
        symbols: 'IBM,AAPL,GOOG',
        frequency: 'Quarter',
        count: '1',
        rawData: '1',
    }
)

response.body