Digital Tools for Industrial SMEs · 11

B2B Debtor Register & Collection System (Thai + English editions)

Fixed price · instant download after payment · no quote needed

Sheet 0 — start in 4 steps, with a guided tour that ticks itself only when you have really done each step; the status cells are formulas reading your own cells · the two file-health lights should always be green.

The register — one invoice per row, yellow cells only; the file computes the due date, expected cash net of withholding tax, outstanding, days overdue, status, next action and idle-money interest · the three sample rows show three real states: not yet due (🟢), 20 days overdue at the firm-follow-up step (🟡), and an invoice closed after payment net of 3% withholding (✅).

The chase-today screen — open it each morning and work top-down; the file ranks for you: broken rows first, then longest-overdue and largest amounts, due-soon last, each with the recommended step, the customer's phone/LINE, and the row number that drives the message composer on sheet 6.

The dashboard — receivables health on one page: full ageing, a grand total that always equals the sum of the buckets, DSO against your target with a warning light, the collection rate for invoices due in the window, and a per-customer summary of who owes what and how much of it is overdue.

The reminder sheet — type a register row number and three ready messages compose themselves with the invoice number, amount and due date; copy one into LINE or email. The wording is deliberately relationship-preserving, and the file suggests which level fits this invoice.

The self-test — 26 live-computed cases: 10 normal · 10 deliberately broken (negatives, overpayment, blank rows, Buddhist years, billions) · 6 forcing every ageing edge exactly (1 · 30 · 31 · 60 · 90 · 91 days) · the right-hand column compares live against what the answer should be, and if you retune the settings, affected cases honestly say “comparison skipped” instead of pretending the file broke.

Screenshots of the file you actually receive — the figures shown are sample defaults, and every cell is yours to change.

One purchase, two files. You receive both the English (Thailand) edition shown in the screenshots above and the Thai edition — generated from the same formulas, so the two can never disagree about a number.

An Excel debtor register for businesses that sell on credit — one row per invoice, and every morning it answers the only question that matters: who owes us what today, and who to chase first. Due dates can run from the Thai billing-cycle date (วางบิล) instead of the invoice date, matching how Thai corporate customers actually pay · three-level credit terms: per-invoice override → per-customer term → default · expected cash is computed net of Thai withholding tax (0/1/2/3/5%) on the pre-VAT base, the way customers actually withhold · invoices close themselves once payment arrives within a tolerance you set, so transfer-fee satang never linger as ghost debt · nine statuses: the standard ageing buckets 1-30/31-60/61-90/90+, due-soon, collected, and two data-quality flags (missing date · Buddhist-era year typed into a Gregorian field, which shifts dates by 543 years) · a ranked chase-today screen — broken rows first so you fix them, then longest-overdue and largest amounts, with each customer's phone/LINE pulled from the register · a four-step collection ladder you tune yourself (polite call → ask for a firm payment date → formal balance notice → suspend deliveries and escalate) · an idle-money column that prices every overdue baht at your overdraft rate, per year · a dashboard with ageing totals, DSO against your target, and the collection rate of invoices due in your chosen window · a reminder-message sheet: type a row number and it composes a polite Thai message with the invoice number, amount and due date, ready to paste into LINE or email · every setting keeps a factory value to copy back when you break something · a 26-case live self-test sheet (10 normal · 10 deliberately broken — negative amounts, overpayment, Buddhist years, billions · 6 forcing every ageing edge exactly) · sheet one is a four-step guided tour that ticks itself only when you have really done each step · one purchase, two files: the Thai edition and this English (Thailand) edition, generated from the same formulas · no macros — opens in Excel, LibreOffice and Google Sheets

Launch price · until 31 Dec 2026

฿1,290≈ US$39Regular price ~~฿1,990~~Complete · one-time payment

This price includes 7% Thai VAT (goods ฿1,205.61 + VAT ฿84.39) — nothing else is added. You are charged ฿1,290 THB; the US$ figure is an approximate guide at today's rate and your bank converts at its own. Cards from any country are accepted.

✓Two editions in one purchase — Thai and English files, identical formulas.
✓Download immediately after payment — no waiting.
✓The manual lives inside the file (first sheet) — usable without anyone training you.
✓Every default is yours to change, and a “factory value” column restores the original when you break something.
✓A plain .xlsx with no macros — opens in Excel, LibreOffice and Google Sheets.
✓A full Thai tax invoice can be issued — deductible as a company expense (registered company).
✓Buy in your company’s name — enter the company name and 13-digit tax ID at checkout and we issue the tax invoice to match.

Pay by PromptPay or credit/debit card through Stripe (secure, industry-standard encryption).

What support covers

This is a finished file sold outright, once. It does not include installation, training or per-customer customisation — the common questions are answered in the manual inside the file.