Questionnaire for The Accounting Library, Standard Edition Version 4.7
This Questionnaire contains approximately 1850 questions that are to be scored
in the ranking and selection process.
NOTE: This file is a plain text file and has been formatted using spaces
for alignment rather than proportional type with tab stops, etc.
It was felt that this is the least common denominator for the
wide audience for which it is intended. For best results, load it
into your favorite word processor as PLAIN ASCII text then set the
base font to Courier or some other font with fixed spacing.
The Itemized Needs Definition Checklist has been designed to serve as a
preliminary worksheet prior to defining your needs or those of your client
in the analysis program. Each module has been broken down into logical
processing areas. As an example the General Ledger questions are broken
into sub-sections relating to the Chart of Accounts, Transaction Processing,
Month and Year End Closing, Control Reports, and Financial Statements.
Your objective is quite simple. Pick and choose from this list of features,
functions, and reports, and build as comprehensive a definition of your
or your client's accounting needs as is appropriate.
The guidelines listed below should be followed in order to complete the
Itemized Needs Definition accurately and with minimum confusion:
1. As the example below illustrates, each section of the Needs Definition
form indicates both the module and the processing area. Some questions
stand by themselves, while others are a part of a larger group of
questions. In the example below, the "... Post to General Ledger :" is
the general question, while the two items following are the more detailed
questions.
General Ledger / Month and Year End Closing
2. If users are unsure as to the exact definition of any feature, function,
or report listed in the questionnaire, please refer to the associated Help
Files in the analysis program. If we are running the analysis for you
as a service, this is the most severe limitation to this approach. In
most instances, if you do not understand the question, you probably do
not need that function.
3. If a feature, function, or report is of no interest at all, skip it and
proceed to the next question.
4. If a feature, function, or report is of interest, indicate the degree
interest with a weighting factor from "1" indicating a low and "9"
(Critical) in the position provided. Remember to use 9's sparingly
as TAL rejects all systems that do not have the feature covered by
the 9 you are using. We suggest that you weight features you really
need with 8's and reduce the weighting of all other less significant
questions.
5. If numerical values are utilized at this stage, spend some time in
advance deciding exactly what a value of "1" or "3" or "6" etc. means.
Using the whole range of values can improve the accuracy of the
analysis, but may become somewhat confusing as users proceed with the
questionnaire.
6. Once the questions are weighted, we suggest that you load the questions
into a word processor and do a search on "underscore" "space"
(2) characters. This will make your word processor stop at the points where
the answers belong.
General Ledger \ Chart of Accounts
_ Industry Specific Charts of Accounts
_ User Defined Segment Lengths
_ Copy Range of Accounts to New Reporting Units
_ User Defined Account Ranges
* Copy Chart of Accounts to New:
_ Department
_ Profit Center
_ Company
* G/L Account Code Supports:
_ Active Accounts
_ Inactive Accounts
_ Allocation Accounts
_ Statistical Accounts
* Allocation Account Processing:
_ Single Allocation
_ Waterfall to Other Allocation Accounts
_ Percentage Allocation
_ Dollar Allocation
* Allocation Formulas Based Upon:
_ G/L Financial Accounts
_ Statistical Accounts
_ Supports Multiple Account Levels
_ Segregates Subsidiary Schedules
General Ledger \ Transaction Processing
* Supports Batch Layout Configurator for:
_ Header Record
_ Detail Lines
_ Move Fields
_ Add Fields
_ Delete Fields
_ Modify Field Size
_ Attach Notes Record to Existing Field
_ Import Batch from Outside Application
_ Checks Validity of Batches from Sub-Modules
_ Holds Invalid Sub-Module Batch in G/L as Unposted
_ Post One-Sided Journal Entry by Password
_ User Defined Journals
_ Automatic Journal Entry Numbering
* Supports Unlimited Note Fields for:
_ Batch Header Record
_ Each Line
_ Number Each Journal Entry Line
_ Line Item Reference Numbers
_ Journal Entry Templates
_ Recurring Journal Entries Each Month
_ User Defined Cycles for Recurring Transactions
_ Automatic Reversing Journal Entries
_ User Defined Reversing Period
_ Generates Balancing Entry Automatically
_ Distribute Costs by User Defined Formulas
* Distribute Costs to Jobs/Projects:
_ In General Ledger
_ In Job/Project Module
_ Post to Phases and Cost Categories
_ Running Total of Debits and Credits
_ Validates Posting Date
_ Supports Provisional Posting
_ Post to Prior Periods
_ Post to Future Periods in Same Fiscal Year
_ Post to Future Periods in Future Fiscal Year
* Corrects Transactions in Posted Batches by:
_ Reversing Batch Automatically
_ Copy to New Batch for Manual Adjustment
_ Full Bank Reconciliation Functions
_ Full Treasury Management Functions
_ Full Cash Management Functions
General Ledger \ Month and Year End Closing
_ Single Period Accounting Only
_ Multiple Open Periods
_ User Defined End of Period Date
_ Final Period Dedicated to Closing
_ Close Each Module Separately
* Post to General Ledger:
_ In Summary
_ In Detail
* Trial Balance Format:
_ Summary
_ Detailed
_ Journal Entry Work Sheets
_ System Flags Reports Not Printed
* Clear Posted Transactions in Sub-Modules:
_ Automatically at Period End
_ User Defined Purge
_ Temporary Year End Closing
_ Post Net Income to Multiple Equity Accounts
General Ledger \ Control Reports
_ Batch Control Report
_ Transactions Registers
* View/Print Transaction Register by:
_ Transaction Date
_ Date Range
_ General Ledger Account Number
_ User ID
* Drill Down to Original Transaction:
_ Displays Basic Transaction Source
_ Displays Original Transaction in Detail
_ Displays Offsetting Entry or Entries
_ Cash Receipts Journal
_ Cash Disbursements Journal
_ Sales Journal
_ Purchase Journal
General Ledger \ Financial Statements
_ Print Financial Statements to Screen
* Financial Snapshots:
_ Displays Single Set of Financial Snapshots
_ User Defined Financial Snapshots
_ Create Multiple User Specific Snapshots
_ Incorporate Information from Sub-Modules
_ Displays Information Graphically
_ Consolidate Multiple Companies
_ Consolidate Different Charts of Accounts
_ Consolidate Partially Owned Companies
_ Supports Account Masking
_ Checks Validity of Consolidation
_ Eliminate Inter-Company Transfers
_ Group Profit Centers
* Produce Financial Statements for:
_ Departments
_ Product Lines
_ Sales Representatives
_ Regions
_ Cost Centers
_ Projects/Jobs
_ Produce Management Accounts
* Summary Standard Financial Reports:
_ Balance Sheet
_ Income Statement
* Detailed Standard Financial Reports:
_ Balance Sheet
_ Income Statement
_ Monthly Financial Statement
_ Year To Date Financial Statement
_ Quarterly Financial Statement
* Comparative Income Statement:
_ This Month Versus Last Year
_ Year to Date Versus Last Year
_ Year to Date Versus Budget
_ Variance Analysis
_ Variance Expressed as Percentage
_ Variance Expressed as Dollars
* Comparative Balance Sheets:
_ This Month Versus Last Year
_ Year to Date Versus Last Year
_ Year to Date Versus Budget
_ Variance Analysis
_ Percentage
_ Dollars
_ Print Balance Sheet for any Reporting Unit
* Budget Reports:
_ YTD vs Budget: Current + Last Five Years
_ Project Year End Based on YTD Actual
_ Modify Projected Year End Estimate
_ Calculate YTD as Percentage of Annual Budge
_ 12/13 Column Period Reports
_ Print any Range of Consecutive Months
_ Percentage of Revenue Calculation
_ Cash Flow Analysis
_ Working Capital Analysis
_ Changes in Financial Position
_ Ratio Analysis
* General Ledger Month End Schedules:
_ Amortization
_ Depreciation
_ Prepaid Expenses
_ Accrued Expenses
Accounts Payable \ Vendor Master File
_ Departmental/Divisional Accounts Payable Files
_ Supports One Time Vendors
_ Automatically Assigns New Vendor Number
_ Supports User Defined Numbering Convention
_ Identifies Vendor Type
_ Supports Foreign Addresses
* Supports Contract Employees:
_ Process Through Accounts Payable
_ Process Through Payroll
* Vendor Master File Supports:
_ Single Order-From Contact
_ Multiple Order-From Contacts
_ Single Ship-From Contact
_ Multiple Ship-From Contacts
_ Multiple Pay-to Contacts
_ Supports Multiple 1099 Codes per Vendor
_ Non-Print 1099 if Below Minimum Value
_ Payment to Third Party
* Quick Purchase Review:
_ Outstanding Balance
_ Last Check Date
_ Check Amount
_ Invoices Paid
_ Last Purchase Date
_ Last Purchase Amount
_ Purchases This Year
_ Purchases in Previous Years
_ Single Default Expense Account
_ Multiple Default Expense Accounts
_ Default Percentage Distribution
* User Defined Blanket Payment Terms:
_ Due Date
_ Discount Date
_ Discount %
_ Tax Rate
* User Defined Individual Payment Terms:
_ Due Date
_ Discount Date
_ Discount %
_ Tax Rate
_ Primary Contact
_ Comment Field
* Vendor Contact Manager:
_ Unlimited Notes by Date and User
_ Call Back Scheduling
_ Stores all Applicable Documents
_ User Defined Vendor Master Fields
Accounts Payable \ Purchasing Controls
_ Supports Purchase Order Control System
_ Supports External Requisition System
_ Supports Internal Requisition System
_ Order Supplies from Vendor Catalogue
_ Service Contract Orders
_ Blanket Orders
_ Recurring Orders
_ Define Cycle Dates for Recurring Orders
_ Proforma/RFQ Orders
_ Maintains Listing of Qualified Vendors
_ Conversion of Proforma/RFQ Order
* Sends Tax Exempt Forms Automatically to:
_ New Vendors
_ Existing Vendors as Requested
_ Route System Generated POs to Buyers for Action
* Automatic Purchase Orders:
_ User Defines Order Price Ceiling
_ User Defines Items Not Requiring Approval
_ Defaults to Best Quantity Price Break Point
* Displays Purchase Order Status for:
_ System Generated Orders Awaiting Action
_ Manual Requisitions Awaiting Action
_ RFQs Awaiting Vendor Responses
_ Orders Approved
_ Orders Rejected
_ Maintains Rejection Codes or Reason Fields
_ Lists Suggested Orders Sorted by Vendor
* Automatically Displays Item Status Information:
_ On Hand by Location
_ Open Sales Orders by Location
_ Open Purchase Orders by Location
_ Last Price by Location
_ Minimum Safety Stock
_ Maximum Stock Limit Quantity
_ Economic Order Quantity by Location
_ Systems Calculates Suggested Order by Location
_ Sorts Suggested Orders by Priority
_ Highlights Stock-Out Items
* Automatically Displays Vendor/Item Information:
_ Primary Vendor
_ Vendor Part Number
_ Item Pricing at Quantity Required/Suggested
_ Requested or Normal Reorder Quantity
_ Minimum Order Quantity
_ Price Break Quantities
_ Automatically Toggle to Alternate Vendor(s)
_ Automatic Numbering
_ Multiple Ship to Addresses
_ Multiple Ship to on Same Order
_ Multiple Ship to for Same Item
_ Multiple Purchase Addresses
_ Order Contact Person
_ Free Form Special Instruction Fields
* Purchase Discounts Supported:
_ Item Order Quantity Discount
_ Item Order Dollar Discount
_ Total Order Dollar Discount
_ Annual Item Volume Contract
_ Annual Dollar Volume Discount
_ Group Similar Items into Single Discount Category
_ Unit of Measure Conversion
_ Listing of Alternate Items/Vendors
_ Restrict Orders Above a Specified Price Range
_ Prevents Alteration of Unit Cost
_ Set Not-to-Exceed Price Limits
_ Restricts Orders From Specified Vendors
_ Automatic Creation of New Inventory Items
_ Prints Vendor Part Number on Purchase Order
_ Print Required By Date Per Line Item
_ Assign Cancel By Date per Line Item
_ Supports Dropped Ship Purchases
_ Alter Outstanding Purchase Order
Tracks Status of Open Purchase Orders
* Segregate Open PO Items by Status Code:
_ Expected Arrival Date Exceeded
_ O/S/D Status
_ Expedite Status
_ Exceptional Value
* Place Hold on Open PO Automatically if:
_ Expected Arrival Date Exceeded
_ Cancel Date Exceeded
_ Hold Placed on Vendor
_ Set Tolerance for Quantity Ordered/Received
_ Close Purchase Order Short
_ Match Purchase Order to Invoice
_ Verification of Material Receipt on Purchase Order
_ Automatically Reports Discrepancies
_ Hold Invoice Pending Approval
_ Verification of Quoted Cost to Actual Cost
_ Verification Against Duplicate Invoice
_ User Defined Vendor Performance Criteria
_ Automatic Tracking of Vendor Performance
_ Display Vendor Catalogues
_ Automatic Order Placement from Vendor Catalogues
_ Create Material Requisitions for Internal Transfer
_ Maintains Full Purchase Order Audit Trail
Accounts Payable \ Data Input
_ Forces Balanced Transactions
_ Automatic Processing of Prepaid Expenses
_ Define Start/End Dates for Expensing Prepaids
_ Post to G/L Prepaid Account Only When Paid
_ Automatic Processing of Accrued Expenses
_ Automatic Amortization Scheduling
_ Carries Prepaid, etc. into New Year
_ Assigns Voucher Numbers Automatically
_ Override Invoice Date as Posting Date
_ Restricts Discounts by Line Item
* Post Discounts Earned to:
_ General Ledger Discount Account
_ Line Item Cost
_ Multiple Distribution of Expenses
* Input Job/Project Costing Details:
_ Job/Project Number
_ Phase Number
_ Cost Category
* Input Inventory Details:
_ Item Number
_ Quantity Ordered
_ Quantity Received
_ Input Products and Services in Same Routine
_ Automatic Segregation of Freight Charges
* Prorate Freight Charges:
_ To Expense Account
_ Prorate to Each Item
_ Automatic Segregation of Sales Taxes
* Prorate Sales Tax:
_ To Expense Account
_ Prorate to Each Item
_ Schedule Invoice Payment Over Time
_ Restricts Invoice Amount
_ Prevents Alteration of Unit Cost
_ Automatic Payment of Recurring Invoices
_ Automatic Posting of Loan Principle and Interest
_ 1099 Backup Withholding
_ Hand Written Check Posting
_ Free Form Field to Describe Invoice
_ Automatic Deletion of Invoice and Expense Account
Accounts Payable \ Payables Analysis
_ Supports Offsetting Entries Between A/P and A/R
_ Automatic Account Aging
_ Aging Based Upon Discount Date
_ User Defined Aging Criteria
_ Payment Scheduling by Discount Date
_ Payment Date Based on User Defined Payment Cycle
_ Prompts for Excessive Payment Delay
_ Automatic Calculation of Discount
_ Review and Modify Calculated Discounts
_ Reinstate Discount After Expiration Date
_ Part Pay Invoice for Partial Receipt
* Screen Review of Invoices Which Are Due:
_ By Vendor
_ By Invoice
_ By Voucher
_ By Due Date
_ Display of Cash Available
_ Past Due Payables Report
_ Suspend Recurring Payments
_ Clear Payment Schedule
* Automatic Recalculation of Payment Schedule:
_ Users Specified Total Payment
_ User Specified Percentage Reduction
_ Alter Due Dates
_ Exclusion of Specified Invoices
_ Partial Payment of Specified Invoices
_ Select Specific Invoices
_ Select Specific Vendors
* Manual Selection of Payments:
_ Specific Invoices
_ Specific Vendors
_ Assign Payment Priority by Vendor
_ Put Vendor on Hold
_ Pay Invoices Which Are Not on File
_ Supports Invoice Adjustments After Check Printing
_ Automatically Deducts Adjustment in Next Check
Accounts Payable \ Check Writing
_ Supports Multiple Checking Accounts
_ System Printed Check
_ Prints Manual Checks
* Check Formats Supported:
_ Laser Checks
_ MICR
_ EDI
_ EFT (Electronic Funds Transfer)
_ Automatic Assignment of Check Number
_ Manual Assignment of Check Number
_ Check for Duplicate Check Number
_ Manual Check Cost Distribution
_ Pay Multiple Invoices With One Check
_ Print Check Details on More Than One Check Stub
_ Print Separate Check Remittance Advice
_ Sales Tax Payment
Voided Checks
_ Void Check Automatically Reinstates Transactions
_ Prints Facsimile Checks
_ Prints Message on Check Stub
_ Check Register Before Printing
_ Full Bank Statement Reconciliation
Accounts Payable \ Control Reports
_ Invoice Summary
_ Transaction Register
_ Sort Transaction Register by GL Account
_ Sort Transaction Register by Transaction Type
_ Sort Transaction Register by Vendor
_ Vendor Master Changes
_ Credit, Debit, and Cancellation Report
Accounts Payable \ Financial Reports
Vendor List
* Receiving Report:
_ Actual Receipts
_ Actual Receipts Sorted by Date (History)
_ Actual Receipts Sorted by Receipt Type
* Open Purchase Orders Sorted by:
_ Buyer
_ Inventory Item
_ Job/Project
_ Backordered Sales Orders
_ Production Work Order
* Unvouchered Receipts Sorted by:
_ Vendor
_ Inventory Item
* Cash Requirements Report:
_ Sort by Due Date
_ Sort by Discount Date
_ Print Total Discounts Available
_ Include All Obligations
_ Summarize by Obligation Type
_ Aged Accounts Payable Report
_ Period End Check Register
* Purchase Journal Sorting:
_ Vendor
_ General Ledger Code
_ Inventory Item Number
_ Job Number
_ Buyer
* Purchase Comparisons:
_ Previous Period Versus Last Year
_ Year to Date Versus Last Year
_ Previous Period Versus Budget
_ Year to Date Versus Budget
_ Discounts Lost
_ Discounts Earned
_ 1099 Reports
* Vendor Analysis Report:
_ All Transactions
_ Purchase History This Year
_ Purchase History Previous Years
* Purchase Price Variance Analysis by:
_ Vendor
_ Inventory Item
* Statistical History Reports:
_ Summary for Multiple Time Periods
_ Summaries Cut Across Multiple Years
_ Purchase Orders Written
_ Normal Restock Purchase Orders
_ Stock Out Purchase Orders
_ Production Work Order Purchase Orders
_ Invoices Processed
_ Average Invoice Value
_ Invoices Paid on Time
_ Invoices Paid Late
_ Invoices Paid on Time as % of Total Invoice
Accounts Receivable \ Customer Master File
_ Divisional Accounts Receivable
_ Open Item Customers
_ Balance Forward Customers
_ Automatically Assigns New Account Number
_ Supports Order By, Ship to, Paid by Addresses
_ Sort Customer List Alphabetically
*
_ Supports Foreign Addresses
_ Supports COD Customers
_ Tracks Specific COD Terms
_ Supports Occasional Customers
_ Multiple Ship to Addresses
_ Record Delivery/Handling Instructions
_ FOB Terms
* Assign Freight Carrier:
_ Single Freight Carrier per Customer
_ Separate Freight Carrier per Ship to Addres
_ Stores UPS Zone Code
_ Ship Complete Only Notation
_ Item Substitution Notation
_ Identifies Customer Type
_ Default Revenue Code
_ Set Individual Credit Limits
_ Set Blanket Finance Charges
_ Set Individual Finance Charges
_ Set Individual Sales Discount
_ Set Blanket Payment Terms
_ Set Individual Payment Terms
_ Tracks Customer Payment History
_ Calculates Credit Rating Automatically
_ Segregate Customers by Payment History
* Quick Payment Review:
_ Last Invoice Number
_ Last Invoice Date
_ Invoice Amount
_ Last Payment Date
_ Check Number
_ Amount
_ Average Collection Period
_ Percentage On Time Payment
_ Years as a Customer
_ Primary Contact
_ Primary Contact Telephone Number
_ Sales Account Representative
_ Collections Representative
_ Statement Options
_ Record Exemption ID's for Non-Taxable Customers
_ Comment Field
* Customer Contact Manager:
_ Unlimited Notes by Date and User
_ Call Back Scheduling
_ Store all Applicable Documents
_ User Defined Customer Master Fields
Accounts Receivable \ Invoicing
_ User Designed Invoices
_ User Designed Statements
_ Automatic Invoice Numbering
_ User Defined Invoice Numbering
_ Automatic User Defined Invoice Numbering
_ Assign Posting Date/Period vs. Invoice Date
* Automatic Billing of Recurring Invoices:
_ Monthly
_ Variable
_ Future Due Invoicing
_ After the Fact Invoicing
_ Automatic Credit Check
_ Overdue Account Flag
_ Input Reference Number on Invoice
_ Override Default Payment Discount Terms
_ Credit Invoice to Job
_ Line Item Credit to Single G/L Account
_ Line Item Credit to Multiple G/L Accounts
* User Defined Description Codes:
_ Products
_ Services
_ Multi-Line Billing Code Descriptions
_ Free Form Invoicing
_ User Defined Messages
_ Multiple Sales Tax Reporting
_ Line Item Default Tax Coding
* Credit Cost of Goods Sold by:
_ Line Item
_ Inventory Item
_ Revenue Code
_ Customer Code
_ User Override
_ Automatic Calculation of Sales Tax
_ Posts Sales Tax Liability to General Ledger
_ Posts Sales Tax Liability to Accounts Payable
_ Segregates Freight Charges
_ Calculates Freight Charges Automatically
_ Automatic Calculation of Discounts
_ Supports Multiple Page Invoices
_ Prints Multiple Copies Automatically
_ Real Time Automatic Inventory Adjustments
_ Supports Debit and Credit Memos
_ Supports Reason Codes for Debit/Credit Memos
_ System Prevents Excessive Credit Memos
_ Mailing Labels
_ Supports Financing Plans
_ Prints Contract Payment Books
Accounts Receivable \ Cash Receipts
_ Supports Automatic Bank Debit
_ Supports Unidentified Receipts Processing
_ System Displays all Outstanding Invoices
_ Credit Payment to Multiple Open Items
_ Includes Open Credits Automatically
_ Credit Payment to Oldest Invoice First
* Credits Payments to O/S Finance Charges:
_ Automatic Based on Invoice ID Input
_ User Can Override
* Supports Variable Payment Terms:
_ Revolving
_ Fixed
_ Time Based
* Supports Less Than Full Payment:
_ Discounts
_ Partial Payments
_ Supports Prepayment
_ Calculate and Retain Overpayments
_ Prints Overpayment Checks and Refunds
_ Write off Small Amounts
_ Reinstate an Invoice for Insufficient Funds
_ Automatic Charge for Returned Checks
_ Automatic Notation of Bad Checks
_ User Defined Purge of Paid Invoices
_ Prints Deposit Slip
Accounts Receivable \ Debt Collection
_ Specific Debt Collection Program
_ Aging Schedule Based Upon Actual Date
_ Aging Schedule Sorted by Collections Representative
_ Aging Schedule Mirrors Payment Terms
_ User Defined Aging Criteria
_ Summary Aging Report
_ Detailed Aging Report
_ Screen Display of Customer Account
_ Screen Display of Customer Overdue Accounts
_ Print Range of Customer Accounts
_ Print Statements Only for Overdue Accounts
* Automatically Send Statements Electronically:
_ FAX
_ E-Mail
_ Non-Print Statement if Below Threshold
_ Aged Receivables Sorted by Age
_ Statement Messages
_ Holds Invoices Which Are in Dispute
_ Credit Exception Reporting and Analysis
_ Multiple Page Statements
_ User Defined Statement Cycle
_ Automatic Calculation of Finance Charges
_ User Override of Finance Charges
_ Compounding of Finance Charges
Accounts Receivable \ Control Reports
_ Invoice Summary
_ Transaction Register
_ Sort Transaction Register by General Ledger Account
_ Sort Transaction Register by Transaction Type
_ Customer Master Changes
_ Credit and Cancellation Report
Accounts Receivable \ Financial Reports
Customer List
* Detailed Customer Transaction Report:
_ All Transactions
_ Year to Date
_ Each Month
* Sales Analysis by:
_ Customer
_ Customer Category
_ Product
_ Sales Representative
_ Region
_ Department
_ Store
* Gross Profit Analysis by:
_ Customer
_ Customer Category
_ Product
_ Sales Representative
_ Region
_ Department
_ Store
* Gross Profit Expressed as:
_ Dollar
_ Percentage of Revenue
* Trend Analysis by Revenue Type:
_ Yearly Basis
_ Monthly Basis
* Cash Flow Forecast:
_ By Due Date
_ By Discount Date
_ By Average Payment Date
* Rank Customers by:
_ Dollar Volume
_ Gross Margin Dollars
_ Gross Margin Percentage
_ Fully Allocated Net Profit
_ Special Sales Reports
_ Monthly Sales Tax Reports
_ Prints COD Tags and Labels
_ Dunning Letters
_ Court Writs
Payroll \ Employee Files
_ Restricts Access to Sensitive Files
_ User Defined Employee Master Fields
* Basic Employee Information:
_ Marital Status
_ Job Class
_ Date of Hire
_ Date of Review
_ Termination Date
_ Date of Last Check
_ Tracks Citizenship Information
_ Automatic Assignment of Employee Number
_ User Defined Numbering Convention
_ Assigns Default Department
_ Assigns Default Pay
_ Assigns Default Pay Cycle
* Pay Periods Supported:
_ Daily
_ Weekly
_ Bi-Weekly
_ Bi-Monthly
_ Monthly
_ Quarterly
_ 10 Pay Periods Per Year
_ 13 Pay Periods Per Year
_ Annual
_ Automatically Applies Scheduled Raises
_ Automatically Applies Cost of Living Adjustments
* Assigns Default Expense Distribution:
_ Normal Wages
_ All Wages and Benefits
_ Single Cost Account Only
_ Multiple Cost Accounts
_ Dollar Distribution Only
_ Percentage of Gross Pay
_ Supports Automatic Deductions
* Deduction Calculations:
_ Percentage
_ Lump Sum
_ User Defined
_ Deduct Meal Allowances
_ Credit Meal Allowances
_ Record, Track, and Deduct Advances
_ Supports Local Union Benefit Reporting
_ Supports Calculation of Employer Contribution
_ Process Short Term Deductions Over Specified Period
* Deduction Limit Management:
_ Set Minimum Fixed Dollar Earning
_ Set Deduction Limits
_ Set Deduction Minimums
_ Tracks Deductions as Non-Mandatory
* Tracks Accrued Sick and Vacation Pay:
_ Accrued Sick Days
_ Accrued Vacation Days
* Carries Over to New Year:
_ Vacation Days
_ Sick Leave
_ Sets Limits on Time Carried Forward
_ Automatically Offsets Sick Pay Received/Accrued
_ Calculates Employer FICA for Sick Leave
_ Prevents Accrual During Unpaid Leave
_ Accrues and Tracks Other Paid Leave
_ Tracks Workers Compensation Information
_ Supports Individual Savings Calculations
_ Supports Retirement Programs
_ Supports Additional Tax Withholding
_ Direct Deposit
* Vendor Provided Tax Tables:
_ Federal Withholding
_ State Withholding
_ Local Withholding
_ FICA
_ FUTA
_ SUTA
User Can Change Tax Tables
Supports Insurance Submissions
Segregates Active and Inactive Employees
Calculates Termination Pay Automatically
Payroll \ Data Input and Cost Distribution
_ Automatic Payroll Processing
_ Enter Payroll Checks Manually
_ After the Fact Payroll Processing
_ Accepts Payroll Data From Remote Terminals
_ Accepts Data From Time Clock
_ Supports Time Billing
_ Process Multiple Checks for One Employee
_ Multiple State/Province Processing
_ Multiple State/Province Processing for One Employee
_ Specify Pay Types to be Processed
_ Process Payroll More than Once per Week
_ Process Payroll for Selected Employees
_ Process Salaried Employees Automatically
_ Supports Tip Income Reporting
_ Supports Piece Rates
_ Wage Minimum Versus Tips or Piece Rates
_ Pay Rate Based on Work Performed
_ Automatic Processing of Temporary Upgrade
_ Pays Shift Differentials Automatically
* Supports Automatic Calculation of Commissions:
_ Gross Sales
_ Gross Margin
_ Flat Rate
_ Percent In Excess of Minimum
_ Manual Input of Commission Data
_ Supports Draw Against Earnings
_ System Prepared Worksheet
_ Input Hours Worked
_ Input Time Clock Data
_ Supports Military Time
_ Retain Hours Worked from Previous Week
_ Automatic Alert for Missing Time Cards
_ Hides All Pay Rate Fields
_ Calculates Overtime Automatically
_ Default to Normal Overtime Rates
_ User Defined Other Overtime
_ Pay Overtime to Salaried Employees
_ Reduce Tax Option for Miscellaneous Income
_ Checks User Defined Tolerances
* Assigns Cost to Multiple Destinations:
_ Hourly Employee
_ Salaried Employees
_ Departments
_ General Ledger Accounts
_ Job/Project Costing
_ Work Orders
_ Fixed Asset Repair/Maintenance
_ Assigns Employer Taxes to Multiple Destinations
_ Distribute Payroll Cost on a Percentage Basis
* Calculates Taxes Automatically:
_ Employer FICA
_ Workman's Compensation
_ Federal Unemployment
_ State Unemployment
* Post Deductions Automatically:
_ To Expense Account
_ To Liability Account (Not A/P)
_ To Accounts Payable
_ Pay Withholding and FICA From Payroll
_ Pays Federal Taxes Electronically
_ Repay Deductions from Payroll Module
Payroll \ Payroll Check Writing
_ Process Quick Checks
_ Pre-check Payroll Audit
* Print Checks by:
_ Department
_ Current Location
_ Alphabetically Sorted by Last Name
_ Pay Frequency
_ Flags Abnormal Checks
_ Flags Negative Checks
_ Prints Exception List for all Pay Rate Changes
_ Supports Approval Process Prior to Printing
_ Void or Reprint Selected Checks
_ Void Check With Auto Reverse
_ Void or Reprint W2 or 1099
_ Print W2 and 1099 After Year End
_ Prints Details of all Income and Deductions
_ Supports Direct Deposit
_ Prints Facsimile Checks
_ Prints Tax Withholding Checks
_ Payroll Check Reconciliation
Payroll \ Control Reports
Costing Reports
_ General Ledger Distribution Report
_ Hours Earnings Report
_ Commission Report
_ Deductions Register
_ Payroll Register
_ Check Register
_ Direct Deposit Report
_ Voided Checks
Payroll \ Financial Reports
* Employee List:
_ Summary
_ Detail
_ Prints Employee Mailing Labels
_ Employee Earnings Report
_ Departmental Payroll Report
* Payroll Cost Report Date Ranges:
_ Current Period
_ Year-to-Date
_ Current and YTD on Same Report
_ User Defined Date Ranges
* Other Payroll Reports:
_ Vacation Pay Report
_ Sick Pay Report
_ Employee Termination Report
_ Job Cost Report
_ User Defined W2
_ Magnetic Media W2
_ 940 and 941 Schedule Information
_ Unemployment Tax Reports
_ Workers Compensation Report
* Union Reporting:
_ Employee Membership Roster
_ Employee Contribution Deductions
_ Employer Obligations
_ Minority Hiring Report
_ Certified Payroll Report
_ Overtime Analysis
_ Vacation and Sick Leave Analysis
_ Detailed Vacation Planning Charts
_ Attendance Record
Payroll \ Human Resource Management
_ Payroll Benefits Administration
_ Candidate Tracking
_ Employee Tracking
_ Time and Attendance Administration
_ Training Administration
_ COBRA Administration
_ Employee Health and Safety
_ Employee and Labor Relations
_ Payroll/Benefits Budgeting
_ Supports Ad-Hoc Queries
_ Supports User Defined Employee H/R Fields
_ Customizable
Payroll \ Canadian Payroll Processing
_ Supports Registered Retirement Programs
* Vendor Provided Canadian Tax Tables:
_ Federal Income Tax
_ Quebec Income Tax
_ CPP
_ QPP
_ E1
_ Ontario Employee Health Tax
_ Quebec Health Insurance
* Canadian Payroll Reporting:
_ Prints T4's
_ Prints T4A's
_ Prints Releve1's
_ Remittance Report
_ Record of Employment
_ Receiver General Summary Report
_ RSP Contributions Report
Inventory \ Inventory Master File
_ User Defined Numbering Convention
_ Define Item ID by Item Characteristics
_ Change Item ID and Transactions
_ Supports Superseded Items
_ Combine Original and Superseded Item Histories
_ Multi-Line Item Descriptions
_ Supports Serial Numbering
_ Tracks Serial Numbers of Components
_ Supports Lot Tracking
_ Identify Customer(s) from Serial/Lot Number
_ Supports Multi-Dimensional Items
* Supports Bar Code Tracking:
_ Material Receipt
_ Translates Supplier Bar Code
_ Inventory Stock Count
_ Order Picking
_ Product Line Segregation
_ Shipping Weight
_ Supports Shelf Life Tracking
_ Picks Items Based on Shelf Life
_ Converts Item to Dead Stock With Write Off
_ Cycle Count Code
_ ABC Code
_ Movement Class
_ Supports Consignment Inventory
* Inventory Costing Method:
_ LIFO
_ FIFO
_ Standard Cost
_ Average Cost
_ Weighted Average
* Normal Vendor:
_ Name
_ I.D. Number
_ Vendor Part Number
_ Converts Item Number to Vendor Number
_ Last Purchase Date
_ Last Unit Cost
_ Alternate Vendors
_ Copy Vendor Information for New Items
_ Default Revenue Account
_ Default Cost of Goods Sold Account
_ Sales Tax Rate
_ Excise Tax Rate
* Pricing Conventions:
_ Single Price Only
_ Multiple Price Levels
_ Percentage of Actual Cost
_ Percentage of Average Cost
_ Percentage of Standard Cost
_ List Price
_ Blanket Discount
_ Dollar Volume Discount
_ Item Volume Discount
* Customer Price Matrix Options:
_ Customer All Items
_ Customer by Item
_ Customer by Item Group
_ Customer by Product Class
_ Customer Type All Items
_ Customer Type by Item
* Other Customer Contract Options:
_ Maintain Multiple Contracts Per Customer
_ Copy Existing Rate Table
* Reorder Conventions:
_ Manual
_ Automatic
_ Minimum Stock Level
_ Maximum Stock Level
_ Normal Reorder Quantity
_ Average Usage
_ Period Usage
_ Average Lead Time
_ Calculates EOQ
_ Define Commission Rate
* Define Commission Types:
_ Define for Each Item
_ Define Commission Rate Groups
_ Prevents Unauthorized Alteration of Records
Inventory \ Data Input and Cost Distribution
_ Automatic Cost Distribution to General Ledger
_ Automatic Cost Distribution to Job Module
_ Automatic Creation of Payable for Consignments
_ Real Time Posting of all Activities
* Price Change Conventions:
_ Automatic as Costs Change
_ User Defined
_ Automatic Across the Board
_ Entire Customer Table
_ Item Only
_ Product Line
_ Define Percentage Margin Required
_ Display Modified Prices Before Commitment
_ Set Effective Date for Price Changes
_ Set Contract Dates for Specific Customers
_ Prompt for Expiration of Effective Dates
_ Time Based Discount Pricing
_ Calculates Inventory Available Based on Orders
_ Maintains On Hand, Orders, Purchases, and Expected
_ Suggests Stocking Levels
_ Recommends Transfers Between Locations
_ Automatic Ordering
_ Supports Contract Shipments
_ Split Case and Other Fractional Selling
_ Supports Bar Code Readers
_ Prints Bar Code Labels
_ Freezes Inventory While Taking a Physical Count
_ Prints Count Sheets and Inventory Tags
_ Physical Inventory Reconciliation Routine
_ Tracks Transaction History Audit Trail Per Item
* Adjust Inventory:
_ Discontinued Items
_ Scrap
_ Missing Inventory
Inventory \ Receiving Activities
_ Supports Specific Receiving Functions/Screens
_ Prints or Displays Anticipated Receiving Schedule
_ Displays Special Instructions
_ Input Material Receipts
_ Input Multiple Receipt Dates Per Line Item
* Supports Input During Receipt:
_ Manufacturer's Lot Numbers
_ Manufacturer's Serial Numbers
_ User's Lot Numbers
* Supports Printing During Receipt:
_ Bar Code Labels
_ Bar Code Lot Number
_ Bar Code Serial Number
* Unit of Measure Conversions:
_ Purchase to Stocking
_ Multiple Stocking Units of Measure
_ Stocking to Selling
* Updates Purchase Order System:
_ Batch Processing
_ Real-Time Processing
* Updates Inventory Control System:
_ Batch Processing
_ Real-Time Processing
_ Receives Entire Purchase Order Automatically
_ Receives Entire Purchase Order With Exceptions
_ Checks Over/Under by Percent Limit
_ Note Items Backordered
_ Receives Material Without Matching Invoice
_ Separate Stock Return Function
* Supports RMA (Return Material Authorization):
_ Receipts From Suppliers
_ Shipments to Customers
_ Stock Return Creates Automatic Debit Transaction
_ Receives Material Subject to Inspection
_ O/S/D Routine
_ Supports Exception Control System
_ Close Open Purchase Orders Within Tolerances
_ Stop Payment on Purchase
_ Automatic Shipping Orders for Back Ordered Items
Inventory \ Shipping/Withdrawal Activities
* Supports Inventory Withdrawal Functions for:
_ Internal Requisitions
_ Warranty Reshipment to Customers
_ Warranty Returns to Suppliers
_ Job/Project Withdrawals
_ Work Order Withdrawals
_ Prints Shipping Schedule
_ Prints Orders Not Shipped
_ Specifies Serial Number Items to be Shipped
_ Prints Items to be Shipped on Long Term Contracts
_ Calculates Shipping Weight
* Prints Shipping Documents:
_ Inventory Pick Lists
_ Packing Lists
_ Shipping Labels
_ Bill of Lading
_ UPS Labels
Inventory \ Financial Reports
* On-Line Query Functions:
_ By Warehouse
_ By Stockroom Within a Warehouse
_ Open Sales Order Details
_ Open Work Order Details
_ Open Job/Project Details
_ Open Purchase Order Details
_ Quantity on PO Reserved/Unrestricted
_ Expected Arrival Date for Materials
_ Tracks PO Backordered Items Separately
* Quick Item Snapshot:
_ User Defined Shapshot Fields
_ Quantity on Hand
_ Quantity Committed to Sales/Work Orders
_ Quantity on Order (PO)
_ Average Sales Volume Per Month
_ Last 12 Months Sales Displayed Graphically
_ Average Sales/Work Order Quantity
_ Last Sales/Work Order Date
_ Last Sales/Work Order Quantity
_ Last Receipt Date
_ Last Receipt Quantity
_ Average Cost
_ Average Price
_ Average Percentage Margin
* Inventory Activity Report:
_ By Item Number
_ By Vendor
_ By Product Class
_ ABC Analysis
* Where Used Report:
_ Component
_ Assembly
_ Customer
_ Receiving Report
_ O/S/D Report
_ Shipping Report
_ Late Shipment Report
_ Consignment Inventory Report
_ Customer Contract History Report
_ Identify Problem Sales Orders and Invoices
_ Tracks Sales by Salesperson
_ Tracks Profits by Salesperson
_ Provides Sales Projections
_ Rank Inventory by Volume or Profitability
* Inventory Analysis:
_ Turnover
_ Percentage Profitability
_ Dollar Profitability
_ Item
_ Product Line
_ Profit Exception Report
_ Replenishment Orders Required
_ Stock out Only
_ Excessive Inventory
_ User Defined
_ Inventory Price List
_ Customer Contract Price List
Inventory \ Inventory Control/Assembly Systems
_ Supports Multiple Warehouses
_ Multiple Stocking Locations in Same Warehouse
_ Central Warehouse Feeds Satellite Locations
_ Supports Bin Locations
_ Multiple Bin Locations for Same Item
_ Multiple Units of Measure for Same Item
* Supports Kits/Bill of Materials:
_ Single Level Bill of Materials
_ Multi-Level Bill of Materials
_ Unlimited Level Bill of Materials
_ Calculates Yield for Whole Bill
_ Calculates Yield for Individual Components
_ Supports Tag-Along Sets
_ Maintains Detailed Costs at Component Level
* Copy Existing BOM to New Bill of Materials:
_ Copy Entire Bill of Materials
_ Copy Specific Sub-Assemblies
_ Supports Template Bills of Materials
_ Mass Replace Component
_ Supports Work Orders for Light Assembly
_ Supports Sub Assembly Tracking and Assembly
_ Work Orders Created Automatically
_ Supports Kit Disassembly
* Supports Rework/Repair Operations:
_ Create Work Order for Rework/Repair
_ Schedule and Track Rework/Repair
* Supports Warehouse Transfers:
_ Supports Menu Functions for Transfers
_ Creates Internal Shipping Documents
_ Tracks Items While Being Transferred
* Hazardous Materials Controls:
_ Check Box Identifies as Hazardous
_ Identifies Federal Control Number
_ Print/Display Internal Handling Instruction
_ Print/Display Emergency Instructions
_ Prints Hazmat Sheets Only for Fist Shipment
_ Prints Hazmat Sheets for all Shipments
Job/Project Costing \ Job Initiation
DCAA Approved
* Job Types Supported:
_ Standard Job With Work in Process
_ Multi-Year Project (No WIP)
_ Multi-Year Project (With WIP)
_ Short-Term Activity/Event (No WIP)
_ Automatic Job Numbering
_ User Defined Numbering Convention
_ Job Cost Estimating
_ Convert Estimate to Budget
_ Supports Multiple Budgets With Revisions
_ Master Labor and Material File
_ Store Estimates
* Stores Data for Completed Job:
_ Summary
_ Detail
_ Update Template With Current Costs
* User Defined Line Item Cost Detail:
_ Cost Category
_ Phase Category
_ Other
_ Vendor Provided Standard Categories and Phases
_ Segregates and Identifies Subcontractors
_ New Job Initiated Entirely From Job Cost Module
* Tracks Start/End Dates for:
_ Job/Project
_ Phase
_ Sub-Phase/Activity
* Tracks Costs for:
_ Direct Labor
_ Direct Material
_ Indirect Labor
_ Indirect Material
_ Equipment Costs
_ Subcontractors
_ Direct Administrative Costs
_ General Overhead Costs
_ Non-Billable/Non-Productive Costs
_ User Defined Cost Categories
Job/Project Costing \ Data Input and Cost Distribution
_ Supports Terminals in the Field
* Data Input Method:
_ Entirely In Job Cost Module
_ Entirely In Other Modules
_ Both
_ Input Data Only One Time
_ Prevents Posting Unless Job Open/Active
* Commits Inventory Based on Job Estimates:
_ Commit at Beginning of Job
_ Time-Phased Material Commitment
_ Standard Costing
_ Profit/Loss Recognized at User Discretion
_ Supports Classification of Labor
_ User Defined Overhead Allocation
_ Modify Posted Overhead Allocation
* User Defined Labor Burden:
_ Percentage of Direct Labor Cost
_ Percentage of Total Labor Cost (Fringes)
_ Cost per Labor Hour
_ Supports Reimbursable Office Expenses
_ Imports Payroll Taxes Automatically
Job/Project Costing \ Job Control
_ Supports Project Management Functions
_ Display Information in Line Chart Format
_ Define Dependent Relationships
_ Modify Start/Stop Times Based on Dependencies
_ Practice What If Analysis
_ Utilize Bottom Up Scheduling
_ Supports Change Orders
_ Prints Job Tickets
_ User Defined Notation File
_ Displays Outstanding Purchase Orders
_ Supports Manpower Forecasting
_ Supports Materials Management
Job/Project Costing \ Cost Analysis and Reports
_ Data Transaction Registers
_ Reports Labor Hours
_ Labor Analysis by Employee
_ Overtime Analysis
_ Analysis of Productive Versus Non-Productive Labor
_ Analysis of Support Labor
* Detailed Equipment Analysis:
_ Cost Analysis
_ Utilization Analysis
_ Detailed Subcontractor Analysis
_ Comparison Versus Budget
_ Detailed Cost by Phase and Category
_ Drill Down to Source Cost Elements
_ Automatic Notification of Cost Overruns
_ Supports User Defined Reports
_ Separates Warranty Work
_ Detailed Listing of Material Consumed
_ Variance Analysis
_ Work in Process Report
_ Backlog Report
*
Cost to Complete Analysis
Job History Summary
Prints Year End Summary
* Reports Cost Review by:
_ Job-to-Date
_ Entire Project
_ Fiscal Year
_ Calendar Year
_ User Defined Time Period
Job/Project Costing \ Job Invoicing and Accounts Receivabl
_ Self Contained Invoicing Routine
_ Post Invoices Generated in Accounts Receivable
_ Post Invoices Generated in Order Entry
* Time and Material Billing:
_ Price Per Unit
_ Markup Over Cost
_ A.I.A. Billing
* Defense Contractor Billing:
_ Invoicing
_ Job/Project Progress Reporting
* Other Government Contractor Billing:
_ Invoicing
_ Job/Project Progress Reporting
* Percentage Completion Contracts:
_ Percentage of Whole Job
_ Each Phase
_ Each Sub Phase
_ Completed Contract Basis
* Material Pricing Based Upon:
_ Standard Pricing in Inventory Control
_ Contract Pricing Defined in Inventory Contr
_ Contract Pricing Defined in Job/Project Mod
* Labor Pricing Based Upon:
_ Actual Cost Plus Markup Percentage
_ Labor Class Rate/Hour
_ Individual Employee Rate/Hour
_ Supports Multiple Rates Per Employee
_ Labor Rates Defined in Job/Project Module
_ Supports User Defined Invoice Formats
_ Calculates all Sections of Invoice
_ User Override of Automatic Invoices
_ Invoice Printing from Job Cost Module
_ Invoice Includes Unpaid Balances
_ Retainage Withheld Automatically
_ Includes Retainage in Final Invoice
_ Automatic Alert of Price Ceiling
_ Integration with Accounts Receivable
_ Tracks Payment History
Fixed Assets \ Equipment Files
_ User Defined Equipment Master File
_ Asset ID Permits Grouping by Category
_ Supports Assignment of Serial Numbers
_ Identifies Original Manufacturer
_ Identifies Current Location
_ Identifies Current User
_ Prepares Property Tax Reports
* Default Distribution:
_ General Ledger
_ Job Costing
_ Department
* Supports Multiple Depreciation Methods:
_ Straight Line
_ Sum of Years
_ Accelerated
_ Unit of Production
_ Supports Asset Groups
* Calculates Simultaneous Depreciation:
_ Management Accounting
_ Tax Accounting
_ Stockholder Accounting
Fixed Assets \ Cost Calculation and Distribution
_ Special Function for Installation
_ Automatic Calculation of Depreciation
* Automatic Transfer of Depreciation:
_ To General Ledger
_ To Departments
_ To Job Cost
_ Calculates Gain/Loss on Disposition of Asset
_ Recaptures Investment Tax Credit
_ Transfers Assets to Other Departments
_ Recalculates Depreciation Based on Major Repairs
_ Built in Lease/Purchase Analysis
Fixed Assets \ Reports
_ Cost Distribution Report
_ Prints Detailed Equipment List
_ Maintenance Cost Analysis
_ Maintenance Cost Versus Depreciation
_ Maintenance Cost Trend Analysis
Order Entry \ General Questions
* Primarily Designed for:
_ Wholesale Distribution
_ Light Manufacturing
_ Commerical Counter Sales
_ Consumer Telephone Sales
_ Retail Point of Sale
* Commission Splits and Overrides:
_ Single Commission Only
_ Automatic Multiple Commission Levels
_ Supports Commission Overrides
* Commission Based Upon:
_ Booked Orders
_ Invoiced Orders
_ Customer Payments
_ Gross Sales Revenue
_ Gross Dollar Margin
_ Item Specific Rate
_ Item Class/Type Rate
_ Salesperson Specific Rate
_ Customer Specific Rate
_ Post Commission to Payroll Automatically
_ Supports Cash Drawer
_ Cash Drawer Balancing
_ Calculates Change Due
* Supports Payroll Timekeeping:
_ Employee Log In/Out
_ Commission Calculations
_ Hours Plus Commission
_ Salary Plus Commission
_ Supports All Inventory Functions
_ Supports Restocking
_ User Designed Data Entry Screens
_ Supports Bar Code Reader
_ Prints Price Labels
_ Prints Bar Code Labels
Order Entry \ Order Receipt
_ Supports Contact Management System
_ Supports Field Sales Management
* Supports Service Management Functions:
_ Maintain Service Contract Details
_ Bill Monthly Service Fees Automatically
_ Define Locations Being Serviced
_ Define Prime Contacts at Each Location
_ Maintain Equipment List Being Serviced
_ Maintain Service Schedules for Equipment
_ Maintain Equipment Spare Parts Lists
_ Maintain Labor and Material Rates
_ Supports Service Scheduling System
_ Supports Daily Dispatch Functions
_ Dispatch/Control Multiple Service Vehicles
_ Supports RMA Warranties
_ Maintain Spare Parts Per Service Vehicle
_ Track Each Service Call Separately
_ Maintain Service Records for all Equipment
_ Maintain Detailed Cost Records for Contract
* EDI Commerce Options:
_ Order Placement
_ Order Acknowledgement
_ Advance Ship Notice
_ Invoicing
* Internet Commerce Options:
_ Business to Business Commerce
_ Consumer to Business Commerce
_ Real Time Interactive Order Processing
_ After-the-Fact Order Processing
_ Secure Credit Card Processing
_ Real Time Item Availability Checking
_ Order Acknowledgement
_ Advance Ship Notice
_ Invoicing
_ Supports Input of New Customer
_ Supports One Time Customers
_ Assigns New Account Numbers
_ Automatic Order Numbering
* Customer Lookup Options Supported:
_ Name/Partial Name
_ User Defined Customer Short Name
_ Telephone Number
* User Defined Item Lookup Conventions:
_ Define Lookup Groups
_ Define Attribute Categories
_ Define Specific Attributes
_ Use Customer Item ID
_ Creates Work Order Automatically
* Work Order Contains:
_ Assembly Operations
_ Bill of Materials Per Assembly Operation
_ Special Customer Requirements
_ Work Order Linked to Sales Order
_ Calculates Price From Component Prices
_ Calculates Price From Work Order Estimator
_ Supports Special Sales
* Supports Multiple Classes of Sales:
_ Cash
_ Credit
_ Layaway
_ Credit Card
_ Partial Payment
_ Coupons
Prepares Quotations
* Automatically Transmit Quotation Electronically:
_ FAX Transmission
_ E-Mail Transmission
_ Converts Quotation to Firm Order
_ Prints Acknowledgments
_ Display and Duplicate Previous Order
_ Supports Special Customer Requirements
_ Maintains File of Special Requirements
_ Recalls Special Requirements Automatically
_ Maintains Standing Orders
_ Retention of Repeat Orders
_ Automatic Credit Check
_ Credit Check Includes Current Order
_ Overdue Account Flag
_ Displays Customer Aging Automatically
* Send Invoice Copies Automatically:
_ Print Format
_ FAX
_ E-Mail
_ Multiple Transaction Types Per Order
_ Segregates Drop Shipments by Location
_ Supports Ship Complete Only Orders
_ Specify Delivery Date Per Line Item
_ Supports Rush Order Designation
_ Automatic Inventory Check
_ Displays Best Price Calculations
_ Displays Quantity Price Breaks
* Price Discounts Based on:
_ Item Quantity
_ Order Quantity
_ Item Dollar Total
_ Order Dollar Total
_ Group Items Into Categories
* Supports Margin Analysis:
_ Displays Percentage Margin
_ Displays Dollar Margin
_ Displays Optimum Percentage Margin
_ Displays Minimum Percentage Margin
_ Displays Expected Arrival Date
_ Displays Alternate Items
_ Displays Upgrade Items
_ Charge Upgrade at Original Item Price
_ Listing of Alternate Warehouse Locations
_ Automatically Consolidate into One Warehouse
_ Creates Automatic Back Orders
_ Integrates With Purchase Order System
_ FAX/EDI Purchase Order From Sales Order
_ Sales Unit of Measure Conversion
_ Input Cost of Sales for Non-Inventory Items
* Process Credit Card Orders Automatically:
_ Input Card Details in Sales Order Screen
_ Automatic Approval Processing
* Sales Tax Calculation Based on:
_ Shipper Location
_ Single Tax Level Per Ship-to
_ Multiple Tax Levels Per Ship-to
Order Entry \ Order Tracking
_ Supports Orders Tracking Application
_ Screen Display of Open Orders
* Displays Order Information:
_ Customer Contact
_ Telephone Number
_ Special Requirements and Notes
_ Order Date
_ Original Promise Date
_ Revised Promise Date
_ Shipping Dates
_ Back Order Information/Status
_ Order Tracking Notes
* Track Open Order Status:
_ Order Number
_ Customer Number
_ Customer Name
_ Customer Purchase Order Number
_ Item Number
_ Sales Representative
_ Ship Date
_ Orders Not Shipped Only
_ Rush Orders
* Internet Order Status Query by:
_ Customers
_ Sales Representatives
Specify Action to be Taken on Open Orders
Assign Date for Next Review
Tracks Status of Back Orders
Order Entry \ Shipping
* Creates Shipping Documents:
_ At Source
_ Transfers to Shipping Department
_ Supports Partial Shipments
_ Supports Shipping From Multiple Warehouses
_ Enter Ship Complete Notation
_ Enter Ship Complete With Exceptions
_ Calculates Ship-by Date
_ Displays Shipping Schedule by Day/Week
_ Prints Pick Tickets by Required Ship Date
* Consolidates Pick Tickets by:
_ Item
_ Warehouse Location
_ Supports Delivery Route Scheduling
_ Consolidate Items into Boxes/Crates
_ Use Bar Codes to Record Shipments
_ Calculates Shipping Weight Automatically
* Calculates Freight Rates for:
_ UPS
_ Federal Express
_ Commercial Carriers
* Prints Manifest/Bill of Lading for:
_ UPS
_ Federal Express
_ Commercial Carriers
_ Automatic Cancellation of Orders by Cancel Date
_ Fills Back Orders Automatically
Order Entry \ Invoicing
_ Print Invoice Directly From System
_ Delay Invoicing Until All Items Have Been Shipped
_ Comment Lines on Invoice
_ Indicates All Items Back Ordered
_ Non Charge for Back Orders
_ Prints Customer Part Number
_ Prints Multiple Line Part Descriptions
_ Prints Credit Card Number and Authorization
_ Requires Authorization Number
_ Applies Customer Deposit to Invoice
_ Automatic Calculation of Freight Charges
Order Entry \ Reports
* Daily Order Analysis:
_ Firm Orders
_ Quotations
_ Shipments
_ Returns
_ Back Orders
_ Cancelled Orders
* Cash Receipts Analysis:
_ Gross Revenue
_ Returns and Discounts
_ Charge Sales
_ Cash Receipts
_ Checks
_ Credit Cards
_ Coupons
_ Bad Checks
_ Bad Credit Cards
_ Backlog Report
_ Customer Credit Limit Warning
_ Customer Credit Limit Overrides
* Sales History Report Sorted by:
_ Invoice Number
_ Customer
_ Item
_ Territory
_ Warehouse
_ Salesperson
_ User Defined
* Sales History Report Options:
_ Last Twelve Months in Separate Columns
_ Actual vs Budget: Corporate
_ Actual vs Budget: Salespeople
_ Graphical Presentation
* Margin Analysis Sorted by:
_ Customer
_ Item
_ Salesperson
* Salesperson Performance Analysis:
_ Gross Sales
_ Commissions Earned
_ Summary of All Salespeople
_ Comparison of Salespeople
Budgeting \ General Budgeting Module
_ Supports Comparison Versus Budget
_ Supports Separate Internal Budgeting Module
_ Integrates With Third Party Budgeting System
_ Supports Monthly Budgets
_ Supports Multiple Budget Revisions
_ Maintains Budget Revision History
_ Supports Non-G/L Budget Groups
_ Supports Budget Roll Up System
* Supports Budgeting for:
_ Non-General Ledger Activities/Accounts
_ Activities/Campaigns
_ Capital Projects
_ Supports Multiple Year Budgets
Budgeting \ Review Process
_ Past Budgets and Results Segregated
_ Saves More than One Years Past Data
_ Saves the Past Results for Each Month
_ Expresses Past Results as Percentage
Budgeting \ Construction of New Budget
_ Fixed Dollar Budgets Only
_ Variable Budgets
_ Isolates and Compares Each Line Item
_ Supports Comparison of Variables
_ Comparison Data Presented Graphically
_ Input Percentage Growth Rate
_ Expresses New Budget as Percentage
_ Balance Sheet Budgeting
_ Values Based Upon Other Values
* Supports Spreadsheet Budgets:
_ Import New Budget From Spreadsheet
_ Vendor Provides Full Instructions
_ Supports Budgeting Through Payroll Module
_ Prepares Cash Flow Forecast
_ Change Budgets During Year
General Questions \ Pre Sale Information
* Client Operating System:
_ DOS
_ OS/2
_ XENIX/UNIX
_ Macintosh
_ Windows 3.1 +
_ Windows 95
_ Windows NT Workstation
_ AS/400
* Server Operating System:
_ Macintosh
_ MS Windows NT Server
_ Novell NetWare
_ OS/2
_ OS/400
_ UNIX - Data General
_ UNIX - DEC Alpha
_ UNIX - HP UX
_ UNIX - IBM AIX
_ UNIX - Sun Solaris
_ UNIX - SCO/Unixware
_ UNIX - Other
* Databases Supported:
_ Btrieve
_ Btrieve Scalable SQL
_ dBase
_ FoxBase
_ Info Builders Focus
_ MS Access
_ MS SQL Server
_ OS/400
_ Progress
_ Retrieve
_ Scalable SQL
_ Sybase SQL Server
_ Proprietary
_ Other
* Programming Language:
_ Acucobol
_ Basic/Business Basic
_ C
_ C++
_ Clipper
_ Cobol
_ Delphi
_ FoxPro
_ HTML
_ Informix-4GL
_ Java
_ Object Oriented Language
_ Pascal
_ PowerBuilder
_ Progress
_ RPG/400
_ Visual Basic
_ Visual FoxPro
_ Other
* Microsoft Compliance:
_ BackOffice Logo
_ Designed for Windows 95 Logo
_ MAPI Compliant
_ ODBC Compliant
_ OLE 2/ActiveX Compliant
* Functions Supported/Required:
_ General Ledger
_ Bank Reconciliation
_ Electronic Funds Transfer (EFT)
_ Budgeting
_ Multi-Currency Accounting
_ Multi-Lingual Accounting
_ Fund Accounting
_ Governmental Accounting
_ Accounts Payable
_ Accounts Receivable
_ Invoicing
_ Time and Billing
_ Debt Collection
_ Sales Analysis
_ Sales/Use Tax Reporting
_ Payroll
_ Human Resource Management
_ Direct Deposit
_ Inventory Control
_ Bill of Materials
_ Job Costing: Construction
_ Job Costing: Service
_ Job Costing: Manufacturing
_ Job Costing: Government Contractors
_ Project Accounting
_ Project Management
_ Fixed Assets
_ Order Entry
_ POS/Counter Sales
_ Contact Management
_ Sales Force Management
_ Service Contract Management
_ Service Dispatch
_ EIS (Executive Information System)
* Manufacturing Functions Required/Supported:
_ Assembly/Light Manufacturing
_ Make-to-Stock Manufacturing
_ Make-to-Order Manufacturing
_ Apparel Manufacturing
_ Process Manufacturing
_ Work Order Processing
_ Production Scheduling
_ MRPII
_ ERP
* EDI Functions Supported:
_ Purchase Order Placement
_ Sales Order Receipt
_ Sales Order Acknowledgement
_ Advance Ship Notice
_ Invoicing
_ Production Scheduling
_ Invoice Payment
* Inter/Intranet Functions Supported:
_ Consumer to Business Commerce
_ Business to Business Commerce
_ Order Status Query
_ Advance Ship Notice
_ Financial/Management Report Circulation
_ Purchase Order Placement
_ T&E Expense Reporting
_ Remote Data Entry
* Supports Multi-Currency Transactions:
_ Full FASB 52 Compliance
_ Accounts Receivable
_ Accounts Payable
_ Inventory
_ General Ledger
* Supports Canadian Tax Reporting:
_ Payroll
_ Accounts Receivable & Billing
_ Features Disk/CD
_ Vendor Provided Copies of All Standard Reports
_ Full Demo Disk
* Vendor Provided Reference List:
_ Current Users
_ Dealers
_ Value Added Resellers (VAR''s)
_ Vertical Market Products
_ Certified Consultants
_ Source Code Availability
_ Vendor Newsletter
_ Company Operated Bulletin Boards
General Questions \ Purchase and Installation
_ Training Seminars
_ On-site Training
_ Video Tutorial
_ Menu Driven Installation
_ Installation Checklist
_ Sample Data Files
_ Sample Data Entry Screens
_ Copy Chart of Accounts From Existing Company
_ Copy New Chart of Accounts From Spreadsheet
_ Copy Master Files From Existing Company
_ Input Opening Balances Using Menu Function
* Input Customer Balances:
_ All Open Invoices
_ Balance Forward Only
* Input Vendor Balances:
_ All Open Invoices
_ Balance Forward Only
* Detail Accounts Affect General Ledger Balance:
_ Accounts Receivable
_ Accounts Payable
_ Inventory
General Questions \ Control and Audit Functions
* Password Security:
_ System
_ Modules
_ Functions
_ Files
_ Reports
_ Transaction Types
_ G/L Account Numbers
_ Data Input Fields
_ Audit All Master File Changes
* File and Record Lockout:
_ General Ledger
_ Accounts Receivable
_ Accounts Payable
_ Payroll
_ Inventory
_ Data Entry Control Report
* Details Carried With Each Transaction:
_ Date
_ Batch Number
_ Line Number
_ Source Journal
_ Customer/Vendor Number
_ Invoice/Voucher Number
_ Transaction Type
_ Description
_ Forced Audit Trail Print Prior to Posting
_ Prevents Deletion of Account With a Balance
* Prevents Record Alteration After Posting:
_ Data
_ Descriptions
_ Disk Storage of Audit Trail
General Questions \ General Operational Questions
* Supports Unlimited Note Fields for:
_ General Ledger Accounts
_ Other Master Files
_ Built in Backup Function
_ File Recovery Utility
_ Automatic Recovery Utility
_ Transaction Rollback After Crash
_ Keystroke Recording Utility
_ System Integrity Check
_ Hot Key Combinations
_ User Defined Macro Commands
_ User Defined Default Values
_ Full Screen Editing
* Posting Method:
_ Batch
_ Real Time
* Accounting Basis:
_ Cash Accounting
_ Accrual Accounting
_ Help Screen Indexed to Manual
_ Modify Help Screens
_ Create User-Specific Menus
_ Place Reports and Processes on Same Screen
_ Add User-Defined Reports to Standard Menu
_ Use Enter Key for Data Input
_ Modify Data Entry Sequence
_ Delete Fields Not Required
_ Modify Field Names
_ On-line Reference Manual
_ On-line Tutorial
_ Daily Procedures List
_ Screen Display of all Function Key Options
_ Screen Describes Nature of Required Input
_ Add New Accounts On-the-Fly
_ Data Entry Fields Default to the Last Entry
_ Allows Input of Valid Account Numbers Only
_ Confirmation of Input Account Number
_ On-line Account Number Inquiry
_ Search for Account Number by Name
_ Search by Partial Description
_ Search Range of Account Numbers
* Prompts User to Verify Input:
_ Each Line of Data
_ Each Screen
_ Use Single Function Key to Save Input Screen
_ System Checks for Key Fields
_ System Describes Nature of Errors
_ Allows Input of Valid Commands Only
_ View Files and Accounts On Screen
_ Assign Inactive Status to Master Files
_ Mass Purge Inactive Accounts
General Questions \ Reports
_ Supports Multiple Printers Simultaneously
_ Compressed Print Option
_ Prints Activity Report for Single Account
_ Drill Down to Source Transactions
_ Option to Print Account Number on Reports
_ Summary Reports
_ User Specified Rounding
_ Multiple Copies Upon Demand
_ Report Queuing
_ Report Scheduling
_ Account Balances Reflect Actual Aging
_ Credit Terms Noted on Reports
_ Print Reports for Prior Periods
_ Built-in Report Writer
* Third Party Report Writers Supported:
_ Crystal Reports
_ FoxFire
_ FRx for Windows
_ F9
_ IQ Report Writer
_ Progress
_ R&R Report Writer
_ Other
* Uses Commonly Available Forms for:
_ Checks
_ Invoices
_ Statements
_ W2
_ 1099
* Design Format for:
_ Check
_ Check Stub
_ Invoice
_ Import/Export Utility
_ Template for Data Import/Export
_ Documentation of Import/Export Process
General Questions \ Industry Specific Modules
_ Accounting: Public
_ Advertising
_ Automotive: Repair and Service
_ Automotive: Sales
_ Automotive: Supply
_ Banking
_ Chemical
_ Contractors: Electrical
_ Contractors: HVAC
_ Contractors: Plumbing
_ Construction: Commercial
_ Construction: Highway
_ Construction: Homes
_ Consumer Package Goods
_ Dental
_ Distribution & Warehousing
_ Education
_ Electronics
_ Employment Agencies/Contractors
_ Engineering & Architecture
_ Government, Local
_ Grocery & Foods
_ Insurance
_ Legal
_ Loan Management
_ Manufacturing: FDA Controlled (Foods)
_ Manufacturing: Make-to-Order (Job Shop)
_ Manufacturing: Make-to-Stock
_ Manufacturing: Process
_ Medical: Hospital Management
_ Medical: Office/Patient Management
_ Metals: Fabrication
_ Metals: Wholesale/Distribution
_ Office Equipment Dealers
_ Oil and Gas Exploration
_ Optometry
_ Petrochemical
_ Pharmaceutical
_ Property Management
_ Printing
_ Rental/Lease: Equipment
_ Restaurants
_ Retail
_ Telecommunications
_ Transportation
_ Travel Agencies
_ Utilities
Numerical Requirements \ Field Lengths and Dollar Values
* ID Field Length Supported/Required:
________ General Ledger Accounts
________ Journal Codes
________ Customers
________ Vendors
________ Employees
________ Inventory Item ID
________ Vendor Item ID in I/C
________ Warehouse ID
________ A/R Invoices
________ A/P Invoices
________ Purchase Orders
________ A/P Checks
________ Sales Orders
________ Customer Purchase Orders
________ Customer Checks
* Description Field Lengths:
________ General Ledger Accounts
________ Departments/Divisions
________ Journal Entry Headers
________ Journal Entry Line Items
________ Customer Name
________ Vendor Name
________ Employee Name
________ Inventory Item Description
________ Warehouse Location Description
* Maximum Dollar Values:
________ Financial Statements
________ Foreign Currency Transactions
________ Budgets
________ G/L Journal Entries
________ A/R Invoices
________ A/P Invoices
________ P/R Checks
________ A/P Checks
________ Purchase Orders
________ Item Unit Value
________ Sales Order Line Item Total
________ Sales Order Total
________ Customer Purchase Orders
________ Customer A/R Payment Checks
Numerical Requirements \ Other Numerical Questions
________ G/L Account Segments Supported
________ Maximum Length of any one Segment
________ Maximum Periods in Fiscal Year
* Number of Open Periods in:
________ General Ledger
________ Accounts Payable
________ Accounts Receivable
________ Payroll
* Number of Periods History Maintained in:
________ General Ledger
________ Accounts Payable
________ Accounts Receivable
________ Payroll
Number of Budgets/Revisions Supported
* Line Items Supported per:
________ Journal Entry
________ A/R Invoice
________ A/P Invoice
________ Purchase Order
________ Sales Order
* Maximum Distributions per Line Item:
________ A/R Invoices
________ A/P Invoices
* Payroll Related Questions:
________ Number of Compensation Methods
________ Number of Miscellaneous Income Categories
________ Total Deduction Categories - Employer
________ Total Deductions per Employee
* Maximum Decimal Places Supported:
________ Employee Hourly Rates
________ Employee Piece Rates
________ Employee Overtime Factor
________ Employee Hours Worked
________ Salesperson Commission Rates
________ Split/Override Commission Levels
________ Fixed Asset Books Supported
Numerical Requirements \ Inventory Related Questions
* Decimal Places Supported:
________ Item Quantities on Hand
________ Item Unit Cost
________ Item Unit Price
________ Units of Measure per Inventory Item
________ Bill of Materials Levels
________ Number of Customer-Specific Contracts
Numerical Requirements \ User Defined Fields and Analysis
* User Defined Fields:
________ General Ledger Accounts
________ Customers
________ Vendors
________ Employees
________ Inventory Items
________ Jobs/Projects
________ Fixed Assets
Numerical Requirements \ Users and Transaction Volumes
________ Number of Users Accessing the Accounting/Business Management System
* Optimum Transaction Volumes:
________ Journal Entry Line Items per Week
________ A/R Invoices per Week
________ A/P Invoices per Week
________ Payroll Employees
Return to excelco Accounting System Selector
If you have questions and want to to contact us by voice the numbers are
VOICE TOLL-FREE (800) 553-6911
Voice: 1-(928) 443-5100 and Fax: 1-(800) 466-6001
Excelco, P. O. Box 3089, Prescott, AZ 85302