Accounting for Payroll with the help of Excel

This new one-day course explains your organisation’s accounting function and
how this can help you in your monthly balancing routines and raise your profile
in the organisation.

Is this course for you?
If you are involved with posting payroll information to the accounting ledgers,
balancing the monthly payroll or require an introduction to your organisation’s
accounting function then this course is ideal.

To ensure that you derive maximum benefit from this course you will need to be
conversant with Excel to an intermediate level. Therefore this course would be useful for those who have previously attended the Excel as a Payroll Tool – Intermediate and Advanced levels half day courses.

This course will enable you to:
• Reconcile your payroll data more efficiently using Excel and so save you valuable time
  and enhance your understanding of financial data and so make it work better for you
• Ask the right questions and make more informed decisions
• Contribute more to the business, thereby raising your profile
• Enhance existing systems

The Benefits of attending this course
Worked examples that make the course fun and bring the issues to life, with
all-inclusive notes, which contain detailed screen images and explanations.
Practical exercises are provided during the course and you will be able to raise
queries direct with the tutor.

You will receive a CD-ROM of all the examples & pro forma’s for you to use on
return to the office.

What does the course cover?
• The operation of the Main Functions within a Finance Department, such as
  Financial Accounts
• How Double-entry Book-keeping is used to create the essential elements of an
  accounting system
• How each of these is reconciled with each other and with the payroll department
• The creation & interpretation of the Primary Financial Reports: Profit & Loss Account,
  Balance Sheet & Cash Flow
• An explanation of Ratio analysis and how to get the most from it, including such terms
  as Staff turnover, Return on Staff Employed and Break-even analysis
• The Business Cycle, Budgeting and Decision-Making, including terms such as Payback
  and Net Present Value (NPV). By understanding these terms your importance within your
  organisation will grow
• Financial Controls, including controls to prevent the incorrect payment of employees
• How Excel can help save you time with your daily tasks and produce enhanced
  financial reports.

You will receive hands on training in the ways in which Excel can help.

Back to overview