Masking Social Security Numbers in Microsoft Dynamics GP

By Michael Zerr | April 11, 2018

According to the Social Security Administration (SSA), identity theft is one of the fastest growing crimes in America. Once a malicious person has your social security number in hand, they can use it to apply for credit cards and secure loans in your name while leaving you with the bill. The process to repair the damage done by an identity thief is time-consuming and expensive, with the cost to the victim at an average of $5,130.

The pain for an individual is magnified when your business is involved. Target is currently in the middle of a class action lawsuit from their 2013 data breach in which personal information from 70 million customers was breached. Their business has suffered losses in consumer confidence and their stock plunged.

A more realistic scenario for a small to medium business is an employee stealing personal information from information found around the office. Microsoft Dynamics GP includes a new feature that masks social security numbers so they do not show up on reports.

The payroll administrator now has the option for masking social security numbers in Microsoft Dynamics GP without having to make Report Writer modifications. At the same time, they can choose to not mask the social security number for reports that may need the social security numbers to display due to state or federal requirements such as W-2s. If the Payroll Administrator selects to apply the mask for one of the predefined reports, when generated, the employee’s social security number field will appear with an XXX-XX-XXXX mask.

The following reports will be applicable for masking:

  • Check Register
  • Cross Company Employee Address List
  • Cross Company Vacation/Sick Time Available List
  • Direct Deposit Check Register
  • Direct Deposit Detail List
  • Direct Deposit List
  • Direct Deposit Register
  • Direct Deposit Statement of Earnings
  • Earnings Register
  • Employee Address List
  • Employee Checks Other-D
  • Employee Checks Other-L
  • Employee Checks Stub on Bottom-D
  • Employee Checks Stub on Top and Bottom-L
  • Employee Checks Stub on Top-D
  • FICA Wage Report
  • FUTA Summary
  • FUTA Summary - Consolidated
  • Manual Check Register
  • Precheck Report
  • Reprint Check Register
  • Reprint Vac/Sick Accrual Register
  • State Wage And Hour Report
  • SUTA Summary
  • SUTA Summary - Consolidated
  • Vacation/Sick Time Accrual Register
  • Vacation/Sick Time Available List
  • Workers Compensation Summary
  • Workers Compensation Summary - Consolidated

Want more information? Contact Stoneridge Software to talk with a Microsoft Dynamics GP expert.


Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!