Published 9/2024
Created by Bizfacility (Pty) Ltd
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 7 Lectures ( 2h 17m ) | Size: 1.78 GB
Learn to prepare Management Reports in Excel
What you’ll learn:
Preparing a Fixed Asset Register and calculating depreciation
Preparing the reports
Streamline reports
Journals
Requirements:
No prerequisites
Description:
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 reportsReconciling:The Bank AccountThe Petty Cash AccountSuppliersCustomersLoan AccountsPreparing a Fixed Asset Register and calculating depreciationJournalsPreparing the reports:Trial BalanceIncome StatementManagement AccountsBalance SheetRolling over for the year and starting fresh for the next yearAll Included:Video presented courseDownloadable course materialCertificate of trainingOptional assessment4 Verifiable CPD Points – SAIT AccreditedAbout the Presenter:Ruzel van JaarsveldRuzel 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.
Who this course is for:
Business Owners, Managers, Financial Staff, Accountants, Professional Individuals
Homepage