Modules‎ > ‎Manager‎ > ‎

Daily Sales Report


 Report Name
 Step By Step Guide
 Description / Usage / Benefits
Daily Sales Report With Cash Flow Analysis
1. Select 'All Branches' or a Branch.
2. Set the date range for the report.
3. Choose whether you want to view:
  • Company name
  • Contact person and company name
 



This report shows all sales transactions being done, and the collection associated with the sales (both credit sales and cash sales). Other collections like deposits and collection for previous sales are also included in this report. Users will find this report extremely informative to capture the entire performance of the business for a period of time. With detailed payment modes summarized in different columns, one will be able to know exactly the cash flow in relation to sales.
  • A very detailed report to display cash, credit card, cheque, post dated cheque, voucher and other collection based on a date range specified.
  • Cash collection for current sales, deposits collected and collection for previous invoices are clearly separated
  • Sales Return with hyperlinks showing corresponding invoices enable easy cross referencing
  • An excellent report to look at the cash flow, sales, sales return and various daily transaction in a bird's eye view.

Daily Invoice Summary
1. Select 'All Branches' or a Branch.
2. Choose a user who issued the invoices.
3. Enter date range From and To Date.
From this report, managers will be able to check on users who invoice on a daily basis. This report enable managers to keep track of amount invoices issued and how much has been paid. For example:
  • Number of invoices for the day.
  • Minimum amount invoiced.
  • Maximum amount invoiced.
  • Average amount is automatically calculated.
  • Total invoice amount.
  • How much from the total amount invoiced for the day is still outstanding (not paid).
 Daily Receipt Summary
1. Select 'All Branches' or a Branch.
2. Choose a user of who received the cash / cheque / credit card payment.
3. Enter date range From and To Date.
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. Example:
  • Cash
  • Cheque
  • Cheque Charges
  • Post-Dated Cheque
  • Credit Card
  • Credit Card charges
  • Card Surcharge
  • Other / Contra (deduct from cashbook)
  • Open balance / Deposit
  • Total Collection
 Daily Sales Report With Inventory Category Grouping1. Select 'All Branches' or a Branch.
2. Enter date range From and To Date.
3. Tick on Salesman and select a Salesman name (if you want to view report based on his / her Sales).
4. Select Inventory Category Grouping - Level 1 to 5 (all items under this category will appear).
Sales Report of Quantity and Amount based on each product type in the chosen Category Grouping. This report can also be filtered by Salesman and at the same time, calculate Salesman Commission ,manually (if applicable). Example given:
  • Sales Amount - Sales Discount = Sales Standard Price
  • Sales Amount - Return Amount = Net Sales
  • Quantity and Amount for each Brand (Category Grouping) sold on that day.
 Stock Sales Report
1. 'Select  All' branches or 1 Branch(es).
2. Enter date range.
3. Tick the checkbox and select a salesman name (only if you want the report based on his stock sales).
4. If you have the item code, enter a specific one or a range or leave it blank to view all the items codes.
5. Select Item Category and tick the checkbox.
6. Sort by : Time or Item Code - means in the report, how the items comes in sequence.
This report displays the In and Out of inventory quantities due to Sales or Sales Return. the balance quantity can be obtained here as at specific dates. The other information provided are :
  • Unit price = How much it is invoiced (sales price) or for Sales Return (how much is refunded or CM to customers).
  • Unit Cost (Average) = Cost / Quantity
  • Amount = Quantity x Unit price
  • Cost = Quantity x Unit Cost (Average)
  • Gross Margin = Amount - Cost
  • Margin (%) = Gross Margin / Amount x 100%
     
 Stock Sales Report By Item Code
1. Set Date range.
2. Location - All or 1 stock location.
3. Select Item Category Filters and tick the box.
4. Group by - Will appear in Blue and Black fonts (2 Groups).
5. Order by - Item Name (Check box).
Stock Sales by Item Code is quite similar to Stock Sales Report, except that it's less detailed and is grouped by Group 1-5. It shows :
  • Balance = Stock quantity left in inventory.
  • Quantity sold = Deduction from inventory. (Negative amount) is actually a Sales Return.
  • Amount = Quantity sold x Unit price.
  • COGS = Cost of the stock sold x Quantity
  • GP = Amount - COGS
 Sales Report By Salesman
1. Set Branch or All Branches.
2. Salesman Name.
3. Enter Date Range - To and From.
This report is useful for calculating Salesman's Commission. By looking at the Net Sales, you can find out how much the Salesman sold and multiply with the Commission %. However, this method can only be used if factors such as, Collection Period and Type of Items Sold are not taken into account.
  • Respective Salesman names.
  • Net Sales = Sales - Returns + CM
 Sales Report By Customer Code
1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Customer Code Range - Customer Code can be obtained from Customer Listing. Or leave it blank to view all Customer Codes.
In this report, Customer Code means the Property 1-5 in Create Customer Account. Basically, this report categorizes customers based on the Geographical Area entered when creating the Customer Account. It summarizes the Sales, Sales Return and CM into one lump sum for each area.
 Sales Summary By Customer (Summary)
1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Click 'Generate Report Now'.
Almost similar to Sales Report by Customer Code, except that it lists down ALL the customers individually. This report is useful for checking how regular the customer is to your business. The higher the Net Sales, the more loyal the customer is. Apart from the value of sales and sales return, this report also shows the Count - number of invoices and sales.
  • Invoice - Sales Return = Net Sales
 Sales Report By Daily, Weekly or Monthly1. Set Branch or All Branches.
2. Fuzzy Search (Optional)
3. Item Code (O)
4. Item Category (Level 1-5) (O)
5. Status (Default - Active).
6. Salesman.
7. Customer Name (O)
8. By - Select how you want to view the report - Day / Month.
9. Date.
One Advantage of this report is that, it allows users to do comparison between 2 or more months. You can check the Sales for each Item Code and compare with other days / months. According to this report, you can also see which item sells better, and take in more stock on that item code. Whichever sells poorly as compared to previous months, you can either keep less stock (stock order level) or instruct the salesman to push for that item code.
  Sales Report By Invoice With Inventory Category Grouping1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Salesman - Select a name and tick the check box.
4. Inventory Category Grouping.
A more detailed report is incorporated here for further analysis. When it comes to calculate salesman's commision, this report is quite useful. For each Category Grouping, the sales amount, quantity and discounts given for every invoice is displayed here. To view the Invoices, just click on the Invoice PKID to see the items sold separately.
 Sales Report by Salesman, Customer, Category1. Set Branch or All Branches.
2. Salesman - Select a name
3. Enter Date Range - To and From.
4. Group By - Choose 1 or 2 groups by Level.
Sales amount for each level will be shown for each salesman. Select salesman 'Nobody' to view for all salesman. Here, the customer names also appear individually.
  • Sales (Level 1) + Sales (Level 2) - Credit Note = Total Amount

 Sales Report by Salesman, Customer, Category (Summary) An exact duplicate of Sales Report by Salesman, Customer, Category, except that the customers' names are not shown in this report.
 Detailed Sales Item, CRV and Finance Charges Report1. Select a Branch or All Branches.
2. Invoice Date - To and From.
3. Select by Item Code or Inventory Category.
4. Sort By - Item Code / Invoice Date.
The cost of sales for each invoice item is not limited to the inventory cost (cost of goods sold). There are several other costs incurred, for example, if Cash Rebate Vouchers were given to customers based on each item, or if the customers pay using Easy Payment Scheme (IPP) where finance charges could be amounting to between 5% to 9%, which is pretty significant. While giving out sales commissions to the salesman, sometimes it makes sense to deduct these direct charges, and only pay out commissions based on gross profit calculated after deducting these finance charges etc.







ċ
Unknown user,
Aug 16, 2009, 8:47 PM
ċ
Unknown user,
Aug 16, 2009, 8:48 PM
ċ
Unknown user,
Aug 16, 2009, 8:48 PM
ċ
Unknown user,
Aug 16, 2009, 8:47 PM
ċ
Unknown user,
Aug 16, 2009, 8:51 PM
ċ
Unknown user,
Sep 13, 2009, 11:08 PM
ċ
Unknown user,
Sep 13, 2009, 11:08 PM
ċ
Unknown user,
Sep 13, 2009, 11:14 PM
ċ
Unknown user,
Aug 16, 2009, 11:05 PM
ċ
Unknown user,
Aug 16, 2009, 11:08 PM
ċ
Unknown user,
Sep 13, 2009, 11:08 PM
ċ
Unknown user,
Aug 16, 2009, 10:54 PM
ċ
Unknown user,
Aug 16, 2009, 8:49 PM
ċ
Unknown user,
Sep 13, 2009, 10:19 PM
Comments