417
Purchases & payables
Accounts payable
Vendor bills, what we still owe, and paying them on time.
Aging by vendor
| Name | Docs | Not due | 1-30 | 31-60 | 61-90 | 90+ | Total |
|---|---|---|---|---|---|---|---|
| Bright Ads Agency Co., Ltd. | 1 | 55,961.00 | 0.00 | 0.00 | 0.00 | 0.00 | 55,961.00 |
| Kasem Legal & Accounting Co., Ltd. | 1 | 0.00 | 32,100.00 | 0.00 | 0.00 | 0.00 | 32,100.00 |
| Total | 2 | 55,961.00 | 32,100.00 | 0.00 | 0.00 | 0.00 | 88,061.00 |
To pay - oldest due first
| Bill | Vendor | Due | Outstanding | |
|---|---|---|---|---|
| BILL-2026-0047 | Kasem Legal & Accounting Co., Ltd. | 28 Oct 2026 12 d late | 32,100.00 THB | Pay |
| BILL-2026-0051 | Bright Ads Agency Co., Ltd. | 9 Nov 2026 | 55,961.00 THB | Pay |
Bills received
| Bill | Date | Vendor / what | Status | Total |
|---|---|---|---|---|
| BILL-2026-0051 | 10 Oct 2026 | Bright Ads Agency Co., Ltd. Online ads campaign October 2026 |
Open | 55,961.00 THB |
| BILL-2026-0050 | 5 Oct 2026 | Metropolitan Electricity Authority Electricity October 2026 |
Paid | 16,670.60 THB |
| BILL-2026-0049 | 3 Oct 2026 | CloudStack Inc. Cloud hosting and developer tools October 2026 |
Paid | 1,190.00 USD |
| BILL-2026-0048 | 1 Oct 2026 | Bangkok Office Tower Co., Ltd. Office rent October 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0047 | 28 Sep 2026 | Kasem Legal & Accounting Co., Ltd. Quarterly accounting and legal review |
Open | 32,100.00 THB |
| BILL-2026-0046 | 18 Sep 2026 | Pim Chantarasiri (designer) Brochure and social media design |
Paid | 25,000.00 THB |
| BILL-2026-0045 | 10 Sep 2026 | Bright Ads Agency Co., Ltd. Online ads campaign September 2026 |
Paid | 95,861.30 THB |
| BILL-2026-0044 | 5 Sep 2026 | Metropolitan Electricity Authority Electricity September 2026 |
Paid | 15,793.20 THB |
| BILL-2026-0043 | 3 Sep 2026 | CloudStack Inc. Cloud hosting and developer tools September 2026 |
Paid | 1,204.00 USD |
| BILL-2026-0042 | 1 Sep 2026 | Bangkok Office Tower Co., Ltd. Office rent September 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0041 | 10 Aug 2026 | Bright Ads Agency Co., Ltd. Online ads campaign August 2026 |
Paid | 95,155.10 THB |
| BILL-2026-0040 | 5 Aug 2026 | Metropolitan Electricity Authority Electricity August 2026 |
Paid | 22,587.70 THB |
| BILL-2026-0039 | 3 Aug 2026 | TechPro Computers Co., Ltd. Meeting room furniture |
Paid | 128,400.00 THB |
| BILL-2026-0038 | 3 Aug 2026 | CloudStack Inc. Cloud hosting and developer tools August 2026 |
Paid | 1,167.00 USD |
| BILL-2026-0037 | 1 Aug 2026 | Bangkok Office Tower Co., Ltd. Office rent August 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0036 | 18 Jul 2026 | Pim Chantarasiri (designer) Brochure and social media design |
Paid | 25,000.00 THB |
| BILL-2026-0035 | 10 Jul 2026 | Bright Ads Agency Co., Ltd. Online ads campaign July 2026 |
Paid | 84,316.00 THB |
| BILL-2026-0034 | 5 Jul 2026 | Metropolitan Electricity Authority Electricity July 2026 |
Paid | 19,773.60 THB |
| BILL-2026-0033 | 3 Jul 2026 | CloudStack Inc. Cloud hosting and developer tools July 2026 |
Paid | 1,192.00 USD |
| BILL-2026-0032 | 1 Jul 2026 | Bangkok Office Tower Co., Ltd. Office rent July 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0031 | 28 Jun 2026 | Kasem Legal & Accounting Co., Ltd. Quarterly accounting and legal review |
Paid | 32,100.00 THB |
| BILL-2026-0030 | 10 Jun 2026 | Bright Ads Agency Co., Ltd. Online ads campaign June 2026 |
Paid | 66,693.10 THB |
| BILL-2026-0029 | 5 Jun 2026 | Metropolitan Electricity Authority Electricity June 2026 |
Paid | 15,076.30 THB |
| BILL-2026-0028 | 3 Jun 2026 | CloudStack Inc. Cloud hosting and developer tools June 2026 |
Paid | 1,359.00 USD |
| BILL-2026-0027 | 1 Jun 2026 | Bangkok Office Tower Co., Ltd. Office rent June 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0026 | 18 May 2026 | Pim Chantarasiri (designer) Brochure and social media design |
Paid | 25,000.00 THB |
| BILL-2026-0025 | 12 May 2026 | Euro Training Partners GmbH Trainer fees - Agile workshop |
Paid | 4,500.00 EUR |
| BILL-2026-0024 | 10 May 2026 | Bright Ads Agency Co., Ltd. Online ads campaign May 2026 |
Paid | 79,950.40 THB |
| BILL-2026-0023 | 5 May 2026 | Metropolitan Electricity Authority Electricity May 2026 |
Paid | 18,500.30 THB |
| BILL-2026-0022 | 3 May 2026 | CloudStack Inc. Cloud hosting and developer tools May 2026 |
Paid | 1,503.00 USD |
| BILL-2026-0021 | 1 May 2026 | Bangkok Office Tower Co., Ltd. Office rent May 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0020 | 10 Apr 2026 | Bright Ads Agency Co., Ltd. Online ads campaign April 2026 |
Paid | 75,381.50 THB |
| BILL-2026-0019 | 5 Apr 2026 | Metropolitan Electricity Authority Electricity April 2026 |
Paid | 17,259.10 THB |
| BILL-2026-0018 | 3 Apr 2026 | CloudStack Inc. Cloud hosting and developer tools April 2026 |
Paid | 1,303.00 USD |
| BILL-2026-0017 | 1 Apr 2026 | Bangkok Office Tower Co., Ltd. Office rent April 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0016 | 28 Mar 2026 | Kasem Legal & Accounting Co., Ltd. Quarterly accounting and legal review |
Paid | 32,100.00 THB |
| BILL-2026-0015 | 18 Mar 2026 | Pim Chantarasiri (designer) Brochure and social media design |
Paid | 25,000.00 THB |
| BILL-2026-0014 | 15 Mar 2026 | TechPro Computers Co., Ltd. 12 developer laptops |
Paid | 256,800.00 THB |
| BILL-2026-0013 | 10 Mar 2026 | Bright Ads Agency Co., Ltd. Online ads campaign March 2026 |
Paid | 52,965.00 THB |
| BILL-2026-0012 | 5 Mar 2026 | Metropolitan Electricity Authority Electricity March 2026 |
Paid | 19,409.80 THB |
| BILL-2026-0011 | 3 Mar 2026 | CloudStack Inc. Cloud hosting and developer tools March 2026 |
Paid | 1,154.00 USD |
| BILL-2026-0010 | 1 Mar 2026 | Bangkok Office Tower Co., Ltd. Office rent March 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0009 | 10 Feb 2026 | Bright Ads Agency Co., Ltd. Online ads campaign February 2026 |
Paid | 88,200.10 THB |
| BILL-2026-0008 | 5 Feb 2026 | Metropolitan Electricity Authority Electricity February 2026 |
Paid | 21,453.50 THB |
| BILL-2026-0007 | 3 Feb 2026 | CloudStack Inc. Cloud hosting and developer tools February 2026 |
Paid | 1,236.00 USD |
| BILL-2026-0006 | 1 Feb 2026 | Bangkok Office Tower Co., Ltd. Office rent February 2026 |
Paid | 90,950.00 THB |
| BILL-2026-0005 | 18 Jan 2026 | Pim Chantarasiri (designer) Brochure and social media design |
Paid | 25,000.00 THB |
| BILL-2026-0004 | 10 Jan 2026 | Bright Ads Agency Co., Ltd. Online ads campaign January 2026 |
Paid | 66,875.00 THB |
| BILL-2026-0003 | 5 Jan 2026 | Metropolitan Electricity Authority Electricity January 2026 |
Paid | 16,092.80 THB |
| BILL-2026-0002 | 3 Jan 2026 | CloudStack Inc. Cloud hosting and developer tools January 2026 |
Paid | 1,303.00 USD |
| BILL-2026-0001 | 1 Jan 2026 | Bangkok Office Tower Co., Ltd. Office rent January 2026 |
Paid | 90,950.00 THB |
| 51 bills, total in THB | 3,060,154.44 | |||
How this works - feature 417 Vendor bills, what we owe, and paying them.
Concepts
- Bill: Dr Expense or fixed asset / Dr Input VAT / Cr Accounts payable.
- Payment: Dr Accounts payable / Cr Bank (net) / Cr WHT payable (+ FX gain or loss).
- Thai rule: withholding tax is deducted when you PAY, so it is stored on the payment.
- A bill booked to a fixed asset account shows up as an investing cash flow (416).
Read the code
service/PurchaseServicedomain/Billdomain/BillPayment
SQL behind this page
SELECT p.id, p.code, p.name, COUNT(*) AS docs,
SUM(CASE WHEN x.days_late <= 0 THEN x.thb ELSE 0 END) AS not_due,
SUM(CASE WHEN x.days_late BETWEEN 1 AND 30 THEN x.thb ELSE 0 END) AS d1_30,
SUM(CASE WHEN x.days_late BETWEEN 31 AND 60 THEN x.thb ELSE 0 END) AS d31_60,
SUM(CASE WHEN x.days_late BETWEEN 61 AND 90 THEN x.thb ELSE 0 END) AS d61_90,
SUM(CASE WHEN x.days_late > 90 THEN x.thb ELSE 0 END) AS d90_plus,
SUM(x.thb) AS total
FROM bill b
JOIN party p ON p.id = b.vendor_id
CROSS APPLY (SELECT DATEDIFF(day, b.due_date, :today) AS days_late,
ROUND(b.outstanding * b.fx_rate, 2) AS thb) x
WHERE b.status IN ('ISSUED','PARTIAL')
GROUP BY p.id, p.code, p.name
ORDER BY total DESC