- 30 Marks
AA – L2 – Q67 – Internal Control Systems
Question
Bertram Co
Bertram Co assembles fridges, microwaves, washing machines and other domestic appliances from parts procured from a large number of suppliers. As part of the interim audit work two weeks prior to the company year-end, you are testing the procurement and purchases systems and attending the inventory count.
Procurement and purchases system
Parts inventory is monitored by the stores manager. When the quantity of a particular part falls below re-order level, an e-mail is sent to the procurement department detailing the part required and the quantity to order. A copy of the e-mail is filed on the store manager’s computer.
Staff in the procurement department check the e-mail, allocate the order to an authorised supplier and send the order to that supplier using Electronic Data Interchange (EDI). A copy of the EDI order is filed in the order database by the computer system. The order is identified by a unique order number.
When goods are received at Bertram, the stores clerk confirms that the inventory agrees to the delivery note and checks the order database to ensure that the inventory were in fact ordered by Bertram. (Delivery is refused where goods do not have a delivery note.)
The order in the order database is updated to confirm receipt of goods, and the perpetual inventory system updated to show the receipt of inventory. The physical goods are added to the parts store and the paper delivery note is stamped with the order number and is filed in the goods inwards department.
The supplier sends a purchase invoice to Bertram using EDI; invoices are automatically routed to the accounts department. On receipt of the invoice, the accounts clerk checks the order database, matches the invoice details with the database and updates the database to confirm receipt of invoice. The invoice is added to the purchases database, where the purchase day book (PDB) and suppliers individual account in the payables ledger are automatically updated.
Required:
(a) List SIX audit procedures that an auditor would normally carry out on the purchases system at Bertram Co, explaining the reason for each procedure.
(b) List FOUR audit procedures that an auditor will normally perform prior to attending the client’s premises on the day of the inventory count.
(c) On the day of the inventory count, you attended depot nine at Bertram. You observed the following activities:
- Pre-numbered count sheets were being issued to client’s staff carrying out the count. The count sheets showed the inventory ledger balances for checking against physical inventory.
- All count staff were drawn from the inventory warehouse and were counting in teams of two.
- Three counting teams were allocated to each area of the stores to count, although the teams were allowed to decide which pair of staff counted which inventory within each area. Staff were warned that they had to remember which inventory had been counted.
- Information was recorded on the count sheets in pencil so amendments could be made easily as required.
- Any inventory not located on the pre-numbered inventory sheets was recorded on separate inventory sheets – which were numbered by staff as they were used.
- At the end of the count, all count sheets were collected and the numeric sequence of the sheets checked; the sheets were not signed.
Required:
(i) List the deficiencies in the control system for counting inventory at depot nine.
(ii) For each deficiency, explain why it is a deficiency and state how that deficiency can be overcome.
(d) (i) State the aim of a test of control and the aim of a substantive procedure.
(ii) In respect of your attendance at Bertram Co’s inventory count, state one test of control and one substantive procedure that you should perform.
Answer
| Procedure | Reason for procedure |
|---|---|
| Obtain a sample of e-mails from the store manager’s computer. Trace details to the order database. | Ensure that all orders are recorded and that the order details are correct. |
| Obtain a sample of orders in the order database, record details of the order, and trace to the paper delivery note filed in the goods inwards department. | To confirm that all goods ordered were received. |
| For the sample of orders above, agree to the inventory database. | To confirm that goods received were completely and accurately recorded in the inventory database. |
| Obtain a sample of paper delivery notes and agree to the order database and inventory database. | To confirm that inventory received has been recorded in Apex’s accounting system and that liabilities are therefore not understated. |
| For a sample of orders in the orders database, agree details to the payables ledger database, confirming details against the purchase invoice. | To confirm complete and accurate recording of the inventory liability in the payables database. Note: To ensure goods received have been recorded as a payables liability, the sample selected from the order database should be only those orders that have been received. The invoice number in the order database is then noted and traced to the payables ledger in the purchase database. |
| Within the purchase database, obtain a sample of invoices recorded in the purchase day book, agree details of price and supplier to the purchase invoice record in the database. | To confirm that purchase invoice details have been correctly recorded in the payables database. |
(B)
- Review the client’s inventory count instructions to ensure they are adequate and appropriate.
- Confirm the date, time, and location of the inventory count with the client.
- Obtain a copy of the inventory ledger to prepare for reconciling physical counts.
- Assess the competence and independence of the client’s staff performing the count.
(C)
(i) Deficiencies
- Recording information on the count sheets in pencil.
- Count sheets for inventory not on the pre-numbered count sheets were only numbered when used.
(ii) Explanation and Resolution
| Deficiencies | Reason for deficiencies | How to overcome deficiencies |
|---|---|---|
| Recording information on the count sheets in pencil | Recording in pencil means that the count sheets could be amended after the count has taken place, not just during the count. The inventory balances will then be incorrectly recorded. | Count sheets should be completed in ink. |
| Count sheets for inventory not on the pre-numbered count sheets were only numbered when used | It is possible that the additional inventory sheets could be lost as there is no overall control of the sheets actually being used. Sheets may not be numbered by the teams, again giving rise to the possibility of loss. | All inventory sheets, including those for ‘extra’ inventory, should be pre-numbered. |
(D)
(i) Aims
The aim of a test of control is to check that an audit client’s system of internal control is operating effectively.
The aim of a substantive procedure is to ensure that there are no material misstatements at the assertion level in the client’s financial statements.
(ii) Regarding the inventory count
Test of control
Observe the count teams ensuring that they are counting in accordance with the client’s inventory count instructions.
Substantive procedure
Record the condition of items of inventory to ensure that the valuation of those items is correct on the final inventory summaries.
- Tags: Audit Evidence, Audit Procedures, Internal controls, Procurement System, Purchases System
- Level: Level 2
- Topic: Audit Procedures
- Uploader: Samuel Duah