.jpg){kind=logo}
Know your Back Office Daily Sales Revenue Report
| Objective | This report aims to generate the Daily Sales Revenue Report which consists transaction details including Sales Invoice Number, Transaction Date and Time, Sales, VAT, Discount, Service Type and Channel, Payment Mode, Item and Modifier Sold and Buyer Information. This report only includes sales, no voided transactions. |
|---|---|
| User Access |
Store Admin = can access own sales revenue only Brand = no access Enterprise = can access all locations' sales summary Super Admin = can access all accounts' sales summary |
| Filter Fields and Buttons |
Manager
Store Admin
Brand
Enterprise
Super Admin
|
| Page Buttons | [Download Excel] - xls and xlsx format |
| Date Filter Limit | None |
Values
| View Table Column | Description |
|---|---|
| Location | Location Name |
| Date | POS Date when the transaction was placed |
| OR No | System-generated Sales Invoice Number of the transaction (paid) |
| Bill No | System-generated Bill Number of the transaction (billed) |
| Bill Time | Time when the transaction was billed (realtime) |
| Settle Date | Date when the transaction was paid (device date) |
| Settle Time | Time when the transaction was paid (device time) |
| Manual SI No | Manually encoded Sales Invoice # on the Buyer Information field |
| Terminal ID | Terminal ID of the device where transaction was paid |
| Cashier | Logged in user who processed the transaction payment |
| Discount Amount | Amount of the applied discount - all types of discount |
| VAT Adjustment | The VAT removed from Senior Citizen, PWD and Diplomat transactions |
| Tax Amount | 0 by default |
| VAT | Amount of VAT or Value Added Tax |
| Service Charge Amount | Amount of Service Charge |
| Net Sales | Sales excluding VAT and all deductions such as Discounts and VAT Adjustments |
| Gross Sales | Sales including VAT and all deductions such as Discounts, VAT Adjustments, Service Charge and Other Charges |
| GC Excess | The Return/Change Amount if the Customer paid more than the Amount Due using Gift Certificate or Voucher |
| Order Type | Service Type (Dine in, Take Out, etc.) |
| Service Channel | Service Channel if it's under Delivery Service Type (Grab, Foodpanda, etc.) |
| Payment Type | Payment method used for settlement |
| More Details | (outdated) Entered details on the Add Details field on POS |
| Short Order ID | The Grab or Foodpanda Order ID in order to map with Aggregator Reports |
| Customer TIN | (outdated) Entered TIN on the Buyer Information dialog on POS |
| Customer Name | (outdated) Entered Name on the Buyer Information dialog on POS |
| Customer Address | (outdated) Entered Address on the Buyer Information dialog on POS |
| Customer Business Style | (outdated) Entered Business Style on the Buyer Information dialog on POS |
| Modifiers (Detailed) | Modifier Names sold along with sold items |
| Item Details (Detailed) | Item Name of sold items |
| Payment Mode Breakdown (Detailed) | Payment type used and amount paid per payment type |
Future Enhancements
|
|
Description | Target Deployment Date |
|---|---|---|
| Daily Sales Revenue - Only show the Payment Modes applicable to the client |
Currently, it shows all clients' payment modes |
|
| Daily Sales Revenue - Implement "All Locations" filter to show sales of all locations under the account |
Currently, there's an "All Locations" option but not working |
|
| Daily Sales Revenue - Show Buyer Information | https://mosaic-solutions.atlassian.net/browse/PRD-188 |
|