Sage Training courses
sage training program
sage training in London
sage practical training
sage payroll training

Final Accounts Training

Final accounts training is an ideal program for anyone looking to target Financial Accountant jobs. We at KBM Training & Recruitment, are constantly working hard to help candidates achieve the best quality training in accountancy along with one of the best recruitment facility in the market.

Over the past 30 years, we have helped thousands of candidates in getting the practical skills and secure the jobs in accountant sector.

Final Accounts Training duration: 12 months (416 hours)

Overview

  • Advanced Excel Techniques
  • Final Accounts Preparation
  • Corporation Tax Returns
  • Self-Assessment Tax Returns
  • CIS Tax Returns
  • Budgeting, Forecasting and Management Accounting
  • HMRC and Companies House Submissions

Software covered

  • Sage 50 Accounts
  • QuickBooks
  • Excel
  • Sage 50 Payroll
  • Xero
  • Sage Accounts Production Advanced
  • Sage Compliance

Final Accounts Preparation - Sage Accounts Production Advanced (SAPA)

You are required to have a good understanding of all the control accounts and adjusting entries

  • Initial Trail Balance and completing the final control accounts.
  • Posting client and initial trail balance on Accounts Production packages
  • Navigating your way around the Software
  • Creating a client and amending the client database
  • Posting of clients data, including current year and comparative data
  • Working paper reports including lead schedules, trial balance, general ledger and audit trail
  • Working efficiently with documents and posting of data, including "Copy Document"
  • Entering "Disclosure data"; As per FRS 102 and other relevant standards
  • Working with ROP's. Report Pads and Headings
  • Report Pad formatting - producing enhanced notes and reports
  • Producing draft and final financial statements
  • Completing and understanding the compliance as per company's house
  • Year-end process
  • Making Abbreviated accounts of the company
  • Finalizing the accounts and making the final file of the company for partner review
  • Learning how to do filing and making indexes of the company final accounts file

Corporation Tax Returns CT600

  • Understanding Corporation Tax
  • Setting up for corporation tax
  • Rates and reliefs
  • Working out TTP’s
  • Adjusting the profit figures
  • Allowable and disallowed for tax purposes
  • Treatment of qualifying charitable donations
  • Understanding and calculating Capital Allowances
  • Various pools for CA calculations
  • AIA and FYA
  • Dealing with Losses and Long Period of Accounts
  • Trading profits basis period
  • Long period of accounts
  • Filling in CT600 form
  • Paying corporation tax and filing company tax returns
  • Deadlines for paying and filing corporation tax returns

Contents of Self-Assessment

  • Sources of income under Self-Assessment (SA)
  • Relief under SA
  • Payments Concept Under SA
  • National Insurance under SA
  • How to calculate tax liability and tax due
  • The personal tax return (SA100)
  • Supplementary Returns
  • Employment Income (SA102)
  • Self-Employment (SA103)
  • Property (SA105)

Contents of CIS

  • 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

Advanced Excel

  • 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

MANAGEMENT ACCOUNTING WITH BUDGETTING AND FORCASTING: (4 days)

Management accounting course covers detailed analytical skills on Budgeting, Forecasting and Advanced Management Accounting:

Forecasting

  • Smoothing Techniques
  • Trend Analysis
  • Regression Analysis
  • Expected Values
  • Evaluating Forecasting Techniques

Departmental Analysis

  • Creating departments in Sage
  • Allocation of Invoices(Costs) to Departments
  • Generation of Departmental Profit and Loss
  • Generation of Departmental Balance sheet
  • Departmental Expense Analysis

Project Analysis

  • Creating Projects in Sage
  • Defining Resources in Sage
  • Allocation of Invoices (Sales, Purchases and Overheads to Projects)
  • Project Profitability Analysis
  • Project Cost Analysis

Product Costing

  • Creating Raw Material
  • Creating Finished Products
  • Bill of Materials To Finished Products
  • Stock Movement Within an Organization
  • Product Costing and Pricing
  • Purchasing Trends

Company Performance Analysis

  • Entering Prepared Budget in Sage
  • Budgeted and Actual Variance Analysis
  • Period Ending Wizard
  • Historical Variance Analysis
  • Quarterly Adjustments
  • Use of Fixed Asset Register

Reporting

  • Project Report
  • Product Report
  • Departmental Report
  • Company Performance Report

Business Analysis

  • Payback Period
  • NPV
  • IRR
  • Profitability Index

WHY KBM?

  • Matrix approved training with highest standards
  • Authorised and Regulated by Financial Conduct Authority – FCA
  • Firm of Chartered Certified Accountants & Registered Auditors
  • 1 – 1 training sessions in our Accountancy firm with Qualified Accountants
  • Licensed software installed on your laptop
  • Approved by AAT, Oxford Cambridge and RSA
  • 100% Practical training on real company documents
  • 100% Flexible – You choose day, time and location of your own choice
  • Multiple locations – Park Royal, Canary Wharf, Barking, Elephant & Castle, Birmingham
  • Regular performance reviews to identify learning gaps
  • Job market awareness sessions
  • Professional CV and Interview preparation
  • Guaranteed Work Placement
  • Reference to employers
  • Complete PER for ACCA / AAT / CIMA
Quick Contact