Microsoft Excel Template to create e-Tax Invoice & e-Receipt documents

1. The input part of each column.
Each column is described as follows.
order: order
documentType: The order of the documents.
- e-Receipt/ e-Tax Invoice
- e-Invoice/e-Tax Invoice
- e-Delivery Invoice/e-Tax Invoice
- e-Tax Invoice
- e-Receipt/e-Abb tax invoice
- e-Receipt
- e-Debit note
- e-Credit note
- e-Quotation
- e-Invoice
- e-Bill
number : Document number.
dateBE : Day, Month, Year (B.E.) the document was issued.
IncludeVat: Price includes VAT. If included, specify true .
(Only Quotation, Invoice, Billing) Pay via PromptPay. If yes, specify true
Only Debit note, Credit note) Specify as 1 = Debit note/Credit or 2 = Actual price.
Specify a vertical list of products by using order to indicate which document the item is in. For example:

itemsNumber : The order of the items or services.
itemsDescription : A description of a product or service.
itemsQuantity : Number of items.
itemsUnitName : item unit information
Unit (Thai language) | Unit (English) |
– | – |
ชิ้น/อัน | EA |
กล่อง | BX |
แพ็ค | PACK |
หน่วย | AU |
ถุง | BAG |
ปิ๊ป | BKT |
ขวด | BT |
กระป๋อง | CAN |
เซลล์ | CELL |
วัน | DAY |
ถัง | DR |
โหล | DZ |
แกลลอน | GLL |
งาน | JOB |
ชิ้น | PCS |
ชุด | SET |
เมตร | M |
หลา | YARD |
ซม. | CM |
นิ้ว | INCH |
กรัม | GRAM |
กก. | KG |
ปอนด์ | POUND |
ลิตร | LITRE |
เส้น | LINE |
คัน | CAR |
เที่ยว | TRIP |
แผ่น | SHEET |
ม้วน | ROLL |
Units can be typed into Thai or English unit names.
For example, if the product list is in boxes , type in boxes (type in Thai) or type in BX (for English).
An example of entering data is shown in the figure below.

itemsPrice : The price of a product or service per unit.
itemsDiscount : Discount on goods or services per unit.
itemsPercentVat : The tax percentage of the item contains
- If it is a tax exempt item, specify – 1.
- If it is a 0% tax item, specify 0 .
- If it is a 7% tax item, specify 7.
discount : (Can be blank) total discount (different from items_discount ).
Language, if English, specify en , if Thai, specify th.

Buyer’s part
Note: If documentType is specified as RECEIPT-TAXINVOICE-ABB. (abbreviated tax invoice) is not required on the part of the buyer.
customerName : Buyer’s name or buyer’s company.
customerAddressLineOne : Buyer’s address or buyer’s company, line 1.
customerAddressLineTwo : (Can be blank) Buyer’s or buyer’s company address, line 2.
customerPostcode : Postal Code
customerCountryName : (You can leave blank) Country name such as Thailand (default) Click to view country name details.

customerTaxNumberType : The taxpayer type code contains.
Requirements in the file | Meaning |
TXID | Tax Identification Number |
NIDN | ID Number |
CCPT | Passport Number |
OTHR | Do not want to specify |
customerTaxId : Tax ID if
- customerTaxNumberType as TXID => Specified as a 13-digit corporate tax ID number.
- customerTaxNumberType as NIDN => Specified as a 13-digit identification number (for individuals).
- customerTaxNumberType as CCPT => Specified as Passport Number.
- customerTaxNumberType as OTHR => N/A
customerBranchNumber: Branch code, head office is 00000.

customerPhone : Phone number
customerEmail : Email

note : (You can leave blank) Note that you want to show in the e-Receipt/e-Tax invoice.
receivedBy : (Can leave blank) Name of payee.
createdBy : (Can leave blank) Author name.
reIssue : If a new tax invoice is issued in lieu of a canceled tax invoice, true.

Part of the Document Referred to
Note: If reIssue is specified as false, no information is required here. except the documents of Debit note and credit note to be specified in this section.
referTypeCode : Reference document type code. (Include only document, debit note or credit note only).
Requirements in the file | Meaning |
T02 | e-Invoice/e-Tax Invoice |
T03 | e-Receipt/e-Tax Invoice |
T04 | e-Delivery invoice/e-Tax invoice |
388 | e-Tax invoice |

referNumber : The number that the document refers to.
referDateBE : Date, month, year (B.E.) the reference document was issued.
referAmountTotal : The value of the product or service according to the original document. (Include only document, debit note or credit note only).

referReasonCode :
For RECEIPT-TAXINVOICE, INVOICE-TAXINVOICE, DELIVERYORDER-TAXINVOICE, TAXINVOICE, RECEIPT-TAXINVOICE-ABB
Requirements in the file | Meaning |
TIVC01 | Wrong name |
TIVC02 | Wrong address |
TIVC99 (if specified, referSpecificReason must also be specified) | Other reasons |
For RECEIPT
Requirements in the file | Meaning |
RCTC01 | Wrong name |
RCTC02 | Wrong address |
RCTC03 (if specified, referSpecificReason must also be specified) | Return of goods/cancellation of service in full amount. |
RCTC04 (if specified, referSpecificReason must also be specified) | Returns/cancellation of partial services. |
RCTC99 (if specified, referSpecificReason must also be specified) | Other reasons |
For DEBIT-NOTE
Requirements in the file | Meaning |
DBNG01 | There is an increase in the price of the product. |
DBNG02 | Miscalculated the price of a product that was lower than it actually was. |
DBNG99 (if specified, referSpecificReason must also be specified) | Other reasons (in case of product price). |
DBNS01 | There is an increase in the price of the service. |
DBNS02 | Miscalculated the price of a service fee that is lower than it actually is. |
DBNS99 (if specified, referSpecificReason must also be specified) | Other reasons (in case of service). |
For CREDIT-NOTE
Requirements in the file | Meaning |
CDNG01 | Reduce the price of the products sold. |
CDNG02 | Damaged goods |
CDNG03 | The product is out of quantity as agreed upon. |
CDNG04 | The price was calculated wrongly higher than it actually was. |
CDNG05 | Return |
CDNG99 (if specified, referSpecificReason must also be specified) | Other reasons (in case of selling products). |
CDNS01 | service fee reduction. |
CDNS02 | Lack of service charge. |
CDNS03 | Miscalculated the price of the service fee higher than it actually is. |
CDNS04 | service contract termination. |
CDNS99 (if specified, referSpecificReason must also be specified) | Other reasons (in case of service). |

referSpecificReason : If the cause is other must state the reason.
If referSpecificReason specifies as RCTC03 => specifies as Return or Cancel service, the whole amount followed by the amount number. Place a space between the text and the number. Example: Return the entire product for 2000 baht.
If referSpecificReason specifies as RCTC04 => specifies as Refund or Cancel service, the whole amount followed by the amount number. Place a space between the text and the number. Example: Return the entire product for 2000 baht.

calculationMethod
Calculating debit note and credit note divided into two types.
Type 1 (Debit note)

Type 1 (Debit note)

Type 2 (Debit note)

Type 2 (Debit note)

2. Examples of Excel columns compared to actual documents
The column names in the Excel document are shown below referring to the numbers as shown below.

- documentType
- number
- dateBE
- itemsNumber
- itemsDescription
- itemsQuantity
- itemsUnitCode
- itemsPrice
- itemsDiscount
- discount
- customerName
- customerAddressLineOne + customerAddressLineTwo
- customerPostcode
- customerBranchNumber
- customerTaxId
- customerPhone
- customerEmail
- note
- createdBy, receivedBy
- referNumber
- referDateBE
- referReasonCode