Do Your Own Accounts
Use An Excel Spreadsheet To Do Your Own Bookkeeping And Save Yourself Time, Costs And Stress
What you'll learn
- Do Your Own Accounts using a simple Excel spreadsheet
- Understand what the numbers in the accounts mean for the business
- Understand the basic principles of bookkeeping and accounting, including financial statements, balance sheets, and income statements.
- Learn how to use Excel to create and manage financial records, including tracking income and expenses, managing invoices, and reconciling bank statements
- Discover practical tips and tricks for streamlining your bookkeeping processes, saving time, and reducing costs
- Gain the confidence and skills to manage your own accounts effectively, allowing you to focus on growing your business and achieving your financial goals
Course content
4 sections • 13 lectures • 1h 39m total length
- 1. Worked Example - inputting April income (6:39)
- 2. Worked Example - inputting April expenses (12:58)
- 3. Worked Example - the accounts for Month 1 - April (5:22)
- 4. Worked Example - inputting May income (4:20)
- 5. Worked Example - inputting May expenses (13:33)
- 6. Worked Example - the accounts for Month 2 - May (3:48)
Requirements
- You will need to be able to open up an excel 2003 document on your computer. BASIC excel skills are needed. There are no formula's etc., because the template has everything, but you need to be able to navigate through a spreadsheet.
Description
Are you tired of spending endless hours and tons of money on bookkeeping? Well, you're in luck! Our online course, "Do Your Own Accounts: Use An Excel Spreadsheet To Do Your Own Bookkeeping And Save Yourself Time, Costs And Stress" is the solution you've been looking for.
Designed for entrepreneurs, business owners, individuals, and bookkeepers, this course offers a simple and easy way to do your bookkeeping using an excel spreadsheet. You don't need any accounting knowledge, and it takes just 90 minutes to complete.
With our reusable template excel spreadsheet, you can easily manage your small business bookkeeping in a simple and effective way. The spreadsheet acts as a cashbook and prepares a profit and loss statement for you, which will help you submit your self-assessment tax return in the UK or provide a profit and loss account globally (due to complying with international accounting standards).
The course takes a practical approach, using a fictitious company and two months worth of bank statements to show you how to fill in the cashbook and automatically populate the accounts. You'll also learn about accounting concepts and the physical aspects of keeping accounting records.
With our course, you'll not only save time and stress but also reduce your accountancy fees. Use the template to do your own accounts, and then send it to your accountant. The accounts will be in much better shape, and you can ask for a reduction in accountancy fees.
Stop wasting time and money on bookkeeping. Enroll in our course today and take control of your bookkeeping in a simple and effective way.
Who this course is for:
- This course is for entrepreneurs, business owners (home based businesses) and bookkeepers who want a simple, yet effective spreadsheet system to keep track of and do their own bookkeeping
- If your business is fairly small, home-based and you don't want to learn Sage or Quickbooks, but you are comfortable using Excel - this course is for you