Basic Bookkeeping in MS Excel
Recording transactions, profit or loss statements, and balance sheets in Excel
About This Course
Course Information
This course provides basic understanding of how to use MS Excel for Bookkeeping, including recording transactions, classifying them, summarising them and reporting them. By the end of this course, you will be able to: 1. Prepare a basic statement showing the financial position of the business, in MS Excel (the balance-sheet). 2. Prepare a basic statement of profit or loss in MS Excel. 3. Perform basic bookkeeping using MS Excel. The template prepared in this course will help you with basic bookkeeping for your company or clients (small businesses).
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 10 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 10 units.
Course Sections
This Course is made up of the following sections:
- Creating the Transaction List Template (Video and Quiz)
- Refining the Data (Video and Quiz)
- Finalising the Transaction List (Video and Quiz)
- Preparing a Simple Statement of Profit or Loss (Video and Quiz)
- Preparing a Simple Balance Sheet (Video and Quiz)
- Additional Quizzes and Course Completion Survey
- Additional Reading Materials
What You Will Learn
- Prepare a transaction list template that records, classifies, and summarises business transactions
- Apply data validation and VLOOKUP to automate transaction categorisation
- Describe how to refine raw transaction data into a format suitable for financial reporting
- Prepare a simple statement of profit or loss in Excel from the transaction list
- Prepare a simple balance sheet showing the financial position of a business
- Explain the bookkeeping cycle from recording to reporting using spreadsheet tools
Who This Course Is For
- Small business owners who need to perform basic bookkeeping without accounting software
- Trainee accountants learning the bookkeeping cycle in a practical, hands-on way
- Bookkeepers who want to build a reusable Excel template for recording and reporting transactions
- Finance students who want to connect bookkeeping theory with spreadsheet practice
Prerequisites
- Basic Excel skills (data entry, navigating sheets, simple formatting)
- No prior bookkeeping or accounting knowledge is required
Frequently Asked Questions
Course Details
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now