Printed by: {{auth()->user()->name}}
Printed Date: 2024-11-21 11:39:50 AM
Printed Date: 2024-11-21 11:39:50 AM
{{$app->app_name}},
Sales and Profit Summary
OUTLETS: ALL OUTLETS
Sales and Profit Summary
OUTLETS: ALL OUTLETS
Report Date
{{request()->date == null ? $dayClose->day_close : request()->date}}
| OUTLETS | Sales Excl. Tax {{empty($app->currency) ? "GHS" : $app->currency}} |
NHIL Levy ({{ $mTaxes->nhil * 100}}%) {{empty($app->currency) ? "GHS" : $app->currency}} |
Covid Levy ({{ $mTaxes->covid * 100}}%) {{empty($app->currency) ? "GHS" : $app->currency}} |
Getfund Levy ({{$mTaxes->getfund * 100}}%) {{empty($app->currency) ? "GHS" : $app->currency}} |
Tourism Levy ({{$mTaxes->tourism * 100}}%) {{empty($app->currency) ? "GHS" : $app->currency}} |
VAT ({{$mTaxes->vat*100}}%) {{empty($app->currency) ? "GHS" : $app->currency}} |
Total Tax {{empty($app->currency) ? "GHS" : $app->currency}} |
Sales Inc. Tax {{empty($app->currency) ? "GHS" : $app->currency}} |
Total Cost of Sales {{empty($app->currency) ? "GHS" : $app->currency}} |
Gross Profit W/O Tax {{empty($app->currency) ? "GHS" : $app->currency}} |
|---|---|---|---|---|---|---|---|---|---|---|
| {{$report->branch}} | @convert( $vat_exclusive = ($report->total)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat)) ) | @convert( $NHIL_ = ($report->total)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->nhil) | @convert( $COVID_ = ($report->total)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->covid) | @convert( $GETFUND_ = ($report->total)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->getfund) | @convert( $TOURISM_ = ($report->total)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->tourism) | @convert( $VAT_ = ($vat_exclusive+$NHIL_+$COVID_+ $GETFUND_+$TOURISM_) * $mTax->vat) | @convert($total_tax = $VAT_+$NHIL_+$COVID_+ $GETFUND_+$TOURISM_) | @convert($total_tax + $vat_exclusive) | @convert( $cos = \DB::table('cost_of_sale_analyses')->where('category', '!=', "TRANSPORT") ->where('branch', $report->branch) ->WhereDate('date','>=', $from) ->WhereDate('date','<=', $to) ->sum('cost') ) | @convert($vat_exclusive-$cos) |
| Grand Total | @convert( $vat_exclusive = ($total_sale)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat)) ) | @convert( $NHIL_ = ($total_sale)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->nhil) | @convert( $COVID_ = ($total_sale)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->covid) | @convert( $GETFUND_ = ($total_sale)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->getfund) | @convert( $TOURISM_ = ($total_sale)/(1+ ($gTax) + ($mTax->vat) + ($gTax*$mTax->vat))*$mTax->tourism) | @convert( $VAT_ = ($vat_exclusive+$NHIL_+$COVID_+ $GETFUND_+$TOURISM_) * $mTax->vat) | @convert($total_tax = $VAT_+$NHIL_+$COVID_+ $GETFUND_+$TOURISM_) | @convert($total_tax + $vat_exclusive) | @convert( $cos_final = \DB::table('cost_of_sale_analyses')->where('category', '!=', "TRANSPORT") ->WhereDate('date','>=', $from) ->WhereDate('date','<=', $to) ->sum('cost') ) | @convert($vat_exclusive - $cos_final) |