ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Understanding Business Intelligence Reports
3
5
6
7
8
BLACK text explains how to read the report RED text identifies actions to be taken
9
10
KPI Ratio Trending Analysis
11
 • These are period-over-period and year-to-date, year-over-year views of the most popular ratios.
• Green arrows are “good”, red arrows are “bad”.
• Pay close attention to Months of Cash Reserves in the CASH section of these reports!
12
 If you see numerous red arrows, call me for insights and suggestions to resolve the issues that are negatively impacting your bottom-line.
13
Total Income and Net Income Analysis
14
 • This 3-Dimensional chart shows Total Income and Net Income, by month, over a 2-year period.
• The left-most column is Income, the right-most column is Year-Over-Year Variance.
• Current year is the active color, last year is the passive color.
• (Total Income) Illustrates how you are doing year-over-year by month, as well as year-to-date trending.
• (Net Income) You want the graphed pattern of Net Income to mirror or be slightly better than its monthly counterpart in Total Income.
15
 If mirrored, you are controlling costs. If not, give me a call to discuss a strategy to better control the costs that are negatively impacting your Net Income.
16
Expense Control Analysis
17
 If you want to make an immediate impact on your profits, it’s best to focus on controlling your largest expenses.
• This report automatically identifies, and stack ranks your Top 10 Expenses.
• It auto-populates whatever those expenses are called in your Chart of Accounts into column A.
• It compares them year-over-year and graphs the data (current year = active color; prior year = passive color).
18
 The better you control these expenses, the faster your “Red” arrows will become “Green” (KPI Ratios reports) and the more Net Income you will have!
19
Forecast Trend Analysis
20
 • Provides a snapshot of last month’s performance.
• A forward-looking trend analysis highlights the main areas of your P&L.
• Ideally, as “Red” arrows become “Green” (KPI Ratios reports) because your larger expenses are being better controlled
21
 (Expense Analysis report), your projected Net Income will continue to increase!
22
 If you are seeing a negative or small single digit percentage in the Net Income line, YTD-YOY Variance column, we should talk.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101