TCS calculation on sales and receipt transactions

TCS can be collected on goods (Items) and services (G/L Account) transactions. TCS calculations can be done through following documents:

  • Sales Order
  • Sales Invoice
  • Sales Return Order
  • Sales Credit Memo
  • General Journal
  • Sales Journal
  • Cash Receipt Voucher
  • Bank Receipt Voucher

The examples use illustrative rates, concessional rates, and exchange rates. They aren't guidance on current tax law. The calculated amounts depend on your tax rate and rounding setup.

TCS calculation on general journal, sales journal, cash receipt journal, sales invoice, sales order, sales return order, sales credit memo

  • Create general journal, sales journal, cash receipt journal, or bank receipt journal

    1. Select Search (Alt+Q) in the upper-right corner Enter General Journal, Sales Journal, Cash Receipt Voucher, or Bank Receipt Voucher, and then choose the related link.
    2. Select Customer in Account Type and select relevant customer code in Account No. field.
    3. Select G/L Account or Bank Account in Bal. Account Type, and select the balancing account in Bal. Account No. For a receipt, use the relevant cash or bank account.
    4. Select relevant TCS Nature of Collection in journal line. Location Code and T.C.A.N No. fields shouldn't be blank.
  • Create sales invoice or sales order

    1. Select Search (Alt+Q) in the upper-right corner Enter Sales Invoice, Sales Order, Sales Return Order, or Sales Credit Memo, and then choose the related link.
    2. Select Customer, Location Code on Sales Order, Sales Invoice, Sales Return Order or Sales Credit Memo header.
    3. Select G/L Account or Item Code on Sales Order, Sales Invoice, Sales Return Order or Sales Credit Memo line.
    4. TCS Nature of Collection, Location Code, and T.C.A.N No. fields shouldn't be blank.

TCS to be calculated on customer invoice (through general journal, sales journal, sales invoice, or sales order)

For example, invoice has been issued to customer for INR 10,000 on which 1% TCS is applicable for Nature of Collection 'Scrap'.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount10000
    TCS Amount100 (10000*1%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account10100
    TCS Payable Account-100
    Sales Account-10000

TCS to be calculated on customer advance payment (through general journal, cash receipt journal)

For example, advance payment received from customer for INR 10,000 on which 1% TCS is applicable for Nature of collection 'Scrap'

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount10000
    TCS Amount99 (10000 × 1 / 101, rounded)
  • GL Entries are as following:

    ParticularsAmount
    Bank Account10000
    TCS Payable Account-99
    Customer Account-9901

Adjustment of calculated TCS on advance payment against sales invoice

TCS, which has been calculated on advance payment can be adjusted while creating Sales Invoice against that advance payment. TCS isn't calculated on Customer Invoices if advance payment on which TCS has already been calculated, is applied to the invoice. System should check the TCS base amount on which TCS has been calculated on advance payment with the line amount of Sales Invoice and TCS will only be calculated on the line amount, which is more than the TCS base amount. For example: If TCS base amount was 10,000.00 in advance payment and line amount is 20,000.00 on sales invoice, then TCS is calculated on 10,000.00 on sales invoice.

  • GL Entries for TCS on Customer advance payment using Cash Receipt Journal are as following:

    ParticularsAmount
    Bank Account10000
    TCS Payable Account-99
    Customer Account-9901
  • GL Entries for TCS on Customer Invoice using Sales Invoice against advance payment are as following:

    ParticularsAmount
    Customer Account20101
    TCS Payable Account-101
    Sales Account-20000

Note

TCS is calculated after adjusting the TCS amount, which was earlier calculated on advance payment.

TCS to be calculated on nonresident customer invoice in foreign currency

For example, invoice has been raised to foreign customer for USD 10,000 on which 1% TCS is applicable for Nature of collection 'Scrap'. All foreign currency amounts get converted into INR based on currency exchange rates. Exchange rate considered for this example is 1 USD = 65 INR.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base AmountUSD 10000 or INR 650000
    TCS AmountINR 6500(650000x1%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account656500
    TCS Payable Account-6500
    Sales Account-650000

TCS calculation on higher rate if customer isn't having PAN

For example, invoice has been raised to customer for INR 50,000 on which 1% TCS is applicable for Nature of collection 'Scrap'. But if there's no PAN available for customer then higher TCS of 5% is applicable.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount50000
    TCS Amount2500(50000x5%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account52500
    TCS Payable Account-2500
    Sales Account-50000

TCS calculation on multiple nature of goods in single invoice

For example, invoice has been raised to customer for INR 1,00,000. INR 50,000 each towards two nature of goods 'Scrap' and 'Timber'.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount100000
    TCS Amount on Scrap500(50000x1%)
    TCS Amount on Timber2500(50000x5%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account103000
    TCS Payable Account - Scrap-500
    TCS Payable Account - Timber-2500
    Sales Account - Scrap-50000
    Sales Account - Timber-50000

TCS on sale of scrap at a lower rate

For example, invoice has been raised to customer for INR 1,00,000 towards sale of Scrap. Customer has a certificate of income tax at Lower rate @ 0.5% on Scrap instead of normal rate.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount100000
    TCS Amount500(100000x0.5%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account100500
    TCS Payable Account-500
    Sales Account-100000

TCS on sale of scrap at a zero rate

For example, invoice has been raised to customer for INR 1,00,000 towards sale of Scrap. Customer has a certificate of income tax at Zero rate @ 0% on Scrap instead of normal rate.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount100000
    TCS Amount0(100000x0%)
  • GL Entries are as following:

    ParticularsAmount
    Customer Account100000
    Sales Account-100000

TCS to be calculated on sales return (sales return order or sales credit memo)

For example, sales return from customer for INR 10,000 on which 1% TCS is applicable for Nature of collection “Scrap”.

  • In this case TCS calculation is as following:

    ComponentValue
    TCS Base Amount10000
    TCS Amount100(10000x1%)
  • GL Entries are as following:

    ParticularsAmount
    Sales Account10000
    TCS Payable Account100
    Customer Account-10100

Note

If Credit Memo is created before remittance of Tax to government, then TCS entries are reversed proportionately, on the basis of the quantity returned. In case TCS amount has been remitted to Income Tax department, TCS Payable account isn't reversed.

TCS Threshold

Find free e-learning modules for Business Central here