Download Excel

Sales are issued invoices. Purchases are expenses in {{ \App\Services\Accounting\GstReportService::PURCHASE_CATEGORY }}. Taxable and GST values are in INR. Sales invoice totals show the original invoice currency. CESS and Kerala Flood Cess are left blank. Download Excel for the two-sheet file.

Sales taxable
{{ money($report['sales_taxable']) }}
Sales total
{{ money($report['sales_total']) }}
Purchases taxable
{{ money($report['purchase_taxable']) }}
Purchases total
{{ money($report['purchase_total']) }}
Sales — {{ $report['label'] }}
@forelse ($report['sales'] as $index => $row) @empty @endforelse
Sl No Date of Invoice Invoice Number Customer Name Customer GST Number Price GST % IGST CGST SGST CESS Total Invoice Amount
{{ $index + 1 }} {{ $row->invoice_date?->format('d/m/Y') }} {{ $row->invoice_number }} {{ $row->client?->company_name ?? '—' }} {{ $row->client?->gst_number ?: '—' }} {{ $row->formattedOriginalAmount('subtotal') }} {{ number_format((float) $row->tax_rate_gst, 2) }} {{ $row->formattedOriginalAmount('tax_amount_igst') }} {{ $row->formattedOriginalAmount('tax_amount_cgst') }} {{ $row->formattedOriginalAmount('tax_amount_sgst') }} — {{ $row->formattedOriginalAmount() }}
No issued invoices in {{ $report['label'] }}.
Purchases — {{ $report['label'] }}
@forelse ($report['purchases'] as $index => $row) @php $taxable = (float) $row->amount - (float) $row->tax_amount; $gstRate = (float) $row->tax_rate_igst + (float) $row->tax_rate_cgst + (float) $row->tax_rate_sgst; if ($gstRate <= 0 && $taxable > 0) { $gstRate = round(((float) $row->tax_amount / $taxable) * 100, 2); } @endphp @empty @endforelse
Sl No Date of Purchase Invoice Number Supplier Name Supplier GST Number Price GST % Kerala Flood Cess IGST CGST SGST Total Invoice Amount
{{ $index + 1 }} {{ $row->transaction_date?->format('d/m/Y') }} {{ $row->reference_no ?: '—' }} {{ $row->vendor_name ?: '—' }} {{ $row->vendor_gst_number ?: '—' }} {{ money($taxable) }} {{ number_format($gstRate, 2) }} — {{ money($row->tax_amount_igst) }} {{ money($row->tax_amount_cgst) }} {{ money($row->tax_amount_sgst) }} {{ money($row->amount) }}
No Office Purchases & Hardware bills in {{ $report['label'] }}.