Singapore Tax Invoice and Credit Note Templates

Title

“Tax Invoice”

The document type.

Yes

Company Name

${subsidiary.name}

If you are not using a OneWorld account, the place holder is ${companyInformation.companyName}

The name of your company or subsidiary that issued the tax invoice.

Yes

Company Logo

${subsidiary.logo}

If you are not using a OneWorld account, the place holder is <img src="${companyInformation.logoUrl}" />

References the image that you want to place as the company logo.

No

Company Address

${subsidiary.mainaddress_text}

If you are not using a OneWorld account, the place holder is ${companyInformation.addressText}

The address of your company that issued the tax invoice.

Yes

Tel No. label

“Tel”

Label indicating “Tel”.

No

Tel No.

${subsidiary.phone}

If you are not using a OneWorld account, the place holder is ${companyInformation.phone}

The telephone number of your company that issued the tax invoice.

No

Email label

“Email”

Label indicating “Email”.

No

Email

${subsidiary.email}

If you are not using a OneWorld account, the place holder is ${companyInformation.email}

The email address of your company that issued the tax invoice.

No

Company Reg. No. label

“Company Reg. No.”

Label indicating “Company Reg. No.”

No

Company Reg. No.

${subsidiary.custrecord_company_uen}

If you are not using a OneWorld account, the place holder is ${companyInformation.custrecord_company_ uen}

By default, in the Singapore Tax Invoice Template, this is the value entered in the Unique Entity Number (UEN) field provided by the Tax Audit Files SuiteApp (if installed).

If the Tax Audit Files SuiteApp is not installed, this field will be blank.

If you have your own custom field for UEN, you can also source it by replacing the placeholder.

No

GST Reg. No. label

“GST Reg. No.”

Label indicating “GST Reg. No.”

Yes

GST Reg. No.

${subsidiary.federalidnumber}

If you are not using a OneWorld account, the place holder is ${companyInformation.employerid}

The GST Reg. No. of your company. If you are not using a NetSuite OneWorld account, this is sourced from the VAT Registration No. in Company Information. If you are using a OneWorld account, it is sourced from the subsidiary VAT Registration No.

Yes

Transaction Date label

${record.trandate@label}

Label indicating “Date”.

Yes

Transaction Date

${record.trandate}

The transaction date, in DD/MM/YYYY format, which is the required date format in Singapore.

Yes

Invoice No. label

${record.tranid@label}

Label indicating “Invoice No.”

Yes

Invoice No.

${record.tranid}

The Invoice No. sourced from the transaction.

Yes

Billing Address label

${record.billaddress@label}

Label indicating “Billing Address”.

No

Customer Address (Bill To)

${record.billaddress}

The billing address of the customer.

Yes

Shipping Address label

${record.shipaddress@label}

Label indicating “Shipping Address”.

No

Customer Address (Ship To)

${record.shipaddress}

The shipping address of the customer.

Yes

Terms label

${record.terms@label}

Label indicating “Terms”.

No

Terms

${record.terms}

The payment terms sourced from the transaction record.

No

Due Date label

${record.duedate@label}

Label indicating “Due Date”.

No

Due Date

${record.duedate}

The due date of the invoice.

No

PO No. label

${record.otherrefnum@label}

Label indicating “PO No.”

No

PO No.

${record.otherrefnum}

The PO No. indicated in the transaction.

No

Sales Rep label

${record.salesrep@label}

Label indicating “Sales Rep.”

No

Sales Rep

${record.salesrep}

The name of the Sales Rep sourced from the transaction.

No

Shipping Method label

${record.shipmethod@label}

Label indicating “Shipping Method”.

No

Shipping Method

${record.shipmethod}

The shipping method sourced from the transaction.

No

Partner label

${record.partner@label}

Label indicating “Partner”.

No

Partner

${record.partner}

The name of the partner sourced from the transaction.

No

Item line No. label

“No.”

Label indicating “No.”

No

Item Name label

${item.item@label}

Label indicating “Item Name”.

No

Item Description label

${item.description@label}

Label indicating “Description”.

No

Item Quantity label

${item.quantity@label}

Label indicating “Qty”.

No

Item Rate label

${item.rate@label}

Label indicating “Rate”.

No

Item Amount label

${item.amount@label}

Label indicating “Amount”.

No

Item Rate Currency

${record.currencysymbol}

The currency of rate or unit price per line item.

Yes

Item Amount Currency

${record.currencysymbol}

The currency of the item amount.

Yes

Item Line No.

${item?counter}

The number of the line item in the list.

No

Item Name

${item.item} ${item.custcol_psg_sal_reverse_indicator}

The name of the line item.

Asterisks beside the line item indicate that reverse charge is applied, when the tax code used for customer accounting has reverse charge property.

Yes

Item Description

${item.description}

The description of the line item.

Yes

Item Quantity

${item.quantity}

The quantity of the item.

Yes

Item Rate

${item.rate?string["#,##0.00"]}

The rate or unit price per line item.

Yes

Item Amount

${item.amount?string["#,##0.00"]}

The amount of the item derived from the item rate or unit price multiplied by the quantity.

Yes

Subtotal label

${record.subtotal@label}

Label indicating “Subtotal”.

Yes

Subtotal currency

${record.currencysymbol}

The currency of the total amount excluding tax.

No

Subtotal

${record.subtotal?string["#,##0.00"]}

The total amount excluding tax.

Yes

GST Transaction Tax Rate

GST ${record.custbody_psg_sal_tax_rate}

If the same tax code is applied to all items in the transaction, and the tax code does not have the exempt and reverse charge property checked, this shows the applicable tax rate, beside the label GST.

Yes

Tax Currency

${record.currencysymbol}

The currency of the tax amount.

No

Tax Total Amount

${record.taxtotal?string["#,##0.00"]}

The total tax amount.

Yes

Total Amount label

${record.total@label}

Label indicating “Total Amount”.

Yes

Total Amount Currency

${record.currencysymbol}

The currency of the total amount inclusive of tax.

No

Total Amount

${record.total?string["#,##0.00"]}

The total amount inclusive of tax.

Yes

Customer Accounting

${record.custbody_psg_sal_reverse_indicator} Customer accounting: Customer to pay GST of ${record.currencysymbol} ${record.custbody_psg_sal_reverse_charge_ amount} to IRAS.

If customer accounting is applied, a note is added indicating that the customer has to pay for output tax and the amount of GST to be paid, as required by IRAS.

Asterisks mark items with reverse charge tax code applied.

Reverse charge amount is the amount of tax that will be paid by the customer.

The notional rate indicated in the tax codes applied is used to compute for the GST amount.

Yes

Tax Summary (single tax code)

“GST Summary”

You must also include the tag: <#assign baseconversions=record.custbody_psg_sal_ base_conversion?eval> for succeeding tags to work.

Label indicating “GST Summary”. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal label

${record.subtotal@label}

Label of the Subtotal converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the Subtotal converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal

${baseconversions.basesubtotal}

Indicates the Subtotal amount converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax label

“GST”

Label indicating “GST”. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the tax amount converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax Total Amount

${baseconversions.basetax}

The total tax in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount label

${record.total@label}

Label indicating the total amount in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the total amount in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount

${baseconversions.basetotal}

Indicates the total amount in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Tax Summary (multiple tax codes)

“GST Summary”

You must also include the tag: <#assign taxsummary=record.custbody_psg_sal_tax_ codes_summary?eval> for succeeding tags to work.

Label indicating “GST Summary”. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Subtotal Column label

${record.subtotal@label}

(${taxsummary.basecurrency})

Label of the Subtotal column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Tax Column label

“Tax” (${taxsummary.basecurrency})

Label of the Tax column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Total Column label

${record.total@label} (${taxsummary.basecurrency})

Label of the Total column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Tax Code and Rate

${taxdata.taxcode} ${taxdata.rate}

You must also include the tag: <#list taxsummary.taxcodedata as taxdata> for succeeding tags to work.

Tax code and rate in the GST Summary table, pertaining to the tax codes used in the transaction and the corresponding rates. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Subtotal

${taxdata.subtotal}

Subtotal amount in the GST Summary table, pertaining to the total amount exclusive of tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Tax Summary Tax Amount

${taxdata.tax}

Total tax amount in the GST Summary table, pertaining to the total tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Tax Summary Total Amount

${taxdata.total}

Total Amount in the GST Summary table, pertaining to the total amount inclusive of tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Editable comments in the document footer

--Editable comments section--

A section where comments or any message for the customer can be entered.

No

Page number

<pagenumber /> of <totalpages />

Page number and total number of pages.

No

Title

“Credit Note”

The document type.

Yes

Company Name

${subsidiary.name}

If you are not using a OneWorld account, the place holder is ${companyInformation.companyName}

The name of your company or subsidiary that issued the credit note.

Yes

Company Logo

${subsidiary.logo}

If you are not using a OneWorld account, the place holder is <img src="${companyInformation.logoUrl}" />

References the image that you want to place as the company logo.

No

Company Address

${subsidiary.mainaddress_text}

If you are not using a OneWorld account, the place holder is ${companyInformation.addressText}

The address of your company that issued the tax invoice.

Yes

Tel No. label

“Tel”

Label indicating “Tel”.

No

Tel No.

${subsidiary.phone}

If you are not using a OneWorld account, the place holder is ${companyInformation.phone}

The telephone number of your company that issued the tax invoice.

No

Email label

“Email”

Label indicating “Email”.

No

Email

${subsidiary.email}

If you are not using a OneWorld account, the place holder is ${companyInformation.email}

The email address of your company that issued the tax invoice.

No

Company Reg. No. label

“Company Reg. No.”

Label indicating “Company Reg. No.”

No

Company Reg. No.

${subsidiary.custrecord_company_uen}

If you are not using a OneWorld account, the place holder is ${companyInformation.custrecord_company_ uen}

By default, in the Singapore Tax Invoice Template, this is the value entered in the Unique Entity Number (UEN) field provided by the Tax Audit Files SuiteApp (if installed).

If the Tax Audit Files SuiteApp is not installed, this field will be blank.

If you have your own custom field for UEN, you can also source it by replacing the placeholder.

No

GST Reg. No. label

“GST Reg. No.”

Label indicating “GST Reg. No.”

Yes

GST Reg. No.

${subsidiary.federalidnumber}

If you are not using a OneWorld account, the place holder is ${companyInformation.employerid}

The GST Reg. No. of your company. If you are not using a NetSuite OneWorld account, this is sourced from the VAT Registration No. in Company Information. If you are using a OneWorld account, it is sourced from the subsidiary VAT Registration No.

Yes

Transaction Date label

${record.trandate@label}

Label indicating “Date”.

Yes

Transaction Date

${record.trandate}

The transaction date, in DD/MM/YYYY format, which is the required date format in Singapore.

Yes

Credit Note No. label

“Credit Note #”

Label indicating “Credit Note #”.

No

Credit Note No.

${record.tranid}

The Credit Note No. sourced from the transaction.

Yes

Billing Address label

${record.billaddress@label}

Label indicating “Billing Address”.

No

Customer Address (Bill To)

${record.billaddress}

The billing address of the customer.

Yes

Shipping Address label

${record.shipaddress@label}

Label indicating “Shipping Address”.

No

Customer Address (Ship To)

${record.shipaddress}

The shipping address of the customer.

Yes

PO No. label

${record.otherrefnum@label}

Label indicating “PO No.”

No

PO No.

${record.otherrefnum}

The PO No. of the transaction.

No

Shipping Method label

${record.shipmethod@label}

Label indicating “Shipping Method”.

No

Shipping Method

${record.shipmethod}

The shipping method sourced from the transaction.

No

Tax Invoice No. label

“Tax Invoice No.”

Label indicating “Tax Invoice No.”

Yes

Tax Invoice No.

${record.custbody_psg_sal_sg_createdfr}

The number of the tax invoice that the credit note was created from. This is blank if the credit memo or return authorization is not created from an invoice.

Yes

Invoice Date label

“Invoice Date”

Label indicating “Invoice Date”.

Yes

Invoice Date

${record.custbody_psg_sal_sg_createddate}

The invoice date, in DD/MM/YYYY format. This is blank if the credit memo or return authorization is not created from an invoice.

Yes

Reason for the credit label

“Reason for the credit”

Label indicating “Reason for the credit”.

Yes

Reason for the credit

${record.memo}

The reason for the credit, sourced from the Memo of the transaction.

Yes

Item line No. label

“No.”

Label indicating “No.”

No

Item Name label

${item.item@label}

Label indicating “Item Name”.

No

Item Description label

${item.description@label}

Label indicating “Description”.

No

Item Quantity label

${item.quantity@label}

Label indicating “Qty”.

No

Item Rate label

${item.rate@label}

Label indicating “Rate”.

No

Item Amount label

${item.amount@label}

Label indicating “Amount”.

No

Item Rate Currency

${record.currencysymbol}

The currency of rate or unit price per line item.

Yes

Item Amount Currency

${record.currencysymbol}

The currency of the item amount.

Yes

Item Line No.

${item?counter}

The number of the line item in the list.

No

Item Name

${item.item} ${item.custcol_psg_sal_reverse_indicator}

The name of the line item.

Asterisks beside the line item indicate that reverse charge is applied for customer accounting transactions, when the tax code used has reverse charge property checked.

Yes

Item Description

${item.description}

The description of the line item.

Yes

Item Quantity

${item.quantity}

The quantity of the item.

Yes

Item Rate

${item.rate?string["#,##0.00"]}

The rate or unit price per line item.

Yes

Item Amount

${item.amount?string["#,##0.00"]}

The amount of the item derived from the item rate or unit price multiplied by the quantity.

Yes

Subtotal label

${record.subtotal@label}

Label indicating “Subtotal”.

Yes

Subtotal currency

${record.currencysymbol}

The currency of the total amount excluding tax.

No

Subtotal

${record.subtotal?string["#,##0.00"]}

The total amount excluding tax.

Yes

GST Transaction Tax Rate

GST ${record.custbody_psg_sal_tax_rate}

If the same tax code is applied to all items in the transaction, and the tax code does not have the exempt and reverse charge property checked, this shows the applicable tax rate, beside the label GST.

Yes

Transaction Tax Code

“GST (7%)”

The tax code used per line item.

Yes

Tax Currency

${record.currencysymbol}

The currency of the tax amount.

No

Tax Total Amount

${record.taxtotal?string["#,##0.00"]}

The total tax amount.

Yes

Total Amount label

${record.total@label}

Label indicating “Total Amount”.

Yes

Total Amount Currency

${record.currencysymbol}

The currency of the total amount inclusive of tax.

No

Total Amount

${record.total?string["#,##0.00"]}

The total amount inclusive of tax.

Yes

Customer Accounting

${record.custbody_psg_sal_reverse_indicator} Customer accounting: Customer to account for output tax adjustment of -${record.currencysymbol} ${record.custbody_psg_sal_reverse_charge_ amount}.

If customer accounting is applied, a note is added indicating that the customer has to account for output tax adjustment and the GST amount.

Asterisks mark items with reverse charge tax code applied.

Reverse charge amount is the amount of tax that must be accounted for by the customer.

The notional rate indicated in the tax codes applied is used to compute for the GST amount.

Yes

Tax Summary (single tax code)

“GST Summary”

You must also include the tag: <#assign baseconversions=record.custbody_psg_sal_ base_conversion?eval> for succeeding tags to work.

Label indicating “GST Summary”. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal label

${record.subtotal@label}

Label of the Subtotal converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the Subtotal converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Subtotal

${baseconversions.basesubtotal}

Indicates the Subtotal amount converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax label

“GST”

Label indicating “GST”. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the tax amount converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Tax Total Amount

${baseconversions.basetax}

The total tax in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount label

${record.total@label}

Label indicating the total amount in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount Currency

${record.custbody_psg_sal_custpay_sub_currency.symbol}

The currency of the total amount converted into the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Base Total Amount

${baseconversions.basetotal}

Indicates the total amount in the base currency. The default template only displays this if the transaction is in a foreign currency and the same tax code is used for all items.

Yes

Tax Summary (multiple tax codes)

“GST Summary”

You must also include the tag: <#assign taxsummary=record.custbody_psg_sal_tax_ codes_summary?eval> for succeeding tags to work.

Label indicating “GST Summary”. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Subtotal Column label

${record.subtotal@label}

(${taxsummary.basecurrency})

Label of the Subtotal column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Tax Column label

“Tax” (${taxsummary.basecurrency})

Label of the Tax column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Total Column label

${record.total@label} (${taxsummary.basecurrency})

Label of the Total column in the GST Summary table. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Tax Code and Rate

${taxdata.taxcode} ${taxdata.rate}

You must also include the tag: <#list taxsummary.taxcodedata as taxdata> for succeeding tags to work.

Tax code and rate in the GST Summary table, pertaining to the tax codes used in the transaction and the corresponding rates. The default template only displays this if the transaction has multiple tax codes.

Yes

Tax Summary Subtotal

${taxdata.subtotal}

Subtotal amount in the GST Summary table, pertaining to the total amount exclusive of tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Tax Summary Tax Amount

${taxdata.tax}

Total tax amount in the GST Summary table, pertaining to the total tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Tax Summary Total Amount

${taxdata.total}

Total Amount in the GST Summary table, pertaining to the total amount inclusive of tax for each tax code applied to the transaction. The default template only displays this if the transaction has multiple tax codes. Amounts are converted into the base currency if the transaction is in a foreign currency.

Yes

Editable comments in the document footer

--Editable comments section--

A section where comments or any message for the customer can be entered.

No

Page number

<pagenumber /> of <totalpages />

Page number and total number of pages.

No