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.