TVET NATIONAL PRACTICAL EXAMINATION SCHOOL YEAR 2022-2023

TRADE: ACCOUNTING

INTEGRATED ASSESSMENT

Modules combined (Code and Name of the module):

1. ACCAS401: Manipulating Computerized accounting software

2. ACCPB501: Preparing Budget
3. ACC PS501: Maintaining Payroll system
4. ACCPC401: Maintaining petty cash record
5. ACCAP301: Accounting principles

Integrated situation

Huye Company Ltd is a small sole trade business of purchasing and selling of

Eggplants. It is located in NGOMA Sector, HUYE District in Southern Province

(Tel +250798567000/722567000; P.O Box 102 HUYE).
Huye Company Ltd is well known for its services in Society and this attracts
clients. Nowadays Huye Company Ltd is facing serious problems related to

the use of manual accounting, lack of tools which helps to analyze the

financial prospects in advance, financial projection and challenges of

performing an effective payroll system.

Therefore, the Manager wants to solve the above said problems by using
accounting software to record financial transactions and MS office excel for

effectiveness of the business. The decision made, is to hire you as a skilled

worker who is able to help the company to perform well.

 Instructions to a candidate

1. This paper is composed by five compulsory sub-tasks

2. Calculator is allowed to be used
3. The work done must be saved on desktop.
4. Duration for activities is 4hours

SUB-Task 1. ACCOUNTING SOFTWARE

A. Below is the past provided information:

On 1st September, 2020 Starting business with RWF 6,000,000(from the business
owner)

2nd September, 2020 Receiving a loan from BPR BANK of RWF 2,000,000

8th September, 2020 Buying premises for RWF 200,000 and paying rent for RWF
60,000 (both by cheque.)

10th September, 2020 Purchasing goods on credit from Jackson for RWF 500,000

11th September, 2020 Selling goods on credit to Gahunde for RWF 700,000 (cost of
goods sold RWF 360,000)

12th September, 2020 Receiving cash from Gahunde (full payment of his debt)

Considering above transactions execute adequately the following tasks using

accounting software.

 Create your own chart of accounts and SP Chart

 Create the journal codes you need for recording
 Record the above transactions in the appropriate journal
 Show the trial balance
 Show the income statement
 Show the balance sheet
SUB-Task 2: PREPARING BUDGET

Using Ms EXCEL, the company is requesting you as specialist to assist in

preparation of the cash budget for the period of 1stMay to 31stJULY, 2021 from
the following information:
Month, 2018 Sales in RWF Purchases in RWF

Mach 6,400,000 4,200,000

April 6,000,000 4,000,0003

May 6,800,000 3,600,000

June 8,000, 000 4000,000

July 6,400,000 3,600,000

The following additional information is available:

i. Cash in hand at the end of April,2021 will be RWF 2000,000 ii. 50% of sales
proceeds are received in the current month, 30% in the following month and
the balance is received two months after sale. iii. Suppliers are paid one
month after delivery of goods.
iv. Corporation tax for 2021 amounts to RWF 80,000 will be paid on
31/3/2021.
v. The shareholders at their last extraordinary general meeting increase
the share capital
By RWF 280,000 and the first call of RWF 160,000 will be received on
30th June 2021.
vi. Delivery van amount to RWF 100,000 will be paid on in July, 2021.
vii. In August, 2021, the Company is due to receive RWF 40,000 as interest
of money lent.
viii. The monthly operating expenses amounts to RWF 332,000 include
factory depreciation charge of RWF 36,000 and preliminary expenses of
RWF 21,000.
 SUB-Task 3: MAINTAIN PAYROLL SYSTEM

As a qualified accountant, Using Ms EXCEL you are requested to assist the

Company to maintain Payroll for the month of of July, 2020. The payment is
made through UNGUKA bank

The following information is available:

S/N Names Basic House Communicatio Transport
Account salary(R allowances n Allowances allowances
Number WF)
(RWF) (RWF) (RWF)

01 Manzi 00505 400,000 200,000 90,000 200,500

02 Kwizera 00516 200,000 70,000 80,000 110,000

03 Ganza 00517 140,000 70,000 35,000 100,000

Additional information

- PAYE is deducted according to Rwandan Labor Law

- Medical Insurance scheme is deducted by 7.5% on basic salary
- RSSB Pension is deducted by 3% on the gross salary less transport
allowance.
- Maternity leave contribution of 0.3% on gross salary less transport
allowance.

Execute adequately the following tasks:

1. Establish the payroll requirement

2. Process the payroll
3. Record all information related to the payroll prepared
 SUB-Task4.MAINTAINING PETTY CASH BOOK

Using Ms Excel, the company is requesting you as specialist to assist in

preparation of petty cash book for the month of May 2021. For the following
information.on 1st May ,2021, a cheque issued with of Rwf 30 800 to be spent
on minor expenses the following transactions took place
May 2nd Paid transport Rwf 1 550; postage Rwf 2 200
May 4th Paid transport Rwf 3,300;
May 5th Paid stationery expenses Rwf 1,200.

SUB-TASK5: PREPARE A CASH FLOW STATEMENT

Using MS EXCEL, the company is requesting you as specialist to assist for

preparing cash flow statement of three month April, May and June ,2021. For
Information the following.
Details April (rwf) May(rwf) June(rwf)
Cash bal b/f 10,000 14,100 12,700
Sales for period 5,000 5000 6000
Salary and wages 800 800 900
Rent income 1,000 1,000 2,000
Purchases cost 6,000 6,000 6,000
Interest paid 5,000 5,000 6,000
Receipts from
0 3,500 3,000
debtors
 MATERIALS Reusable materials

SN Item Technical Unit Quantity Unit price Total cost

specifications (Rwf) (Rwf)

1. Pens Bic Piece 4 200 800

2. Stapling DUX (DS _15) Piece 1 7,000 7,000

machine

3. Scientific KENKO Piece 3 2,000 6,000

Calculator

Consumable materials
SN Item Technical Unit Quantit Unit price Total price
specifications y
1 Staples Any type Piece 5 0.8 rwf 4 rwf

2 Power Electricity KWH 0.25 935 rwf 233rwf

Total 237 Rwf

Tools First Choice Tools

SN Item Technical Specifications Unit Quantity
1 Stapling machines Any type Piece 1
3 Pen Any types Piece 1
2 Calculators Scientific Piece 3
3 External disk Removable disk Piece 1

Alternatives Tools
SN Item Technical Unit Quantity First choice that it
Specifications can replace
1 Calculators Any type Piece 3 Scientific calculator
2 Flash disk Removable disk Piece 1 External disk
 Equipment First Choice Equipment
SN Item Technical Unit Quantity
Specifications
1 Computers Desktop Piece 3
2 Tables Any type Piece 4
3 Chairs Any type Piece 6
4 UPS Any type Piece 3
5 Stapling machines Any type Piece 1

Alternatives equipment
Technical First choice that it can
SN Item Unit Quantity
specifications replace
1 Desk Any type 1 1 Table and chair
2 Computer Lap top 1 1 Computer desk top

CHECKLIST
Criteria Indicators and Elements of verification Score

Yes No (N)
(Y)
Indicator 1: The company is well created

1. Company name is indicated.

1.Quality of
process 2. Company name is saved on desktop
(20%)
3. Company address is filled

Indicator 2 : Chart of account are well created

1. Bank account
2. Capital account

3. Loan account

4. Office equipment account

5. Rent account

6. Purchases account

7. Creditors account

Indicator 3: Journal code is well created.

1. Purchase journal is created

2. General journal is created

3. All necessary accounts are created

4. wage account is created

Indicator 4: transactions recording is well done

1. Capital account is credited and Bank/cash account is

debited with correct amount

2. wage account is debited and Bank account is credited

with correct amount

3. SOP (Sales order processing) is done

4. POP (Purchase order processing) is done

5. VAT Exclude for POP transaction is done

Indicators and Elements of verification of Cash budget

Indicator 1: Format of cash budget is respected

1. Heading is shown

2. Type of budget is indicated

3. Budget period covered is indicated

Indicator 2: Cash budget preparation process is

respected

1. Total receipt is indicated

2. Total payment is indicated

3. Closing balance is determined

Indicators and Elements of verification of payroll

Indicator 1: Format is well respected

1. Name of the company is mentioned

2. Title of the document is indicated

3. Month of the payment is indicated

4. Personal identification is indicated (names, account number ,bank )
Indicator 2: Gross salary is well indicated

1. Basic salary is indicated

2. Allowances are indicated

3. Basic salary is added to allowances for gross salary

Indicator 3: Net salary is well indicated

1. PAYE is indicated

2. Social Security Fund contribution is indicated

3. National Health Insurance (Medical Insurance) is

indicated

4. Maternity leave contribution is indicated

5. Total deductions are indicated

Indicators and Elements of verification of Petty Cash book

Indicator 1: Format of petty cash is respected

1. Heading is shown

2. Type of expenses (Analysis Columns) is indicated

3. Petty cash book period covered is indicated

Indicator 2: petty Cash book preparation process is

respected

1. Total receipt is indicated

2. Total cash payment is indicated

3. Closing balance is determined

Indicator 3: Transaction recording is well done

1. Balance b/f
 2. Transport

3. Postage

4. Stationaries

Indicators and Elements of verification of Cash flow statement

Indicator 1: Format of cash flow is respected

1. Heading is shown

2. Cash flow period covered is indicated

Indicator 2: Cash flow preparation process is

respected

1. Total Cash inflow is indicated

2. Total Cash out flow is indicated

3. Closing cash balance is determined

Criteria Indicators and Elements of verification Score

Yes No (N)
(Y)

Indicator 1: Financial statements are available

2. Quality of
1. Trial balance is well presented
product
(60%)
2. Income statement is well presented

3. Balance sheet is well presented

Indicators and Elements of verification of Cash Budget

Indicator 1: Budget is well presented

1. Opening balance is well mentioned

 2. Receipts from sales are well determined

3. Receipts from share capital are well calculated

4. Other receipts are well presented

Indicator 2.Total payment is well calculated

1. Payment to creditors /suppliers is correctly calculated

2. Operating expenses are properly calculated

3. Corporation tax is well shown

4. Others payments are well shown

Indicator 3: Balance for the period is well determined

1. Closing balance is well calculated

Indicators and Elements of verification of Payroll

Indicator 1: Payroll is correctly prepared

1. Basic salary is well calculated

2. Gross salary is well calculated

3. Net salary is well calculated

Indicator 2 :Payroll journal is well prepared

1. Gross salary is debited with correct amount

2. PAYE is credited with correct amount

3. Social Security Fund contribution is credited with

correct amount
 4. National Health Insurance is credited with correct
amount

5. Maternity leave contribution is credited with correct

amount

6. Net salary is credited with the correct amount

7. Payroll journal is balanced on both sides

Indicators and Elements of verification of Petty Cash

Indicator 1: Total cash receipt is well calculated

1. Opening cash float is well mentioned

2. Receipts from bank issued is well mentioned

Indicator 2.Total cash payment is well calculated

1. Transport

2. Postage

3. Stationary

Indicator 3.Total expenses analysis is well calculated

1. Postage &telephone expense

2. Transport expenses

3. Stationary expenses

Indicator 4: Balance for the period is well determined

1. Closing balance c/d is well calculated

2. balance b/d /reimbursement is well calculated

Indicators and Elements of verification of Cash flow statement
 Indicator 1: Total cash inflow is well calculated

1. Opening balance is well mentioned

2. Sales receipts are properly calculated

3. Receipts from debtors are well calculated

Indicator 2.Total Cash out flow is well calculated

1. Purchases are well calculated

2. Salary and wages are well calculated

Indicator 3: Balance for the period is well determined

1. Closing cash flow balance is well calculated

Criteria Indicators and Elements of verification Score

Yes No
3.
Indicator 1: instruction is respected (Y) (N)
Relevan

ce (5%) 1. The work is completed on time

2. Work is saved on desktop

Criteria Indicators and Elements of verification Score

Yes No
(Y) (N)
1) Quality of process

1. Oral Q no

quest
ions 2) Quality of product

(10% Q no

3) Relevance
Q no
Criteria Indicators and Elements of verification Score

Indicator 1: Appropriate languages are used

4. Polite language

5. Body language
2. Right
Attitu 6. No being shy in front of the panellists
des(5 Indicator 2: Commitment to the task is well observed
%)

1. Confidence

2. Self-motivation

3. Ownership

PRE-DETERMINED CONDITIONS

1. Availability of electricity and generator

2. Availability of Computer lab
3. Stabilizing machines is available
4. Printer is available
5. Software is well installed in computer
6. Fire extinguisher is available
7. Availability hand sanitizers

Oral questioning items for each criterion

Quality process

1. What is importance of using accounting software?

Answer:
 - it saves time
- timely reporting
- it helps to produce accurate report
- it leads to efficiency and effectiveness of work - it minimizes errors in reporting
process 2. What is a budget?
Answer: A budget is a plan of action in future period.

3. Provide in full words, RSSB, PAYE?

Answer: RSSB: Rwanda Social Security Board. PAYE: Pay as You Earn.

Quality of product

1. Differentiate with a petty cash from cash flow statement?

Answer

Petty cash is money to be used for small expenses while cash flow statement is
statement which show the movement of money (in and out)

2. A)Define a cash budget

B) State two parts of cash budget estimation.

Answer:

A) Cash budget is an estimate showing the amount of cash which would be available in
the future period OR Cash budget is an estimation of cash receipt and cash payment,

B) Also parts of cash budget estimation cash budget estimation are:

 cash receipt
 cash payment
3. Give any four (4) elements of a Payroll?
Answer:

Serial number , Names of the employees, Basic salary, Gross salary,

Deductions, Net salary Advances, Balance.
Relevance

1. What is the role of saving any document on computer?

Answer: -to keep information for long time

 -To save information as reference for future time

2. What is the role of time management in daily activities of business?

Answer: - it saves time

- It increases productivities of business

- It can help business to achieve short- and long-term objectives

SUMMARY OF MARKS PER CRITERION

Criteria Marks

1 Quality of Process (20%)

2 Quality of Product (60%)

3 Relevance (5%)

4 Oral questions (10%)

5 Right attitudes (5%)

Result /100