Skip to main content
This Board Has Moved

This board has been migrated to our new platform! Check out the new home page at or click below to go directly to the new Board on the new site.

Go to the New Site
Message Font: Serif | Sans-Serif
No. of Recommendations: 0
I have set up an Excel spreadsheet that automatically gets the Financial Statement information using the RCH functions. However, no matter which service I use (Reuters, Google, etc.) the numbers are not matching what DELL has published in their 10K. Why is this happening? Is there a workaround?

Some examples might help?

However, from what I've seen in writing the add-in and looking at financial statements on the various services, they tend to "pigeon hole" the information differently because they publish fewer line items than the 10-K filings have.

For the general items, they are usually OK, but when you get down to the finer level of detail, there is little consistency. I've even seen cases where "Cash and Equivalents" is significantly different between services because of how they treat the applicable (by their definition) sub-items. For example, some include "Restricted Cash", others do not.
Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.