GST and TDS on Vendor Advance Payments - Business Central (2024)

  • Article

Liability of paying GST and TDS arises at the time of advance payment to vendor.

Mandatory fields in cash or bank payment voucher

  1. Choose the GST and TDS on Vendor Advance Payments - Business Central (1) icon, enter Bank Payment Voucher or Cash Payment Voucher, and then choose the related link.
  2. Select Vendor in Account Type field and select relevant vendor code in Account No. field.
  3. Select G/L Account for cash or Bank Account for bank in Bal. Account Type field, and select relevant cash or bank account in Bal. Account No. field.
  4. Select relevant TDS Section, GST Group Code, HSN/SAC Code, Location Code on journal line.
  5. GST on Advance Payment should be marked true.

For example, service amount is INR 20000 and advance payment made to vendor for INR 10000, 18% GST (i.e. 9% CGST and 9% SGST/UTGST) and 10% TDS has to be charged.

  • GST calculation for Intra-State or Intra-Union Territory transactions will appear in the Fact Box, as following:

    ComponentAmount
    GST Base Amount10,000
    CGST900 (10000*9%)
    SGST900 (10000*9%)
    TDS Amount1000 (10000*10%)
  • On posting of advance payment made to vendor, GL Entries will be as following:

    ParticularsAmount
    Vendor Account10,000
    SGST/UTGST Receivable (Interim) Account900
    CGST Receivable (Interim) Account900
    TDS Payable Account-1000
    SGST/UTGST Payable Account-900
    CGST Payable Account-900
    Bank Account-9000

Important

In some cases GST needs to be calculated on the amount excluding GST, provision has been made to handle such scenario. Business user need to fill the TDS Base Value in Amount Excl. GST filed on Bank Payment Voucher, and system will calculate TDS on the mentioned value.

Later invoice for service purchase issued by vendor for INR 20,000, 18% GST (i.e. 9% CGST and 9% SGST/UTGST) and 10% TDS, will be charged, and the advance payment will be applied with the invoice.

Mandatory fields on purchase invoice

  1. Choose the GST and TDS on Vendor Advance Payments - Business Central (2) icon, enter Purchase Invoice, and then choose the related link.
  2. Select Vendor on Purchase Invoice header.
  3. Select G/L Account for service on Purchase Invoice line.
  4. Select TDS Section on Purchase Invoice line.
  5. GST Group Code, HSN/SAC Code, GST Credit should have a value in G/L Account card.
  6. Location Code field should not be blank on both Purchase Invoice header and line.
  7. Apply the advance payment in Applies to Doc. No. field on Purchase Invoice header.
  • GST calculation will appear in the Fact Box, as following:

    ComponentAmount
    GST Base Amount20000
    CGST900 = [1800 (20000 * 9%)] - [900 (10000 * 9%)]
    SGST900 = [1800 (20000 * 9%)] - [900 (10000 * 9%)]
    TDS Amount1000 = [2000 (20000 * 10%)] - [1000 (10000 *10%)]

GST and TDS will be calculated on the remaining amount, i.e. Invoice Amount - Advance Payment Amount. If advance payment is not applied with the purchase invoice then GST and TDS will be calculated on the whole invoice amount.

  • On posting the purchase invoice, GL Entries will be as following:

    ParticularsAmount
    Vendor Account-19000
    SGST/UTGST Payable (Interim) Account-1800
    CGST Payable (Interim) Account-1800
    SGST/UTGST Receivable (Interim) Account-1800
    CGST Receivable (Interim) Account-1800
    TDS Payable Account-1000
    CGST Payable (Interim) Account900
    CGST Receivable Account900
    SGST/UTGST Payable (Interim) Account900
    SGST/UTGST Receivable Account900
    SGST/UTGST Receivable (Interim) Account1800
    CGST Receivable (Interim) Account1800
    Service Account20000

Tip

Note: In case of Inter-State Purchase, IGST will be calculated.

See Also

GST on Journals

Find free e-learning modules for Business Central here

GST and TDS on Vendor Advance Payments - Business Central (2024)
Top Articles
Latest Posts
Article information

Author: Gov. Deandrea McKenzie

Last Updated:

Views: 6174

Rating: 4.6 / 5 (66 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.