MoneyWise Solutions
E-mail Questions or Comments
  • Home
  • COBRA Online
  • COBRA Links
  • ACA Reporting
  • CDH Benefit Support
  • ERISA / FLEX
  • Contact Us

The Gravel Road of Reconciliation

5/8/2015

0 Comments

 
Picture
Most of us cannot tell the difference between the Formula 1 car above and the Indy Cars that race on Memorial Day in Indiana.  All of us can see that the track above is not ready for this type of car and it is also a sure thing that lap times on gravel would really be slow compared to the now finished track just outside of Austin Texas.

That is my point.  

Over 80% of our clients never reconcile their monthly carrier bills for benefit insurances.  The reason is that the client is using a system that is much like the gravel track above.  It takes forever to do and with the interruptions of e-mails and urgent phone calls, it just gets put off for another month.  Then it is three times harder to do.  The next month it becomes a project that feels like it will take days to complete. 

We have one client that has 7 voided carrier invoices over two months and now they have overpaid their carrier bill by more than $2,000 and have no clue how to claim the credit.  Another client over paid their bill by over $8,000 because three people were not termed off the carrier bill until nearly 5 months after the last date of employment.   What messes these are!

So, how can these folks move from a gravel road to a smooth paved track that will allow reconciliation to be done in 15 minutes each month.

First, acknowledge that it takes three items to reconcile.  The payroll deductions report, the carrier bill and the COBRA activity report.  Make a spreadsheet that has the carrier bill on it ... listed by last name of the participants.  Then a column that shows the payroll deductions, the employer share of the premium and one more column for COBRA.  Move the information for the same month around until it just makes sense to you.  When you get it on there and formatted correctly, it is magic. It will be plain to see any errors.  

The spreadsheet also gives you a Note capability so you can flag pending items and credits or debits.  The carrier bills are always two months behind.  That is why they need to be the first item entered.  The carrier bill has to be paid as presented so tracking the pending credits and debits will be easy month to month.

Last thing.  Only touch this once each month.  Get all the info together, update the spreadsheet by copying last month's into a new worksheet and get the entries updated.  You will soon feel like Staples ... "That was easy!"


0 Comments



Leave a Reply.

    Frank Surface

    MoneyWise Solutions, Inc.
    Principal

    Archives

    February 2022
    November 2021
    April 2021
    September 2020
    August 2020
    May 2020
    February 2020
    January 2020
    December 2019
    September 2019
    July 2019
    February 2019
    December 2018
    July 2018
    August 2017
    April 2017
    March 2017
    January 2017
    July 2016
    March 2016
    January 2016
    December 2015
    November 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    March 2015
    January 2015
    November 2014
    August 2014
    June 2014
    May 2014
    April 2014
    January 2014
    October 2013

    Categories

    All

    RSS Feed