PART B EXCEL PRACTICAL

Question 3

You have been posted to a new start-up company, Healthline Company Limited in Accra. The owner of the business, a foreigner has asked that payroll and tax deductions should be done professionally from day one of the company. As an Account Officer, Trained in UPSA, he has given you these information to prepare a payroll for his consideration.

Name of Staff	SSNIT Numbers	Basic Salary	Allowances
Charles Nkumsah	FK000197812	1,950.00	450.00
Mabel Ackom	BC000142594	3,650.00	300.00
Efia Pokuaa	EF000732596	4,963.00	0.00
Martin Chris	MS000187613	5,746.00	0.00
Robert Sey	KN781714631	20,140.00	750.00
Kofi Nkrabea	NE784441361	11,860.00	0.00

Kofi Nkrabea and Efia Pokua will have pending monthly staff deductions of GHS960 and GHS720 respectively for their accommodation.

Note: Assume a Flat Pay As You Earn tax of 15% for other staff and 22% for Robert Sey and Kofi Nkrabea

Required:

You are required to prepare a payroll based on Ghanas Tax Laws for the consideration of the investors. (10 Marks)

PART C - TALLY ACCOUNTING SOFTWARE QUESTIONS

Answer All Questions from this Section

Section 1

Outline the processes of generating/viewing the following reports from Tally Accounting Software

i. Bank Book

ii. Purchase Register

iii. Journal Register

iv. Debit Note Register

v. Receivables Ledger

(1 mark for each process for a total of 5 Marks)

Section 2

Indicate the ledgers, vouchers and the double entry processes of entering the following transactions in Tally Accounting Software

i. Nana Kwame started Universal Solutions Business Limited with his personal cash of GHS60,000.00

ii. Universal Solutions Business Limited opened a current account with GCB Bank Limited with GHS40,000 cash

iii. Universal Solutions Limited paid for an office rent with GHS12,000 with a cheque

iv. Universal Solutions Limited bought office Furniture for GHS6,000, Computers for GHS12,000 and Office Equipment for GHS3,000 on credit from CompuGhana Ltd

v. Universal Solutions Limited received consultancy fees of GHS50,000 cheque from a client

(2 marks for each question for a total of 10 marks)

Section 3

Outline the processes of creating the following Masters Information in the Tally Accounting Software

i. Units of Measure

ii. New Company in Tally

iii. Stock Items

iv. Motor Vehicles

v. Share Capital

(1 mark for each process for a total of 5 marks) (5 marks)

Section 4

i. Which option is used in Tally to make changes in created company?

ii. Which option is used in Tally Accounting Software to copy a companys information unto pen drives or CDs?

iii. Which shortcut key is used to take print of any report in Tally?

iv. Which option is used in Tally Software to move from one company to another when more than one company are opened?

v. Which shortcut key is used to view configuration in Tally Accounting Software?

vi. Which menu is used to create new ledgers, groups and vouchers in Tally Accounting Software?

vii. Which option is used to view list of primary and secondary groups in Tally Accounting Software?

viii. Which shortcut key (s) are used to enter a stock journal in Tally Accounting Software?

ix. Which option is used to view Stock Items or Group Summary in Tally Accounting Software?

x. Which voucher do we use to create credit purchases of Furniture in Tally Accounting Software?

(1 mark for each question for a total of 10 marks)