Collection and Cash Flow

Report #	Report Name	Description
CCF-01	Daily Collection Summary Report	Shows total of the receipt received on daily basis from settlement or receipt vouchers
CCF-02	Official Receipt Listing	Shows detail on the receipt created base on the method of payment include deposit or credit sales. Displayed with separate columns on cash, cheques, post dated cheques (PD Cheques) and credit cards, managers will be able to get a firm grasp of the cash flow for the company
CCF-03	Official Receipt By Credit Card	This report is useful when it comes to inspecting your credit card receipts at the end of the day. Normal operating standards would require you to vouch the credit card receipts against this report. This check helps you deter fraud and errors in a way that, if : credit card sales entered in EMP, but no receipt printed from the machine to verify the sales - the cashier did not swipe credit card. the amount entered in EMP different from credit card receipt. payment mode entered in EMP is via credit card, but actually the customer paid by cash and vice versa.
CCF-04	Collection with Invoice Aging	This report shows all the collections within a period of time, and analyze each of the collection by salesman, to compute the corresponding age of the collection based on the invoice dates. This report is may be useful for the company which analyze how fast the salesman collect the payment from their customers.
CCF-05	Daily Receipt Summary By Salesman	This reports shows the total of collection or receipt by salesman and by method pf payment on the selected period
CCF-06	Collection with Invoice Aging with Cost	This reports shows CCF-04 with COST and GP calculation per invoice and per collection
CCF-07	Official Receipt by Coupon	This reports shows the receipt created for Coupon type item
CCF-08	Collection with Invoice Details	This report shows the invoice, invoice item and receipt collected by the selected period. This report is useful to drill down the invoice information base on the receipt created.

CCF-01 Daily Collection Summary Report

Receipts from Invoice Settlement or Receipt Vouchers will appear in this report. Managers can how much users have received on a daily a basis and in what form. Hence, managers can vouch the information on this report to the receipts from each user.

Select Branch
Select Username → compulsory
Select Customer Type → if any
Select Filter Criteria → salesman or user
Select Date Range

Click on printable page 2 → to show column header as row

Click on printable page with signature → without details

Click on printable page with signature 2 → with details

CCF-02 Official Receipt Listing

Sometimes, management would like to take a detailed view on the collections, from cash sales to deposit and payment for credit sales are listed here. With separate columns on cash, cheques, post dated cheques and credit cards, managers will be able to get a firm grasp of the cash flow for the company. Users can drill down to individual Official Receipt, and trace the invoices accordingly through the user friendly interface.

Key in any fuzzy search for the payer's name and click submit → if any
Select Branch → refer to Manager Reports (Permission) under collection and cashflow list for the branch permission
Key in Keyword → if any
Tick Cashbook → if any
Select Date and Time Range
Select User → compulsory
Select Status → by default is normal
Select Order by → transaction or creation date
Click Generate Report Now

Select Batch Print format, Tick box of which RCT and click Batch Print → if want to perform batch printing

CCF-03 Official Receipt by Credit Card

This report is useful when it comes to inspecting your credit card receipts at the end of the day. Normal operating standards would require you to vouch the credit card receipts against this report. This check helps you deter fraud and errors in a way that, if :

credit card sales entered in EMP, but no receipt printed from the machine to verify the sales - the cashier did not swipe credit card.
the amount entered in EMP different from credit card receipt.
payment mode entered in EMP is via credit card, but actually the customer paid by cash and vice versa.

Select Branch and click 'Set Branches'
Select Date Range and choose it base on Create Time or Transaction (txn) Time
Select Salesman from the drop down list
Select User or click Select All → Please take note : deselect all will generate ALL users
Select Credit Card or click Select all → Please take note : deselect all will generate ALL Credit Card
Select Cashbook from the drop down list
Choose Customer Type (if any)
Tick the Display Options if you want to group the transactions
Sample result of "Untick" the Display Options → which show no grouping of transactions

Sample result of "Tick" the Display Options → which there is grouping of transactions based on Cashbook and Payment Type

Notes:

The Cashbook and Payment Type will follow the Credit Card configuration
In this report, the vehicle number also available on "Printable Page with Vehicle" which is very useful if user using Workshop Module. With this printable, user can see the CCF-03 base on Jobsheet Reference Number and Vehicle Number with Branch Code and Credit Card Type

CCF-04 Collection with Invoice Aging

Certain companies reward their salesmen according to how fast they manage to collect from their customers. If the salesman collect faster, they get rewarded better. This report shows all the collections within a period of time, and analyze each of the collection, to compute the corresponding age of the collection based on the invoice dates.

Select Branch → refer to Manager Reports (Permission) under collection and cashflow list for the branch permission
Select Salesman
Select Customer Category → if any
Select Customer Type → if any
Select Date Range
Click Generate Report Now

Click on printable page (Summary) → to show total only

CCF-05 Daily Receipt Summary by Salesman

Select Branch → refer to Manager Reports (Permission) under collection and cashflow list for the branch permission
Select Salesman
Select Customer Category → if any
Select Customer Type → if any
Select Date Range
Click Generate Report Now

CCF-06 Collection with Invoice Aging with Cost

Select Branch
Select Date Range and choose it base on Create Time or Transaction (txn) Time
Select Salesman → default is all
Select Option of cost → tick to show base on latest item and delta cost

Click on printable page (Summary) → to show total only

CCF-07 Official Receipt by Coupon

Select Branch → refer to Manager Reports (Permission) under collection and cashflow list for the branch permission
Key In Keyword → if any
Select Date Range → base on creation or transation date
select User → default is all

Click on Printable Page→ to print current columns
Click Export Excel xls File → to export current columns to excel file
Click Export CSV → to export current columns to CSV file

CCF-08 Collection with Invoice Details

Select Branch → refer to Manager Reports (Permission) under collection and cashflow list for the branch permission
Select Date Range
Key in Item Code Fuzzy Search and tick "allow seach for description" or leave if blank to view all item codes
Key in Item Code Range → if any or leave it blank to view all
Select Item Category → if any or leave it untick
Select Item Status → by default is active
Select Item Type → deselect will generate All Type
Select Salesman