How to get information by using formula
This query is : Resolved
09 August 2010
Let me present here a summarized worksheet
Supp Name Item Des Value VAT rate Vat amt
Asha Entp 775 4 31
Asha Entp 3415 12.5 426.88
Let me present here a summarized worksheet
Supp Name Item Des Value VAT rate Vat amt
Asha Entp 775 4 31
Asha Entp 3415 12.5 426.88
09 August 2010
LET TAKES
COLUMN A : SUPPLIER NAME
COLUMN B : ITEM DESCRIPTION
COLUMN C : VALUE OF PARTICULAR ITEM COLUMN D : VAT RATE ( FEED RATE MANUALLY)
COLUMN E : VAT VALUE ( IN THIS ROW/COLUMN
= C2*D2/100
ASSUMING ROW 1 IS USED FOR DESCIRIPTION OF COLUMN HEADING AND DATA IS FEEDING IN ROW 2.
COLUMN A : SUPPLIER NAME
COLUMN B : ITEM DESCRIPTION
COLUMN C : VALUE OF PARTICULAR ITEM COLUMN D : VAT RATE ( FEED RATE MANUALLY)
COLUMN E : VAT VALUE ( IN THIS ROW/COLUMN
= C2*D2/100
ASSUMING ROW 1 IS USED FOR DESCIRIPTION OF COLUMN HEADING AND DATA IS FEEDING IN ROW 2.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Sale of property furniture sale
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Tds on building rent monthly
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
