cms 2 V12 tm New Feature Overview

1. cms2V12 tmNew Feature Overview Cougar Mountain SoftwareProfessional Version

2. CMS Professional V12-New FeaturesNew Feature Descriptions Add a date block for posting Compare financial status with target goals in General Ledger Create additional custom reports in various modules Filter the GL Spreadsheet Export Report by account Include general ledger account impact summary on Edit Reports Include posting reference/batch number on check register Monitor your business status with Financial Analysis Report in “G/L” Print customer statements from the “AR Customers” window Re-index all modules

3. CMS Professional V12-New FeaturesNew Feature Descriptions Set default printing of account numbers on General Ledger Reports Set up queries for additional reports Use additional report groups in General Ledger Use unapplied payment transaction types View common-size “Balance Sheet” and “Income Statement” in General Ledger View date ranges on Budget Reports View more information in AP GL Expense Distribution Reports View improved Balance Sheet, Income Statement, and Audit Trail Reports View snapshot reports of your business

4. CMS Professional V12-New FeaturesAdd a Date Block Range for Posting Now you can set a start and end date range to block transactions from posting. This gives you the option of blocking all postings in all modules for specific periods within the fiscal calendar. If you attempt to post a transaction that is outside of the date block range, you will receive an error message. This may help prevent errors such as posting a transaction for the wrong year. To add a date block range, in the “Main Menu” select Company/Organization > Fiscal Calendar. While in the “Date Block Period” field, enter the starting and ending dates you wish to block and select “OK”.

5. CMS Professional V12-New FeaturesAdd a Date Block Range for Posting

6. CMS Professional V12-New FeaturesCreate Additional Custom Reports in Various Modules Job Cost: Billing History Report, Profit Margin Report, and Sales Tax Report Order Entry: Invoice Tracking Report, Sales History Report, Price Variance Report, Sale Tax Report, Promotional Sales Report, Profit Margin Report, Back Order Tracking Report, and Back Order Fulfillment Report Payroll: Edit Reports, Print Checks Report, and Employee Benefit/Deduction Report Point of Sale: Reprint Receipts Report, Sales History Report, Price Variance Report, Sales Tax Report, Coupon/Buy Down Report, Promotional Sales Report, and Profit Margin Report Purchase Order: Print POs/Reprint POs Report, Edit Reports, Open Purchase Order Report, Expected/Late Items Report, Vendor Performance Report, and History Report

7. CMS Professional V12-New FeaturesCreate Additional Custom Reports in Various Modules

8. CMS Professional V12-New FeaturesReindex All Modules Have you ever needed to re-index more than one module and grown tired of all the steps required to do so? Well, now you can “Reindex” all of your installed modules at the same time. In the Main Menu if you select “Options > File Maintenance > Reindex Data Files”, you will notice a new option that allows you to “Reindex” all modules at once. When you select the “Reindex All Modules”radio button, the grid will automatically populate with the file information from all of your installed modules; including the system files.

9. CMS Professional V12-New FeaturesReindex All Modules To further enhance CMS Professional and expand this feature, the option to “Reindex” is also available when you schedule a back up using the “Backup Schedule” feature. If you select the “Reindex All Modules Before Backup” check box, the system will automatically re-index your files before starting the back up process. If a user is in the system when the “Reindex” process starts, the files in use are skipped and a message indicating this will appear in a back up log to which you can refer to at your convenience. You also have the option of stopping the backup if the re-indexing fails. To do this, click the “Advanced” button in the CMS Backup Scheduler window. When the next window appears, select the “Stop Backup If Reindex fails” check box.

10. CMS Professional V12-New FeaturesReindex All Modules

11. CMS Professional V12-New FeaturesSet Up Query for Additional Reports This feature was introduced in CMS version 11, but in version 12 you have additional reports for which you can set up queries that can further define your reports. The additional reports you can use with this feature are as follows: Accounts Payable: Dated Invoice/Payment Report and History Report Accounts Receivable: Customer Statements and Dated Invoice/Payment Report General Ledger: Audit Trail Report Inventory: History Report Purchase Order: History Report

12. CMS Professional V12-New FeaturesSet Up Query for Additional Reports

13. CMS Professional V12-New FeaturesView Snapshot Reports of Your Business Have you ever wanted to see a snapshot of your business with one click? Now you can with CMS Professional Version 12. When you select the menu option, “Snapshot Reports”, now available in the Main Menu, you can run vital financial reports for General Ledger, Accounts Receivable, Accounts Payable, Inventory, Sales (OE/POS), and Payroll (post V12 release) at the same time. After you make your selections on each tab in this window, select “OK” and the system will retain the settings for the next time you want to use this feature. This helps eliminate time spent continually selecting options for this report, or opening several report windows to run all of the snapshots you wish to view.

14. CMS Professional V12-New FeaturesView Snapshot Reports of Your Business

15. CMS Professional V12-New FeaturesView Snapshot Reports of Your Business Once you select the modules on the “Report Options”tab, that you want to include in the report, you can select the exact information you want include for each module snapshot. Only the options you select will show in the snapshot. The following options are available on each respective tab: For General Ledger: You can print the financial data based on a period or date range. You can also print a graph for the total net income/loss for a specified period during the current fiscal year. For Accounts Receivable: You can print transaction totals, your top ten customers, and your top ten delinquent customers along with a graph of the total receivables by period. For Accounts Payable: You can print your top ten vendors, your top ten overdue items, the next ten upcoming items due, and a graph of the total payables by period.

16. CMS Professional V12-New FeaturesView Snapshot Reports of Your Business For Sales (OE/POS): You can print the top ten best selling items, worst selling items, most profitable items, days for sales, weeks for sales, and the running/current sales in any open batches or registers, along with a graph of the total sales by period. For Inventory: You can print the top ten best selling stock items, worst selling stock items, fastest turnover items, slowest turnover items, and under stock items. In addition, you can print a graph for the total number of inventory purchases by specified periods. For Payroll (post V12 release): You can print the total payroll expenses by department, your employees’ vacation and sick leave totals, the top ten employees by total vacation, sick, and other time used; along with grand totals and a graph of the total payroll expenses by specific period. Once you select your report options and click OK, your report will look something like the following image.

17. CMS Professional V12-New FeaturesView Snapshot Reports of Your Business

18. CMS Professional V12-New FeaturesGL Compare Financials with Target Goals If you are an “Accounting” or “Point of Sale” back office user, you can use the new Financial Report Codes to compare your business’ current financial activity to your target financial goals. When you create a Financial Report Code, you set the values you want to use for comparison. Then, when you run the GL Financial Analysis Report, GL Common-Size Balance Sheet, or GL Common-Size Income Statement, you can use these codes to include the defined values under the “Industry Averages” column to see how your business is currently stacking up to your target goals. To create a Financial Reports Code in “General Ledger”, select Options > Financial Reports Codes from the menu bar.

19. CMS Professional V12-New FeaturesGL Compare Financials with Target Goals

20. CMS Professional V12-New FeaturesGL Spreadsheet Export Report Filter by Account If you want to export your general ledger account information, you can now filter out only what you want to export. You have the options of using the “Account Filter”, or the “Advanced Filter” options for this report. Also, if you have more than one company, you can consolidate the ledgers into one export by selecting the “Print Consolidated Ledgers” check box.

21. CMS Professional V12-New FeaturesGL Spreadsheet Export Report Filter by Account

22. CMS Professional V12-New FeaturesGL/All Acct Impact Summary on Edit Reports Do you ever want to see how transactions will affect your general ledger accounts before you post transactions? Now you can with the new Print Account Impact Summary check box available in all Edit Report windows (except in Bank Reconciliation). The image shows the new check box in the GL Print Edit Report window.

23. CMS Professional V12-New FeaturesGL/All Acct Impact Summary on Edit Reports With this new feature, you can now see a summary of how your un-posted transactions will affect each general ledger account. If you have a large number of transactions to post, this may help you to notice incorrect entries. When you select this check box and click “OK”, the Edit Report will print first and then the GL Impact Summary Report will print. If any validation errors are encountered, they will show on the report instead of the transaction information. If you use batches in Order Entry, Point of Sale, or Purchase Order, and you choose to print more than one batch in which to see the impact summary; a separate impact report will print for each batch.

24. CMS Professional V12-New FeaturesGL/All Acct Impact Summary on Edit Reports

25. CMS Professional V12-New FeaturesGL Default Printing of Account #’s on Reports CMS Professional has an option to include general ledger account numbers on certain reports, but now you can set this option as a default instead of selecting it each time you print a report. In the GL Module Preferences window, you will notice a new Select “Print Account Number” as defaultcheck box. If you enable this check box, when you run the balance sheet, income statement, revenue/expense report (FUND only), or budget report; the general ledger account numbers will automatically be included. Access the Module Preferences window by selecting Options > Module Preferences from the menu bar.

26. CMS Professional V12-New FeaturesGL Default Printing of Account #’s on Reports

27. CMS Professional V12-New FeaturesGL Additional Report Groups In conjunction with the new GL Financial Analysis, GL Common-Size Income Statement, and GL Common-Size Balance Sheet reports, there are now additional report groups you can use to track your general ledger accounts. When you create or modify your general ledger accounts, you can assign report groups in the “General”tab of the GL Master Accounts window.

28. CMS Professional V12-New FeaturesGL Additional Report Groups

29. CMS Professional V12-New FeaturesGL Additional Report Groups You can also select one of the new options from the “Classified” drop-down list in the Set Up GL Account Groups window to set up groups for specific reporting purposes. This image reflects a sample account group for current assets.

30. CMS Professional V12-New FeaturesGL View a Common-Size Balance Sheet and Income Statement You can now view a Common-Size Balance Sheet or Income Statement in “General Ledger”. In the report window for either the Balance Sheet or Income Statement, an additional option, “Common Size”, is available for selection in the Report Type field. When you select this report type, a new “Financial Reports Code”field appears in which you can enter or use the “Lookup” to select a code to include pre-set industry averages on the report. These new reports are beneficial because you can compare two years of financials along with industry averages, which may help you analyze your financial status. The following image reflects the GL Income Statement window and “GL Common Size Income Statement”. Because these reports print in landscape format only, you will need to use a laser printer.

31. CMS Professional V12-New FeaturesGL View a Common-Size Balance Sheet and Income Statement

32. CMS Professional V12-New FeaturesGL View Date Ranges on Budget Reports With version 12, when you run a Budget Report in “General Ledger”, you will notice two new date ranges included in the header section of the report. These date ranges include the current and “year-to-date” ranges for which the report data spans. Because these reports provide a view of the current and “year-to-date” balances for both budget amounts, the inclusion of these date ranges is beneficial to anyone reviewing the report data.

33. CMS Professional V12-New FeaturesGL View Date Ranges on Budget Reports

34. CMS Professional V12-New FeaturesGL More Info on AP Expense Distribution Report If you have Purchase Order installed and integrated with Accounts Payable, you can now view additional information on the AP GL Expense Distribution Report. This additional information includes the detailed description from the purchase order.

35. CMS Professional V12-New FeaturesGL View Improved Balance Sheet, Income Statement, and Audit Trail Reports Cougar Mountain made several changes to the layout and design of the Balance Sheet, Income Statement, and Audit Trail Reports to make them more consistent and readable. These changes were incorporated in response to customer requests to modify these reports. When you run one of these reports, you will notice several changes that make these reports more user friendly, and easier to interpret. The following image shows the new look of the GL Classified Balance Sheet.

36. CMS Professional V12-New FeaturesGL Improved Balance Sheet

37. CMS Professional V12-New FeaturesGL Improved Audit Trail Reports Also, when you are ready to print the GL Audit Trail Report, you will notice a few new options from which to choose. You can now skip accounts with zero balances, group activities by modules, and print reports in landscape view (detailed or single line). If you choose a landscape view, you will need to use a laser printer. These new options require the system to save additional data at posting. Because of this, for any transactions posted prior to installing version 12; when you run the report, the “Post Date” field will reflect stars (*****) and the “Posting Reference” field will be blank.

38. CMS Professional V12-New FeaturesGL Improved Audit Trail Reports

39. CMS Professional V12-New FeaturesAR Print Statements Customers Window In addition to the other new features in Accounts Receivable, you can also print customer statements directly from the “AR Customers”window. Select Customers > Customer Maintenance from the menu bar. On the Credit/Collection tab, you will notice a “Print Statement” button. When you select this button, only the statement for the selected customer will print. This helps simplify the process when you need to print, or reprint a statement. It will also help you if you need to closely monitor a customer’s account.

40. CMS Professional V12-New FeaturesAR Print Statements Customers Window

41. CMS Professional V12-New FeaturesAP Posting Ref./Batch # on Check Register Now, before you post transactions in Accounts Payable, you can track the module, reference number, transaction number, and batch number for every transaction. This may be beneficial, if there is an error with a transaction and you need to track it back to the individual who generated it. Since the check register only reflects un-posted Accounts Payable transactions; once you post the batch, the register is cleared and the posting reference is omitted from the history.

42. CMS Professional V12-New FeaturesAP Posting Ref./Batch # on Check Register In the image below, the segments in the posting reference AP-00183-00002-AGJ represents the following information: AP is the module from which the transaction is posted 00183 is the posting reference number 00002 is the transaction number AGJ is the batch number

43. CMS Professional V12-New FeaturesAP Unapplied Payment Transaction Type Do you need to cut a check to a vendor before the bill is posted? Do you allow customers to pay for an invoice before the vendor bill is posted? With version 12 you can enter unapplied payment transactions in Accounts Payable to help accommodate these types of situations. In Accounts Payable, when you select Pay Bills > Adjust/Pay Bills from the menu bar, you will notice the new “Unapplied Payment”option available in the Transaction Type drop-down list.

44. CMS Professional V12-New FeaturesAP Unapplied Payment Transaction Type

45. CMS Professional V12-New FeaturesAP Unapplied Payment Transaction Type This new feature allows you to apply the payment to the proper transaction instead of the first invoice posted. When you post the unapplied payment transaction, it will show as an “UN Payment” type in the AP Open Item Lookup window and on the “Aging and History” tabs of the AP Vendors window.

46. CMS Professional V12-New FeaturesAP Unapplied Payment Transaction Type

47. Other CMStotheMaxtm tm Products cms2EM Email tm cms2SY AutoArchiver tm cms2EX Excel tm cms2SY UDF+ tm cms2AR PastDueInvoices tm cms2OE CollectionNotes-swo cms2OE LookupHis-Enh tm cms2RRW Reportstm cms2R&R LearnCDtm cms2AL MaxPak’stm cms2PR CertifiedPR-Formstm cms2AL QckChgtm cms2SY mini-ContactMgrtm

48. How Can I Get the CMStotheMax tm & Cougar-Magic tm Products? You can get cms2OE_CollectionComments&Notes tmfrom your local Cougar Mtn Dealeror GPS Financial Services(aka CMStotheMAX.com and CougarMtnSupport.com) 13337 South Street #352 Cerritos, CA 90703 714 228-5444 Phone 800 531-2944 Fax sales@CMStotheMAX.com

49. CMS to the MAX &Cougar-Magic Products 9. Enhanced Reports

50. ___________________ Enhanced Reports • Pending