# haideristaken/automated-salary-slips-sheets architecture

> Architecture diagram of the GitHub repository haideristaken/automated-salary-slips-sheets, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-03-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/haideristaken/automated-salary-slips-sheets
- Repository: https://github.com/haideristaken/automated-salary-slips-sheets

## Overview

##### Project Type and Purpose
- This is a macro-enabled Excel application (.xlsm) that automates payroll processing.
- Its purpose is to simplify and streamline salary calculation, attendance tracking, and automatic payslip generation for up to 1,000 employees.
- The design relies on integrated worksheets linked via formulas (VLOOKUP, SUM, IF) and custom VBA code (e.g., converting net salary to words).

##### Analyzing the File Structure
- The project consists of a single macro-enabled Excel file that contains all the logic and UI.
- The three core logical “modules” (worksheets) are embedded within the workbook:
– Attendance Worksheet: Captures and calculates employee attendance metrics.
– Salary Sheet Worksheet: Computes various salary components including basic salary, HRA, allowances, overtime, deductions, and tax.
– Payslip Generator Worksheet: Dynamically produces individual payslips by referencing data via lookups and VBA.
- Additionally, the use of VBA macros ties these modules together, automating the recalculation and generation process.

## Diagram (Mermaid)

```mermaid
flowchart TD
    EXCEL("Excel Workbook: Project Salary.xlsm"):::container
    subgraph "Worksheets Modules"
        ATS("Attendance Worksheet"):::worksheet
        SAL("Salary Sheet Worksheet"):::worksheet
        PSL("Payslip Generator Worksheet"):::worksheet
    end
    VBA("VBA / Macros Engine"):::vba

    %% Data Flow Connections
    EXCEL -->|"contains"| ATS
    ATS -->|"VLOOKUP/SUM/IF"| SAL
    SAL -->|"Aggregates Salary Data"| PSL

    %% VBA Automation Triggers
    VBA -->|"automates recalculation"| ATS
    VBA -->|"automates recalculation"| SAL
    VBA -->|"automates payslip generation"| PSL

    %% Click Events
    click EXCEL "https://github.com/haideristaken/automated-salary-slips-sheets/blob/main/Project File/Project Salary.xlsm"
    click ATS "https://github.com/haideristaken/automated-salary-slips-sheets/blob/main/Project Salary.xlsm (embedded Attendance worksheet)"
    click SAL "https://github.com/haideristaken/automated-salary-slips-sheets/blob/main/Project Salary.xlsm (embedded Salary Sheet worksheet)"
    click PSL "https://github.com/haideristaken/automated-salary-slips-sheets/blob/main/Project Salary.xlsm (embedded Payslip Generator worksheet)"
    click VBA "https://github.com/haideristaken/automated-salary-slips-sheets/blob/main/Project Salary.xlsm (contains the custom VBA macros and functions)"

    %% Styles
    classDef container fill:#88CCEE,stroke:#1f78b4,stroke-width:2px;
    classDef worksheet fill:#CCFFCC,stroke:#33aa33,stroke-width:2px;
    classDef vba fill:#FFDD99,stroke:#ff9900,stroke-width:2px;
```
