Spreadsheet: 704195d1605428306-nested-if-function-example
Sheet: Sheet1

Sales tax credits
S NOS | [NAME] | ANNEX | GROSS VALUE | TAXABLE VALUE | SALES TAX
1 | Domestic Purchases from Registered Persons (excluding fixed assets) |  | 707200
 | Domestic Purchases from Un-registered Persons
 | Imports excluding fixed assets (includes value addition tax on commercial imports) |  | 513519
 | Capital Goods / Fixed Assets (Domestic Purchases & Imports)
 | Input for the month = (1 + 3 + 4)
 | Credit brought forward from previous tax period |  |  |  | 1356909
6a | Inadmissible input tax in terms of section 8(1)(m) for failure to provide NIC / NTN of unregistered buyer
 | Non creditable inputs (relating to exempt, non-taxed supplies of goods or services etc.) |  |  |  | 178942
7a | Inadmissible input tax credit in terms of section 8(1)(l) read with section 7(2)(i) of the Sales Tax Act, 1990 and disallowance of reduction in output tax in respect of withholding of sales tax/Credit Notes.
7b | Allowance of input tax credit and reduction of output tax out of previous return column 7c
7c | Balance of earlier disallowed input tax credit and disallowed reduction of output tax through column of 7(a).
 | Accumulated Credit = [5 + 6 + 7b - (6a + 7 + 7a)]
Sales tax debits
 | Total Goods or Services supplied locally (Including Reduced Rate Sales) |  | 9503639
 | Goods or services supplied locally (at Reduced Rates)
 | Exports
 | Bricks Suppliers With 3 Regional Categories RS 12500, 10000, 7500 Per Month
 | Gas supplied to CNG sector on fixed/notified Value
14a | Sales Tax portion of Sr. 14 collected at normal rate (adjustable against input)
14b | Remaining Sales Tax portion of Sr. 14 (non-adjustable against input) = (14 - 14a)
 | Output Tax = (9 + 14a + 19 + 20)
 | Sales Tax deducted by withholding agent(s)
 | Accumulated Debit = (15 - 16)
 | Sales Tax u/s 3(9) on electricity supplied to [NAME] (non Adjustable)
 | Adjustment in respect of Steel Sector.
 | Adjustment in respect of Ship breaking units
 | Purchase of ginned cotton covered under SRO 1087(I)/2019
 | Sales Tax withheld as withholding agent
 | Sales Tax Arrears including Principal, Default Surcharge & Penalty |  |  |  | 21473
23a | Further Tax charged on supplies made to Un-Registered Person
23b | Extra Tax collected under SRO 509(I)/2013 on sale of Electricity & Gas
24 | Whether exclude from Section 8B(1), under SRO 647(I)/2007 |  |  |  | no | drop down
 | Admissible Credit [if 24 = Yes then 8; if 24 = No, then {least of (8-4) or "90% of 15" or 17} + {if (8-4) < "90% of 15" then 4; otherwise zero}] |  |  |  |  | formula in this  cell
 | Excess Unadjusted Credit [if 24 = Yes and 25 > 17 then (25 - 17); otherwise zero; if 24 = No then (8 - 25)] |  |  |  | 0 | formula in this  cell
 | Credit Carried forward on account of Value Addition Tax
 | Unadjusted Credit Available for the purpose of refund = (26 - 27)
 | Refund Claimed (Provide Stock Statement as Annex-H now, or file it later as per rules)
 | Credit to be carried forward [if 28 > 29, then [(28 - 29) + 27]; otherwise 27]
 | Federal Excise Duty (FED) Drawback
 | Sales Tax Payable [if 17 > 25 then (17 - 25); otherwise zero] + [12 + 14b + 18 + 19 + 20 + 21 + 22 + 23 + 23a + 23b] |  |  |  | 236196 | formula in this  cell
 | Federal Excise Duty (FED) Payable (Incl. FED @ Rs.1KG on Locally Produced Oil, from Annex-A)
 | [NAME] (PL) Payable
 | Total amount to be paid = (32 + 33 + 34)
 | Tax paid on normal/previous return (applicable in case of revised return)
 | Balance Tax Payable/ (Refundable) (35 - 36)