Read the Rekaz sales report: totals, invoices, refunds and exports
Use the summary for the overall result, the service table to find a difference, and the invoice dialogs to understand it. Keep sales dates, payment dates and refund dates distinct when reconciling the figures.
Reports → Sales → Sales
Sales
Use this tab to understand sales value, discounts, tax and returns for the selected period. A sale can be included before its invoice is fully paid, so Net Sales and Net Paid Amount answer different questions.
Payments
Switch to the payments view when you need to review recorded payments. Check the displayed period after switching and use that view’s own filters and breakdowns.
Collection
Switch to the collection view to inspect collection transactions. Its controls and transaction details are separate from the service rows shown in Sales.
Refresh / Updated at
Refresh after a relevant order, payment or refund changes, then wait for the figures to finish loading. Updated at identifies the report refresh time. It is not the creation date of the invoices in the report.
Total Sales / information icon
This total includes VAT after discounts and returns. Open the information icon to see the relationship: Total Sales = Net Sales + VAT. For example, net sales of 100 and VAT of 15 give total sales of 115. Do not add the discount or refunded amount back unless you are deliberately reconstructing an earlier gross amount.
Net Sales
Read the sales value after discounts and returns, excluding VAT. It can include an invoice that has not been fully paid. Use it to review sales, then use Net Paid Amount to review money recorded as received after refunds.
How is it calculated?
Open the breakdown to follow the displayed amounts from sales before discounts through discounts, tax and refunds to Net Sales. Read the timing note too: a refund in the current period can relate to an order created earlier. The minus signs identify amounts being deducted; they do not mean another refund action will occur.
Read the net-sales calculation and timing note
Export net sales detail
Use the download control beside Net Sales when investigating the components behind that figure. It is a different export from the service table. The control is unavailable when there is no breakdown to export; changing the table search does not create one.
Net Paid Amount
This is recorded payments during the period minus refunds executed during it, including VAT. It can include several payment methods and payments for older orders. It is not a promise of the next bank transfer: transfer timing and fees can make the bank amount different.
Total Discount Amount
Review the discounts included in the report, such as coupons, manual discounts and offers. This amount excludes VAT. These discounts have already reduced Net Sales; subtracting them from Net Sales again would count the same reduction twice.
Refunds excluding VAT
Read the refund value without its VAT component. If a customer receives 115 back, consisting of 100 plus 15 VAT, this figure is 100. Net Paid Amount instead deducts the full 115 returned to the customer.
Tax
Review the VAT recorded on included invoices after returned VAT is deducted. It follows the tax applied to those invoices and is not necessarily proportional to the part of an invoice already paid.
Sales Details: Search
Search the service rows by name or a displayed number such as quantity or amount. This changes the visible table rows and row count, while the summary cards keep representing the report’s date and filter selection. To investigate one service’s totals throughout the report, choose it in Filters → Service instead.
Search sales rows and inspect their invoice details
Clear the table search
Delete the search text to restore the rows allowed by the report filters. If the table remains empty, check the dates and applied filters. Searching an invoice number or customer name belongs in the relevant order or customer view, rather than this service-row search.
Service
Sort rows by the displayed service name. Click again to reverse the order. Names reflect saved business data and need not change language with the interface.
Unit Price
Sort by the unit-price value shown for each service row. Open its invoices when you need to inspect the price on a particular sale; the summary row can combine more than one invoice.
Quantity
Sort by the included item quantity. This is not a count of unique customers. A row can show a payment with zero current-period sales quantity when the payment relates to an older order.
Vat amount
Sort the service rows by their VAT amounts. Keep this column separate from the VAT-excluded refund column when comparing them.
Discount
Sort by the discount shown for each service row. A zero means no discount is shown for that row under the current report selection.
Total Price
Sort by the service row’s total price. Read it alongside refunds and Net Sales rather than assuming it is the amount retained after all refunds. Click the same heading again to reverse the order.
Refunds excluding VAT
Sort by VAT-excluded refunds to find services with returned amounts. The invoice dialog separately labels its refund amount as including VAT, so the two columns can show different numbers for the same refund.
Net Sales
Sort by each service row’s net sales. A fully refunded example can have a positive original Total Price and zero Net Sales; inspect View to understand the invoices behind that row.
Net Paid Amount
Sort by the payment value shown for each service row. Use the invoice drill-down and the earlier-order explanation when the payment amount does not follow the sales quantity for this period.
Show: 10, 25, 50 or 100
Choose how many service rows appear on one page. This changes the table layout, not the dates or summary totals. Selecting a new size returns the table to its first page.
First page
Return directly to the first page of the current service results. The control is disabled when you are already there.
Previous page
Move back one page while retaining the current sort and search.
Next page
Show the next page when more matching rows exist. A disabled next arrow means you are at the last page, not necessarily that the report has no data.
Last page
Jump to the last page of the current results. Check the page indicator before concluding that a service is missing.
Invoices: View (count)
Open the invoices contributing to a service row. The number in parentheses is the number of invoice entries behind that row, not its service quantity. In the dialog, review the selected service name before comparing figures.
Invoice detail columns
Read quantity, unit price, discount, VAT, total, paid amount, refunds including VAT and order status together. For example, a fully returned 115 invoice can show 115 paid and 115 refunded, while its service row shows 100 refunded excluding VAT and zero net sales. Paid Amount and Refunds are separate columns; do not read Paid Amount alone as money still retained.
Inspect invoices behind a service row
Invoice Number link
Use the invoice-number link to open the related order for a fuller investigation. Viewing the link or the report does not itself edit the order or execute a refund.
Scroll across invoice columns
If the dialog is narrower than the table, scroll horizontally to see the remaining refund and status columns. A column outside the current view has not been omitted from the invoice.
Invoice dialog: Show
When the dialog contains more than ten invoice entries, use Show to select 10, 25, 50 or 100 per page. Changing the size returns to page one. Closing and reopening the dialog restores ten per page.
Invoice dialog: first page
Jump to the first invoice page.
Invoice dialog: previous page
Go back one invoice page.
Invoice dialog: next page
Read the next group of invoice entries. Check the page indicator to track your place.
Invoice dialog: last page
Jump to the final invoice page; the arrow is unavailable when you are already there.
Close invoice details
Close the dialog to return to the service table. This leaves the report filters in place.
Payments and refunds for earlier orders
Open this button when it appears to inspect earlier orders with payments or refunds inside the chosen period. For example, a booking order created in August and paid in September belongs in this explanation of September cash activity. The badge counts the listed earlier orders.
Understand payments and refunds for earlier orders
Created / Paid in period / Refunded in period
Compare the old order creation date with the amounts paid or refunded during the selected period. A dash is used where no amount is shown. These rows help explain why current-period cash and sales need not match.
Earlier-order invoice link
Open the invoice number to inspect the related order. Keep the report’s date range in mind when comparing the order’s overall figures with amounts marked in period.
Earlier-order pages and Show
When more than ten entries are listed, use the page arrows and Show selector to read the remaining entries. Closing the dialog resets it to the first page and ten entries per page.
Close earlier-order details
Return to the same sales report without changing its filters or the underlying orders.
Deferred gift coupons
Open this button when shown to review paid gift coupons whose value is awaiting recognition as sales on redemption. This explanation applies to gift coupons; giftable products are explicitly excluded.
Understand paid gift coupons before redemption
Paid amount now / Net sales now / Net sales when redeemed
Read these three figures as different stages. A paid 50 coupon can show +50 received now, 0 in net sales now and +50 in sales when redeemed. Do not add the future sales figure to current sales simply because the cash has already arrived.
Gift coupon invoice number
Use the invoice-number link to inspect the purchase. The Purchased column is the purchase date, while Not in net sales yet shows the amount still deferred.
Gift coupon pages and Show
If more than ten entries appear, use Show and the first, previous, next and last arrows. Changing page size returns to page one; closing restores the initial ten-entry view.
Close gift coupon details
Close the explanation to return to Sales. This does not redeem a coupon or change its value.
Export above the summary
Choose the main report export after checking the date range and Filters. It uses those report selections. The separate Export beside Sales Details and the Net Sales download serve different levels of detail.
Choose the report export format
Main export: Export as Excel
Request a spreadsheet of the main report for the selected filters. After downloading, check the period and contents before using it as a comparison with another report.
Main export: Export as PDF
Use the PDF option for the report’s print view. Review its period and layout before choosing print or save in the browser.
Sales Details: Export
Use this export for the service breakdown. Table search and page size control what you see on screen; do not rely on them to restrict the export. Set the report filters to the intended scope first.
Detail export: Export as Excel
Export the service rows and totals for spreadsheet review. The file includes invoice numbers associated with each row. If the report has no sales data, this command shows a no-data message instead of a detailed file.
Detail export: Export as PDF
Request a printable service breakdown. Check that the chosen dates and report filters match your purpose before exporting; narrowing the table search alone is not sufficient.
FAQ: What does Net Sales mean?
Expand this question for the distinction between sales value and amounts paid. Open another question to switch the explanation, or click the open question again to close it.
FAQ: Net Paid Amount and bank transfers
Read why the report can differ from a bank transfer. The linked Rekaz Pay view is for electronic-payment transfers other than Tabby and Tamara.
FAQ: How is Tax calculated?
Read how invoice VAT and returned VAT affect the displayed tax amount.
FAQ: Refunds excluding VAT
Use the 115 refund example to distinguish a 100 VAT-excluded return from the full amount returned to the customer.
FAQ: Total Discount Amount
Check which discount types the explanation covers and why you should not subtract them from Net Sales again.
