Reports

Review Returned Sales, Products and Refund Evidence

Return Reports explain which completed sales were reversed, which products and quantities came back, how much value was returned and which customer, cashier, branch and payment method belong to the event.

Menu path: Reports -> Sales -> Return Sale
Verified from: Posnic demo and current POS source reviewed on 2026-09-08

Technical source evidence

Live local Posnic Return Reports audited and captured 2026-09-10 using a controlled local return fixture, frontend/modules/returnReport.html Return Details Return Based Product sidebar and return modal, frontend/static/script/js/modules/js/report_return.js filters pagination drill-downs and CSV projections, frontend/static/script/js/core/PosnicPro.js Return Details headings and shared report export registration, api/src/controllers/sales.controller.js report permissions branch parameters and session date filtering, api/src/repositories/sale.repository.js returnSalesReportPage returnProductReportPage productBasedReportPage and returnProductViewPage

Current Posnic Return Details report showing returned sale id date customer payment method item count and return amount — **Review returned sales**Return Details shows one row per qualifying returned sale. Select the Sales Id to inspect the returned product lines and customer context.

Current Posnic return sale sidebar showing branch user customer details and returned product history — **Inspect a returned sale**The sale drill-down ties the return to its branch, cashier, customer and returned product lines.

Current Posnic Return Based Product report showing return id date product supplier quantity and total amount — **Review returned products**Return Based Product separates return lines by return document, item and supplier, with quantity and value totals.

Current Posnic Return Details modal showing customer payment method returned item price quantity discount tax subtotal and total — **Open the return document**Select a Return Id to review customer, payment method, item pricing, quantity, discount, tax and calculated return total.

Before Running the Report

Complete returns from the original saved sale so Posnic retains the sale, customer, payment and item relationship.
Use the correct return quantity and refund method. The report describes saved return data; it does not repair a wrong refund.
A sale appears only when its process is PartialReturn or FullReturn.
Confirm the current branch and your report permission before investigating missing rows.
Use Sales History, Payment Reports, Inventory Logs and Register Reports as supporting evidence rather than treating one report as the whole audit.

Run Return Details

The date filter uses the sale record's updated date. A return completed today can therefore appear in today's Return Report even when the original sale was created earlier.

Open Reports -> Sales -> Return Sale.
Open the filter control.
Choose the return activity date range.
Select one or more branches, then Apply.
Keep Return Details selected.
Choose 5, 10, 25, 50 or 100 rows per page as needed.
Review every page and use Refresh after a newly completed return.
Select a Sales Id to open its customer and Product history detail.

Read Return Details Columns

Column	Meaning	Check
Sales Id	The original saved sale number; opens the returned-product sidebar.	Match the customer's receipt and Sales History.
Date	The returned sale record's last updated date in the report range.	Do not assume it is the original sale date.
Customer Name	Customer saved on the original sale, including Walk-in Customer.	Verify identity before discussing account or refund details.
Payment Method	Payment label stored on the sale record.	Compare with the actual refund route and Payment Reports.
No. Of Item	Count of returned item-value records after the report expands the saved return arrays.	It is a returned-line count, not the sum of returned units.
Return Amount	Saved cumulative items-return total for the sale.	Compare with the return document, refund evidence and remaining sale value.

Inspect a Returned Sale

The contact area prefers phone; when phone is empty it shows email, otherwise it shows address.
Product history groups matching returned item ids for the selected sale and sums quantity and total amount.
The sidebar is evidence for the sale-level return; it is not a second return action and does not change stock or payment.

Select the Sales Id in Return Details.
Verify the Branch and User at the top of the sidebar.
Confirm the customer name and the one available contact field shown by the sidebar.
Review each Product history row for item name, returned quantity and amount.
Page through the product history when more than five distinct returned items exist.
Close the sidebar and compare the original bill in Sales History.

Use Return Based Product

Return Based Product answers which physical products came back, from which return document and with what quantity and value.

Rows are grouped by return id, item and supplier, so the same product can appear on several return documents.
Rows are sorted by return date descending and then return value descending.
A blank Supplier means the returned line did not retain supplier context; do not invent one in reconciliation.

Keep the required date range and branch selection.
Select Return Based Product.
Review Return Id, Date, Product Name, Supplier, Qty and Total Amount.
Use Qty for returned units; unlike No. Of Item in Return Details, this value is summed quantity.
Select a Return Id to open the return document modal.
Compare the returned item with Inventory Logs and the physical stock received back.

Read the Return Document

For tax-inclusive items, the modal derives a pre-tax display price before applying its calculation.
Discount and Tax summary rows appear only when their calculated value is above zero.
The Return Id modal is constrained to the active branch. If a multi-branch report row belongs to another branch and the modal is empty, switch to that branch and reopen it.

Area	Shows	Use it for
Customer Details	Customer name, address, phone and email retained with the return.	Confirming whose transaction was reversed.
Return number and date	Return Id and saved return timestamp.	Matching refund, stock and customer evidence.
Payment Method	Payment method stored on the returned item record.	Checking how the refund should be reconciled.
Item Details	Name, pre-tax price, quantity, discount, tax and total.	Explaining the return calculation line by line.
Totals	Subtotal, optional discount, optional tax and total amount.	Comparing the document with the reported Return Amount.

Export Return CSV Files

The small share/export icon on each tab exports all matching rows, not only the visible page.
Set date and branch filters before exporting and verify the downloaded row count.
Keep both exports when an investigation needs sale-level customer/payment context and item-level quantity/supplier context.
The shared top PDF, CSV, Excel and Email toolbar is registered against the Return Details report surface; verify the resulting file before relying on it for the product tab.
Return report views and their export controls are restricted on the Free plan.

Export	Current CSV fields	Important omission
Return Details	SalesId, Date, CustomerName, PaymentMethod, NoofItem, ReturnAmount	No item names, quantities by product, cashier, branch or refund note.
Return Based Product	ReturnId, Date, ItemName, SupplierName, NoofReturn, ReturnTotal	No customer, cashier, payment method, tax or discount.

Reconcile a Return

Match Sales Id and Return Id to the original Sales History record.
Confirm PartialReturn when sellable lines remain or FullReturn when the entire sale was returned.
Compare returned quantities and values in both report tabs.
Check the refund method against Payment Reports, provider evidence and register activity.
Confirm stock-tracked units returned to inventory through Inventory Logs and a physical count.
Review tax, discount and customer-credit effects where applicable.
Record and escalate any mismatch before day close; do not create a second return to force totals to agree.

Troubleshooting

Problem	What to check	Action
No Records	Return activity date, selected branches and whether the sale is PartialReturn or FullReturn.	Correct the filters and refresh; do not widen dates without documenting the actual return period.
Return completed but absent	The report uses updated_date and current licence context.	Open the original sale, verify saved return status, then rerun the date containing the return update.
Item count differs from quantity	Return Details counts expanded return lines; Return Based Product sums units.	Use the product tab for quantity reconciliation.
Return modal is empty	The Return Id may belong to a selected branch that is not the active branch.	Switch to that branch and reopen the same Return Id.
Return Amount differs from modal total	Repeated returns, cumulative sale return total, discount or tax calculation.	Review all return documents under the sale and reconcile each event.
Supplier is blank	The returned item line did not retain supplier information.	Use item and purchase history to investigate; do not overwrite return evidence casually.
Export is disabled or blurred	No matching rows or Free-plan restriction.	Verify filters and plan access; retain on-screen evidence if export is unavailable.

Manager Sign-Off

The return is tied to the correct original sale, customer, branch and cashier.
Returned line count and returned unit quantity are not confused.
Refund method and amount match payment evidence.
Stock movement matches the returned physical units.
PartialReturn or FullReturn status matches the remaining sale.
Required CSV files, return document and investigation notes are retained.