Detail Collection Report

Lists every Collection with its payments line by line: customer, the sales it pays, and each payment's method, bank, check or card details and surcharge.

Menu: Reports › Transaction Detail Reports › Detail Collection Report

Required permission

Reports › Detail Collection Report › View

What it's for

Use it when the transaction list isn't enough: to filter and export lines by product, brand, category, customer, supplier or status, for example for reconciliation, audits or analysis in Excel. Filter by any header field or product with Filters and Filter By Product. See Collection for the transaction itself.

Example

The accountant lists all collections by check with Check No. and Deposit/Check Date to prepare the bank deposit.

Filters

Click Filters to narrow the report. You can filter by:

Branch, Branch Area, Trans. Date, Sheet No., Collection Remarks, Approval Status, Customer Type, Customer, Walk-in Customer, Customer Branch, Created by, Created Date, Last Modified By, Last Modified Date, Audit By, Audit Date, References, Payment Method, Bank, Check No., Deposit/Check Date, Card No., Merchant No., Batch No., Approval No., Other Reference 1, Other Reference 2, Other Reference 3, Collection Detail Remarks.

Columns

Column	What it shows
Created From	The branch where the transaction was created.
Created For	The branch the transaction is for (whose stock or money it affects).
Transaction Date and Time	The transaction's date and time.
Sheet No.	The transaction's sheet number; click it to open the transaction.
References	The sales the collection pays.
Approval Status	Draft, For Approval, Approved or Declined.
Customer Type	Walk-in or regular customer.
Customer	The customer.
Collection Remarks	Remarks on the collection.
Total Amount	Total sales or transaction amount.
Adjustment Amount	Amount added or taken off the whole transaction.
Net Total Amount	Total amount after the transaction's discounts.
Collected Amount	Amount collected.
Created by	User who created the transaction.
Created Date	When the transaction was created.
Audit By	User who approved (audited) the transaction.
Audit Date	When the transaction was approved.
Modified by	User who last changed the transaction.
Last Modified	When the transaction was last changed.
Payment Method	How the amount was paid.
Payment Surcharge	Surcharge added for the payment method.
Bank	The bank of the check or transfer.
Check No.	Check number.
Deposit/Check Date	Deposit or check date.
Amount	Line amount: quantity × price.
Actual Amount	Amount applied to the sales.
Charge Amount	Surcharge amount.
Charge Based On	How the surcharge is computed.
Customer Name	Name on the card or payment.
Card No.	Card number.
Merchant No.	Card terminal merchant number.
Batch No.	Card settlement batch number.
Approval No.	Card approval code.
Collection Detail Remarks	Remarks on the payment line.

Also shows: Other Reference 1, Other Reference 2, Other Reference 3.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.