Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Reconciliation of benefit deductions to vendor invoice

  • 1.  Reconciliation of benefit deductions to vendor invoice

    Posted 11 days ago
    ​Anyone use an ISV to aid in reconciling benefit deductions to vendor invoices?  We have around 2,000 employees actively using benefits and find it a struggle to reconcile the deductions timely.  This includes ensuring the proper follow up is maintained to prevent getting overbilled or receiving proper credits for terminated employees, or any employee change of status.

     #Payroll
     #AccountsPayable

    ------------------------------
    Lisa Jackson
    Compass Health Network
    Clinton MO
    ------------------------------


  • 2.  RE: Reconciliation of benefit deductions to vendor invoice

    TOP CONTRIBUTOR
    Posted 8 days ago
    @Lisa Jackson:

    We have around 1,300 active employees. We don't use an ISV. We use Excel. We export the deduction report into Excel as well as the vendor's invoices then perform a VLookup to compare.​ It can be tedious in the heavier enrollment periods but it works well for us. 8-)

    Thanks

    ------------------------------
    Joni Finnell [Designation]
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------