Learn Full Excel Based Accounts in 60 Minutes- UK Accountant
What you'll learn
- Meaning of Accounting Terms
- How Accounting Ratios work
- Rules of Double Entry Bookkeeping
- Day Book- How do business manage its day book
- How to prepare journal entries
- Method of preparation of ledgers accounts
- VAT/GST calculation, posting of VAT/GST in day book
- Prepare Trial Balance from ledgers accounts
- Prepare Profit & Loss Account from Trial Balance
- Construct Balance Sheet from trail balance
- How to keep stock record on Excel
Requirements
- None, anyone with interest in finance can join
Description
Accounting is important in our day to day life. When small businesses can’t afford accounting software, they keep their daily business record on excel. This course has developed a simple method where business can have all their data on excel without using any complicated excel workbooks. Simple Steps Learning core principle is to develop courses with simple and straightforward approach with easy understanding.
This course would explain to you what is double entry bookkeeping, and how it works in practical life. You would learn five important steps which will in the end produce your business profit and loss account and balance sheet. These five steps contain day book, journal entry, trial balance, profit and loss account and balance sheet. There is no other simple way than this for your daily bookkeeping and accounts preparation.
I hope you would learn new skills which will be beneficial for life! Please note some tasks are repeated for extra 15 minutes. You can skip as per your need.
Why accounting is important, and how to achieve best out of it in short time:
Due to fast paced environment, accounting professionals, entrepreneurs, and ambitious accountants and bookkeeper need to keep
track of business finance in short time to analyze business growth and profitability. There is no other way than cloud base accounting
to achieve these objectives. You can process financial data on daily basis and produce financial reports (P&L, B/S etc…) everyday,
which can give you an overview of business performance. I have covered important topics from scratch to end to produce these
reports with actual financial data posting, and explanation. please note some tasks are repeated for extra 15 minutes. If you want to be expert in
accounting I would strongly suggest that you must practice skills you learn through this course. Practice is mandatory in order for you to
understand that how the whole accounting system works. Always start with small data so that you can monitor your results easily if you make
mistake you can correct yourself straight away. Accounting is really a fun, there are lot of online applications which have made accounting so much
easy so that a person who have no prior knowledge in accounting can learn these skills comfortably. You even do not need to learn all the rules
and principles used in accounting in order to do the job.
All the best
Simple Steps Learning Academy
Who this course is for:
- Students
- New Startups
- Business Owners
- Freelancers
- Fresh Accountants
- House Wives- Start their own accounting/bookkeeping business
- Unemployed Individuals- Learn new skill for job
- Investors
- Property Landlord
Course content
- Preview06:29
- 04:48Accounting Ratios
- 14:10Debit & Credit Rules
- Preview04:28
- 09:56Journal Entries
- 10:17Individual Ledger Accounts
- 06:34VAT/GST Invoices Posting & Calculation
- Preview03:34
- Preview02:13
- 03:33Balance Sheet
- 06:40Different Method of Stock Keeping
Instructor
![Simple Steps Learning Academy](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.9 Instructor Rating
- 3 Reviews
- 24 Students
- 3 Courses
Teacher Introduction:
My philosophy 'Learning Through Simple Steps'
Accounting and teaching are my passion. I am a professional accountant, practicing in London, UK. I have been in accounting profession for last 15 plus years. I graduated with first division in finance from Leeds Beck University, UK and PGCE from Kingston University, London. I have also been awarded by Royal Bank of Scotland for being an outstanding in finance. I have dealt with multiple assignment, and implemented best accounting systems to enhance business performance, growth and profitability.
By working both in practice and industry I understand the complexities involved in businesses. I trained many accountants and bookkeepers; I understand difficulties they face while working. This is where I come forward to develop SIMPLE STEPS LEARNING techniques for students, entrepreneurs and many other individuals. I believe the simple the step is, the easier it is going to be for learner. I transform hard tasks into easy task due to my vast experience.
Regardless whatever difficulties you have, you just need to follow the process I have taught in this course, you will learn skills to handle actual financial data, which will lead you to produce financial reports.
Imran Majeed
Simple Steps Learning Academy