Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with this systems understanding aid in my accounting information systems class. I just need the journals and ledgers. I have attached the
I need help with this systems understanding aid in my accounting information systems class. I just need the journals and ledgers. I have attached the transaction list and all the documents to complete the journals and ledgers.
Systems Understanding Aid Instructions 1. 2. 3. 4. 5. Read the reference guide and the instructions. Study the flow charts provided in the instruction booklet. Read all instructions and notes on the transaction list. Review all Systems Understanding Files in Course Documents. The systems approach will be used to complete this project. Process the transactions by business cycle. a. Sales journal b. Cash receipts journal c. Purchases journal d. Cash disbursements journal Remember that each cycle has sub-cycles that are to be included in the cycle. 6. Classify each transaction on the transaction list as a. Sales journal b. Cash receipts journal c. Purchases journal d. Cash disbursements journal e. General journal 7. Process the transactions using the workpapers provided in ASSIGNMENTS Systems Understanding Aid -in the order specified in step 5. Handwritten projects will not be accepted. 8. The transaction list will lead you through each step in detail. 9. Begin processing the month's activities using the steps in the accounting cycle. 10. Submit each journal as it is completed. 11. Follow the directions given in the transaction list. 12. Each student must have their own project. If students hand in the same file printout of any portion of this project, all will receive zeroes. 13. It is important that this material be understood. 14. If the accounting cycle is understood, it is understood that one step determines the next. IE -- if the journal entry is wrong, the general ledger is wrong, and the financial statements are wrong. There is no way that errors in the system can result in perfect financial statements. Therefore, if there are errors in the project, but perfect financial statements, the project will receive a zero. However, if the mistakes are processed correctly points will be deducted. This is a round about way of sayingif financial statements are copied from others all involved will receive zeroes. If there are errors, related points will be deducted. Our employers are telling us that our students do not understand the accounting cycle. Some are even testing for understanding. This is unheard of to test students for understanding of basics when they hold a 4-year degree. Therefore, this is your chance to solidify your understanding. You can ask questions and work together, but you cannot divide up the project and hand in the same file as another student. Purchase a cheap three-ring folder-- Soft plastic -not the hard notebook. Organize your project within that binderthis will minimize handling of the documents. The project is due on the date provided in the assignment schedule. There are no exceptions. If you have questions, please post them to the Discussion Board Other notes: 1. The online documents do not have to used. The documents can be filled out by hand. This is the only part of the assignment that is acceptable handwritten. 2. The checks do not have to written. They can be filed as if filled out. There is nothing to be learned from filling out blank checks. 3. I will provide a the authors filing solution 4. I will provide a list of check figures. Document No. 1 Transactions List December 16-31, 2013 Complete each of the following transactions in accordance with the seven-step process on pages 11-12 of the Instructions, Flowcharts, and Ledgers book (step 5). Remember the importance of the systems flowcharts on pages 18-24 for details as to (a) documents to prepare, (b) approvals and other internal control procedures, (c) accounting entries, and (d) filing. You are to perform the roles of Ray Kramer, Nancy Ford, and Jim Adams. Some of the following events require the preparation or modification of systems documents and some do not. Although systems documents accompany most business transactions, you are asked to prepare and work with only a representative sample in this project. Each event on the transactions list includes one of three symbols, which determine whether documents from the loose document set in this project must be prepared or used: You are required to prepare or modify documents from the loose document set for this event. An accounting entry may or may not be required. Yes You are not required to prepare or modify documents from the loose document set because documents would not normally be prepared or modified for this type of event. An accounting entry is required, with one exception: the December 20 change in pay rates. No You are not required to prepare or modify documents from the loose document set, although this type of event would normally require you to do so. These events are included to provide additional practice in recording transactions. An accounting entry is required. No Hints are provided in boxed areas like this. December Yes 16 Received validated deposit receipt (Doc. No. 11) from the bank for $7,931.96 deposit made December 14. B Follow flowchart on page 21. No recording occurs at this time. Cash receipts prelist is Doc. No. 9. File Doc. No. 9 and Doc. No. 11 in the Temporary file tab. December Yes 16 Ordered the following inventory on account from Velocity Sporting Goods, using purchase order No. 328 (Doc. No. 16). Units 115 60 70 85 Vendor address: Freight carrier: Freight charges: Allowances: Yes 16 19 1285 Colgrove Avenue, Pierre, SD 57501 Interstate Motor Freight Collect (i.e., paid by Waren Sports Supply) None Follow flowchart on page 22. Use purchase order No. 325 (Doc. No. 16) as a guide. Use the price list (Doc. No. 3). No receiving or recording occurs at this point for this transaction. Tear document apart and file, following the flowchart guidance. Borrowed $80,000 from First American Bank and Trust by issuing a two-year note payable (Doc. No. 14) with a stated annual interest rate of 6%. Check No. 545 (Doc. No. 8) for $80,000 was received from the bank and deposited. Reviewed the terms and conditions of the note and signed it (Ray Kramer) as the borrower. Yes Description Basketball pole pad Basketball bag Portable inflation pump Trainer's first aid kit Restrictively endorse means to write the following on the back of the check: \"For deposit only. Waren Sports Supply.\" See flowchart, page 21, for recording and depositing. Detach the bottom portion of the check and file in the Shipping/Banking file tab. File the note in the Shipping/Banking file tab. Received customer purchase order No. ST3107 (Doc. No. 4) in the mail from Clayborn University, approved their credit and shipped the goods. All goods ordered were shipped, except that only 45 shoulder pad sets were available for shipment. Carrier & number: Allied Trucking; Carrier number 2154 Freight charges: FOB shipping point; Billed to buyer (i.e., paid by Clayborn) Route: Express Truck & driver: Truck 2961XZ, Linda Arensmeier Freight rate: $15.00 per 100 lbs. Shipment: 3 cartons/goal and rim sets @ 26 lbs./carton 6 cartons/backboards @ 125 lbs./carton 5 cartons/shoulder pad sets @ 40 lbs./carton 4 cartons/football helmets @ 24 lbs./carton B 2 See flowchart, pages 18 and 19; follow all steps carefully. You will use several documents and record an entry in the sales journal and the accounts receivable subsidiary ledger for this transaction. For guidance in preparing the bill of lading, see pages 35-36 of the Reference book. December Yes 20 Received sales return request No. R8034 (Doc. No. 12) in the mail from Eastern Wisconsin University (EWU). The request was approved and the acknowledgment copy mailed to EWU. No 20 Increased employee pay rates, and employees changed their federal income tax withholding amounts, both effective December 16. There were no changes in filing status or withholding allowances. New Federal Income Tax New Pay Rate Withholding Amt. Ray Kramer $3,600.00 semimonthly $466.71 Jim Adams $22.00 per hour $365.06 Nancy Ford $18.00 per hour $136.90 Yes 23 Follow the flowchart steps on page 20. No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. Received merchandise from Velocity Sporting Goods as listed on purchase order No. 328. All merchandise listed on the purchase order was delivered in good condition and in the quantities ordered, except that only 100 basketball pole pads (Item No. BB-019) were received. The goods were placed immediately in the inventory warehouse. Freight carrier: Freight bill: Interstate Motor Freight No. 26425 (Doc. No. 19), received with shipment Remember to follow the flowchart on page 22. You can't record a purchase yet because the invoice hasn't been received. Yes 23 Received check No. 28564 (Doc. No. 8) from Branch College for payment in full for charge invoice No. 730, and deposited the check. No 23 Received legal notification from Benson, Rosenbrook, and Martinson, P.C., attorneys at law, that Stevenson College had filed bankruptcy and will be unable to pay any of its outstanding debts to its suppliers. Write off the account as a bad debt. Yes B 24 Remember that Waren Sports Supply uses the \"Allowance\" method rather than \"Direct write-off\" for accounting for bad debts. Received all goods that Waren had authorized Eastern Wisconsin University (EWU) to return on EWU's return request No. R8034 for credit against their account balance. 3 Yes 24 Process and record the sales return now. Received check No. 49326 (Doc. No. 8) for $9,000 from Eastern Wisconsin University in partial payment of the remaining amount (after sales return) on charge invoice No. 729, and deposited the check. Do not finalize a deposit slip until you determine whether there are other cash receipts on the same day. December Yes 24 Received vendor invoice No. 34719 (Doc. No. 18) from Velocity Sporting Goods for goods ordered December 16 and received December 23. Yes 24 Issued a check (Doc. No. 20) to Interstate Motor Freight for the amount of the freight bill (Doc. No. 19) for the Velocity Sporting Goods shipment received December 23. Yes 24 Follow the flowchart steps on page 22. Upon receiving the invoice, you can now record the purchase using the date on which Waren incurred the liability for the goods, December 23. Follow the flowchart steps on page 23. Received check No. 7403 (Doc. No. 8) for $9,165 and customer purchase order No. 94772 (Doc. No. 4) in the mail from Andover University for a cash sale. All goods ordered were shipped and the cash sale was processed and recorded. Carrier & number: Freight charges: Route: Truck & driver: Freight rate: Shipment: No 24 Start with the flowchart on page 21. Made a special promotional sale on account to Rosemont University. For the promotion, Waren agreed to a 15% reduction in the selling prices of the following items: Quantity 30 5 Yes B 26 Interstate Motor Freight; Carrier number 62XY404 Collect (i.e., paid by Andover University) Direct Truck 64, Dale Hoch $15.00 per 100 lbs. 5 cartons/basketballs @ 23 lbs./carton 4 cartons/hip, tail, arm pad sets @ 36 lbs./carton 2 cartons/footballs @ 16 lbs./carton Item No. BA-054 BA-807 Description Premium aluminum bat Pitching machine Received office supplies from Chicago Office Supply as listed on purchase order No. 327 (Doc. No. 16), a copy of which is being held in accounting. Chicago Office Supply's vendor invoice No. 2378 (Doc. No. 18) was received with the goods. All supplies ordered were received in good condition and taken directly to the office, but the invoice was not paid. 4 No 26 Sold bookshelves to Nancy Ford for $300. Nancy will pay this amount to Waren in January of 2014. The bookshelves were purchased for a cost of $1,000 on September 30, 2007 along with other office furniture costing $49,750 (total purchase was $50,750). The bookshelves were fully depreciated at the end of 2012. Add a new general ledger account on page 36. Assign it G/L #10210 - Accounts Receivable from Employees. Be sure to include this account in the proper section of Waren's 2013 financial statements. Do not be concerned that the new account is out of sequence in the G/L. Waren reorganizes its chart of accounts and G/L at the beginning of a new fiscal year. Don't forget to update the fixed asset subsidiary ledger on pages 42- 43. December No 26 Received check No. 4014 from Central Brokerage for $1,200 of dividend income. The dividends were earned on various common stocks in the marketable securities general ledger account. Yes 30 Issued check (Doc. No. 20) to Velocity Sporting Goods for payment in full of their invoice No. 34719 for goods received December 23. No 30 Received check No. 14002 for $6,122.55 from Rosemont University in payment of the promotional sale on account made December 24. Yes 31 Yes Paychecks are considered \"Mailed/Given to Outsiders.\" Timecards are filed in the \"Accounting\" file tab. Recall that federal income tax withholding amounts were listed earlier with employee pay rate increases. 31 Received the laptop computers ordered on Waren's purchase order No. 325 (Doc. No. 16) and vendor invoice No. 2423 (Doc. No. 18) from Chicago Office Supply. The computers were received in new and undamaged condition and taken directly to the office. The estimated useful life is 5 years with no salvage value. 31 Received vendor invoice No. 72654 (Doc. No. 18) from University Athletic News for advertisements Waren ran during the Christmas season and immediately issued a check (Doc. No. 20) for payment in full. B Recall that the original sale was made at a 15% promotional discount. Because Rosemont paid within ten days of the original sale, be sure to record the applicable discount. Received payroll time cards (Doc. No. 21) from Ford and Adams for the time period ended December 31 and prepared the payroll for all three employees, including paychecks. Yes Consider the credit terms before making the payment. Purchase orders are not issued for services that Waren purchases. 5 No No 31 Purchased 200 shares of Redhawk Corporation common stock for $22.00 per share plus commission of $90.00. Immediately issued a check payable to Central Brokerage. 31 The Board of Directors declared a $2.25 per share dividend on the 3000 shares of $75 par value common stock outstanding. The dividends will be payable on January 31, 2014 to all stockholders of record as of January 25, 2014. No 31 Add a new general ledger account on page 36. Assign it G/L #29010 - Dividends Declared. Be sure to include this account in the proper section of Waren's 2013 financial statements. Issued check to First American Bank and Trust for $10,000 for partial payment on the bank note, which included no payment for interest. The terms on the back of the bank note stipulate that prepayments can be made without early payment penalty. For purposes of the year-end adjusting entry for accrued interest that you will be making later, assume that this payment was not received by the bank until January 2, 2014. December No 31 Issued check for $4,800 to First Security Insurance for the premium on Waren's six-month liability insurance policy. The policy period runs from December 1, 2013 to June 1, 2014. No 31 Sold 150 shares of Sohn Corporation common stock for $27.00 per share. The shares were originally purchased on July 11, 2013 for $21.00 per share plus a commission of $60. Central Brokerage retained a commission of $70 on the sale and forwarded check No. 4289 for the net sale proceeds to Waren. No Yes No Calculate and record the gain or loss on the sale of the marketable securities. Be sure to consider the effects of both the purchase and sale commission expenses. 31 Loaned $8,000 to Maple Valley Electric by issuing a four-year note receivable with a stated annual interest rate of 8%. The funds were loaned by issuing a check. Interest payments of $640.00 are due on December 31 of each year, beginning in 2014. The entire principal is due four years from December 31, 2013. 31 The company signed an agreement to sublease an office in its building to Basso & Associates at a monthly rental rate of $1,200 . In connection with the sublease, Waren received check No. 55941 for $3,600 from Basso & Associates covering rent for the first quarter of 2014. B Remember to consider the time period to which this expenditure applies. Add a new general ledger account on page 36. Assign it G/L #21100 - Unearned Revenue. Be sure to include this account in the proper section of Waren's 2013 financial statements. 6 MONTH-END PROCEDURES - After you have recorded all the transactions, go to page 12 of the Instructions, Flowcharts, and Ledgers book and complete all the month-end procedures. An additional month-end requirement for this project is: Yes Monthly Statement - Prepare a monthly statement (Doc. No. 15) for Clayborn University. YEAR-END PROCEDURES - After completing all the month-end procedures, go to page 14 of the Instructions, Flowcharts, and Ledgers book and complete all the year-end procedures. Additional information for the year-end procedures is: No Ending Inventory - A physical inventory was taken 1/1/14, before business began for the new year. Merchandise on hand cost $193,306.00 . No Bad Debt Expense - The expense for bad debts is estimated at the end of the year as one-quarter of one percent (0.0025) of net sales. No Marketable Securities - At December 31, 2013, the market value of marketable securities held by Waren approximated the cost of the securities. The project is now complete. Good work! Review your materials to make certain everything is finalized. Complete the filing of documents, records, and working papers using the file tabs and the envelope in which the Aid is packaged. File all materials as indicated in the flowcharts. B 7 Document No. 3 PRICE LISTS CURRENT AS OF DECEMBER 1, 2013 VELOCITY SPORTING GOODS Item No. Baseball items: BA-054 BA-158 BA-199 Description Premium aluminum bat Baseballs - 12 game balls Fielding glove Cost Selling Price $ 139.00 42.00 46.00 205.00 65.00 61.00 BA-281 BA-445 BA-507 BA-667 BA-694 BA-807 60 lb. dry line marker Catcher's mask Baseball equipment bag Ball bucket with seat - set of 3 Batting gloves - 1 pair Pitching machine 65.00 48.00 27.00 23.00 24.00 164.00 107.00 72.00 41.00 32.00 33.00 240.00 BA-859 Set of bases 111.00 185.00 25.00 94.00 35.00 135.00 258.00 95.00 83.00 10.00 25.00 26.00 400.00 140.00 115.00 14.00 35.00 42.00 Basketball items: BB-008 Basketball BB-019 Basketball pole pad BB-113 BB-267 BB-358 BB-399 BB-431 BB-538 Scoreboard and timer Goal and rim set Backboard Basketball net Whistle and lanyard - set of 6 Basketball bag BB-688 BB-926 Portable inflation pump Trainer's first aid kit 69.00 30.00 110.00 43.00 Shoulder pad set 89.00 125.00 39.00 55.00 21.00 135.00 58.00 90.00 29.00 225.00 16.00 96.00 27.00 83.00 26.00 25.00 150.00 38.00 122.00 40.00 Football items: FB-027 FB-091 FB-225 FB-344 FB-513 Hip, tail, arm pad set Football helmet Football Portable storage locker FB-573 FB-650 FB-812 FB-874 FB-952 Kicking tees - set of 6 Football post pad Collapsible cones - set of 8 Sideline repair kit Portable hand warmer CHICAGO OFFICE SUPPLY Item No. 4126 4733 5433 8506 5302 Description Laser printer toner cartridge Copier paper - box Rewritable CDs Flash drive - 4GB Invoice forms - 100 Cost $ 46.50 19.50 12.50 14.50 6.00 6211 8843 2342 6277 7246 Legal pad - box of 5 Time cards - box of 50 Black ink pens - box of 12 Pencils - box of 24 Business envelopes - box of 1000 12302 12480 15321 3.95 6.90 4.50 2.25 15.50 Laptop computer Flat panel monitor High-speed copier $ 2,150.00 195.00 6,950.00 Approved By Ray Krame B 9 GENERAL JOURNAL: Date Nov Account No. 30 40600 20600 20400 20500 November and December Explanation Payroll Tax Expense FICA Payable SUTA Payable FUTA Payable Post Debit Credit 1,068.43 21.00 1,003.58 50.03 14.82 To record November payroll Nov 30 41000 Other Operating Expense 10100 Cash To record November bank service charge 21.00 SALES JOURNAL: November and December Invoice or Subsidiary Subs Credit Memo Account Post Number Number CM41 411 (23,014.00) 724 406 2,460.00 2,460.00 10 Branch College 725 408 32,912.00 32,912.00 14 Eastern Wisconsin University 726 410 24,905.00 24,905.00 Date Nov Customer 7 Stevenson College 7 Rosemont University Debit Accts Rec Sales Returns Sales G/L 10200 Monthly Totals G/L 30200 G/L 30100 37,263.00 Dec Credit 23,014.00 23,014.00 60,277.00 2 Rosemont University 727 406 4,174.00 4,174.00 7 Clayborn University 728 407 7,252.00 7,252.00 9 Eastern Wisconsin University 729 410 21,872.00 21,872.00 730 408 1,656.00 1,656.00 13 Branch College CASH RECEIPTS JOURNAL: November and December DEBIT CREDIT Dept Nov Description 7 13 17 18 Stevenson College McClain College Rosemont University Branch College 21 Eastern Wisconsin Unversity Monthly Totals Dec 6 Gates Unversity 9 14 15 15 Rosemont University Hancock College Clayborn University Atwood Brothers Sales Disc Control G\\L G\\L Subs Trans Subs G\\L Acct Trans Post Initials Date Cash 10100 30300 Acct No. Amount Post Ref 30100 No. Amount Ref 411 34,682.00 406 408 2,460.00 32,912.00 410 5,000.00 NF NF NF NF NF 34,682.00 7,767.00 2,410.80 32,253.76 82,113.56 NF 4,090.52 5,306.00 7,106.96 825.00 Other G/L 5,891.00 NF NF Sales 7767 49.20 658.24 5,000.00 RK Accounts Receivable G/L 10200 707.44 75,054.00 7,767.00 ### 83.48 406 4,174.00 145.04 407 7,252.00 ### 31200 825.00 PURCHASES JOURNAL November and December DEBIT Vendor Date Credit Other G/L Accounts Payable G/L 20100 Purchases 3 Velocity Sporting Goods 21 Chicago Office Supply Invoice G\\L Acct. Trans Post Subs Trans Subs Returns No. Nov Vendor Purchases 30500 No. Amount Ref Acct No. Amount Post Ref G/L 30600 33371 2275 Monthly Totals 27,380.00 40300 27,380.00 558.09 252 253 558.09 5 Velocity Sporting Goods 12 Chicago Office Supply 33965 2344 27,938.09 Dec 27,380.00 558.09 0 36115.00 10800 7367.00 252 253 36115.00 7367.00 CASH DISBURSEMENTS JOURNAL: November and December CREDIT DEBIT Purchases Date Check Description 8 1124 Chicago Office Supply 13 1125 Velocity Sporting Goods 13 1126-8 See Payroll Journal 15 1129 Internal Revenue Service 15 15 17 17 18 18 23 30 1130 1131 1132 1133 1134 1135 1136 1137-9 Internal Revenue Service State of Illinois Worldwide Management Board of Water & Light Interstate Motor Freight University Athletic News Chicago Office Supply See Payroll Journal Monthly Totals Cash Discounts Subs Trans Subs G/L 10100 Number Nov G/L 30700 Acct No Amount Post Ref 26,832.40 7 12 13 13 14 14 15 1140 1141 1142 1143 1144 1145 1146 Freight-In 547.60 985.80 252 27,380.00 30,800.00 44,181.03 First Security Insurance Chicago Office Supply Velocity Sporting Goods Worldwide Management Board of Water & Light Interstate Motor Freight Internal Revenue Service 2,575.00 7,367.00 35,392.70 4,800.00 1,360.25 778.75 3,523.23 15 1147 Internal Revenue Service 15 1148 State of Illinois 15 1149-51 See Payroll Journal 14.82 50.03 Post Amount Ref 1,559.33 2,016.46 13.33 44.98 4,800.00 1,763.65 3,250.00 3,575.79 13.33 44.98 4,800.00 1,763.65 2,356.99 3,250.00 558.09 Trans No 40200 253 G/L Other G/L Acct 20300 20600 20500 20400 40100 41000 985.80 Dec Accounts Payable G/L 20100 ### 253 547.60 558.09 28,923.89 13,447.75 RK 2,356.99 41000 722.30 253 252 7,367.00 36,115.00 2,575.00 40100 41000 4,800.00 1,360.25 20300 20600 20500 20400 1,516.07 2,007.16 14.82 50.03 ### Payroll Journal: November and December EARNINGS Date Employee DEDUCTIONS PAYMENT Subs Regular Regular Overtime Overtime Gross Pay FICA Fed W/H Net Pay Check Post Hours Pay Hours Pay G/L 40500 G/L 20600 G/L 20300 G/L 10100 No Ref Nov ### Ray Kramer 3500.00 3500.00 2790.54 1126 2253.72 172.41 328.47 1752.84 1127 88.00 1848.00 Nancy Ford 49.00 833.00 833.00 63.73 8.72 760.55 1128 3500.00 3500.00 267.75 441.71 2790.54 1137 2012.01 153.91 268.04 1590.06 1138 27.42 914.55 1139 Jim Adams 88.00 1680.00 Nancy Ford 60.00 1020.00 1020.00 78.03 12381.00 737.73 13118.73 1003.58 Monthly Totals 10.54 405.72 441.71 Jim Adams Nov ### Ray Kramer 12.88 267.75 332.01 Dec ### Ray Kramer 1516.07 10599.08 3500.00 3500.00 267.75 441.71 2790.54 1149 Jim Adams 88.00 1680.00 5.77 181.76 1861.76 142.43 230.48 1488.85 1150 Nancy Ford 88.00 1360.00 1.23 31.37 1391.37 106.43 65.79 1219.15 1151 ### -- CASH Journal CR CD PR G CR CD PR G 110,395.64 Journal Oct 1 Oct ### ### ### ### Nov ### ### ### ### Debit Debit Credit Balance Forward Net Wages and Salary Bank Service Charge Net Wages and Salary Bank Service Charge 98,304.36 10,611.98 25.00 82,113.56 44,181.03 10,599.08 21.00 Dr Balance 44,407.53 154,803.17 56,498.81 45,886.83 45,861.83 127,975.39 83,794.36 73,195.28 73,174.28 73,174.28 73,174.28 73,174.28 73,174.28 73,174.28 73,174.28 73,174.28 ### -- ACCOUNTS RECEIVABLE 1 Balance Forward ### ### Nov ### ### Credit Oct S CR S CR 86,714.00 74,369.00 37,263.00 75,054.00 Dr Balance Ctrl Init 49,451.00 NF 136,165.00 61,796.00 NF 99,059.00 24,005.00 NF 24,005.00 24,005.00 24,005.00 24,005.00 24,005.00 ### -- ACCOUNTS RECEIVABLE FROM EMPLOYEES Journal Oct 1 Balance Forward Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ### -- ALLOWANCE FOR DOUBTFUL ACCOUNTS Journal Oct 1 Balance Forward Debit Credit Cr Balance 1,750.81 1,750.81 1,750.81 1,750.81 1,750.81 1,750.81 1,750.81 Journal Debit Credit Dr Balance 101,681.00 101,681.00 101,681.00 101,681.00 101,681.00 101,681.00 101,681.00 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Dr Balance 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 ### -- INVENTORY Oct 1 Balance Forward ### -- PREPAID EXPENSES Oct 1 Balance Forward ### -- MARKETABLE SECURITIES Oct 1 Balance Forward ### -- INTEREST RECEIVABLE Oct 1 Balance Forward 0.00 0.00 0.00 0.00 0.00 0.00 ### -- FIXED ASSETS Journal Credit Dr Balance Ctrl Init 320,665.00 NF 320,665.00 320,665.00 320,665.00 320,665.00 320,665.00 320,665.00 320,665.00 320,665.00 320,665.00 Journal Debit Credit Cr Balance Ctrl Init 81,559.50 NF 81,559.50 81,559.50 81,559.50 81,559.50 81,559.50 81,559.50 81,559.50 81,559.50 81,559.50 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Debit Credit Cr Balance Ctrl Init 1,087.83 NF 87,008.63 4,635.80 NF 32,573.89 3,650.00 NF 3,650.00 3,650.00 3,650.00 3,650.00 3,650.00 1 Balance Forward ### -- ACCUMULATED DEPRECIATION Oct 1 Balance Forward 11000 -- NOTES RECEIVABLE Oct 1 Balance Forward ### -- ACCOUNTS PAYABLE Oct 1 Balance Forward ### ### Nov ### ### P CD P CD 85,920.80 82,372.83 27,938.09 28,923.89 ### -- WAGES AND SALARIES PAYABLE Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Credit Cr Balance 1,515.80 0.00 1,559.33 0.00 1,516.07 1,516.07 1,516.07 1,516.07 1,516.07 1,516.07 1 Balance Forward ### -- FEDERAL INCOME TAXES WITHHELD Oct 1 Balance Forward ### ### Nov ### ### CD PR CD PR ### -- STATE UNEMPLOYMENT TAXES PAYABLE Journal Oct 1 Balance Forward ### G Nov ### CD ### G 1,515.80 1,559.33 1,559.33 1,516.07 Debit Credit 44.98 44.98 50.03 Cr Balance 0.00 44.98 0.00 50.03 50.03 50.03 50.03 50.03 50.03 50.03 ### -- FEDERAL UNEMPLOYMENT TAXES PAYABLE Journal Oct 1 Balance Forward ### G Nov ### CD ### G Debit Credit 13.33 13.33 14.82 Cr Balance 0.00 13.33 0.00 14.82 14.82 14.82 14.82 14.82 14.82 14.82 ### -- F.I.C.A. TAXES PAYABLE Journal Oct 1 ### ### ### Nov ### ### ### Debit Credit Balance Forward F.I.C.A. Withheld Employer's Tax F.I.C.A. Withheld Employer's Tax CD PR G CD PR G 1,745.62 995.38 995.38 1,990.76 1,003.58 1,003.58 Cr Balance 1,745.62 0.00 995.38 1,990.76 0.00 1,003.58 2,007.16 2,007.16 2,007.16 2,007.16 ### -- FEDERAL INCOME TAXES PAYABLE Journal Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 Balance Forward ### -- DIVIDENDS PAYABLE Oct 1 Balance Forward ### -- INTERST PAYABLE Oct 1 Balance Forward ### -- NOTES PAYABLE Oct 1 Balance Forward 21100 -- UNEARNED REVENUE Oct 1 Balance Forward 0.00 ### -- COMMON STOCK Journal Debit Credit Cr Balance 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 225,000.00 Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Cr Balance 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 90,264.99 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Credit Cr Balance 1,326,865.00 1,413,579.00 1,450,186.00 1,510,463.00 1,518,230.00 1,518,230.00 1,518,230.00 1,518,230.00 1,518,230.00 1,518,230.00 1 Balance Forward ### -- PAID-IN CAPITAL IN EXCESS OF PAR Oct 1 Balance Forward ### -- INCOME SUMMARY Oct. 1 Balance Forward ### -- RETAINED EARNINGS Oct 1 Balance Forward ### -- DIVIDENDS DECLARED Oct 1 Balance Forward ### -- SALES Oct 1 ### ### Nov ### ### Balance Forward Credit Sales Cash Sales Credit Sales Cash Sales S CR S CR 86,714.00 36,607.00 60,277.00 7,767.00 ### -- SALES RETURNS AND ALLOWANCES Journal Oct 1 Balance Forward Nov ### ### -- SALES DISCOUNTS TAKEN S Debit 23,014.00 Credit Dr Balance 34,617.00 57,631.00 57,631.00 57,631.00 57,631.00 57,631.00 57,631.00 57,631.00 57,631.00 57,631.00 Journal 1 Balance Forward ### Nov ### Debit Credit Dr Balance 13,856.38 14,436.74 15,144.18 15,144.18 15,144.18 15,144.18 15,144.18 15,144.18 15,144.18 15,144.18 Oct CR CR 580.36 707.44 ### -- COST OF GOODS SOLD Journal Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Debit Credit Dr Balance 969,835.00 1,051,120.00 1,078,500.00 1,078,500.00 1,078,500.00 1,078,500.00 1,078,500.00 1,078,500.00 1,078,500.00 1,078,500.00 Debit Credit Cr Balance 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 19,445.00 Debit Credit Cr Balance 13,388.00 15,013.70 15,561.30 15,561.30 15,561.30 15,561.30 15,561.30 15,561.30 15,561.30 15,561.30 1 Balance Forward ### -- PURCHASES Oct 1 Balance Forward ### Nov ### P P ### -- PURCHASES RETURNS AND ALLOWANCES Journal Oct 1 Balance Forward 81,285.00 27,380.00 ### -- PURCHASES DISCOUNTS TAKEN Journal Oct 1 Balance Forward Oct ### Nov ### CD CD 1,625.70 547.60 ### -- FREIGHT-IN Journal Credit Dr Balance 18,038.35 21,023.95 23,380.94 23,380.94 23,380.94 23,380.94 23,380.94 23,380.94 23,380.94 23,380.94 Debit Credit Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ### -- GAIN/LOSS ON SALES OF MARKETABLE SECURITIES Journal Debit Oct 1 Balance Forward Credit Balance 0.00 1 Balance Forward ### Nov ### Debit Oct CD CD ### -- GAIN/LOSS ON SALE OF FIXED ASSETS Journal Oct 1 Balance Forward 2,985.60 2,356.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 31100 -- INTEREST/DIVIDEND INCOME Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Cr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Credit Dr Balance 43,200.00 48,000.00 52,800.00 52,800.00 52,800.00 52,800.00 52,800.00 52,800.00 52,800.00 52,800.00 Credit Dr Balance 13,030.00 17,555.00 20,805.00 20,805.00 20,805.00 20,805.00 20,805.00 20,805.00 20,805.00 20,805.00 Credit Dr Balance 3,518.41 4,504.21 5,062.30 5,062.30 5,062.30 5,062.30 5,062.30 5,062.30 5,062.30 5,062.30 1 Balance Forward ### -- MISCELLANEOUS REVENUE Oct 1 Balance Forward ### -- RENT EXPENSE Oct 1 Balance Forward ### Nov ### CD CD 4,800.00 4,800.00 ### -- ADVERTISING EXPENSE Journal 1 Balance Forward ### Nov ### Debit Oct CD CD 4,525.00 3,250.00 ### -- OFFICE SUPPLIES EXPENSE Journal 1 Balance Forward ### Nov ### Debit Oct P P 985.80 558.09 ### -- DEPRECIATION EXPENSE Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Credit Dr Balance Ctrl Init 100,281.22 NF 113,460.76 NF 126,579.49 NF 126,579.49 1 Balance Forward ### -- WAGES AND SALARIES EXPENSE Oct 1 Balance Forward Oct ### Nov ### PR PR 13,179.54 13,118.73 126,579.49 126,579.49 126,579.49 126,579.49 126,579.49 126,579.49 ### -- PAYROLL TAX EXPENSE Journal Oct 1 Balance Forward Oct ### Nov ### G G Debit Credit Dr Balance 8,161.52 9,228.06 10,296.49 10,296.49 10,296.49 10,296.49 10,296.49 10,296.49 10,296.49 10,296.49 1,066.54 1,068.43 ### -- FEDERAL INCOME TAX EXPENSE Journal Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Debit Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Journal Oct Debit Debit Credit Dr Balance 17,880.14 17,905.14 21,555.14 23,540.35 23,561.35 25,325.00 25,325.00 25,325.00 25,325.00 25,325.00 Credit Dr Balance 1 Balance Forward ### -- INTEREST EXPENSE Oct 1 Balance Forward ### -- BAD DEBT EXPENSE Oct 1 Balance Forward ### -- OTHER OPERATING EXPENSE Oct 1 Balance Forward Oct ### ### ### Nov ### ### G P CD G CD Journal Oct 1 Balance Forward 25.00 3,650.00 1,985.21 21.00 1,763.65 Debit 406 ROSEMONT UNIVERSITY 121 E. Front Louisville, KY 40202 Date Description Oct 1 Balance Forward Oct 6 Invoice #722 Oct 14 Payment #722 Nov 7 Payment #724 Nov 17 Invoice #724 Dec 2 Invoice #727 Dec 9 Payment #727 407 CLAYBORN UNIVERSITY 13210 S. Upton Logansport, IN 46947 Date Description Oct 1 Balance Forward Dec. 7 Invoice #728 Dec. 10 Payment #728 408 BRANCH COLLEGE 242 W. Holt Road Trenton, MO 64683 Date Description Oct 1 Balance Forward Oct 7 Payment #721 Nov 10 Invoice #725 Nov 18 Payment #725 Dec 13 Invoice #730 409 UNIVERSITY OF SOUTHERN IOWA 1231 S. Cedar Dubuque, IA 52003 Date Description Oct 1 Balance Forward 410 EASTERN WISCONSIN UNIVERSITY 14123 W. Saginaw Madison, WI 53702 Debit Credit Limit: Credit 29,018.00 29,018.00 2,460.00 2,460.00 4,174.00 4,174.00 Debit Credit Limit: Credit 7,252.00 7,252.00 $125,000 Dr Balance 0.00 29,018.00 0.00 2,460.00 0.00 4,174.00 0.00 0.00 0.00 0.00 0.00 0.00 $125,000 Dr Balance 0.00 7,252.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Credit Limit: $100,000.00 Debit Credit Dr Balance 46,551.00 45,351.00 1,200.00 32,912.00 34,112.00 32,912.00 1,200.00 1,656.00 2,856.00 2,856.00 2,856.00 2,856.00 2,856.00 2,856.00 2,856.00 2,856.00 Debit Credit Limit: $100,000.00 Credit Dr Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Credit Limit: $ 75,000.00 Credit Dr Balance 0.00 24,905.00 24,905.00 5,000.00 19,905.00 21,872.00 41,777.00 41,777.00 41,777.00 41,777.00 41,777.00 41,777.00 41,777.00 41,777.00 41,777.00 Debit Oct Nov Nov Dec 1 14 21 9 Balance Forward Invoice #726 Partial Payment #726 Invoice #729 411 STEVENSON COLLEGE 2689 Indurstial Boulevard Chicago, Illinois 60614 Date Description Oct 1 Balance Forward Oct 24 Invoice #723 Nov 7 Return for Credit #CM-41 Nov 7 Payment #723 Credit Limit: $ 75,000.00 Credit Dr Balance 2,900.00 57,696.00 60,596.00 23,014.00 37,582.00 34,682.00 2,900.00 Debit 2,900.00 2,900.00 2,900.00 2,900.00 2,900.00 2,900.00 2,900.00 2,900.00 252 VELOCITY SPORTING GOODS 1285 Colgrove Ave. Pieere, SD 57501 Date Oct Oct Oct Nov Nov Dec Dec TERMS: 2/10, Net 30 Description 1 Balance Forward 5 Vendor Invoice #32407 14 Check #1112 3 Vendor Invoice #33371 13 Check #1125 5 Vendor Invoice #33965 13 Check #1142 FREIGHT: Collect Debit Credit 81,285.00 27,380.00 36,115.00 Dr Balance 0.00 81,285.00 81,285.00 0.00 27,380.00 27,380.00 0.00 36,115.00 36,115.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 253 CHICAGO OFFICE SUPPLY 1411 E. Michigan Chicago, Illinois 60606 Date Oct Oct Oct Nov Nov Nov Dec Dec TERMS: Due on receipt of invoice Description 1 Balance Forward 7 Check #1111 19 Vendor Invoice #2112 8 Check #1124 21 Vendor Invoice #2275 23 Check #1136 12 Vendor Invoice #2344 12 Check #1141 FREIGHT: No Charge Debit Credit 7,367.00 Dr Balance 1,087.83 0.00 985.80 985.80 0.00 558.09 558.09 0.00 7,367.00 7,367.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Debit Credit Debit Credit 1,087.83 985.80 558.09 261 GILLETT CONSULTING 5613 Lantern View Chicago, Illinois 60612 Date Oct Oct TERMS: Net 30 days Description 1 Balance Forward 3 Vendor Invoice #9884 Dr Balance 0.00 3,650.00 3,650.00 3,650.00 3,650.00 3,650.00 3,650.00 3,650.00 Dr Balance 1 Balance Forward 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Item: Office Furniture Depreciation Method Straight-line Purchased from Chicago Office Supply Estimated Life 5 Years Date Sep 30, 07 Dec 31, 07 Dec 31, 08 Dec 31, 09 Dec 31, 10 Dec 31, 11 Dec 31, 12 Asset Record Debit 50,750.00 Credit Where Located Office Est. Salvage Value $ Depreciation Record Balance Debit Credit 50,750.00 50,750.00 5,075.00 50,750.00 10,150.00 50,750.00 10,150.00 50,750.00 10,150.00 50,750.00 10,150.00 50,750.00 5,075.00 50,750.00 50,750.00 50,750.00 50,750.00 50,750.00 50,750.00 0.00 Asset Net Balance Book Value 0.00 50,750.00 5,075.00 45,675.00 15,225.00 35,525.00 25,375.00 25,375.00 35,525.00 15,225.00 45,675.00 5,075.00 50,750.00 0.00 50,750.00 0.00 50,750.00 0.00 50,750.00 0.00 50,750.00 0.00 50,750.00 0.00 50,750.00 0.00 Final Disposition of the Asset Item Purchased Delivery Truck Depreciation Method Straight-line Purchased from Dyckstra Ford Where Located Loading Dock Estimated Life 5 years Date Apr 21, 11 Dec 31, 11 Dec 31, 12 Debit 69,255.00 Asset Record Credit Est. Salvage Value $ Balance 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 69,255.00 Debit 0.00 Depreciation Record Asset Net Credit Balance Book Value 0.00 69,255.00 6,925.50 6,925.50 62,329.50 13,851.00 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 20,776.50 48,478.50 Final Disposition of the Asset Item Purchased Inventory Handling Sys Depreciation Method Straight-line Purchased from Conveyor Systems, Inc. Where Located Warehouse Estimated Life 10 years Date Jul 05,012 Dec 31, 12 Debit 200,660.00 Asset Record Credit Est. Salvage Value $ Balance 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 200,660.00 Debit 0.00 Depreciation Record Asset Net Credit Balance Book Value 0.00 200,660.00 10,033.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 10,033.00 190,627.00 Final Disposition of the Asset Item Purchased High-Speed Copier Purchased from Chicago Office Supply Estimated Life 5 years Date Dec 12, 13 Debit 7,367.00 Asset Record Credit Depreciation Method Straight-line Where Located Office Est. Salvage Value $ Balance 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 0.00 Depreciation Record Asset Net Debit Credit Balance Book Value 0.00 7,367.00 0.00 7,367.00 0.00 7,367.00 0.00 7,367.00 0.00 7,367.00 0.00 7,367.00 0.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 0.00 0.00 0.00 0.00 0.00 0.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 7,367.00 Final Disposition of the Asset Item Purchased Purchased from Where Located Estimated Life Date Depreciation Method Est. Salvage Value $ Debit Asset Record Credit Final Disposition of the Asset Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Debit Depreciation Record Asset Net Credit Balance Book Value 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Pay Rate Time Unit Filing Status Withholding Allowances Effective Date Approved By semimonthly semimonthly M M 2 2 12/16/11 12/16/12 RK RK Ray Kramer $ 3,400.00 3,500.00 Jim Adams $ 20.00 21.00 hourly hourly S S 2 2 12/16/11 12/16/12 RK RK Nancy Ford $ 17.00 hourly M 3 10/01/13 Hire Dt, RK Employee's Name Ray Kramer Soc. Sec. No. 365-73-2376 Home Address 417 Cherry, Chicago, 60912 Phone No. 781-3565 Employed 04/06/02 Date of Termination Date of Birth 02/15/70 Occupation Manager Date Period Ending Paid 10/01/13 Balance Hours Worked Regular Hours Forward Overtime Hours Gross Pay 63,000.00 F.I.C.A. 4,819.50 Federal Income Tax 7,950.78 Net Pay 50,229.72 10/15/13 10/31/13 10/15/13 10/31/13 Cumulative Annual Total 3,500.00 3,500.00 70,000.00 267.75 267.75 5,355.00 441.71 441.71 8,834.20 2,790.54 2,790.54 55,810.80 11/15/13 11/30/13 11/13/13 11/30/13 Cumulative Annual Total 3,500.00 3,500.00 77,000.00 267.75 267.75 5,890.50 441.71 441.71 9,717.62 2,790.54 2,790.54 61,391.88 3,500.00 267.75 441.71 2,790.54 80,500.00 6,158.25 10,159.33 64,182.42 12/15/13 12/15/13 Cumulative Annual Total Employee's Name Jim Adams Soc. Sec. No. 379-54-9833 Home Address 2522 Longfellow, Chicago, 60823 Phone No. 351-5874 Employed 01/16/09 Date of Termination Date of Birth 10/01/84 Occupation Accounting Clerk Date Period Ending Paid 10/01/13 Balance Hours Worked Regular Hours Forward Overtime Hours Gross Pay 37,281.22 F.I.C.A. 2,852.02 Federal Income Tax 5,091.05 Net Pay 29,338.15 10/15/13 10/31/13 10/15/13 88.00 10/30/13 88.00 Cumulative Annual Total 11.87 8.75 2,221.91 2,291.63 41,794.76 169.97 175.31 3,197.30 320.52 337.95 5,749.52 1,731.42 1,778.37 32,847.94 11/15/13 11/30/13 11/13/13 88.00 11/30/13 88.00 Cumulative Annual Total 12.88 10.54 2,253.72 2,012.01 46,060.49 172.41 153.91 3,523.62 328.47 268.04 6,346.03 1,752.84 1,590.06 36,190.84 5.77 1,861.76 142.43 230.48 1,488.85 47,922.25 3,666.05 6,576.51 37,679.69 12/15/13 12/15/13 88.00 Cumulative Annual Total Employee's Name Nancy Ford Soc. Sec. No. 367-55-4832 Home Address 1018 Whittier, Chicago, 60823 Phone No. 351-5251 Employed 10/01/13 Date of Termination Date of Birth 05/22/80 Occupation Clerk Date Period Ending Paid 10/01/13 Balance Hours Worked Regular Hours Foraward Overtime Hours Gross Pay 0.00 F.I.C.A. 0.00 Federal Income Tax 0.00 Net Pay 0.00 10/15/13 10/31/13 10/15/13 48.00 10/30/13 50.00 Cumulative Annual Total 816.00 850.00 1,666.00 62.42 65.03 127.45 7.02 10.42 17.44 746.56 774.55 1,521.11 11/15/13 11/30/13 11/13/13 49.00 11/30/13 60.00 Cumulative Annual Total 833.00 1,020.00 3,519.00 63.73 78.03 269.21 8.72 27.42 53.58 760.55 914.55 3,196.21 1,391.37 106.43 65.79 1,219.15 4,910.37 375.64 119.37 4,415.36 12/15/13 12/15/13 88.00 Cumulative Annual Total 1.23 SYSTEMS UNDERSTANDING AID CHECK FIGURES FOR STUDENTS (12/31/13) TRANSACTIONS LIST - AIS FALL 2015 Financial Statements Current Assets Total Assets Net Sales Operating Expenses (excluding COGS, Interest exp, & FIT) Net Income Net cash provided by operating expenses Net increase in Cash 362,316.79 586,237.79 1,518,176.73 306,846.08 131,234.70 59,964.85 85,529.85 Accounts Receivable Aged T/B Total Accounts Receivable Current Accounts Receivable 45,522.00 24,417.00 Bank Reconciliation Outstanding checks Unadjusted General Ledger Balance, 12/31/13 59,926.54 96,582.54 Year-end Worksheet 12/31/13 Unadjusted Trial Balance Total Adjustments Column Total Journals Sales Journal Credit to #30100 Purchases Journal debit to #30500 Cash Receipts Journal debit to #10100 Cash Disbursements Journal credut to #10100 Payroll Journal debit to #40500 General Ledger Balances #10100 - Cash #30100 - Sales (pre-closing) #30500 - Purchases (pre-closing) #30400 - Cost of Goods Sold (pre-closing) 2,123,007.83 1,249,816.29 56,226.50 54,455.00 137,909.91 102,707.98 14,618.65 96,555.04 1,594,818.50 1,132,955.00 1,029,877.29 SYSTEMS UNDERSTANDING AID CHECK FIGURES FOR STUDENTS (12/31/13) TRANSACTIONS LIST - AIS FALL 2015 Financial Statements Current Assets Total Assets Net Sales Operating Expenses (excluding COGS, Interest exp, & FIT) Net Income Net cash provided by operating expenses Net increase in Cash 362,316.79 586,237.79 1,518,176.73 306,846.08 131,234.70 59,964.85 85,529.85 Accounts Receivable Aged T/B Total Accounts Receivable Current Accounts Receivable 45,522.00 24,417.00 Bank Reconciliation Outstanding checks Unadjusted General Ledger Balance, 12/31/13 59,926.54 96,582.54 Year-end Worksheet 12/31/13 Unadjusted Trial Balance Total Adjustments Column Total Journals Sales Journal Credit to #30100 Purchases Journal debit to #30500 Cash Receipts Journal debit to #10100 Cash Disbursements Journal credut to #10100 Payroll Journal debit to #40500 General Ledger Balances #10100 - Cash #30100 - Sales (pre-closing) #30500 - Purchases (pre-closing) #30400 - Cost of Goods Sold (pre-closing) 2,123,007.83 1,249,816.29 56,226.50 54,455.00 137,909.91 102,707.98 14,618.65 96,555.04 1,594,818.50 1,132,955.00 1,029,877.29 SYSTEMS UNDERSTANDING AID CHECK FIGURES FOR STUDENTS (12/31/13) TRANSACTIONS LIST - AIS FALL 2015 Financial Statements Current Assets Total Assets Net Sales Operating Expenses (excluding COGS, Interest exp, & FIT) Net Income Net cash provided by operating expenses Net increase in Cash 362,316.79 586,237.79 1,518,176.73 306,846.08 131,234.70 59,964.85 85,529.85 Accounts Receivable Aged T/B Total Accounts Receivable Current Accounts Receivable 45,522.00 24,417.00 Bank Reconciliation Outstanding checks Unadjusted General Ledger Balance, 12/31/13 59,926.54 96,582.54 Year-end Worksheet 12/31/13 Unadjusted Trial Balance Total Adjustments Column Total Journals Sales Journal Credit to #30100 Purchases Journal debit to #30500 Cash Receipts Journal debit to #10100 Cash Disbursements Journal credut to #10100 Payroll Journal debit to #40500 General Ledger Balances #10100 - Cash #30100 - Sales (pre-closing) #30500 - Purchases (pre-closing) #30400 - Cost of Goods Sold (pre-closing) 2,123,007.83 1,249,816.29 56,226.50 54,455.00 137,909.91 102,707.98 14,618.65 96,555.04 1,594,818.50 1,132,955.00 1,029,877.29 SYSTEMS UNDERSTANDING AID CHECK FIGURES FOR STUDENTS (12/31/13) TRANSACTIONS LIST - AIS FALL 2015 Financial Statements Current Assets Total Assets Net Sales Operating Expenses (excluding COGS, Interest exp, & FIT) Net Income Net cash provided by operating expenses Net increase in Cash 362,316.79 586,237.79 1,518,176.73 306,846.08 131,234.70 59,964.85 85,529.85 Accounts Receivable Aged T/B Total Accounts Receivable Current Accounts Receivable 45,522.00 24,417.00 Bank Reconciliation Outstanding checks Unadjusted General Ledger Balance, 12/31/13 59,926.54 96,582.54 Year-end Worksheet 12/31/13 Unadjusted Trial Balance Total Adjustments Column Total Journals Sales Journal Credit to #30100 Purchases Journal debit to #30500 Cash Receipts Journal debit to #10100 Cash Disbursements Journal credut to #10100 Payroll Journal debit to #40500 General Ledger Balances #10100 - Cash #30100 - Sales (pre-closing) #30500 - Purchases (pre-closing) #30400 - Cost of Goods Sold (pre-closing) 2,123,007.83 1,249,816.29 56,226.50 54,455.00 137,909.91 102,707.98 14,618.65 96,555.04 1,594,818.50 1,132,955.00 1,029,877.29Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started