Online Bookkeeping, VAT and Payroll Training

Bookkeeping, VAT and Payroll training is ideal for anyone looking to start a fresh career in the accounting sector. We have designed this training program to cover all job requirements for Bookkeeping and Payroll positions.

We are a Gold-level ACCA-approved Chartered Accountancy firm and we are constantly working hard to help candidates achieve the best quality training in accounting, along with one of the best recruitment facilities in the market. Over the past 35 years, we have helped thousands of candidates get practical skills and secure jobs in the accountant sector.

We are also a recruitment firm and we help each candidate in preparing a professional CV. We add work experience to the CV to boost employability. We arrange interviews with employers and prepare our candidates before each interview. We also provide references to potential employers to place our candidates in jobs. In 2023 we successfully placed more than 1600 candidates in accountancy jobs.

Upon completion of Bookkeeping, VAT and Payroll training you will receive a training certificate and work experience reference letter from our chartered accountancy firm.

Software covered

• Sage 50 Accounts
• QuickBooks
• Excel
• Sage 50 Payroll
• Xero

Contents of Bookkeeping and VAT (Sage 50, QuickBooks and Xero)

• Setting up companies using various VAT schemes, i.e Standard VAT Scheme, Cash Accounting Scheme, Flat Rate Scheme, Marginal VAT Scheme
• Choosing the chart of accounts and its customisation
• Understanding how double entry is applied in accounting software
• How to customise the nominal ledger and nominal codes
• Maintaining sales ledgers of businesses
• Maintaining purchase ledgers of businesses
• Setting up customers’ accounts
• Processing customers invoices and credit notes
• Setting up suppliers accounts
• Processing suppliers invoices and credit notes
• Generating reports customer/supplier invoices,
• Generating customers and suppliers statements and reconciling them
• Generating aged debtors and aged creditors reports for credit control purposes
• Identifying errors and performing error corrections
• Allocating cash payments and receipts
• Allocating bank payments and receipts
• Allocating supplier payments and customer receipts against right invoices
• Performing bank reconciliation
• Performing petty cash reconciliation
• Preparing the VAT return
• Reconciling the VAT return
• Submitting the VAT return to HMRC
• Dealing with HMRC queries
• VAT registration and deregistration process
• Understanding VAT period and Tax point
• Rules regarding Cash VAT and Flat Rate VAT scheme
• Deeper understanding of Standard VAT Scheme, Cash Accounting Scheme, Flat Rate Scheme, Marginal VAT Scheme and VAT Retail Scheme
• VAT deadlines and penalties

Contents of Payroll and HMRC Reports (Sage Payroll 50)

• Program and payroll basics
• Backing up and restoring data
• Company settings
• Understanding UK legislation relating to Payroll
• Registering as an employer
• Understanding Pay as you earn (PAYE) system
• NIC classes and rate
• Income tax bands and rates
• Adding employees into payroll software
• Creating pay elements
• Understanding year to date values
• Processing payments for employees
• Generating payslips
• Generating pre-update reports
• Departments and employee analysis
• Calculating and processing statutory payments
• Calculating and paying statutory sick pay (SSP)
• Calculating and paying statutory maternity pay (SMP)
• Calculating and paying statutory paternity pay (SPP)
• Recording absences
• Updating the payroll records with leavers and joiners
• Payment by BACS
• Yearend procedures
• Printing and Issuing pay slips to employees
• Real time information (RTI) reports
• Full payment submission (FPS)
• Employer payment summary (EPS)
• Submitting PAYE to HMRC
• Issuing P45 to employees when they leave
• Issuing P60’s to employees at the end of each tax year

Advanced Excel Training

• 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
• H-Look ups
• V-Lookups
• Web workbooks
• Sharing Workbooks

Why KBM?

• ACCA Approved at Gold level
• AAT Approved and promoted training provider
• Practical Accountancy Training Endorsed by Institute of Financial Accountants
• Firm of Chartered Certified Accountants & Registered Auditors
• Authorised and Regulated by Financial Conduct Authority (FCA)
• Online Training sessions with Qualified Accountants
• 100% Practical training
• 100% Flexible - You choose day & time of your own choice
• Official Sage, QuickBooks and Xero Certifications
• Professional CV and Interview Preparation
• Professional reference to employers
• Support with PER for ACCA / AAT / CIMA

Bookkeeping and Payroll training is an ideal program for anyone looking to start a fresh career in Accountancy sector.

Bookkeeping and Payroll training has no requirements

Bookkeeping and Payroll training can prepare you for jobs such as Bookkeeper and Payroll Administrator

Certificate of completion

Digital certificate - Included