BOOKKEEPING POWER PACK SELF-STUDY PACKAGE
BOOKKEEPING Power Pack Online Self-Study Package
50% Discount LIMITED Special R 2 900.00 For 10 Course Package
Normal Price is R 5 800.00
Who is the BOOKKEEPING POWEPACK for?
For individuals, entrepreneurs, financial administrators, personal assistants, and bookkeeping staff who need to gain understanding of how the “books of account” are designed and integrate into business, leading ultimately into the Financial Statements, as well as gain a solid background of Financial Administration, VAT procedures and the learning of Excel
BASIC ACCOUNTING TO TRIAL BALANCE
- Basic Bookkeeping and Accounting Terminology
- Why you need bookkeeping
- Accounting Cycle
- Source Documents
- Books of First Entry
- Chart of Accounts
- Audit Trails
- Trial Balance
- Income Statement
- Balance Sheet
- Depreciation/Amortisation
- Compound Interest
- Prepayments
- Accruals and Provisions
- Journals
- Reconciliations
- Month/Year End Close of
- Annual Financial Statements
ACCOUNTS PAYABLE PROCESSING
- Why is Account Payable important, and how it adds value to your business
- Key Accounts Payable Controls
- Processes, systems and procedures
- Organizational Accounts Payable Policy
- Year-end reporting requirements
- Methods of ensuring consistency with your Accounts Payable functions
- Processing Methods
- Accounts Payable management reporting tools
- Data Capture, workflow processes and document control management
- Electronic invoices, purchase orders and shipping documentation
- Transactions from initiating purchase order to completing invoice payment
- Simplifying standard internal procedures
- Accruals & Provisions - to effectively use methods during close-off periods
- Streamline management reports and reducing unnecessary information
- Year-end close-offs & the importance of a check list
- Reconciling your Accounts Payable accounts
- How to prevent duplicate payments
- How to reduce unallocated payments
- Your filing system - ensuring your information is ready for your auditors
- Vendor information you are required to have
- Procurement policies and procedures with overview
FINANCIAL ADMINISTRATION
- Department of Labour – When and How to register and for what
- UI-8 – What this form is for and what to do with it
- UI-19 – What this form is for and what to do with it
- Staff Files – Relevant documents needed to keep in a staff file
- Staff Payslips – When to supply an employee with a payslip and what information is needed to include
- Staff Leave – How staff leave works and how to calculate unpaid leave
- Leave – How annual leave works and how to calculate to pay out
- Workmen’s Compensation – When to register for Workmen’s compensation, and how it works
- Personal Income Tax – The company’s responsibility in terms of staff personal income tax as well as informing staff of their responsibility to submit their own income tax
- SETA – How to register under the applicable SETA and what are the benefits
- ETI Rebate from SARS – To qualify and benefits of this rebate?
- PAYE, UIF & SDL – Relevant deductions from staff salaries and submissions to SARS. (EMP201 Submissions)
- IRP5’s and IT3’s – Issuing of IRP5’s and IT3’s and when required (EMP501)
VAT 3 SESSION SERIES
SESSION 1 - VAT REGISTRATION AND CATEGORIES
- Registrations - Supporting Documents and Forms to fill in
- VAT Categories
- How to fill in the VAT201 form
- Invoices - what are they supposed to look like?
- E-Invoices - how am I supposed to store them?
- Connected Persons
- Accrual Basis / Invoice Basis compared to Payment Basis
- The 10-Day Rule
- Exceptions to the general time and value of supply
SESSION 2 - VAT INPUT TAX CREDIT
- Time and Value of supply
- Progressive, successive and periodic supplies
- Fringe Benefits
- Installment Sale Agreements
- Commercial Accommodation
- Consideration only partly for a taxable supply
- Standard Rated Supplies
- Zero Rated Supplies
- Exempt Supplies
- Entertainment
- Travel Reimbursement
- Expense Reimbursement
- International Travel
- Exports
- Selling a business as a going concern
- Municipal Rates
SESSION 3 - VAT INTERMEDIATE
- Diesel/Biodiesel Refund System (Application and General Conditions & procedures relating to purchases of diesel/biodiesel and refunds)
- Foreign Suppliers of Electronic Services
- Entertainment
- Accommodation (Commercial, Employee housing, Residential, Holiday Homes)
- Property Developers
- Agent vs Principal
- Associations not for Gain and Welfare Organisations
EXCEL 4 SESSION SERIES
SESSION 1 - INTRODUCTION TO EXCEL/FIRST TIME USER
- Introduction
- Terminology
- Layout and interface
- Move or copy sheets
- Status Bar
- Print Preview and set print area o Formatting data (changing appearance) and format Painter
- Various ways to Paste data
- How Windows Regional Settings may affect your Excel
- Recovering Lost Documents and using the auto-save function
- Built-in Templates - Exploring pre-created templates, e.g.
- Budgets
- Expense tracker
- Invoices
- Navigating Seamlessly
- Freeze panes
- Quick access toolbar
- How to navigate without a mouse
- Line breaks
SESSION 2 - EXPLORING AND CREATING FORMULA
- Building Formulas
- Exploring available library of formulae within Excel
- Cell referencing within formulas i.e. relative and absolute references
- Mathematical operators within Excel
- Duplicating (dragging) formulas without retyping
- Reviewing formulas
- Flash fill (Excel 2013 and later only)
- Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV.
SESSION 3 - DATA FILTERING, SORTING, SEARCHING EDITING AND EXTRACTION
- Data Editing
- Sorting
- Filtering
- Conditional formatting
- Data validation
- Subtotal formula
- Find and replace
- Data Searching
- Searching within filter
- Searching within sheet
- VLookUps
- CountIf formula
- If statements
- Basic Data Extraction
- Flash fill
- Text-to-Columns
- Concatenate
SESSION 4 - PIVOT TABLES, TABLES, GRAPHS AND CREATING VISUAL REPORTS
- Tables and Graphs
- Quick analysis
- Pivot tables
- Charts