How to Prepare Management Accounts

How to Prepare Management Accounts free download

Learn to prepare Management Reports in Excel

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

All Included:

• Video presented course

• Downloadable course material

• Certificate of training

• Optional assessment

• 4 Verifiable CPD Points - SAIT Accredited

About the Presenter:

Ruzel van Jaarsveld

Ruzel has over 26 years financial and bookkeeping experience, working with many industries and corporate environments, with extensive knowledge and practical application of trial balance, payroll, VAT, PAYE returns, Inventory control, Management Accounts, E-filing and Procedures of Importing and Exporting.

Ruzel is a seasoned appointed facilitator with Biz Facility, and for numerous years has been presenting various national practical financial workshops to business owners and corporate financial staff.