Waren sports supply general journal 2017

SUA Project instructions included and sample journal included.

Must use from book "Systems Understanding Aid by Arens, 9th Edition by Arens (Armond Dalton)" ISBN: 978-0-91-2503578

Must be done using Excel (step by step instructions included)
ACCT 3252 SUA – Part A Assignment 1. Go to page 10 in your SUA – Instructions, Flowcharts, and Ledgers book 2. Select the “Blue” Document 1 Transactions List. Also referred to as Letter A. a. DO NOT THROW AWAY/DISCARD THE GREEN DOCUMENT OR LETTER B. SAVE FOR LATER. 3. You will choose Option 2 for the assignments on page 11. 4. Record each transaction in chronological date sequence. Any accounting entry will be done in the appropriate journals. a. HINT: i. You will have at minimum a Sales Journal, Purchases Journal, Cash Receipts Journal, Cash Disbursements Journal, and Payroll Journal. ii. Journals are for the entire month of December. You will have to rebuild the journals at December 1st. The transactions list Option A starts at December 18th. Refer to Document No. 9 and Document No. 24 to see prior transactions for the month December. iii. I have prepared a Journal Samples Microsoft Excel Spreadsheet. Please use this to enter transactions. This is not a complete set. You will also have two subsidiary accounts for Accounts Payable and Accounts Receivable. Categorize these sub accounts based on vendor name and customer name respectively. b. You will need to prepare a General Ledger categorized by each GL number. i. Please refer to pages 25-29 for beginning balances and columns. c. Journals must be completed using Microsoft Excel or Green Bar paper. (I prefer Excel). i. Each journal should be a separate sheet in the same file. ii. HINT: You may want to print all the journals first so that you can see all the transactions at once. Once complete, you can enter them into Excel. 5. Follow the seven step process for recording a transaction. SUA – Part B Assignment 1. Go to page 5 of the “Blue” Document 1 Transactions List a. Complete year – end procedures 2. Go to page 14 of the SUA – Instructions, Flowcharts, and Ledgers book a. Complete the following procedures i. Item #1 & #2 3. Complete item #3 on page 15 – prepare a trial balance worksheet – see page 18 for reference or Excel projects 1 & 2 as a reference. a. Adjustments and journals to the adjustments should be recorded similar to Excel projects 1 & 2. b. Item # 7 – adjusting entries should also be entered in trial balance worksheet. 4. Complete item #4 on page 15 – calculate federal income tax 5. Complete #5 on page 15 – prepare an income statement, balance sheet, and statement of retained earnings. Do NOT complete a Cash flow statement. 6. Complete #7 on page 15 – adjusting entries from general journal to general ledger. NOTE – item #6 is not required. NOTE – items #3 thru #5 should be completed on an Excel spreadsheet and uploaded in Blackboard. NOTE – Item #7 can either be completed on an Excel spreadsheet and uploaded in Blackboard or completed on paper. Sales Journal: December Debit Date 1-Dec Customer Rosemont University Monthly Totals Credit Inv. Or Cr. Sales Memo Subs Acct.