The Sales By Invoice Report helps you review detailed amounts and taxes for each invoice. Through this report, you can distinguish invoices subject to tobacco tax (100%) from those subject to VAT (15%), in addition to accurately reviewing profit, loss, and returns.
Accessing the Report
Go to Reports > Sales > Sales By Invoice.
Click on the report to view details.
Search in the Report
Enter the sales invoice number or return invoice number in the search field.
Filter Search Results
Click Filter.
You can filter results by:
Time period
Invoice number
Location
Click Apply.
Sort Data
Click on the View By field.
Choose the appropriate sorting option to display the report data.
Report Sections
Summary: Shows a summary of sales from all invoices.
Details: Displays each invoice based on the selected period or applied filters.
Report Data
Invoice Number | All sales and return invoices from Rewaa Cashier and online stores. |
Location | The branch where the sale was made. |
Sales | Total completed sales excluding tax, minus discounts. |
Cost of Goods Sold (COGS) | The total cost of the products sold. |
Gross Margin | Sales (excluding tax) minus the cost of goods sold. |
15% Tax | Total VAT collected on products subject to the 15% rate. |
100% Tax | Total VAT collected on products subject to the 100% tobacco rate. |
Other Taxes | Total VAT collected on products subject to other tax rates. |
Sales Tax | Total tax collected on taxable products across all applicable rates. |
Sales (Tax Inclusive) | Total completed sales including tax, minus discounts. |
Sold Quantity | Number of products sold, without deducting returns. |
Returned Quantity | Number of products that were returned. |
ℹ️ The table contains multiple columns. Use the horizontal scroll bar below the table to view all columns.
Export the Report
Click Export:
To export detailed report data: select xlsx.
To export the summary report: select summary xlsx.
The file will be downloaded to your device.
FAQs
1. How can I identify invoices that include products subject to tobacco tax?
By checking the 100% Tax column in this report.
2. How can I identify invoices with negative profits?
Check the Profit Value column. If the profit is negative, it will be displayed with a minus sign.
3. How can I know which products were sold in an invoice?
Copy the invoice number from the report, then go to Sales & Customers > Sales Invoices.
Search by invoice number, then click on the invoice to view details.
4. How can I check the tax amount for a specific invoice?
Search for the invoice number in the report, and tax details will appear in the dedicated tax columns.
5. Can I see which invoices included discounts?
No, this report does not show discounts. To view them, go to Sales & Customers > Sales Invoices, open the invoice details, or export invoices to Excel and check the Discount column.
6. Why don’t all report details appear on the screen?
Use the horizontal scroll bar below the table to see all data, or click Export to view full details in an Excel file.