Practical Accounts Automated

Year End Procedures to Finalise Accounts
5.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
166 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 79
  • Length 14 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

Welcome to Practical Accounts Automated, a Cross between Theory, Practical, and Computerised Accounting.

Theory or Academic Accounting provides the Definitions and Explanations.

Practical Accounting is about Procedures used in Accounting Firms.

Computerised Accounting is about Automating Processes, probably without Explanations.

Get Accounting Firm Procedures together with an Entry Form based Template that Records, Posts to Ledgers, and Automates Over 100 Reports.

Based on Universal Accounting Principles regarding Double Entry, Trial Balance, Profit and Loss Account, Balance Sheet, etc.

For training we use Videos, Illustrative Documents, Recorded Annual Double Entry, plus a Template for Practice. The same Template can be used for other businesses.

The Template requires an installed version of Excel 2010 and upwards on the PC. Otherwise the Slicers Do Not Work. Those with older versions of Excel have to ask before enrolling on the course. The Template doesn't work on the mobile version of Excel.

Please Note that we dont train on how to prepare since the Reports are already done by the Template. We only guide on how to access and Present or Print.

What Do You Get?

A Re-usable Template and How To Use it

Plenty of Forms with Auto Selected Accounts and Minimal Typing

Periodic Tasks and Annual Reports Checklists

Auto Monthly and Quarterly Reports

Efficient Year-end Procedures

Financial Statements

60 Mandatory and Automated Supporting Reports

Live Online Question and Answer Sessions

Get Certified

ENROL NOW TO ACQUIRE SKILLS DESIRED BY EMPLOYERS

What are the requirements?

  • Excel Software
  • Minimal Excel Skills.
  • Basic Knowledge of Double Entry

What am I going to get from this course?

  • 1. Able to identify all Periodic Reports automatically prepared by the Template. This includes: Vat Return & Computations, Reconciliations, Cash & Bank Summaries, General Ledgers, Trial Balance, Journals, Creditors Ledgers, Creditor's Reconciliations, Debtors Ledgers, Debtor's Reconciliations, Profit And Loss Accounts plus Notes, Balance Sheets plus Notes.
  • 2. Able to identify all the 72 Year-end reports prepared by the Template, on a section by section basis.
  • 3. Able to Carry out All Year End Procedures that finalise Financial Statements and 70 Supporting Reports.
  • 4. Able to Present 72 Final Reports for a Sole Trader, classified in 17 sections which are; Tax Return Extract, Financial Statements, Year End Adjustments, Vat, Wage, Income, Expenses, Fixed Assets, Stock, Trade Debtors, Bank, Cash, Other Current Assets, Trade Creditors, Long-term Liabilities, Other Current Liabilities, plus Equity Reports.
  • 5. Able to Re-use the Template for other businesses.

What is the target audience?

  • Those interested in acquiring Skills and Knowledge for Finalising Accounts, as its done by Accounting Firms, with a final layout for a Sole Trader. The final layout for a Partnership and Limited Company are in a separate course.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:32

Get a brief background to the design of this course

05:26

knowing what is covered on the Course

16:10

Knowing the 14 Menus or Sections on the Accounting Ribbon, plus the facilities in each of them.

19:26

Identify the 267 Accounts available and customisable for a Sole Trader.

16:36

Identify the columns of required information before transactions can be updated to the Reports.

12:06
Able to use a Standard Recording; selecting accounts, typing amounts, Narration, document number, Date, plus month.
19:48

Able to interpret information pasted on the Double Entry Page

Section 2: 2. Reviewing Periodic Reports
07:29

Get some understanding on the Pivot based Journals

12:29

Get some understanding on the Pivot based General Ledger using slicers

08:42

Get some understanding on the Pivot based Trial Balance using slicers

16:04

Being introduced to the Vat Return and see how its values come from the Vat Ledger or Detailed Vat Computations

13:42

Being Introduced to the Pivot based Reconciliation for the Bank, Cash, Credit Card Loan, and Hire Purchase accounts.

03:39

Being Introduced to the monthly Summary for the most sensitive accounts which are the Bank and Cash accounts

05:17

Being introduced to the Pivot based Creditors Ledger

05:17

Being introduced to the Pivot based Creditors Ledger Reconciliation

09:12

Being introduced to the Pivot based Debtors Ledger

04:39
Being introduced to the Pivot based Debtors Ledger Reconciliation
13:24

Being introduced to Pivot based Notes to the Periodic Profit and Loss Accounts

04:47

Being introduced to the Pivot based monthly and quarterly Profit and Loss Accounts

11:40

Being introduced to the Pivot based Notes to the Quarterly Balance Sheets

05:51

Being introduced to the Pivot based Quarterly Balance Sheets

Section 3: 3. Reviewing Annual Reports
13:28

Reviewing the Accounting Reports Checklist starting from section A to S

13:34

Getting an Overview of Vat Reports

11:14

Getting an Overview of Wage Reports

05:39

Getting an Overview of Income Reports

19:36

Getting an Overview of Expense Reports

20:01

Getting an Overview of Fixed Asset Reports

04:31

Getting an Overview of Stock Reports

08:55

Getting an Overview of Trade Debtor Reports

12:17

Getting an Overview of Bank Reports

05:11

Getting an Overview of Cash Reports

09:16

Getting an Overview of Other Current Asset Reports

07:54

Getting an Overview of Trade Creditor Reports

08:30

Getting an Overview of Long-term Liability Reports

15:09

Getting an Overview of Other Current Liability Reports

07:20

Getting an Overview of Equity Reports

19:55

Getting an Overview of Year End Adjustments

15:29

Getting an Overview of the Notes to Final Financial Statements, the Profit and Loss Account, Balance Sheet, and Performance Ratios

13:01

Being introduced to A Sole Traders Tax Return SA103F, indicating where values come from

Section 4: 4. Year End Procedures
03:55

Able to Verify Double Entry Records and Reports, Carrying Out Year End Adjustments, and Present about 70 Reports for the Accounts File.

13:56

Able to quickly peruse through the Double Entry records on their page.

12:51

Able to confirm Filed Periodic Reports against Periodic Reports on the Template, plus the Year End Comparative Trial Balance.

32:52

Able to confirm or investigate and correct differences between C3 and D3, E2, E3, G3 TO G16, H5, H6, J1, K2, L3, L6, L9, M2, N2, P2, Q3, R5, S1, and S3.

13:02

Able to Assemble all copies of submitted Vat Returns, Verify Periodic Vat Figures, and Reconcile the Vat Summary.

09:47

Able to Assemble all the Wage Computation Summaries, and Reconcile the PAYE and NI Summary.

19:09

Able to find Depreciation Policies, Compute Depreciation figures, and Record the Depreciation Amounts.

11:45

Able to identify documents that support the Purchase and Disposal of Fixed Assets, plus prepare the Fixed Assets Register.

09:45


Able to gather Stock Taking Records and Record values as a Journal.

16:23

Able to investigate causes of Differences among the Reconciliation Figures on the Debtors and Creditors Summary Page.

13:51

Able to Assemble the Last Statements for the Bank Accounts and a Record of Cash Balances, plus Reconciling each of them.

1 page

Able to identify and Copy Prepayment Documents, make Computations, and Record.

09:56

Assemble the Last Loan, Hire Purchase and Credit Card Statements, and Reconcile them to the Summaries.

2 pages

Able to Assemble Accruals Documents, and Compute before Recording using the Single Journal.

Article

Able to record an Accrued Income Reserve Adjustment at the Year-end

08:00

Able to Review the Year-end Journals and Final Trial Balance.

20:05

Able to Review the Financial Statements, Notes, and the Tax Return Extract.

Section 5: 5. Final Reports Presentation
02:53

Able to Present 72 Final Reports for a Sole Trader, classified in 17 sections which are; Tax Accounts, Year End Adjustments, Vat, Wage, Income, Expenses, Fixed Assets, Stock, Trade Debtors, Bank, Cash, Other Current Assets, Trade Creditors, Long-term Liabilities, Other Current Liabilities, Equity Reports.

07:58

Able to Review, Print and File Drawings accounts, their Summary, plus Capital accounts.

14:27

Able to Review, Print and File the Other Current Liability accounts, their Summary, the Credit Card Final Statement, Summary and Reconciliation, plus Accruals Computations, Estimates and Documents.

07:29

Able to Review, Print and File the Loan and Hire Purchase accounts, their Final Statements, plus Summaries and Reconciliations.

07:00

Able to Review, Print and File the Annual Creditors Ledger, Trade Creditors Control account, plus the Creditors Summary and Reconciliation.

15:19

Able to Review, Print and File the Cash, Prepayments and Other Current Asset Reports.

09:06

Able to Review, Print and File the required Bank accounts, their Final Statements, plus Summaries and Reconciliations.

08:35

Able to Review, Print and File the Stock Taking Records and accounts, Annual Debtors Ledger, Trade Debtors Control account, plus the Debtors Summary and Reconciliation.

18:59

Able to Review, Print and File Fixed Asset Documents, the Accounts, the Depreciation and Disposal accounts, Depreciation Policies and Computations, the Fixed Assets Register, plus the Fixed Assets Summary.

14:01

Able to Review, Print and File Grouped Expense accounts from 21 upto 180, on reports G3 to G16, plus A Summary on G1.

05:14

Able to Review, Print and File the Other Income accounts, Turnover accounts, plus the Turnover Summary.

07:29

Able to Review, Print and File the Wage Computation Summaries, Net Wages account, PAYE and NI account, plus the PAYE and NI Summary and Reconciliation

09:50
  • Able to Review, Print and File the Vat Returns, Vat Payable account, Periodic Vat Figures, plus the Vat Summary and Reconciliation
09:41
Able to Review, Print, and File the Year End Comparative Trial Balance, Year End Journals and the Final Trial Balance.
19:52

Able to Review, Print, and File the Notes to Financial Statements, Performance Ratios, the Profit and Loss Account, Balance Sheet, and the Tax Return Extract for a Sole Trader.

Section 6: 6. Template for Other Businesses
19:41

Able to Save Double Entry Records before clearing the Template.

13:15

Able to clear the Business Names and Financial Year in cells B2 and B3, plus all the recorded transactions on the Double Entry page.

07:21

Able to replace the Creditors, Debtors and General Ledger account names with those for the New Business.

03:18

Able to change to the Standard Vat Rate used in your country, in order to verify computed figures on the Vat Return page.

02:36

Able to delete the entered Monthly Reconciliation Balances in the blue cells on the Reconciliation page.

04:41

Able to delete the typed figures on the Annual Reconciliation pages which includes Reports D1, E1, K1, L1, L4, L7, M1, P1, Q1, and R2.

03:32

Able to delete typed information on the following reports: Fixed Assets Register, Depreciation Policies and computations, Prepayment Calculations, plus Accruals Computations and Estimates.

03:41

Able to Swap the Template's use by Cummulating Specific business records via it's Backup file or worksheet in a Workbook

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Fellow of the ACCA, DBA, BA/ Educ,

A Practicing Accountant with many years Experience

I designed and partly built the Template on this course

25 Years Experience Teaching Theory and Practical Accounting

Taught at High schools, City College Coventry, and Halifax University, Birmingham

Published Author with several Accounts titles

Administrator at the Association of Practical Accounts (APA), UK.

APA is tasked to provide Practical Accounts Training in a classroom environment, which addresses the shortage of Training Facilities in the work environment.

The newly qualified in Accounting are not able to deliver at work. The idea of learning at work is only accessible to a few. Many finalists are not offered jobs since employers require practical experience.

APA aims to narrow the gap between what is taught on many courses, and the skills required at work. There is a mismatch between graduates and the crucial skills desired by employers especially the business sector. Its difficult to justify the size of the gap in the 21st Century.

Modern procedures have been modified to save time, overcome weaknesses, adjust to tax report layouts, and are software Oriented.

Most courses deliver Accounting knowledge without the technical or practical skills required in the modern workplace. Many only scratch the Bookkeeping Function, which is the backbone of the Accounting Function. The Accounts File Preparation should be straight forward if the Bookkeeping is done properly from start. However, since Bookkeeping is often left in a mess, Final Accounts Preparation starts by Reviewing Bookkeeping, which is often complicated and stressful.

That is why we have opted for automating the Process, Saving time, and filling in the skills shortage. All is left accessing, presenting, and explaining the Reports.

Ready to start learning?
Take This Course