# How to Create a Payroll Process Flowchart in Excel – 6 Steps

In a Flowchart each element in the diagram has different shapes. For example, a Rectangle indicates the Start or End of a flowchart. Other shapes have different meanings.

### Step 1 – Calculate the Basic Pay

Create the flowchart diagram.

• Go to the Insert tab.
• Click Illustrations.
• Go to Shapes.
• Select Rectangle.

• Place the rectangle.

Change the fill color:

• Select the rectangle and go to the Home tab.
• Select Fill Color.
• Choose a color.

Excel will change the Fill Color.

• Double-click inside the rectangle to activate the editing mode.
• Enter ‘Start’.

Add the calculation of the basic pay to the chart:

• Go to the Insert tab.
• Click Illustrations.
• Go to Shapes.
• Select Parallelogram.

• Place the Parallelogram and enter ‘Basic Pay’ after activating the editing mode.

• Use the Arrow in Shapes to show the sequence.

This is the flowchart diagram:

### Step 2 – Measure Allowances

Consider the allowances:

• House allowance
• Transportation allowance, etc.

• Enter ‘Add Allowances’ in the rectangle.

This is the output:

### Step 3 – Deduct the TDA

Calculate the Tax Deducted at Source. Deduct any other dues.

• This is the output:

### Step 4 – Calculate the Total Payment

The total payment is the result of the addition of all allowances to the basic pay and the deduction of all dues from the basic pay.

• Insert a rectangle.
• This is the output:

### Step 5 – Add a Print Statement

• Choose the Diamond shape.

• Edit it.

This is the output.

### Step 6 – Complete the FlowChart

• Add the End rectangle to complete the flowchart.

## Related Articles

<< Go Back to Excel Payroll Templates | Excel HR Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF