POS Collection Detail Report
Lists every POS payment with its receipt, cashier, customer and payment details (method, account, check, gift check, bank).
Menu: Reports › POS Reports › POS Collection Detail Report
What it's for
Use it to trace individual payments, for example all checks received at the POS, all gift checks redeemed, or the payments of one customer.
The accountant filters Payment Method Check for last week to list the checks to deposit, with Check No., Check Date and bank.
Filters
Click Filters to narrow the report. You can filter by:
Branch, Trans. Date, Terminal No., OR Number, Transaction Number, Cashier, Customer Type, Customer, Walk-in Customer, Salesman, Is Member, Member, Remarks, Senior Number, Senior Name, PWD Number, PWD Name, Solo Parent Number, Solo Parent Name, PNST Number, PNST Name, POS Promo Name, EWT Name, Is Non Vat, Is Wholesale, Voided, Void Date/Time, Payment Method, Account Number, Account Name, Check Date, Check No., POS Collection Remarks, Customer Address, Customer TIN, Bank Name.
Columns
| Column | What it shows |
|---|---|
| Created For | The branch the transaction is for (whose stock or money it affects). |
| For Location | The branch location whose stock the transaction affects. |
| Transaction Date | The transaction's date. |
| Terminal No. | The POS terminal number. |
| OR Number | The official receipt number. |
| Transaction Number | The POS's own transaction number. |
| Cashier | The cashier who rang up the sale. |
| Customer Type | Walk-in or regular customer. |
| Customer | The customer. |
| Customer Address | The customer's address. |
| Customer TIN | The customer's tax identification number. |
| Total Amount | Total sales or transaction amount. |
| Remarks | The transaction's remarks. |
| Salesman | The salesman on the transaction. |
| Member | The POS member (loyalty card holder). |
| Senior Number | ID number of the senior citizen who got the discount. |
| Senior Name | Name of the senior citizen who got the discount. |
| PWD Number | ID number of the person with disability who got the discount. |
| PWD Name | Name of the person with disability who got the discount. |
| Solo Parent Number | ID number of the solo parent who got the discount. |
| Solo Parent Name | Name of the solo parent who got the discount. |
| PNST Number | ID number of the national athlete or coach who got the discount. |
| PNST Name | Name of the national athlete or coach who got the discount. |
| POS Promo Name | The POS promotion applied. |
| EWT Name | Expanded withholding tax applied. |
| Is Non Vat | Whether the sale was VAT-exempt. |
| Is Wholesale | Whether wholesale prices were used. |
| Voided | Whether the POS transaction was voided. |
| Void Date/Time | When the POS transaction was voided. |
| Payment Method | How the amount was paid. |
| Account Number | Account number of the payment (check or bank). |
| Account Name | Account name. |
| Check No. | Check number. |
| Check Date | Check date. |
| Gift Check | Gift check used. |
Also shows: POS Collection Remarks, Collected Amount, Other Info, Bank Name.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.