SUA Spreadsheet

Document Sample
SUA Spreadsheet Powered By Docstoc
					D:\Docstoc\Working\pdf\847f970f-f5f2-4b01-94d6-d5c57f391398.xls



 This Excel file has eleven separate spreadsheets (after this page) for the Systems Understanding Aid assignments.
 At the bottom of this window, you should be able to see a tab for each of the pages:

         Trial Balance
         GL Assets
         GL Liabilities & OE
         GL Income
         GL Expenses
         General Journal
         Other Journals (sales & cash receipts, purchases & disbursements, payroll)
         AR Ledger
         AP Ledger
         Payroll
         Fixed Assets
         Bank Reconciliation (Rec)

 You are to use these spreadsheets to complete the various stages of the SUA exercise. These pages replicate the
 paper versions of the documents contained in the SUA documentation.

 Remember: Save your work frequently. Submit this entire file as an attachment to email when you are finished with
 each stage of the assignment:
     Email address: ACCT@rrtidd.com
     Subject line: 455 SUA 01
847f970f-f5f2-4b01-94d6-d5c57f391398.xls   Trial Balance                        7/16/2011




                                                                 11/30
 ACCT                       ACCOUNT                          UNADJUSTED
  NO.                         TITLE                         TRIAL BALANCE
                                                           DEBIT       CREDIT

                             ASSETS
 10100    Cash
 10200    Accounts receivable
 10300      Allowance for doubtful accounts
 10400    Inventory
 10500    Prepaid Expenses
 10600    Marketable securities
 10700    Interest Receivable
 10800    Fixed assets
 10900      Accumulated depreciation
 11000    Notes Receivable
                          LIABILITIES
 20100    Accounts payable
 20200    Wages & Salaries Payable
 20300    Federal income taxes withheld
 20400    State unemployment taxes payable
 20500    Federal unemployment taxes payable
 20600    F.I.C.A. taxes payable
 20700    Federal incomes taxes payable
 20800    Dividends Payable
 20900    Interest payable
 21000    Notes payable

              STOCKHOLDERS' EQUITY
 26000 Common stock
 27000 Paid-in Capital in Excess of Par
 29000 Retained earnings

              REVENUE AND GROSS PROFIT
 30100    Sales
 30200    Sales returns and allowances
 30300    Sales discounts taken
 30400    Cost of goods sold
 30500    Purchases
 30600    Purchases returns and allowances
 30700    Purchases discounts taken
847f970f-f5f2-4b01-94d6-d5c57f391398.xls     Trial Balance                        7/16/2011


 30800    Freight-in
 30900    Gain/Loss- Sale of Fixed Assets
 31000    Gain/Loss- Sale of Marketable Sec.
 31100    Interest/Dividend Income
 31200    Miscellaneous revenue

                            EXPENSES
 40100    Rent expense
 40200    Advertising expense
 40300    Office supplies expense
 40400    Depreciation expense
 40500    Wages and salaries expense
 40600    Payroll tax expense
 40700    Federal income tax expense
 40800    Interest expense
 40900    Bad debt expense
 41000    Other operating expense



                TOTALS                                       $      -     $   -
                                                                          $   -
                                           Check Figures $ 1,959,049.68
847f970f-f5f2-4b01-94d6-d5c57f391398.xls   Trial Balance                      7/16/2011




     Revenue Cycle               Expenditure Cycle           Payroll Cycle

    TRIAL BALANCE                TRIAL BALANCE              TRIAL BALANCE
   DEBIT     CREDIT             DEBIT     CREDIT           DEBIT     CREDIT
847f970f-f5f2-4b01-94d6-d5c57f391398.xls       Trial Balance                   7/16/2011




                              $        -   $           -       $   -   $   -
     10100   Cash
   Date                        Entry        Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1       Balance Forward                                                   44,407.53
Oct. 31                                     CR        110,395.64
     X                                      CD                     98,304.36
     X       Net Wages and Salary           PR                     10,498.83
     X       Bank Service Charge            G                          25.00    45,974.98
Nov. 30                                     CR         82,113.56
     X                                      CD                     44,113.33
     X       Net Wages and Salary           PR                     10,599.08
     X       Bank Service Charge            G                          21.00    73,355.13




     10200 Accounts Receivable
   Date                    Entry            Journal    Debit       Credit      Balance    Ctrl Init
Oct. 1     Balance Forward                                                     49,451.00 NF
Oct. 31                                     S          86,714.00
     X                                      CR                     74,369.00    61,796.00 NF
Nov. 30                                     S          37,263.00
     X                                      CR                     75,054.00    24,005.00 NF




    10300 Allowance for Doubtful Accounts
                                                                                            Ctrl Init
Oct. 1       Balance Forward                                                     1,750.81




     10400 Inventory
   Date                    Entry            Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1     Balance Forward                                                     101,681.00




     10500 Prepaid Expenses
   Date                    Entry            Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1     Balance Forward                                                          0.00




     10600 Marketable Securities
   Date                    Entry            Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1     Balance Forward                                                     24,000.00




     10700 Interest Receivable
   Date                    Entry            Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1     Balance Forward                                                          0.00




     10800 Fixed Assets
   Date                    Entry            Journal    Debit       Credit      Balance     Ctrl Init
Oct. 1     Balance Forward                                                     320,665.00 NF




     10900 Accumulated Depreciation
   Date                    Entry            Journal    Debit       Credit      Balance    Ctrl Init
Oct. 1     Balance Forward                                                     81,559.50 NF




     11000 Notes Receivable
   Date                    Entry            Journal    Debit       Credit      Balance      Ctrl Init
Oct. 1     Balance Forward                                                          0.00
     20100 Accounts Payable
  Date                    Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               P                     85,920.80
X                                     CD        82,372.83
Nov. 30                               P                     27,938.09
X                                     CD        28,923.89




     20200 Wages & Salaries Payable
  Date                    Entry       Journal   Debit       Credit
Oct. 1     Balance Forward




     20300 FIT Withheld
  Date                    Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               CD         1,515.80
X                                     PR                     1,517.33
Nov. 20                               CD         1,517.33
X                                     PR                     1,516.07




     20400 SUT Payable
  Date                    Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               G                        44.98
Nov. 30                               CD           44.98
X                                     G                        50.03
     20500 FUT Payable
  Date                    Entry     Journal   Debit      Credit
Oct. 1     Balance Forward
Oct. 31                             G                       13.33
Nov. 30                             CD           13.33
X                                   G                       14.82




     20600   FICA Taxes Payable
  Date                      Entry   Journal   Debit      Credit
Oct. 1       Balance Forward
Oct. 31                             CD        1,745.62
X            F.I.C.A. Withheld      PR                     995.38
X            Employer's Tax         G                      995.38
Nov. 30                             CD        1,990.76
X            F.I.C.A. Withheld      PR                    1,003.58
X            Employer's Tax         G                     1,003.58




     20700 FIT Payable
  Date                    Entry     Journal   Debit      Credit
Oct. 1     Balance Forward




     20800 Dividends Payable
  Date                    Entry     Journal   Debit      Credit
Oct. 1     Balance Forward
     20900 Interest Payable
  Date                    Entry               Journal   Debit   Credit
Oct. 1     Balance Forward




     21000 Notes Payable
  Date                    Entry               Journal   Debit   Credit
Oct. 1     Balance Forward




     26000 Common Stock
  Date                    Entry               Journal   Debit   Credit
Oct. 1     Balance Forward




     27000 Paid-in Capital in Excess of Par
  Date                     Entry              Journal   Debit   Credit
Oct. 1     Balance Forward
     28000 Income Summary
  Date                    Entry   Journal   Debit   Credit
Oct. 1     Balance Forward




     29000 Retained Earnings
  Date                    Entry   Journal   Debit   Credit
Oct. 1     Balance Forward
Balance    Ctrl Init
 1,087.83 NF

  4,635.80 NF

  3,650.00 NF




Balance      Ctrl Init
     0.00




Balance      Ctrl Init
 1,515.80

  1,517.33

  1,516.07




Balance      Ctrl Init
     0.00
    44.98

    50.03
Balance     Ctrl Init
     0.00
    13.33

    14.82




Balance     Ctrl Init
 1,745.62


 1,990.76


 2,007.16




Balance     Ctrl Init
     0.00




Balance     Ctrl Init
     0.00
Balance      Ctrl Init
     0.00




Balance      Ctrl Init
     0.00




Balance      Ctrl Init
225,000.00




Balance      Ctrl Init
     0.00
Balance      Ctrl Init
     0.00




Balance      Ctrl Init
 90,264.99
     30100   Sales
   Date                     Entry       Journal   Debit       Credit
Oct. 1       Balance Forward
Oct. 31      Credit Sales               S                     86,714.00
X            Cash Sales                 CR                    36,607.00
Nov. 30      Credit Sales               S                     60,277.00
X            Cash Sales                 CR                     7,767.00




     30200 Sales Returns & Allowances
   Date                   Entry         Journal   Debit       Credit
Oct. 1     Balance Forward
Nov. 30                                 S         23,014.00




     30300 Sales Discounts Taken
   Date                   Entry         Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                                 CR          580.36
Nov. 30                                 CR          707.44




     30400 Cost of Goods Sold
   Date                   Entry         Journal   Debit       Credit
Oct. 1     Balance Forward
     30500 Purchases
   Date                   Entry                Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                                        P         81,285.00
Nov. 30                                        P         27,380.00




     30600 Purchase Returns and Allowances
   Date                   Entry                Journal   Debit       Credit
Oct. 1     Balance Forward




     30700 Purchase Discounts Taken
   Date                   Entry                Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                                        CD                     1,625.70
Nov. 30                                        CD                       547.60




     30800 Freight-In
   Date                   Entry                Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                                        CD         2,985.60
Nov. 30                                        CD         2,356.99




     30900 Gain/Loss on Sale of Fixed Assets
   Date                   Entry                Journal   Debit       Credit
Oct. 1     Balance Forward
     31000 Gain/Loss on Sale of Marketable Securities
   Date                   Entry                Journal   Debit   Credit
Oct. 1     Balance Forward




   311100 Interest/Dividend Income
   Date                   Entry               Journal    Debit   Credit
Oct. 1    Balance Forward




     31200 Miscellaneous Revenue
   Date                   Entry               Journal    Debit   Credit
Oct. 1     Balance Forward
  Balance      Ctrl Init
1,326,865.00

1,450,186.00

1,518,230.00




 Balance       Ctrl Init
  34,617.00
  57,631.00




 Balance       Ctrl Init
  13,856.38
  14,436.74
  15,144.18




 Balance       Ctrl Init
      0.00
  Balance      Ctrl Init
  969,835.00
1,051,120.00
1,078,500.00




 Balance       Ctrl Init
  19,445.00




 Balance       Ctrl Init
  13,388.00
  15,013.70
  15,561.30




 Balance       Ctrl Init
  18,038.35
  21,023.95
  23,380.94




 Balance
      0.00
Balance
     0.00




Balance     Ctrl Init
     0.00




Balance     Ctrl Init
     0.00
     40100 Rent Expense
   Date                   Entry      Journal   Debit      Credit
Oct. 1     Balance Forward
Oct. 31                              CD        4,800.00
Nov. 30                              CD        4,800.00




     40200 Advertising Expense
   Date                   Entry      Journal   Debit      Credit
Oct. 1     Balance Forward
Oct. 31                              CD        4,525.00
Nov. 30                              CD        3,250.00




     40300 Office Supplies Expense
   Date                   Entry      Journal   Debit      Credit
Oct. 1     Balance Forward
Oct. 31                              P           985.80
Nov. 30                              P           558.09




     40400 Depreciation Expense
   Date                   Entry      Journal   Debit      Credit
Oct. 1     Balance Forward
     40500 Wages & Salaries Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               PR        13,011.54
Nov. 30                               PR        13,118.73



     40600 Payroll Tax Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               G          1,053.69
Nov. 30                               G          1,068.43




     40700 FIT Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward




     40800 Interest Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward




     40900 Bad Debt Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward




     41000 Other Operating Expense
   Date                   Entry       Journal   Debit       Credit
Oct. 1     Balance Forward
Oct. 31                               G             25.00
X                                     P          3,650.00
X                                     CD         1,985.21
Nov. 30                               G             21.00
X                                     CD         1,763.65
Balance      Ctrl Init
 43,200.00
 48,000.00
 52,800.00




Balance      Ctrl Init
 13,030.00
 17,555.00
 20,805.00




Balance      Ctrl Init
 3,518.41
 4,504.21
 5,062.30




Balance      Ctrl Init
     0.00
Balance     Ctrl Init
100,281.22 NF
113,292.76 NF
126,411.49 NF




Balance      Ctrl Init
  8,161.52
  9,215.21
 10,283.64




Balance      Ctrl Init
     0.00




Balance      Ctrl Init
     0.00




Balance      Ctrl Init
     0.00




Balance      Ctrl Init
 17,880.14


 23,540.35

 25,325.00
General Journal

           Date    Acct. No.            Acct. & Explain         Post x   Debit

         Nov. 30        40600 Payroll Tax Expense                 X       1,068.43
                        20600    F.I.C.A. Payable                 X
                        20400    SUTA Payable                     X
                        20500    FUTA Payable                     X

                               To record November payroll

         Nov. 30        41000 Other Operating Expense             X          21.00
                        10100    Cash                             X

                               To record November bank service charge
TOTALS   1,089.43
Credit


 1,003.58
    50.03
    14.82




    21.00
1,089.43
Sales Journal

                                                                                                                                  Debit                      Credit
                                                                 Invoice or      Subsidiary                                                 Sales
                Date                Customer                     Cr. Memo         Acct. No.            Post x              A/R             Returns           Sales

          Nov. 7        Stevenson College                       CM41                   411.00            X               (23,014.00)        23,014.00
          Nov. 7        Rosemont University                                724         406.00            X                 2,460.00                           2,460.00
          Nov. 10       Branch College                                     725         408.00            X                32,912.00                          32,912.00
          Nov. 14       Eastern Wisconsin Univ.                            726         410.00            X                24,905.00                          24,905.00


                              Monthly Totals                                                                             37,263.00          23,014.00        60,277.00
                                                                                                                     X                 X                 X

          Dec. 2        Rosemont University                                727         406.00            X                4,174.00                            4,174.00
          Dec. 7        Clayborn University                                728         407.00            X                7,252.00                            7,252.00
          Dec. 9        Eastern Wisconsin Univ.                            729         410.00            X               21,872.00                           21,872.00
          Dec. 13       Branch College                                     730         408.00            X                1,656.00                            1,656.00




Cash Receipts Journal

                                                                                      Debit                                                                                   Credit
                                                                                                                            Accounts Receivable                               Sales                          Other G/L
               Date                 Description                  Dep. Ctrl.           Cash           Sales Disc. Sub. Acct. No.  Amount      Subs Post x                                    Acct. No.         Amount         Post Ref.
          Nov. 7        Stevenson College                       NF                   34,682.00                             411    34,682.00 X
          Nov. 13       McClain College                         NF                    7,767.00                                                                                 7,767.00
          Nov. 17       Rosemont University                     NF                    2,410.80             49.20                 406          2,460.00 X
          Nov. 18       Branch College                          NF                   32,253.76            658.24                 408         32,912.00 X
          Nov. 21       Eastern Wisconson Univ.                 NF                    5,000.00                                   410          5,000.00 X

                              Monthly Totals                    RK                   82,113.56            707.44                             75,054.00                         7,767.00
                                                                                 X               X                                     X                                  X


          Dec. 6        Gates University                        NF                    5,891.00                                                                                 5,891.00
          Dec. 9        Rosemont University                     NF                    4,090.52               83.48               406          4,174.00 X
          Dec. 14       Hancock College                         NF                    5,306.00                                                                                 5,306.00
          Dec. 15       Clayborn University                                           7,106.96            145.04                 407          7,252.00 X
          Dec. 15       Atwood Brothers                                                 825.00                                                                                                   31200           825.00




                              Monthly Totals




Purchases Journal
                                                                                                                 Debit                                                            Credit
                                                                                                                      Other GL                                        Accounts Payable
                                                                     Vendor      Purchases                                                                                                               Purchases
                Date                     Vendor                      Invoice        GL               Acct. No.           Amount            Post. Ref.    Sub. Acct. No.       Amount      Subs Post x     Returns

          Nov. 3        Velocity Sporting Goods                         33371        27,380.00                                                                    252         27,380.00 X
          Nov. 21       Chicago Office Supply                            2275                                40300          558.09 X                           253.00            558.09 X


                        Monthly Totals                                               27,380.00                              558.09                                            27,938.09                                  0
                                                                                 X                                   X                                                    X                              X

          Dec. 5        Velocity Sporting Goods                         33965        36,115.00                                                                    252         36,115.00 X
          Dec. 12       Chicago Office Supply                            2344                                10800        7,367.00                             253.00          7,367.00 X



                                               Monthly Totals




Cash Disbursements Journal
                                                                                          Credit                                                                Debit
                                                                                              Purchases                 Accounts Payable                      Freight-in                     Other G/L
               Date                  Description               Check No.           Cash          Disc.      Sub. Acct. No.  Amount      Subs Post x                         Acct. No.         Amount          Post Ref.
          Nov. 8         Chicago Office Supply                       1124            985.80                           253      985.80 X
          Nov. 13        Velocity Sporting Goods                     1125         26,832.40           547.6           252   27,380.00 X
          Nov. 15        See Payroll Journal                  1126-8
          Nov. 15        Internal Revenue Service                    1129          3,508.09                                                                                      20300         1,517.33   X
                                                                                                                                                                                 20600         1,990.76   X
          Nov. 15        Internal Revenue Service                      1130           13.33                                                                                      20500            13.33   X
          Nov. 15        State of Illinois                             1131           44.98                                                                                      20400            44.98   X
          Nov. 17        Worldwide Management                          1132        4,800.00                                                                                      40100         4,800.00   X
          Nov. 17        Board of Water & Light                        1133        1,763.65                                                                                      41000         1,763.65   X
          Nov. 18        Interstate Motor Freight                      1134        2,356.99                                                                     2,356.99
          Nov. 18        University Athletic News                      1135        3,250.00                                                                                      40200         3,250.00 X
          Nov. 23        Chicago Office Supply                         1136          558.09                           253           558.09
          Nov. 30        See Payroll Journal                  1137-9

                                                                                  44,113.33         547.60                       28,923.89                      2,356.99                      13,380.05
                                                                              X               X                             X                             X                              X

          Dec. 7         First Security Insurance                      1140        2,575.00                                                                                      41000         2,575.00
          Dec. 12        Chicago Office Supply                         1141        7,367.00                           253         7,367.00 X
          Dec. 13        Velocity Sporting Goods                       1142       35,392.70           722.3           252        36,115.00 X
          Dec. 13        Worldwide Management                          1143        4,800.00                                                                                      40100         4,800.00
          Dec. 14        Board of Water & Light                        1144        1,360.25                                                                                      41000         1,360.25
          Dec. 14        Interstate Motor Freight                      1145          778.75                                                                       778.75
          Dec. 15        Internal Revenue Service                      1146        3,523.23                                                                                      20300         1,516.07
                                                                                                                                                                                 20600         2,007.16
          Dec. 15        Internal Revenue Service                      1147          14.82                                                                                       20500            14.82
          Dec. 15        State of Illinois                             1148          50.03                                                                                       20400            50.03
          Dec. 15        See Payroll Journal




Payroll Journal

                                                                                                  Earnings                                        Deductions                      Payment                       Sub.
                                                                 Reg.              Reg.             OT          OT              Gross Pay      FICA          FIT            Net Pay    Check No.              Post. Ref
                  Date                Employee                   Hours             Pay            Hours         Pay

          Nov. 15        Ray Kramer                                                 3500.00                                        3500.00       267.75            441.71      2790.54             1126 X
                         Jim Adams                                       88         1680.00           12.88       405.72           2085.72       159.55            286.47      1639.70             1127 X
                         Nancy Ford                                      60          833.00                                         833.00        63.73              8.72       760.55             1128 X

          Nov. 30        Ray Kramer                                                 3500.00                                        3500.00       267.75            441.71      2790.54             1137 X
                         Jim Adams                                       88         1848.00           10.54       332.01           2180.01       166.77            310.04      1703.20             1138 X
                         Nancy Ford                                      60         1020.00                                        1020.00        78.03             27.42       914.55             1139 X

                                             Monthly Totals                        12381.00                       737.73          13118.73      1003.58          1516.07      10599.08

          Dec. 15        Ray Kramer                                                 3500.00                                        3500.00       267.75            441.71      2790.54             1149 X
                         Jim Adams                                       88         1848.00            5.77       181.76           2029.76       155.28            272.48      1602.00             1150 X
                         Nancy Ford                                      88         1496.00            1.23        31.37           1527.37       116.84             86.19      1324.34             1151 X




                                             Monthly Totals
406 Company ROSEMONT UNIVERSITY
    Address 121 E. Frong
            Louisville, KY 40202           Credit Limit    125,000.00
      Date                  Entry              Debit        Credit      Balance
    Oct. 1  Balance Forward                                                   0.00
    Oct. 6  Invoice #722                       29,018.00                 29,018.00
    Oct. 14 Payment #722                                    29,018.00         0.00
    Nov. 7  Invoice #724                        2,460.00                  2,460.00
    Nov. 17 Payment #724                                     2,460.00         0.00
    Dec. 2  Invoice #727                        4,174.00                  4,174.00
    Dec. 9  Payment #727                                     4,174.00         0.00




407 Company CLAYBORN UNIVERSITY
    Address 13210 S. Upton
            Logansport, IN 46947           Credit Limit    125,000.00
      Date                 Entry               Debit        Credit      Balance
    Oct. 1  Balance Forward                                                  0.00
    Dec. 7  Invoice #728                        7,252.00                 7,252.00
    Dec. 15 Payment #728                                     7,252.00        0.00




408 Company BRANCH COLLEGE
    Address 242 W. Holt Road
            Trenton, MO 64683              Credit Limit    100,000.00
      Date                 Entry               Debit        Credit      Balance
    Oct. 1  Balance Forward                                              46,551.00
    Oct. 7  Payment #721                                    45,351.00     1,200.00
    Nov. 10 Invoice #725                       32,912.00                 34,112.00
    Nov. 18 Payment #725                                    32,912.00     1,200.00
    Dec. 13 Invoice #730                        1,656.00                  2,856.00




409 Company UNIVERSITY OF SOUTHERN IOWA
    Address 1231 S. Ceader
            Dubuque, IA 52003           Credit Limit       100,000.00
      Date                 Entry            Debit           Credit      Balance
    Oct. 1  Balance Forward                                                  0.00




410 Company EASTERN WISCONSIN UNIVERSITY
    Address 14123 W. Saginaw
             Madison, WI 53702          Credit Limit    75,000.00
     Date                   Entry           Debit       Credit      Balance
   Oct. 1    Balance Forward                                              0.00
   Nov. 14   Invoice #726                   24,905.00                24,905.00
   Nov. 21   Partial Payment #726                        5,000.00    19,905.00
   Dec. 9    Invoice #729                   21,872.00                41,777.00



411 Company STEVENSON COLLEGE
    Address 2689 Industrial Boulevard
            Chicago, IL 60614           Credit Limit    75,000.00
      Date                  Entry           Debit       Credit      Balance
    Oct. 1  Balance Forward                                           2,900.00
    Oct. 24 Invoice #723                    57,696.00                60,596.00
    Nov. 7  Return for Credit #CM-41                    23,014.00    37,582.00
    Nov. 7  Payment #723                                34,682.00     2,900.00
252 Company VELOCITY SPORTING GOODS
    Address 1285 Colgrove Ave.
            Pierre, SD 57501
    Terms:  2/10, Net 30                Freight:       Collect
      Date               Description        Debit          Credit      Balance
    Oct. 1  Balance Forward                                                  0.00
    Oct. 5  Vendor Invoice #32407                         81,285.00     81,285.00
    Oct. 14 Check #112                     81,285.00                         0.00
    Nov. 3  Vendor Invoice #33371                         27,380.00     27,380.00
    Nov. 13 Check #1125                    27,380.00                         0.00
    Dec. 5  Vendor Invoice #33965                         36,115.00     36,115.00
    Dec. 13 Check #1142                    36,115.00                         0.00




253 Company Chicago Office Supply
    Address 1411 E. Michigan
            Chicago, IL 60606
    Terms:  Due on receipt of invoice   Freight:       No charge
      Date              Description         Debit          Credit      Balance
    Oct. 1  Balance Forward                                             1,087.83
    Oct. 7  Check #1111                     1,087.83                        0.00
    Oct. 19 Vendor Invoice #2112                             985.80       985.80
    Nov. 8  Check #1124                       985.80                        0.00
    Nov. 21 Vendor Invoice #2275                             558.09       558.09
    Nov. 23 Check #1136                       558.09                        0.00
    Dec. 12 Vendor Invoice #2344                            7,367.00    7,367.00
    Dec. 12 Check #1141                     7,367.00



261 Company GILLETT CONSULTING
    Address 5613 Lantern View
            Chicago, IL 60612
    Terms:  Net 30 days                 Freight:
      Date              Description         Debit          Credit      Balance
    Oct. 1  Balance Forward                                                 0.00
    Oct. 3  Vendor Invoice #9884                            3,650.00    3,650.00
Pay Rate History

                                                                                Withholding
             Employee         Pay Rate        Time Unit        Filing Status    Allowance




Subsidiary Ledgers

          Employee:        Ray Kramer                    Soc. Sec. No.   365-73-2376
          Home Address 417 Cherry, Chicago, 60912        Phone No.       781-3565
          Emplyed                4/6/1994                Date of Termination
          Date of Birth        2/15/1962                 Occupation      Manager
                        Date                      Hours Worked
           Period Ending        Paid      Regular Hours      OT Hours      Gross Pay
                10/1/2005 Balance Forward                                    63,000.00

               10/15/2005     10/14/2005                                           3,500.00
               10/31/2005     10/31/2005                                           3,500.00
                            Cumulative Annual Total                               70,000.00

               11/15/2005     11/15/2005                                           3,500.00
               11/30/2005     11/30/2005                                           3,500.00
                            Cumulative Annual Total                               77,000.00

               12/15/2005      12/15/2005                                          3,500.00

                            Cumulative Annual Total                               80,500.00




          Employee:        Jim Adams                     Soc. Sec. No.   379-54-9833
          Home Address 2522 Longfellow, Chicago 60823    Phone No.       351-5874
          Emplyed               1/16/2001                Date of Termination
          Date of Birth         10/1/1976                Occupation      Accounting Clerk
                        Date                      Hours Worked
           Period Ending        Paid      Regular Hours      OT Hours      Gross Pay
                10/1/2005 Balance Forward                                    37,281.22

               10/15/2005      10/14/2005                 80            11.87      2,221.91
               10/31/2005      10/31/2005                 88             8.75      2,123.63
                  Cumulative Annual Total                          41,626.76

     11/15/2005     11/15/2005              88           12.88      2,085.72
     11/30/2005     11/30/2005              88           10.54      2,180.01
                  Cumulative Annual Total                          45,892.49

     12/15/2005      12/15/2005             88            5.77      2,029.76

                  Cumulative Annual Total                          47,922.25




Employee:        Nancy Ford                    Soc. Sec. No.   367-55-4832
Home Address 1018 Whittier, Chicago, 60823     Phone No.       351-5251
Emplyed              10/1/2005                 Date of Termination
Date of Birth        5/22/1972                 Occupation      Clerk
              Date                      Hours Worked
 Period Ending       Paid       Regular Hours      OT Hours      Gross Pay
      10/1/2005 Balance Forward                                         0.00

     10/15/2005     10/14/2005              48                        816.00
     10/31/2005     10/31/2005              50                        850.00
                  Cumulative Annual Total                           1,666.00

     11/15/2005     11/15/2005              60                        833.00
     11/30/2005     11/30/2005              60                      1,020.00
                  Cumulative Annual Total                           3,519.00

     12/15/2005      12/15/2005             88            1.23      1,527.37

                  Cumulative Annual Total                           5,046.37
             Effective Date   Approval




                 FICA           FIT         Net Pay
                 4,819.50       8,294.94   49,885.56

                    267.75        460.83    2,771.42
                    267.75        460.83    2,771.42
                  5,355.00      9,216.60   55,428.40

                    267.75        460.83    2,771.42
                    267.75        460.83    2,771.42
                  5,890.50     10,138.26   60,971.24

                   267.75        460.83     2,771.42

                  6,158.25     10,599.09   63,742.66




counting Clerk

                 FICA           FIT         Net Pay
                 2,852.02       5,091.05   29,338.15

                   169.97        320.52     1,731.42
                   162.46        295.95     1,665.22
3,184.45   5,707.52     32,734.79

  159.55     286.47      1,639.70
  166.77     310.04      1,703.20
3,510.77   6,304.03     36,077.69

  155.28    272.48       1,602.00

3,666.05   6,576.51     37,679.69




FICA       FIT          Net Pay
    0.00         0.00       0.00

   62.42      7.02         746.56
   65.03     10.42         774.55
  127.45     17.44       1,521.11

   63.73      8.72         760.55
   78.03     27.42         914.55
  269.21     53.58       3,196.21

  116.83     86.19       1,324.35

  386.04    139.77       4,520.56
Item              Office Furniture          Depreciation Method        Straight-line
Purchased From Chicago Office Supply        Where Located              Office
Estimated Life    5 years                   Estimated Salvage Values $            0.00
                                     Asset Record                                    Depreciation Recor
      Date             Debit       Credit            Balance                Debit
        9/30/2003     50,750.00                             50,750.00
       12/31/2003
       12/31/2004
       12/31/2005
       12/31/2006
       12/31/2007
       12/31/2008




Item           Delivery Trucks               Depreciation Method        Straight-line
Purchased From Dyckstra Ford                 Where Located              Loading Dock
Estimated Life 5 years                       Estimated Salvage Values $            0.00
                                      Asset Record                                    Depreciation Recor
      Date            Debit         Credit            Balance                Debit
       4/21/2007      69,255.00                              69,255.00
      12/31/2007
      12/31/2008




Item              Inventory Handling System Depreciation Method          Straight-line
Purchased From Conveyor Systems, Inc.         Where Located              Warehouse
Estimated Life    10 years                    Estimated Salvage Values $            0.00
                                       Asset Record                                    Depreciation Recor
      Date            Debit         Credit             Balance                Debit
         7/5/2008    200,660.00                              200,660.00
       12/31/2008




Item              High-Speed Copier         Depreciation Method        Straight-line
Purchased From Chicago Office Supply        Where Located              Office
Estimated Life    5 years                   Estimated Salvage Values $            0.00
                                     Asset Record                                    Depreciation Recor
      Date            Debit        Credit            Balance                Debit
       12/12/2009      7,367.00                              7,367.00
Item                              Depreciation Method
Purchased From                    Where Located
Estimated Life                    Estimated Salvage Values $
                           Asset Record                                Depreciation Recor
     Date        Debit   Credit            Balance             Debit
Depreciation Record
      Credit        Balance       NBV
                                 50,750.00
       5,075.00      5,075.00    45,675.00
      10,150.00     15,225.00    35,525.00
      10,150.00     25,375.00    25,375.00
      10,150.00     35,525.00    15,225.00
      10,150.00     45,675.00     5,075.00
       5,075.00     50,750.00         0.00




Depreciation Record
      Credit        Balance       NBV
                                 69,255.00
       6,925.50      6,925.50    62,329.50
      13,851.00     20,776.50    48,478.50




Depreciation Record
      Credit        Balance       NBV
                                200,660.00
      10,033.00     10,033.00   190,627.00




Depreciation Record
      Credit        Balance      NBV
                                 7,367.00
Depreciation Record
      Credit        Balance   NBV
                                         Bank Stmt        G/L
Unadjusted Trial Balance, 12/31/01

Add:



Deduct Outstanding Checks




                                               0.00

Adjustments
 Bank service charge

                 Adjusted Balance    $          -     $         -