Automatically translated.View original post

ðŸ’ĨCalculate the daily salary. Don't reconcile the calculator!

ðŸ’Ĩ calculate daily salary. Don't reconcile the calculator!

At the end of the month, a headache with a combined day of work + calculating the social security deduction itself. ðŸ˜Đ

Today we have an automatic salary calculation Excel template.

✅ Fill in the workday → Get a salary immediately

✅ Compute 5% Social Security Deduction (up to 750 baht) Auto

✅ Reduce headache time, easy to use, new ones are fine.

👉 fits HR owners who have to make their own salary.# Excel # Exceltutorial # ExcelTips # Excellent # Train today

2025/9/26 Edited to

... Read moreāļ–āđ‰āļēāļ„āļļāļ“āļāļģāļĨāļąāļ‡āļŦāļē “āđāļšāļšāļŸāļ­āļĢāđŒāļĄāļ„āđˆāļēāđāļĢāļ‡āļĢāļēāļĒāļ§āļąāļ™ Excel āļŸāļĢāļĩ” āļŦāļĢāļ·āļ­āļ­āļĒāļēāļāđ„āļ”āđ‰ “āļ•āļēāļĢāļēāļ‡āļ„āļģāļ™āļ§āļ“āđ€āļ‡āļīāļ™āđ€āļ”āļ·āļ­āļ™ Excel” āļ—āļĩāđˆāļāļĢāļ­āļāđāļĨāđ‰āļ§āļˆāļš āđ„āļĄāđˆāļ•āđ‰āļ­āļ‡āļĄāļēāļ™āļąāđˆāļ‡āļāļ”āđ€āļ„āļĢāļ·āđˆāļ­āļ‡āļ„āļīāļ”āđ€āļĨāļ‚āļ—āļļāļāļŠāļīāđ‰āļ™āđ€āļ”āļ·āļ­āļ™ āđ€āļĢāļēāđāļ™āļ°āļ™āļģāđƒāļŦāđ‰āļ•āļąāđ‰āļ‡āđ„āļŸāļĨāđŒāđ€āļ›āđ‡āļ™āđ‚āļ„āļĢāļ‡āđ€āļ”āļĩāļĒāļ§āđƒāļŠāđ‰āđ„āļ”āđ‰āļĒāļēāļ§āđ† (āđāļ™āļ§āđ‚āļ›āļĢāđāļāļĢāļĄāđ€āļ‡āļīāļ™āđ€āļ”āļ·āļ­āļ™āļŸāļĢāļĩ āđ„āļĄāđˆāļŦāļĄāļ”āļ­āļēāļĒāļļ) āđāļĨāđ‰āļ§āļ„āđˆāļ­āļĒāļ›āļĢāļąāļšāđƒāļŦāđ‰āđ€āļ‚āđ‰āļēāļāļąāļšāļāļ•āļīāļāļēāļ‚āļ­āļ‡āļšāļĢāļīāļĐāļąāļ—āļ„āđˆāļ° āđ‚āļ„āļĢāļ‡āļ•āļēāļĢāļēāļ‡āļ—āļĩāđˆāđ€āļĢāļēāđƒāļŠāđ‰āđāļĨāđ‰āļ§āđ€āļ§āļīāļĢāđŒāļ (āļ—āļģāđ€āļ›āđ‡āļ™āļŠāļĩāļ•āđ€āļ”āļĩāļĒāļ§āļāđ‡āđ„āļ”āđ‰) āļˆāļ°āļĄāļĩāļ„āļ­āļĨāļąāļĄāļ™āđŒāļŦāļĨāļąāļāđ† āđāļšāļšāļ™āļĩāđ‰: āļĢāļŦāļąāļŠāļžāļ™āļąāļāļ‡āļēāļ™, āļŠāļ·āđˆāļ­-āļŠāļāļļāļĨ, āļ­āļąāļ•āļĢāļēāļ„āđˆāļēāđāļĢāļ‡/āļ§āļąāļ™, āļˆāļģāļ™āļ§āļ™āļ§āļąāļ™āļ—āļģāļ‡āļēāļ™, OT (āļ–āđ‰āļēāļĄāļĩ), āđ€āļšāļĩāđ‰āļĒāļ‚āļĒāļąāļ™/āļ­āļ·āđˆāļ™āđ†, āļĢāļēāļĒāđ„āļ”āđ‰āļĢāļ§āļĄ, āļŦāļąāļāļ›āļĢāļ°āļāļąāļ™āļŠāļąāļ‡āļ„āļĄ, āļĒāļ­āļ”āļŠāļļāļ—āļ˜āļī āđ‚āļ”āļĒāđ€āļ‰āļžāļēāļ°āļŠāđˆāļ­āļ‡ â€œāļˆāļģāļ™āļ§āļ™āļ§āļąāļ™āļ—āļģāļ‡āļēāļ™â€ āļ™āļĩāđˆāđāļŦāļĨāļ°āļ—āļĩāđˆāļāļĢāļ­āļāļ—āļĩāđ€āļ”āļĩāļĒāļ§āđāļĨāđ‰āļ§āđƒāļŦāđ‰āļŠāļđāļ•āļĢāļ„āļģāļ™āļ§āļ“āļ•āđˆāļ­āđƒāļŦāđ‰āļ—āļąāđ‰āļ‡āļŦāļĄāļ” āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡ â€œāļŠāļđāļ•āļĢāļ„āļīāļ”āļ„āđˆāļēāđāļĢāļ‡āļĢāļēāļĒāļ§āļąāļ™ Excel” āļ—āļĩāđˆāđƒāļŠāđ‰āļ‡āđˆāļēāļĒāļĄāļēāļ: - āļĢāļēāļĒāđ„āļ”āđ‰āļˆāļēāļāļ„āđˆāļēāđāļĢāļ‡ = āļ­āļąāļ•āļĢāļēāļ„āđˆāļēāđāļĢāļ‡āļ•āđˆāļ­āļ§āļąāļ™ * āļˆāļģāļ™āļ§āļ™āļ§āļąāļ™āļ—āļģāļ‡āļēāļ™ (āđ€āļŠāđˆāļ™ =C2*D2) - āļĢāļēāļĒāđ„āļ”āđ‰āļĢāļ§āļĄ = āļ„āđˆāļēāđāļĢāļ‡ + OT + āđ€āļšāļĩāđ‰āļĒāļ‚āļĒāļąāļ™ (āđ€āļŠāđˆāļ™ =E2+F2+G2) āļŠāđˆāļ§āļ™āđ€āļĢāļ·āđˆāļ­āļ‡ â€œāļŦāļąāļāļ›āļĢāļ°āļāļąāļ™āļŠāļąāļ‡āļ„āļĄ 5% (āļŠāļđāļ‡āļŠāļļāļ” 750 āļšāļēāļ—)” āđƒāļ™āđ„āļŸāļĨāđŒāđ€āļ‡āļīāļ™āđ€āļ”āļ·āļ­āļ™āđ€āļĢāļēāđƒāļŠāđ‰āļŠāļđāļ•āļĢāđāļ™āļ§āļ™āļĩāđ‰ (āļ›āļĢāļąāļšāļ•āļēāļĄāļŠāđˆāļ­āļ‡āļˆāļĢāļīāļ‡āđ„āļ”āđ‰): - āļŦāļąāļāļ›āļĢāļ°āļāļąāļ™āļŠāļąāļ‡āļ„āļĄ = MIN(āļĢāļēāļĒāđ„āļ”āđ‰āļĢāļ§āļĄ*0.05,750) āļŠāļđāļ•āļĢ MIN āļŠāđˆāļ§āļĒāļĨāđ‡āļ­āļāđ€āļžāļ”āļēāļ™āđƒāļŦāđ‰āđ„āļĄāđˆāđ€āļāļīāļ™ 750 āļ­āļąāļ•āđ‚āļ™āļĄāļąāļ•āļī āļ—āļģāđƒāļŦāđ‰āđāļšāļšāļŸāļ­āļĢāđŒāļĄāļˆāđˆāļēāļĒāļ„āđˆāļēāđāļĢāļ‡āļĢāļēāļĒāļ§āļąāļ™/āļĢāļēāļĒāđ€āļ”āļ·āļ­āļ™āļ”āļđāđ€āļ›āđ‡āļ™āļĄāļēāļ•āļĢāļāļēāļ™āļ‚āļķāđ‰āļ™āļĄāļēāļ āļ—āļĢāļīāļ„āļ—āļĩāđˆāļŠāđˆāļ§āļĒāļĨāļ”āļ‡āļēāļ™āļ‹āđ‰āļģ (āđ€āļŦāļĄāļēāļ°āļāļąāļšāļ„āļ™āļ—āļģ HR āļŦāļĢāļ·āļ­āđ€āļˆāđ‰āļēāļ‚āļ­āļ‡āļāļīāļˆāļāļēāļĢāļ—āļĩāđˆāļ•āđ‰āļ­āļ‡āļ—āļģāđ€āļ­āļ‡): 1) āļ—āļģāļŠāđˆāļ­āļ‡āđ€āļ›āđ‡āļ™ â€œāļ•āļēāļĢāļēāļ‡ (Format as Table)” āļˆāļ°āļĨāļēāļāļŠāļđāļ•āļĢāļĨāļ‡āļ—āļąāđ‰āļ‡āļ„āļ­āļĨāļąāļĄāļ™āđŒāļ­āļąāļ•āđ‚āļ™āļĄāļąāļ•āļī 2) āđāļĒāļāļŠāļĩāļ• â€œāļ•āļąāđ‰āļ‡āļ„āđˆāļē” āđ„āļ§āđ‰āđ€āļāđ‡āļšāļ­āļąāļ•āļĢāļēāļ„āđˆāļēāđāļĢāļ‡/āļŠāļ·āđˆāļ­āļžāļ™āļąāļāļ‡āļēāļ™ āđāļĨāđ‰āļ§āļ”āļķāļ‡āļĄāļēāđƒāļŠāđ‰āļ”āđ‰āļ§āļĒ VLOOKUP/XLOOKUP āļˆāļ°āļĨāļ”āļāļēāļĢāļžāļīāļĄāļžāđŒāļœāļīāļ” 3) āđƒāļŠāđˆ Data Validation āđƒāļŦāđ‰āļˆāļģāļ™āļ§āļ™āļ§āļąāļ™āļ—āļģāļ‡āļēāļ™āđƒāļŠāđˆāđ„āļ”āđ‰āđāļ„āđˆ 0–31 (āļŦāļĢāļ·āļ­āļŠāđˆāļ§āļ‡āļ—āļĩāđˆāļ•āđ‰āļ­āļ‡āļāļēāļĢ) āļāļąāļ™āļāļĢāļ­āļāļĄāļąāđˆāļ§ 4) āļŠāļĢāļļāļ› â€œāļĒāļ­āļ”āđ€āļ‡āļīāļ™āđ€āļ”āļ·āļ­āļ™āļ—āļĩāđˆāļ•āđ‰āļ­āļ‡āļˆāđˆāļēāļĒāļ›āļĢāļ°āļˆāļģāđ€āļ”āļ·āļ­āļ™â€ āļ”āđ‰āļ§āļĒ SUM āđ€āļžāļ·āđˆāļ­āđ€āļŠāđ‡āļāļĒāļ­āļ”āļĢāļ§āļĄāļāđˆāļ­āļ™āđ‚āļ­āļ™āđ€āļ‡āļīāļ™āļˆāļĢāļīāļ‡ āļŠāļļāļ”āļ—āđ‰āļēāļĒ āļ–āđ‰āļēāļšāļĢāļīāļĐāļąāļ—āļĄāļĩāđ€āļ‡āļ·āđˆāļ­āļ™āđ„āļ‚āđ€āļžāļīāđˆāļĄ āđ€āļŠāđˆāļ™ āļŦāļąāļāļ‚āļēāļ”/āļĨāļēāđ„āļĄāđˆāļˆāđˆāļēāļĒ/āļ„āđˆāļēāļ›āļĢāļąāļš āļŦāļĢāļ·āļ­āļˆāđˆāļēāļĒāđ€āļ›āđ‡āļ™āļĢāļēāļĒāļ§āļąāļ™āļˆāļĢāļīāļ‡āđ† āļāđ‡āđ€āļžāļīāđˆāļĄāļ„āļ­āļĨāļąāļĄāļ™āđŒ “āļĢāļēāļĒāļāļēāļĢāļŦāļąāļâ€ āđāļĨāļ° â€œāļŦāļĄāļēāļĒāđ€āļŦāļ•āļļ” āđ„āļ§āđ‰āđƒāļ™āļ•āļēāļĢāļēāļ‡āļ„āđˆāļēāđāļĢāļ‡āļĢāļēāļĒāļ§āļąāļ™ excel āđ„āļ”āđ‰āđ€āļĨāļĒāļ„āđˆāļ° āļžāļ­āļĄāļĩāđ‚āļ„āļĢāļ‡āļ™āļĩāđ‰āđāļĨāđ‰āļ§ āđ€āļ”āļ·āļ­āļ™āļ•āđˆāļ­āđ„āļ›āđāļ„āđˆāļ„āļąāļ”āļĨāļ­āļāļŠāļĩāļ• āđ€āļ›āļĨāļĩāđˆāļĒāļ™āļˆāļģāļ™āļ§āļ™āļ§āļąāļ™āļ—āļģāļ‡āļēāļ™ āļāđ‡āđ„āļ”āđ‰āļĒāļ­āļ”āļŠāļļāļ—āļ˜āļīāļ—āļąāļ™āļ—āļĩ āļŠāđˆāļ§āļĒāļ›āļĢāļ°āļŦāļĒāļąāļ”āđ€āļ§āļĨāļēāđāļĨāļ°āļĨāļ”āļ„āļ§āļēāļĄāļœāļīāļ”āļžāļĨāļēāļ”āđ„āļ”āđ‰āđ€āļĒāļ­āļ°āļĄāļēāļāđ†

Related posts

A majestic lion's head, rendered in warm orange and red tones, with glowing light at the bottom. Overlayed text reads: "THE POWERFUL NAME OF JESUS."
A majestic lion's head in warm orange and red tones. Overlayed text states: "THE NAME ABOVE EVERY NAME," followed by a description of Jesus' name being exalted, citing Philippians 2:9-10.
A majestic lion's head in warm orange and red tones. Overlayed text states: "SALVATION IN HIS NAME," followed by a description of Jesus' name as the only doorway to salvation, citing Acts 4:12.
The Lion still roars. The Name still reigns. JESUS
#Lemon8Diary #christian #jesus #spirituality #viral #jesusfollower
Lylicious

Lylicious

1055 likes

Her best friend lost her son... and now she is trying to STEAL hers! #movie #film #fyp
lovemovie

lovemovie

403 likes

How to pray 101 for beginners: Reconcile
Joel2: 25 “I will repay you for the years the locusts have eaten— the great locust and the young locust, the other locusts and the locust swarm[a]— my great army that I sent among you. #reconciliation #letgo #keepgoing #godrelationship #restoration
Ariel Richardson

Ariel Richardson

7 likes

A laptop and coffee cup sit on a wooden table outdoors, overlooking a scenic mountain valley. The image has a text overlay that reads 'Bible Journaling Ideas'.
An open Bible page shows a drawing of mountains, a river, and colorful flowers. The text 'his foundation is in the holy mountains' is handwritten next to the drawing.
An open Bible page features the word 'PRAISE' written three times in large, bubble letters, colored in shades of blue and gray, next to Psalm 150:6.
Bible journaling ideas ðŸŦķðŸŧ
I absolutely love to journal so here are some simple journaling ideas (as requested!)ðŸĨ° These are just some of my favorites that I saved on Pinterest and have done myself! I definitely recommend giving journaling a try! Comment ⮇ïļ below if you have any other suggestions!ðŸĨđ #journalingbible #biblej
Ava wells

Ava wells

211 likes

Prioritize life now — the future might not come.
#retirement #retirementplanning #microretirement #lifestylemotivation #lifeadvice
ClaraCocoa

ClaraCocoa

1 like

#film #tiktok #foryou #fyp
Francisinn Qu

Francisinn Qu

131 likes

Beyond the page 📑
#sat #study #studywithme #viral #fyp
Henry SAT

Henry SAT

43 likes

TRAINTHROUGHPAIN.COM

TRAINTHROUGHPAIN.COM

17 likes

The House Representatives Doesn't Need Trump?
Scott Free Morning Show

Scott Free Morning Show

2 likes

How to find your coworkers salary 💰
Wanna know if you're being paid fairly? Start here 👇 ðŸ’ŧ Use Levels.fyi → Type in the company name (like Google, Meta, Amazon) → Look up your role and level (ex: L4 Software Engineer) → You’ll see salary plus stock and bonus breakdowns 🧠 Ask ChatGPT → Try this prompt: “What’s the average
Nikki

Nikki

2 likes

What if the quiet kid had powers... and no mercy? #movie #film
lovemovie

lovemovie

59 likes

Daily Oracle FYP
#tarotreadersoftitktok #tarotreadersoflemon8 #oraclecards #oraclemessage #dailyoracle
Johnny 🌞The Sun Mage🌞

Johnny 🌞The Sun Mage🌞

2 likes

A screenshot of a text message from an ex, expressing deep regret, missing the recipient, and asking to meet to apologize in person. The message details feelings of longing and dreams about the past relationship. A small Lemon8 watermark is visible at the bottom.
Manifested my ex back and he begged to reconcile.
I was shocked when he suddenly sent me a message -it truly worked. #ManifestingMe #manifestion #manifestationtips
KK

KK

2 likes

They know that you may have outgrown them by now, but they still wish they could reconcile #storytime #foryou #viral #fyp #tiktok #fypシ #cairo.nova9 #foryoupage
salemka253

salemka253

0 likes

#godisgood #jesuslovesyou #christiantiktok
CHLOðŸ§ļ

CHLOðŸ§ļ

1 like

Day 17/60 Days of CFO: Reconcile Prepaid Expenses
This may be the most common adjusting journal entry to book in a month end close and it’s actually fairly simple once you understand the concept Let’s jump into it ➡ïļ What are Prepaid Expenses? Prepaid Expenses represent the amounts paid in advance for a benefit you have yet to incur
ExpressoSolut

ExpressoSolut

4 likes

An office interior with wooden partitions and a chair, featuring the title 'Calculating Total Compensation ITS MORE THAN JUST YOUR SALARY' in white text, framed by a dashed circle. The Lemon8 logo and username are at the bottom.
A dark-themed graphic explaining 'What goes into total compensation?' It lists components like Tips, Bonuses, Benefits, Commission, and Other Perks with brief descriptions. The Lemon8 logo and username are at the bottom.
A light-themed graphic with text discussing how to evaluate job offers by considering total compensation beyond just salary, using an example comparing two job scenarios. The Lemon8 logo and username are at the bottom.
How to calculate a job’s total compensation! 💰
While salary is your main form of compensation for most jobs, your total compensation is much more than that! Total compensation is the sum of an employee’s salary and any additional payments, which can include: - Tips - Benefits (medical/dental/vision insurance, stipends, etc.) - Bonuses
hannah 💟

hannah 💟

16 likes

A devotional page titled "Faithfulness Through the Ages" for Monday, 14, discussing God's unwavering faithfulness, fulfilled prophecies, and promises of salvation through Jesus, referencing Deuteronomy 7:8-9.
Faithfulness Through the Ages
Deuteronomy 7:8-9 NIV [8] But it was because the Lord loved you and kept the oath he swore to your ancestors that he brought you out with a mighty hand and redeemed you from the land of slavery, from the power of Pharaoh king of Egypt. [9] Know therefore that the Lord your God is God; he is the f
Karen 🇚ðŸ‡ļ💜

Karen 🇚ðŸ‡ļ💜

3 likes

They are abandoning a situation to reconcile w/you
#tarot #contentcreator #zodiac #lemon #pisces
🇚ðŸ‡ļHalloweenbaby1031Tarot🇭ðŸ‡đ

🇚ðŸ‡ļHalloweenbaby1031Tarot🇭ðŸ‡đ

2 likes

They are waiting on this Jackpot to reconcile w/U😒
#tarot #Lemon8 #zodiacsigns #spirituality #reading
🇚ðŸ‡ļHalloweenbaby1031Tarot🇭ðŸ‡đ

🇚ðŸ‡ļHalloweenbaby1031Tarot🇭ðŸ‡đ

6 likes

See more