ACCOUNTING.TAX.AUDIT.TRAINING

STAND OUT FROM THE CROWD

 ACCOUNTING SESSIONS  QUICKBOOKS/SAGE/TALLY

SESSION ONE  

• Overview of QB
• Setting up the Company Profile
• Chart of accounts
• Raising Tax invoices for customers
• Raising Tax invoices for suppliers
• Setting up VAT accounts

SESSION  TWO

• Receive and Make payments against raised Invoices
• Setting up controls account
• Posting withholding taxes for VAT & Income tax
• Posting Deferred Tax

SESSION  THREE

• Account payable reconciliation
• Account Receivable reconciliation
• Credit note

SESSION  FOUR

• Posting of depreciation
• Payroll Management
• Bank reconciliation

SESSION  FIVE

• Closing Entries, including accruals
• General Audit check of accounts

SESSION  SIX

• Preparation of Management Accounts

 

 

                TAX COMPUTATION AND FILLING  SESSIONS

SESSION ONE  

• Overview of Itax
• Pin Registration
• Nil Return

SESSION  TWO

• PAYE
• Advance Tax
• Installment Tax

SESSION  THREE

• VAT
• Withholding tax

SESSION  FOUR

• Income tax individuals
• Income tax corporate

SESSION  FIVE

• Generating certificates
• Payment slips

 

 

PRACTICAL APPLICATION OF ADVANCED EXCEL SESSIONS

SESSION ONE  

• Extensive exercise on Excel shortcuts
• Cell formatting
• Conditional formatting
• Sorting and Filtering data
• Advanced filter criteria
• Sub totaling.

SESSION  TWO

• Dates formats
• Logical Functions
• VLOOKUP & HLOOKUP
• XLOOKUP

SESSION  THREE

• INDEX & MATCH
• SUMPRODUCT Function.
• SUMIF & sumifs

SESSION  FOUR

• Analyzing and generating reports of large data using PivotTables
• Using Slicers in Pivot Table
• Data Validations and Protection

SESSION  FIVE

• Reconciled Bank with Excel formulas
• Reconciled VAT on I tax and Ledger
• Develop a stock management system
• Develop payroll, PAYE, CSV, P10, P9
• General Automation of Excel workbook
• Free Excel templates on the same
• Reconciliation of KRA Auto populated VAT return.