# Salary Processing and Reports based on an Excel template file

**URL:** <https://community.automationedge.com/t/salary-processing-and-reports-based-on-an-excel-template-file/10308>\
**Category:** AutomationEdge Cook Book\
**Tags:** data-massaging\
**Created:** [July 31, 2023, 3:55am UTC](https://community.automationedge.com/t/salary-processing-and-reports-based-on-an-excel-template-file/10308 "2023-07-31T03:55:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pallavi.Rajadhyax](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\
**Post date:** [July 31, 2023, 3:55am UTC](https://community.automationedge.com/t/salary-processing-and-reports-based-on-an-excel-template-file/10308/1 "2023-07-31T03:55:00Z")

</div>

In this post I am sharing a video for - Salary Processing and Reports based on an Excel template file. This video showcases an AutomationEdge RPA Bot | Excel Bot for Salary Processing and Reports based on an Excel template file.

[![](https://img.youtube.com/vi/d5UN-qLfb1M/maxresdefault.jpg "AutomationEdge RPA Bot | Excel Bot | Salary Processing and Reports based on an Excel template file") ](https://www.youtube.com/watch?v=d5UN-qLfb1M)

We will build a bot/workflow for Salary Processing and formatting Reports with Templates. The template has a formatted header, pivot tables and charts.

The bot uses the following AutomationEdge Plugin steps:  
Microsoft Excel Input, Multi-Way Merge join, Calculator, Get Variables, Filter Rows, Block, Microsoft Excel Output

#MicrosoftExcelInput #MultiWayMergeJoin #Calculator #GetVariables #FilterRows #Block #MicrosoftExcelWriter #MicrosoftExcelOutput #AutomationEdge #rpa #hyperautomation

=========================================================

**Following is the complete list of videos on Data Massaging. Click on the links below to view the videos.**

(1)Excel Bot for Data Massaging- [https://www.youtube.com/watch?v=Lz5dkxL4IHs](https://www.youtube.com/watch?v=Lz5dkxL4IHs)

(2)Excel Bot for Pay Slip Distribution with Mail Merge - [https://www.youtube.com/watch?v=6rEij5tU7xc](https://www.youtube.com/watch?v=6rEij5tU7xc)

(3)Excel Bot for Salary Transfer to Bank- [https://www.youtube.com/watch?v=c7CjYhmypdE](https://www.youtube.com/watch?v=c7CjYhmypdE)

(4)Excel Bot and send Mail- [https://www.youtube.com/watch?v=P34RrDV7FF0](https://www.youtube.com/watch?v=P34RrDV7FF0)

(5)Excel Bot to Read Timesheet Emails - [https://www.youtube.com/watch?v=q5cKOlRB8lI](https://www.youtube.com/watch?v=q5cKOlRB8lI)

(6)AutomationEdge RPA Bot for Employee Data transformation - [https://www.youtube.com/watch?v=7NLg0krRYSM](https://www.youtube.com/watch?v=7NLg0krRYSM)

(7)Manage a Long-Running AutomationEdge RPA Bot | Excel Bot - [https://www.youtube.com/watch?v=HZgY0i7s-ac](https://www.youtube.com/watch?v=HZgY0i7s-ac)

(8)Excel Bot to Combine Timesheets - [https://www.youtube.com/watch?v=ewknhuSpbK4](https://www.youtube.com/watch?v=ewknhuSpbK4)

(9)Salary Processing with formatted output based on a template - [https://www.youtube.com/watch?v=D3zH6umOXXY](https://www.youtube.com/watch?v=D3zH6umOXXY)

(10)Salary Processing and Reports based on an Excel template - [https://www.youtube.com/watch?v=d5UN-qLfb1M](https://www.youtube.com/watch?v=d5UN-qLfb1M)