{"id":999973750,"date":"2025-05-22T22:28:32","date_gmt":"2025-05-22T15:28:32","guid":{"rendered":"https:\/\/bizzi.vn\/?p=999973750"},"modified":"2026-08-11T12:56:15","modified_gmt":"2026-08-11T05:56:15","slug":"download-the-reverse-license-plate","status":"publish","type":"post","link":"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/","title":{"rendered":"Download the latest debt reconciliation form Word, Excel file"},"content":{"rendered":"<article class=\"bizzi-template-page\" aria-label=\"Word and Excel 2026 Debt Reconciliation Form\">\n<div class=\"template-sapo\">\n<p><strong>Debt reconciliation form<\/strong> This helps businesses and partners compare accounts receivable and accounts payable at a given time, identify discrepancies, and agree on the balances to be monitored. For signing confirmations, a Word file is more suitable; for checking multiple invoices and documents and calculating balances manually, an Excel file is more convenient.<\/p>\n<p>Bizzi has prepared a 2026 model collection including <strong>editable Word file<\/strong> and <strong>Excel file with formulas<\/strong>, and also provide usage instructions to customers and suppliers, and conduct year-end reconciliation.<\/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\/download-the-reverse-license-plate\/#1_Tai_mau_bien_ban_doi_chieu_cong_no_Word_Excel_2026\" >1. Download Word and Excel 2026 debt reconciliation statement templates.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#11_Mau_bien_ban_doi_chieu_cong_no_file_Word\" >1.1. Sample debt reconciliation statement (Word file)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#12_Mau_doi_chieu_cong_no_Excel_co_cong_thuc\" >1.2. Excel debt reconciliation template with formulas<\/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\/download-the-reverse-license-plate\/#13_Debt_Reconciliation_Minutes_template_in_English\" >1.3. Debt Reconciliation Minutes template in English<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#2_Bien_ban_doi_chieu_cong_no_la_gi\" >2. What is a debt reconciliation statement?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#21_Phan_biet_doi_chieu_xac_nhan_can_tru_va_ban_giao_cong_no\" >2.1. Distinguishing, reconciling, confirming, offsetting, and transferring accounts payable.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#3_Mau_bien_ban_doi_chieu_cong_no_nen_co_nhung_noi_dung_nao\" >3. What information should a debt reconciliation statement template include?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#4_Cach_lap_bien_ban_doi_chieu_cong_no\" >4. How to prepare a debt reconciliation statement<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#Chuan_bi_du_lieu_cong_no\" >Prepare accounts receivable data.<\/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\/download-the-reverse-license-plate\/#Doi_chieu_chung_tu_nguon\" >Compare source documents<\/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\/download-the-reverse-license-plate\/#So_sanh_so_lieu_giua_hai_ben\" >Compare the data between the two sides.<\/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\/download-the-reverse-license-plate\/#Xac_dinh_nguyen_nhan_chenh_lech\" >Identify the cause of the discrepancy.<\/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\/download-the-reverse-license-plate\/#Thong_nhat_so_du_va_phuong_an_xu_ly\" >Agree on the balance and handling plan.<\/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\/download-the-reverse-license-plate\/#Xac_nhan_va_luu_ho_so\" >Confirm and save the record.<\/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\/download-the-reverse-license-plate\/#5_Cach_xu_ly_khi_so_lieu_cong_no_giua_hai_ben_khong_khop\" >5. How to handle discrepancies in accounts receivable\/payable between two parties.<\/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\/download-the-reverse-license-plate\/#6_Doi_chieu_cong_no_khach_hang_va_nha_cung_cap_khac_nhau_the_nao\" >6. How do you reconcile accounts payable and accounts receivable from different suppliers?<\/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\/download-the-reverse-license-plate\/#61_Bien_ban_doi_chieu_cong_no_khach_hang\" >6.1. Customer Accounts Reconciliation Report<\/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\/download-the-reverse-license-plate\/#62_Bien_ban_doi_chieu_cong_no_nha_cung_cap\" >6.2. Supplier Accounts Reconciliation Report<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#7_Mau_bien_ban_doi_chieu_cong_no_cuoi_nam_can_chot_nhung_gi\" >7. Sample year-end accounts receivable reconciliation statement: what needs to be finalized?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#8_Bien_ban_doi_chieu_cong_no_co_bat_buoc_khong_Co_can_ky_dong_dau\" >8. Is a debt reconciliation statement mandatory? Does it need to be signed and stamped?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#81_Co_mau_bat_buoc_theo_phap_luat_khong\" >8.1. Is there a legally mandated template?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#82_Ai_nen_ky_bien_ban\" >8.2. Who should sign the minutes?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#83_Bien_ban_dien_tu_co_the_ky_so_khong\" >8.3. Can electronic minutes be digitally signed?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#9_Nhung_loi_thuong_gap_khi_lap_bien_ban_doi_chieu_cong_no\" >9. Common mistakes when preparing accounts receivable reconciliation statements<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#10_Khi_nao_Excel_khong_con_du_de_quan_ly_cong_no\" >10. When is Excel no longer sufficient for managing accounts receivable?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#11_Bizzi_ho_tro_quan_ly_va_doi_soat_cong_no_o_buoc_nao\" >11. At which stage does Bizzi assist in managing and reconciling accounts receivable?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/bizzi.vn\/en\/download-the-reverse-license-plate\/#Quan_ly_cong_no_tap_trung_khi_so_luong_giao_dich_tang\" >Centralized accounts receivable management is necessary as the number of transactions increases.<\/a><\/li><\/ul><\/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\/download-the-reverse-license-plate\/#12_Cau_hoi_thuong_gap_ve_bien_ban_doi_chieu_cong_no\" >12. Frequently Asked Questions about Accounts Reconciliation Statements<\/a><\/li><\/ul><\/nav><\/div>\n\n<\/div>\n<section class=\"template-section\" id=\"tai-mau\">\n<h2><span class=\"ez-toc-section\" id=\"1_Tai_mau_bien_ban_doi_chieu_cong_no_Word_Excel_2026\"><\/span>1. Download Word and Excel 2026 debt reconciliation statement templates.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"template-download-grid\">\n<section class=\"template-card\">\n<div class=\"template-card-body\">\n          <span class=\"bizzi-badge\">Word 2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Mau_bien_ban_doi_chieu_cong_no_file_Word\"><\/span>1.1. Sample debt reconciliation statement (Word file)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Suitable for sending a memorandum to a partner for verification, signature confirmation, or inclusion in accounts receivable records. The template includes information on both parties, a transaction table, beginning and ending balances, differences, and proposed solutions.<\/p>\n<p class=\"template-download\">\n            <a class=\"bizzi-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2026\/08\/mau-bien-ban-doi-chieu-cong-no-2026.docx\" download>Download Word 2026 templates<\/a>\n          <\/p>\n<\/div>\n<\/section>\n<section class=\"template-card\">\n<div class=\"template-card-body\">\n          <span class=\"bizzi-badge\">Excel 2026<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Mau_doi_chieu_cong_no_Excel_co_cong_thuc\"><\/span>1.2. Excel debt reconciliation template with formulas<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The workbook consists of 3 sheets: user guide, detailed reconciliation table, and summary report. The file automatically calculates the balance and difference between the two parties and supports marking the status as &quot;Matched,&quot; &quot;Pending Verification,&quot; or &quot;Adjusted.&quot;.<\/p>\n<p class=\"template-download\">\n            <a class=\"bizzi-button\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2026\/08\/mau-doi-chieu-cong-no-2026.xlsx\" download>Download Excel 2026 template<\/a>\n          <\/p>\n<\/div>\n<\/section>\n<section class=\"template-card\">\n<div class=\"template-card-body\">\n          <span class=\"bizzi-badge\">English<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"13_Debt_Reconciliation_Minutes_template_in_English\"><\/span>1.3. Debt Reconciliation Minutes template in English<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is used when a business needs to send a reconciliation statement to a partner in English. Before signing, the terminology, currency, and transaction information need to be adjusted to match the actual contract.<\/p>\n<p class=\"template-download\">\n            <a class=\"bizzi-button bizzi-button-secondary\" href=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/05\/mau-bien-ban-doi-chieu-cong-no-tieng-anh.docx\" download>Download English sample<\/a>\n          <\/p>\n<\/div>\n<\/section><\/div>\n<div class=\"bizzi-table-wrap\" role=\"region\" aria-label=\"Select the appropriate accounts receivable reconciliation file.\" tabindex=\"0\">\n<table>\n<caption>Should I use Word or Excel?<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Demand<\/th>\n<th scope=\"col\">Suitable file<\/th>\n<th scope=\"col\">Use<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Send to partner for signature confirmation<\/td>\n<td>Word<\/td>\n<td>Fill in the verified data, adjust the confirmation section and signatory according to actual authority.<\/td>\n<\/tr>\n<tr>\n<td>Compare multiple invoices\/documents.<\/td>\n<td>Excel<\/td>\n<td>Enter each transaction, counterparty data, and track the difference.<\/td>\n<\/tr>\n<tr>\n<td>Reconcile customer accounts receivable.<\/td>\n<td>Excel \u2192 Word<\/td>\n<td>Check accounts receivable in Excel, then summarize the balances to create a report in Word.<\/td>\n<\/tr>\n<tr>\n<td>Reconcile accounts payable with suppliers.<\/td>\n<td>Excel \u2192 Word<\/td>\n<td>Change the debt type to &quot;Accounts Payable&quot;, reconcile invoices, and make payments before confirmation.<\/td>\n<\/tr>\n<tr>\n<td>Finalize accounts receivable at the end of the year.<\/td>\n<td>Excel + Word<\/td>\n<td>Finalize the balances as of December 31st, process any discrepancies, and prepare a final confirmation report.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<aside class=\"bizzi-callout\">\n<p><strong>Note:<\/strong> The above files are sample files compiled by Bizzi for operational support. Current legislation does not mandate a standard sample reconciliation statement for all businesses and transactions.<\/p>\n<\/aside>\n<\/section>\n<section class=\"template-section\" id=\"bien-ban-la-gi\">\n<h2><span class=\"ez-toc-section\" id=\"2_Bien_ban_doi_chieu_cong_no_la_gi\"><\/span>2. What is a debt reconciliation statement?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A debt reconciliation statement is a document recording the results of comparing debt figures between two parties at a specific point in time. The data is typically reconciled from accounting records, invoices, contracts, payment vouchers, delivery or acceptance records, and related deductions.<\/p>\n<p>The goal of reconciliation is not only to determine &quot;how much is still owed,&quot; but also to clarify... <strong>Beginning balance, transactions during the period, amounts paid or deducted, ending balance, and the reason for any difference, if any.<\/strong>.<\/p>\n<figure class=\"bizzi-image\">\n      <img loading=\"lazy\"\n        src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/05\/01-bien-ban-doi-chieu-cong-no-tieng-viet.jpg\"\n        alt=\"Sample Vietnamese debt reconciliation statement between a business and its partners.\"\n        title=\"Debt reconciliation form\"\n        aria-describedby=\"caption-bien-ban-doi-chieu-cong-no\"\n        width=\"621\"\n        height=\"612\"\n        decoding=\"async\"\n      ><figcaption id=\"caption-bien-ban-doi-chieu-cong-no\">For example, the layout of a debt reconciliation statement includes information from both parties, details of transactions, and a section for confirming the balance.<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"21_Phan_biet_doi_chieu_xac_nhan_can_tru_va_ban_giao_cong_no\"><\/span>2.1. Distinguishing, reconciling, confirming, offsetting, and transferring accounts payable.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"bizzi-table-wrap\" role=\"region\" aria-label=\"Distinguishing between different types of accounts receivable\/payable records.\" tabindex=\"0\">\n<table>\n<thead>\n<tr>\n<th scope=\"col\">Document<\/th>\n<th scope=\"col\">Main purpose<\/th>\n<th scope=\"col\">When to use<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Debt reconciliation minutes<\/strong><\/td>\n<td>Compare the data and identify the differences between the two sides.<\/td>\n<td>Periodically, at the end of the period, before closing the balance, or when discrepancies arise.<\/td>\n<\/tr>\n<tr>\n<td><strong>Debt confirmation minutes<\/strong><\/td>\n<td>Confirmation of agreed-upon balances\/debt obligations between the parties.<\/td>\n<td>When proof is needed to confirm the amount of money still to be collected or paid.<\/td>\n<\/tr>\n<tr>\n<td><strong>Minutes of debt offsetting\/counter-offering<\/strong><\/td>\n<td>Record the offsetting of receivables and payables as agreed.<\/td>\n<td>When two or more parties have obligations that are offset against each other.<\/td>\n<\/tr>\n<tr>\n<td><strong>Minutes of debt handover<\/strong><\/td>\n<td>Delegating responsibility for monitoring accounts receivable records and status.<\/td>\n<td>When there are changes in personnel, departments, or the person in charge.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>If the goal is to confirm the balance rather than reconcile details, you can use... <a href=\"https:\/\/bizzi.vn\/tai-mau-bien-ban-xac-nhan-cong-no-mien-phi-moi-nhat-2025\/\">Sample debt confirmation form<\/a>. In case of needing to offset obligations between parties, please refer to... <a href=\"https:\/\/bizzi.vn\/mau-bien-ban-can-tru-cong-no\/\">debt offset form<\/a>.<\/p>\n<\/section>\n<section class=\"template-section\" id=\"noi-dung\">\n<h2><span class=\"ez-toc-section\" id=\"3_Mau_bien_ban_doi_chieu_cong_no_nen_co_nhung_noi_dung_nao\"><\/span>3. What information should a debt reconciliation statement template include?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There is no single legally binding form that applies to all transactions. However, to ensure the record is easily verifiable and valid for use in business records, it should include all of the following information groups.<\/p>\n<div class=\"bizzi-table-wrap\" role=\"region\" aria-label=\"Contents of the debt reconciliation report\" tabindex=\"0\">\n<table>\n<caption>Suggested information structure<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Group<\/th>\n<th scope=\"col\">Content<\/th>\n<th scope=\"col\">Points to check<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Information from both sides<\/td>\n<td>Name of the entity, tax identification number, address, representative\/authorized person.<\/td>\n<td>Matches the contract and transaction records.<\/td>\n<\/tr>\n<tr>\n<td>Time of comparison<\/td>\n<td>Date of record keeping, date of balance closing, reconciliation period.<\/td>\n<td>Distinguish between the data creation date and the data closing date.<\/td>\n<\/tr>\n<tr>\n<td>Opening balance<\/td>\n<td>The amount of debt carried over from the previous period.<\/td>\n<td>Match the previously confirmed balance or closed balance.<\/td>\n<\/tr>\n<tr>\n<td>Increase in occurrence<\/td>\n<td>Invoices, supporting documents, quantities accepted, or arising obligations.<\/td>\n<td>Check the document number, date, and value.<\/td>\n<\/tr>\n<tr>\n<td>Payment\/Deduction<\/td>\n<td>Amounts paid, received, discounts, returns, or offsets.<\/td>\n<td>Compare the bank statement and related documents.<\/td>\n<\/tr>\n<tr>\n<td>Closing balance<\/td>\n<td>The remaining amount will be monitored by both parties after reconciliation.<\/td>\n<td>Specify the figures for each side if there are any discrepancies.<\/td>\n<\/tr>\n<tr>\n<td>Difference<\/td>\n<td>Amount, cause, and proposed solution.<\/td>\n<td>Don&#039;t force a match when the documents are not yet complete.<\/td>\n<\/tr>\n<tr>\n<td>Confirm<\/td>\n<td>The competent\/authorized person shall provide confirmation in an appropriate manner.<\/td>\n<td>Verify the signing authority and internal procedures of the parties involved.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/section>\n<section class=\"template-section\" id=\"cach-lap\">\n<h2><span class=\"ez-toc-section\" id=\"4_Cach_lap_bien_ban_doi_chieu_cong_no\"><\/span>4. How to prepare a debt reconciliation statement<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol class=\"bizzi-steps\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Chuan_bi_du_lieu_cong_no\"><\/span>Prepare accounts receivable data.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Extract balances and transactions according to the correct partner, reconciliation period, and type of debt. With Excel data, each row should correspond to a single transaction or document.<\/p>\n<\/li>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Doi_chieu_chung_tu_nguon\"><\/span>Compare source documents<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Review invoices, contracts, payment documents, delivery\/acceptance records, deductions, and related adjustments.<\/p>\n<\/li>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"So_sanh_so_lieu_giua_hai_ben\"><\/span>Compare the data between the two sides.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Include partner data in the same table to identify which items match, which are out of order, and which lack sufficient documentation.<\/p>\n<\/li>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_nguyen_nhan_chenh_lech\"><\/span>Identify the cause of the discrepancy.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Adjustments should not be made simply to ensure both parties have the same balance. It is necessary to identify unrecorded transactions, duplicate entries, incorrect periods, outstanding payments, returns, or deductions that have not been updated.<\/p>\n<\/li>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Thong_nhat_so_du_va_phuong_an_xu_ly\"><\/span>Agree on the balance and handling plan.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Clearly state the agreed-upon balance; if there is a difference, specify the amount awaiting verification and the deadline for processing.<\/p>\n<\/li>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Xac_nhan_va_luu_ho_so\"><\/span>Confirm and save the record.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Keep records along with detailed data and related documents so that the cause of each outstanding debt can be traced.<\/p>\n<\/li>\n<\/ol>\n<\/section>\n<section class=\"template-section\" id=\"xu-ly-chenh-lech\">\n<h2><span class=\"ez-toc-section\" id=\"5_Cach_xu_ly_khi_so_lieu_cong_no_giua_hai_ben_khong_khop\"><\/span>5. How to handle discrepancies in accounts receivable\/payable between two parties.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"bizzi-table-wrap\" role=\"region\" aria-label=\"Handling accounts payable discrepancies\" tabindex=\"0\">\n<table>\n<caption>Reasons for discrepancies and how to check them.<\/caption>\n<thead>\n<tr>\n<th scope=\"col\">Common causes<\/th>\n<th scope=\"col\">How to check<\/th>\n<th scope=\"col\">Solution<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>One party has issued the invoice, the other has not.<\/td>\n<td>Check the invoice date, the date the document was received, and the accounting period.<\/td>\n<td>Determine the correct period and update it according to actual records.<\/td>\n<\/tr>\n<tr>\n<td>Payment has been made but not yet recorded.<\/td>\n<td>Compare the bank statement, UNC\/credit note, and transaction code.<\/td>\n<td>Record payments or verify transactions that have not yet been reconciled.<\/td>\n<\/tr>\n<tr>\n<td>Duplicate invoices\/documents<\/td>\n<td>Compare invoice numbers, document numbers, values, and transaction dates.<\/td>\n<td>Duplicate records after verification.<\/td>\n<\/tr>\n<tr>\n<td>Returns, discounts, or deductions have not been updated.<\/td>\n<td>Review adjustment documents, agreements, and deduction records.<\/td>\n<td>Update accounts receivable\/payable based on valid supporting documents.<\/td>\n<\/tr>\n<tr>\n<td>Offsetting unrecorded liabilities<\/td>\n<td>Review the offsetting agreement\/record and related obligations.<\/td>\n<td>Record the transaction or update the status once all necessary documents are submitted.<\/td>\n<\/tr>\n<tr>\n<td>Incorrect customer\/supplier code<\/td>\n<td>Verify the accounting object and partner code.<\/td>\n<td>Adjust the correct target before finalizing the balance.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<aside class=\"bizzi-callout\">\n<p>In Bizzi&#039;s Excel 2026 file, the column <strong>\u201c&quot;Balance A&quot;, &quot;Balance B&quot;, &quot;Difference&quot;, &quot;Cause of Difference&quot;, and &quot;Status&quot;\u201d<\/strong> They are placed side-by-side so that accountants don&#039;t have to compare them using two separate sheets.<\/p>\n<\/aside>\n<\/section>\n<section class=\"template-section\" id=\"khach-hang-nha-cung-cap\">\n<h2><span class=\"ez-toc-section\" id=\"6_Doi_chieu_cong_no_khach_hang_va_nha_cung_cap_khac_nhau_the_nao\"><\/span>6. How do you reconcile accounts payable and accounts receivable from different suppliers?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"bizzi-decision-grid\">\n<section class=\"bizzi-decision-card\">\n<h3><span class=\"ez-toc-section\" id=\"61_Bien_ban_doi_chieu_cong_no_khach_hang\"><\/span>6.1. Customer Accounts Reconciliation Report<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The focus is <strong>accounts receivable<\/strong>The invoice should include the amount paid by the customer, deductions, and the remaining amount to be collected. Special attention should be paid to overdue or disputed amounts.<\/p>\n<\/section>\n<section class=\"bizzi-decision-card\">\n<h3><span class=\"ez-toc-section\" id=\"62_Bien_ban_doi_chieu_cong_no_nha_cung_cap\"><\/span>6.2. Supplier Accounts Reconciliation Report<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The focus is <strong>Accounts Payable<\/strong>This includes purchase invoices, amounts paid, advances\/offsets, and outstanding liabilities. A thorough comparison with the payment schedule and bank statements is necessary.<\/p>\n<\/section><\/div>\n<p>To track accounts receivable regularly instead of just finalizing them at the time of recording, you can refer to the following: <a href=\"https:\/\/bizzi.vn\/tai-file-bang-theo-doi-cong-no-bang-excel-mien-phi\/\">Excel file for managing and tracking accounts receivable.<\/a>.<\/p>\n<\/section>\n<section class=\"template-section\" id=\"cuoi-nam\">\n<h2><span class=\"ez-toc-section\" id=\"7_Mau_bien_ban_doi_chieu_cong_no_cuoi_nam_can_chot_nhung_gi\"><\/span>7. Sample year-end accounts receivable reconciliation statement: what needs to be finalized?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Year-end reconciliation is usually performed before or during the closing process to clarify the balances as of December 31st and any remaining discrepancies. It is important not to record only the final balance while ignoring the transactions that led to that balance.<\/p>\n<ul class=\"bizzi-checklist\">\n<li>Verify that the opening balance has been transferred to the correct partner.<\/li>\n<li>Compare all invoices\/documents generated during the year.<\/li>\n<li>Compare the amounts received, paid, and payments awaiting reconciliation.<\/li>\n<li>Check returns, discounts, deductions, offsets, and adjustments.<\/li>\n<li>Determine the balance as of December 31st for each party.<\/li>\n<li>Record any outstanding issues separately instead of making adjustments without justification.<\/li>\n<li>Complete the confirmation and attach the detailed accounts receivable statement.<\/li>\n<\/ul>\n<figure class=\"bizzi-image\">\n      <img loading=\"lazy\"\n        src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/05\/khi-nao-can-doi-chieu-cong-no.jpg\"\n        alt=\"When should businesses conduct periodic and year-end accounts receivable reconciliation?\"\n        title=\"When is it necessary to reconcile accounts payable?\"\n        aria-describedby=\"caption-khi-nao-doi-chieu-cong-no\"\n        width=\"1920\"\n        height=\"1080\"\n        decoding=\"async\"\n      ><figcaption id=\"caption-khi-nao-doi-chieu-cong-no\">Periodic reconciliation helps detect discrepancies early; year-end reconciliation focuses on balances at the closing date and outstanding balances.<\/figcaption><\/figure>\n<\/section>\n<section class=\"template-section\" id=\"phap-ly\">\n<h2><span class=\"ez-toc-section\" id=\"8_Bien_ban_doi_chieu_cong_no_co_bat_buoc_khong_Co_can_ky_dong_dau\"><\/span>8. Is a debt reconciliation statement mandatory? Does it need to be signed and stamped?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"81_Co_mau_bat_buoc_theo_phap_luat_khong\"><\/span>8.1. Is there a legally mandated template?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Currently, there is no single legally mandated template for a debt reconciliation statement that all businesses are required to use. Businesses can develop templates that suit their specific transactions and control systems.<\/p>\n<p><strong>Circular 99\/2025\/TT-BTC<\/strong> Effective from January 1, 2026, this document provides guidance on corporate accounting procedures. However, the Word\/Excel files in this article are sample forms to support data reconciliation and verification, not mandatory accounting forms issued separately under Circular 99.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"82_Ai_nen_ky_bien_ban\"><\/span>8.2. Who should sign the minutes?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To increase its usability as a basis for comparison, the record should be certified by an authorized person or a representative appropriate to the transaction and procedures of each party. It should not be assumed that the absence of a seal automatically renders the record invalid.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"83_Bien_ban_dien_tu_co_the_ky_so_khong\"><\/span>8.3. Can electronic minutes be digitally signed?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The Law on Electronic Transactions 20\/2023\/QH15, effective from July 1, 2024, and Decree 23\/2025\/ND-CP, effective from April 10, 2025, provide the legal framework for electronic signatures and trusted services. When using electronic minutes, businesses need to choose a signing method that is appropriate to the legal conditions and the agreements\/procedures of the parties involved.<\/p>\n<div class=\"bizzi-source-links\">\n<p><a href=\"https:\/\/congbao.chinhphu.vn\/van-ban\/thong-tu-so-99-2025-tt-btc-46529.htm\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Circular 99\/2025\/TT-BTC \u2013 Government Gazette<\/a><\/p>\n<p><a href=\"https:\/\/vanban.chinhphu.vn\/?classid=1&amp;docid=208421&amp;pageid=27160&amp;typegroupid=3\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Law on Electronic Transactions 20\/2023\/QH15<\/a><\/p>\n<p><a href=\"https:\/\/congbao.chinhphu.vn\/van-ban\/nghi-dinh-so-23-2025-nd-cp-44261.htm\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Decree 23\/2025\/ND-CP on electronic signatures and trusted services<\/a><\/p>\n<\/div>\n<\/section>\n<section class=\"template-section\" id=\"loi-thuong-gap\">\n<h2><span class=\"ez-toc-section\" id=\"9_Nhung_loi_thuong_gap_khi_lap_bien_ban_doi_chieu_cong_no\"><\/span>9. Common mistakes when preparing accounts receivable reconciliation statements<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul class=\"bizzi-checklist bizzi-checklist-warning\">\n<li>Only the ending balance is recorded, without a detailed transaction statement.<\/li>\n<li>Using data from a third party without cross-referencing it with the source documents.<\/li>\n<li>Combining the accounts payable of multiple customers\/suppliers into a single document.<\/li>\n<li>Do not record the reason when the balances on both sides are still different.<\/li>\n<li>Incorrectly recording accounts receivable as accounts payable, or vice versa.<\/li>\n<li>Using a signatory who is not in line with the unit&#039;s authority or procedures.<\/li>\n<li>Not saving detailed files makes it difficult to trace back the transaction in the summary report.<\/li>\n<li>Because the reconciliation was only done at the end of the year, the discrepancies were discovered too late.<\/li>\n<\/ul>\n<\/section>\n<section class=\"template-section\" id=\"excel-hay-phan-mem\">\n<h2><span class=\"ez-toc-section\" id=\"10_Khi_nao_Excel_khong_con_du_de_quan_ly_cong_no\"><\/span>10. When is Excel no longer sufficient for managing accounts receivable?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel is suitable when the number of partners and transactions is manageable with just a few files. As the data increases, reconciliation often becomes difficult due to files being held by multiple people, inconsistent recovery status, and payments needing to be traced back against bank statements.<\/p>\n<div class=\"bizzi-table-wrap\" role=\"region\" aria-label=\"Excel and accounts receivable management systems\" tabindex=\"0\">\n<table>\n<thead>\n<tr>\n<th scope=\"col\">Element<\/th>\n<th scope=\"col\">Excel is suitable when<\/th>\n<th scope=\"col\">The system should be considered when<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Mass<\/td>\n<td>Few partners, few transactions.<\/td>\n<td>Multiple invoices, multiple customers, and multiple payment periods.<\/td>\n<\/tr>\n<tr>\n<td>Debt reminder<\/td>\n<td>It can be tracked manually.<\/td>\n<td>You need to remind people by due date or according to a set schedule.<\/td>\n<\/tr>\n<tr>\n<td>Payment reconciliation<\/td>\n<td>The number of bank transactions is low.<\/td>\n<td>There are several payments awaiting reconciliation with the statement.<\/td>\n<\/tr>\n<tr>\n<td>Report<\/td>\n<td>Just the basic balance is needed.<\/td>\n<td>We need DSO, a report on the aging of the debt and its collection status.<\/td>\n<\/tr>\n<tr>\n<td>Combination<\/td>\n<td>One person or a small group.<\/td>\n<td>Multiple departments monitor the status of accounts receivable.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>To understand the entire lifecycle from recording to tracking and retrieval, refer to <a href=\"https:\/\/bizzi.vn\/quy-trinh-quan-ly-cong-no\/\">debt management process in businesses<\/a> and <a href=\"https:\/\/bizzi.vn\/dso-la-gi\/\">How to track DSO in cash flow management.<\/a>.<\/p>\n<\/section>\n<section class=\"template-section\" id=\"bizzi-arm\">\n<h2><span class=\"ez-toc-section\" id=\"11_Bizzi_ho_tro_quan_ly_va_doi_soat_cong_no_o_buoc_nao\"><\/span>11. At which stage does Bizzi assist in managing and reconciling accounts receivable?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When accounts receivable are managed across multiple separate files, creating a reconciliation statement only addresses a single point in time. For continuous monitoring, businesses need to manage balances, payment deadlines, collection status, and outstanding payments awaiting reconciliation.<\/p>\n<p>According to the features Bizzi is announcing, the solution <strong>Debt control<\/strong> Supports management by invoice, contract, and customer; sends due date or scenario-based payment reminders; tracks DSO and reports aging; manages pending payments; reconciles payments with bank statements and assists in offsetting accounts payable.<\/p>\n<aside class=\"bizzi-callout\">\n<p>Software solutions do not replace businesses identifying the cause of discrepancies or authorizing the verification of accounts receivable. The main value lies in centralizing data and accounts receivable status so that reconciliation takes place on a single information source.<\/p>\n<\/aside>\n<div class=\"bizzi-cta\">\n<h3><span class=\"ez-toc-section\" id=\"Quan_ly_cong_no_tap_trung_khi_so_luong_giao_dich_tang\"><\/span>Centralized accounts receivable management is necessary as the number of transactions increases.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Businesses can use Word\/Excel templates to get started; as the volume of partners, invoices, and payments increases, the accounts receivable management system helps reduce manual aggregation and tracking of payment status.<\/p>\n<p><a class=\"bizzi-button\" href=\"https:\/\/bizzi.vn\/quan-ly-cong-no\/\">View Bizzi&#039;s debt management solution.<\/a><\/p>\n<\/div>\n<\/section>\n<section class=\"template-section bizzi-faq\" id=\"faq\">\n<h2><span class=\"ez-toc-section\" id=\"12_Cau_hoi_thuong_gap_ve_bien_ban_doi_chieu_cong_no\"><\/span>12. Frequently Asked Questions about Accounts Reconciliation Statements<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<details>\n<summary>Is a debt reconciliation statement mandatory?<\/summary>\n<p>There is no single mandatory reconciliation statement template for all businesses and transactions. However, reconciliation or confirmation may arise from contracts, internal control requirements, audits, or records of specific transactions.<\/p>\n<\/details>\n<details>\n<summary>What are the differences between Word and Excel templates?<\/summary>\n<p>Word is suitable for presentation, printing, and signing. Excel is suitable for entering multiple transactions, calculating balances, and identifying discrepancies. Businesses can use Excel to reconcile details and then transfer the agreed-upon data to Word.<\/p>\n<\/details>\n<details>\n<summary>Is the customer accounts receivable reconciliation form different from that of the supplier?<\/summary>\n<p>The structure may be similar, but the nature of the balances differs. For customers, businesses primarily track accounts receivable; for suppliers, businesses primarily track accounts payable.<\/p>\n<\/details>\n<details>\n<summary>When should the year-end accounts receivable reconciliation statement be finalized?<\/summary>\n<p>Typically, businesses need to determine the balance at the end of the accounting period, such as December 31st for a fiscal year that coincides with the calendar year. The date of record-keeping and the date of closing the figures should be clearly separated.<\/p>\n<\/details>\n<details>\n<summary>If the figures from both sides don&#039;t match, can a memorandum of understanding still be signed?<\/summary>\n<p>A record can be made documenting the agreed-upon figures and the remaining discrepancies, along with the reasons or details awaiting verification. Figures should not be altered simply to make the record appear to &quot;match&quot; without sufficient evidence.<\/p>\n<\/details>\n<details>\n<summary>Does a debt reconciliation statement need to be stamped?<\/summary>\n<p>A general rule that a document is automatically invalid without a seal should not be applied. Businesses need to verify whether the certifying party has the appropriate authority or authorization, and also review the agreement and procedures of the parties involved.<\/p>\n<\/details>\n<details>\n<summary>Can a debt reconciliation statement be digitally signed?<\/summary>\n<p>Electronic forms may be used when the legal requirements for electronic transactions and signatures are met, and when they are consistent with the procedures and agreements of the parties involved.<\/p>\n<\/details>\n<details>\n<summary>How often should accounts receivable and payable be reconciled?<\/summary>\n<p>There is no single frequency that applies to all businesses. The frequency should be based on transaction volume, debt risk, contractual requirements, and control processes. Businesses with many transactions often reconcile periodically rather than waiting until the end of the year.<\/p>\n<\/details>\n<\/section>\n<\/article>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>M\u1eabu bi\u00ean b\u1ea3n \u0111\u1ed1i chi\u1ebfu c\u00f4ng n\u1ee3 gi\u00fap doanh nghi\u1ec7p v\u00e0 \u0111\u1ed1i t\u00e1c so s\u00e1nh s\u1ed1 li\u1ec7u ph\u1ea3i thu, ph\u1ea3i tr\u1ea3 t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m,&#8230;<\/p>","protected":false},"author":57,"featured_media":999973937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[263],"tags":[],"class_list":["post-999973750","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc"],"acf":[],"_links":{"self":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999973750","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\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/comments?post=999973750"}],"version-history":[{"count":9,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999973750\/revisions"}],"predecessor-version":[{"id":999981895,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999973750\/revisions\/999981895"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media\/999973937"}],"wp:attachment":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media?parent=999973750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/categories?post=999973750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/tags?post=999973750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}