COURSE OUTLINE
This revolutionary program will help you solve your difficulty in completing your audits and financial reports on time. This best seller program will teach you how to save time in completing your financial and statutory reports using Excel.
Participants will have more in time analysing these reports and in providing more valuable advice to management. The session also include introductory session on Tableu, one of the leading third-party data analytics and business intelligence software.
This program is ideal for accountants and auditors, or for anyone who works on Excel.
Phases
-
Preparing chart of accounts
-
Recording opening account balances
-
Recording transactions
-
Preparing ledgers and trial balance
-
Preparing basic financial reports
-
Preparing value-added reports
Get the most from the training using Excel 2010 or 2013. This program does not support Excel in MAC computers.
____________________________________
What participants say about our program
-
"An excellent resource speaker! Looking forward to see you in the future seminars. Gained so much more particularly on pivot and vlookup" - Managing Partner of a CPA firm
-
"Excellent!" I learned that Excel is a) very useful tool indeed!"- Finance Director of a global pharmaceutical company
Session 1: Preparing chart of accounts
The objective of this session is to help you master the preparation of chart of accounts that is aligned with the reporting of basic financial information and notes to financial statements.
CASE 1: The art of grouping related accounts
CASE 2: The art of re-grouping related accounts
Session 2: Recording opening account balances
The objective of this session is to help you master forwarding the beginning account balances.
CASE 3: The art of automation
Session 3: Recording transactions
The objective of this session is to help you master the preparation of key accounting records (i.e. sales and collection, purchases and disbursements) that readily tally with certain regulatory reports (i.e. VAT, Withholding Tax).
CASE 4: The art of recording transactions
Session 4: Preparing ledgers and trial balance
The objective of this session is to help you master the preparation of general and subsidiary ledgers, including trial balance, from the key accounting records (i.e. sales, collections, purchases and disbursements).
CASE 5: The art of summarizing transactions
Session 5: Preparing basic financial reports
The objective of this session is to help you master the preparation of balance sheet, income statement & statement of cash flows.
CASE 6: The art of reporting transactions
Session 6: Preparing value-added reports
The objective of this session is to help you master the preparation of charts and other visual presentations to help drive the decision making process of the organization
CASE 7: The art of creating value-added information
CASE 8: The art of working in the cloud
Click here to read more...
-
Critical thinking
-
Internal audit delivery
Competency
-
Junior Auditors
-
Senior Auditors
-
Junior Risk Officers
-
Junior Compliance Officers
-
Accountants
-
Finance Officers
-
Budget Officers
-
Treasury personnel
-
Any Excel user
Who should attend this Seminar?
Click here to read about Mr Allan Palacio
Meet your facilitator
Follow this event
Applying CAATs in Financial Reporting Using Excel
Member only E-class room
You need to be officially enrolled in the program to gain access to our e-class room facilities.
Enroll now!
18 CPE Credits
Investment: P5,000 or $150
6-month subscription
Are you having difficulty completing your audits and financial reports on time? Worry no more.
This best seller program will teach you how to save time in completing your financial and statutory reports using Excel. Participants will have more in time analysing these reports and in providing more valuable advice to management.
Training partner
Philipine Institute of Certified Public Accountants (PICPA)
- Accelerated Financial Reporting Using Excel
In-house seminar
CIASP provides in-house training programs upon request. For any queries, please contact Pol Mirafuentes:
E: PolMirafuentes@ciasp.com.ph
T: (+63917) 837 2038