Professional Computer Systems, Co.

March 2018, Newsletter Issue No. 36


  • Marc's Insights
  • Power BI is Here!!
  • Connect with Angie
  • Points form PSN
  • Notification of PSN IP Address Change
  • New Employee
  • Annual User Group Meeting
  • Upcoming Webianrs

  • Upcoming Conferences:

    NWPPA Annual Conference & Membership Meeting
    Boise, ID
    May 20-23, 2018

    PCS Annual User Group Meeting
    Denison, IA
    June 4-7, 2018

    APPA National Conference & Public Power Expo
    New Orleans, LA
    June 18-19, 2018

    Upcoming Webinars

    Purchase Order Requisitions
    April 5, 2018 1:30 PM CDT
    (Click here to sign up.)

    What Does Connect Have That You Don't?
    April 11, 2018 1:30 PM - 3:30 PM CDT
    (Click here to sign up.)

    Ins and Outs of Connect Business Intelligence and Power BI
    May 17, 2018 1:30 PM CDT
    (Click here to sign up.)

    To view the 2018 class schedule and dates Click here

    Know someone interested in receiving our newsletter?

    Forward this to them so they can sign up today at the PCS website in the client area at or email


    Phone: (888) 843-3106

    Happy Easter!

    Marc's Insights

    To Balance, or Not to Balance, is not really a question...

    Let's start with a pop quiz question.

    How often should you balance/reconcile the GL to subsidiary ledgers?

    1. Never
    2. Occasionally
    3. Just before annual audit
    4. Monthly

    We all know the answer. And yes, there is only one right answer.

    Do a Google search on "reconciling the GL" and like with any Google search you will get thousands of hits. But this one was toward the top of the list: "Reconciling the balances in the Accounts Receivable module with AR accounts in General Ledger is an important step and should be done as part of the month-end closing process. If a monthly reconciliation is done, the proper documentation will be available if an audit is performed, and any differences that exist between the two modules can be caught and corrected before the period is closed." That one is from Microsoft. I underlined what I feel are two key points in that statement.

    Before I continue, let's try to define the difference between "reconciling" and "balancing". One definition doing another Google search said this: "Reconciliation is an accounting process that uses two sets of records to ensure figures are correct and in agreement. It confirms whether the money leaving an account matches the amount that's been spent, ensuring the two are balanced at the end of the recording period."

    Click Here for the rest of the article

    Top of Page

    Power BI is here!!

    Many utilities have taken a dive into their data with Business Intelligence. The next level of BI is here - Power BI. Power BI is an online, interactive BI tool. PCS developed a library of parts, so users can quickly visualize, filter and drill into data. Users can also create customized dashboards with the click of a button. Initial pre-built parts include Connect payment trends, revenue and usage trends, service orders, top consumers and Insight actual vs budget analysis, cash analysis, depreciation analysis and financial statics and ratios.

    View a short demo of PCS' Power BI here.

    Want to see more? View our 3-part Power BI webinar series:

    Part 1 - Overview

    Part 2- Connect

    Part 3 - Insight

    Contact to get started and with any questions you have.

    Power BI creates impressive visuals that can be distributed on a variety of devices.

    Top of Page

    Connect with Angie

    Would You Like A Receipt?

    Utilit-e Online now provides the option to View and/or Email a receipt. Upon completing a payment. The View Receipt and Email Receipt buttons display on the screen under the message stating the payment was successful.

    This functionality is available with release 7.0.703. The ability to email the receipt also requires that you have the Integrated Messaging (IM) module licensed. If you are emailing notifications to your customers that their statement is available online and or that their payment has posted, for example, then you already have IM. If you are interested in implementing the Online receipt capabilities, please contact your Connect support person.

    Top of Page

    Points from PSN

    Consolidating Bank-Initiated Customer Payments

    If you would like to...

    • Eliminate bank-issued paper checks
    • Eliminate multiple electronic bank deposits
    • Eliminate hard-to-reconcile payments
    • Consolidate bank-initiated payments with other electronic payments

    ...then PSN's Bank Bill Pay e-Solution is the way to go. Customer payments initiated in their banks' bill payment systems either arrive many days later as paper checks or are directly deposited, both of which must be manually processed and posted by your staff. Eliminate the hassle.


    PSN "captures" the payment from the bank, makes it an ePayment and processes it through the PSN system. The PSN system automatically recognizes the customer number and automatically posts it to your software, while routing funds to your depository account. If any customer numbers do not match your customer data file, PSN staff researches and then corrects the issue so it is a match for all future payments. The result: payments are consolidated with other PSN payments resulting in one reconciliation report.


    • View payments in real time-just like an online payment
    • Eliminate 99% or more of labor-intensive, hard-to-reconcile paper checks and electronic deposits
    • Bank bill payments are consolidated with all other PSN payments for one deposit and one reconciliation
    • Payments are automatically posted to your software to reduce manual input and errors
    • Customer payments posted more quickly to your software
    • Enhances the customer experience by allowing more options for making payments
    • Faster deposit times


    You can also accept cash and turn it into an ePayment by signing up for PSN's Bank Bill Pay eSolution. PSN provides a list of cash acceptance sites in your area; you choose at which locations you want to allow customers to make payments. For more information, contact your PSN Service Account Manager.

    Top of Page

    Notification of PSN IP Address Change

    By now you have probably all seen the notice sent out by PSN informing everyone of an IP address change. PCS has been fielding numerous questions in regards to this. The big question is “What do we have to do?”. The answer is nothing.

    All payments processed through PCS/PSN go through a common point here at PCS. That is the point where the potential need for an IP address change would occur. PCS uses DNS names as opposed to IP addresses, so no change is required when PSN makes their IP address changes.

    Please let us know if you have any further questions.

    Top of Page

    Welcoming Our Newest Employee!

    Introducing Heather Fineran, Project Analyst on the Insight Team

    Heather joined PCS in mid-December. Loving a challenge Heather pursued business and computer programming after high school. Following that, Heather owned and operated her own business in Denison for 15 years. Heather has an extensive background in customer service and is a proven problem solver. Her goal is to help make our clients jobs easier!

    Heather has been busy with training and is now beginning to take calls. Feel free to ask for Heather when calling about accounting!

    Top of Page

    Annual User Group Meeting

    Planning for the 2018 Annual User Group Meeting is in full swing. Surveys have been sent to get your opinions on new sessions. If you haven't already done so, please reply so your voice is heard!

    The dates for this year's meeting are Monday June 4th through Thursday June 7th. Both Boulders Inn & Suites have their entire facilities blocked off for our group. Reservations can be made by calling 866-430-2692 for the Majestic Hills location or 800-239-0253 for the Oak Ridge location.

    The full slate of sessions will be out soon!

    Top of Page

    Upcoming Webinars

    Upcoming PCS webinars April and May are listed below... click on the title to register

    Purchase Order Requisitions
    April 5, 2018 1:30 PM CDT
    (Click here to sign up.)

    What Does Connect Have That You Don't?
    April 11, 2018 1:30 PM - 3:30 PM CDT
    (Click here to sign up.)

    Ins and Outs of Connect Business Intelligence and Power BI
    May 17, 2018 1:30 PM CDT
    (Click here to sign up.)

    Top of Page

    Click here to view all our Prefered Partners

    This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version at Please do not reply to this message as the "reply to" function does not allow us to receive your email. If you no longer wish to receive our newsletters, please click here to unsubscribe.