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
| Cashier Name |
Closed Sessions |
Net Cash Collected |
@forelse($register_totals as $register)
| {{ $register->first_name }} {{ $register->last_name }} |
{{ $register->total_registers }} |
{{ @num_format($register->total_cash) }} |
@empty
| No register data found |
@endforelse
Customer Outstanding Balance (Due)
| Date |
Customer Name |
Invoice |
Due Amount |
@php $total_due = 0; @endphp
@forelse($customer_due_details as $due)
| {{ @format_date($due->transaction_date) }} |
{{ $due->customer_name }} |
#{{ $due->invoice_no }} |
{{ @num_format($due->due_amount) }} |
@php $total_due += $due->due_amount; @endphp
@empty
| No outstanding balances found |
@endforelse
@if($total_due > 0)
| Total Outstanding: |
{{ @num_format($total_due) }} |
@endif
@if(count($customer_due_collection_details) > 0)
Customer Due Collection Details
| Date Paid |
Customer Name |
Invoice Ref |
Payment Ref |
Amount Collected |
@php $total_cust_collection = 0; @endphp
@foreach($customer_due_collection_details as $collection)
| {{ @format_date($collection->paid_on) }} |
{{ $collection->customer_name }} |
#{{ $collection->invoice_no }} |
{{ $collection->payment_ref_no }} |
{{ @num_format($collection->amount) }} |
@php $total_cust_collection += $collection->amount; @endphp
@endforeach
| Total Collected: |
{{ @num_format($total_cust_collection) }} |
@endif
Itemized Sales Returns
@forelse($sales_return_details as $return)
| Date: {{ @format_date($return->transaction_date) }} | Invoice: #{{ $return->invoice_no }} |
Return Total: {{ @num_format($return->final_total) }} |
| Product |
Qty |
Price |
Subtotal |
@foreach($return->sell_lines as $line)
{{ $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) }} |
@endforeach
@empty
No sales returns recorded
@endforelse
Procurement Log (Purchases)
| Date |
Supplier |
Reference |
Total Value |
@php $total_purchase = 0; @endphp
@forelse($purchase_details_list as $purchase)
| {{ @format_date($purchase->transaction_date) }} |
{{ $purchase->supplier_name }} |
{{ $purchase->ref_no }} |
{{ @num_format($purchase->final_total) }} |
@php $total_purchase += $purchase->final_total; @endphp
@empty
| No purchases recorded |
@endforelse
| Total Procurement: |
{{ @num_format($total_purchase) }} |
Supplier Outstanding Balance (Due)
| Date |
Supplier Name |
Reference |
Due Amount |
@php $total_supplier_due = 0; @endphp
@forelse($supplier_due_details as $due)
| {{ @format_date($due->transaction_date) }} |
{{ $due->supplier_name }} |
#{{ $due->ref_no }} |
{{ @num_format($due->due_amount) }} |
@php $total_supplier_due += $due->due_amount; @endphp
@empty
| No outstanding balances found |
@endforelse
@if($total_supplier_due > 0)
| Total Outstanding: |
{{ @num_format($total_supplier_due) }} |
@endif
@if(count($supplier_due_collection_details) > 0)
Supplier Due Collection Details
| Date Paid |
Supplier Name |
Purchase Ref |
Payment Ref |
Amount Paid |
@php $total_sup_collection = 0; @endphp
@foreach($supplier_due_collection_details as $collection)
| {{ @format_date($collection->paid_on) }} |
{{ $collection->supplier_name }} |
#{{ $collection->ref_no }} |
{{ $collection->payment_ref_no }} |
{{ @num_format($collection->amount) }} |
@php $total_sup_collection += $collection->amount; @endphp
@endforeach
| Total Paid: |
{{ @num_format($total_sup_collection) }} |
@endif
Operational Expenditures (Expenses)
| Date |
Category |
Reference |
Notes |
Amount |
@php $total_expense = 0; @endphp
@forelse($expense_details as $expense)
| {{ @format_date($expense->transaction_date) }} |
{{ $expense->category_name }} |
{{ $expense->ref_no }} |
{{ $expense->additional_notes }} |
{{ @num_format($expense->final_total) }} |
@php $total_expense += $expense->final_total; @endphp
@empty
| No expenses recorded |
@endforelse
| Total Expenses: |
{{ @num_format($total_expense) }} |
Customer Advance Deposits
| Date |
Customer |
Payment Ref. |
Deposit Amount |
@php $total_deposit = 0; @endphp
@forelse($customer_deposit_details as $deposit)
| {{ @format_date($deposit->paid_on) }} |
{{ $deposit->customer_name }} |
{{ $deposit->payment_ref_no }} |
{{ @num_format($deposit->amount) }} |
@php $total_deposit += $deposit->amount; @endphp
@empty
| No advance deposits found |
@endforelse
| Total Deposits: |
{{ @num_format($total_deposit) }} |
@if(count($account_deposit_details) > 0)
Payment Account Deposits
| Date |
Account |
Note |
Amount |
@php $total_acc_deposit = 0; @endphp
@foreach($account_deposit_details as $acc_deposit)
| {{ @format_date($acc_deposit->operation_date) }} |
{{ $acc_deposit->account_name }} |
{{ $acc_deposit->note }} |
{{ @num_format($acc_deposit->amount) }} |
@php $total_acc_deposit += $acc_deposit->amount; @endphp
@endforeach
| Total Account Deposits: |
{{ @num_format($total_acc_deposit) }} |
@endif
@if(count($account_fund_transfer_details) > 0)
Payment Account Fund Transfers
| Date |
Account |
Note |
Amount transferred |
@php $total_acc_transfer = 0; @endphp
@foreach($account_fund_transfer_details as $acc_transfer)
| {{ @format_date($acc_transfer->operation_date) }} |
{{ $acc_transfer->account_name }} |
{{ $acc_transfer->note }} |
{{ @num_format($acc_transfer->amount) }} |
@php $total_acc_transfer += $acc_transfer->amount; @endphp
@endforeach
| Total Fund Transfers: |
{{ @num_format($total_acc_transfer) }} |
@endif
@if(count($commission_agent_details) > 0)
Sales Commission Agent Details
| Agent Name |
Total Sales Generated |
@php $total_agent_sales = 0; @endphp
@foreach($commission_agent_details as $agent)
| {{ $agent->agent_name }} |
{{ @num_format($agent->total_sales) }} |
@php $total_agent_sales += $agent->total_sales; @endphp
@endforeach
| Total: |
{{ @num_format($total_agent_sales) }} |
@endif