Version 3.26 (1/26/2022)
1) Corrected the problem of uploading the database files to the CMW Software website.
2) Corrected a minor problem with printing the Form W-2.
Version 3.25 (1/6/2022)
1) Modified procedure to create checks (paper and electronic) for accounts payable dated in prior year.
Version 3.24 (12/23/2021)
1) File upload password changed.
2) Updated 1099 NEC Form for 2021.
3) Updated W-2 and W-3 Forms for 2021.
4) Updated payroll tax rates and tax tables for paychecks issued on or after 1/1/2022.
Version 3.23 (7/4/2021)
1) Correction to Schedule C tax information report (Business Entity) (includes Electronic Checks).
2) Modified payroll employee setup procedures to correct an error in handling a situation in which the employee is "Exempt" from federal withholding tax. (PR/Employee Data. Select Employee, Select Benefits and Deductions Tab, Highlight the Benefit Deduction row, Select Update or Correction, Select Appropriate Federal Withholding Status).
3) Completed a new feature of NA ready for testing the creation of GAAP financial statements (accrual basis balance sheet and income statement). This new feature will not impact your current use of NA.
Version 3.22 (1/4/2021)
1) Updated 1099 reporting requirements from Form 1099-MISC (Box 7) to Form 1099-NEC 2020 (Box 1).
2) Added new 2021 payroll tax rates and withholding tables.
Version 3.21 (11/25/2020)
1) Added a new type of electronic meter reading (EMR) to NA, the second in about a week. This upgrade applies only to one city. For this reason it is recommended to not intall it.
Version 3.20 (11/23/2020)
1) Completed Part 2 of the new type of electronic meter reading (EMR) added to NA in the prior upgrade 3.19 (UB/Electronic Meter Reading). This upgrade applies only to one city. For this reason it is recommended to not intall it.
Version 3.19 (11/17/2020)
1) Added a new type of electronic meter reading (EMR) to NA. This upgrade applies only to one city. For this reason it is recommended to not intall it.
Version 3.18 (10/26/2020)
1) Added a new type of electronic meter reading (EMR) to NA. This upgrade applies only to one city. For this reason it is recommended to not intall it.
Version 3.17 (8/20/2020)
1) Corrected a problem with NA database file uploads.
2) Added a new customer report with a single line for each customer (AR/Setup/Customer). Select option "Customer Name" for Sort Customer Listing By. Select "None" for Number of SA Assignments.
3) Added a new feature to enter a new Vendor in the "invoice detail" screen (BA/Accounts Payable/Add).
4) For Electronic Checks only, when you select the individual AP selection, the invoice date will automatically populate the electronic check record.
5) The procedure for NA database cleanup is available. You must contact technical support for information about the special requirements to proceed, and to get the password (Startup/Move Data to History Tables).
Version 3.16 (5/28/2020)
1) Corrected a minor problem with the AR customer deposits screen when "applying" an overpayment deposit(AR/Customer Deposits).
Version 3.15 (5/25/2020)
1) Corrected a problem printing customer deposit reports (AR/Customer Deposits/Print).
2) Updated the "Utility Customers" export file (Startup/Electronic Trial Balances for Auditor).
Version 3.14 (5/19/2020)
1) Added new customer deposits report when printing a report for all customers (AR/Customer Deposits/Print). The new report is summarized by customer.
2) Enabled an AR report (active customers only). AR/Customer Assistance/Select Date/Press Print Summary.
3) Created duplicate table to store CRBook history transactions.
4) Modified AdjustmentsH table to enable storage of encumbrance adjustments consistent with AdjustmentsC table.
Version 3.13 (2/16/2020)
1) Modified the payroll procedures to simplify the use of new Form W-4 2020 requirements. This upgrade incorporates the requirements of both the new Form W-4 2020 as well as the old Form W-4 (pre-2020). If you have any employees using the new Form W-4 2020 you must edit their payroll "Benefits and Deductions" record to designate that they use the new form (PR/Employee Data).
2) Modified the NA download document "Month-End Reconciliations Checklist." The primary focus was on Accounting Receivable, clarifying which reports to print and how to use them. A small paragraph discussing Customer Deposits was added at the bottom of page 2. Comments and suggestions are always welcome.
3) Modified the NA download document "Maintaining Investment Records". A few changes were made in an effort to better clarify the various procedures. Comments and suggestions are always welcome.
Version 3.12 (1/27/2020)
1) Modified the payroll procedures to comply with the new Form W-4 2020 requirements. This upgrade incorporates the requirements of both the new Form W-4 2020 as well as the old Form W-4 (pre-2020).
You should already be familiar with the new Form W-4 2020. Before you do another payroll, you should review, and update as necessary, each employee's "benefits and deductions" record (PR/Employee Data). The changes you will see are patterned after the requirements of the new Form W-4 2020. As has been noted by most people connected to payroll procedures, the payroll changes in NA have been substantial, somewhat complex, and comprehensive regarding the pay calculation process. While this upgrade has been tested thoroughly, please share with us any comments, questions, or possible problems.
Version 3.11 (1/24/2020)
1) Modified the payroll procedures to comply with the new Form W-4 2020 requirements. Refer to NA Special Notice dated 1/24/2020 for more information.
Version 3.10 (1/19/2020)
1) Modified the payroll employee data setup procedure (PR/Employee Data). The "Benefits and Deductions" have been modified by adding a fourth federal withholding status - Exempt.
Exempt status for federal withholding can be used for an employee who writes "Exempt" under Step 4C of the Form W-4 2020.
Version 3.09 (1/2/2020)
1) Updated payroll tax rates and withholding tables for payrchecks issued on or after 1/1/2020.
2) Minor modifications to printed version of Form 1099 (BA/Reports/Print Form 1099, Form 1096).
3) Modified "Export" function (Startup/Electronic Trial Balances for Auditor) to correct error creating the Utility Customers text file.
Version 3.08 (8/11/2019)
1) Activated an additional electronic meter reading vendor (Mueller).
Version 3.07 (7/24/2019)
1) Updated backup procedures to upload and download data files.
Version 3.05 (8/7/2018)
1) Activated an additional electronic meter reading vendor (Kamstrup).
Version 3.04 (8/1/2018)
1) Added a special procedure for one city.
Version 3.03 (7/29/2018)
1) Added a new option for electronic meter reading capability (Utility Billing/Electronic Meter Reading).
2) Modified the procedure to add and edit utility meter information (Utility Billing/Utility Meter Information).
Version 3.02 (4/23/2018)
1) Added a selection option for Receipt Description (Customer Payment) when printing OTC cash receipts report (CR Book).
2) Modified bank account number entries to allow entry of leading zeros (Banking/Bank Accounts).
Version 3.01 (3/26/2018)
1) Minor modification to chart of accounts for two cities.
Version 3.00 (3/1/2018)
1) Modified meter reading information to enable printing of prior period meter reading and usage reports (Startup/NA Special Procedures). Please contact technical support for assistance.
2) Minor modification to Billing Adjustment procedures (AR/Billing Adjustments).
Version 2.99 (2/12/2018)
1) Modified procedures to generate monthly meter readings and usage reports to correct a problem (AR/Reports/Monthly Meter Readings and Usage).
Version 2.98 (2/9/2018)
1) Modified fund setup procedures to allow agency funds to be edited (BA/Setup/Government Funds).
2) Modified procedures to generate monthly meter readings and usage reports to correct a problem (AR/Reports/Monthly Meter Readings and Usage).
3) Modified the entry screen for general setup information (Startup/General Entity Setup Information). This modification affects only small businesses, and not local governments.
4) Modified the payroll benefit/deduction procedures to provide messaging on how and when to add, update, correct, and delete benefit/deduction records (PR/Setup Benefits and Deductions).
5) Modified several utility billing customer reports to better display customer account numbers (AR/Setup/Customers).
Version 2.97 (1/12/2018)
1) Updated 2018 federal payroll withholding tables (PR/Setup). These are the new Tax Cut withholding tables and are dated January 14, 2018.
2) Modified Schedule C reports (SC).
Version 2.96 (12/29/2017)
1) Updated 2018 federal payroll withholding allowance and withholding tables with temporary (2017) values which will be updated with new Tax Cut information when it is available in January 2018 (PR/Setup).
Version 2.95 (12/28/2017)
1) Updated payroll tax rates and tables for paychecks issued on or after 1/1/2018 (PR/Setup).
Note: Federal withholding information (withholding allowance and withholding tables) has not been updated because it is not yet available. This information will be updated as soon as it is available, sometime in January 2018. Prior to that, paychecks issued in 2018 will automatically continue to use the 2017 federal withholding allowance and tables. As in ALL cases when the payroll calculation changes you should take a more cautious review of the related pay detail to satisfy yourself that the paycheck information looks reasonable. Please contact technical support if you have any questions.
Version 2.94 (12/24/2017)
1) Added a new utility billing report of billing invoices to be printed or sent by email (AR/Print Utility Billing Invoices).
Version 2.93 (12/17/2017)
1) Modified the utility billing email procedures to correct problems with certain "email" providers (AR/Print Utility Billing Invoices).
We want to encourage all of you to use this feature to send out utility billings. It is very simple to set up and test with just a few customers. And it will save you time and money! Please contact technical support for assistance.
Version 2.92 (11/27/2017)
1) Modified the EMail customer billing procedure (AR/Setup/Host EMail Billing Information).
Version 2.91 (10/15/2017)
1) Added a new feature to move Accounts Receivable transactional records from live production to history tables (AR/Setup/Start New Year). Please refer to the related download document for more detailed instructions.
Version 2.90 (9/22/2017)
1) Modified end-of-month balances report (Banking/Month-End Balances (Per Bank Statement)).
2) Updated payroll tax rates and withholding tables for Nebraska (PR/Setup/Tax Rates/Tables).
3) Modified month-end fund summary reports for both cash basis and budgetary basis (BA/Reports/Monthly Financial Statement Reporting).
Note: The reports for government were not modified. New (separate) reports were created for small business reporting.
4) Modified the AR menu selections for business billing invoices (AR). A new (separate) selection has been enabled to Print business billing invoices.
5) Disabled selections on Employee Deduction Detail that allow Taxability of Gross Income for Federal Income Tax or State Income Tax to be unchecked (PR/Employee Data/Benefits and Deductions).
6) Added a new (optional) AR report that includes only active customer accounts that are not assigned a service address (AR/Reports/Accounts Receivable Report).
7) Disabled the use of all Customer Deposit Types except Security Deposit (No. 1) and Overpayment (No. 2) (AR/Setup/Customer Deposit Types).
8) Disabled the "View" button on the screen to print vendor checks (BA/Print Paper Checks).
9) Added new reports for Schedule C small business tax reporting (SC/Print Schedule C Reports).
Version 2.89 (7/31/2017)
1) Modified the cash receipt adjustments report (BA/Inquiries/Cash Receipt Adjustments).
Version 2.88 (7/30/2017)
1) Modified the expenditure adjustments report (BA/Inquiries/Expenditure Adjustments).
Version 2.87 (6/28/2017)
1) Added a new report for detailed accounts payable where a single vendor is selected to be printed (BA/Inquiries/Accounts Payable).
2) Minor modifications (formatting) to the monthly accounts receivable summary report (AR/Reports/Monthly Accounts Receivable Summary).
3) Added revised state payroll withholding rates for Kansas, effective July 1, 2017 (PR/Setup/Tax Tables).
Version 2.86 (5/18/2017)
1) Modified the chart of accounts for NA business entities. Chart of accounts menu selections have been moved to a separate submenu selection (BA/Setup/Chart of Accounts).
Version 2.85 (4/5/2017)
1) Modified the procedures to edit accounts receivable records (AR/Accounts Receivable Detail).
Version 2.84 (4/1/2017)
1) Minor modifications to budgetary financial statement formats (BA/Reports/Budgetary Financial Statement Reporting).
2) Activated the "PDF" feature allowing you to send certain financial statements directly to a PDF file instead of to the "view" screen to be printed (BA/Reports/Monthly Financial Statement Reporting or Budgetary Financial Statement Reporting).
Version 2.83 (3/25/2017)
1) Modified the customer deposit procedures (AR/Customer Deposits). Deposits applied to customer billing invoices are now segregated from all other deposits. Deposits applied to billing invoices can be deleted. That is, they can be removed as if they were never applied in the first place. All other customer deposits, on the other hand, can only be reversed.
Version 2.82 (3/17/2017)
1) Corrected a problem with payroll postings for a specific city.
Version 2.81 (3/14/2017)
1) Corrected a problem with payroll postings for a specific city.
Version 2.80 (3/13/2017)
1) Modified EMail billing invoices to make them more presentable (AR/Print Utility Billing Invoices).
2) Minor revisions to Risk Analysis document (Revised 3/10/2017).
3) Corrected a problem with payroll postings for a specific city.
Version 2.79 (3/5/2017)
1) Modified the customer deposit detail entry screen (AR/Customer Deposits/Add). The fund selection was discontinued.
2) Corrected a problem when adding a new utility service item (AR/Setup/Products and Services for Sale). When adding a new service item on the detail screen, the "Utility" class and subclass were not available to be selected previously.
3) Added a feature to allow you to change the bank account for electronic checks (BA/Change Bank Account (Electronic Checks Only)).
Version 2.78 (2/21/2017)
1) Modified rate code assignment procedures (UB/Rate Code Assignments).
Version 2.77 (2/18/2017)
1) Modified the billing exceptions report (AR/Reports/Billing Exceptions Report). A new exception was added to the report.
2) Special procedural code to correct entry errors for a specific city.
Version 2.76 (2/15/2017)
1) Modified the Products and Services function to incorporate business products and services, as well as utility funds and clearing funds (AR/Setup/Products and Services for Sale).
2) Added an edit to the utility billing invoice creation procedure to check if the customer invoice being created is for an "inactive" customer. This edit will reject the attempt to create the billing invoice in the same way it would reject an attempt to create a duplicate billing invoice for the same customer, service address, and billing date (AR/Create and Edit Utility Billing Invoices).
3) Added a new exception to the AR billing exceptions report (AR/Reports/Billing Exceptions Report). The new exception is inactive customers that are still assigned a service address.
Version 2.75 (2/13/2017)
1) Modified the report identifying the products and services for sale, and which ones are active and inactive (AR/Setup/Products and Services for Sale).
2) Disabled the "Enter Customer Deposit Adjustment" button in the Customer Deposits Listing screen (AR/Customer Deposits).
3) Added a new feature to the AR business customer invoicing procedures that allow you to create "Business Invoice Templates". Each template allows up to five invoice line items to be auto-added to a new business customer invoice.
Note: To update the sales tax for the customer invoice as a whole you MUST Edit one of the "template" line items, press Update Line Item, and then press Return to Menu.
Version 2.74 (2/8/2017)
1) Added a new business feature to consolidate in a single screen the chart of accounts for products and services for sale (AR/Setup/Products and Services for Sale).
2) Fixed a problem with the entity's return address on Utility Billing invoices (AR/Print Utility Billing Invoices). This affected only customer utility billings printed after February 3, 2017. It did not impact any other part of the billing invoice.
Version 2.73 (2/4/2017)
1) Modified business invoicing procedures (AR/Create and Edit Business Billing Invoices).
2) Minor modification to paycheck stub (PR/View Paychecks or Print Paychecks).
3) Minor modification to The New Approach - Risk Analysis Overview (Revised 1/29/2017).
4) Minor modification to The New Approach - Risk Analysis Audit Procedures and Findings (Revised 1/29/2017).
Version 2.72 (1/22/2017)
1) Added a new report that allows you to print cash receipts by bank account deposit (BA/Reports/Cash Receipts Report).
2) Corrected a report problem limited to a specific city.
Version 2.71 (1/5/2017)
1) Modified the printout of the Form 1096 (BA/Reports/Print Form 1099, Form 1096).
2) Modified the fund account code assignment procedures to check for improper assignments (BA/Setup/Fund Account Code Assignments). When you select a Fund, the computer will automatically search for inactive or deleted codes that have been assigned to the selected fund, and print a report for each type of code.
Version 2.70 (1/2/2017)
1) Added Schedule C (Form 1040) tax reporting capability for NA Business entities (BA/Setup/Receipt Codes Listing and Object Codes Listing).
Version 2.69 (12/26/2016)
1) Updated payroll tax rates and withholding tables for paychecks issued on or after January 1, 2017 (PR/Setup/Tax Tables and Tax Rates).
Note: Kansas and Colorado state rates and withholding tables are the same for 2016 and 2017.
2) Added customer report options (AR/Setup/Customers).
3) Added a new report feature that allows you to "re-print" a cash receipt (CRBook/View and Print OTC Cash Receipt Records/Re-Print Selected OTC Receipt).
4) Added a new feature to track customers by Business Segment (AR/Setup/Customer Type Assignments/Create BS Assignments).
Version 2.68 (12/19/2016)
1) Modified various reports primarily to segregate active and inactive records. The affected reports are for customers, vendors, payroll pay types, and payroll benefits and deductions.
2) Modified the Project Estimating procedures for business segments (AR/Create and Edit Project Estimates).
Version 2.67 (12/15/2016)
1) Corrected a minor problem when creating the first billing of the new year (AR/Create and Edit UB Invoices).
2) Modified the Project Estimating procedures for Business Segment Funds.
Version 2.66 (12/8/2016)
1) Corrected a problem with the business billing procedures (AR/Create and Edit Business Billing Invoices).
2) Modified the business billing procedures (AR/Create and Edit Business Billing Invoices). Added the capability to enter "Item Reference" information to the invoice line item detail.
Version 2.65 (12/6/2016)
1) Modified the default fund account code assignment procedures for local governments to correct a problem (BA/Setup/Fund Account Code Assignments).
Version 2.64 (12/5/2016)
1) Activated the default fund account code assignment procedures for local governments (BA/Setup/Fund Account Code Assignments).
Version 2.63 (12/1/2016)
1) Added a new feature to display and print unassigned service addresses (UB/Customer Service Addresses).
2) Added a new report that displays only customers assigned multiple service addressesses (AR/Setup/Customers).
3) Corrected an intermittant problem in which the fund number sometimes would not "reset" when adding a customer deposit (AR/Customer Deposits).
4) Made minor modifications to the BA Expenditure Approval Report (BA/Reports/Expenditure Approval Report). A grand total was created to include employee paychecks for the period.
5) Activated the "Stop Update Now" button on the AR/Delinquent Accounts screen and the "Stop Print Procedure Now" button on the AR/PrintUtility Billing Invoices screen.
6) Corrected an inquiry error (checks) related to the Version 2.62 upgrade (BA/Inquiries/Inquiry - Checks).
Version 2.62 (11/30/2016)
1) Added a new Project Estimating system for small businesses (AR/).
Version 2.61 (10/29/2016)
1) Modified the UB delinquent account procedures to avoid duplicative processing (AR/Delinquent Accounts).
Version 2.60 (10/9/2016)
1) Modified the customer listing report to prevent duplicate rate codes from being displayed (AR/Setup/Customers).
2) Added a new customer listing report to allow you to print a report with only one line per customer that contains the customer's service address (AR/Setup/Customers).
Version 2.59 (10/4/2016)
1) Modified an edit in the paycheck print procedures (PR/Print Paychecks or PR/View Paychecks).
Version 2.58 (9/30/2016)
1) Corrected a problem with the meter usage reports (AR/Reports/Monthly Meter Readings and Usage).
Version 2.57 (9/29/2016)
1) Corrected a problem for one city.
Version 2.56 (9/26/2016)
1) Corrected a problem that caused NA to shut down when printing certain reports. The problem appears to affect only Win 10 computers that were recently updated.
2) Modified several GAAP Inquiry reports for formatting purposes (GAAP/Inquiries/Journal Entries).
Version 2.55 (8/28/2016)
1) Modified the procedures to convert BA cash basis data to accrual basis format for GAAP reporting purposes (GAAP/Import Cash Basis Trial Balance).
2) Added a new GAAP report to show revenues and expenses converted from BA cash basis data to GL revenues and expenses (GAAP/Inquiries/Journal Entries).
3) Modified the AR customer payment procedures to correct a problem in which, in very specific circumstances, the procedure would not allow an "ACH Group" payment record to be 'approved" for processing (AR/Customer Payments/Add).
4) Added new reports for GAAP journal entries (GAAP/Inquires Menu/Journal Entries).
Version 2.54 (8/21/2016)
1) Added an edit to the customer payments detail entry screen to disallow entering a customer payment with a date that is earlier than a customer payment to the same customer account number already processed in the system (AR/Customer Payments/Add).
2) Corrected a problem printing meter reading sheets (AR/Reports/Meter Reading Sheets). Under certain circumstances the report would not print.
3) Modified the customer payment procedures (AR/Customer Payments/Add). More detailed informational messages provided to allow you to better determine if the customer payment is ready for processing or possibly needs some investigation before processing is approved.
Version 2.53 (8/15/2016)
1) Corrected a problem with the monthly meter readings and usage report (AR/Reports/Monthly Meter Readings and Usage). The utility billing rate codes being reported were incorrect.
Version 2.52 (7/25/2016)
1) Modified cash receipt deposit procedures to prevent certain cash receipts created from posted customer payments from inadvertently being included in the wrong "computer" generated deposit (BA/Cash Receipts Deposit).
2) Modified the ACH customer payment procedures to allow you the option of creating two separate ACH text files (i.e., separate files for Residential and Business) or creating a single "Residential" file that includes business customers (i.e., same single file that was created in the past) (AR/Create ACH Payment or Pre-Note File).
Version 2.51 (7/7/2016)
1) Modified the procedures to automatically create customer payment records from the ACH Group payment OTC entry (AR/Customer Payments/Add). Note that a separate OTC entry must be made for each of the two ACH text files that you created - one for business customers and the other for residential (non-business) customers.
Version 2.50 (6/19/2016)
1) Added a new payroll report that shows pay types excluded from gross pay for specified benefits and deductions (PR/Reports/Payroll Benefits and Deductions Report).
Version 2.49 (6/14/2016)
1) Modified the Accounts Receivable ACH customer payment procedures. Instead of creating a single text file for all ACH customer payments, two separate text files must be created - one for Residential customers and one for Business customers (AR/Create ACH Payment or Pre-Note File). The ACH screen allows you to select either Residential or Business customers.
Version 2.48 (6/12/2016)
1) Added a new feature and report that allows you to add "comments" to a customer deposit record and print the report with or without the comments (AR/Customer Deposits).
2) Added new AR reports that show the Billing Invoice line number along with the Billing Invoice number (AR/Accounts Receivable Detail).
Version 2.47 (5/30/2016)
1) Corrected a problem reporting medicare gross pay in certain instances where the employee was subject to medicare tax but not subject to social security tax.
2) Added or revised several download documents. Look for revision dates 5/30/2016.
Version 2.46 (5/15/2016)
1) Corrected an error in the AR Billing Adjustments report in which the report would fail to print if any customer names exceeded a certain length (AR/Billing Adjustments).
2) Added an edit to the utility billing calculation procedures to prevent an error message when using "Demand Units" in certain circumstances (AR/Create and Edit Utility Billing Invoices).
3) Added an edit to utility billing rate procedures that applies only to Sewer utility billing rates (UB/Utility Rates).
Version 2.45 (5/9/2016)
1) Made minor modifications to the Customer Deposit tracking and reporting system (AR/Custom Deposits).
2) Modified the AR ACH payment procedures to allow you to remove an ACH payment by clicking on Remove Selection (AR/Create ACH Payment or Pre-Note File). The procedure automatically inactivates the customer's ACH status, but it can be re-activated later if necessary.
3) Made minor modification to the fund summary financial statement (Kansas format) by changing several 'fund type' descriptions to meet KMAAG requirements (BA/Reports/Budgetary Financial Statement Reporting).
4) Modified the AR Billing Adjustments report (AR/Billing Adjustments). A second report was added with comments.
5) Revised several AR download documents. Look for 5/9/2016 revision dates.
Version 2.44 (4/20/2016)
1) Corrected a problem with an AR reconciliation report revised with NA Ver. 2.43.
Version 2.43 (4/19/2016)
1) Revised two AR download documents (dated 4/18/2016).
2) Modified AR Monthly Customer Payment Reconciliation reports.
A new column was added to compare the AR amount allocated to the various funds to the amount recorded in BA for the same fund and reporting period (month). Use AR/Reports/Monthly Customer Payment Reconciliation and select Customer Payments to BA Cash Receipts.
The report reconciling AR customer payments to OTC customer payments was modified to handle differently instances where no variances were found between AR and OTC customer payments.
3) Added a new feature that allows you to print an Expenditure Approval Report for a single bank account (summary report only). Use BA/Reports/Expenditure Approval Report.
Version 2.42 (4/5/2016)
1) Activated the Estimated Water Usage feature for use with Sewer billing computations (UB/Estimated Water Usage).
Version 2.41 (4/4/2016)
1) Corrected a problem on Utility Billing Invoices in which the unpaid balance forward was computed improperly in certain circumstances (AR/Print Utility Billing Invoices).
Version 2.40 (4/3/2016)
1) Special procedural code written for and applies to a single city.
Version 2.39 (3/13/2016)
1) Added a new feature to allow you to print utility billing invoices in customer account number sequence in addition to customer name and billing invoice number (AR/Print Utility Billing Invoices).
2) Disabled the "Reverse" command button on the Billing Adjustments screen (AR/Billing Adjustments).
3) Minor modifications to the AR monthly reconciliation reports (AR/Reports).
4) Added a new feature to allow you to print an OTC Daily Cash Receipts Report for a single date (as in the past) as well as a date range. To print the report for a date range use CR Book/View and Print OTC Cash Receipt Records/Enter Date Range/Click on Print "Daily" Cash Report.
Version 2.38 (3/6/2016)
1) Modified the utility billing invoice sheets that are printed in customer sequence. The current and previous meter readings were added. Previously only the usage appeared on the billing sheet (AR/Print Utility Billing Invoices).
2) Modified the AR billing by utility report to separately classify "utility" billings from billings for services not classified as utilities (AR/Reports/Billings By Utility Report).
3) Added the "progress bar" feature to two additional financial reports - Billings Register and Accounts Receivable Report (AR/Reports). The progress bar allows you to watch the progress as a report is being processed.
4) Modified the billing card format. The customer name, account number, invoice number, and service address were re-arranged slightly (AR/Print Utility Billing Invoices).
5) Modified the OTC Daily Cash Report to include a breakdown of customer payments and all other payments (CR Book/Print Daily Cash Report).
6) Modified the detail and summary customer payment allocations reports (AR/Reports/Customer Payment Allocations).
Version 2.37 (2/29/2016)
1) Modified the accounts receivable detail reports to add customer's deposit amount (AR/Customer Assistance).
Version 2.36 (2/28/2016)
1) Modified the electronic trial balances used by some auditors. The transaction date was added to the detailed trial balances (Startup/Electronic Trial Balances for Auditor).
2) Modified the utility billing sorted by customer. The customer's service address was added to the billing (AR/Print Utility Billing Invoices).
3) Modified the summary accounts receivable reports to display the customer's deposit balance along with the customer's accounts receivable "account" balance (AR/Reports/Accounts Receivable Report).
Version 2.35 (2/21/2016)
1) Modified the accounts receivable detail report to allow tracking at the billing invoice line level (AR/Customer Assistance).
Version 2.34 (2/18/2016)
1) Modification to correct error in generation of fund detail report (BA/Reports/Budgetary Financial Statement Reporting).
Version 2.33 (2/17/2016)
1) Added a cautionary message to document the "removal" of electronic checks (BA/Create Electronic Check Records).
2) Corrected a problem with the utility meter readings report displaying duplicate meter readings in certain circumstances (AR/Reports/Monthly Meter Readings and Usage).
3) Added a new feature to group funds by category for financial reporting purposes. To add fund categories use BA/Setup/Fund Categories. To assign a fund category to a fund use BA/Setup/Funds.
4) Activated the progress bar on the delinquent accounts screen for "updates" (AR/Delinquent Accounts).
5) Activated the progress bar on the print billings screen (AR/Print Utility Billing Invoices).
6) Activated the electronic meter reading feature for Metron (UB/Electronic Meter Readings).
Version 2.32 (2/8/2016)
1) Minor modification to the Billing Adjustment procedures (AR/Billing Adjustments).
2) Revised the download document Utility Billing Adjustments (2/8/2016).
3) Corrected a problem with a corrupted record for a city.
Version 2.31 (2/7/2016)
1) Modified the procedure to delete customer payments (AR/Customer Payments/Delete).
2) Added an edit when creating or editing billing invoices to assure that the processing of all invoices has been properly "completed" (AR/Create and Edit Utility Billing Invoices).
3) Modified the appearance of the sheet format for Business Billing Invoices (AR/Print Business Billing Invoices).
4) Revised the download document Cash Receipt Procedures for Customer Payments (2/7/2016).
5) Revised the download document Cash Receipt Problems (2/7/2016). Problem 4 was revised.
Version 2.30 (2/4/2016)
1) Added a feature to the customer deposit clearing function to allow you to add deposit adjustment entries (AR/Customer Deposits/Enter Customer Deposit Adjustment).
Version 2.29 (2/3/2016)
1) Modified the procedures to approve customers for ACH payment (AR/Setup/Customers Using ACH Payments).
2) Added a feature to the customer accounts receivable reports that allow you to add the immediate prior year transactions to a customer's detailed report (AR/Customer Assistance and AR/Reports/Accounts Rreceivable Report).
Version 2.28 (1/28/2016)
1) Modified the Accounts Receivable ACH procedures to allow level pay customers to use the ACH payment feature.
Version 2.27 (1/27/2016)
1) Added a new feature to the Accounts Receivable deposit clearing function. The new feature allows you to reverse a deposit applied to a billing invoice and re-apply it to another billing invoice (AR/Customer Deposits/Apply Overpayments to Billing Invoices).
2) Minor change to the title of the Treasurer's Report (BA/Reports/Monthly Financial Statement Reporting).
Version 2.26 (1/24/2016)
1) Minor revision to YEC document for stage 3.
2) Added a revised BA download document "Year-End Encumbrances".
3) Modified the fund summary report generation procedures to exclude inactive funds (BA/Reports/Monthly/Cash/Budgetary Financial Statement Reporting).
4) Modified the treasurer's report to include payroll payable (i.e., payroll encumbrances) for year-end (BA/Reports/Monthly Financial Statement Reporting).
Version 2.25 (1/17/2016)
1) Modified the accounts payable (invoicing) procedure to simplify the application of an encumbrance (e.g., purchase order) to an invoice (BA/Accounts Payable/Add).
2) Added some new Utility Billing meter readings and usage reports (AR/Reports/Monthly Meter Readings and Usage). These reports require that you enter the Usage Reporting Factor for each Rate Code using UB/Utility Rates.
3) Minor modifications to the appearance of financial statement reporting (BA/Reports/Monthly/Cash/Budgetary Reporting).
4) Added an option to print Utility Billing invoices in customer name sequence (AR/Print Utility Billing Invoices).
Version 2.24 (1/10/2016)
1) Added a new procedure to speed up the generation of reports in some circumstances. The procedure displays a brief message that is removed from the screen automatically.
2) Added a new option to send the Treasurer's report to a Word document format (BA/Reports/Monthly Financial Statement Reporting). Minor modification to report title.
3) Added numerous new reporting capabilities that can be found using BA/Reports/ and Monthly Financial Statement Reporting, Cash Financial Statement Reporting, and Budgetary Financial Statement Reporting. You can use the Budgetary reporting selection to print financial statements for your Annual Financial Report. Be careful with the options to print the Fund Detail financial statements because they will be sent directly to the printer, not to the view window.
Version 2.23 (1/6/2016)
1) Modified the report display procedures to re-activate the temporary "display" message. Some reports were not being displayed on some computers without the "display" message.
Version 2.22 (1/5/2016)
1) Modified the report display procedures to remove the temporary "display" message.
Version 2.21 (1/4/2016)
1) Modified the report display procedures to speed up the process in certain circumstances.
2) Minor modification to the financial statement reporting screens (BA/Reporting/Monthly/Cash/Budgetary Financial Statement Reporting).
Version 2.20 (1/3/2016)
1) Corrected a problem creating Pre-Note file in which the customer name placed in the ACH text file exceeded the maximum allowed by ACH (AR/Create ACH Payment or Pre-Note File).
2) Added an edit in the UB billing invoice creation procedure to prevent user from attempting to update a billing invoice line item without selecting it from the listing of line items (AR/Create and Edit Utility Billing Invoices).
3) Disabled BA Reports menu item selection for "Fund Detail (Year-End) Statements". This selection was previously replaced with BA/Reports/Budgetary Financial Statement Reporting.
Version 2.19 (12/28/2015)
1) Updated payroll tax rates and withholding tables for paychecks issued on or after January 1, 2016 (PR/Setup/Tax Tables and Tax Rates).
2) Updated the financial statement reporting procedures (BA/Reporting/Monthly/Budgetary/Cash Financial Statement Reporting).
Version 2.18 (12/20/2015)
1) Added a special procedure for a single city.
Version 2.17 (12/14/2015)
1) Minor change to Accounts Receivable detail report (AR/Accounts Receivable Detail).
2) Modified procedure to delete a billing invoice (AR/Create and Edit Utility Billing Invoice).
3) Added an edit to the ACH customer activation procedure to not allow activation unless customer's account balance equals zero (AR/Setup/Customers Using ACH Payments).
Version 2.16 (12/7/2015)
1) Minor modification to Form W-3 (Box b), Form 1096, and Form 1099 Misc.
2) Modified Accounts Receivable ACH procedures to automatically load OTC entries after they are created (AR/Customer Payments). Also, added an edit to the related OTC ACH total entry to check for possible duplicate OTC entry (CR Book).
3) Revised download document "Billing ACH Procedures".
Version 2.15 (12/2/2015)
1) Modified the Accounts Receivable summary report to support beginning balances for the year-to-date (AR/Reports/Monthly Accounts Receivable Summary).
2) Activated the AR - Starting a New Year procedure (AR/Setup/Starting a New Year).
3) Corrected a problem with the banking deposits and withdrawals procedure (Banking/Deposits and Withdrawals).
Version 2.14 (12/2/2015)
1) Modified the customer deposit procedures to allow a deposit applied to a billing invoice to be removed from the invoice and deleted (AR/Customer Deposits).
Version 2.13 (12/1/2015)
1) Modified Accounts Receivable procedures to automate ACH customer payments (AR/Customer Payments). Refer to revised download document for guidance.
2) Modified OTC (CR Book) procedures to allow for multiple customer ACH Group Payment (DBC).
3) Modified the banking deposits and withdrawals procedures to allow for comments on each transaction (Banking/Deposits and Withdrawals).
4) Revised download document "Billing ACH Procedures".
Version 2.12 (11/23/2015)
1) Activated the year-end annual financial statements (BA/Reports/AFR Financial Statements).
2) Modified the creation of Electronic Meter Reading records to add business name to the record (UB/Electronic Meter Readings).
3) Updated the year-end closing download documents.
Version 2.11 (11/20/2015)
1) Added edits to utility billing customer name entries to prevent user from entering a comma in the name (AR/Setup/Customers).
2) Modified the ACH procedures for direct deposit paychecks and budgetary accounting vendor payments.
3) Minor changes to Accounts Receivable reconciliation reports (AR/Reports/Monthly Customer Payment Reconciliation).
4) Made modifications to the monthly Accounts Receivable report (AR/Reports/Monthly Accounts Receivable Summary).
5) Activated the Form 1099 reports and form printouts (BA/Reports/Print Form 1099, Form 1096).
Version 2.10 (10/28/2015)
1) Modified the procedure to create meter reading records (UB/Manual Entry of Meter Readings). The customer name was not being picked up properly in certain circumstances.
Version 2.09 (10/18/2015)
1) Modified the electronic meter reading procedures for the vendor ITRON (UB/Electronic Meter Readings).
2) Modified the utility billing reconnection fee procedures. Refer to related (new) download document.
3) Introduced a new procedure to restrict users' access to certain screens without our assistance. This new security procedure applies only to certain startup procedures and new procedures being developed.
4) Revised the download document UB Setup for Electronic Meter Readings (Revised 10/15/2015).
Version 2.08 (10/11/2015)
1) Added a new reporting feature for utility meter readings (AR/Inquiry - Utility Meter Readings).
2) Added an edit to restrict use of the electronic meter reading screen without advanced preparation (UB/Electronic Meter Readings).
3) Added a new feature to delinquency reporting (AR/Delinquent Accounts). The new procedure allows you to print "Door Hangers".
4) Made minor modification to detailed utility billing customer type report for usage units (AR/Reports/Customer Type Reports).
Version 2.07 (9/15/2015)
1) Corrected problems with corrupted data related to allocation of customer payments for each of two different cities.
Version 2.06 (9/1/2015)
1) Added a special procedure for a single accounting entity.
Version 2.05 (8/31/2015)
1) Corrected a problem with the zip, upload, and billing email procedures. The error was caused by a password certification problem that surfaced on 8/31/2015 after the "trial period" had ended.
Version 2.04 (8/30/2015)
1) Corrected a problem with creating billing adjustment credits in certain circumstances (AR/Billing Adjustments).
2) Added a special procedure for a single accounting entity.
Version 2.03 (8/18/2015)
1) Modified the trifold delinquency letter for use with window envelopes as well as a trifold letter.
Version 2.02 (8/17/2015)
1) Corrected a minor problem with the Version 2.01 upgrade file.
Version 2.01 (8/14/2015)
1) Created a new "statup" database file for NA Version 2.01.
2) Revised download document "Installation and General Startup". (Revised 8/14/15)
3) Modified the startup chart of accounts procedures to include both local governments and businesses.
Version 1.86 (8/6/2015)
1) Corrected a problem with the email billing invoices (AR/Print Utility Billing Invoices). Previously the unpaid balance forward and amount due were incorrectly computed in certain circumstances.
2) Removed the warning message (Customer Deposits Applied and Credit Adjustments Applied) when printing utility billing invoices.
3) Corrected a problem when printing paper checks in which the Check Memo was not being printed on the paper check (BA/Print Paper Checks).
4) Corrected a problem with the monthly customer payment reconciliation (AR/Reports/Monthly Customer Payment Reconciliation). Previously customer payments not recorded in the CR Book were being summarized in a single line.
Version 1.85 (7/27/2015)
1) Revised download document Billing ACH Procedures (7/26/2015).
2) Modified the billing adjustments screen to allow you to select a customer (AR/Billing Adjustments).
3) Corrected a problem with the "sheet" billing format in which the amount due was calculated wrong in certain circumstances (AR/Print Utility Billing Invoices).
Version 1.84 (7/22/2015)
1) Corrected a problem with the utility billing invoice calculation procedure (AR/Create and Edit Utility Billing Invoices). The problem was in the initial creation of the billing invoice (but not in the manual re-calculation procedure). The problem affected only metered utilities that use a rate code that has a rate value for variable rate level 5 or 6 and the units of usage exceeded a certain level.
Version 1.83 (7/10/2015)
1) Corrected a problem when creating the AR ACH text file using customers with a name that exceeds the length allowed by ACH rules (AR/Create ACH Payment or Pre-Note File).
2) Modified the AR Billings By Utility report to include penalty assessments (AR/Reports/Billings By Utility Report). This allows you to visually tie the grand total to the AR monthly summary report.
3) Modified the Listing of Outstanding Electronic Checks to print the checks in date and check number order (Banking/Outstanding Electronic Checks).
4) Modified the Meter Readings and Usage report to allow a report for a single customer (AR/Reports/Monthly Meter Readings and Usage).
Version 1.82 (7/5/2015)
1) Removed the procedure that sends a vendor check or a paycheck "directly" to the printer. All checks will now appear in a view window, similar to financial statements and reports, with the option to print.
2) Added a caution message when printing billing invoices to provide an alert regarding the amount of customer deposits and the amount of billing credit adjustments that have been applied (or not applied) to the invoices selected to be printed (AR/Print Utility Billing Invoices).
3) Made some changes to the OTC cash receipt entry procedures (CR Book). The CR Book Daily Cash Receipts Report was modified to help make is more useful and more understandable.
Version 1.81 (7/1/2015)
1) Added a new Accounts Receivable monthly reconciliation report for billing adjustments (AR/Reports/Monthly Billing Adjustments Report).
2) Revised the Customer Payment Allocations By Fund (AR/Reports/Monthly Customer Payment Reconciliation).
3) Added the NA download document Accounts Receivable Month-End Reconciliation Procedures (Revised 7/1/2015).
Version 1.80 (6/28/2015)
1) Modified the monthly Accounts Receivable report (AR/Reports/Monthly Accounts Receivable Summary).
2) Added a new report to the AR module - Monthly Customer Deposits Summary Report (AR/Reports/Monthly Customer Deposits Report).
3) Added two new customer payment reconciliation reports - 1) Customer Payment Allocations by Fund, and 2) Reconciliation of Customer Payments to OTC Cash Receipts (AR/Reports/Monthly Customer Payment Reconciliation).
4) Minor modification to the OTC cash receipts report (CR).
Version 1.79 (6/20/2015)
1) Added the Pet Licensing feature to NA (PL).
To move your Pet License related records from GS to NA you must do the following:
Step 1 - Create GS Backup. Start up GS, Exit, and Create a backup of your current GS database file.
Step 2 - Rename GS Backup. Rename the backup file created in Step 1 with the prefix "Old" (e.g., OldLincoln.accdb).
Step 3 - Copy Renamed Backup. Copy the renamed backup file from Step 2 to the NA database folder (C:\ProgramData\NA\Databases).
2) Added a new feature that allows you to create billings for non-utility products and services. This new billing capability is independent of the utility billings, but at the same time integrated with the overall AR module.
At the present time this feature is password protected to restrict its use for the purpose of testing.
3) Changed the procedures to print vendor checks to sort the printed checks in vendor name order (BA/Print Paper Checks).
4) Corrected a utility rate edit that did not function as it was intended (UB/Utility Rates).
5) Corrected a problem in which the amount due if not paid by due date was displayed on the billing invoice incorrectly in certain circumstances (AR/Print Utility Billing Invoices).
Version 1.78 (6/7/2015)
1) Added an edit to the customer payment procedure to display an information message if the payment does not equal the customer's current unpaid balance (BB/Customer Payment).
2) Replaced "trial" password with a permanent password for use with the Zip procedure, the Upload procedure, the Download procedure, and the EMail billing procedure.
3) Mid-Month Billings download document put online (5/28/2015).
Version 1.77 (5/28/2015)
1) Added new feature to "automatically" record an estimated meter reading when the meter is not accessible (UB/Manual Entry of Meter Readings).
2) Modified the procedure to generate the customer payment allocations report to correct an error (BB/Reports/Customer Payment Allocations).
Version 1.76 (5/27/2015)
1) Modified the Utility Billing system-wide summary report and renamed it Monthly Accounts Receivable Summary (BB/Reports/Monthly Accounts Receivable Summary).
2) Added two new Billing and AR reports to assist in reconciling customer payments to OTC and BA cash receipts (BB/Reports/Monthly Customer Payment Reconciliation.
3) Added a new feature to remove Billing and AR testing records.
Version 1.75 (5/19/2015)
1) Updated billing email procedures (BB/Print Billing Invoices) as well as backup procedures.
Important: The updated procedures require that NA Patch Version 1.75 also be installed after NA Upgrade Version 1.75 has been installed.
2) New NA Setup installation file created reflecting the new procedures in Version 1.75.
Version 1.74 (5/12/2015)
1) Added an edit to customer email billing procedrue to check if Outlook is installed and open (i.e., running) (BB/Print Billing Invoices).
2) Modified the procedure to edit customer payments (BB/Customer Payments).
3) Revised download document UB Setup and Billing Cycle Procedures.
Version 1.73 (5/10/2015)
1) Expanded the different types of customer Accounts Receivable reports that can be printed (BB/Reports/Accounts Receivable Report).
2) Added a new feature to allow for customers to receive their billing invoices by email (BB/Print Billing Invoices).
3) Revised download document UB Setup and Billing Cycle Procedures.
4) Added an edit to disallow changing a check number after the check has cleared the bank (BA/Change Check Numbers (Paper Checks Only)).
Version 1.72 (5/4/2015)
1) Corrected a problem with the billings register report generation (BB/Reports/Billings Register).
2) Corrected a problem with monthly fund summary report generation (BA/Reports/Fund Summary (Monthly Statements).
3) Modified the service addresses report to print in sort (sequence) order instead of SA number order (BB/Customer Service Addresses).
Version 1.71 (5/3/2015)
1) Modified the accounts receivable record editing function to permit more extensive editing capability (BB/Accounts Receivable Detail).
2) Added a new feature that allows entry of a close-out billing invoice without the need to go through the Manual Meter Reading Entry process (BB/Create and Edit Billing Invoices).
3) Several download documents have been revised or added. Refer to revision dates.
Version 1.70 (4/30/2015)
1) Changed the customer payment procedures to prevent a customer payment from being allocated to an unpaid billing invoice dated after the customer payment (BB/Customer Payments).
Version 1.69 (4/29/2015)
1) Corrected an error when creating "blank" meter reading records for entry of meter readings. If a service address was assigned to a new (different) customer since the last billing date, the computer would not pick up the previous meter reading. The problem has been fixed (UB/Manual Entry of Meter Readings).
Version 1.68 (4/28/2015)
1) Modified the Accounts Receivable detail entry screen to enable entry of certain values (BB/Accounts Receivable Detail).
2) Corrected a problem with creating sewer meter readings from related water meter readings (UB/Manual Entry of Meter Readings).
3) Added an edit to the billing invoice listing to prevent the deletion of a billing invoice that has had a payment applied to it (BB/Create and Edit Billing Invoices).
Version 1.67 (4/23/2015)
1) Corrected an error in computing the ACH customer payment amount where the customer had a deposit applied to the billing invoice (BB/Customer ACH Payment or Pre-Note File).
Version 1.66 (4/22/2015)
1) Corrected a problem with the procedure that generates the delinquent accounts report (BB/Delinquent Accounts).
2) Modified the procedure to load billing dates in the billing invoice listing (BB/Create and Edit Billing Invoices).
3) Modified the utility meter information procedures and modified the meter information report (UB/Utility Meter Information).
4) Modified the customer reports (BB/Setup/Customers).
Version 1.65 (4/21/2015)
1) Modified the delinquent accounts report to dispaly the accounts in customer name order. Also, the balance owed was added to the report. (BB/Delinquent Accounts)
2) Modified the delinquent account billing card format to include customer payments on the account balance owed (BB/Delinquent Accounts). This modification affected only customers that had made payments on their account balance but still had a delinquent account balance.
Custom Micro Works © 2009-2017