W3 Day 11 of Nana's Internship

-

Week 3 Day 11 (21 April 2025)


Activity


- Ms. Chan taught me how to key in the monthly EPF amounts into the payroll Excel file to calculate the director’s and employee’s salaries by working backward.

- Continued keying in the bank-in and bank-paid transactions for the client’s company from January to April.


Key Learning


- Learned how to use EPF amounts to calculate salaries in reverse.

- Gained practical experience working with payroll files in Excel.

- Improved understanding of monthly statutory contributions and salary breakdowns.

- Continued practicing bank-in and bank-paid transaction entries.

- Strengthened attention to detail by handling payroll and banking records.

- Enhanced Excel skills through real accounting tasks.

 

Reflection


Today, I learned a new payroll-related task from Ms. Chan. She taught me how to enter the monthly EPF amounts into the Excel payroll file and calculate the director’s and employee’s salaries by working backward. It was interesting to see how EPF figures can be used to estimate gross salary, and it helped me understand payroll from a different perspective. I also continued entering bank-in and bank-paid transactions for a client’s company from January to April. Handling both payroll and transaction data in one day sharpened my focus and improved my confidence in managing detailed records with care.


 

Popular posts from this blog

Week 1

-
Image
Week 1 (07 April - 11 April 2025) Day 1:  W1 Day 1 of Nana's Internship Day 2:  W1 Day 2 of Nana's Internship Day 3:  W1 Day 3 of Nana's Internship Day 4:  W1 Day 4 of Nana's Internship Day 5:  W1 Day 5 of Nana's Internship
Read more

W1 Day 1 of Nana's Internship

-
Image
Week 1 Day 1 (07 April 2025) Activity -  Ms. Chan, a staff member from the Accounting Department, gave a briefing about the company’s activities and the accounting job scope. - Ms. Chan also taught me how to prepare a full set of accounts for a company and assigned some tasks to me. - I keyed in the company’s payment records into the payment vouchers and supplier payment records. Key Learning - G ained an overview of the company’s operations and the role of the accounting department and learned the job scope and daily responsibilities of accounting staff. - Understood the process of preparing a full set of accounts for a company. - Acquired practical skills in using accounting tools and software. - Practiced entering payment records into payment vouchers and supplier payment records. - Better attention to detail and accuracy in financial data entry. - Learned the importance of proper documentation and record-keeping in accounting. Reflection At the beginning, I felt quite nerv...
Read more