Vlook up with Ab ref | first inlearning

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Build Your Own Accountancy Practice

Xero Bookkeeping - Practical based Training

Introduction to XERO (14:59)
Setting up New company (7:48)
Create customer and Supplier Contacts (6:53)
Chart of Accounts (6:08)
Add Bank Accounts (8:24)
Conversion Balances (6:17)
Customer Invoice (7:44)
Allocate Credit Notes (4:39)
Supplier Bills (2:49)
Credit Note for Bill (4:07)
Customer Payments (3:35)
Supplier Payments (2:40)
Repeating Bill (2:52)
Petty Cash (3:55)
Journal Entry (5:17)
Quotes (3:03)
Purchase order (4:59)
Reporting (7:55)
Free Trial (2:43)

QuickBooks Bookkeeping - Practical based Training

Free Trial (2:08)
QuickBooks Overviews (15:59)
QuickBooks Accountant version (3:57)
Create and send Invoices (12:25)
Supplier & Expenses (17:31)
Recording Invoice & Payments (17:01)
Banking (8:19)
Reports (8:10)
Bank Reconciliation (17:22)
QB Shortcut (7:52)
Exercise (102:44)

IRIS Payroll - Practical based Training

Introduction to Payroll (24:18)
Setting Up New Companies (12:43)
Enroll or Import Employees (12:40)
Additions and deductions on the parsnip ( Gross Pay to Net Pay) (10:55)
Statutory Payments ( SSP , SMP , Holidays ) (9:07)
Back up & Restore (4:01)
P45 (6:26)
Reporting (10:36)
Import Hours & Employees (11:51)
RTI Submission (4:18)

Bright pay Payroll - Practical based Training

Introduction to Payroll (24:18)
Set Up Employer in Bright Pay (15:16)
Enroll or Import Employees (15:16)
Additions and deductions on the payslip ( Gross Pay to Net Pay) (11:35)
Statutory Payments ( SSP , SMP , Holidays) (11:19)
Back up & RTI submission (9:53)
P60 & P45 (4:24)
Exercise (13:37)

Taxfiler - Limited Company Accounts Preparation

Introduction to taxfiler (7:06)
Bank Analysis (16:35)
Setting up New Clients (11:31)
Prepare Accounts & tax Return (12:52)
Understand of Trial Balance (8:32)
Trial Balance Data Input (9:32)
LTD Company - Example (55:48)

Microsoft Excel

Sorting and Filtering (4:54)
Vlook Up in Details (6:59)
Pivot Table with examples (6:10)
If Function (5:37)
Find and Replace (3:19)
Find Duplicates (3:34)
Password on Excel file (3:30)
Data Validation (5:55)
Vlook up with Ab ref (9:19)
Removing Duplicates Value (3:10)
Pivot Table with Pivot Chart (9:35)

Self Employment

Register for self Employment (4:31)
File your tax return online (15:42)
Stop Being Self Employed (5:14)

VAT - Making Tax Digital

Introduction to VAT (5:38)
Understanding of VAT Return (8:04)
Submit VAT return to HMRC (7:26)

Classroom Based Training

Bookkeeping - Business Documents, Books of prime entry, vat & discounts (136:49)
Bookkeeping - Credit purchase & Sales, Double Entry for Bookkeeping (143:23)
Bookkeeping - Double entry Journals (121:04)
Bookkeeping - Cash book , Double entry for Trade receivable & Trade Payable (145:00)
Bookkeeping - Petty Cash book & Initial Trial Balance (81:49)
Control - Payments Methods & Bank Reconciliation (118:38)
Control - Control accounts (122:38)
Control - Payroll Journal & Error in Suspense Account (130:58)
Financial Accounting - Introduction & Incomplete records (153:24)
Financial Accounting - Sole Trader (139:41)
Financial Accounting - Partnership (122:20)

TaxCalc Limited Company Accounts Production

TaxCalc Training Series 01 Getting Started for Practice Users (7:26)
TaxCalc Training Series 02 Client Onboarding (8:42)
TaxCalc Training Series 03 Dashboards and Tasks (5:58)
TaxCalc Training Series04 Mail Merge and Questionnaires (6:39)
TaxCalc Training Series 05 Report Manager (5:38)
TaxCalc Training Series 06 Accounts Production (8:25)
TaxCalc Training Series 07 Corporation Tax (6:17)
TaxCalc Training Series 08 Self Assessment Tax (8:17)
TaxCalc Training Series 09 VAT Filer (6:36)
TaxCalc Training Series 10 Companies House Forms (4:20)
TaxCalc Training Series 11 Advanced Settings (9:01)
TaxCalc Advanced Training Class 2 NICs (1:27)
TaxCalc Advanced Training Capital Allowances (4:15)
TaxCalc Advanced Training Capital Gains (5:49)
TaxCalc Advanced Training Foreign Dividend Income (3:26)
TaxCalc Advanced Training Foreign Pension Income (2:52)
TaxCalc Advanced Training Foreign Social Security Income (3:01)
TaxCalc Advanced Training Foreign Interest Income (3:12)
TaxCalc Advanced Training Foreign Land and Property Income (5:26)

Extras

Submission of Confirmation Statement (11:54)
Pension (19:18)
Apply for Authentication code (4:48)
Apply for UTR number (7:09)
Dormant & Micro Company (14:21)
Extend deadline for limited company (8:21)
Apply for PAYE Ref. (6:39)

Teach online with

Vlook up with Ab ref

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock