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