top of page

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

  • Facebook Clean

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

 

bottom of page