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

 VAT

• 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

Payroll

• 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