Official System Documentation & Deployment Guides
1-Click Automated Payroll Architecture
Welcome to the ultimate guide for our automated payroll and tracking system. Custom-designed for all types of companies, institutions, and factories—both large and small—managing up to 500+ Employees. This system completely removes human mistakes. It instantly changes long days of complex manual calculations by accountants into a simple, 1-second automatic process.
- One-Click Payroll: Instant automated salary calculations.
- Industrial-Scale Power: Over 500+ employees simultaneous sync.
- Management Override: Replaces weeks of costly manual work.
- Hardware Sync: Instantly process text logs from biometric fingerprint machines.
Whether you are the business owner, an HR manager, or the employee running the system—this tool keeps all your data safe, locks your finances securely against tampering, and saves you 95% of time, money, and administrative effort every single month.
Step 1: Open the System & Enable Macros
To start using the system, you just need to follow a quick security step required by Microsoft Excel. When you open the file for the first time, a standard yellow security warning banner will appear at the top of your screen depending on your Excel version.
Critical Initialization Required
You must click the Enable Content or Enable Macros button right after opening the file. This action instantly activates the main automation code. If you do not click it, the login screen will not load and the sheets will stay locked.
Once activated, the official login dashboard will instantly pop up on your screen. The system requires standard login credentials to verify access. For the main Time Keeper System, use Username: Timekeeper and Password: Timekeeper@2025 For the Report Approval System, the manager password is: M.N.G@2025 To view these verified access parameters anytime, check the secure text ledger:
Fetch Access Credentials Ledger
Step 2: Exploring the All-In-One Management Hub
The main control dashboard works as the heart of the system, connecting all your payroll operations in one single screen. It features a clean, simple layout with easy buttons that allow you to import data, register staff, view attendance logs, and print official payroll sheets with just one single click.
- Import Fingerprint Data: Instantly read raw logs from your biometric device.
- Employees Information: Register names, jobs, work hours, and base salaries.
- Time Keeper Report: Track real-time attendance, absences, and overtime metrics.
- Print Salaries & Cards: Generate monthly certified payslips and employee Labour Cards.
Every single button on this main dashboard works instantly. It takes heavy calculations that used to take days and processes them in less than a second, giving you a smooth and stress-free management experience.
Step 3: Registering Employee and Financial Data
Clicking the Employees Information button takes you directly to the employee master database tab. This sheet is the main foundation that the system uses to calculate all monthly payrolls and hours automatically.
Important Notice
Make sure to delete the default test names and examples before adding your real team data. Simply type in your official employee roster, including their names, job positions, required working hours, and base salaries.
The input fields are very easy to fill: just type the Employee Name, Designation, Required Hours, and Base Salary. This clear setup keeps your staff profiles completely organized and ensures perfectly accurate salary calculations without any errors later on.
Step 4: Automatic Fingerprint Log Import & Processing
To easily import your team's attendance logs, the system features a powerful automated folder connection. You do not need to manually process files or read raw data shifts yourself. Simply export the attendance logs from your fingerprint device, copy them, and paste them straight into the dedicated folder named Biometric_Logs_Folder on your computer.
1-Click Execution Protocol
Once your raw log files are placed in the folder, go back to the system's main hub and click the large red Run One-Click Administration button. The system will automatically access the folder, read all the data at once, and fully calculate your payroll metrics in less than 1 second.
Important Rule: Right after the red button finishes processing the files, you must delete the raw logs from the Biometric_Logs_Folder. This simple step keeps your database safe, perfectly blocks any accidental duplicate data entries in the future, and ensures your accounts remain clean and accurate.
Step 5: Managing the Biometric Attendance Records Sheet
When the logs are processed, all data is stored inside the Machine Finger Time Upload tab. This sheet acts as the main history log that holds every single clock-in and clock-out time recorded by your employees at their work locations.
- Automatic Sorting: Instantly organizes names, employee numbers, and dates.
- Verify Code: Automatically tracks verification codes for safe check-ins.
- Attendance Remarks: Type official excuses (like Sick or Annual Leave) under Work Description.
- Salary Protection: Official remarks automatically stop the system from making wrong deductions.
Attendance Remarks & Salary Protection Protocol
To completely safeguard your workforce payroll from auto-deductions, you can enter official absence excuses directly copied from the biometric device. Simply type parameters such as: Annual Leave, Sick Leave, Emergency Leave, or Medical Excuses under the Work Description column.
System Impact: The system automatically processes these remarks as officially approved excuses. This instantly prevents the employee from being calculated as absent and protects their monthly payroll from any automated financial deductions.
The system easily handles thousands of attendance rows at the same time. It scans, filters, and connects every timestamp to the right employee profile in less than a second, ensuring your company records stay 100% clean and correct.
Step 6: Recording Manual Attendance for Remote Sites
To easily manage special situations—like field work, remote project tasks, or when an employee cannot use the fingerprint machine—the system includes a built-in manual logging tool. Simply click the Manual Entry Upload button on the main dashboard to open a helpful pop-up window directly on your screen.
This screen allows you to safely type in attendance records for external branches or off-site locations without mixing them up or breaking your original biometric device logs. It keeps all your company operations moving smoothly and without any delays.
Step 7: Filling the Manual Entry Form Fields
The manual upload window acts as a simple data-entry screen. Every detail you type into this form goes directly into the tracking system to fix missing logs or cover employees working outside the main office.
- Full Name Selection: A dropdown menu that automatically pulls names from your staff list.
- Punch Time: Automatically records the exact time, which you can easily edit if needed.
- Site or Branch Name: Allows you to type the actual workplace or branch location of the worker.
- Work Description: A text box dedicated to entering official attendance notes and excuses.
Payroll Protection Protocol
Use the Work Description box to type official approved excuses such as: Annual Leave, Sick Leave, Emergency Leave, or Medical Excuses. The system will read these notes instantly, prevent the employee from being marked absent, and protect their monthly salary from automated deductions.
Step 8: Opening the Master Attendance Reports
To view your complete team attendance details, the system features a powerful reporting sheet. Simply click the Time Keeper Report button on the main dashboard to open your full analytics screen.
This single action tells the system to automatically combine all your fingerprint logs and manual entries. It instantly creates a clean, easy-to-read summary showing every employee's total work days, absences, late minutes, and overtime hours for easy checking.
Step 9: How to Filter and Approve the Report
This sheet allows the manager or accountant to review the final attendance details. You can check any record instantly by following three simple steps shown on the screen:
- Select Month from List: Click the dropdown menu on the left to choose the specific month you want to review.
- Select Employee from List: Click the dropdown menu in the middle to pick the name of a specific employee.
- Manager Report Approval: Review the colored data rows to instantly see if the employee was present, late, or absent.
Final Approval Action
After checking the month and the employee name, the manager must click the green APPROVAL button to officially lock the data, or the red REJECTED button if something needs a manual fix.
Step 10: Printing Monthly Salaries and Labour Cards
The final step in the system allows you to easily output your official documents. Simply click the Print Salaries & Cards button on the main dashboard to open the automated document generation screen.
100% Automated Printing Workflow (Live Example)
To print a certified payslip for an employee (for example, named Mohammed), you only need to follow this effortless routine:
1. Go to the Time Keeper Report sheet first, then select the specific Date and choose the name Mohammed from the dropdown list.
2. Navigate directly to the Labour Card sheet. You will instantly find the monthly payslip fully generated for Mohammed with the exact date you selected.
System Impact: Everything is 100% correct, pre-calculated, and completely ready to print automatically. You never have to type, format, or manually edit a single cell. The data syncs instantly like magic!
This single action tells the system to instantly create ready-to-print monthly payslips and official employee Labour Cards. Every document automatically includes the worker's base salary, calculated overtime, and final net balance, ready for immediate printing or high-quality PDF saving without any manual effort.
Step 11: Understanding the Automatic Payroll Calculations
Inside the Labour Card sheet, the system automatically builds a professional financial summary for the employee you selected. It gathers all the tracking records and computes the numbers perfectly without any manual work.
- Automatic Rates: Instantly calculates the correct daily and hourly pay rates.
- Overtime Earnings: Automatically adds extra pay for hours worked beyond the official shift.
- Smart Deductions: Processes precise penalties for late arrivals, missing hours, or unexcused absences.
- Advance Deductions: Automatically subtracts loans from the specialized Cash Advance Field.
By simply selecting the employee's name and month, this dashboard completely structures their Total Earnings, subtracts any advance payments or shortage hours, and displays the final Net Salary. The resulting document is perfectly organized and 100% ready for official manager signatures and immediate cash distribution.
TimeKeeper: The 1-Click Payroll & Attendance Tracker for All Large & Small Businesses
Say goodbye to manual errors. Easily process text logs from biometric fingerprint machines or use the manual entry tool to manage your entire workforce inside factories, companies, or institutions in less than 1 second.
