When preparing Management Reports, there are no set procedure of rules or processes whilst preparing management accounts, there is nothing mandatory to include, rather these are a compilation of all financial or operational information which you believe to be of importance, collected from various financial reports that management has gathered. Typical management accounts, would include the Trial Balance compared to last year, profit and loss accounts, cash flow forecasts, income statement, and balance sheets. Also, relevant Balance Sheet Reconciliations for example Loan Accounts.

This course will assist the learner in preparing useful and thoughtful Management Reports on EXCEL.

This course is also meant to assist the learner STEP-BY-STEP, how a set of completed books are to be compiled for a full financial year, from the capturing of the transactions to the reporting thereof.

Topics Discussed:

• Preparing your bank allocations to ensure consistent and streamline reports
• Reconciling:
• The Bank Account
• The Petty Cash Account
• Suppliers
• Customers
• Loan Accounts
• Preparing a Fixed Asset Register and calculating depreciation
• Journals
• Preparing the reports:
• Trial Balance
• Income Statement
• Management Accounts
• Balance Sheet
• Rolling over for the year and starting fresh for the next year