Forlan Khanombuya, a student at University of Venda studying Bachelor of Commerce in Business Information Systems. Khanombuya is a non-NSFAS beneficiary, when 2021 academic came to an end, he had a debit balance of R17 759.28 which grew further when he registers for the 2022 academic year. 2022 tuition fees are stated as R27 542,78 of which a registration fee of R5 000 is excluded. On the 17th of January, a day he registered for 2022 academic year, is a day deposited a registration fee into his student account. Three days after he deposited R4 000 upfront for his 1st semester residence, as he is not funded, he was required to pay an amount of R4 000 before he could claim a room from Housing Department. Monday 31st January, his student account was credited with R36 362.21 (an annual fee of Male residence. Khanombuya won a scholarship from Madevu film and productions worth R15 000 which was deposit to his student account. The scholarship came in handy as he only paid R4 000 on the 27th of July to keep his residence over 2nd semester. The Department of Business Information System ensured unfunded students that they will receive a grant from Dell Technologies worth R75 000 each to pay off their debts. The remaining balance will be paid off to their personal bank accounts at the end of academic year. September 09th , unfunded students accounts were credited with said amount. 

Required:

Add worksheet and draw up a student account statement of F Khanombuya with reference to the above case study.

Include columns Date, Reference, Description, Debit and Credit among others.

Note: F Khanombuya student number is 201769565. Tip: state the amount due to Univen or Student after calculating all transactions.