GST code

If your company is GST registered or going to then this blog is for you! I’ll help you understand the various tax codes in SQL Account to better equip you how you going to apply it.

When you’re GST-registered, you will need to assign a tax code to each and every transaction that you process. The tax codes will tell your accounting system whether or not there is GST in the transaction, what is the tax rate and more importantly how it present later in your GST F5 return.

Tax Codes Used in Sales (Output)

Tax Code SR

For sales of goods and services made in Singapore.

Tax Code ZR

For exporting goods out of Singapore or providing international services that fall within the description of international services under section 21(3) of the GST Act.

Tax Code OS

For sales of goods from a place outside Singapore to another place outside Singapore.

Tax Code DS

You provide gifts and samples (worth more than $200) out to your clients or prospective customers where you will issue a “Tax Certificate” (similar to Tax Invoice) to the recipient to claim as input tax if:

  1. The recipient is GST-registered.

  2. The recipient pays for the GST output tax.

Tax Code ES33

For supplies that are exempt from GST under Regulation 33 including:

  1. Interest income from deposits placed with a bank.

  2. Realised foreign currency exchanged gain loss.

  3. Issue / sales of shares or bonds.

  4. Interest income received from provision of loan.

Kindly refer here for more information.

Tax Code ESN33

For supplies that are exempt from GST and not covered under Regulation 33 including:

  1. Sales and rental of residential properties.

  2. Financial services provider.

Tax Codes Used in Purchases (Input)

Tax Code TX

For purchase of goods and services made in Singapore from GST-registered supplier.

Tax Code NR

For purchase of goods and services made in Singapore from non-GST registered supplier.

Tax Code ZP

For importing goods into Singapore or. No GST is imposed on imported services.

Tax Code IM

For GST on imports that is generally payable to Singapore Customs.

Tax Code OP

For purchase of goods from a place outside Singapore and the goods did not come into Singapore.

Tax Code BL

Regulations 26 and 27 of GST (General) Regulations do not allow GST incurred in the following expenses to be claimed as input tax.

  1. Benefits provided to the family members or relatives of your staff.

  2. Costs and running expenses incurred on motor cars.

  3. Club subscription fees (including transfer fees) charged by sports and recreation clubs.

  4. Medical expenses and accident insurance premiums incurred for your staff unless the insurance or payment of compensation is obligatory under the Work Injury Compensation Act or under any collective agreement within the meaning of the Industrial Relations Act.

  5. Any transaction involving betting, sweepstakes, lotteries, fruit machines or games of chance.​

Tax Code EP

Purchases related to residential properties or certain financial services where GST is exempted.

Tax Code TX-ESS

This is used for transactions involving the payment of input tax that is directly attributable to Regulation 33 Exempt Supplies, including:

  1. Interest income from deposits placed with a bank.

  2. Realised foreign currency exchanged gain loss.

  3. Issue / sales of shares or bonds.

  4. Interest income received from provision of loan.

Tax Code TX-N33

This is used for transactions involving the payment of input tax that is directly attribultable to Regulation 33 Exempt Supplies, including:

  1. Sales and rental of residential properties.

  2. Financial services provider.

Tax Code TX-RE

GST incurred that is not directly attributable to the making of taxable or exempt supplies. This includes operation overhead for a development of mixed property (comprised of residential and commercial properties).

Tax Code IGDS

Under Import GST Deferment Scheme (IGDS), approved GST-registered businesses pay GST on imports payments when their monthly GST returns are due instead of at the point of importation. Businesses under IGDS must file their GST returns on monthly basis.

These tax codes are already setup in your SQL Account, so you can start it straight away. For more information, you may refer to

Install odoo on digitalocean

reference link:

1:sudo nano (create one file named”” )
2:copy script to this file and save it to linux
3:sudo chmod +x (Make the script executable)
4:sudo ./ the script:)

sudo service odoo-server restart
sudo service odoo-server stop
sudo service odoo-server start

1:Download the script:

sudo wget

2:Make the script executable:

sudo chmod +x

3:Execute the script:

sudo ./

ODOO debranding

STEP #1 – change your company logo (let’s start from easy…)
Hover the big Odoo logo on the left side, click on “Edit company data” and give your company your own logo – this will replace the Odoo placeholder logo.

STEP#2 – remove “Powered by Odoo”
Open the view web.login_layout and comment out following lines:

<!-- <span class="oe_footer_seperator"> | </span> -->
<!-- <a href="" target="_blank">Powered by <span>Odoo</span></a> -->

Open the view web.menu_secondary and comment out following line:

<!-- Powered by <a href="" target="_blank"><span>Odoo</span></a> -->

STEP#3 – remove “Odoo support” user for instant messaging
Goto Settings > Local Modules and uninstall module Odoo Live Support (im_odoo_support)

or install Remove bindings

the the app  menu will change to setting/technical/parameters/app


STEP#4 – remove Odoo announcement top bar
Empty the openerp_announcement function inaddons/mail/static/src/js/announcement.js like this:

openerp_announcement = function(instance) {};

install bitnami odoo on AWS


Install pdf

sudo apt-get install libjpeg8 libpng12-0 xfonts-base xfonts-scalable
sudo dpkg -i wkhtmltox-0.12.1_linux-trusty-amd64.deb

Then copy the binaries to a your /usr/bin directory:
sudo cp /usr/local/bin/wkhtmltopdf /usr/bin/
sudo cp /usr/local/bin/wkhtmltoimage /usr/bin/

remove banner

sudo /opt/bitnami/apps/odoo/bnconfig --disable_banner 1
As final step, restart Apache server:
sudo /opt/bitnami/ restart apache

If you experiment issues with resolution, it could be related to xfonts-75dpi or xfonts-100dpi packages. You can uninstall them executing:

sudo dpkg --remove --force-depends xfonts-75dpi
sudo dpkg --remove --force-depends xfonts-100dpi


sudo dpkg -r wkhtmltox
sudo wget
sudo dpkg -i wkhtmltox-0.12.1_linux-trusty-amd64.deb

education theme



odoo salary sum

Some deductions have a yearly limit per employee. Is there away to check these registers within a salary rule to determine if the maximum has been paid?

To elaborate:

In Canada we have two limited deductions, one of which is EI (employment Insurance) which deducts 1.88% of the total payslip up to a maximum of $891.12 within the year after which the deduction stops. In order to achieve this I am looking to add a Python Expression under condition that grabs the total contributions over the year period and if it is less then the $891.12 allow the payroll rule to proceed. My issue I am hitting is that I am unsure how to get the total of one register for the year to date within the condition rule.

Nicholas Linn
Okay found this out for myself under the example above, the following conditional statement will work assuming the rule name is EI:

result = payslip.sum(‘EI’,’2013-01-01′,’ 2013-12-31′) > -891.12

Still would be nice not to have to change the formula every year. Any ideas?

Bit of a hack but you can use the contract start and end date to define the fiscal year:

result = payslip.sum(‘EI’,contract.date_start,contract.date_end) > -891.12