Bookkeeping Practical Course​
Course Content

Advanced Excel Bookkeeping Training Content

  • Creating worksheets, formatting text

  • Simple and complex 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

  • Tables and Bordering

  • Look up References (Vlookup, Hlookup, etc)

  • Data Validation

  • Conditional Formatting

  • Date & Time Formulas

  • Charts & Graphs

  • Protection & Security

  • Creating a Pivot Table

  • Pivot Table Analysis

Cloud Bookkeeping Training Content (VT, Xero, QB, Free Agent)

  • Working with cloud Bookkeeping  Program Basics

  • Creating Account names, Numbers & Bank Payments

  • Financials

  • Bank Reconciliations

  • Generating Customers Invoices

  • Products

  • Monitoring Customer Activity

  • Generating Product Invoices & Credit Notes

  • Compiling & Sending Customer Statements

  • Creating Customer Receipts & Purchase Invoices

  • Supplier Payments

  • Managing Recurring Entries

  • Generating Reports & Information

  • The Active Set-Up Wizard

  • VAT Changes

VAT Training – Preparation and Submission Training Content

  • Understanding VAT Principles

  • Analysis of different VAT Scheme

  • Preparing VAT in Spreadsheet

  • Reconciliation of VAT

  • Completing a VAT return

  • Import and Export VAT analysis

  • Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet

  • Introduction of TOMS (Tour Operator Margin Scheme)

  • Submission of VAT Return to HMRC

This accounting practical course covers Excel, all elements of bookkeeping and VAT, as well as introducing the principles of computerised bookkeeping and VAT preparation and submission. 

 

 

Course Overview

This course is intended for anyone who is either about to launch a new career in accountancy or who has recently done so.

There are no formal entry requirements for this course

Who is it for?

Training Period

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

 

 

Bookkeeping 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.

 

 

CourseFees

£995

Course duration and Fee
Request course information 
arrow&v
Contact Us

Unit A2, Gateway Tower

30 Western Gateway

London 

E16 1YL

Tel: 0207 059 0712

  • LinkedIn Social Icon