{"id":999978552,"date":"2025-10-08T11:35:15","date_gmt":"2025-10-08T04:35:15","guid":{"rendered":"https:\/\/bizzi.vn\/?p=999978552"},"modified":"2026-08-14T16:54:09","modified_gmt":"2026-08-14T09:54:09","slug":"9-latest-employee-salary-sheet-templates-excel-word-2025","status":"publish","type":"post","link":"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/","title":{"rendered":"12 M\u1eabu B\u1ea3ng L\u01b0\u01a1ng Nh\u00e2n Vi\u00ean [Excel\/Word] M\u1edbi Nh\u1ea5t 2026"},"content":{"rendered":"<article class=\"bizzi-template-page\" aria-label=\"Updated Excel and Word employee payroll templates (2026)\">\n<div class=\"template-sapo\" aria-label=\"Summary of the article\">\n<p>The following documents include: <strong>12 sample payroll and salary payment forms<\/strong> Businesses can download the payroll forms according to each payment method: monthly, 3P, business, product, hourly\/shift, construction worker, collaborator, individual payslip, and Form 01-L\u0110TL as per Circular 99.<\/p>\n<p>One easy way to choose is to start from <strong>how businesses are calculating salaries<\/strong>, not from the file name. If paying by the number of working days, use the monthly template or a simple template; if there are shifts\/part-time, use the hourly template; if paying by project volume, use the construction template. After downloading, it&#039;s advisable to test it with a small group of employees and review their contracts, salary and bonus regulations, insurance, tax, and payment records before applying it to the entire payroll period.<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Index<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#1_Tai_12_mau_bang_luong_nhan_vien_ExcelWord_2026\" >1. Download 12 Excel\/Word 2026 employee payroll templates.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#2_Chon_mau_bang_luong_theo_cach_doanh_nghiep_dang_tra_luong\" >2. Choose a payroll template based on how your company currently pays salaries.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#21_Mau_bang_luong_nhan_vien_don_gian\" >2.1. Simple employee payroll template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#22_Mau_bang_luong_theo_thang\" >2.2. Monthly salary sheet template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#23_Mau_bang_luong_3P\" >2.3. 3P Payroll Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#24_Mau_bang_luong_nhan_vien_kinh_doanh\" >2.4. Sales staff salary sheet template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#25_Mau_bang_luong_theo_baccap_bac\" >2.5. Salary table template by level\/rank<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#26_Mau_bang_luong_theo_san_pham\" >2.6. Sample payroll by product<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#27_Mau_bang_luong_theo_gio_ca_va_part-time\" >2.7. Sample hourly, shift, and part-time payroll sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#28_Mau_bang_luong_cong_nhan_xay_dung\" >2.8. Sample payroll sheet for construction workers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#29_Mau_bang_thanh_toan_thu_lao_cong_tac_vien\" >2.9. Sample payment sheet for collaborators<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#210_Mau_phieu_luong_ca_nhan\" >2.10. Individual Payroll Slip Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#211_Mau_bang_luong_nhan_vien_tong_hop\" >2.11. Sample of a consolidated employee payroll sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#212_Mau_01-LDTL_%E2%80%93_Bang_thanh_toan_tien_luong_theo_Thong_tu_99\" >2.12. Form 01-L\u0110TL \u2013 Salary Payment Table according to Circular 99<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#3_Bang_luong_phieu_luong_thang_bang_luong_va_Mau_01-LDTL_khac_nhau_the_nao\" >3. What are the differences between a payroll sheet, payslip, salary scale, and Form 01-L\u0110TL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#4_Khi_dung_bang_luong_nam_2026_can_kiem_tra_nhung_gi_da_thay_doi\" >4. When using the 2026 payroll system, what changes need to be checked?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#41_Muc_luong_toi_thieu_vung_tu_01012026\" >4.1. Regional minimum wage effective from January 1, 2026<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#42_Khong_lay_%E2%80%9Cluong_co_ban%E2%80%9D_lam_can_cu_dong_BHXH_mot_cach_may_moc\" >4.2. Do not mechanically use &quot;basic salary&quot; as the basis for social insurance contributions.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#43_Thue_TNCN_nam_2026_muc_giam_tru_moi_va_bieu_thue_5_bac\" >4.3. Personal Income Tax in 2026: New Deduction Levels and 5-Tier Tax Schedule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#44_Khong_dua_%E2%80%9Cphat_tien%E2%80%9D_vao_bang_luong_nhu_mot_khoan_khau_tru_mac_dinh\" >4.4. Do not include &quot;fines&quot; in payroll as a default deduction.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#45_Khoan_thanh_toan_luong_tu_5_trieu_donglan_va_chung_tu_khong_dung_tien_mat\" >4.5. Salary payments of 5 million VND or more per payment, with non-cash payment documents.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#5_Cach_lap_bang_luong_di_tu_du_lieu_nguon_den_so_thuc_nhan\" >5. How to create a payroll table: starting from source data to actual received amount<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#6_Ba_tinh_huong_khien_bang_luong_de_dung_cong_thuc_nhung_sai_nghiep_vu\" >6. Three situations where payroll calculations are likely to follow the correct formula but are technically incorrect.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#Nhan_vien_vao_hoac_nghi_giua_thang\" >Employees may start or leave mid-month.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#Nhan_vien_theo_gio_ca_dem_hoac_lam_them\" >Hourly, night shift, or overtime staff<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#Luong_sales_san_pham_hoac_cong_trinh\" >Sales commission, per product or per project.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#7_Checklist_truoc_khi_duyet_va_thanh_toan_bang_luong\" >7. Checklist before reviewing and paying payroll.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#8_Khi_nao_Excel_van_du_khi_nao_nen_danh_gia_he_thong_payroll\" >8. When is Excel sufficient, and when should the payroll system be evaluated?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#9_Bizzi_phu_hop_o_dau_sau_khi_bang_luong_da_duoc_xu_ly\" >9. Where does Bizzi fit in after the payroll has been processed?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#Payroll_va_chi_phi_nhan_vien_la_hai_lop_khac_nhau\" >Payroll and employee costs are two different categories.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#10_Cau_hoi_thuong_gap_ve_mau_bang_luong_nhan_vien\" >10. Frequently Asked Questions about Employee Payroll Templates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/bizzi.vn\/en\/9-latest-employee-salary-sheet-templates-excel-word-2025\/#Nguon_phap_ly_tham_chieu\" >Referenced legal sources<\/a><\/li><\/ul><\/nav><\/div>\n\n<\/div>\n<section id=\"tai-mau\" class=\"template-section\" aria-labelledby=\"tai-mau-heading\">\n<h2 id=\"tai-mau-heading\"><span class=\"ez-toc-section\" id=\"1_Tai_12_mau_bang_luong_nhan_vien_ExcelWord_2026\"><\/span>1. Download 12 Excel\/Word 2026 employee payroll templates.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You don&#039;t need to download all 12 files. The table below will take you directly to the template closest to your current payroll system. Three additional templates are available in August 2026. <strong>Hourly\/Shift\/Part-time wage table<\/strong>, <strong>construction worker salary scale<\/strong> and <strong>Form 01-L\u0110TL according to Circular 99<\/strong>.<\/p>\n<div class=\"bizzi-table-wrap\" tabindex=\"0\" role=\"region\" aria-label=\"Quick selection of 12 payroll templates\">\n<table>\n<caption>Quickly select a template based on calculation method and intended use.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Sample<\/th>\n<th scope=\"col\">Suitable when<\/th>\n<th scope=\"col\">Format<\/th>\n<th scope=\"col\">See details<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Simple employee payroll<\/td>\n<td>Fewer salary components, need to track working days and actual earnings.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-don-gian\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Monthly payroll<\/td>\n<td>Regular payroll, multiple employees\/departments<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-theo-thang\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>3P Salary Table<\/td>\n<td>The Position-Person-Performance mechanism is already in place.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-3p\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Sales staff salary scale<\/td>\n<td>There is a fixed salary, sales commission, bonuses, and KPIs.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-kinh-doanh\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Salary scale by grade\/level<\/td>\n<td>There is an internal salary scale or coefficient system.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-cap-bac\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Piecework wage system<\/td>\n<td>Calculated by quantity \u00d7 unit price<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-san-pham\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Hourly\/Shift\/Part-time wage table<\/td>\n<td>F&amp;B, retail, warehousing, seasonal or flexible shifts<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-gio-ca\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Construction worker salary scale<\/td>\n<td>Based on daily wages or volume\/contract payment per project.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-xay-dung\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Collaborator Compensation Payment Table<\/td>\n<td>Payment is based on work, project, or agreed-upon unit price.<\/td>\n<td>Word<\/td>\n<td><a href=\"#mau-ctv\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Individual payslip<\/td>\n<td>Send detailed income\/deduction information for each employee.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-phieu-luong\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Summary payroll<\/td>\n<td>Data needs to be compiled by department.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-tong-hop\">See sample<\/a><\/td>\n<\/tr>\n<tr>\n<td>Form 01-L\u0110TL according to Circular 99<\/td>\n<td>A payroll payment sheet is needed in the accounting documentation system.<\/td>\n<td>Excel<\/td>\n<td><a href=\"#mau-01-ldtl\">See sample<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<aside class=\"bizzi-callout\"><strong>Note before downloading:<\/strong> The first 11 files are primarily used for calculating salaries, tracking, or sending salary information as needed by the administration. <strong>Form 01-L\u0110TL<\/strong> This is a payroll payment sheet belonging to the group of labor and payroll documents under Circular 99\/2025\/TT-BTC. It is inappropriate to refer to every Excel file in this set as a &quot;template according to Circular 99&quot;.<\/aside>\n<\/section>\n<section id=\"chon-mau\" class=\"template-section\" aria-labelledby=\"chon-mau-heading\">\n<h2 id=\"chon-mau-heading\"><span class=\"ez-toc-section\" id=\"2_Chon_mau_bang_luong_theo_cach_doanh_nghiep_dang_tra_luong\"><\/span>2. Choose a payroll template based on how your company currently pays salaries.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In reality, even though they&#039;re all called &quot;payroll,&quot; the input data can vary greatly. The best template is one that allows accountants to see the details immediately. <strong>Where does salary come from?<\/strong> and it can be traced back to the source document when verification is needed.<\/p>\n<div class=\"template-download-grid\">\n<article id=\"mau-don-gian\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"21_Mau_bang_luong_nhan_vien_don_gian\"><\/span>2.1. Simple employee payroll template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Suitable for businesses with a payroll structure that doesn&#039;t have too many variables. The file focuses on working days, income, insurance, taxes, advances, and net amount received.<\/p>\n<figure class=\"bizzi-image\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.33.35-1024x520.png\" alt=\"Simple Excel employee payroll template\" width=\"1024\" height=\"520\" title=\"\"><figcaption>The payroll template has a simple layout to track income from total earnings to net salary.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-nhan-vien-don-gian.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-theo-thang\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"22_Mau_bang_luong_theo_thang\"><\/span>2.2. Monthly salary sheet template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This method is recommended when businesses finalize payroll on a fixed period and need to filter by department. Before finalizing the file, check the list of employees joining\/leaving for the month to avoid calculating the full payroll period for those who only worked for part of the month.<\/p>\n<figure class=\"bizzi-image\"><img decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-16.10.23-1024x508.png\" alt=\"Excel monthly payroll template\" width=\"1024\" height=\"508\" title=\"\"><figcaption>Monthly templates are suitable when you need to manage many employees and departments.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-theo-thang.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-3p\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"23_Mau_bang_luong_3P\"><\/span>2.3. 3P Payroll Template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This file should only be used when the business already has a way to define P1 \u2013 position, P2 \u2013 capabilities, and P3 \u2013 performance. The file cannot replace the development of a 3P policy; it only helps to consolidate the values that have already been identified and approved.<\/p>\n<div class=\"bizzi-image-grid\">\n<figure class=\"bizzi-image\"><img decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.31.25-1024x240.png\" alt=\"3P Salary Form Template - Position, Person, and Performance\" width=\"1024\" height=\"240\" title=\"\"><figcaption>Components P1, P2, and P3.<\/figcaption><\/figure>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.32.56-1024x494.png\" alt=\"3P Salary Form Template: Income and Net Received\" width=\"1024\" height=\"494\" title=\"\"><figcaption>Total income and net income.<\/figcaption><\/figure>\n<\/div>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Bang-luong-nhan-vien-theo-quy-tac-3P.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-kinh-doanh\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"24_Mau_bang_luong_nhan_vien_kinh_doanh\"><\/span>2.4. Sales staff salary sheet template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It&#039;s helpful to include both a fixed salary and a variable portion based on sales\/KPIs. Sales, commission rates, and bonuses should be separated so that when discrepancies arise, auditors can identify errors in sales data or the salary formula.<\/p>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.32.30-1024x267.png\" alt=\"Sample payroll sheet for sales staff with KPI commission\" width=\"1024\" height=\"267\" title=\"\"><figcaption>This sales salary template separates fixed salary, sales commission, bonus, and KPI.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-nhan-vien-kinh-doanh-.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-cap-bac\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"25_Mau_bang_luong_theo_baccap_bac\"><\/span>2.5. Salary table template by level\/rank<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This applies to businesses with an internal salary scale or coefficient system. The coefficients used in the public sector should not be applied as a default for businesses; the salary levels, coefficients, and promotion conditions must adhere to the established policies.<\/p>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.30.34-1024x372.png\" alt=\"Excel salary scale template based on salary grades.\" width=\"1024\" height=\"372\" title=\"\"><figcaption>A template based on salary grades\/levels is used to calculate salaries from the base salary and internal coefficients.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-theo-bac_cap-bac.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-san-pham\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"26_Mau_bang_luong_theo_san_pham\"><\/span>2.6. Sample payroll by product<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Suitable for production or work that can be measured by output. The two most important data points are: <strong>confirmed volume<\/strong> and <strong>The unit price has been approved.<\/strong>; If one of the two is not locked, the total salary may still be correct according to the formula but the transaction will be incorrect.<\/p>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.31.09-1024x442.png\" alt=\"Excel template for piece-rate payroll\" width=\"1024\" height=\"442\" title=\"\"><figcaption>The product-based wage model uses output and unit price as input data.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-theo-san-pham.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-gio-ca\" class=\"template-card template-card-new\"><span class=\"template-badge\">New model 2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"27_Mau_bang_luong_theo_gio_ca_va_part-time\"><\/span>2.7. Sample hourly, shift, and part-time payroll sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This template is for stores, F&amp;B businesses, warehouses, part-time employees, or models with flexible shifts. The file separates regular hours, night hours, overtime hours, and corresponding rates, and includes a region selection sheet to check the basic hourly rate against the minimum rate for 2026.<\/p>\n<p><strong>Points to note:<\/strong> The file does not automatically assign an overtime\/night shift coefficient to every case. Businesses enter unit prices that have been determined according to the work schedule, agreements, and applicable regulations.<\/p>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2026\/08\/Bizzi-Mau-bang-luong-theo-gio-ca-part-time-2026.xlsx\">Download hourly\/shift\/part-time template<\/a><\/p>\n<\/article>\n<article id=\"mau-xay-dung\" class=\"template-card template-card-new\"><span class=\"template-badge\">New model 2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"28_Mau_bang_luong_cong_nhan_xay_dung\"><\/span>2.8. Sample payroll sheet for construction workers<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Instead of using a single employee table, this file separates it into three sheets: <strong>by working days<\/strong>, <strong>by volume\/contract<\/strong> and <strong>Summary by project<\/strong>. This layout allows for tracking projects, teams\/groups, items, number of work units, or quantities that have been inspected and approved.<\/p>\n<p>If a team receives both daily wages and piecework pay, the source of wage calculation should be recorded separately before totaling, to avoid adding up the same workload twice.<\/p>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2026\/08\/Bizzi-Mau-bang-luong-cong-nhan-xay-dung-2026.xlsx\">Download construction worker template<\/a><\/p>\n<\/article>\n<article id=\"mau-ctv\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"29_Mau_bang_thanh_toan_thu_lao_cong_tac_vien\"><\/span>2.9. Sample payment sheet for collaborators<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This Word template is suitable for summarizing work, quantities, unit prices, and payable fees. It shouldn&#039;t be assumed that all terms like &quot;Collaborator&quot; automatically mean the same insurance or tax obligations; the nature of the relationship and specific documentation need to be considered.<\/p>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/10\/mau-bang-luong-cong-tac-vien.png\" alt=\"Sample payment sheet for collaborators\" width=\"1224\" height=\"694\" title=\"\"><figcaption>Payment schedule for collaborators based on assigned tasks and agreed-upon rates.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/10\/Bizzi-Vietnam-Mau-bang-luong-cong-tac-vien.docx\">Download Word template<\/a><\/p>\n<\/article>\n<article id=\"mau-phieu-luong\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"210_Mau_phieu_luong_ca_nhan\"><\/span>2.10. Individual Payroll Slip Template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is to allow employees to see how their earnings for the period are calculated: income, insurance, taxes, advances, and justified deductions. The payslip should match the approved payroll, not be a standalone calculation.<\/p>\n<figure class=\"bizzi-image bizzi-image-portrait\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/10\/Screenshot-2025-10-08-at-11.22.33-1024x984.png\" alt=\"Excel personal payslip template\" width=\"1024\" height=\"984\" title=\"\"><figcaption>Pay slips help employees verify their income and deductions.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/10\/Bizzi-Vietnam-Mau-bang-luong-ca-nhan-phieu-luong-Excel.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-tong-hop\" class=\"template-card\">\n<h3><span class=\"ez-toc-section\" id=\"211_Mau_bang_luong_nhan_vien_tong_hop\"><\/span>2.11. Sample of a consolidated employee payroll sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is suitable when accountants need a summary sheet after the detailed payroll sheet to view expenses and actual receipts by department. It&#039;s better to keep the detailed sheet as the source and use the summary sheet for comparison, rather than re-entering the same data in two places.<\/p>\n<figure class=\"bizzi-image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-24-at-15.33.35-1024x520.png\" alt=\"Excel Employee Payroll Template\" width=\"1024\" height=\"520\" title=\"\"><figcaption>The detailed table serves as input for the payroll cost aggregation layer.<\/figcaption><\/figure>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/Bizzi-Vietnam-Mau-bang-luong-nhan-vien-tong-hop.xlsx\">Download Excel template<\/a><\/p>\n<\/article>\n<article id=\"mau-01-ldtl\" class=\"template-card template-card-new\"><span class=\"template-badge\">TT99 \u00b7 New model 2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"212_Mau_01-LDTL_%E2%80%93_Bang_thanh_toan_tien_luong_theo_Thong_tu_99\"><\/span>2.12. Form 01-L\u0110TL \u2013 Salary Payment Table according to Circular 99<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Form 01-L\u0110TL is part of the document group. <strong>Labor - wages<\/strong> In Appendix I of Circular 99\/2025\/TT-BTC. This form is used as a basis for paying salaries, allowances, additional income beyond salary, and for verifying payments to employees.<\/p>\n<p>This is the file you should download if your goal is... <strong>payroll payment vouchers according to accounting regulations<\/strong>. If detailed calculations of shifts, KPIs, commissions, or output are needed before determining the amount payable, businesses can still use an internal payroll workbook in the preceding step.<\/p>\n<p><a class=\"download-template-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2026\/08\/Bizzi-Mau-01-LDTL-Thong-tu-99-2026.xlsx\">Download Form 01-L\u0110TL Excel<\/a><\/p>\n<\/article>\n<\/div>\n<\/section>\n<section id=\"phan-biet\" class=\"template-section\" aria-labelledby=\"phan-biet-heading\">\n<h2 id=\"phan-biet-heading\"><span class=\"ez-toc-section\" id=\"3_Bang_luong_phieu_luong_thang_bang_luong_va_Mau_01-LDTL_khac_nhau_the_nao\"><\/span>3. What are the differences between a payroll sheet, payslip, salary scale, and Form 01-L\u0110TL?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Many businesses refer to these documents collectively as &quot;payroll,&quot; but their purposes differ. Differentiating them from the outset will make selecting the right file and creating a payment record simpler.<\/p>\n<div class=\"bizzi-table-wrap\" tabindex=\"0\" role=\"region\" aria-label=\"Distinguishing between payroll records and related documents.\">\n<table>\n<caption>Four types of documents that are often confused with each other.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Document<\/th>\n<th scope=\"col\">Main role<\/th>\n<th scope=\"col\">When is it needed?<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th scope=\"row\">Excel payroll spreadsheet<\/th>\n<td>Calculated from job\/income data to actual amount received.<\/td>\n<td>When businesses need a customized management formula based on working days, KPIs, commissions, products, shifts, or piecework.<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">Payslip<\/th>\n<td>Detailed salary information for each individual.<\/td>\n<td>When it is necessary to send documents to employees for income verification and deductions.<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">Salary scales and pay tables<\/th>\n<td>Establish a salary system based on job\/position.<\/td>\n<td>When designing salary policies, recruitment, ranking, and salary adjustments.<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">Form 01-L\u0110TL<\/th>\n<td>The payroll payment sheet is part of the accounting document system according to Circular 99.<\/td>\n<td>When preparing payroll payment documents in the applicable corporate accounting system.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Circular 99 includes a whole group of labor and wage documents, not just Form 01-L\u0110TL. If you are reviewing your document system from the 2026 fiscal year, you can refer to it for more information. <a href=\"https:\/\/bizzi.vn\/mau-chung-tu-ke-toan-theo-thong-tu-99\/\">List of sample accounting documents according to Circular 99<\/a> after you have determined the type of document you need.<\/p>\n<\/section>\n<section id=\"cap-nhat-2026\" class=\"template-section\" aria-labelledby=\"cap-nhat-2026-heading\">\n<h2 id=\"cap-nhat-2026-heading\"><span class=\"ez-toc-section\" id=\"4_Khi_dung_bang_luong_nam_2026_can_kiem_tra_nhung_gi_da_thay_doi\"><\/span>4. When using the 2026 payroll system, what changes need to be checked?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A file with the correct formula can still produce incorrect results if outdated parameters are used. Before each important payroll period, it&#039;s advisable to check the milestones below instead of just looking at the file name containing &quot;2026&quot;.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"41_Muc_luong_toi_thieu_vung_tu_01012026\"><\/span>4.1. Regional minimum wage effective from January 1, 2026<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Decree 293\/2025\/ND-CP, effective from January 1, 2026, stipulates both minimum monthly and hourly wages. For businesses with part-time, shift-based, or daily wage employees, the minimum hourly wage is a particularly useful benchmark.<\/p>\n<div class=\"bizzi-table-wrap\" tabindex=\"0\" role=\"region\" aria-label=\"Regional minimum wage levels 2026\">\n<table>\n<caption>Minimum wage effective from January 1, 2026.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Region<\/th>\n<th scope=\"col\">Monthly amount<\/th>\n<th scope=\"col\">Hour<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th scope=\"row\">I<\/th>\n<td>5,310,000 VND\/month<\/td>\n<td>25,500 VND\/hour<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">II<\/th>\n<td>4,730,000 VND\/month<\/td>\n<td>22,700 VND\/hour<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">III<\/th>\n<td>4,140,000 VND\/month<\/td>\n<td>20,000 VND\/hour<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">son-in-law<\/th>\n<td>3,700,000 VND\/month<\/td>\n<td>17,800 VND\/hour<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The applicable area is determined by the employer&#039;s operating location. If the business has multiple units\/branches in different regions, it is advisable to check the area for each unit instead of assigning a single rate to the entire company.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"42_Khong_lay_%E2%80%9Cluong_co_ban%E2%80%9D_lam_can_cu_dong_BHXH_mot_cach_may_moc\"><\/span>4.2. Do not mechanically use &quot;basic salary&quot; as the basis for social insurance contributions.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For employees whose salaries are determined by the employer, the salary used as the basis for mandatory social insurance contributions includes the salary based on the job or position, salary allowances, and other supplementary payments that are agreed upon and paid regularly and stably in each pay period. Therefore, when designing the file, a separate column should be included to define this. <strong>Salary used as the basis for social insurance contributions.<\/strong> According to the records of each personnel group.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"43_Thue_TNCN_nam_2026_muc_giam_tru_moi_va_bieu_thue_5_bac\"><\/span>4.3. Personal Income Tax in 2026: New Deduction Levels and 5-Tier Tax Schedule<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For income from salaries and wages of resident individuals, the new regulations apply from the tax year 2026. The deduction for the taxpayer themselves is... <strong>15.5 million VND\/month<\/strong>; Each dependent is <strong>6.2 million VND\/month<\/strong>. The progressive tariff system has also been reduced from 7 tiers to 5 tiers.<\/p>\n<div class=\"bizzi-table-wrap\" tabindex=\"0\" role=\"region\" aria-label=\"Personal Income Tax Rate Table (5 tiers) 2026\">\n<table>\n<caption>Progressive tax rate schedule for taxable income on a monthly basis.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Level<\/th>\n<th scope=\"col\">Taxable income\/month<\/th>\n<th scope=\"col\">Tax rate<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Up to 10 million VND<\/td>\n<td>5%<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Between 10 and 30 million VND<\/td>\n<td>10%<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Between 30 and 60 million VND<\/td>\n<td>20%<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Over 60 to 100 million VND<\/td>\n<td>30%<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Over 100 million VND<\/td>\n<td>35%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>If you need to check the personal deductions and their validity separately, Bizzi has a document page on that topic. <a href=\"https:\/\/bizzi.vn\/tai-lieu\/nghi-quyet-110-2025-ubtvqh15\/\">Resolution 110\/2025\/UBTVQH15 on personal allowance deductions<\/a>. This link is suitable for legal reference; there&#039;s no need to repeat the entire tax content in the payroll article.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"44_Khong_dua_%E2%80%9Cphat_tien%E2%80%9D_vao_bang_luong_nhu_mot_khoan_khau_tru_mac_dinh\"><\/span>4.4. Do not include &quot;fines&quot; in payroll as a default deduction.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When employees are late, violate company rules, or incur financial liability, you shouldn&#039;t create a &quot;penalty&quot; column and deduct directly based solely on internal regulations. Labor law prohibits using fines or salary cuts as a substitute for disciplinary action; salary deductions must be justified and adhere to applicable limits. In the file, a safer column name would be... <strong>\u201c&quot;Other legitimate deductions&quot;\u201d<\/strong> and only enter if the actual records allow it.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"45_Khoan_thanh_toan_luong_tu_5_trieu_donglan_va_chung_tu_khong_dung_tien_mat\"><\/span>4.5. Salary payments of 5 million VND or more per payment, with non-cash payment documents.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In the Corporate Income Tax filing section, the Ministry of Finance is providing guidance: for individual salary and wage payments from... <strong>5 million VND or more<\/strong> Since Decree 320\/2025\/ND-CP came into effect, businesses need non-cash payment documents to meet the conditions for deductible expenses. Therefore, after finalizing the payroll, accountants should further check the list\/payment documents instead of considering creating the Excel file as the final step.<\/p>\n<aside class=\"bizzi-callout\">If a company is simultaneously revising its salary calculation methods, KPIs, bonuses, and approval authority, it&#039;s advisable to agree on those principles beforehand. <a href=\"https:\/\/bizzi.vn\/tai-lieu\/quy-che-luong-thuong-2026-ban-mau-cap-nhat-luat-moi-nhat\/\">Salary and bonus regulations 2026<\/a>. Monthly payroll records will be easier to audit when all income can be traced back to a single, established record.<\/aside>\n<\/section>\n<section id=\"cach-lap\" class=\"template-section\" aria-labelledby=\"cach-lap-heading\">\n<h2 id=\"cach-lap-heading\"><span class=\"ez-toc-section\" id=\"5_Cach_lap_bang_luong_di_tu_du_lieu_nguon_den_so_thuc_nhan\"><\/span>5. How to create a payroll table: starting from source data to actual received amount<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When a file contains many formulas, the easiest way to check is to follow the business logic flow. Don&#039;t start with the &quot;Net&quot; cell; start with the data that generates revenue.<\/p>\n<ol class=\"bizzi-steps\">\n<li><strong>Lock the employee list and payroll records.<\/strong><br \/>\nRecord new hires, resignations, unpaid leave, job title changes, or contract changes during the period.<\/li>\n<li><strong>Lock job data.<\/strong><br \/>\nFor time-based wages, verify working days\/hours; for piece-rate or contract wages, verify the accepted volume; for sales, finalize sales figures and KPIs before calculating commission.<\/li>\n<li><strong>Calculate income components according to the approved policy.<\/strong><br \/>\nSeparate fixed salary, allowances, commissions, bonuses, overtime pay, or other payments to make it easier to verify their source.<\/li>\n<li><strong>Determine the insurance basis and tax data.<\/strong><br \/>\nIt is not assumed that the entirety of total income is the basis for social insurance contributions or that all income is taxed in the same way.<\/li>\n<li><strong>Calculate advances, deductions based on evidence, and the actual amount received.<\/strong><br \/>\nIf the Net number changes unusually compared to the previous month, it&#039;s better to compare each group of changes instead of directly editing the result cell.<\/li>\n<li><strong>Compare payment records.<\/strong><br \/>\nReview the approved payroll, payslips, transfer\/payment voucher lists, and save the final version.<\/li>\n<\/ol>\n<p>For businesses that pay employees based on time, input data typically begins with timekeeping. If normalization at this stage is needed, address it accordingly. <a href=\"https:\/\/bizzi.vn\/mau-bang-cham-cong\/\">Time sheet templates and how to control employee data.<\/a> Then, transfer the number of days\/hours to the payroll. This is a direct upstream link, not an additional document to read just to complete the process.<\/p>\n<div class=\"formula-box\" aria-label=\"Payroll data flow\"><strong>The inspection flow should be maintained:<\/strong><br \/>\n<code>Job data \u2192 Income components \u2192 Insurance\/deductions \u2192 Taxable income \u2192 Personal income tax \u2192 Legal advances\/deductions \u2192 Actual payment \u2192 Payment voucher<\/code><\/div>\n<\/section>\n<section id=\"tinh-huong\" class=\"template-section\" aria-labelledby=\"tinh-huong-heading\">\n<h2 id=\"tinh-huong-heading\"><span class=\"ez-toc-section\" id=\"6_Ba_tinh_huong_khien_bang_luong_de_dung_cong_thuc_nhung_sai_nghiep_vu\"><\/span>6. Three situations where payroll calculations are likely to follow the correct formula but are technically incorrect.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"bizzi-decision-grid\">\n<article class=\"bizzi-decision-card\">\n<h3><span class=\"ez-toc-section\" id=\"Nhan_vien_vao_hoac_nghi_giua_thang\"><\/span>Employees may start or leave mid-month.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Don&#039;t just divide your monthly salary by 26 and multiply by the number of working days if your company&#039;s payroll policy doesn&#039;t use that method. First, you need to determine the working period, standard working days, paid\/unpaid days off, and the calculation principles for months with incomplete working periods.<\/p>\n<\/article>\n<article class=\"bizzi-decision-card\">\n<h3><span class=\"ez-toc-section\" id=\"Nhan_vien_theo_gio_ca_dem_hoac_lam_them\"><\/span>Hourly, night shift, or overtime staff<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A single coefficient should not be locked into a file and used for all shifts. It&#039;s necessary to define which hours are regular hours, which are night\/overtime hours, and which unit price applies to each specific case. Therefore, the new hour\/shift template should have separate input fields for these unit prices.<\/p>\n<\/article>\n<article class=\"bizzi-decision-card\">\n<h3><span class=\"ez-toc-section\" id=\"Luong_sales_san_pham_hoac_cong_trinh\"><\/span>Sales commission, per product or per project.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When income fluctuates based on results, it&#039;s crucial to retain the original data: sales figures, production output, acceptance reports, or contracted quantities. A payroll record with a reasonable total amount but lacking traceability back to its source will be difficult to reconcile during complaints or audits.<\/p>\n<\/article>\n<\/div>\n<\/section>\n<section id=\"checklist\" class=\"template-section\" aria-labelledby=\"checklist-heading\">\n<h2 id=\"checklist-heading\"><span class=\"ez-toc-section\" id=\"7_Checklist_truoc_khi_duyet_va_thanh_toan_bang_luong\"><\/span>7. Checklist before reviewing and paying payroll.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul class=\"bizzi-checklist\">\n<li>The list of personnel accurately reflects their employment status during the period.<\/li>\n<li>Workdays, working hours, KPIs, sales, or volume have been confirmed.<\/li>\n<li>Income is based on a contract, regulation, or related decision.<\/li>\n<li>The salary for the job\/position has been checked against the appropriate regional minimum wage.<\/li>\n<li>The salary used as the basis for social insurance contributions is determined separately according to the records.<\/li>\n<li>The personal allowance and personal income tax rates used were correct for the 2026 tax period.<\/li>\n<li>Do not use &quot;fines&quot; or &quot;salary cuts&quot; as a form of disciplinary action.<\/li>\n<li>Individual payslips match the consolidated payroll statement.<\/li>\n<li>Expenditures of 5 million VND or more per transaction are subject to verification of payment documents when considering corporate income tax eligibility.<\/li>\n<li>The final file contains locked important formulas, access permissions, and versioning.<\/li>\n<\/ul>\n<\/section>\n<section id=\"excel-hay-he-thong\" class=\"template-section\" aria-labelledby=\"excel-hay-he-thong-heading\">\n<h2 id=\"excel-hay-he-thong-heading\"><span class=\"ez-toc-section\" id=\"8_Khi_nao_Excel_van_du_khi_nao_nen_danh_gia_he_thong_payroll\"><\/span>8. When is Excel sufficient, and when should the payroll system be evaluated?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There&#039;s no fixed number of employees to say, &quot;If you have more than X people, you have to abandon Excel.&quot; The deciding factor often lies in the complexity of the data and the ability to manage it, not just the headcount.<\/p>\n<div class=\"bizzi-table-wrap\" tabindex=\"0\" role=\"region\" aria-label=\"Comparison between using Excel and having a payroll system.\">\n<table>\n<caption>Evaluate based on how the business is currently operating.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Excel is still relevant when<\/th>\n<th scope=\"col\">Specialized payroll should be evaluated when<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>The input data comes from few sources and there is someone responsible for locking the data.<\/td>\n<td>Working days, shifts, KPIs, commissions, and policies come from multiple systems\/departments.<\/td>\n<\/tr>\n<tr>\n<td>The formula is relatively stable and can be tested before each period.<\/td>\n<td>Many groups of employees use different calculation rules, which change frequently.<\/td>\n<\/tr>\n<tr>\n<td>The file is subject to permission management, version control, and independent review.<\/td>\n<td>With multiple people editing simultaneously, it&#039;s difficult to trace who changed the formula or data.<\/td>\n<\/tr>\n<tr>\n<td>The volume of manual reconciliation remains at an acceptable level.<\/td>\n<td>Accountants\/HR staff spend a significant amount of time piecing together data and correcting discrepancies between sources.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>If the real need is payroll, then a suitable payroll\/HR system should be evaluated. One shouldn&#039;t choose expense management software and expect it to replace timekeeping and payroll.<\/p>\n<\/section>\n<section id=\"bizzi\" class=\"template-section\" aria-labelledby=\"bizzi-heading\">\n<h2 id=\"bizzi-heading\"><span class=\"ez-toc-section\" id=\"9_Bizzi_phu_hop_o_dau_sau_khi_bang_luong_da_duoc_xu_ly\"><\/span>9. Where does Bizzi fit in after the payroll has been processed?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"bizzi-cta\">\n<h3><span class=\"ez-toc-section\" id=\"Payroll_va_chi_phi_nhan_vien_la_hai_lop_khac_nhau\"><\/span>Payroll and employee costs are two different categories.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Bizzi is not a replacement for timekeeping systems or payroll software.<\/strong> After processing payroll, Finance still has another group of tasks to handle, such as business expenses, expense requests, advances, payments from company funds, and invoice\/receipt reconciliation.<\/p>\n<p>With this cost level, <a class=\"bizzi-button\" href=\"https:\/\/bizzi.vn\/he-thong-quan-ly-chi-phi-va-thanh-toan\/\">Bizzi Expense Pay expense management and payment system<\/a> It supports the workflow from request, approval, payment to document reconciliation. Therefore, the product link only appears here \u2013 after the article has completed its main task of selecting and using a payroll template.<\/p>\n<\/div>\n<\/section>\n<section id=\"faq\" class=\"template-section bizzi-faq\" aria-labelledby=\"faq-heading\">\n<h2 id=\"faq-heading\"><span class=\"ez-toc-section\" id=\"10_Cau_hoi_thuong_gap_ve_mau_bang_luong_nhan_vien\"><\/span>10. Frequently Asked Questions about Employee Payroll Templates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<details>\n<summary>Is it mandatory for Excel 2026 payroll templates to follow a single format?<\/summary>\n<div class=\"faq-answer\">\n<p>No. Internal payroll files can be designed to suit the company&#039;s payroll and control methods. However, payroll data, insurance, taxes, deductions, and related accounting documents must still be defined according to applicable regulations and records.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Does Form 01-L\u0110TL under Circular 99 replace the detailed payroll calculation sheet?<\/summary>\n<div class=\"faq-answer\">\n<p>Not necessarily. Form 01-L\u0110TL is the payroll payment sheet in the accounting document system. Businesses may still need the detailed spreadsheet from the previous step to process working days, output, commissions, insurance, or taxes before consolidating them into the payment document.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Is it mandatory for businesses to use a standard 26-day work week?<\/summary>\n<div class=\"faq-answer\">\n<p>No. The standard number of days or hours required for work schedules and payroll is already defined. Therefore, files should use the standard number of days\/hours as configuration data instead of locking in a specific number for every business.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Does the hourly\/shift payment model automatically calculate overtime and night shift pay?<\/summary>\n<div class=\"faq-answer\">\n<p>The new template automatically multiplies the number of hours by the user-entered unit price, but does not automatically apply a single legal coefficient to all cases. Before entering the unit price, businesses need to determine the type of hours and the appropriate payment rate based on the work schedule, agreements, and applicable regulations.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Can the construction worker model be used for piece-rate pay?<\/summary>\n<div class=\"faq-answer\">\n<p>Yes. The file has separate sheets for quantities\/contracts and a summary sheet for each project. When using it, you should enter the confirmed quantities, contract unit prices, and converted hours\/days according to the actual records to check the payment amount.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Are freelancers always exempt from paying insurance contributions?<\/summary>\n<div class=\"faq-answer\">\n<p>One should not draw conclusions solely from the term &quot;collaborator.&quot; The nature of the relationship, the type of contract, and the participants, as defined by applicable regulations, must be considered. Therefore, the collaborator model should not rigidly define a single insurance claim processing method for all cases.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Is it permissible to deduct money from an employee&#039;s salary for being late or violating company rules?<\/summary>\n<div class=\"faq-answer\">\n<p>Fines or salary deductions should not be used as a substitute for labor disciplinary action. If there is another deduction, the basis, scope, and limits of the deduction must be properly determined before being included in the payroll.<\/p>\n<\/div>\n<\/details>\n<details>\n<summary>Does paying salaries in cash of 5 million VND or more affect the deductibility of expenses?<\/summary>\n<div class=\"faq-answer\">\n<p>Labor regulations regarding the form of salary payment need to be separated from the conditions for corporate income tax filing. According to the current guidance of the Ministry of Finance, salary\/wage payments of 5 million VND or more require non-cash payment documentation to meet the conditions for deductible expenses.<\/p>\n<\/div>\n<\/details>\n<\/section>\n<section class=\"template-section legal-sources\" aria-labelledby=\"legal-sources-heading\">\n<h2 id=\"legal-sources-heading\"><span class=\"ez-toc-section\" id=\"Nguon_phap_ly_tham_chieu\"><\/span>Referenced legal sources<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/xaydungchinhsach.chinhphu.vn\/nghi-dinh-so-293-2025-nd-cp-quy-dinh-muc-luong-toi-thieu-doi-voi-nguoi-lao-dong-lam-viec-theo-hop-dong-lao-dong-119251110172808433.htm\" rel=\"nofollow noopener\" target=\"_blank\">Decree 293\/2025\/ND-CP on minimum wage levels effective from January 1, 2026<\/a>.<\/li>\n<li><a href=\"https:\/\/baohiemxahoi.gov.vn\/tintuc\/Pages\/hoat-dong-he-thong-bao-hiem-xa-hoi.aspx?CateID=0&amp;ItemID=23352\" rel=\"nofollow noopener\" target=\"_blank\">Vietnam Social Security: Social Insurance Law 2024 and salary as the basis for mandatory social insurance contributions.<\/a>.<\/li>\n<li><a href=\"https:\/\/nief.mof.gov.vn\/tin-tuc\/noi-dung-chinh-cua-luat-thue-thu-nhap-ca-nhan-so-109-2025-qh15-11929.html\" rel=\"nofollow noopener\" target=\"_blank\">Ministry of Finance: Main contents of the Personal Income Tax Law 109\/2025\/QH15<\/a>.<\/li>\n<li><a href=\"https:\/\/congbao.chinhphu.vn\/van-ban\/thong-tu-so-99-2025-tt-btc-46529.htm\" rel=\"nofollow noopener\" target=\"_blank\">Circular 99\/2025\/TT-BTC guiding the Enterprise Accounting Regime<\/a>.<\/li>\n<li><a href=\"https:\/\/vanban.chinhphu.vn\/?classid=2629&amp;docid=217002&amp;pageid=27160\" rel=\"nofollow noopener\" target=\"_blank\">Consolidated text 18\/VBHN-VPQH of 2026 \u2013 Labor Code<\/a>.<\/li>\n<li><a href=\"https:\/\/portal.mof.gov.vn\/hoidapcstc\/home\/cthoidap\/159434\" rel=\"nofollow noopener\" target=\"_blank\">Ministry of Finance: Non-cash payment documents are required for salary payments of 5 million VND or more per transaction.<\/a>.<\/li>\n<\/ul>\n<p class=\"template-update-note\">The information is up to August 14, 2026. When applying this to actual cases, businesses need to check the validity, scope of application, and relevant industry guidelines at the time of application.<\/p>\n<\/section>\n<\/article>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>The document set below includes 12 payroll and salary payment templates for businesses to download, categorized by salary payment method: according to\u2026<\/p>","protected":false},"author":37,"featured_media":999978954,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[263,84],"tags":[],"class_list":["post-999978552","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc","category-thiet-lap"],"acf":[],"_links":{"self":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/comments?post=999978552"}],"version-history":[{"count":9,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978552\/revisions"}],"predecessor-version":[{"id":999982081,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978552\/revisions\/999982081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media\/999978954"}],"wp:attachment":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media?parent=999978552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/categories?post=999978552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/tags?post=999978552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}