Accounting Information Systems Assignment -
Case Study - Pete's Pedals
Required:
Part A: Manual recording
1. Record the opening balances as at 1 April 2018 in the general journal and appropriate general ledger accounts and the opening balances of accounts receivable, accounts payable and inventory in the appropriate subsidiary ledgers.
2. Record the transactions in the appropriate general or special journal for April 2018. Post all transactions from journals to the general ledger in accordance with accounting procedures.
3. Prepare schedules of accounts receivable, accounts payable and inventory as at 30 April 2018 and reconcile these with the control accounts in the general ledger.
4. Record end of month adjustments in the general journal and post these to the general ledger.
5. Prepare a bank reconciliation as at 30 April 2018.
6. Prepare a Trial Balance before and after end of month adjustments as at 30 April 2018.
7. Prepare an Income Statement for April 2018 and a Balance Sheet as at 30 April 2018.
8. Prepare closing entries for April 2018.
9. Prepare a Trial Balance after closing entries for April 2018.
Transactions must be recorded in the excel work book which includes pro-forma journals, ledgers, worksheets and reports available in the assessment folder.
Part B - Computerised accounts using MYOB
1. Set up a data file for Pete's Pedals and process the transactions for April 2018.
2. The Easy Setup Assistant can be used for the initial setup process to:
- Prepare the Chart of Accounts
- Enter the opening balances in the general ledger
- Setup customer and supplier cards and enter opening balances in the specialist modules
The Command Center can be used to create inventory items and enter opening balances of inventory
3. Record the transactions for April 2018.
4. Prepare a bank reconciliation statement as at 30 April 2018.
5. Record end of month adjustments.
Need to complete Manual Accounting Part.
Attachment:- Assignment Files.rar