13TH MONTH PAY CALCULATOR
💛 13TH MONTH PAY CALCULATOR 🎄💰
💼 Less Year-End Payroll Stress. Clearer Computations. More Time to Enjoy the Holidays!
🇵🇭 MADE FOR FILIPINO SMALL BUSINESS OWNERS!
😩 “MA'AM, MAGKANO PO 13TH MONTH PAY KO?” 😂
Ayan na naman! BER MONTHS NA! 🎄
Habang ang employees ay excited sa Christmas bonus, ikaw naman bilang business owner...
EXCITED DIN! PERO SA DAMI NG KAILANGANG I-COMPUTE! 😭😂
🎄 Christmas Party?
🎁 Raffle Prizes?
💰 Year-End Expenses?
📊 Annual Payroll Review?
😱 13TH MONTH PAY NG LAHAT NG EMPLOYEES?!
Tapos biglang may magtatanong:
“Ma'am, bakit po hindi isang buong monthly salary ang 13th month ko?”
Ay, teka! Check muna natin ang eligible basic salary earned throughout the year! 😅
“Ma'am, July lang po ako nag-start. May 13th month pay pa rin po ba ako?”
YES, qualifying employees who worked only part of the year can receive proportionate 13th month pay!
“Ma'am, may advance na po ako noong June. Magkano na lang po balance ko?”
Ayan na! Another computation! 😂
SOUND FAMILIAR?
What if you could organize your employees' annual basic salary records, calculate estimated 13th month pay, and track advances ALL IN ONE WORKBOOK?
✨ Introducing the 13TH MONTH PAY CALCULATOR by GlassPro Systems! ✨
Your practical, beginner-friendly Excel 13th month pay computation toolkit designed for Filipino business owners, HR assistants, bookkeepers, payroll staff, and administrative personnel!
💛 Because Christmas should be filled with joy, not endless payroll calculations! 🎄😂
😵💫 ARE THESE YOUR 13TH MONTH PAY PROBLEMS?
❌ Hindi sure kung paano i-compute ang proportionate 13th month pay
❌ Nalilito kapag midyear nag-start ang employee
❌ Hirap mag-compute kapag may unpaid absences
❌ Hindi alam kung anong salary components ang dapat isama
❌ Paulit-ulit na manual computations gamit ang calculator
❌ Walang organized annual basic salary records
❌ Nakakalimutang ibawas ang 13th month pay advances
❌ Hirap malaman ang remaining balance ng employee
❌ Walang consolidated year-end 13th month pay register
❌ Hirap i-explain kung paano nakuha ang amount
❌ Sayang ang oras sa paulit-ulit na pag-check ng payroll records!
IF YOU ANSWERED YES TO EVEN ONE OF THESE, THIS CALCULATOR IS FOR YOU! 🙌
Imagine having your employees' monthly eligible basic salary records, estimated 13th month pay, advances, and remaining balances organized in ONE convenient workbook!
Less guessing. Less confusion. Clearer year-end computations! 🚀
🎁 WHAT'S INSIDE YOUR 13TH MONTH PAY CALCULATOR?
You're not just buying another ordinary Excel spreadsheet!
You're getting a practical year-end payroll calculation and recordkeeping toolkit designed to make 13th month pay preparation easier!
🧮 1. AUTOMATIC 13TH MONTH PAY CALCULATOR
THIS IS WHERE THE MAGIC HAPPENS! ✨😍
No more manually adding monthly salaries and dividing everything by 12!
Simply enter:
💵 Employee's Eligible Basic Salary Earned
📅 Monthly Salary Amounts
👥 Employee Information
💰 Any 13th Month Pay Already Released
And the workbook helps calculate the estimated 13th month pay and remaining amount!
✅ Monthly eligible basic salary inputs
✅ Automatic annual salary total
✅ Estimated 13th month pay calculation
✅ Payment and advance tracking
✅ Estimated remaining balance
ENTER. CALCULATE. REVIEW! 🙌
Because your time is valuable, too!
📅 2. MONTH-BY-MONTH BASIC SALARY TRACKER
“MA'AM, PWEDE BANG MONTHLY SALARY LANG ANG ILAGAY?” 🤔
Not always!
The 13th month pay calculation is generally based on the employee's TOTAL ELIGIBLE BASIC SALARY ACTUALLY
EARNED DURING THE CALENDAR YEAR.
That's why your workbook provides monthly salary input columns!
📋 TRACK ELIGIBLE BASIC SALARY FOR:
📅 January
📅 February
📅 March
📅 April
📅 May
📅 June
📅 July
📅 August
📅 September
📅 October
📅 November
📅 December
12 MONTHS. ONE ORGANIZED ANNUAL RECORD! 💛
Perfect for employees who:
✅ Worked the entire year
✅ Started employment partway through the year
✅ Had unpaid absences
✅ Earned different basic salary amounts in different months
✅ Had partial-month salary earnings
No need to pretend every month had exactly the same salary!
Just enter the verified eligible basic salary actually earned!
👥 3. ANNUAL 13TH MONTH PAY REGISTER — UP TO 60 EMPLOYEES!
YES! UP TO 60 EMPLOYEES! 😍
Imagine having to compute 13th month pay for 60 employees manually!
SIXTY EMPLOYEES?! SIXTY COMPUTATIONS?! 😭😂
Instead of maintaining separate calculations for every employee, use ONE organized annual register!
Your workbook accommodates UP TO 60 EMPLOYEES!
Keep important information together:
✅ Employee information
✅ Monthly eligible basic salary amounts
✅ Annual eligible basic salary total
✅ Estimated 13th month pay
✅ Recorded payments and advances
✅ Estimated remaining balance
ONE REGISTER. UP TO 60 EMPLOYEES. ORGANIZED YEAR-END RECORDS!
Perfect for growing small businesses!
💰 4. AUTOMATIC PROPORTIONATE 13TH MONTH PAY CALCULATOR
“MA'AM, JULY LANG PO AKO NAG-START. MAY 13TH MONTH PAY PO BA AKO?”
YES! Qualifying employees who worked only part of the year can receive proportionate 13th month pay.
And here's where many business owners get confused!
HINDI MO KAILANGANG HULAAN KUNG ILANG MONTHS ANG IDI-DIVIDE! 😂
✨ THE BASIC FORMULA:
13th Month Pay = Total Eligible Basic Salary Earned During the Calendar Year ÷ 12
YES! DIVIDED BY 12!
Even when an employee worked only part of the year, the divisor remains 12.
💵 LET'S LOOK AT AN EXAMPLE!
👩💼 Employee: Sample Employee A
📅 Employment Period: Partial Year
💰 Total Eligible Basic Salary Earned: ₱159,000
🧮 COMPUTATION:
₱159,000 ÷ 12
🎉 ESTIMATED 13TH MONTH PAY: ₱13,250!
SEE? CLEAR AND EASY TO REVIEW! 😍
The workbook performs the calculation using the monthly eligible basic salary amounts entered.
📌 The example assumes the employee is covered by the applicable 13th month pay requirements and the ₱159,000 amount consists entirely of eligible basic salary.
📉 5. UNPAID ABSENCE & PARTIAL-MONTH SALARY HANDLING
“MA'AM, PAANO KAPAG MAY ABSENCES?” 🤔
Another common year-end payroll question!
Some employees may have:
❌ Unpaid absences
📅 Partial-month employment
💵 Different basic salary earnings
📉 Reduced basic salary in certain months
Your workbook helps you account for these situations by using the ACTUAL ELIGIBLE BASIC SALARY EARNED for each month.
Instead of automatically assuming the employee earned the same monthly salary throughout the year, enter the verified amount from payroll records!
MORE REALISTIC INPUTS. CLEARER ESTIMATES! 💛
📌 The workbook does not independently calculate unpaid absence deductions. Those adjustments must already be reflected in the eligible basic salary amounts you enter.
💸 6. 13TH MONTH PAY ADVANCE & PAYMENT TRACKER
THIS IS ONE OF THE MOST USEFUL FEATURES! 😍
Ever experienced this?
“Ma'am, pwede po bang mag-advance ng 13th month pay?”
Then months later...
“Ma'am, magkano na lang po ang remaining 13th month ko?” 😅
Instead of relying on memory, keep a record of payments already released!
Your workbook includes a Payment and Advance Tracker.
✅ Record 13th month pay advances
✅ Track payments already made
✅ Review total amounts released
✅ Calculate estimated remaining balance
💰 EXAMPLE:
Estimated 13th Month Pay: ₱13,250
Advance Already Paid: ₱5,000
🎉 ESTIMATED REMAINING BALANCE: ₱8,250!
NO MORE FORGETTING PREVIOUS PAYMENTS! 🙌
Because accurate records matter, especially when money is involved!
📊 7. EMPLOYEE COVERAGE STATUS TRACKER
“MA'AM, LAHAT PO BA NG EMPLOYEES COVERED?”
Not necessarily!
Employee coverage depends on applicable Philippine labor rules and the nature of the employment arrangement.
That's why your workbook includes a COVERAGE-STATUS SELECTION!
Use it to flag employee records for review before finalizing computations.
✅ Identify employees requiring eligibility verification
✅ Mark confirmed eligible employees after review
✅ Keep coverage status visible
✅ Support a more organized year-end checking process
VERIFY FIRST. COMPUTE SECOND. REVIEW BEFORE PAYMENT! 💛
📌 The workbook does not automatically determine whether an employee is legally entitled to 13th month pay.
🖨️ 8. PRINTABLE 13TH MONTH PAYROLL SUMMARY
PROFESSIONAL-LOOKING YEAR-END PAYROLL RECORDS? YES, PLEASE! 😍
Your toolkit includes a printable payroll summary designed for internal payroll-officer review.
✅ Organized employee estimates
✅ Annual eligible basic salary totals
✅ Estimated 13th month pay amounts
✅ Recorded payments and advances
✅ Estimated remaining balances
Perfect for reviewing your year-end computations before releasing payments!
Because even small businesses deserve organized payroll documentation!
👩💻 9. SAMPLE COMPLETED 13TH MONTH PAY COMPUTATION
First time computing proportionate 13th month pay?
DON'T WORRY! 💛
We've included a sample completed calculation for a fictional partial-year employee!
See how the workbook handles:
✅ Monthly eligible basic salary entries
✅ Partial-year employment
✅ Annual salary totals
✅ Estimated 13th month pay
✅ Recorded advances
✅ Remaining balance
Simply review the example, understand the workflow, and replace the sample information with your own verified payroll details!
Learn by example. Then start calculating! 🙌
📚 10. BEGINNER-FRIENDLY QUICK-START PDF GUIDE
HINDI KA EXCEL EXPERT? NO PROBLEM! 😂
You don't need to be an accountant or spreadsheet wizard to start using this calculator!
Your purchase includes a beginner-friendly PDF guide.
📖 Learn how to enter employee information
📖 Understand eligible basic salary
📖 Learn how to input monthly salary earnings
📖 Understand proportionate 13th month pay
📖 Learn how to record advances and payments
📖 Know how to review employee coverage status
📖 Learn how to use the Annual Register
📖 Understand how to prepare the printable summary
Konting basa, konting encode, and you're ready to calculate! 💛
💛 WHY YOU'LL LOVE THIS 13TH MONTH PAY CALCULATOR!
⏰ 1. SAVE TIME DURING YEAR-END PAYROLL!
Imagine having to calculate 13th month pay for 20, 30, or even 60 employees.
Different salaries.
Different employment start dates.
Different unpaid absences.
Different advance payments.
Instead of repeatedly adding monthly figures and calculating everything manually, use ONE organized workbook!
More time for your business. More time for your family. More time to enjoy Christmas! 🎄
🧮 2. LESS MANUAL COMPUTATION!
No more repeatedly entering formulas into your phone calculator!
Your workbook helps calculate:
💰 Total eligible basic salary earned
🎄 Estimated 13th month pay
💸 Recorded advances and payments
📊 Estimated remaining balances
Work smarter, not harder! 🚀
📅 3. BETTER ANNUAL SALARY RECORDS!
Instead of searching through 12 months of scattered payroll notes, keep your eligible basic salary inputs organized in one annual register.
Less searching. Better documentation!
👥 4. DESIGNED FOR UP TO 60 EMPLOYEES!
Whether you have 5 employees, 20 employees, or a growing team of 60, this workbook can help organize your annual 13th month pay computations!
💸 5. KEEP ADVANCES ORGANIZED!
No more relying on memory to remember who already received part of their 13th month pay!
Record previous payments and review estimated remaining balances.
💼 6. MORE TRANSPARENT COMPUTATIONS!
Want to explain how an employee's 13th month pay was calculated?
Your workbook keeps the monthly eligible basic salary amounts and resulting estimate together.
Because clear computations make payroll discussions easier!
👩🏫 7. BEGINNER-FRIENDLY!
Not an accountant?
Not an HR professional?
Not an Excel expert?
YOU CAN STILL GET STARTED! 🙌
🔄 8. EDITABLE & REUSABLE!
Use the calculator for future calendar years.
Update employee information and monthly eligible salary amounts.
Save separate copies for organized annual recordkeeping.
ONE PURCHASE. A REUSABLE YEAR-END PAYROLL TOOL!
💰 9. NO EXPENSIVE MONTHLY SUBSCRIPTIONS!
Not ready to invest in complicated payroll software?
Start with a practical, budget-friendly 13th month pay calculator!
Clearer year-end computations don't have to be expensive! 💛
🏪 PERFECT FOR PHILIPPINE SMALL BUSINESSES!
🏬 Retail stores and small shops
🔨 Hardware and construction businesses
🪟 Glass and aluminum fabrication shops
📦 Warehouses and trading businesses
🍔 Restaurants and cafés
💇 Beauty salons and barbershops
🚚 Delivery and logistics businesses
🏭 Small manufacturing businesses
🏢 Small offices
👩💻 Bookkeepers and payroll assistants
👥 HR staff and supervisors
🚀 Startup business owners
If your business needs to calculate and review employee 13th month pay, THIS TOOL CAN HELP!
💰 LET'S TALK ABOUT YOUR TIME!
Imagine this...
You have 20 employees.
Christmas is approaching!
But their employment situations are different!
👷 Employee A — Worked the Entire Year
👩💼 Employee B — Started in March
👨🔧 Employee C — Started in July
👩🍳 Employee D — Had Unpaid Absences
👷 Employee E — Already Received an Advance
Now you need to compute everyone's 13th month pay!
IBA-IBANG SALARY?! IBA-IBANG START DATE?! MAY ADVANCE PA?! 😭😂
Instead of manually adding 12 months of salary records for each employee, imagine having ONE workbook where you can:
✅ Enter monthly eligible basic salaries
✅ Automatically total annual earnings
✅ Calculate proportionate 13th month pay
✅ Track advances and payments
✅ Review estimated remaining balances
✅ Organize up to 60 employees
✅ Prepare printable year-end payroll summaries
WOULDN'T THAT MAKE YOUR YEAR-END PAYROLL SO MUCH EASIER? 😍
Think about what you could do with the time you save!
🎄 Prepare your Christmas celebration
🎁 Organize employee gifts
📈 Focus on year-end sales
📦 Manage holiday inventory
💛 Spend more time with your family
Your time is valuable. Don't waste your holidays on repetitive calculations!
🎉 YOUR 13TH MONTH PAY CALCULATOR IS ONLY ₱149!
💛 YES! JUST ₱149!
For around the price of a coffee and snack, you can get a practical digital 13th month pay calculation toolkit for your business!
☕ Coffee? Mauubos in minutes!
💻 13th Month Pay Calculator? REUSABLE YEAR AFTER YEAR! 😍
🎁 WHAT YOU GET FOR ONLY ₱149:
✅ Single-Employee 13th Month Pay Calculator
✅ Annual Register for Up to 60 Employees
✅ Monthly Eligible Basic Salary Tracker
✅ Automatic Proportionate 13th Month Pay Calculation
✅ Unpaid Absence & Partial-Month Salary Input Support
✅ Payment and Advance Tracker
✅ Employee Coverage Status Selection
✅ Printable Payroll Summary
✅ Sample Completed Computation
✅ Beginner-Friendly Quick-Start PDF Guide
10 PRACTICAL FEATURES & RESOURCES IN ONE AFFORDABLE DIGITAL TOOLKIT! 💰
💛 One-time purchase
💛 No monthly subscription
💛 Editable Excel workbook
💛 Up to 60 employees
💛 Automatic supported calculations
💛 Payment and advance tracking
💛 Printable payroll summary
💛 Beginner-friendly instructions
💛 Reusable for future years
Small investment. Big help for your year-end payroll administration!
🎁 BONUS FREEBIES!
🇵🇭 FREE DOLE WORKERS' STATUTORY MONETARY BENEFITS HANDBOOK!
YES! INCLUDED FOR FREE! 🎉
Because understanding employee monetary benefits is just as important as computing 13th month pay!
Get a reference copy of the DOLE Workers' Statutory Monetary Benefits Handbook to help you learn more about important employee monetary benefits and labor standards.
📖 Keep this handy when reviewing 13th month pay rules and other statutory monetary benefits.
The handbook is a reference resource. Always verify the latest official guidance and applicable regulations.
📅 PLUS! FREE PRINTABLE 2027 CALENDAR!
ANOTHER FREEBIE?! YES! 😍
Get a printable 2027 Calendar (January–December) to help organize important business dates!
📅 Payroll schedules
📅 Employee meetings
📅 Business deadlines
📅 Team activities
📅 Important company events
MORE VALUE FOR YOUR ₱149! 💛
📥 HOW TO GET STARTED
📧 STEP 1: PURCHASE USING YOUR ACCESSIBLE EMAIL ADDRESS
IMPORTANT!
Please make sure you enter a valid email address that you can access during checkout.
Your purchase confirmation and download instructions will be sent to your email.
Keep your purchase email safe for future reference!
📚 STEP 2: READ THE PDF GUIDE FIRST!
Before editing your workbook, please read the included QUICK-START PDF GUIDE.
This will help you understand:
✅ Which cells to edit
✅ How to enter employee information
✅ How to input monthly eligible basic salaries
✅ How to review employee coverage
✅ How to record advances and payments
✅ How to avoid accidentally changing formulas
Konting basa muna bago mag-compute! 😂💛
👥 STEP 3: SET UP YOUR EMPLOYEES!
Enter your employees' information.
Review their coverage status and confirm eligibility based on applicable rules.
💵 STEP 4: ENTER MONTHLY ELIGIBLE BASIC SALARIES!
Using verified payroll records, enter the eligible basic salary actually earned for each month.
Remember:
USE ACTUAL ELIGIBLE BASIC SALARY EARNED — NOT AUTOMATICALLY THE EMPLOYEE'S CURRENT MONTHLY RATE!
🧮 STEP 5: REVIEW THE 13TH MONTH PAY ESTIMATE!
The workbook calculates the estimated amount using:
Total Eligible Basic Salary Earned ÷ 12
Review the result and confirm the salary basis.
💸 STEP 6: RECORD ADVANCES & PAYMENTS!
Enter any 13th month pay amounts already released.
Review the estimated remaining balance.
📊 STEP 7: PREPARE YOUR YEAR-END PAYROLL SUMMARY!
Review the employee estimates and remaining balances.
Use the printable summary for internal payroll checking.
Verify all figures before releasing payments!
Congratulations! You're one step closer to a less stressful Christmas payroll season! 🎉🎄
⚠️ IMPORTANT PRODUCT INFORMATION
This 13th Month Pay Calculator is designed to assist with 13th month pay estimates and recordkeeping.
It is NOT a complete payroll system, automatic tax calculator, or statutory labor compliance tool.
Please remember:
📌 The calculator uses eligible basic salary amounts entered by the user.
📌 The workbook does not automatically determine whether an employee is legally entitled to 13th month pay.
📌 Users must verify employee coverage and the correct salary basis before marking an employee as confirmed eligible.
📌 The general computation is total eligible basic salary earned during the calendar year divided by 12.
📌 The divisor remains 12 even when an employee worked only part of the year.
📌 Overtime, premium pay, night shift differential, holiday pay, unused leave cash equivalents, and allowances or benefits not integrated into basic salary are generally excluded, subject to applicable rules and arrangements.
📌 Unpaid absences and partial-month earnings must already be reflected in the eligible basic salary amounts entered.
📌 The workbook does not automatically handle special cases such as piece-rate employment, guaranteed salary plus commission, separation from employment, maternity salary differential, or income tax.
📌 Payments and advances must be entered accurately to calculate an estimated remaining balance.
📌 Sample employee information, salary amounts, dates, and calculations are fictional and provided for demonstration purposes only.
📌 Users must verify current Philippine labor regulations, official guidance, employee coverage, and applicable employment arrangements before processing payments.
This digital product is a calculation and recordkeeping aid. It does not replace professional accounting, payroll, HR, or legal advice.
For official references:
📖 NWPC Workers' Statutory Monetary Benefits Handbook (INCLUDED!)
📖 DOLE Labor Advisory No. 16-25 — Guidelines on the Payment of the Thirteenth Month Pay (INCLUDED!)
💛 STOP LETTING 13TH MONTH PAY COMPUTATIONS RUIN YOUR CHRISTMAS SPIRIT!
Running a business already means wearing MANY hats!
📦 Inventory Manager
📞 Customer Service Representative
💰 Sales Manager
👥 HR Officer
📊 Bookkeeper
🧾 Administrative Assistant
And every December…
CHRISTMAS PAYROLL MATHEMATICIAN PA! 🎄🧮😂
“Magkano ang eligible basic salary?”
“Kailan siya nag-start?”
“May unpaid absences ba?”
“May advance na ba siya?”
“Magkano na lang ang balance?”
Instead of repeatedly searching through payroll records and manually calculating every amount, why not use a simple digital calculator?
You don't need to be an accountant.
You don't need advanced Excel skills.
And you don't need expensive payroll software just to start organizing your 13th month pay computations!
YOU JUST NEED THE RIGHT TOOL! 💻✨
🚀 WORK SMARTER. CALCULATE CLEARER. ENJOY CHRISTMAS MORE!
💰 GET YOUR 13TH MONTH PAY CALCULATOR FOR ONLY ₱149!
🛒 CLICK BUY NOW AND START SIMPLIFYING YOUR YEAR-END PAYROLL COMPUTATIONS TODAY!
Because Christmas is for celebrating — not for spending sleepless nights calculating 13th month pay! 🎄💛
💙 GLASSPRO SYSTEMS
TOOLS BUILT FOR GLASS & ALUMINUM PROFESSIONALS
Practical digital tools designed to help entrepreneurs, business owners, and administrative teams work smarter, stay organized, and grow with confidence.
💛 Your Business. Better Systems. Brighter Possibilities.