top of page
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

​

​

​

​

Course Overview

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. 

 

 

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.

There are no formal entry requirements for this course

Course duration and Fee

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

Request course information 

Thanks for submitting!

bottom of page