Course Outline

Online Core Product Training for AccountMate for SQL and Express


Course Outline


I.              Installation and Implementation (Solution Providers-Only Session)

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)



II.            System Manager – Part I (System Administrator)

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



III.          System Manager – Part II (User Interface)

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



IV.          General Ledger

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



V.            Inventory Control

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



VI.          AP/PO Master Record (Required for AP and PO sessions)

Set Up Master Record - Vendor Maintenance



VII.        Purchase Order

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



VIII.      Accounts Payable

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



IX.          AR/SO Master Records (Required for AR and SO sessions)

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



X.            Sales Order

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



XI.          Accounts Receivable

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



XII.        Bank Reconciliation

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


FaceBook LinkedIn Twitter YouTube