Sage 100

 View Only
  • 1.  Payroll Time Off Accrual Reconciliation

    Posted 05-17-2025 13:03

    The general ledger payroll time off accrual account doesn't agree to the Time Off Accrual Report.  How can it be reconciled?  Where can I see the amounts accrued by employee for each payroll period?  I want to see the detail that agrees to the amount posted to the GL accrual account. 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Payroll Time Off Accrual Reconciliation

    Posted 05-18-2025 09:28

    Unless the employees never get raises, I don't think it ever will.  Dollars go into (and out of) the account each pay period.  Life is good until someone gets a raise.  Instead of pulling $22.50 out, they start pulling $25 out.  So at year end (or every quarter), you need to make an adjusting JE based on the hours accrued and the current pay rate.  

    Hours accrued each pay period are stored in the Payroll History Header Table,  I don't think there is a detailed Crystal report.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: Payroll Time Off Accrual Reconciliation

    Posted 05-18-2025 10:31

    Thanks @Jeff Schwenk   In addition to the wage rate differences, there are issues with unused time off that doesn't carry over to a new year or anniversary date, and unused time off for terminated employees.  How is unused time off for terminated employees removed from the Time Off Accrual Report.  the more I go down this rabbit hole the messier it becomes!



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Payroll Time Off Accrual Reconciliation

    Posted 05-19-2025 09:40

    Give my regards to the Mad Hatter if you see him down there.

    Yes, it's probably holier than Swiss Cheese.  So, run the report at QE/YE, dollarize the hours, and make the adjustment.

    There better things to stress about on Sunday mornings.  Like should pull up short of the water with a 7 iron or get on the green with a 5.....



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 5.  RE: Payroll Time Off Accrual Reconciliation

    Posted 05-21-2025 10:33

    Also, when an employee uses a vacation, sick, or other paid time off, salaries and wages (or other expense account) get debited, and cash is credited.  The accrual is never reduced.  So, @Jeff Schwenk you are correct, there is no way the Time Off Accrual Report will ever tie out to the GL accrual account.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------