Sage 100

 View Only
  • 1.  Gift Cards

    Posted 09-04-2020 12:44
    I received the following email from a client regarding gift card.
    I am thinking a new payroll earnings code, but forcing the exact 50 is going to be close to impossible without manual calculation on each employee.

    Any thoughts or advice would be appreciated.
    Thank you
    Michael

    Each year we have always issued gift cards (usually for $50) to employees prior to November.  These have just been regular Visa gift cards that we mail or deliver to them.  Our HR Generalist, has indicated that the gift cards should have been considered taxable income to the employee and reported on their W-2.  We weren't aware and therefore have never done that.  The only way to report it as income would be to run it through payroll.  However, the company still wants to just give them an actual gift card.  So, that raises the following questions to which I need your help with:

     

    1. Can you confirm that gift cards (or anything of monetary value) that is provided to employees is indeed to be considered as taxable income?
    2. Is there a way to run it through the payroll system so it is included as taxable income to the employee?  We still want to give them an actual $50 gift card and don't want to just do it through payroll.
    3. In running it through the payroll system, we would want the end result to be $50, which would entail figuring up what the gross amount would need to be (including the taxes, 401K, etc.) so the net result is $50.  Is there an easy way to do that?


    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------


  • 2.  RE: Gift Cards

    Posted 09-04-2020 13:07
    Not a practicing CPA so I'm not sure what the limit is for small incidental gifts.

    I personally would set it up as a fringe benefit earnings code.  Sage will associate the earnings with an auto FB deduction code.  So you pay them $50 as an earnings code, Sage will handle the taxes and auto create a $50 deduction code to offset.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Gift Cards
    Best Answer

    Posted 09-04-2020 14:31

    Michael – I do this at least twice a year for the employees, and it is a bit of work, but I'll explain how I do it.   What I'm not sure about it the threshold for having to report the Gift Cards to Employees – we do cash bonuses at our Fiscal Year End as well as our Christmas Party, and they're enough that I know I have to report those.  Seems like $50 would be below the threshold, but I'm not a tax expert and don't know about that!

     

    I set up an earnings code of CB (Cash Bonus) that is a Misc Earnings Code, with a Fixed Amount ($54.15 in your case – explained below)) and expense it by department (if you are using Departments in Payroll).  I also set up a Deduction code of CB for a Fixed Amount  ($50 in your case) and use a Deduction Accrual Account that points to a Clearing Account (also explained below!).  You might want to set your earnings code and deduction code up as GC for Gift Card.  Just a thought.

     

    You can back into the amount you want the employee to be paid by dividing the number you want by .9235 – which takes care of the mandatory FICA and Medicare.  (I don't worry about the employee's withholding taxes – just the FICA & Medicare and "any other mandatory Employer Paid Taxes").    In the case of $50, assuming you don't have any mandatory State Taxes that need to be deducted (Oregon has one of those!) you would actually pay the employee $54.15, which is $50 / .9235, and takes care of the employee's $3.36 FICA and $0.79 Medicare deductions.  If you happen to offer profit Sharing, the system automatically calculates that if it is set up as an Employer Contribution.  I don't take the 401k deduction out of the cash bonuses I do – that just would never work out!

     

    When I go to the bank to get the cash (or in your case, whoever you write the check to in order to purchase the Gift Cards), I code that check to a clearing account.   

     

    You would then input all of the checks through Payroll as Manual Checks, using the same check number and check date as the check you wrote for the Gift Cards, but the check amount would be zero for each employee.  The new Earnings code (CB in my case) would be $54.15, and then you use the new CB deduction code  $50 out that you gave the employee in a gift card, and enter $3.36 on the tax screen for FICA and 0.79 for Medicare.  Hence the zero check amount –  the income is recorded for the employee this way, as well as the expense for the employer.  And you will have to make a tax deposit for the FICA and Medicare as well – and obviously you'll be paying for both the employer and the employee.    Everything gets expensed through Payroll, and the check you wrote for the gift cards is cleared out by the deduction you took back through Payroll.  And the gift cards are expensed through payroll departments, or whatever Expense account you designated when you created the Earnings code for the Gift Cards.

     

    There are a lot of steps involved, but this is the only that I've found that works each and every time.

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog facebook twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     






  • 4.  RE: Gift Cards

    Posted 12-03-2020 11:56
    Sue,

    This worked great, but it exposed an interesting issue in 2020 payroll.

    They have a number of employees on Direct Deposit. Since the payroll data entry results in a zero, Sage Payroll Tax Calculation is automatically unchecking direct deposit and forcing us to print a voided check. Of course, Sage says this is working as designed since it is zero.

    Any thoughts, or just let it print voided checks.

    Thank you again for the gift card insgihts.

    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------



  • 5.  RE: Gift Cards

    Posted 12-03-2020 12:10

    Did you change the check header on each employee to be a manual check?  It shouldn't print them if indeed you told it to be a manual check...

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog facebook twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     






  • 6.  RE: Gift Cards

    Posted 12-03-2020 12:14

    Oh!   And I forgot to mention that you have to be careful on the employees who have maxed out on FICA and/or are over the Medicare threshold of $200,000.  You'll have to use different calculations to gross up the wages in those two cases.

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog facebook twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.