Automated Payroll and Paysheet Excel


This Excel file help you to create payroll for each month, create paysheet for each employee, saving each paysheet as PDF format in organized folders (based on year and month) and will send email to each employee by attaching the PDF file with respect to each employee. Also, it archives all payroll data of each month in the Excel table and provide you an simple informational dashboard to help for having better insight of your payments. This software is developed in Microsoft Excel based on Macro (VBA programming), so it’s really easy to use and can be manipulated as you need (because it’s just Excels).

For more information, please watch the video in description

This Excel file should be used on Windows OS, by Microsoft Excel 2016 or above


In each month, the H.R department needs to create a document named payroll that contains employs payment information for each individuals who working in the company. Afterward, they create paysheet for each indusial employee, which contain that specific employee payment information and they sending those documents to each person via Email. Creating payroll and paysheet and sending emails can consume lots of time and having a software that automatically create and send them can be very helpful.

In this reason, we developed an Excel file to help you to create payroll and pay sheet very easily and in conventional manner. This application will create a paysheets for you and saving each of them as pdf file in the organized folder structure (which is based on year and month) and will send each paysheet pdf file to each person via email (which can be used by Gmail, Yahoo or by using Outlook account).

Also, you can automatically archive the payroll data of each month in the Excel table and have a data base of all payments of all persons in company and there is simple informational dashboard developed for you that will help you for analyzing your payments and making better decision for paying to employees. Also you are able to creating more reports as you want or develop this Microsoft Excel file

This Excel file should be used on Windows OS, by Microsoft Excel 2013, 2016 or above

This software has below capabilities:

  • Creating a payroll for each month
  • Creating paysheet for each person
  • Saving all Paysheet as PDF file automatically
  • Organizing all PDF file based on Year and Month of payroll
  • Sending paysheet PDF file automatically to each employee by Email
  • Archiving data for each year and month
  • Having informational dashboard
  • Able to getting custom reports and be improved by anyone

Also you can see the video instruction which is provided for you in the below


There are no reviews yet.

Be the first to review “Automated Payroll and Paysheet Excel”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.