PAYROLL SYSTEM – Ideal for HR departments, payroll practitioners, and business owners
₱4,999.99
PAYROLL SYSTEM – Ideal for HR departments, payroll practitioners, and business owners
10 in stock
SKU: PRS1
Category: Software
Tags: Barcode Scanner, Customize System, Excel, Inventory, Inventory Management System, Inventory System, POS, POS System, Promo. Promo Sale, Rush Sale, Scanner, Sofware
The Excel VBA Automated Payroll System is a fully customizable, user-friendly payroll automation tool designed for small to medium-sized businesses. It streamlines all payroll-related computations—regular hours, overtime, holidays, allowances, deductions, government contributions, loans, and net pay—into a single automated module powered by advanced Excel formulas and Visual Basic for Applications (VBA).
Built for accuracy, efficiency, and compliance, the system minimizes manual encoding, reduces computation errors, and ensures fast processing of employee compensation every payroll cycle. Ideal for HR departments, payroll practitioners, and business owners looking to automate payroll without the high cost of third-party software.
________________________________________
KEY FEATURES & ADVANTAGES
1. Automated Payroll ComputationAutomatically calculates:
• Regular days and pay
• Overtime (regular, holiday, special, night shift OT)
• Holiday pay (regular & special)
• Night shift differential
• Late minutes and deductions
• Allowances (COLA, Food, Transport, Communication, Misc.)
• Commissions
• Adjustments (Additions or Deductions)
Updated rates or rules only need to be set once—VBA handles the rest.
________________________________________
2. Complete Employee ProfilingStores and automatically retrieves employee information:
• Employee ID
• Full Name
• Position
• Monthly Salary
• Government Numbers (TIN, SSS, PhilHealth, HDMF/Pag-IBIG)
No need for repeated encoding—reducing human error.
________________________________________
3. Government Contribution ComputationAutomated calculation of:
• SSS Contribution
• PhilHealth Contribution
• Pag-IBIG/HDMF Contribution
Integrates seamlessly with your configured contribution tables and formulas.
________________________________________
4. Automatic Loan & Cash Advance DeductionHandles deductions such as:
• SSS Loans
• HDMF Loans
• Cash Advances
• VALE Payments
The system automatically deducts them from the net pay.
________________________________________
5. Accurate TaxationComputes:
• Taxable Compensation
• Withholding Tax
• Net of Tax
• Final Net Compensation
All based on your tax table configurations.
________________________________________
6. Transaction Management & Audit TrailEvery payroll run includes:
• Transaction ID
• Series Number
• Period Covered
• Date Prepared
• Processed By
• Remarks
• Count (Auto-tracking of entries)
Ensures transparency and traceability.
________________________________________
7. Integrated Image/ID Capture FieldIncludes an IMAGE field where company ID photos or employee images can be inserted for verification.
________________________________________
8. Dynamic, Automated SummarySystem generates:
• Total Gross Compensation
• Total Deductions
• Total Net Compensation
• Adjustment Summary
• All computed amounts are automatically displayed in real-time.
________________________________________
9. Clean & Professional InterfaceDesigned with:
• Organized headers
• Automated input validation
• Color-coded sections for easier navigation
• User-friendly VBA forms (optional, if included)
________________________________________
10. Printable Payslip Option (Optional)Generates:
• Employee payslips
• Payroll register summary
• Government compliance sheets
(Include only if your system already has this; if not, I can help you add it.)
________________________________________
COMPLETE FIELD LIST (As Included in the System)Employee & Transaction Details
• S.No
• Transaction ID
• Transaction
• Period Covers
• Date Prepared
• Employee ID#
• Employee Name
• Position
• Monthly Salary (Mo Salary)
• TIN
• SSS No.
• HDMF No.
• PhilHealth No.
• Processed By
• Remarks
• Series
• Image
________________________________________
Earnings & Time-Based Computation
• Reg Days / Reg Days (Amt)
• Reg OT Hrs / Reg OT (Amt)
• Reg Holiday Days / Reg Holiday (Amt)
• Reg Holiday OT Hrs / Amt
• Special Holiday Days / Amt
• Special Holiday OT Hrs / Amt
• Night Shift Hrs / Amt
• Night Shift OT Hrs / Amt
• Late Minutes / Amt
________________________________________
Allowances & Additions
• COLA (Amt)
• Food Allowance (Amt)
• Transport Allowance (Amt)
• Communication Allowance (Amt)
• Other Allowance (Amt)
• Commission (Amt)
________________________________________
Gross Pay & Deductions
• Total Gross Compensation (Amt)
• SSS Contribution (Amt)
• HDMF Contribution (Amt)
• PhilHealth Contribution (Amt)
• Taxable Compensation (Amt)
• Tax Withheld (Amt)
• Compensation Net of Tax (Amt)
• SSS Loan Payment (Amt)
• HDMF Loan Payment (Amt)
• Cash Advance Payment (Amt)
• VALE Payment (Amt)
• Net Compensation (Amt)
• Total (Amt)
• Adjustment (Amt)
________________________________________
Leave & Attendance
• Sick Leave (SL) Used
• Vacation Leave (VL) Used
• Absents
• Count
________________________________________
WHY BUY THIS SYSTEM?
One-time payment — no monthly subscription fees Fully editable Excel file (not locked) Easy to use even for non-technical staff Customizable for any company policy Accurate calculations & reduced payroll errors Faster payroll processing (minutes instead of hours)
CONTACT / ORDER INFORMATIONProduct Name: Payroll System
Developer: ELJ
Inclusions: System file, UserForm, Database Table, Basic Support
Email: vbafan2000@gmail.com
Contact: 09274741927
Shipping Policy
Shipping Policy
At ELJ268, we are committed to delivering fast and reliable service to our customers.
1. Product Type
Our products are digital software applications (Excel VBA-based systems). No physical items will be shipped.
2. Delivery Method
After successful payment, customers will receive:
A download link, or
The software file via email, or
Direct installation support (if applicable)
3. Delivery Time
Standard digital delivery: Within 24 hours
Custom-built systems: 1–3 business days (depending on project complexity)
4. Shipping Fees
Since our products are digital, no shipping fees apply.
5. Customer Responsibilities
Provide a valid email address.
Ensure your device can run Microsoft Excel with macros enabled.
6. Incorrect or Failed Delivery
If you do not receive your software within the expected time, please contact us and we will resolve the issue promptly.
7. Contact Information
For questions regarding your order or delivery, contact:
Email: vbafan2000@gmail.com
Phone/WhatsApp: +63-9274741927
Refund Policy
Digital Product Rule
Due to the nature of digital software, all sales are final and non-refundable once the software has been delivered.
Cancellation / Return / Exchange Policy
1. Cancellation Policy
Once the digital product has been sent via email or the download link or has been shared, the order can no longer be cancelled.
2. Return Policy
Since our products are digital and downloadable, we do not accept returns after delivery.
3. Exchange Policy
We do not offer exchanges for digital products.
4. Custom-Built Software
For custom-made Excel VBA systems:
Cancellations are only allowed if work has not yet started
Once development begins, cancellations and refunds are not available
Leave a Reply
You must be logged in to post a comment.