Contract Generation Software

Automate Bonus Letter Generation and Delivery

Introduction


Once in a year employer reviews an employee's work and performance and decides the bonus. This is formally communicated to the employee through a bonus letter. The same process is carried out for pay review letters as well.

Typically, HR teams mass mail these letters to all employees. Most of the HR teams use Excel for compensation and benefits management or software that allows the export of data into Excel format. Then they use that Excel data to do a mail merge for sending letters.

Using mail merge to generate bonus letters is cumbersome and wastes a lot of productivity. It’s important to deliver this letter to employees on time. An error-free letter is an essential requirement. With mail merge, you can’t be sure of both.

  1. The formats of numbers get changed in the generated document.
  2. Populating templates with table data is a limitation of mail merge if you’re attempting directory mail merge
  3. Takes a lot of time to generate

Moreover, HR teams send password-protected documents to keep the information in the bonus letter confidential. Only the employee with a valid password can open the document. Again, this is not possible with the mail merge.


Bonus Letter Automation


EDocGen provides an elegant solution for automating the pay review letter creation and delivery.

You can use your existing templates for the letter generation. Compared to traditional approaches.

  1. You can generate thousands of letters in minutes
  2. Retains the format of Excel data, which is otherwise hard in the mail merge
  3. Create PDF files
  4. Password-protected files
  5. Conditional statements for special scenarios
  6. Multi-lingual support
  7. Populate a single template with multiple data files or multiple templates with a single data file. This is necessary if you have offices across the globe and use multiple templates. You can populate each of those templates with a single data file

How to generate Bonus letters


In the following sections, we’ll see how to generate bonus letters with an example.

Step1- Add tags to your template:

If your organization has an existing bonus letter template, add dynamic tags to it as shown in the example below. It has dynamic text, table, and conditions.

Text tags: The dynamic text fields are tagged with { } Ex: {Customer}, {Date}

Conditional statements: As you can see in the template, the salutation depends on the gender value in Excel. {#Gender == "F"}Ms.{/}

Formatting: You can format numbers using “format_number” in the tag. Through the tag {Bonus|format_number:","}, we are instructing the system to use “,” separator after thousands.

Image Population: Populate digital signature image through image tag {%Imageid}. In the below template see the tag {%SignImg} that populates the signature.

Step2- Data Population for Bulk Generation: Upload the template into the system and populate the dynamic fields with Excel data. The system generates the bonus letters in bulk.

The following Excel generates two pay review letters for employees Maria & Rob.




Step3 - Email the Letter: If your Excel has the Email column, the system automatically delivers the respective bonus letter to the intended employee.

If the document is encrypted with the password, you can include that information in the mail body. Using the right password, the employee can open the letter.

If you want to auto-send these emails from your business email (Custom sender email), you can set up your mail account.

The system also allows you to download all the generated bonus letters. You can also sync them to cloud storage.

Popular Posts

HR Documents Creation

Posted by admin

HR has lot of importance in modern day organization ranging from strategic planning to