Course Outline
Online Core Product Training for AccountMate for SQL and Express
Course Outline
A. Installation
a. Installation Requirements
b. SQL Server Installation Configuration
c. SQL Server Installation Tips (Connectivity)
d. Installation Checklist
e. Installation Options
f. Installation Process
g. Installation Folders
h. AMSETUP.AM Configuration
i. Reinstall AccountMate
j. Most Common Installation Issues
B. Implementation Flow
a. Install AccountMate
b. Set Up and Configure Company
c. Set Up GL Module
d. Import Chart of Accounts
e. Import Beginning Balance JE Batch
f. Set Up Subsidiary Modules
g. Import Master Records
h. Import Subsidiary Modules Detail Beginning Balances
i. Perform Physical Inventory Count and Inventory Adjustment
j. Perform Period-End Closing
k. Configure Transfer Restrictions
C. Beginning Balance Setup
a. Financial Statement Balances
b. Inventory Balances
c. Customer Balances
d. Vendor Balances
e. Bank Account Balances
D. Conversion, Upgrade, and Update
a. Definition of Terms
b. Conversion Matrix
c. Conversion from Other Accounting Software
E. AccountMate Website (BP-specific)
A. Introduction
a. AccountMate Product Lines
b. Software Requirements
c. SM Flow Chart
B. Licensing
a. Activate Module
b. Install License File
c. Input Maintenance Key
d. Install PR Tax Subscription Key
e. Print License Info
C. Create Company
a. Company Setup
b. Install/Reinstall Sample Company
D. Set Up Groups and Users
a. Password Policy
b. Group/User Setup
c. Audit Trail
d. Database Connection
E. System Setup
a. Module Sequence
b. Menu Display
c. File Location
d. Error Report
e. Miscellaneous
F. Website
AccountMate Website and Resources
G. Hands-on Exercises
A. User Interface
a. AccountMate Menus
i. Utilities Functions
1. Custom Report
2. Print Batch
3. Print Label
4. Miscellaneous Code Listing
5. Fiscal Period Table Setup
6. Table Browser and Exporter
7. Data Manager
8. Error Log Viewer
9. Integration Event Log
10. Company Access Lock
11. Disconnect User
12. Workstation Setup
13. Cascade Window, Tile Window
14. Cut, Copy, Paste, Calculator
15. Check for Payroll Subscription Updates
ii. Help Functions
1. Help Contents
2. Search for Help on
3. Electronic Manual
4. Getting Started Guide
5. E-Learning
6. Sample Reports
7. Enhancement Request
8. Product Information
9. AccountMate Homepage
10. Vertical Solution Center
11. Forms and Checks
12. About AccountMate
b. System Toolbar/Power Toolbar
i. Change System Date
ii. Display Current Login User List
iii. Report and Printer Setup
1. Report Setup
2. Report Export/Email Setup
3. Report Default Printer Setup
iv. File/Windows
v. Calculator
vi. Executive Summary
vii. InfoTrac shortcut
viii. Access to Microsoft Office Applications Outlook, Excel, Word, Internet Explorer
ix. Window List
x. Change Password
xi. Change Login
c. Shortcut Pane
i. AccountMate Shortcuts
ii. Group Shortcuts
iii. Program Shortcuts
iv. Recent Documents
v. Internet Favorites
d. Hotkeys and Function Keys
e. Search Features
f. Report Features
B. System Overview
a. AccountMate as a Modular System
b. Set Up Base Modules
c. Set Up Extended Modules
d. Real Time vs Batch Processing
e. Module Dependencies
C. Hands-on Exercises
A. Introduction
GL Flow Chart
B. Set Up General Ledger
GL Module Setup
C. Create GL Account IDs
a. Segment Definition
b. Account Categories
c. Account Groups
d. Account Segment Values
e. Chart of Accounts Maintenance
f. Copy Chart of Accounts
g. Redefine GL Account Segment
D. Create Journal Entries
a. Journal Entry Transactions
i. Standard Journal Entry
ii. Prior Year-end Journal Entry
iii. Recurring JE Template
iv. Reversing Journal Entry
b. Import Journal Entry
c. Create JEs from Existing, Recurring, and Voided Batches
d. Post JE Batch to GL
e. Void Posted Journal Entries
E. Create Budgets
a. Budget Maintenance
b. Budget Reports
F. Run Reports
a. Financial Statement Drill Down Feature
b. Financial Reports (Balance Sheet and Income Statement)
c. GL Listing
G. Close Periods and the Fiscal Year
a. Period-End Functions
i. Batch Transfer Data to GL
ii. Batch Period-End Closing
b. Fiscal Year-End Closing
c. Posting Period Restrictions
H. Hands-on Exercises
A. Introduction
IC Flow Chart
B. Set up Inventory Control
IC Module Setup
C. Set up Master Records
a. Unit-of-Measurement
b. Warehouse
c. Inventory Type
d. Inventory
D. Record IC Transactions
a. Serial Number
b. Transfer Inventory
c. Internal Stock Issuance
d. Physical Inventory Count
e. Inventory Adjustment
E. Close the Period in IC
a. Transfer Data to GL
b. Period-End Closing
F. Hands-on Exercises
Set Up Master Record - Vendor Maintenance
A. Introduction
PO Flow Chart
B. Set Up Purchase Order
PO Module Setup
C. Set Up Master Records
a. Inventory Vendor
b. Inventory-Related Maintenance Functions
i. Inventory PO only
ii. Inventory Adjustment
D. Process Purchase Orders
a. Create Purchase Orders
i. Approve Purchase Quote
ii. Create PO by Vendor
iii. Create PO by Item
iv. Create PO by Sales Order
v. Create PO by Reorder Quantity
b. Import Purchase Orders
c. Release Blanket Purchase Orders
d. Receive Purchase Order
i. With accrual of obligation
ii. Without accrual of obligation
e. Receive Multiple Purchase Orders
f. Cancel Open Purchase Quote
g. Cancel PO Backorder
E. Record Landed Cost
a. Allocate Landed Cost
b. Accrue Landed Cost
c. Reverse Accrued Landed Cost
F. Close the Period in PO
Period-End Closing
G. Hands-on Exercises
A. Introduction
AP Flow Chart
B. Set Up AP Module
AP Module Setup
C. Set Up Master Records
Cash-book Related Maintenance Functions
a. Currency Code
b. Bank Account
c. Pay Code
D. Record AP Invoices
a. AP Invoice Transactions
i. One-Time Vendor
ii. With reversal of accrued obligation
iii. Without reversal of accrued obligation
iv. Debit invoice
b. Deferred Expense Invoice
c. AP Prepayment Transactions
d. Import AP Invoice
e. Recurring AP Invoice
f. Through Post Handwritten Check
g. Through Post Credit Card Billing
E. Authorize Payments
a. Apply Full Amount Automatically
b. Manual Apply Payment
c. Automatic Apply Payment
F. Issue Payments
a. Apply Prepayment
b. Print Computer Check
c. Process Electronic Payment
d. Post Handwritten Check
e. Post Credit Card Payment
f. Post Credit Card Billing
G. Close the Period in AP
a. Transfer Data to GL
b. Period-End Closing
H. Hands-on Exercises
Set Up Master Records
a. Cash-book Related Maintenance Functions
i. Currency Code
ii. Bank Account
iii. Pay Code
b. Revenue Related Maintenance Functions
i. Revenue Code
ii. Salesperson
c. Inventory Related Maintenance Functions
i. Inventory Type
ii. Inventory AR/SO only
iii. Substitute Item
d. Customer Maintenance
e. Other Maintenance Functions
i. Sales Tax Entity and Code
ii. Freight Code
iii. Activity Type and Rights
iv. System Remark
A. Introduction
SO Flow Chart
B. Set Up Sales Order
SO Module Setup
C. Process Sales Orders
a. Create Sales Orders
i. Approve Sales Quote
ii. Create Sales Order
iii. Copy SO
iv. Copy Lost SO
v. Import Sales Order
vi. Recurring Sales Order
vii. Release Blanket SO
b. Ship Sales Order
c. Create Advanced Billing
d. Cancel Open Sales Quote
e. Cancel SO Open Order
f. Cancel Shipment
D. Close the Period in SO
Period-End Closing
E. Hands-on Exercises
A. Introduction
AR Flow Chart
B. Set Up Accounts Receivable
AR Module Setup
C. Process AR Invoices
a. Ship SO Generate Invoice
b. Approve Advanced Bill
c. Create Invoice
d. Generate Invoice from Shipment
e. Recurring Invoice
f. Import Invoice
D. Process Returns
a. Sales Return Without Invoice
b. Sales Return With Invoice
E. Amortize Revenue
a. Revenue Amortization
b. Schedule Revenue Realization
c. Realize Revenue
d. Reports
F. Record Payments
a. Apply Payment
i. Receipt
ii. Non-Customer Payment
iii. Open Credit
iv. Adjustment, Discount, Write-off
b. Process Electronic Payment
c. Adjust Open Credit
d. Apply Finance Charge
G. Record Bank Deposit Transactions
a. Record Bank Deposit
b. Regenerate ACH File
c. Verify Bank Deposit
H. Close the Period in AR
a. Transfer Data to GL
b. Period-End Closing
I. Hands-on Exercises
A. Introduction
BR Flow Chart
B. Set up Bank Reconciliation
BR Module Setup
C. Set up Master Records
a. Cash-book Related Maintenance Functions
i. Currency Code
ii. Bank Account
b. Transaction Code
D. Record Cash Inflows and Outflows
a. Cash Inflows
i. Record Deposit
ii. Record Other Receipts
b. Cash Outflows
i. Record Check
ii. Record Other Disbursements
c. Record Bank Transfers
d. Recurring Transactions
E. Import Bank Transactions
a. Import Bank Transaction Setup
b. Import Bank Data Converter
c. Import Bank Transactions
F. Reconcile Bank Accounts
Reconcile Bank Account
G. Generate Positive Pay File
a. Set Up Positive Pay
b. Generate Positive Pay File
H. Project Cash Flow
Projected Cash Flow
I. Close the Period in BR
a. GL Transfer Report
b. Period-end Closing
J. Hands-on Exercises