Practical Accounts & Bookkeeping Automated Overview

An Overview of the Recording, plus Year End Procedures Automated by an Excel Template
4.2 (19 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.
2,053 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 30
  • Length 4.5 hours
  • Skill Level All Levels
  • 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 and Bookkeeping Automated, where you get an overview of the whole Practical Accounting Process, all the way from Opening Balances, to the Recording, Periodic Reports, Year-end Procedures, Final Accounts, plus Supporting Reports, all done and automated with an Excel Template.

As opposed to Accounting Theory, get to know what is done in Accounting Firms, speeded up by an Excel Template. Get an insight into the Real Accounts, as desired by Tax Authorities.

What is Covered:

  • An Accounting Template Overview
  • A Chart of Accounts Overview
  • The Double Entry Page
  • A Recording Form
  • Interpreting Recorded Information
  • Opening Balances Recording Overview
  • An Overview of Recording Income Documents and Transactions
  • An Overview of Recording Receipts Documents and Transactions
  • An Overview of Recording Cost of Sales Documents and Transactions
  • An Overview of Recording Overhead Documents and Transactions
  • An Overview of Recording Fixed Asset Documents and Transactions
  • An Overview of Recording Payment Documents and Transactions
  • An Overview of Recording Loan and Credit Card Documents and Transactions
  • An Overview of Recording Creditors Documents and Transactions
  • An Overview of Recording Debtors Documents and Transactions
  • An Overview of Other Recordings Without Vat
  • An Overview of Periodic Reports
  • An Overview of 72 Accounting Reports
  • An Overview of Year-end Adjustments and Procedures
  • An Overview of the Presenting of Final Accounts and Supporting Reports

For this overview, all that is used are Videos.

What is the target audience?

  • business owners
  • managers
  • business students
  • beginning accounting students


What are the requirements?

  • Not much since its just an overview, in preparation for the main course.
  • What is required is an eager mind ready to learn.

What am I going to get from this course?

  • 1. An Accounting Template Overview
  • 2. A Chart of Accounts Overview
  • 3. Overview of the Recording for Opening Balances, Incomes, Receipts, Expenses, Fixed Assets, Payments, Loans, Credit Cards, Creditors, Debtors, etc.
  • 4. Periodic Reports Overview
  • 5. Year-end Adjustments and Procedures Overview
  • 6. Presenting Final Accounts and Supporting Reports Overview

What is the target audience?

  • Anybody interested in getting an Overview of Practical Accounts and Bookkeeping, Automated.

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: Chapter 1: Introduction
02:32

Get a brief background to the design of this course: Practical Accounts and Bookkeeping Automated.

04:30

knowing what is covered in 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 265 Accounts created or modified 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. An Overview of All Template Reports
11:32

Being introduced to all Periodic Reports Automatically prepared by the Template


08:25

Getting an Overview of the 72 Year-end Reports, with some focus on Financial Statements, Tax Return Extract, and Year-end Adjustments.

04:58

Getting an Overview of Vat, Wage and Income Reports

07:30

Getting an Overview of Expenses and Fixed Asset Reports

05:09
Getting an Overview of Stock, Debtors, and Bank Reports
03:50

Getting an Overview of Cash, Other Current Assets, and Creditor Reports

04:54

Getting an Overview of Long-term Liability, Other Current Liability, and Equity Reports

Section 3: 3. Reviewing VAT and Documents Management
19:43

Review the Registration, Rates, Reporting and Verification

16:41

Get a quick overview of the Documents Management system

Section 4: 4. Recording Opening Balances and Document Based Reversals
07:38
Able to record Opening Balances for the Creditors, Debtors and General Ledger, plus Opening Reversals. However, start by adding and customising accounts
Section 5: 5. Recording Income Documents and Transactions
05:01

Able to record Receipts, Invoices, Debit Notes, Credit Notes, Returns Vouchers, and others.

Section 6: 6. Recording Overheard Expense Documents and Transactions
06:06

Able to record documents for Overheads Paid, Refunded, Invoice, Debit Note and Credit Note.

Section 7: 7. Recording Cost of Sales Documents and Transactions
09:37

Able to record documents for Cost of Sales Paid, Refunded, Invoice, Debit Note and Credit Note.

Section 8: 8. Recording Fixed Asset Documents & Transactions
07:55

Able to record documents for Fixed Assets Paid, Refunded, Invoice, Debit Note, Credit Note, Owner's Assets, and Disposals.

Section 9: 9 Recording Payment Documents & Transactions
06:45

Able to record Payments documents although the following are covered in other sections: Cost of Sales, Overhead Expenses, Fixed Assets, Income Refund, Creditors, Debtors

Section 10: 10 Recording Receipts Documents & Transactions
03:04

Able to record documents for Money Received although the following are covered in other sections: Cost of Sales, Overhead Expenses, Fixed Assets, Income Received, Creditors, Debtors

Section 11: 11 Recording Loan and Credit Card Documents & Transactions
03:54

Able to record documents for Borrowed Money, the Fees and Charges, Interest, Loan Repayments, Credit Card advance, and Credit Card Repayments.

Section 12: 12 Recording Creditors Documents & Transactions
04:01

Able to record Creditor Invoices, Debit Notes, Credit Notes, Payments, Refunds, and Dishonoured Cheque. Please Note that although some are already handled, they are covered again.

Section 13: 13 Recording Debtors Documents & Transactions
05:39

Able to record Debtor Invoices, Debit Notes, Credit Notes, Payments, Refunds, Dishonoured Cheque and Bad Debts. Please Note that although some are already handled, they are covered again.

Section 14: 14 Other Recordings Without Vat
06:31

Able to record the other transactions not yet covered, that do not involve Vat. This includes a Bank Transfer, Wages Computations, Drawings Invoice, Rent Deposit Paid, Rent Deposit Refund, Agency Commission, Vat Transfer, Vat Penalty, PAYE & NI Penalty, plus Fixed Assets Capital Invested.

Section 15: 15. Periodic Reports Presentation
08:23

Able to Present all Periodic Reports for a Sole Trader which include; 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.

Section 16: 16. Year End Procedures
10:06

Able to Verify Double Entry Records and Reports, and Carry Out Year End Procedures.

Section 17: 17.0 : Final Reports Presentation
06:26

Able to Present a possible 72 Final Reports for a Sole Trader, classified into 17 sections which are; 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, and Equity Reports.

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