subject: ACCOUNTING INFORMATION SYSTEM

QUESTION 1 EPC Computer Sdn Bhd. Is dealing with computer hardware, software and accessories. In June 2016, they purchased a Sage UBS Accounting System and wanted to computerise their accounts starting from 1 July 2019. Its financial year is from 1 January 2019 to 31 December 2019. Supposing you are the dealer who sells Sage UBS Accounting System to the company and wants to assist the accounts officer to enter the opening balances, debtors and creditors aging distribution and all the July transactions. The following are the documents supplied by the Accounts Officer. 1. Trial Balance as at 30/06/2019 2. Debtors & Creditors Aging Analysis as at 30/06/2019 3. Stock list as at 30/06/3016 and 31/07/2019 4. Sales invoices for the month of July 5. Purchases invoices for the month of July 6. Bank payment vouchers for the month of July 7. Petty cash payment vouchers for the month of July 8. Official receipts for the month of July 9. Credit note and Debit note for the month of July 10. Bank statement as at 31/07/2019 TRIAL BALANCE AS AT 30/06/2019 Account No Description Special A/C RM 1000/000 Capital 100,000 1050/000 Profit & Loss Account PA 20,000 2001/000 Motor Vehicle - JCM2986 55,000 2001/MV1 PFD - Motor Vehicle AD 5,500 2002/000 Office Equipment 15,000 2002/OE1 PFD - Office Equipment AD 1,500 3000/000 Debtors Control 35,000 3010/000 Bank - MBB 88,000 3020/000 Petty Cash 300 3030/000 Stock BS 12,500 4000/000 Creditors Control 51,000 5000/000 Sales 253,400 5010/000 Returns Inwards 3,000 6010/000 Purchases 161,000 6020/000 Returns Outwards 5,000 9010/000 Discount Allowed 15,000 9020/000 EPF Contribution (Employer) 3,100 9030/000 SOCSO Contribution (Employer) 300 9040/000 Salary 30,000 9050/000 Water & Electricity 2,000 9060/000 Petrol 1,500 9070/000 Upkeep of Motor vehicle 3,500 9080/000 Sundry Expenses 1,200 9090/000 Stationeries 2,000 9100/000 Telephone 8,000 REQUIRED: Prepare the following: 1. Profit and Loss Account for the month of July 2019 2. Trial Balance as at 31/07/2019 3. Debtors & Creditors Aging Reports As at 31/07/2019 4. Balance Sheet as at 31/07/2019 5. Bank Account as at 31/07/2019 6. Base on the above Bank Account and the Bank Statement enclosed, please include the Bank Reconciliation Statement. (TOTAL: 50 MARKS)