FINANCIAL REPORTING - SAMPLES

All information is for Demo Use Only
Please do not replicate in any form without written consent of owner

  *** Combined Balance Sheet Report Sample - Month End + Multiple Company (cash-to-accrual transition)
1
          Cmpny A Accrual   Cmpny B Accrual   Cmpny B Cash   Total
ASSETS                  
Current Assets              
  Checking/Savings              
    City National Payroll 78,235.17   -1,378.62   410.83   77,267.38
    City National Retainers Account 271,711.00   50,836.68   -57,410.83   265,136.85
    Client Trust Accounts              
      CA - City Nat'l -7,068.49   43,080.50   -60.00   35,952.01
      IL - Bank One(********) 25.00   100.00       125.00
      MI - Bank One(*********) 25.00   153.20   0.20   178.40
      OH - Bank One(*********) 25.00   100.00       125.00
    Total Client Trust Accounts -6,993.49   43,433.70   -59.80   36,380.41
    Petty Cash 800.00       -0.20   799.80
    Wells Fargo Deposit Account 35,183.04   -1,439.66       33,743.38
  Total Checking/Savings 378,935.72   91,452.10   -57,060.00   413,327.82
    Accounts Receivable              
    Accounts Receivable -20,111.91   -2,900.00       -23,011.91
  Total Accounts Receivable -20,111.91   -2,900.00       -23,011.91
    Other Current Assets              
    Due to/from Cmpny A / Cmpny B Accrual 695,023.73   -494,046.29   529,171.60   730,149.04
    Employee Advances 1,975.00           1,975.00
    Exchange Account -20,754.63   4,000.00       -16,754.63
    Office Security Deposit         400.00   400.00
    Undeposited Funds 8,000.00           8,000.00
    Deposits     325.00       325.00
  Total Other Current Assets 684,244.10   -489,721.29   529,571.60   724,094.41
  Total Current Assets 1,043,067.91   -401,169.19   472,511.60   1,114,410.32
  Total Fixed Assets         10,922.22   10,922.22
  Total Other Assets         75,000.00   75,000.00
TOTAL ASSETS 1,043,067.91   -401,169.19   558,433.82   1,200,332.54
LIABILITIES & EQUITY              
Liabilities                
  Current Liabilities              
    Accounts Payable              
      Contractors Payable     -4,925.00       -4,925.00
      Vendors Payable 6,684.91       196,060.75   202,745.66
    Total Accounts Payable 6,684.91   -4,925.00   196,060.75   197,820.66
      Credit Cards              
      Citi AAdvantage - **** 61,999.16           61,999.16
      America Express - **** 21,101.31   96.74       21,198.05
      US Bank - **** 14,609.52   -9,841.55   -25,000.00   -20,232.03
    Total Credit Cards 97,709.99   -9,744.81   -25,000.00   62,965.18
      Other Current Liabilities              
      Client Trust Funds 9,683.00   31,230.50       40,913.50
      Garnishments Payable 3,972.26   1,476.88       5,449.14
      Loan from Company B 15,975.00           15,975.00
      Due to/from Cmpny B Cash GL     160,048.08       160,048.08
      Reserve For Yellow Pages     61,623.00       61,623.00
      Payroll Taxes Payable 3,519.01       -55,846.27   -52,327.26
      Total Accruals         55,000.00   55,000.00
      Total Trust Account         36,654.43   36,654.43
      Total Flex Spending Accrual         403.89   403.89
    Total Other Current Liabilities 33,149.27   254,378.46   36,212.05   323,739.78
    Total Current Liabilities 137,544.17   239,708.65   207,272.80   584,525.62
    Total Long Term Liabilities         179,901.69   179,901.69
  Total Liabilities 137,544.17   239,708.65   387,174.49   764,427.31
  Equity                  
  Profit Draw 61.69   -150,599.90   -1,639,899.91   -1,790,438.12
  Owner Equity         114,436.68   114,436.68
  Retained Earnings 868,160.86   -473,303.70   1,696,722.56   2,091,579.72
  Net Income 37,301.19   -16,974.24       20,326.95
Total Equity 905,523.74   -640,877.84   171,259.33   435,905.23
TOTAL LIABILITIES & EQUITY 1,043,067.91   -401,169.19   558,433.82   1,200,332.54
 

 

  *** Combined P&L Sample
4
Cmpny A / Cmpny B
Combined Profit Loss
January  2004
                Cmpny A   Cmpny B   Total % of Income
  Ordinary Income/Expense            
      Income                  
      Domestic Violence 27,400.00       27,400.00 4.1%
      Driving Under Suspended License 7,400.00       7,400.00 1.1%
      Driving Under the Influence 172,700.00   454.12   173,154.12 25.7%
      Drug       100,100.00   150.00   100,250.00 14.9%
      Force       100,224.00       100,224.00 14.9%
      Fraud       47,925.00   785.00   48,710.00 7.2%
      License Defense 1,300.00       1,300.00 0.2%
      Other       80,550.00       80,550.00 12.0%
      Pre File     14,500.00       14,500.00 2.2%
      Property     28,850.00   1,414.14   30,264.14 4.5%
      Sex Cases     94,750.00   560.00   95,310.00 14.2%
      Violation of Parole 34,900.00   100.00   35,000.00 5.2%
      Weapon     42,000.00       42,000.00 6.2%
      Client Refunds -70,579.83       -70,579.83 -10.5%
      Client Write-offs 0.00   0.00   0.00 0.0%
        Client NSF     -12,500.00       -12,500.00 -1.9%
      Total Income   669,519.17   3,463.26   672,982.43 100.0%
      Cost of Goods Sold            
      4001 · Attorneys            
        4023 · Attorney Dept. Misc. 0.00       0.00  
        4010 · Admin Management 7,250.00       7,250.00  
        4011 · Salaried Attorneys 7,433.34       7,433.34  
        4017 · Admin Staff 4,959.38       4,959.38  
        4021 · Ind Contractor Attorneys 61,407.50   20,437.50   81,845.00  
        4031 · Auto Allowance-Reimb 549.56       549.56  
          4032 · Phone/Fax-Reimb 2,579.47       2,579.47  
      Total 4001 · Attorneys 84,179.25   20,437.50   104,616.75  
      Total COGS     84,179.25   20,437.50   104,616.75 15.5%
    Gross Profit       585,339.92   -16,974.24   568,365.68  
      Expense                  
        ADMINISTRATION            
        4004 · Office Staff            
          4014 · Salaried Office Staff 19,290.47       19,290.47  
        Total 4004 · Office Staff 19,290.47       19,290.47  
          4020 · Management Salary 14,916.66       14,916.66  
        Total ADMINISTRATION 34,207.13       34,207.13 5.1%
        GENERAL & ADMINISTRATIVE            
        4090 · Other            
          4006 · Payroll Taxes - Employer 29,131.70       29,131.70  
          4007 · Payroll Dedctns & Adjst -1,690.34       -1,690.34  
          4008 · Medical Insurance 4,510.75       4,510.75  
          4009 · Training/Seminars 5.00       5.00  
          4071 · 401(k) Deductions 3,684.41       3,684.41  
          4072 · 401(k) Matching Contributi 1,212.26       1,212.26  
          4090 · Other - Other 400.00       400.00  
        Total 4090 · Other 37,253.78       37,253.78 5.5%
          5000 · Communications            
          5001 · Telephone            
            5011 · Internet 5,012.95       5,012.95  
            5012 · Local Service 7,671.92       7,671.92  
          Total 5001 · Telephone 12,684.87       12,684.87 1.9%
            5002 · Cellular Phones 13,810.02       13,810.02  
          5003 · Pagers 3,052.50       3,052.50  
          5004 · Answering Service 400.82       400.82  
          5000 · Communications - Other 604.04       604.04  
        Total 5000 · Communications 30,552.25       30,552.25 4.5%
          5500 · Office Expense            
          5501 · Office Supplies 1,635.12       1,635.12 0.2%
          5502 · Copier Expense 332.29       332.29 0.0%
          5503 · Postage & Delivery 1,439.76       1,439.76 0.2%
          5505 · Computers           0.0%
            5525 · Hardware & Software 77.53       77.53  
          Total 5505 · Computers 77.53   0.00   77.53 0.0%
            5507 · Dues & Memberships 1,060.00       1,060.00  
          5508 · Subscriptions 110.00       110.00  
          5509 · Parking 315.00       315.00  
          5510 · Finance Charges            
            5520 · Bank Charges 32.00       32.00  
            5530 · Merchant Discount Fee 1,311.00       1,311.00  
          Total 5510 · Finance Charges 1,343.00       1,343.00 0.2%
            5511 · Gifts 1,206.89       1,206.89  
          5515 · Business Promotion 1,799.21       1,799.21  
          5516 · Licenses & Fees 40.00       40.00  
          5521 · Insurance            
            5528 · Employment Practices 16,250.33       16,250.33  
          Total 5521 · Insurance 16,250.33       16,250.33 2.4%
            5580 · Reference & Resrch Matrls 995.00       995.00  
        Total 5500 · Office Expense 26,604.13       26,604.13 4.0%
        6000 · Outside Services            
          6002 · Attorney 275.86       275.86  
        Total 6000 · Outside Services 275.86       275.86 0.0%
          6500 · Automobile Expense            
          6502 · Gasoline 14.95       14.95  
        Total 6500 · Automobile Expense 14.95       14.95  
          7000 · Rent   11,879.18       11,879.18  
        7001 · Miller Marketing 45,000.00       45,000.00  
        8000 · Case Expense            
          8009 · Misc. 4,074.51       4,074.51  
        Total 8000 · Case Expense 4,074.51       4,074.51 0.6%
          9000 · Travel/Meals/Ent.            
          9001 · Meals & Ent. 110.55       110.55  
          9002 · Travel            
            9003 · Empl. Travel Reimb.            
              9004 · Attorney 30.94       30.94  
              9005 · Case Mgr. 103.14       103.14  
            Total 9003 · Empl. Travel Reimb. 134.08       134.08 0.0%
              9008 · Invstmnt Prprty            
              9009 · Rent 2,750.00       2,750.00  
              9010 · Utilities 10.92       10.92  
              9008 · Invstmnt Prprty - Other 255.00       255.00  
            Total 9008 · Invstmnt Prprty 3,015.92       3,015.92 0.4%
              9012 · Air Fare            
              9013 · Attorney 214.00       214.00  
              9016 · Other 778.00       778.00  
              9012 · Air Fare - Other 389.00       389.00  
            Total 9012 · Air Fare 1,381.00       1,381.00 0.2%
              9022 · Hotel            
              9023 · Attorney 448.03       448.03  
              9024 · Case Mgr. 383.14       383.14  
            Total 9022 · Hotel 831.17       831.17 0.1%
              9032 · Auto Rental            
              9034 · Case Mgr. 27.05       27.05  
            Total 9032 · Auto Rental 27.05       27.05 0.0%
              9002 · Travel - Other 28.29       28.29  
          Total 9002 · Travel 5,417.51       5,417.51 0.8%
          Total 9000 · Travel/Meals/Ent. 5,528.06       5,528.06 0.8%
        Total GENERAL & ADMINISTRATIVE 161,182.72       161,182.72 24.0%
        MARKETING EXPENSE            
        4005 · Marketing            
          4026 · Salaried Mkt Staff 8,125.00       8,125.00  
        Total 4005 · Marketing 8,125.00       8,125.00 1.2%
          450 · Advertising            
          4508 · Yellow Page Advertising 67,308.88       67,308.88 10.0%
          4525 · Other            
            4503 · Internet 65,724.20       65,724.20 9.8%
            4504 · Misc. 1,579.88       1,579.88 0.2%
            4505 · Atty Referral Fees 13,950.00       13,950.00 2.1%
            4506 · Jail Mail 3,750.00       3,750.00 0.6%
            4507 · Referral Services 4,974.50       4,974.50 0.7%
            4509 · License Defense Mktg 11.25       11.25 0.0%
          Total 4525 · Other 89,989.83       89,989.83 13.4%
          Total 450 · Advertising 157,298.71       157,298.71 23.4%
        Total MARKETING EXPENSE 165,423.71       165,423.71 24.6%
        SALES EXPENSE            
        4002 · Case Managers            
          4012 · Salaried Case Managers 83,978.46       83,978.46 12.5%
          4052 · Bonus 64,980.00       64,980.00 9.7%
          4061 · Auto Allowance-Reimb 8,694.27       8,694.27 1.3%
          4062 · Phone/Fax-Reimb 438.89       438.89 0.1%
          4063 · CM Prizes 200.00       200.00 0.0%
        Total 4002 · Case Managers 158,291.62       158,291.62 23.5%
          4003 · Case Analyst            
          4015 · Salaried Case Analyst 27,238.10       27,238.10  
          4044 · Bonus - Case Analyst 1,695.45       1,695.45  
          Total 4003 · Case Analyst 28,933.55       28,933.55 4.3%
        Total SALES EXPENSE 187,225.17       187,225.17 27.8%
      Total Expense     548,038.73       548,038.73 81.4%
  Net Ordinary Income     37,301.19   -16,974.24   20,326.95 3.0%
Net Income           37,301.19   -16,974.24   20,326.95 3.0%
 

 

  *** Individual Department "VARIANCE REPORT" Sample
2
  Jan   Jan   Jan   YTD   YTD   YTD  
01/04 MKT Variance Report Projection % Inc. Actual % Inc. Variance % Inc. Projection % Inc. Actual % Inc. Variance % Inc.
                       
Income 813,740.00 100.0% 669,519.17 100.0% -144,220.83 100.0% 813,740.00 100.0% 669,519.17 100.0% -144,220.83 82.3%
Expense                        
                       
4005 Marketing                        
4026 Salaried Marketing Staff 8,164.88 1.0% 8,125.00 1.2% -39.88 0.0% 8,164.88 1.0% 8,125.00 1.2% -39.88 0.2%
4027 IC Admin 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0%
4028 Bonus 1,500.00 0.2% 0.00 0.0% -1,500.00 1.0% 1,500.00 0.2% 0.00 0.0% -1,500.00 -0.2%
4030 Phone/Fax reimb 100.00 0.0% 0.00 0.0% -100.00 0.1% 100.00 0.0% 0.00 0.0% -100.00 -0.0%
4034 Prizes/Awards 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0%
Total 4005 Marketing Payroll 9,764.88 1.2% 8,125.00 1.2% -1,539.88 1.1% 9,764.88 1.2% 8,125.00 0.6% -1,639.88 -0.6%
                       
450 Adv & Mktg                        
Yellow Pages 99,100.70 12.2% 67,492.63 10.1% -31,608.07 21.9% 99,100.70 12.2% 67,492.63 10.1% -31,608.07 -2.1%
Other 57,165.00 7.0% 90,768.83 13.6% 33,603.83 -23.3% 57,165.00 7.0% 90,768.83 13.6% 33,603.83 6.5%
450 Total Adv & Mktg 156,265.70 19.2% 158,261.46 23.6% 1,995.76 -1.4% 156,265.70 19.2% 158,261.46 23.6% 1,995.76 4.4%
 

 

  *** Organizational Budget / Variance Report Sample
4
Jan   Jan   Jan   YTD   YTD   YTD  
Projection % Inc. Actual % Inc. Variance % Inc. Projection % Inc. Actual % Inc. Variance % Inc.
# Calls 409   469   60   6480   5585   -895  
$ per call 850.00   680.99   -169.01   575.66   694.46   118.80  
Income - N CA 347,650.00   319,384.31   -28,265.69   3,730,282.89   3,878,562.13   148,279.24  
# Calls 157   164   7   2423   2423   0  
$ per call 770.00   389.18   -380.82   528.20   764.30   236.10  
Income - S CA 120,890.00   63,825.52   -57,064.48   1,279,840.24   1,851,910.23   572,069.99  
# Calls 157   170   13   1769   1973   204  
$ per call 575.00   502.06   -72.94   454.30   492.77   38.48  
Income - MI 90,275.00   85,350.20   -4,924.80   803,650.00   972,243.75   168,593.75  
# Calls 94   131   37   1722   1713   -9  
$ per call 300.00   170.99   -129.01   345.76   337.81   -7.95  
Income - IL 28,200.00   22,399.69   -5,800.31   595,400.00   578,670.72   -16,729.28  
# Calls 63   78   15   879   1324   445  
$ per call 300.00   266.87   -33.13   386.48   293.85   -92.63  
Income - OH 18,900.00   20,815.86   1,915.86   339,715.50   389,061.48   49,345.98  
# Calls 120   192   72   1374   1698   324  
$ per call 225.00   142.33   -82.67   244.12   205.72   -38.41  
Income - PA 27,000.00   27,327.00   327.00   335,425.00   349,307.00   13,882.00  
# Calls 62   91                  
$ per call 300   423.23                  
Income - DC/MD/VA 18,600.00   38513.93                  
# Calls 76   64   -12   1374   1570   196  
$ per call 300.00   300.00   0.00   244.12   217.31   -26.81  
Income - OR/WA 22,800.00   19,200.00   -3,600.00   335,425.00   341,180.00   5,755.00  
# Calls 507   493   -14   4412   7050   2638  
$ per call 275.00   423.23   148.23   288.80   296.29   7.49  
Income - OT 139,425.00   208,652.39   69,227.39   1,274,190.00   2,088,846.04   814,656.04  
                       
Total # Calls 1645   1852   207   19059   21766   2707  
$ per call 494.67   361.51   -133.16   455.26   464.42   9.16  
Total Income 813,740.00 100.0% 669,519.17 100.0% -144,220.83 100.0% 8,676,878.63 100.0% 10,108,601.35 100.0% 1,431,722.72 116.3%
    805,468.90                  
Expense                        
Attorneys 215,641.10 26.5% 84,179.25 12.6% -131,461.85 -13.9% 2,331,473.52 26.9% 2,709,516.22 26.8% 378,042.70 -0.1%
Case Managers 138,335.80 17.0% 158,291.62 23.6% 19,955.82 6.6% 1,513,155.78 17.4% 1,727,430.52 17.1% 214,274.74 -0.4%
Case Analysts 33,363.34 4.1% 28,933.55 4.3% -4,429.79 0.2% 362,405.15 4.2% 328,945.88 3.3% -33,459.27 -0.9%
Marketing 9,764.88 1.2% 8,125.00 1.2% -1,639.88 0.0% 106,818.20 1.2% 106,987.65 1.1% 169.45 -0.2%
Admin 25,225.94 3.1% 19,506.47 2.9% -5,719.47 -0.2% 228,672.59 2.6% 255,960.29 2.5% 27,287.70 -0.1%
Other 22,784.72 2.8% 30,204.65 4.5% 7,419.93 1.7% 248,762.46 2.9% 465,575.74 4.6% 216,813.28 1.7%
400 Total People 445,115.78 54.7% 329,240.54 49.2% -115,875.24 -5.5% 4,791,287.70 55.2% 5,594,416.30 55.3% 803,128.60 0.1%
                       
Jan   Jan   Jan   YTD   YTD   YTD  
Projection % Inc. Actual % Inc. Variance % Inc. Projection % Inc. Actual % Inc. Variance % Inc.
450 Adv & Mktg                        
Yellow Pages 99,100.70 12.2% 67,492.63 10.1% -31,608.07 -2.1% 1,445,533.78 16.7% 1,424,241.20 14.1% -21,292.58 -2.6%
Other 57,165.00 7.0% 90,768.83 13.6% 33,603.83 6.5% 587,916.34 6.8% 590,173.20 5.8% 2,256.86 -0.9%
450 Total Adv & Mktg 156,265.70 19.2% 158,261.46 23.6% 1,995.76 4.4% 2,033,450.12 23.4% 2,014,414.40 19.9% -19,035.72 -3.5%
                       
500 Communications 14,647.32 1.8% 13,204.87 2.0% -1,442.45 0.2% 185,835.04 2.1% 166,616.32 1.6% -19,218.72 -0.5%
550 Office Expenses 40,687.00 5.0% 31,587.41 4.7% -9,099.59 -0.3% 464,487.55 5.4% 502,858.47 5.0% 38,370.92 -0.4%
600 Outside Services 14,647.32 1.8% 5,166.73 0.8% -9,480.59 -1.0% 87,283.25 1.0% 250,132.95 2.5% 162,849.70 1.5%
650 Automobile 650.00 0.1% 650.00 0.1% 0.00 0.0% 24,044.39 0.3% 36,277.60 0.4% 12,233.21 0.1%
700 Rent 13,019.84 1.6% 11,879.18 1.8% -1,140.66 0.2% 130,068.65 1.5% 153,452.79 1.5% 23,384.14 0.0%
800 Case Expense 813.74 0.1% 574.51 0.1% -239.23 0.0% 5,667.66 0.1% 13,680.00 0.1% 8,012.34 0.1%
900 Travel/Meals/Ent. 8,137.40 1.0% 7,454.68 1.1% -682.72 0.1% 103,463.36 1.2% 95,985.59 0.9% -7,477.77 -0.2%
Total Expenses 693,984.10 85.3% 558,019.38 83.3% -135,964.72 -1.9% 7,825,587.72 90.2% 8,827,834.42 87.3% 1,002,246.70 -2.9%
                       
Other Income 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0%
Other Expense 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0%
Net Other Income 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0% 0.00 0.0%
                       
                       
Net Income 119,755.90 14.7% 111,499.79 16.7% -8,256.11 1.9% 851,290.91 9.8% 1,280,766.93 12.7% 429,476.02 2.9%
 

 

  *** Organizational Budget / Variance with indicator Report Sample
4
COMPANY A       <-- Click to Return to Main  
2004 - Projected Cash Budget            
               
  Jan - 04 Projected % of Jan - 04 Actual % Inc/Dec Jan - 04 Variance % Inc/Dec Indicator
# Calls 409 # 469   60 114.7%  
$ Per Call 850.00 # 558.56    $          (291.44) 65.7%  
Income - N CA 347,650.00 # 261,966.67    $    (85,683.33) 75.4%
# Calls 157 # 164   7 104.5%  
$ Per Call 770 # 439.78    $          (330.22) 57.1%  
Income - S CA 120,890.00 # 72,124.00    $    (48,766.00) 59.7%
# Calls 157 # 170   13 108.3%  
$ Per Call 575.00 # 490.11    $            (84.89) 85.2%  
Income - MI 90,275.00 # 83,318.50    $       (6,956.50) 92.3%
# Calls 94 # 131   37 139.4%  
$ Per Call 300.00 # 145.23    $          (154.77) 48.4%  
Income - IL 28,200.00 # 19,025.00    $       (9,175.00) 67.5%
# Calls 63 # 78   15 123.8%  
$ Per Call 300.00 # 275.64    $            (24.36) 91.9%  
Income - OH 18,900.00 # 21,500.00    $        2,600.00 113.8%
# Calls 120 # 192   72 160.0%  
$ Per Call 225.00 # 89.84    $          (135.16) 39.9%  
Income - PA 27,000.00 # 17,250.00    $       (9,750.00) 63.9%
# Calls 62 # 91   29 146.8%  
$ Per Call 300.00 # 118.13    $          (181.87) 39.4%  
Income - DC/MD/VA 18,600.00 # 10,750.00    $       (7,850.00) 57.8%
# Calls 76 # 64   -12 84.2%  
$ Per Call 300.00 # 820.31    $           520.31 273.4%  
Income - OR/WA 22,800.00 # 52,500.00    $      29,700.00 230.3%
# Calls 507 # 493   -14 97.2%  
$ Per Call 275.00 # 297.84    $              22.84 108.3%  
Income - OT 139,425.00 # 146,835.00    $        7,410.00 105.3%
               
Total Calls 1645 # 1852   207 112.6%  
$ Per Call 494.67 # 370.02    $          (124.66) 74.8%  
Total Income 813,740.00 # 685,269.17    $  (128,470.83) 84.2%
               
Expense              
Attorneys 215,641.10 # 84,179.25   ($131,461.85) -61.0%
Case Managers 138,335.80 # 158,291.62   $19,955.82 14.4%
Case Analysts 33,363.34 # 28,933.55   ($4,429.79) -13.3%
Marketing 9,764.88 # 8,125.00   ($1,639.88) -16.8%
Admin 25,225.94 # 34,207.13   $8,981.19 35.6%
Other 22,784.72 # 37,253.78   $14,469.06 63.5%
400 Total People 445,115.78 # 350,990.33   (94,125.45) -21.1%
450 Adv & Mktg              
4508 -Yellow Pages 99,100.70 # 82,718.48   ($16,382.22) -16.5%
Other 57,165.00 # 70,827.70   $13,662.70 23.9%
 
450 Total Adv & Mktg 156,265.70 # 153,546.18   (2,719.52) -1.7%  
               
500 Communications 14,647.32 # 10,363.71   ($4,283.61) -29.2%
550 Office Expenses 40,687.00 # 22,946.93   ($17,740.07) -43.6%
600 Outside Services 14,647.32 # 275.86   ($14,371.46) -98.1%
650 Automobile 650.00 # 0.00   ($650.00) -100.0%
700 Rent 13,019.84 # 11,456.45   ($1,563.39) -12.0%
800 Case Expense 813.74 # 4,074.51   $3,260.77 400.7%
900 Travel/Meals. Ent. 8,137.40 # 5,110.77   ($3,026.63) -37.2%
General & Administrative 92,602.62 # 54,228.23   (38,374.39) -41.4%
               
Total Expenses 693,984.10 # 558,764.74   (135,219.36) -19.5%
Net Income 119,755.90 # 126,504.43   6,748.53 5.6%
             
             
Surpassed Goal          
             
Under Target            
             
  Requires Attention          
 

 

  ***  KEY STRATEGIC INDICATORS Report Sample
4

MONTHLY KEY STRATEGIC INDICATORS WORKSHEET

Measurable Tangible Indicators

Indicator

 

Target Result

 

Year to Date

2003

 

Past 3 Month Average

 

Current Month

Dec 2003

 

 

 

 

 

 

 

 

 

 

 

 

Sales

 

 

 

YTD – 8,676,878.63

3 Mo Avg –

Current  – 606220.00

 

 

 

8,676,878.63

 

 

 

879,428.54

 

 

 

1,007,286.43

 

Number of Calls

 

 

YTD – 19,059

3 Mo Avg –

Current  – 1,268

 

 

 

21,479

 

 

1484

 

 

 

 

1,268

 

Percentage of Calls Retained

 

 

YTD – 7.0

3 Mo Avg – 7.0

Current  – 7.0

 

 

8.74

 

 

 

 

 

8.99

 

 

 

 

10.9

 

Cost Per Call

 

 

YTD – 101.58

3 Mo Avg – 107.53

Current  – 109.97

 

 

90.65

 

 

 

98.49

 

 

 

82.70

 

$$$ Per Call

Overall

 

 

YTD – 300.00

3 Mo Avg – 300.00

Current  – 300.00

 

 

 

455.26

 

 

600.42

 

 

 

 

714.39

 

$$$ Per Call

Phone

 

 

YTD – 350.00

3 Mo Avg – 350.00

Current  – 350.00

 

 

 

307.41

 

 

474.89

 

 

 

 

557.41

 

Case Analysts – Total $ in Per Hours Worked

 

YTD – 500.00

3 Mo Avg – 500.00

Current  – 500.00

 

 

651.31

 

 

 

614.23

 

 

 

 

579.39

 

Write Offs - Total $ as Uncollected

 

 

0

 

 

183,293.93

 

 

9621.23

 

 

40.00

 

 

# of Client Issues

 

 

0

 

 

589

 

 

68

 

 

81

 

$ Amount of

“At-Fault” Refunds

“Non-Fault” Refunds

 

 

0

0

 

 

116,6421

398,925.33

 

 

2,500

44,152.44

 

 

2,500

63,744.83

 
 

 

  ***  Report Sample
4  

 

  ***  Report Sample
4  

 

  *** Managed Buy-Out (MBO) Transfer Tracking Sample
3
Partner Money Recap                              
First Quarter - 2004                              
                             
                             
  Balance Forward DUE JAN   Paid 1/2004   DUE FEB   Paid 2/2004   DUE MAR   Paid 3/2004     Balance
                             
Lease Payment   $45,000.00   ($45,000.00)   $45,000.00   ($45,000.00)   $45,000.00         $45,000.00
Investment Property   $2,750.00   ($2,750.00)   $2,750.00   ($2,750.00)   $2,750.00         $2,750.00
                            $0.00
Royalities   $145,613.00           ($145,613.00)             $0.00
Wrkng Capital Loan 156,902.00             ($156,902.00)             $0.00
Marketing Expns Reserve ($209,075.00)             $147,452.96             ($61,622.04)
                              $0.00
TOTAL -52,173.00 $148,363.00   ($2,750.00)   $2,750.00   ($157,812.04)   $2,750.00   $0.00     -$13,872.04
 

 

  *** Monthly NSF Reporting Sample
4
              Jan 04 Client NSF                    
Type   Date   Num   Name   Memo   Class   Split   Original Amount   Paid Amount   Balance
Client NSF                                      
Credit Memo   01/06/2004   1145   S., Henry - 89496   Client bounced check   EC:MI   Accounts Receivable -4,500.00   -4,500.00   -4,500.00
Credit Memo   01/21/2004   1056   L., Jerry - 83235   Client bounced check   EC:MI   Accounts Receivable -500.00   -500.00   -5,000.00
Credit Memo   01/21/2004   1058   T., Jack - 88546   Client bounced check   CA:N CA   Accounts Receivable -7,500.00   -7,500.00   -12,500.00
Total Client NSF                               -12,500.00   -12,500.00
                                  -12,500.00   -12,500.00
 

 

  *** Monthly Refund Report Sample
4
                Jan 04 Refunds                    
  Type   Date   Num   Name   Memo   Class   Split   Original Amount   Paid Amount   Balance
Client Refunds                                      
  Credit Memo   01/02/2004   943   R., Robert - 66065       EC:IL   Accounts Receivable   -7,500.00   -7,500.00   -7,500.00
  Credit Memo   01/02/2004   944   T., George - 86297       EC:MI   Accounts Receivable   -1,600.00   -1,600.00   -9,100.00
  Credit Memo   01/02/2004   945   W., Timothy - 86558       WA   Accounts Receivable   -1,000.00   -1,000.00   -10,100.00
  Credit Memo   01/02/2004   946   R., David - 86222       CA:N CA   Accounts Receivable   -1,000.00   -1,000.00   -11,100.00
  Credit Memo   01/02/2004   947   F., Lester - 86393       CA:N CA   Accounts Receivable   -5,000.00   -5,000.00   -16,100.00
  Credit Memo   01/02/2004   948   C., Ryan - 84730       FL   Accounts Receivable   -5,000.00   -5,000.00   -21,100.00
  Credit Memo   01/02/2004   949   D., Antonio - 85817       CA:N CA   Accounts Receivable   -2,600.00   -2,600.00   -23,700.00
  Credit Memo   01/02/2004   950   B., Willie - 79492       CA:S CA   Accounts Receivable   -750.00   -750.00   -24,450.00
  Credit Memo   01/02/2004   951   R., Debra - 78582       EC:MI   Accounts Receivable   -13,331.50   -13,331.50   -37,781.50
  Credit Memo   01/02/2004   952   G., Terri - 85595       PA   Accounts Receivable   -1,250.00   -1,250.00   -39,031.50
  Credit Memo   01/02/2004   953   R., Kenneth - 86620       MD   Accounts Receivable   -20,000.00   -20,000.00   -59,031.50
  Credit Memo   01/02/2004   954   M., Kevin - 82538       CA:N CA   Accounts Receivable   -2,500.00   -2,500.00   -61,531.50
  Credit Memo   01/02/2004   955   M., Kenny - 84088       CA:N CA   Accounts Receivable   -1,333.33   -1,333.33   -62,864.83
  Credit Memo   01/02/2004   1025   M., Ruben       TX   Accounts Receivable   -12,000.00   -4,465.00   -67,329.83
  Deposit   01/06/2004   6205972   R., David - 86222   Trans 1/2/04       City National Retainers Account -1,000.00   -1,000.00   -68,329.83
  Deposit   01/20/2004   6205975   W., Allen - 88701   Trans 1/15/04     City National Retainers Account -2,250.00   -2,250.00   -70,579.83
Total Client Refunds                               -70,579.83   -70,579.83
TOTAL                                 -70,579.83   -70,579.83
 

 

  *** CASH FLOW Budget Report Sample (Covering MBO)
4
Company A     <-- Click to Return to Main                  
2004 - Pro Forma P&L (Totals)                          
                         
  Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
                           
Beginning Balance $464,532.90 $584,288.80 $573,579.32 ($19,889.71) $89,728.19 $234,328.70 $393,065.60 $552,022.26 $514,590.54 $632,092.59 $771,537.42 $841,557.65 5,631,434.26
                           
Gross Revenue 813,740.00 800,135.00 840,825.00 764,070.00 831,940.00 872,775.00 894,655.00 898,095.00 826,970.00 825,280.00 777,690.00 767,565.00 9,913,740.00
                           
Payroll Expenses 445,115.78 449,675.87 453,204.68 414,125.94 450,911.48 473,044.05 484,903.01 486,767.49 448,217.74 447,301.76 423,063.36 417,555.36 5,393,886.52
                           
Marketing Expenses 156,265.70 270,103.36 160,132.82 153,336.25 141,768.80 141,720.47 149,049.32 178,256.49 167,152.60 144,626.77 196,077.44 162,758.00 2,021,248.02
                           
G & A Expenses 92,602.62 91,065.26 95,663.23 86,989.91 94,659.22 99,273.58 101,746.02 102,134.74 94,097.61 93,906.64 88,528.97 87,384.85 1,128,052.62
                           
Cmpny B Accrual (Old YlwPg Ads)     82,179.26                   82,179.26
                           
Due To/From Cmpny B Cash GL     377,501.04                   377,501.04
                           
Lease Pymnt - To Cmpny B     145,613.00                   145,613.00
                           
Discretionary Bonus     120,000.00         168,368.00         288,368.00
                           
Total Expenses 693,984.10 810,844.49 1,434,294.02 654,452.10 687,339.50 714,038.10 735,698.35 935,526.72 709,467.95 685,835.17 707,669.77 667,698.21 9,436,848.46
                           
Net Income 119,755.90 (10,709.49) (593,469.02) 109,617.90 144,600.50 158,736.91 158,956.66 (37,431.72) 117,502.05 139,444.83 70,020.23 99,866.80 476,891.55
                         
Ending Balance 584,288.80 573,579.32 (19,889.71) 89,728.19 234,328.70 393,065.60 552,022.26 514,590.54 632,092.59 771,537.42 841,557.65 941,424.45 6,108,325.80