Format Financial Statements with the Excel Add-In | CLEARIFY

Financial Formatting

The goal of QQube is to let the tool in which you create the report or visualization, do all of the work. However, the engineering for financial statements into Excel, combined with Excel formatting limitations, makes this necessary.

NOTE: In QQube Version 10, you have even more options in Power Pivot for financial summary data models - including EBIDTA

There are five options (1,2,3 available in Version 7.6 and later):

1. Black or Red Negative Values.  Negative Values Show as Black instead of the default Red.
2. "-" or "()" for Negative Values.  Negative Values use "-" instead of the default "()".
3. Decimals or Whole Numbers.  Whole Numbers Only instead of decimal default.
4. Display Only Non-Zero Rows. Hides those rows that have 0.00 in each column chosen for your analytic.
5. Presentation Cleanup. Applies the selected format options in 1 thru 4 above and "cleans-up" the appearance of certain Financial Statements to accommodate the data structure of QQube within an Excel spreadsheet.

They are both available in Excel and Excel PowerPivot for the following data models:

QuickBooks Pro, Premiere, Enterprise:

• Profit and Loss
• Profit and Loss by Class
• Balance Sheet
• Balance Sheet by Class
• Profit and Loss Detail (Formatting not available in Excel PowerPivot)

QuickBooks Enterprise Only:

• Profit and Loss - Actual/Budget/Forecast
• Profit and Loss - Freestyle
• Profit and Loss - 52/53 Tax Year
• Profit and Loss by Class - Actual/Budget/Forecast
• Profit and Loss by Class - Freestyle
• Profit and Loss by Class - 52/53 Tax Year

Presentation Cleanup

This option will perform the following:

• Hide blank rows that are the result of multi-level orphan accounts.  For example some top level accounts may have sub accounts, and some do not.  For those that don't, a row with an ugly "(blank)" in the label appears.
• Remove the Financial Grouping Prepends that QQube uses to effect proper order.  For instance, the letter "a" prepends the Income section so it comes before Cost of Goods Sold; QQube removes that.
• Reverse the "red" signage for COGS and Expenses, which were necessary to ensure that the figures added up properly.  Excel has no conditional formatting behavior.

First is the Raw QQube data (and something you probably wouldn't show to the boss):

Here is the same data, after Presentation Cleanup: