GST Purchase Report - {{ $business->name ?? config('app.name') }}

GST Compliance Report
As per Indian Tax Laws

@if(isset($business->address))

{{ $business->address ?? '' }} @if(isset($business->city)) {{ $business->city ?? '' }} @endif @if(isset($business->state)) {{ $business->state ?? '' }} @endif @if(isset($business->zip_code)) - {{ $business->zip_code ?? '' }} @endif

@endif @if(isset($business->tax_number_1))

GSTIN: {{ $business->tax_number_1 ?? 'Not Available' }}

@endif

GST Purchase Report

Period: {{ $summary['date_range'] ?? 'All Dates' }}

Generated on {{ date('F j, Y \a\t g:i A') }} | Report ID: GPR-{{ date('YmdHis') }}

@if(isset($filters) && !empty(array_filter($filters)))

Applied Filters

@if(!empty($filters['supplier_name'])) @endif @if(!empty($filters['location_name'])) @endif @if(!empty($filters['category_name'])) @endif @if(!empty($filters['tax_rate_name'])) @endif

@endif

Total Transactions

Total Suppliers

Taxable Amount

₹{{ number_format($summary['total_taxable_amount'] ?? 0, 2) }}

Total Tax

₹{{ number_format($summary['total_tax_amount'] ?? 0, 2) }}

@if(isset($purchaseData) && count($purchaseData) > 0) @php $totalTaxableAmount = 0; $totalTaxAmount = 0; $totalAmount = 0; $totalQuantity = 0; @endphp @foreach($purchaseData as $purchase) @php $taxableAmount = $purchase->taxable_amount ?? 0; $taxAmount = ($purchase->item_tax ?? 0) * ($purchase->quantity ?? 0); $lineTotal = $purchase->total_amount ?? 0; $totalTaxableAmount += $taxableAmount; $totalTaxAmount += $taxAmount; $totalAmount += $lineTotal; $totalQuantity += $purchase->quantity ?? 0; @endphp @endforeach

Purchase Ref	Date	Supplier Details	Product	HSN	Qty	Rate	Taxable Value	GST%	Tax Amount	Total Amount	Location
{{ $purchase->ref_no ?? '' }}	{{ $purchase->transaction_date ? \Carbon\Carbon::parse($purchase->transaction_date)->format('d-m-Y') : '' }}	@if($purchase->supplier_business_name) {{ $purchase->supplier_business_name }} @endif {{ $purchase->supplier ?? '' }} @if($purchase->tax_number) {{ $purchase->tax_number }} @endif	{{ $purchase->product_name ?? '' }} @if($purchase->sku) {{ $purchase->sku }} @endif	{{ $purchase->hsn_code ?? '-' }}	{{ number_format($purchase->quantity ?? 0, 2) }} {{ $purchase->unit ?? '' }}	₹{{ number_format($purchase->unit_price ?? 0, 2) }}	₹{{ number_format($taxableAmount, 2) }}	@if($purchase->tax_rate) {{ $purchase->tax_rate }}% @else - @endif	₹{{ number_format($taxAmount, 2) }}	₹{{ number_format($lineTotal, 2) }}	{{ $purchase->location_name ?? '-' }}
TOTAL:					{{ number_format($totalQuantity, 2) }}		₹{{ number_format($totalTaxableAmount, 2) }}		₹{{ number_format($totalTaxAmount, 2) }}	₹{{ number_format($totalAmount, 2) }}

@else

No Purchase Data Available

No purchase transactions found for the selected criteria.

@endif

@if(isset($purchaseData) && count($purchaseData) > 0)

GST Summary for Input Tax Credit

Particulars	Taxable Value (₹)	Tax Amount (₹)	Total Amount (₹)
Total Purchases (Including GST)	{{ number_format($summary['total_taxable_amount'] ?? 0, 2) }}	{{ number_format($summary['total_tax_amount'] ?? 0, 2) }}	{{ number_format($summary['total_amount'] ?? 0, 2) }}
Available for Input Tax Credit	{{ number_format($summary['total_taxable_amount'] ?? 0, 2) }}	{{ number_format($summary['total_tax_amount'] ?? 0, 2) }}	{{ number_format($summary['total_tax_amount'] ?? 0, 2) }}

Important Notes:

This report is generated for GST compliance purposes as per Indian tax regulations.
Input Tax Credit (ITC) is available on eligible purchases as per GST laws.
Please verify GSTIN details of suppliers before claiming ITC.
Retain original tax invoices for audit purposes.
Report generated on {{ date('d-m-Y') }} at {{ date('H:i:s') }}

@endif @if(isset($purchaseData) && count($purchaseData) > 0) @php $taxRateSummary = []; foreach($purchaseData as $purchase) { $rate = $purchase->tax_rate ?? 0; if (!isset($taxRateSummary[$rate])) { $taxRateSummary[$rate] = [ 'taxable_amount' => 0, 'tax_amount' => 0, 'total_amount' => 0, 'count' => 0 ]; } $taxRateSummary[$rate]['taxable_amount'] += $purchase->taxable_amount ?? 0; $taxRateSummary[$rate]['tax_amount'] += ($purchase->item_tax ?? 0) * ($purchase->quantity ?? 0); $taxRateSummary[$rate]['total_amount'] += $purchase->total_amount ?? 0; $taxRateSummary[$rate]['count']++; } ksort($taxRateSummary); @endphp

Tax Rate-wise Summary

@foreach($taxRateSummary as $rate => $summary) @endforeach

GST Rate	No. of Items	Taxable Value (₹)	Tax Amount (₹)	Total Value (₹)
@if($rate > 0) {{ $rate }}% @else Exempt @endif	{{ $summary['count'] }}	{{ number_format($summary['taxable_amount'], 2) }}	{{ number_format($summary['tax_amount'], 2) }}	{{ number_format($summary['total_amount'], 2) }}
TOTAL	{{ array_sum(array_column($taxRateSummary, 'count')) }}	{{ number_format(array_sum(array_column($taxRateSummary, 'taxable_amount')), 2) }}	{{ number_format(array_sum(array_column($taxRateSummary, 'tax_amount')), 2) }}	{{ number_format(array_sum(array_column($taxRateSummary, 'total_amount')), 2) }}

@endif

Authorized Signatory

{{ $business->tax_number_1 ? 'GSTIN: ' . $business->tax_number_1 : '' }}