Some of my most popular bookkeeping and accounting tutorials are those that use excel and spread sheets to demonstrate accounting techniques and principles. With this in mind The Bookkeeping Master decided to upload a new series to his bookkeeping and accounting YouTube channel; 'Creating Management Accounts using Excel'. The tutorial is a 5 part series and covers creating profit and loss statements, balance sheets and sales ledger reports.
Creating Management Accounts using Excel #1 - An Introduction to Management Accounts
Management accounts are an essential part of evaluating business performance and planning for the future of the business. They generally include information about how sales, profits and outstanding asset debt (credit clients that owe cash to the business). Management accounts are generally provided monthly and include (at a minimum) a profit and loss statement, sales information and an aged debtors analysis.If you are a bookkeeper or accountant, providing regular management accounts are also a great way to impress your employer or accounting clients.
Creating Management Accounts using Excel #2 - The Profit and Loss Statement
My next video shows how to create a profit and loss statement using excel. A profit and loss statement details the profit or loss made by a business within a specific period. Most profit and loss statements cover a period of 1 month, 1 quarter or 1 year. The profit or loss is determined by calculating total sales minus the cost of those sales and minus business expenses.
In my video I demonstrate how to create the profit and loss template using Microsoft Excel and also provide an example of what the statement should look like once complete, as well as other important insights.
Creating Management Accounts using Excel #3 - The Balance Sheet
A balance sheet details the assets and liabilities of the company. Some balance sheets specify fixed assets, current assets, long-term liabilities and current liabilities. The purpose of the balance sheet is to summarise the financial health of a business or provide a 'snapshot' of the financial position of a business.
My video gives a short tutorial on creating a balance sheet using excel and gives some further insights into balance sheets and the necessity of including them in management accounts.
Creating Management Accounts using Excel #4 - Sales and Aged Debtors Reports
In management accounts, sales reports can be as simple as comparing current sales with historic sales and/or with forecast sales. Usually a graph will suffice. The next video in my Creating Management Accounts Series shows you how to do this.
I strongly encourage you to include an Aged debtors report as part of management accounts also. Once again this information can be displayed as a graph or, if you have accounting software, can be displayed by simply printing an aged debtors analysis.
Creating Management Accounts using Excel #5
The last video in my management accounts series summarises everything covered in the previous 4 videos. If you would like me to provide monthly management accounts for your business, please contact me at firstname.lastname@example.org and visit my Bookkeeping Services page.