Practical Accounts Automated

Year End Procedures to Finalise Accounts
4.5 (2 ratings)
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.
169 students enrolled
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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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


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.

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


Section 1: Introduction

Get a brief background to the design of this course


knowing what is covered on the Course


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


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


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

Able to use a Standard Recording; selecting accounts, typing amounts, Narration, document number, Date, plus month.

Able to interpret information pasted on the Double Entry Page

Section 2: 2. Reviewing Periodic Reports

Get some understanding on the Pivot based Journals


Get some understanding on the Pivot based General Ledger using slicers


Get some understanding on the Pivot based Trial Balance using slicers


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


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


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


Being introduced to the Pivot based Creditors Ledger


Being introduced to the Pivot based Creditors Ledger Reconciliation


Being introduced to the Pivot based Debtors Ledger

Being introduced to the Pivot based Debtors Ledger Reconciliation

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


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


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


Being introduced to the Pivot based Quarterly Balance Sheets

Section 3: 3. Reviewing Annual Reports

Reviewing the Accounting Reports Checklist starting from section A to S


Getting an Overview of Vat Reports


Getting an Overview of Wage Reports


Getting an Overview of Income Reports


Getting an Overview of Expense Reports


Getting an Overview of Fixed Asset Reports


Getting an Overview of Stock Reports


Getting an Overview of Trade Debtor Reports


Getting an Overview of Bank Reports


Getting an Overview of Cash Reports


Getting an Overview of Other Current Asset Reports


Getting an Overview of Trade Creditor Reports


Getting an Overview of Long-term Liability Reports


Getting an Overview of Other Current Liability Reports


Getting an Overview of Equity Reports


Getting an Overview of Year End Adjustments


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


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

Section 4: 4. Year End Procedures

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


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


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


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.


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


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


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


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


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


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


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.


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.


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


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


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

Section 5: 5. Final Reports Presentation

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.


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


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.


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


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


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


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


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.


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.


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


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


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

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

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

Able to Save Double Entry Records before clearing the Template.


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


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


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


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


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.


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


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