When managing your business, you need a report that provides insights into sales performance across branches, profit value, cost of goods sold (COGS), and other key metrics. Rewaa's Sales by Location Report enables you to access these details for a single branch or multiple branches, helping you identify high-performing locations and make data-driven decisions.
Accessing the Report
Go to: Reports > Sales > Sales by Location.
Click on the report to view its details.
The report details are displayed. You can search by location name, or filter and sort the results.
Report Overview
The report consists of two sections. The first section provides a summary of the report.
The second section displays all the details.
ℹ️ The data is shown based on the selected time period or applied filters.
Report Details
You can view the following information:
Location | Branch name. |
Sales | Total completed location sales (Tax Exclusive), after deducting returns and discounts |
Cost Of Goods Sold | Total cost of the sold products minus the total cost of returned items. |
Gross Margin | Location sales {Tax Exclusive} minus the cost of goods sold |
Sales Tax | The amount of sales tax collected for products that are subject to tax at all rates. |
Sales (Tax Inclusive) | The sum of completed location sales (Tax Inclusive), while deducting the returns and discounts |
Quantity Sold | The total number of items sold at the branch before deducting returns. Example: Sold 3 items, returned 2 items — Quantity Sold will show as 3. |
Quantity Returned | Total number of items returned at the branch. ℹ️ Returned quantities may exceed sold quantities if you allow returns from any branch within your business. |
ℹ️ The table contains multiple columns and data. Use the scroll bar at the bottom of the table to view all columns.
Exporting the Report
To export the full report details, click on "Export" and choose (xlsx). An Excel file will be downloaded to your device, and you can view it once the download is complete.
To export only the report summary, select (Summary xlsx). An Excel file will be downloaded to your device, and you can view it once the download is complete.
FAQs
How can I compare the sales of two locations?
Click the Filter field > select the location you want > click Apply.
How can I identify the branch with the highest sales?
Click the field below the search bar, then select Highest Sales First.
Can I customize user access to this report?
Yes, follow these steps:
Yes. Go to Settings > Users > ⚙️> Edit User.
Under User Permissions, navigate to Reports > Report List > Enable Read.
Navigate to Sales Reports > Sales by Location > Enable the appropriate permissions for the user.
Click Save Custom User to apply the changes.