Home › Forums › The XBRL API › Signs for AccRec Change and Inventories Change are reversed
- This topic has 1 reply, 2 voices, and was last updated 6 months, 3 weeks ago by
fayolaa mary.
-
AuthorPosts
-
-
Friday, January 11, 2019 at 12:32 PM #120361
Tim Bui
ParticipantI just noticed that the sign for concepts “IncreaseDecreaseInAccountsReceivable” and
“IncreaseDecreaseInInventories” are actually reversed. In case someone didn’t notice, I am alerting this fact so that these numbers can be used properly.The issue is not a problem with XBRL.US’s API, but it seems to be that is the way companies are reporting these two items.
If AccRec increased and Inventories increased, the API calls return a positive AccRec number and a positive Inventories number. However, the cash flow statements would report a negative change in AccRec (use of cash) and a negative change in Inventories (use of cash). I think this is the reason for the reversed sign. The strange thing is all other items such as Change in AccPayable, Change in Other Working Capital or Change in Accrued Liabilities
have the same directional signs on both the API calls and the 10Ks.For example:
Merck (MCK, CIK 310158), the API returned a negative $297MM and positive $145MM.
us-gaap IncreaseDecreaseInAccountsReceivable (297,000,000)
us-gaap IncreaseDecreaseInInventories 145,000,000
However, on the 10K, the change in AccRec is a positive $297MM and change in Inventories is a negative ($145)I saw the same situation reported at Air Products (APD, CIK 2969 ) and Apple (AAPL, CIK 320193)
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
Recent Replies
-
Get Balance Sheet with single API call 3 days, 1 hour ago
-
oauth2 Not Giving Access Token 3 days, 12 hours ago
-
Missing Data – Costco Wholesale Corp 2 weeks, 3 days ago
-
Missing Data – Costco Wholesale Corp 2 weeks, 5 days ago
-
Tackling issues with operating lease data 1 month ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- Create a Google Account (without Gmail)
- Install XBRL API Access (Google Sheet Add-on) (troubleshooting access)
- Make a Copy... of Google Sheet Templates
- OR get access to data for your own app and/or our API Tools
Who's using this free data?
API Use 2020 || API Use 2019
API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
XBRL Data Events
In the Last Year:
Upcoming XBRL US Events




Comment
You must be logged in to post a comment.