Training Programs

Sage 50 Accounts Training:

Setting up companies using various VAT schemes
Choosing the chart of accounts that suits the firm's needs and its customisation
Understanding how double entry is applied in accounting software and how to customise the nominal ledger and nominal codes
Maintaining sales and purchase ledgers of organisation
Setting up customers’ accounts
Process customers invoices and credit notes
Setting up suppliers accounts
Processing suppliers invoices and credit notes
Generating reports customer/supplier invoices, statements and reconciling them
Generating aged debtors and aged creditors reports for credit control purposes
Identifying errors and performing error corrections
Allocating cash and bank payments and receipts
Preparing the VAT return,
Reconciling the VAT return,
Submitting the VAT return to HMRC
Dealing with HMRC queries
VAT registration and deregistration process
Understanding VAT period and Tax point
VAT deadlines and penalties

Sage 50 Payroll Training:

Program and payroll basics
Backing up and restoring data
Company settings
Understanding UK legislation relating to Payroll
Registering as an employer
Understanding Pay as you earn (PAYE) system
NIC classes and rate
Income tax bands and rates
Adding employees into payroll software
Creating pay elements
Understanding year to date values
Processing payments for employees
Generating payslips
Generating pre-update reports
Departments and employee analysis
Calculating and processing statutory payments
Calculating and paying statutory sick pay (SSP)
Calculating and paying statutory maternity pay (SMP)
Calculating and paying statutory paternity pay (SPP)
Recording absences
Updating the payroll records with leavers and joiners
Payment by BACS
Yearend procedures
Printing and Issuing pay slips to employees
Real time information (RTI) reports
Full payment submission (FPS)
Employer payment summary (EPS)
Submitting PAYE to HMRC
Issuing P45 to employees when they leave
Issuing P60’s to employees at the end of each tax year

Advanced Excel Training:

Summing Techniques
IF, Cell References, Formula Linking,etc
New Formulas of Excel 2007 Sumifs, Countifs, Iferror
Database Formulas
Subtotal (Formulae & Procedure)
Tables
Macros
Look up References (Vlookup, Hlookup,etc)
Data Validation
Conditional Formatting
Date & Time Formulas
Charts & Graphs
Protection & Security
Goal Seek
Groupings
Pivot Table
Pivot Table Charts
Hyperlinks
Scenario
Hlook ups
Vlookups
Web workbooks
Sharing Workbooks