Description
Table of Contents
Manual Module
- The Manual Accounting Information System
- Transaction Set A
- Chart of Accounts
- Price List
- Supporting Documents
- General Journal
- Sales Register
- Cash Receipts Journal
- Purchases Journal
- Cash Disbursements Journal
- Payroll Journal
- Accounts Receivable Subsidiary Ledger
- Perpetual Inventory Subsidiary Ledger
- Accounts Payable Subsidiary Ledger
- Employee Payroll Subsidiary Ledger
- Fixed Asset Subsidiary Ledger
- General Ledger
- Transaction Set B
- Transaction Set C
Computerized Module
Spreadsheet Applications Using Microsoft® Excel 2016
- Learning Objectives
- Background
- Download the File
- Protecting the Data
- Formula Auditing
- Data Integrity
- Simple Data Analysis
- What-If Analysis
- Information Needs
- Macros
- More Advanced Macros
- Database Functions
- Introduction to PivotTable Reports
- Detail in Reporting
- Flexible Budgeting Using PivotTables
- Creating Charts From PivotTables
- Wrap-Up
General Ledger Applications Using Sage 50® 2018
- Learning Objectives
- Requirements
- Setting Up a New Company
- Setting Up the General Ledger
- Setting Up Beginning Account Balances
- Setting Up User Security
- Setting Up Accounts Receivable
- Setting Up Accounts Payable
- Setting Up Inventory
- Setting Up Payroll
- Entering Transactions
- Transaction Set A
- Month-End Procedures
- Year-End Procedures
- Transaction Set B
- Transaction Set C
Database Applications Using Microsoft® Access 2016
- Learning Objectives
- Background
- Requirements
- Creating a New Database and New Table
- Creating a Form
- Ensuring Sequential Integrity
- Creating Relations
- Integrating Forms within Forms
- Creating a Query
- Creating a Report
- Summary
Assurance Module
- Client Acceptance
- Understanding the Business Environment
- Identification of Audit Tests for the Expenditure Cycle
- Selection of Audit Tests and Risk Assessment for the Expenditure Cycle
- Performance of Audit Tests for the Revenue Cycle
- Completing the Audit