Friday, 28 December 2018

Calculating GST for expense using party.

There are various scenarios in indian gst on different type of transactions.
Let us see how we can calculate gst on vendor that are actual not vendors in my system (i.e. Parties). The use of party was used for calculating TDS on vendors which are not vendors in my system, where we need not maintain ledgers for them. We just use them for calculating TDS. The functionality of party has not been extended for calculating gst also.
Nav 2016 CU Update 30 contains new functionality by which we can do GST transaction on general Journal. It gives us functionality by which we can book direct Invoice against Vendors also ,were there is an option by which we can do GST Transaction against Party for which No Vendor cards need to be created in the System.
Mandatory Fields need to be updated before transaction.
  • State Code on Parties
  • GST Party Type on Parties
  • GST Vendor Type on Parties
  • GST Registration Type on Parties and Location Code.
  • GST Registration No. on Parties.
New Bitmap Image
In the above scenario we can see that we had selected Party Type and Party Code for booking bill for G/L Account.
  • Fields which need to be filled up in General Journal for GST Transaction.
FieldsData value
Posting DateDate of posting
Document TypeDocument type will be Invoice
Document No.Document No.
External Document No.Vendor Invoice No.
Party TypeParty Type if we are booking bill against Party
Party CodeParty Code
Account TypeVendor
Account No.Vendor Acc No.
DescriptionDescription
Gen. Posting TypePurchase
AmountTransaction Amount
Total GST AmountSystem Calculated GST Value
Bal. Account Type
Bal. Account No.Bal. Account No.
Location CodeLocation Code
GST Group TypeGST Group Type i.e Goods/Services
GST Group CodeGST Group Code
GST Vendor TypeGST Vendor Type i.e Registered or Unreg
GST Base AmountGST Base Amount
HSN/SAC CodeHSN/SAC Code
GST CreditAvailment or Unavailment
ExemptedExempted or not
After that we have to click on Calculate GST Function on Home tab of General Journal as shown in Image below to Calculate GST for the Transaction.
New Bitmap Image
Now that we have calculate GST we shall now post and check the transactions.
G/L Impact of the Transaction.
Posting DateDocument TypeG/L Account NameDescriptionGen. Posting TypeAmount
23-01-2020InvoiceLeaseLeasePurchase1,000.00
23-01-2020InvoiceIGST Rcvble AccLease180
23-01-2020InvoiceGiro AccountLease-1,180.00
Detailed GST Ledger Impact of the transaction.
Transaction TypeDocument TypePosting DateTypeNo.Source TypeSource No.GST Component CodeGST %GST Jurisdiction TypeGST Base AmountGST Amount
PurchaseInvoice23-01-2020G/L Account1401PartyLANDLORDIGST18Interstate1,000.00180

External Document No.Location State CodeBuyer/Seller State CodeLocation  Reg. No.Buyer/Seller Reg. No.GST Group TypeGST CreditGST Vendor TypeCredit Availed
INVLFS0011MAHND19LOCAT1100REGI09COMPA0007INFOServiceAvailmentRegisteredYes
That’s it.

No comments:

Post a Comment