When conducting sales transactions, all invoice amounts are included in the total sales, regardless of whether they are fully paid, partially paid, or unpaid. To track the amounts actually collected from customers and the outstanding balances, you can use the Sales Report by Payment Status. This report categorizes sales by payment status, making it easier to monitor financial dues for each location.
Accessing the Report
Go to: Reports > Sales > Sales by Payment Status.
All report details are displayed. You can search for the site name, or filter and sort the search results.
ℹ️ All results are displayed based on the selected time frame and filters.
Report Details
The report provides the following information:
Payment Status | Paid, Partially Paid, Unpaid. |
Location | The branch where the sale occurred. |
Sales | The sum of completed location sales (Tax Exclusive) while deducting the returns and discounts. |
Cost Of Goods Sold | The total cost of products sold in sales while deducting the total cost of products that got returned. |
Gross Margin | Location sales (Tax Exclusive) are discounted from the total cost of goods sold. |
Sales Tax | The amount of sales tax collected for the products subjected to tax at all rates. |
Sales (Tax Inclusive) | The sum of completed location sales (Tax Inclusive) while deducting the returns and discounts. |
Sold Quantity | The quantity of products sold before deducting returns. For example, if 10 items of a product were sold and 1 item was returned, the quantity sold shows as 10. |
Returned Quantity | The quantity of products that were returned. |
ℹ️ The table contains multiple columns and data. Use the horizontal scrollbar to view all columns.
Exporting the Report
To export the report:
Click on Export, then select (xlsx). An Excel file will be downloaded to your device, and you can view it after the download is complete.
FAQs
Can user access to this report be restricted?
Yes, follow these steps:Go to Settings > Users > ⚙️ > Edit User.
Navigate to User Permissions > Reports > Report List, and enable Read.
Expand Sales Reports and locate Sales by Payment Status.
Enable the appropriate permissions for the user.
Save changes to apply the restrictions.