Skip to main content
DD-TAX-001-Q030 Very Hard

Apportioning the overhead VAT

The company makes taxable supplies (S15 and ZR) and exempt supplies (EX), so overhead input VAT must be apportioned. Take the 2025 Purchase invoice VATAmount of the overhead categories "RNT", "UTL" and "MKT", and recover only the fraction equal to (taxable Sales invoice NetAmount / total Sales invoice NetAmount) for 2025. How much of that overhead input VAT is recoverable, in SAR?
Expected
One amount in SAR, 2 decimals · KPI card
Tables
FactVATTransactions, DimCategory, DimTaxCode · columns
  • FactVATTransactions
  • DimCategory
  • DimTaxCode
  • VATAmount
  • NetAmount
  • TaxCode
  • CategoryCode
  • DocType
  • PeriodKey

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us