Financial Reports
Home Up Corporate Database Financial Reports

 

In a CUFFS-88 Multidimensional Report you can select any number of items from any number of dimensions and choose how you want to display the information for the most meaningful financial reports. The dimensions may include levels of a corporate tree, time, accounts (such as Sales or Net Profit), and computed dimensions such as Variance between time periods or between corporate divisions.   There is no limit to the number of dimensions you may put on any row, column, or page of a  report.
EXAMPLES based on sample corporate tree structure
These six reports present the same information six different ways.  
REPORT ONE Each Division is put on a separate page.
REPORT TWO Each Row shows 3 dimensions of data: (1) Budget vs Actual (2) Accounts (Net Profit and Assets) and (3) Divisions (Div 1, Div 2)
REPORT THREE Shows only the month of March. The columns show two dimensions of data: (1) Budget vs Actual and (2) Accounts (Sales and Net Profit), while the rows dispaly a third dimension, Divisions.  See how to define this report below.
REPORT FOUR The columns of this report show two dimensions of data: (1) Months and (2) Accounts (Net Profit and Sales).  The rows also show two dimensions: (1) Budget vs Actual and (2) Divisions.
REPORT FIVE REPORT FIVE and REPORT SIX show the same consolidated data from divisions.   They also show how Budget and Actual can be compared to show Variance in dollars and Variance as % of Sales. These Variances were derived from Budget and Actual in creation of the report.  REPORT FIVE shows the months as columns and the other dimensions on the rows.
REPORT SIX REPORT SIX is the same data as REPORT FIVE, but shows the Budget, Actual, Variance, and Variance as % of Sales as the columns with rows showing (1) Accounts (Sales, Cost of Sales, Net Profit) and (2) Months.
Reports are easy to specify: select any information you want from anywhere in the information hierarchy and put in in the rows, pages, and columns of the report.  Here is the specification for Report Three:

REPORT THREE
Time = "March 1999"
Accounts = Sales, Net Profit
Rows = Division
Pages = Time
Columns = Budget vs Actual:Accounts
END

Totals across time are especially easy.  Items tagged "Asset" (LEVELS) are handled differently from those tagged "Indome" (FLOW).  If the Divisions are calculated in months, but BUDGET and ACTUAL are to be quarterly, CUFFS-88 will automatically combine the months, again treating levels and flows differently.  Currency translation between any two entities is done automatically too.

 

 

Home ] Up ] Sample Report 1 ] Sample Report 2 ] Sample Report 3 and 4 ] Sample Report 5 ] Sample Report 6 ]

Cuffs-88® is a trademark of Cuffs Planning & Models, Ltd.,   copyright ©2001  For information on software or consulting,   educational use of software, or web site comments, contact info@cuffs88.com  .  Cuffs Planning & Models, Ltd. is a New York company founded in 1972.