Dates Listed by Year Instead of Month
Note: the response below should usually fit generally into the template laid out in the General Response format. If this issue was the only issue in the spreadsheet, you don't necessarily need to use the numbered list format ... since there's just one item in the list.
If your user has provided documents where each column covers a whole year, or something to that effect, then you'll need to explain we are looking for months in each column:
From what I can see, it looks like your columns are showing annual rather than monthly data. When you upload into CFO Scoreboard, what we're looking for is one column for each month, and a heading such as e.g. "Jan 2018" at the top of each column. So to move forward, you'll want to go back into your accounting system and create a new set of statements, that shows this monthly data we're looking for.
... Also if they have one of our "fully automatic" supported accounting systems, you can grab the video link from our Accounting System Instructions, and send something like this to the client:
We have a short video below on how to export your financial statements from QuickBooks into the format that CFO Scoreboard requires.
http://help.cfoscoreboard.com/category/66-accounting-system-export-instructionsLet me know if that works for you! Happy to help further if you have any questions or would like me to walk you through the export process.
OR IF IT'S YTDFrom what I can see, your Balance Sheet is showing year-to-date rather than monthly data. When you upload into CFO Scoreboard, what we're looking for is one column for each month, and a heading such as e.g. "Jan 2018" at the top of each column. So to move forward, you'll want to go back into your accounting system and create a new Balance Sheet that shows this monthly data from January 2014-October 2018, matching your Income Statement.
Month vs. Annual Accounting
The reason we use monthly is that is the frequency that all businesses use (or should use) to monitor the financial progress and health of their business. (The Fortune 500 is a pretty good litmus test of this statement…. And they all produce monthly financials). It is the appropriate methodology and is used by ALL major companies around the world. The only entity that requires annual financial reporting is the IRS and this is for tax purposes and not monitoring/running the business purposes.
Plugging in annual data does not provide the useful information required to make the changes and run the business end of a business…. Nor does it allow for analysis of the trends that are impacting the financial performance of the business.
If someone has 3-4 years of annual financial data (Income Statements and Balance Sheets), then this info could be entered into CFOS, but the column headings would have to look like a “month” and not a year…. E.g. 2009 = Jan 12 and 2010 = Feb 12 and 2011 = Mar 12.
The problem with this system is that when/if the user decides to start entering monthly data, the previously entered annual data would need to be deleted to avoid having distorted optics.
Again, having only annual data is not ideal because it does not provide the frequency of measurement that is required to successfully run a business and optimize the financial results.