top of page
Advanced Accounting Course
Course Content

Advanced Excel Bookkeeping Training Content

  • Creating worksheets, formatting text

  • Formulas

  • Handling rows and columns

  • Autocomplete, using styles, headers, and footers,

  • Average, max and min functions and using charts.

  • Use of IF Formula

  • Summing Techniques

  • Cell References

  • Formula Linking

  • Sumifs

  • Look up References (Vlookup, Hlookup, etc)

  • Data Validation

  • Conditional Formatting

  • Date & Time Formulas

  • Charts & Graphs

  • Creating a Pivot Table

  • Pivot Table Analysis

  • Protection & Security

  • Practical Examples


Cloud Bookkeeping - (Free Agent, Xero, QuickBooks, VT)

  • Working with cloud Bookkeeping  Program Basics

  • Chart of Accounts

  • Creating Account names, Numbers & Bank Payments

  • Bank Reconciliations

  • Generating Customers Invoices & Creating Purchase Invoices

  • Generating Product Invoices & Credit Notes

  • Compiling & Sending Customer Statements

  • Creating Customer Receipts & sales receipts & record

  • Supplier Payments

  • Managing Recurring Entries

  • Analysis of accounts payable and receivables

  • Generating Reports & Information

  • The Active Set-Up Wizard

  • VAT reports

  • Auto Bank feeds

  • Practical Examples



  • Preparation and Submission

  • Understanding VAT Basics

  • Registration & Deregistration

  • VAT Scheme

  • Cash vs Accrual methods

  • Manual VAT computation

  • The VAT on BBK software

  • Reconciliation of VAT

  • Completing a VAT return

  • Understanding VAT late claim adjustments

  • VAT on Imports

  • Introduction of Partial Exemption

  • Introduction of MOSS/ECSL

  • Submission of VAT Return to HMRC

  • MTD (Making Tax Digital)

  • Understanding the procedure for payment and administration of VAT

  • Practical Examples


 Company Accounts and Corporation Tax returns

  • Introduction to Company Accounts (Companies House)

  • Confirmation statement(company information)

  • Review of Bookkeeping

  • Reconciliations

  • Control Accounts

  • Year-End Journals

  • ETB

  • Prepare year-end Lead Schedules (Working papers)

  • Preparing Balance Sheet & P&L of Small Companies

  • Accounts production software

  • Corporation Tax return

  • Loan to Participants

  • Filing Company accounts procedure

  • Company house forms and correspondences

  • Producing draft and final financial statements

  • Understanding of iXBRL requirements

  • Making Abbreviated accounts of the company

  • Tax administration for companies

  • Practical Examples


 Personal Tax Return Training Content

  • Basics of Self-assessment

  • Introduction to income tax computation

  • Personal Allowances

  • Sole trader/ rental accounts

  • Simple tax strategies

  • Taxes rates on a variety of income streams

  • Allowable expenses

  • CGT

  • Introduction to sideway relief

  • Tax relief for pension contribution

  • Child tax credit and Child benefits

  • Introduction to UTR and NI Classes

  • Tax Return submission procedures to HMRC

  • Tax return software

  • HMRC overviews, and SA302s

  • Tax administration for Individuals

  • Practical Examples



  • Introduction to payroll

  • PAYE registration

  • Employee records (starters)

  • Real Time Information (RTI)

  • Payroll frequencies (weekly vs Monthly etc.)

  • Timesheets, national minimum wage and pay rate calculations

  • Gross Pay calculations

  • PAYE,  NI Ers, and Ni Eee

  • Payslips

  • Net pay summaries

  • Voluntary deductions

  • Holiday, Sick and maternity pay

  • Communicating with Employers

  • Processing Leavers (P45)

  • Auto Enrolment (Pension)

  • Creating Backups and Restoring data

  • Year End Procedures (P60s)

  • Payroll Corrections

  • Practical Examples



Course Overview

This course covers all elements of bookkeeping and accounting, as well as introducing the principles of computerised bookkeeping and basic costing. It’s comprehensive in its content and has been created to build the bridge between the theoretical and practical aspects of tax and accountancy.


You will cover numerous modules relating to all disciplines of tax and accounting, as well as the technical aspects of computerised payroll and accounting. All of these modules are consolidated after completion with an exciting opportunity to get your foot in the door of the lucrative accounting, tax and payroll sector.

Who is it for?

This course is intended for anyone who is either about to launch a new career in accountancy or who has recently done so. Whether a part qualified student or a newly qualified graduate with little or no job experience, you stand to benefit enormously from a professional standpoint by taking this training. Even those who are either already working in the industry or thinking of opening an accountancy, tax or payroll practice can gain an awful lot by enhancing their tax and accounting knowledge

Accounting CPD Courses

Completion of this training is rewarded with valuable verified CPD points, which are key to retaining accounting membership and remaining compliant with the requirements of professional accounting bodies, such as ACCA, AAT, CIMA, ICAEW etc. Our CPD training for accountants is exclusively designed for ACCA CPD courses, in addition to CPD courses for other accounting bodies, such as AAT, CIMA, ICAEW et al.

Course Requirements

There are no formal entry requirements for this course, however, we expect candidates to have a basic knowledge of accountancy.

What support is available?
  • Free course materials 

  • Small classes of up to 10 students

  • Tutorial support

  • CV writing 

  • Interviewing technique

  • Guaranteed  Job Placement


Training Period

12 Weeks, once a week, 3 hours a day (Morning/Evening/Weekend) 


Accounting Work Experience

12 Weeks, once a week,  one day per week (9am to 5pm) 


When can you start?

It’s possible to start your course at any time of the year, with training taking place once a week. Upon completion of your training modules, you are then able to begin the job placement phase.


Course Fees





Request Course Information

Thanks for submitting!

bottom of page