Skip to main content

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

Required permission
Reports › POS Collection Detail Report › View

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.

Example

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​

ColumnWhat it shows
Created ForThe branch the transaction is for (whose stock or money it affects).
For LocationThe branch location whose stock the transaction affects.
Transaction DateThe transaction's date.
Terminal No.The POS terminal number.
OR NumberThe official receipt number.
Transaction NumberThe POS's own transaction number.
CashierThe cashier who rang up the sale.
Customer TypeWalk-in or regular customer.
CustomerThe customer.
Customer AddressThe customer's address.
Customer TINThe customer's tax identification number.
Total AmountTotal sales or transaction amount.
RemarksThe transaction's remarks.
SalesmanThe salesman on the transaction.
MemberThe POS member (loyalty card holder).
Senior NumberID number of the senior citizen who got the discount.
Senior NameName of the senior citizen who got the discount.
PWD NumberID number of the person with disability who got the discount.
PWD NameName of the person with disability who got the discount.
Solo Parent NumberID number of the solo parent who got the discount.
Solo Parent NameName of the solo parent who got the discount.
PNST NumberID number of the national athlete or coach who got the discount.
PNST NameName of the national athlete or coach who got the discount.
POS Promo NameThe POS promotion applied.
EWT NameExpanded withholding tax applied.
Is Non VatWhether the sale was VAT-exempt.
Is WholesaleWhether wholesale prices were used.
VoidedWhether the POS transaction was voided.
Void Date/TimeWhen the POS transaction was voided.
Payment MethodHow the amount was paid.
Account NumberAccount number of the payment (check or bank).
Account NameAccount name.
Check No.Check number.
Check DateCheck date.
Gift CheckGift 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.

TEST SITE