{{ $business_details->name }}

@if(!empty($location_details))

{{ $location_details->name }}

{{ $location_details->landmark }}, {{ $location_details->city }}, {{ $location_details->state }}

@endif

GP REPORT - DETAILED SUMMARY

@if(!empty($start_date) && !empty($end_date)) Period: {{ @format_date($start_date) }} to {{ @format_date($end_date) }} @else As of: {{ @format_date(\Carbon::now()) }} @endif

Key Performance Indicators
Description Amount
Total Sales {{ @num_format($total_sales) }}
Gross Profit {{ @num_format($gross_profit) }}
Customer Due {{ @num_format($customer_due) }}
Customer Due Collection {{ @num_format($customer_due_collection) }}
Sales Returns {{ @num_format($sales_return) }}
Total Purchases {{ @num_format($purchases) }}
Supplier Due Balance {{ @num_format($supplier_due) }}
Supplier Due Collection {{ @num_format($supplier_due_collection) }}
Purchase Returns {{ @num_format($purchase_returns) }}
Operational Expenses {{ @num_format($expenses) }}
Customer Deposits (Advances) {{ @num_format($customer_deposits) }}
Total Fund Transfers {{ @num_format($total_account_fund_transfers) }}
Cash Flow by Cashier
@forelse($register_totals as $register) @empty @endforelse
Cashier Name Closed Sessions Net Cash Collected
{{ $register->first_name }} {{ $register->last_name }} {{ $register->total_registers }} {{ @num_format($register->total_cash) }}
No register data found
Customer Outstanding Balance (Due)
@php $total_due = 0; @endphp @forelse($customer_due_details as $due) @php $total_due += $due->due_amount; @endphp @empty @endforelse @if($total_due > 0) @endif
Date Customer Name Invoice Due Amount
{{ @format_date($due->transaction_date) }} {{ $due->customer_name }} #{{ $due->invoice_no }} {{ @num_format($due->due_amount) }}
No outstanding balances found
Total Outstanding: {{ @num_format($total_due) }}
@if(count($customer_due_collection_details) > 0)
Customer Due Collection Details
@php $total_cust_collection = 0; @endphp @foreach($customer_due_collection_details as $collection) @php $total_cust_collection += $collection->amount; @endphp @endforeach
Date Paid Customer Name Invoice Ref Payment Ref Amount Collected
{{ @format_date($collection->paid_on) }} {{ $collection->customer_name }} #{{ $collection->invoice_no }} {{ $collection->payment_ref_no }} {{ @num_format($collection->amount) }}
Total Collected: {{ @num_format($total_cust_collection) }}
@endif
Itemized Sales Returns
@forelse($sales_return_details as $return) @foreach($return->sell_lines as $line) @endforeach
Date: {{ @format_date($return->transaction_date) }} | Invoice: #{{ $return->invoice_no }} Return Total: {{ @num_format($return->final_total) }}
Product Qty Price Subtotal
{{ $line->product_name }} @if($line->variation_name != 'DUMMY')
({{ $line->variation_name }}) @endif
{{ @format_quantity($line->quantity) }} {{ @num_format($line->unit_price_inc_tax) }} {{ @num_format($line->quantity * $line->unit_price_inc_tax) }}
@empty

No sales returns recorded

@endforelse
Procurement Log (Purchases)
@php $total_purchase = 0; @endphp @forelse($purchase_details_list as $purchase) @php $total_purchase += $purchase->final_total; @endphp @empty @endforelse
Date Supplier Reference Total Value
{{ @format_date($purchase->transaction_date) }} {{ $purchase->supplier_name }} {{ $purchase->ref_no }} {{ @num_format($purchase->final_total) }}
No purchases recorded
Total Procurement: {{ @num_format($total_purchase) }}
Supplier Outstanding Balance (Due)
@php $total_supplier_due = 0; @endphp @forelse($supplier_due_details as $due) @php $total_supplier_due += $due->due_amount; @endphp @empty @endforelse @if($total_supplier_due > 0) @endif
Date Supplier Name Reference Due Amount
{{ @format_date($due->transaction_date) }} {{ $due->supplier_name }} #{{ $due->ref_no }} {{ @num_format($due->due_amount) }}
No outstanding balances found
Total Outstanding: {{ @num_format($total_supplier_due) }}
@if(count($supplier_due_collection_details) > 0)
Supplier Due Collection Details
@php $total_sup_collection = 0; @endphp @foreach($supplier_due_collection_details as $collection) @php $total_sup_collection += $collection->amount; @endphp @endforeach
Date Paid Supplier Name Purchase Ref Payment Ref Amount Paid
{{ @format_date($collection->paid_on) }} {{ $collection->supplier_name }} #{{ $collection->ref_no }} {{ $collection->payment_ref_no }} {{ @num_format($collection->amount) }}
Total Paid: {{ @num_format($total_sup_collection) }}
@endif
Operational Expenditures (Expenses)
@php $total_expense = 0; @endphp @forelse($expense_details as $expense) @php $total_expense += $expense->final_total; @endphp @empty @endforelse
Date Category Reference Notes Amount
{{ @format_date($expense->transaction_date) }} {{ $expense->category_name }} {{ $expense->ref_no }} {{ $expense->additional_notes }} {{ @num_format($expense->final_total) }}
No expenses recorded
Total Expenses: {{ @num_format($total_expense) }}
Customer Advance Deposits
@php $total_deposit = 0; @endphp @forelse($customer_deposit_details as $deposit) @php $total_deposit += $deposit->amount; @endphp @empty @endforelse
Date Customer Payment Ref. Deposit Amount
{{ @format_date($deposit->paid_on) }} {{ $deposit->customer_name }} {{ $deposit->payment_ref_no }} {{ @num_format($deposit->amount) }}
No advance deposits found
Total Deposits: {{ @num_format($total_deposit) }}
@if(count($account_deposit_details) > 0)
Payment Account Deposits
@php $total_acc_deposit = 0; @endphp @foreach($account_deposit_details as $acc_deposit) @php $total_acc_deposit += $acc_deposit->amount; @endphp @endforeach
Date Account Note Amount
{{ @format_date($acc_deposit->operation_date) }} {{ $acc_deposit->account_name }} {{ $acc_deposit->note }} {{ @num_format($acc_deposit->amount) }}
Total Account Deposits: {{ @num_format($total_acc_deposit) }}
@endif @if(count($account_fund_transfer_details) > 0)
Payment Account Fund Transfers
@php $total_acc_transfer = 0; @endphp @foreach($account_fund_transfer_details as $acc_transfer) @php $total_acc_transfer += $acc_transfer->amount; @endphp @endforeach
Date Account Note Amount transferred
{{ @format_date($acc_transfer->operation_date) }} {{ $acc_transfer->account_name }} {{ $acc_transfer->note }} {{ @num_format($acc_transfer->amount) }}
Total Fund Transfers: {{ @num_format($total_acc_transfer) }}
@endif @if(count($commission_agent_details) > 0)
Sales Commission Agent Details
@php $total_agent_sales = 0; @endphp @foreach($commission_agent_details as $agent) @php $total_agent_sales += $agent->total_sales; @endphp @endforeach
Agent Name Total Sales Generated
{{ $agent->agent_name }} {{ @num_format($agent->total_sales) }}
Total: {{ @num_format($total_agent_sales) }}
@endif