Advance Level

Additional Contents of Advance Level Training

In the Fundamental level training candidates gain knowledge uptill quarterly accounts & submission of VAT to HMRC.In addition to tasks completed in Fundamental level, candidates have the opportunity to cover the following in Intermediate level training.

• Internal control procedures for tangible fixed assets and cash
• Reconciliation of Control Accounts (Debtors and Creditors Control, VAT, PAYE, Wages, Directors, Bank Loans, Suspense Accounts – etc.
• Posting adjusting journal entries at month end such as Accruals,
• Prepayments,
• Depreciations, calculating depreciation using different methods VAT
• Intercompany transactions and reconciliations
• Using a Computerised accounting package of your choice. Preparing closing entries
• Preparing the Final Trial Balance
• Producing a classified profit & Loss account and Balance sheet in a Excel spreadsheet
• Dealing with HMRC queries and small tax matters
• Summaries and analyses financial data and produce reports for management purposes
• Monthly, Quarterly Management Accounts Performing banks reconciliation
• Learning about VAT management
• Running the year end procedure in Sage line 50 Accounts to close the financial year and start a new financial year
• This training package is everything you need to demonstrate your competency for the following roles:
• Finance manager Financial Accountant Management Accountant
• Accounts payable manager Credit controller
• Small business Performance Analyst

Additional Content

• SAGE CISKBM TR is proud to present specialized courses in Construction Industrial Scheme. Be a part of professional network and make your CV stand out with quality training.
• Understanding what is Construction Industry Scheme
• How to register for CIS scheme Familiarization of the CIS rules and legislation
• Different types of CIS Sage CIS activation wizard
• Completing Company preferences Setting up default Nominal codes for CIS Setting up Subcontractors records Setting up CIS tabs
• Verify Subcontractors with different methods manually and with the use of Sage 50 CIS.
• Record work that has been completed by your subcontractors, including any materials used and tax deductions that apply.
• Entering Subcontractor Invoices/ credit notes
• Processing Subcontractor payments and deductions
• Generate your CIS monthly return
• Submitting your CIS monthly returns to HMRC
• Generate a monthly statement of tax deductions to give to your subcontractors.
• Generate your Subcontractor analysis report on monthly and Subcontractor basis
• Control who can view, create and change your subcontractor records with access Rights and passwords.
• Ensure you comply with CIS rules and minimize the possibility of incurring penalties from HM Revenue & Customs (HMRC).
• Store your records ready for an audit by HMRC.
• Sage CIS Contractor Returns
• Generating CIS Statements Update on CIS Rules
• Types of CIS

INCOME TAX - PART 1

In order to equip candidates with the knowledge of income tax computation and tax planning we have developed our income tax courses, which will give candidates the necessary skills and understanding of this topic.By the end of the course with us you will learn the tax procedures as they should be applied in real life accountancy work.The training was developed in such way, that candidates will gradually perform more and more complicated calculations This makes the course suitable for anyone.This is a unique course which will in a few sessions cover the basics of UK income taxation. There will be plenty ofexercises with workings and explanations, and one to one support available too

Income Tax Course

Candidates have the opportunity to master a manual tax computation, candidates also have the opportunity to cover the following tasks:

Understand the history of the tax year Tax return submission and dates Recognise non-taxable income Compute tax liability

Understand income tax rates and apply allowances Identify the correct heading under

which main sources of income are taxed. Grossing up of savings income and dividends

Set out the structured table for computing income tax Calculate tax relief for charitable donations

Compute taxable income

Employment vs self-employment, case law

National Insurance Contribution (NIC) computations – Primary Class 1 and 2, and class 1A

PAYE codes and forms explained

Benefits in-kind principles (vouchers, cars, living accommodation, beneficial loans from employer) Tax-free employment benefits

Allowable expenses for tax purposes: Trading income taxation Adjustments of trading profits Capital expenditure versus other expenditure National Insurance Contribution Class 2 and 4 Basis of assessment for trading income Opening year rules for trading income Calculation of overlap profits and ways to relieve it Trading losses optimum use

ADVANCED EXCEL TRAINING

comprehensive training course with up to date material to practice at home and during your class. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. Whether you're looking for a beginner, intermediate or advanced Excel training program, you won't be disappointed in the end result. You will learn valuable tips and tricks to improve your excel skills. Course contents:

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