Computerised Financial Systems N5 — Document
June 2018 — N5 — Computerised Financial Systems
N5
2018
Nated Business
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
48
This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1— Section header —
Q2— Section header —
Q3— Section header —
Q4— Section header —
Q5— Section header —
Q1— Section header —
21.67Average Paarl Individual with an ID Permanent Weekly Electronic transfer 0020 Capitec Paarl Current Account
21.67Average Paarl Individu al with an ID Permanent STATUTORY Medical Aid Beneficiaries Tax credit frequencies
1.1INSTRUCTIONS
1.1.4Capture the employee infor mation of MARTIN and GOLDING. Capture the leave balances and leave entitlements for each employee. Capture the banking details of each employee. Process the payslips for March.
1.2THE FOLLOWING PRINTOUTS MUST BE HANDED IN:
1.2.1Payslips fo ALL FOUR employees. Payslips for period 1 Mr Africa Ms Simikalo Mr Martin Payslip for period 2
1.2.2Writ ten warning for Mr Martin. (2\
1.2.3Employee Master file for Mr Martin and Mr Golding with personal and payment details. (6\
1.3EMPLOYEE INFORMATION CODE PROFILE SURNAME TITLE FIRST NAME DATE STARTED DATE OF BIRTH ID NUMBER
1.4PAY FREQUENCY AND PAY METHOD PAY FREQUENCY PAYMENT METHOD Monthly Electronic Transfer Weekly Electronic T ransfer (6030
1.5RATES HOURS PER DAY HOURS PER WEEK DAYS PER MONTH 40
21.6740
1.6TAX/STATUTORY TAX METHOD TAX OFFICE NATURE OF PERSON TYPE OF EMPLOYMENT Average Cape Town Normal employee with
1.7LEAVE Capture the following leave entitlement, as w ell as opening balances MARTIN Annual leave entitlement Opening alance for annual leave
1.8CAPTURE THE BANKING DETAILS OF EACH EMPLOYEE MARTIN BRANCH CODE 0030 BANK ABSA PAARL ACCOUNT NAME Current account ACCOUNT NUMBER
1.9PROCESSING OF PAYSLIPS EARNINGS, DEDUCTIONS AND EMPLOYEE CONTRIBUTIONS TRANSACTION CODES TO USE Use the transaction codes given in the list below. Read the following and make the required changes to the transactions in the
5.50per week for pension fund Receives R7 800 per annum for computer allowance (week 4\ eek 3 he rec eive R3 800 for workshop refund
Q2— Section header —
8.5Unemployment Insurance Fund: 1% of normal income Tax: : 25 of taxable income Medi
00.00and Ndela R10 : E mplo yer contributes same amount (6030 175 13
2.1WAGE STATEMENT 30 JUNE 2016 M ZUMA X NDELA
2.1.1Calculate the net wage of both employees for the week ending 30 June 2016. Use the example and r etype exactly as it is. (Do NOT type the row and columns\.
2.1.2Insert a column for % between column A and B. Use this column to calculate percentages for pension, UIF and tax. Use absolute cell references when calculating.
2.1.3Insert your EXAMINATION NUMBER left as well as PRINTOUT 1 ight as a footer.
2.1.4Adjust the width of column A to 32 and the row height to 25.
2.1.5Merge and centre the column heading
2.1.6Insert lines to improve the appearance of the statement.
2.1.7Displa y all amounts as currency with T WO decimals.
2.1.8Save the
Q2— Section header —
2.2FORMULAE
2.2.1Open
Q2— Section header —
2.2.2Change the footer to PRINTOUT 2.
2.2.3Adju st the column widths.
2.2.4Hide the percentage column.
2.2.5Print the spreadsheet with formulae on page ONE andscape page with row and column headings. (1 [35] (603035
Q3— Section header —
3.5Retype the table exactly as given and do the necessary calculations. Show calculations for depreciation Adjust olumn A to 32 and olumn B; C and D to 16. Format the columns to currency
Q4— Section header —
4.7Provide the stock sheet wit h a suitable heading using bold and italic s. Calculate the stock purchased or s old by using applicable formulae. Complete the purchases column by using the given purchase price per unit.
4.10Calculate quantities and amounts only where stars appear. Insert your EXAMINATION NUMBER left and P RINTOUT 4 right as a header. Save the spreadsheet as PRINTOUT 4 and print. (6030 175
Topics Identified
3
Forms of OwnershipBusiness FunctionsBusiness Plan
Mark Allocation
Total200 marks
Sections80 + 35 + 30 + 25 + 30 = 200 marks
Key Information
Contact Number0
701205048 · 0821044408
Paper information
TitleDocument
SubjectComputerised Financial Systems
LevelN5
Document typeQuestion paper
Year2018
MonthJune
Pages17
Downloads8
Examination context
Decade2010s
Years ago8y
SeasonWinter (SH)
Start dayFriday
Exam periodJune 2018
Days since exam3,053
About Computerised Financial Systems examination preparation
This TVET examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.
How to use this resource for revision
A TVET past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?
For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.
understanding question requirements
applying subject knowledge
working under time constraints
checking answers
identifying revision priorities
A practical revision approach
Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.
File details
File size411.3 KB
Pages17
Archived on8 September 2026
File age46d
ContributorFreeMode
FingerprintA0FC94C01B64
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.